第1个回答 2019-02-20
通用的方式有以下几种:
1.
Connection
+
Command
+
DataAdapter
+
DataSet
2.
Connection
+
DataAdapter
+
DataSet
3.
Connection
+
Command
+
DataReader
二、
Connection
+
Command
+
DataAdapter
+
DataSet详解
1.
Connection介绍
Ø
Open()
Ø
Close()
Ø
Dispose()
Ø
ConnectionString
Ø
构造函数()
SqlConnection
conn
=
new
SqlConnection();
conn.ConnectionString
=
"server=KEVIN-LI;database=ADONET;uid=admin;pwd=123456";
conn.Open();
conn.Close();
conn.Dispose();
2.
Command介绍
Ø
Dispose()
Ø
CommandText
Ø
构造函数()
SqlConnection
conn
=
new
SqlConnection();
conn.ConnectionString
=
"server=KEVIN-LI;database=ADONET;uid=admin;pwd=123456";
//打开连接
conn.Open();
//执行命令
SqlCommand
cmd
=
new
SqlCommand();
cmd.Connection
=
conn;
string
sql
=
"select
*
from
销售记录表";
cmd.CommandText
=
sql;
SqlDataReader
dr
=
cmd.ExecuteReader();
if
(dr.Read())
{
dr.Read();
dr.Read();
MessageBox.Show(dr.GetString(1));
}
conn.Close();
conn.Dispose();
3.
DataAdapter介绍
Ø
Dispose()
Ø
Fill()
Ø
构造函数()
4.
DataSet介绍
5.
综合应用
SqlConnection
conn
=
new
SqlConnection();
conn.ConnectionString
=
"server=172.16.32.200;database=ADONET;uid=admin;pwd=123456";
conn.Open();
MessageBox.Show("已经连接到服务器");
SqlCommand
cmd
=
new
SqlCommand();
//建立桥梁关系
cmd.Connection
=
conn;
//设置命令内容
cmd.CommandText
=
"select
*
from
销售记录表";
//创建适配器
SqlDataAdapter
apt
=
new
SqlDataAdapter();
//建立桥梁关系
apt.SelectCommand
=
cmd;
DataSet
ds
=
new
DataSet();
//填充数据
apt.Fill(ds);
//绑定数据
dataGridView1.DataSource
=
ds.Tables[0];
ds.Dispose();
apt.Dispose();
cmd.Dispose();
conn.Dispose();