以下是引用片段: //创建一个 OleDbConnection string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = db.mdb" ; OleDbConnection myConn = new OleDbConnection ( strCon ) ; string strCom = " SELECT * FROM person " ; file://创建一个 DataSet myDataSet = new DataSet ( ) ; myConn.Open ( ) ; file://用 OleDbDataAdapter 得到一个数据集 OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ; file://把Dataset绑定books数据表 myCommand.Fill ( myDataSet , "person" ) ; file://关闭此OleDbConnection myConn.Close ( ) ; myBind = this.BindingContext [ myDataSet , "person" ] ; |
以下是引用片段: // 设定数据连接字符串,此字符串的意思是打开Sql server数据库,服务器名称为server1,数据库为data1 string strCon = "Provider = SQLOLEDB.1 ; Persist Security Info = False ; User ID = sa ; Initial Catalog = data1 ; Data Source = server1 " ; OleDbConnection myConn = new OleDbConnection ( strCon ) ; myConn.Open ( ) ; string strCom = " SELECT * FROM person " ; file://创建一个 DataSet myDataSet = new DataSet ( ) ; file://用 OleDbDataAdapter 得到一个数据集 OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ; file://把Dataset绑定person数据表 myCommand.Fill ( myDataSet , " person " ) ; file://关闭此OleDbConnection myConn.Close ( ) ; myBind = this.BindingContext [ myDataSet , "person" ] ; |
以下是引用片段: protected void GoPrevious ( object sender , System.EventArgs e ) { if ( myBind.Position == 0 ) MessageBox.Show ( "已经到了第一条记录!" , "信息提示!" , MessageBoxButtons.OK , MessageBoxIcon.Information ) ; else myBind.Position -= 1 ; } |
以下是引用片段: protected void GoNext ( object sender , System.EventArgs e ) { if ( myBind.Position == myBind.Count -1 ) MessageBox.Show ( "已经到了最后一条记录!", "信息提示!" , MessageBoxButtons.OK , MessageBoxIcon.Information ) ; else myBind.Position += 1 ; } |
以下是引用片段: protected void GoLast ( object sender , System.EventArgs e ) { myBind.Position = myBind.Count - 1 ; } |
以下是引用片段: protected void GoFirst ( object sender , System.EventArgs e ) { myBind.Position = 0 ; } |
以下是引用片段: protected void Delete_record ( object sender , System.EventArgs e ) { DialogResult r = MessageBox.Show ( "是否删除当前记录!" , "删除当前记录!" , MessageBoxButtons.YesNo , MessageBoxIcon.Question ) ; int ss = ( int ) r ; if ( ss == 6 ) // 按动"确定"按钮 { try{ file://连接到一个数据库 string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = db.mdb " ; OleDbConnection myConn = new OleDbConnection ( strCon ) ; myConn.Open ( ) ; string strDele = "DELETE FROM person WHERE id= " + t_id.Text ; OleDbCommand myCommand = new OleDbCommand ( strDele , myConn ) ; file://从数据库中删除指定记录 myCommand.ExecuteNonQuery ( ) ; file://从DataSet中删除指定记录 myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . Delete ( ) ; myDataSet.Tables [ "person" ] . AcceptChanges ( ) ; myConn.Close ( ) ; } catch ( Exception ed ) { MessageBox.Show ( "删除记录错误信息: " + ed.ToString ( ) , "错误!" ) ; } } } |
欢迎光临 南昌大学|中正论坛 (http://ncu.myubbs.com/) | Powered by Discuz! X3.3 |