C通過DataGridView更新數(shù)據(jù)庫

1、ublicpartialclassForm1:FormForm1數(shù)據(jù)成員#regionForm1數(shù)據(jù)成員privateDataTableDT=newDataTable();privateSqlDataAdapterSDA=newSqlDataAdapter();#endregionForm1構(gòu)造函數(shù)#regionForm1構(gòu)造函數(shù)publicForm1()InitializeComponent();#endregion連接數(shù)據(jù)庫顯示數(shù)據(jù)#region連接數(shù)據(jù)庫顯示數(shù)據(jù)privatevoidForm1_Load(objectsender,EventArgse)SqlConnectionconn=

2、newSqlConnection(server=;database=pubs;uid=sa);SqlCommandSCD=newSqlCommand(select*fromtables,conn);SDA.SelectCommand=SCD;SDA.Fill(DT);dataGridView1.DataSource=DT;#endregion使用Update更新數(shù)據(jù)庫#region使用Update更新數(shù)據(jù)庫privatevoidtoolStripButton1_Click(objectsender,EventArgse)trySqlCommandBuilderSCB=newS

3、qlCommandBuilder(SDA);SDA.Update(DT);catch(System.Exceptionex)MessageBox.Show(ex.ToString();return;MessageBox.Show(更新成功!);#endregion1#region關(guān)于數(shù)據(jù)庫操作的函數(shù)集，與業(yè)務(wù)無關(guān)23/4/查詢數(shù)據(jù)庫記錄,返回存放記錄的DataTable5/6/SQL查詢語句7/DataTable數(shù)據(jù)表8publicDataTableDB_Find(stringSql)910SqlConnectiondbConn=newSqlConnection(Param_Class.Par

4、am_DB.strConn);11dbConn.Open();12SqlDataAdapterSda=newSqlDataAdapter(Sql,dbConn);13DataTabledt=newDataTable();14Sda.Fill(dt);15dbConn.Close();16returndt;171819/20/查詢數(shù)據(jù)庫記錄，返回存放記錄的DataTable，并指定其名稱21/22/SQL查詢語句23/指定DataTable的名稱24/以TableName命名的數(shù)據(jù)表25publicDataTableDB_Find(stringSql,stringTableName)2627Sq

5、lConnectiondbConn=newSqlConnection(Param_Class.Param_DB.strConn);28dbConn.Open();29SqlDataAdapterSda=newSqlDataAdapter(Sql,dbConn);30DataSetds=newDataSet();31Sda.Fill(ds,TableName);32dbConn.Close();33returnds.TablesTableName;343536/37/查找數(shù)據(jù)表中是否存在某個(gè)記錄38/39/SQL查詢語句40/整形變量，0沒有符合記錄；大于0找到符合記錄41publicintIs

6、RecorderExist(stringSql)4243SqlConnectiondbConn=newSqlConnection(Param_Class.Param_DB.strConn);44dbConn.Open();45SqlDataAdapterSda=newSqlDataAdapter(Sql,dbConn);46DataTabledt=newDataTable();47Sda.Fill(dt);48dbConn.Close();49returndt.Rows.Count;505152/53/在對(duì)應(yīng)的數(shù)據(jù)表里添加新記錄54/55/需要添加記錄的數(shù)據(jù)表56/需要添加記錄的數(shù)據(jù)表所暫存的

7、DataTable57/新記錄的各字段值組成的字符串?dāng)?shù)組58publicvoidDb_AddNew(stringstrTableName,DataTabledt,stringstrValues)5960try6162stringstrDesField=newstring100;63stringstrSql=,strField=,strValue=;64for(inti=0;idt.Columns.Count;i+)6566strDesFieldi=dt.Columnsi.ColumnName;67strField+=strDesFieldi+,;68strValue+=+strValuesi+

8、,;6970intnPos=strField.LastIndexOf(,);71strField=strField.Substring(0,nPos);72nPos=strValue.LastIndexOf(,);73strValue=strValue.Substring(0,nPos);74strSql=String.Format(INSERTINTO0(1)VALUES(2),strTableName,strField,strValue);75SqlConnectiondbConn=newSqlConnection(Param_Class.Param_DB.strConn);76SqlCo

9、mmandcmdAddNew=newSqlCommand(strSql,dbConn);77dbConn.Open();78SqlDataReaderSdr=cmdAddNew.ExecuteReader();79Sdr.Close();80dbConn.Close();8182catch(Exceptionex)8384MessageBox.Show(操作失敗，原因：+ex.ToString();85868788/89/在對(duì)應(yīng)的數(shù)據(jù)表里刪除記錄90/91/源數(shù)據(jù)表名92/數(shù)據(jù)表主鍵93/主鍵的匹配值94publicvoidDB_Delete(stringstrTableName,string

10、strKey,stringstrFilter)9596try9798stringstrSql=String.Format(DELETEFROM0WHERE1=2,strTableName,strKey,strFilter);99SqlConnectiondbConn=newSqlConnection(Param_Class.Param_DB.strConn);100SqlCommandcmdDel=newSqlCommand(strSql,dbConn);101dbConn.Open();102SqlDataReaderSdr=cmdDel.ExecuteReader();103Sdr.Clo

11、se();104dbConn.Close();105106catch(Exceptionex)107108MessageBox.Show(操作失敗，原因：+ex.ToString();109110111112/113/更新數(shù)據(jù)庫中與參數(shù)中的SQL查詢符合的記錄,針對(duì)單條記錄修改114/115/查詢某條需要修改的記錄的SQL語句116/各字段的新值，字符串?dāng)?shù)組117/更新后的數(shù)據(jù)表DataTable118publicDataTableDB_Update(stringstrSql,stringstrValue)119120DataTabledt=newDataTable();121dt=DB_Find(Param_Class.Param_DB.strConn,strSql);122DataTabledtNew=newDataTable();123for(inti=0;idt.Columns.Count;i+)124125dt.Rows0dt.Columnsi.ColumnName=strValuei;126127SqlDataAdapterS