C通過DataGridView更新數據庫

1、ublicpartialclassForm1:FormForm1數據成員#regionForm1數據成員privateDataTableDT=newDataTable();privateSqlDataAdapterSDA=newSqlDataAdapter();#endregionForm1構造函數#regionForm1構造函數publicForm1()InitializeComponent();#endregion連接數據庫顯示數據#region連接數據庫顯示數據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更新數據庫#region使用Update更新數據庫privatevoidtoolStripButton1_Click(objectsender,EventArgse)trySqlCommandBuilderSCB=newS

3、qlCommandBuilder(SDA);SDA.Update(DT);catch(System.Exceptionex)MessageBox.Show(ex.ToString();return;MessageBox.Show(更新成功!);#endregion1#region關于數據庫操作的函數集，與業(yè)務無關23/4/查詢數據庫記錄,返回存放記錄的DataTable5/6/SQL查詢語句7/DataTable數據表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/查詢數據庫記錄，返回存放記錄的DataTable，并指定其名稱21/22/SQL查詢語句23/指定DataTable的名稱24/以TableName命名的數據表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/查找數據表中是否存在某個記錄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/在對應的數據表里添加新記錄54/55/需要添加記錄的數據表56/需要添加記錄的數據表所暫存的

7、DataTable57/新記錄的各字段值組成的字符串數組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/在對應的數據表里刪除記錄90/91/源數據表名92/數據表主鍵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/更新數據庫中與參數中的SQL查詢符合的記錄,針對單條記錄修改114/115/查詢某條需要修改的記錄的SQL語句116/各字段的新值，字符串數組117/更新后的數據表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