t_id.Text = ( myBind.Count + 1 ).ToString ( ) ;
t_xm.Text = "" ;
t_xb.Text = "" ;
t_nl.Text = "" ;
t_books.Text = "" ;
}
protected void Insert_record ( object sender , System.EventArgs e )
{
try
{
file://判斷所有字段是否添完，添完則執(zhí)行，反之彈出提示
if ( t_id.Text != "" && t_xm.Text != "" && t_xb.Text != "" &&
t_nl.Text != "" && t_books.Text != "" )
{
string myConn1 = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = db.mdb" ;
OleDbConnection myConn = new OleDbConnection ( myConn1 ) ;
myConn.Open ( ) ;
string strInsert = " INSERT INTO person ( id , xm , xb , nl , zip ) VALUES ( " ;
strInsert += t_id.Text + ", '" ;
strInsert += t_xm.Text + "', '" ;
strInsert += t_xb.Text + "', " ;
strInsert += t_nl.Text + ", " ;
strInsert += t_books.Text + ")" ;
OleDbCommand inst = new OleDbCommand ( strInsert , myConn ) ;
inst.ExecuteNonQuery ( ) ;
myConn.Close ( ) ;
myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . BeginEdit ( ) ;
myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . EndEdit ( ) ;
myDataSet.Tables [ "person" ] . AcceptChanges ( ) ;
}
else
{
MessageBox.Show ( "必須填滿所有字段值！" , "錯誤！" ) ;
}
}
catch ( Exception ed )
{
MessageBox.Show ( "保存數(shù)據(jù)記錄發(fā)生 " + ed.ToString ( ) , "錯誤！" ) ;
}
}
protected void Update_record ( object sender , System.EventArgs e )
{
int i = myBind.Position ;
try{
file://連接到一個數(shù)據(jù)庫
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = db.mdb " ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
myConn.Open ( ) ;
myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . BeginEdit ( ) ;
file://從數(shù)據(jù)庫中修改指定記錄
string strUpdt = " UPDATE person SET xm = '"
+ t_xm.Text + "' , xb = '"
+ t_xb.Text + "' , nl = "
+ t_nl.Text + " , zip = "
+ t_books.Text + " WHERE id = " + t_id.Text ;
OleDbCommand myCommand = new OleDbCommand ( strUpdt , myConn ) ;
myCommand.ExecuteNonQuery ( ) ;
myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . EndEdit ( ) ;
myDataSet.Tables [ "person" ] . AcceptChanges ( ) ;
myConn.Close ( ) ;
}
catch ( Exception ed )
{
MessageBox.Show ( "修改指定記錄錯誤： " + ed.ToString ( ) , "錯誤！" ) ;
}
myBind.Position = i ;
}

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://連接到一個數(shù)據(jù)庫
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://從數(shù)據(jù)庫中刪除指定記錄
myCommand.ExecuteNonQuery ( ) ;
file://從DataSet中刪除指定記錄
myDataSet.Tables [ "person" ] . Rows [ myBind.Position ] . Delete ( ) ;
myDataSet.Tables [ "person" ] . AcceptChanges ( ) ;
myConn.Close ( ) ;
}
catch ( Exception ed )
{
MessageBox.Show ( "刪除記錄錯誤信息： " + ed.ToString ( ) , "錯誤！" ) ;
}
}
}
file://按鈕"尾記錄"對象事件程序
protected void GoLast ( object sender , System.EventArgs e )
{
myBind.Position = myBind.Count - 1 ;
}
file://按鈕"下一條"對象事件程序
protected void GoNext ( object sender , System.EventArgs e )
{
if ( myBind.Position == myBind.Count -1 )
MessageBox.Show ( "已經(jīng)到了最后一條記錄！", "信息提示！" ,
　　　　　　　　　　　　　　　　　　　 MessageBoxButtons.OK , MessageBoxIcon.Information
) ;
else
myBind.Position += 1 ;
}
file://按鈕"上一條"對象事件程序
protected void GoPrevious ( object sender , System.EventArgs e )
{
if ( myBind.Position == 0 )
MessageBox.Show ( "已經(jīng)到了第一條記錄！" , "信息提示！" ,
　　　　　　　　　　　　　　MessageBoxButtons.OK , MessageBoxIcon.Information
) ;
else
myBind.Position -= 1 ;
}
file://按鈕"首記錄"對象事件程序
protected void GoFirst ( object sender , System.EventArgs e )
{
myBind.Position = 0 ;
}
}