刚学习c# http://community.csdn.net/Expert/topic/3510/3510771.xml?temp=.203335 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sql="你的sql增,删或改的语句";SqlCommand cmd = conn.CreateCommand();cmd.Connection.Open();cmd.CommandText=sql;cmd.ExecuteNonQuery();cmd.Connection.Close(); 我给你101个例子 [email protected] 数据库的修改和删除:protected void GoDelete ( object sender, System.EventArgs e ){try{//连接到一个数据库string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = sample.mdb " ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;myConn.Open ( ) ;string strDele = "DELETE FROM books WHERE bookid= " + t_bookid.Text ;OleDbCommand myCommand = new OleDbCommand ( strDele , myConn ) ;//从数据库中删除指定记录myCommand.ExecuteNonQuery ( ) ;//从DataSet中删除指定记录myDataSet.Tables [ "books" ] . Rows [ myBind.Position ] . Delete ( ) ;myDataSet.Tables [ "books" ] . AcceptChanges ( ) ;myConn.Close ( ) ;}catch ( Exception ed ){MessageBox.Show ( "删除记录错误信息: " + ed.ToString ( ) , "错误!" ) ;}}//"修改记录"按钮对应的事件protected void GoUpdate ( object sender , System.EventArgs e ){int i = myBind.Position ;try{//连接到一个数据库string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = sample.mdb " ;OleDbConnection myConn = new OleDbConnection ( strCon ) ;myConn.Open ( ) ;//从数据库中修改指定记录string strUpdt = " UPDATE books SET booktitle = '"+ t_booktitle.Text + "' , bookauthor = '"+ t_bookauthor.Text + "' , bookprice = "+ t_bookprice.Text + " , bookstock = "+ t_bookstock.Text + " WHERE bookid = " + t_bookid.Text ;OleDbCommand myCommand = new OleDbCommand ( strUpdt , myConn ) ;myCommand.ExecuteNonQuery ( ) ;myConn.Close ( ) ;}catch ( Exception ed ){MessageBox.Show ( "修改指定记录错误: " + ed.ToString ( ) , "错误!" ) ;}myBind.Position = i ;}//"尾记录"按钮对应的事件protected void GoLast ( object sender , System.EventArgs e ){myBind.Position = myBind.Count - 1 ;}//"下一条"按钮对应的事件protected void GoNext ( object sender , System.EventArgs e ){if ( myBind.Position == myBind.Count - 1 )MessageBox.Show ( "已经到尾记录!" ) ;elsemyBind.Position += 1 ;}//"上一条"按钮对应的事件protected void GoPrevious ( object sender , System.EventArgs e ){if ( myBind.Position == 0 )MessageBox.Show ( "已经到首记录!" ) ;elsemyBind.Position -= 1 ;}//"首记录"按钮对应的事件protected void GoFirst ( object sender , System.EventArgs e ){myBind.Position = 0 ;} 用SQL来控制最简单了或者用NewRow()和Delete()来增删 UP + 学习 + 接分UP + 学习 + 接分UP + 学习 + 接分 初学者问题 C#获取excel某个单元格的值 VS2008中ADO.NET生成实体框架时关于外键的问题 winform窗体之间的交互 C#和SQL 问一个C#编译报错的问题. 如何获取多行文本框中,光标所在的行列值? 请问C# 和 VB.NET语言是不是一样啊 水晶报表中的货币单位精度是多少? 看了ESP 2.0的同志请进! datepicker的使用问题 请教一个比较麻烦的问题
SqlCommand cmd = conn.CreateCommand();
cmd.Connection.Open();
cmd.CommandText=sql;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
{
try{
//连接到一个数据库
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = sample.mdb " ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
myConn.Open ( ) ;
string strDele = "DELETE FROM books WHERE bookid= " + t_bookid.Text ;
OleDbCommand myCommand = new OleDbCommand ( strDele , myConn ) ;
//从数据库中删除指定记录
myCommand.ExecuteNonQuery ( ) ;
//从DataSet中删除指定记录
myDataSet.Tables [ "books" ] . Rows [ myBind.Position ] . Delete ( ) ;
myDataSet.Tables [ "books" ] . AcceptChanges ( ) ;
myConn.Close ( ) ;
}
catch ( Exception ed )
{
MessageBox.Show ( "删除记录错误信息: " + ed.ToString ( ) , "错误!" ) ;
}
}
//"修改记录"按钮对应的事件
protected void GoUpdate ( object sender , System.EventArgs e )
{
int i = myBind.Position ;
try{
//连接到一个数据库
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = sample.mdb " ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
myConn.Open ( ) ;//从数据库中修改指定记录
string strUpdt = " UPDATE books SET booktitle = '"
+ t_booktitle.Text + "' , bookauthor = '"
+ t_bookauthor.Text + "' , bookprice = "
+ t_bookprice.Text + " , bookstock = "
+ t_bookstock.Text + " WHERE bookid = " + t_bookid.Text ;OleDbCommand myCommand = new OleDbCommand ( strUpdt , myConn ) ;
myCommand.ExecuteNonQuery ( ) ;
myConn.Close ( ) ;
}
catch ( Exception ed )
{
MessageBox.Show ( "修改指定记录错误: " + ed.ToString ( ) , "错误!" ) ;
}
myBind.Position = i ;
}
//"尾记录"按钮对应的事件
protected void GoLast ( object sender , System.EventArgs e )
{
myBind.Position = myBind.Count - 1 ;
}
//"下一条"按钮对应的事件
protected void GoNext ( object sender , System.EventArgs e )
{
if ( myBind.Position == myBind.Count - 1 )
MessageBox.Show ( "已经到尾记录!" ) ;
else
myBind.Position += 1 ;
}
//"上一条"按钮对应的事件
protected void GoPrevious ( object sender , System.EventArgs e )
{
if ( myBind.Position == 0 )
MessageBox.Show ( "已经到首记录!" ) ;
else
myBind.Position -= 1 ;
}
//"首记录"按钮对应的事件
protected void GoFirst ( object sender , System.EventArgs e )
{
myBind.Position = 0 ;
}