C#编程数据库.doc

C#OOC#(C Sharp)C#MicrosoftTurbo PascalDelphiAndersC#AndersMicrosoftC#VC+.NETC#C#JAVAC#VB.NETC#?JAVA?C#.NETC#JAVAJAVAJAVAJAVA1C#IT.NETVS.NET.NETC#ADO.NETC#Visual FoxproVFPOPEN DATABASE MyDatabase &MyDatabaseUSE MyTable &MyTableGO 5 &Cursor5REPLACE MyName WITH &5MyNameGO BOTTOM &CursorLOCATE FOR MyName= &IF FOUND()? FOUND!ELSE? NOT FOUND!ENDIFUSE &MyTableCLOSE DATABASE MyDatabase &MyDatabaseVFPVFPCursorOO-OOOO(Method)(Attribure)(Event)C#ADO.NETC#ADO.NETADO.NETADO.NETSQL ServerOLE DBSQL ServerSQL ServerSQL ServerConnetionConnectionSqlConnectionOleDbConnectionusingusing System.Data.SqlClientSystem.Data.OleDbSQL Serverstring strConn=Integrated Security=SSPI;Initial Catalog=MyDatabase;Data Source=YY-POWERPC ;SqlConnection myConnection = new SqlConnection (strConn);myConnection.Open();OleDbString strConn=Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=SSPI;OleDbConnection myConnection=new OleDbConnection (strConn);myConnection.Open();DataAdapterDataAdapterDataSetDataSetDataAdapterDataSetDataAdapterSqlDataAdapterOleDbDataAdatper(OleDbDataAdapter)SqlDataAdapter myDataAdapter = new SqlDataAdapter ();DataSet myDataSet = new DataSet ();string strCom = SELECT * FROM ;myDataAdapter.SelectCommand = new SqlCommand (strCom,myConnection);SqlCommandBuilder myCB = new SqlCommandBuilder (myDataAdapter);myDataAdapter.Fill (myDataSet,);SqlDataAdapterDataSetSqlCommandSqlCommandBuilderSqlDataAdapterDataSetCommand(SqlCommandOleDbCommand)SelectCommandInsertCommandUpdateCommandDeleteCommandCommandDataAdapterSelectCommandCommandBuilderDataAdapterSelectCommandSQL SelectDataAdapterFillDataSetDataTableDataSetADORecordsetDataSetRecordsetRecordsetRecordsetDataSetDataTableCollectionDataTableDataTableDataTableDataRowCollectionDataColumnCollectionConstraintCollectionDataRow()DataColumn()Constraint()myDataSet.TablesMyTable.Rows3MyName = ;?OO!DataSetMyTable4MyName?ADO.NETDataColumn?Rows34Rows3DataRowMyNameMyNameADO.NETColumnMyName3DataColumn(Field)Column1.ColumnNameC#+ADO.NETADO.NETC#C#()CSDNCSDNC#()C#OKC#+ADO.NETMISC#Visual FoxproUSE MyTableAPPEND BLANKREPLACE MyName WITH USEC#OOC#?DataSetDataRowDataRowDataSetDataTableDataTableDataRowDataRowCollectionDataRowDataTableDataRowCollectionSqlDataAdapter myDataAdapter = new SqlDataAdapter ();DataSet myDataSet = new DataSet ();string strCom = SELECT * FROM myTable;myDataAdapter.SelectCommand = new SqlCommand (strCom,myConnection);SqlCommandBuilder myCB = new SqlCommandBuilder (myDataAdapter);myDataAdapter.Fill (myDataSet,myTable);myDataSetDataTablemyTableDataTableNewRowDataRowDataTable.Rows(DataRowCollection)AddDataRow myDataRow; /DataRowDataTable myDataTable; /DataTablemyDataTable = myDataSet.TablesmyTable; /DataSetDataTablemyDataRow = myDataTable.NewRow(); /NewRowDataRowmyDataRowmyName = ; /DataRowmyNamemyDataTable.Rows.Add(myDataRow); /DataRowmyDataTable?OODataSetDataAdapterUpdateDataSetADO.NETDataSetDataSetDataTableDataRowDataRow myDataRow; /DataRowDataTable myDataTable; /DataTablemyDataTable = myDataSet.TablesmyTable; /DataSetDataTablemyDataRow = myDataTable.Rows1; /DataRowmyDataRowmyName = ; /DataRowmyName,DataTableDataRowDelete1DataRow myDataRow; /DataRowDataTable myDataTable; /DataTablemyDataTable = myDataSet.TablesmyTable; /DataSetDataTablemyDataRow = myDataTable.Rows1;