三套路-----增删改
Code
1 using System.Data.SqlClient;
2
3 SqlConnection conn = new SqlConnection("xxx");
4
5
6 string sql = "xxx";
7
8 SqlCommand comm = new SqlCommand(sql, conn);
9
10 conn.Open();
11
12 comm.ExecuteNonQuery();
13
14 conn.Close();
三套路-----查(绑定到DataGridView
Code
1 using System.Data.SqlClient;
2
3 SqlConnection conn = new SqlConnection("xxx");
4
5 string sql = "xxx";
6
7 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
8
9 DataSet ds = new DataSet();
10
11 da.Fill(ds);
12
13 dataGridView1.DataSource = ds.Tables[0];
14
15 //要更新 查询语句要 查询主键列
16
17 SqlCommandBuilder sd = new SqlCommandBuilder(da);
18
19 da.Update(ds.Tables[0]);
三套路----查(绑定到ListView)
代码
using System.Data.SqlClient;
SqlConnection conn = new SqlConnection("xxx");
string sql = "xx";
SqlCommand comm = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader read = comm.ExecuteReader();
while (read.Read())
{
ListViewItem lvi = new ListViewItem(read["xxx"].ToString());
lvi.Tag = read["id"];
listView1.Items.Add(lvi);
lvi.SubItems.AddRange(new String[] { read["xxx"].ToString() });
}
read.Close();
conn.Close();
中国足彩网信息请查看IT技术专栏
2025国考·省考课程试听报名