Shulou(Shulou.com)06/01 Report--

Set up a public class SqlConnct, which will be called every time you connect to the database for query operations, passing in the sql query parameters.

Using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;namespace WindowsFormsApplication3 {class SqlConnect {public static DataSet sqlconn (string sql) {SqlConnection conn; conn = new SqlConnection ("server=.;database=schoolDB;uid=sa;pwd=111"); conn.Open (); DataSet ds = new DataSet (); SqlDataAdapter dsa = new SqlDataAdapter (sql, conn) Dsa.Fill (ds); return ds;}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.