1. 使用SqlDataSource
(1)使用SqlDataReader
1
string
connStr
=
ConfigurationManager.ConnectionStrings[
"
ConnStr
"
].ConnectionString;
2 string selectString = " select id from info " ;
3
4 SqlDataSource source = new SqlDataSource(connStr, selectString);
5 source.DataSourceMode = SqlDataSourceMode.DataReader;
6 SqlDataReader sqlDataReader = (SqlDataReader)source.Select(DataSourceSelectArguments.Empty);
7 while (sqlDataReader.Read())
8 {
9 int id = ( int )sqlDataReader[ 0 ];
10 // 等同于:
11 // int id = (int)sqlDataReader["id"];
12 }
2 string selectString = " select id from info " ;
3
4 SqlDataSource source = new SqlDataSource(connStr, selectString);
5 source.DataSourceMode = SqlDataSourceMode.DataReader;
6 SqlDataReader sqlDataReader = (SqlDataReader)source.Select(DataSourceSelectArguments.Empty);
7 while (sqlDataReader.Read())
8 {
9 int id = ( int )sqlDataReader[ 0 ];
10 // 等同于:
11 // int id = (int)sqlDataReader["id"];
12 }
(2)使用DataView
1
string
connStr
=
ConfigurationManager.ConnectionStrings[
"
ConnStr
"
].ConnectionString;
2 string selectString = " select id from info " ;
3
4 SqlDataSource source = new SqlDataSource(connStr, selectString);
5 source.DataSourceMode = SqlDataSourceMode.DataSet;
6 DataView dv = (DataView)source.Select(DataSourceSelectArguments.Empty);
7 foreach (DataRowView drv in dv)
8 {
9 int id = ( int )drv[ 0 ];
10 // int id = (int)drv["id"];
11 }
2 string selectString = " select id from info " ;
3
4 SqlDataSource source = new SqlDataSource(connStr, selectString);
5 source.DataSourceMode = SqlDataSourceMode.DataSet;
6 DataView dv = (DataView)source.Select(DataSourceSelectArguments.Empty);
7 foreach (DataRowView drv in dv)
8 {
9 int id = ( int )drv[ 0 ];
10 // int id = (int)drv["id"];
11 }
参考:
2.使用SqlConnection和SqlCommand
(1)使用SqlDataReader
1
string
connStr
=
ConfigurationManager.ConnectionStrings[
"
ConnStr
"
].ConnectionString;
2 string selectString = " select id from info " ;
3 using (SqlConnection conn = new SqlConnection(connStr))
4 {
5 SqlCommand cmd = new SqlCommand(selectString, conn);
6 conn.Open();
7 SqlDataReader sqlDataReader = cmd.ExecuteReader();
8 while (sqlDataReader.Read())
9 {
10 int id = ( int )sqlDataReader[ " id " ];
11 // int id = (int)sqlDataReader[0];
12 }
13 sqlDataReader.Close();
14 cmd.Dispose();
15 }
2 string selectString = " select id from info " ;
3 using (SqlConnection conn = new SqlConnection(connStr))
4 {
5 SqlCommand cmd = new SqlCommand(selectString, conn);
6 conn.Open();
7 SqlDataReader sqlDataReader = cmd.ExecuteReader();
8 while (sqlDataReader.Read())
9 {
10 int id = ( int )sqlDataReader[ " id " ];
11 // int id = (int)sqlDataReader[0];
12 }
13 sqlDataReader.Close();
14 cmd.Dispose();
15 }
(2)使用SqlDataAdapter
1
string
connStr
=
ConfigurationManager.ConnectionStrings[
"
ConnStr
"
].ConnectionString;
2 string selectString = " select id from info " ;
3 using (SqlConnection conn = new SqlConnection(connStr))
4 {
5 SqlDataAdapter adapter = new SqlDataAdapter(selectString, conn);
6 DataSet ds = new DataSet();
7 adapter.Fill(ds, " infotable " );
8 foreach (DataRow dr in ds.Tables[ " infotable " ].Rows)
9 {
10 int id = ( int )dr[ " id " ];
11 // int id = (int)dr[0];
12 }
13 }
2 string selectString = " select id from info " ;
3 using (SqlConnection conn = new SqlConnection(connStr))
4 {
5 SqlDataAdapter adapter = new SqlDataAdapter(selectString, conn);
6 DataSet ds = new DataSet();
7 adapter.Fill(ds, " infotable " );
8 foreach (DataRow dr in ds.Tables[ " infotable " ].Rows)
9 {
10 int id = ( int )dr[ " id " ];
11 // int id = (int)dr[0];
12 }
13 }
参考:
谭总《DOT NET程序设计》视频 "ADO.net 2.avi"