由於最近和數據庫打交道需要用C#和SQL Server 進行操作就把近段時間內的最常用的操作做個總結本人也是第一次用C#操作數據庫所以這三種典型用法對初學者還是挺有幫助的
以下是我在visual studio 上寫的一個類（連的是SQL Server ）已經過測試通過裡面有個方法比較典型源碼如下
using System; using System<fp class='fp-8giw8'></fp>Collections<fp class='fp-6gdte'></fp>Generic; using System<fp class='fp-pckg4'></fp>Text; using System<fp class='fp-pckg4'></fp>Data; using System<fp class='fp-8giw8'></fp>Data<fp class='fp-eys53'></fp>SqlClient; namespace DatabaseOperate { class SqlOperateInfo { //Suppose your ServerName is <fp class='fp-2lsqd'></fp>aa<fp class='fp-2lsqd'></fp><fp class='fp-vqtgu'></fp>DatabaseName is <fp class='fp-ltrgm'></fp>bb<fp class='fp-ltrgm'></fp><fp class='fp-vqtgu'></fp>UserName is <fp class='fp-cb3y9'></fp>cc<fp class='fp-ltrgm'></fp><fp class='fp-itd84'></fp> Password is <fp class='fp-cb3y9'></fp>dd<fp class='fp-ltrgm'></fp> private string sqlConnectionCommand = <fp class='fp-cb3y9'></fp>Data Source=aa;Initial Catalog=bb;User ID=cc;Pwd=dd<fp class='fp-ltrgm'></fp>; //This table contains two columns:KeywordID int not null<fp class='fp-94zye'></fp>KeywordName varchar(<fp class='fp-moya5'></fp><fp class='fp-asf1k'></fp><fp class='fp-vj2oh'></fp>) not null private string dataTableName = <fp class='fp-5wx0e'></fp>Basic_Keyword_Test<fp class='fp-ltrgm'></fp>; private string storedProcedureName = <fp class='fp-ltrgm'></fp>Sp_InertToBasic_Keyword_Test<fp class='fp-5wx0e'></fp>; private string sqlSelectCommand = <fp class='fp-2lsqd'></fp>Select KeywordID<fp class='fp-94zye'></fp> KeywordName From Basic_Keyword_Test<fp class='fp-cb3y9'></fp>; //sqlUpdateCommand could contain <fp class='fp-cb3y9'></fp>insert<fp class='fp-cb3y9'></fp> <fp class='fp-94zye'></fp> <fp class='fp-5wx0e'></fp>delete<fp class='fp-cb3y9'></fp> <fp class='fp-n0nbs'></fp> <fp class='fp-cb3y9'></fp>update<fp class='fp-cb3y9'></fp> operate private string sqlUpdateCommand = <fp class='fp-ltrgm'></fp>Delete From Basic_Keyword_Test Where KeywordID = <fp class='fp-u7dnu'></fp><fp class='fp-ltrgm'></fp>; public void UseSqlReader() { SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand); SqlCommand sqlCommand = new SqlCommand(); sqlCommand<fp class='fp-8giw8'></fp>CommandType = System<fp class='fp-eys53'></fp>Data<fp class='fp-8giw8'></fp>CommandType<fp class='fp-8giw8'></fp>Text; sqlCommand<fp class='fp-pckg4'></fp>Connection = sqlConnection; sqlCommand<fp class='fp-8giw8'></fp>CommandText = sqlSelectCommand; sqlConnection<fp class='fp-6gdte'></fp>Open(); SqlDataReader sqlDataReader = sqlCommand<fp class='fp-pckg4'></fp>ExecuteReader(); while(sqlDataReader<fp class='fp-8giw8'></fp>Read()) { //Get KeywordID and KeywordName <fp class='fp-vqtgu'></fp> You can do anything you like<fp class='fp-pckg4'></fp> Here I just output them<fp class='fp-8giw8'></fp> int keywordid = (int)sqlDataReader[<fp class='fp-1xbn7'></fp>]; //the same as: int keywordid = (int)sqlDataReader[<fp class='fp-cb3y9'></fp>KeywordID<fp class='fp-5wx0e'></fp>] string keywordName = (string)sqlDataReader[<fp class='fp-c4c6w'></fp>]; //the same as: string keywordName = (int)sqlDataReader[<fp class='fp-ltrgm'></fp>KeywordName<fp class='fp-ltrgm'></fp>] Console<fp class='fp-pckg4'></fp>WriteLine(<fp class='fp-5wx0e'></fp>KeywordID = <fp class='fp-cb3y9'></fp> + keywordid + <fp class='fp-cb3y9'></fp> <fp class='fp-n0nbs'></fp> KeywordName = <fp class='fp-2lsqd'></fp> + keywordName); } sqlDataReader<fp class='fp-pckg4'></fp>Close(); sqlCommand<fp class='fp-pckg4'></fp>Dispose(); sqlConnection<fp class='fp-8giw8'></fp>Close(); } public void UseSqlStoredProcedure() { SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand); SqlCommand sqlCommand = new SqlCommand(); sqlCommand<fp class='fp-pckg4'></fp>CommandType = CommandType<fp class='fp-6gdte'></fp>StoredProcedure; sqlCommand<fp class='fp-8giw8'></fp>Connection = sqlConnection; sqlCommand<fp class='fp-pckg4'></fp>CommandText = storedProcedureName; sqlConnection<fp class='fp-6gdte'></fp>Open(); sqlCommand<fp class='fp-6gdte'></fp>ExecuteNonQuery(); //you can use reader here<fp class='fp-n0nbs'></fp>too<fp class='fp-6gdte'></fp>as long as you modify the sp and let it like select * from <fp class='fp-pckg4'></fp><fp class='fp-8giw8'></fp><fp class='fp-6gdte'></fp><fp class='fp-pckg4'></fp> sqlCommand<fp class='fp-pckg4'></fp>Dispose(); sqlConnection<fp class='fp-pckg4'></fp>Close(); } public void UseSqlDataSet() { SqlConnection sqlConnection = new SqlConnection(sqlConnectionCommand); SqlCommand sqlCommand = new SqlCommand(); sqlCommand<fp class='fp-eys53'></fp>CommandType = System<fp class='fp-8giw8'></fp>Data<fp class='fp-pckg4'></fp>CommandType<fp class='fp-6gdte'></fp>Text; sqlCommand<fp class='fp-8giw8'></fp>Connection = sqlConnection; sqlCommand<fp class='fp-8giw8'></fp>CommandText = sqlSelectCommand; sqlConnection<fp class='fp-eys53'></fp>Open(); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(); sqlDataAdapter<fp class='fp-pckg4'></fp>SelectCommand = sqlCommand; DataSet dataSet = new DataSet(); //sqlCommandBuilder is for update the dataset to database SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter); sqlDataAdapter<fp class='fp-8giw8'></fp>Fill(dataSet<fp class='fp-vqtgu'></fp> dataTableName); //Do something to dataset then you can update it to Database<fp class='fp-pckg4'></fp>Here I just add a row DataRow row = dataSet<fp class='fp-8giw8'></fp>Tables[<fp class='fp-asf1k'></fp>]<fp class='fp-6gdte'></fp>NewRow(); row[<fp class='fp-asf1k'></fp>] = <fp class='fp-1qkvu'></fp><fp class='fp-4xpvp'></fp><fp class='fp-1xbn7'></fp><fp class='fp-1xbn7'></fp><fp class='fp-asf1k'></fp>; row[<fp class='fp-c4c6w'></fp>] = <fp class='fp-5wx0e'></fp>new row<fp class='fp-cb3y9'></fp>; dataSet<fp class='fp-8giw8'></fp>Tables[<fp class='fp-1xbn7'></fp>]<fp class='fp-pckg4'></fp>Rows<fp class='fp-pckg4'></fp>Add(row); sqlDataAdapter<fp class='fp-6gdte'></fp>Update(dataSet<fp class='fp-vqtgu'></fp> dataTableName); sqlCommand<fp class='fp-eys53'></fp>Dispose(); sqlDataAdapter<fp class='fp-eys53'></fp>Dispose(); sqlConnection<fp class='fp-pckg4'></fp>Close(); } } }
以上的程序概括了最典型的用法也是最基本的用法更多的用法我將會陸續給出大家有什麼疑問或建議歡迎來信（j）或留言
