软件说明：

using System;<br>using System.Collections.Generic;<br>using System.Text;<br>using System.Data;<br>using System.Data.SqlClient;<br> <br>namespace DatabaseOperate<br>{<br> class SqlOperateInfo<br> {<br> //Suppose your ServerName is "aa",DatabaseName is "bb",UserName is "cc", Password is "dd"<br> private string sqlConnectionCommand = "Data Source=aa;Initial Catalog=bb;User ID=cc;Pwd=dd";<br> //This table contains two columns:KeywordID int not null,KeywordName varchar(100) not null<br> private string dataTableName = "Basic_Keyword_Test";<br> <br> private string storedProcedureName = "Sp_InertToBasic_Keyword_Test";<br> private string sqlSelectCommand = "Select KeywordID, KeywordName From Basic_Keyword_Test";<br> //sqlUpdateCommand could contain "insert" , "delete" , "update" operate<br> private string sqlUpdateCommand = "Delete From Basic_Keyword_Test Where KeywordID = 1";<br> <br> public void UseSqlReader()<br> {<br> SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);<br> SqlCommand sqlCommand = new SqlCommand();<br> sqlCommand.CommandType = System.Data.CommandType.Text;<br> sqlCommand.Connection = sqlConnection;<br> sqlCommand.CommandText = sqlSelectCommand;<br> <br> sqlConnection.Open();<br> SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();<br> while(sqlDataReader.Read())<br> {<br> //Get KeywordID and KeywordName , You can do anything you like. Here I just output them.<br> int keywordid = (int)sqlDataReader[0]; <br> //the same as: int keywordid = (int)sqlDataReader["KeywordID"]<br> string keywordName = (string)sqlDataReader[1]; <br> //the same as: string keywordName = (int)sqlDataReader["KeywordName"]<br> Console.WriteLine("KeywordID = " + keywordid + " , KeywordName = " + keywordName);<br> }<br> <br> sqlDataReader.Close();<br> sqlCommand.Dispose();<br> sqlConnection.Close();<br> }<br> public void UseSqlStoredProcedure()<br> {<br> SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);<br> SqlCommand sqlCommand = new SqlCommand();<br> sqlCommand.CommandType = CommandType.StoredProcedure;<br> sqlCommand.Connection = sqlConnection;<br> sqlCommand.CommandText = storedProcedureName;<br> <br> sqlConnection.Open();<br> sqlCommand.ExecuteNonQuery();<br> //you can use reader here,too.as long as you modify the sp and let it like select * from ....<br> <br> sqlCommand.Dispose();<br> sqlConnection.Close();<br> }<br> public void UseSqlDataSet()<br> {<br> SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand);<br> SqlCommand sqlCommand = new SqlCommand();<br> sqlCommand.CommandType = System.Data.CommandType.Text;<br> sqlCommand.Connection = sqlConnection;<br> sqlCommand.CommandText = sqlSelectCommand;<br> <br> sqlConnection.Open();<br> SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();<br> sqlDataAdapter.SelectCommand = sqlCommand;<br> DataSet dataSet = new DataSet();<br> //sqlCommandBuilder is for update the dataset to database<br> SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);<br> sqlDataAdapter.Fill(dataSet, dataTableName);<br> <br> //Do something to dataset then you can update it to Database.Here I just add a row<br> DataRow row = dataSet.Tables[0].NewRow();<br> row[0] = 10000;<br> row[1] = "new row";<br> dataSet.Tables[0].Rows.Add(row);<br> <br> sqlDataAdapter.Update(dataSet, dataTableName);<br> <br> sqlCommand.Dispose();<br> sqlDataAdapter.Dispose();<br> sqlConnection.Close();<br> }<br> }<br>}<br>