C#中修改数据库,怎么操作的呢?
这些代码是读取数据库的表,那么如果要在C#中修改,添加..怎么弄了...?
private void button1_Click(object sender, EventArgs e)
{
string connectString = this.txtConn.Text.Trim();//数据库连接字符串,用一个字符窜来接受txt中的文本
SqlConnection con = new System.Data.SqlClient.SqlConnection(connectString);//创建一个连接对象
con.Open();//打开连接
SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand();//创建一个Command对象
sqlCmd.Connection = con;
sqlCmd.CommandText = "SELECT * FROM booktable ";//sql语句
System.Data.SqlClient.SqlDataAdapter sqlAdapter = new System.Data.SqlClient.SqlDataAdapter(sqlCmd);
DataTable table = new DataTable();
sqlAdapter.Fill(table);//填充数据到表格;
this.dataGridView1.DataSource = table;//给GridView控制数据源赋值
con.Close();//(联接结束)
}
[解决办法]
insert
update
or
dataapter
[解决办法]
private void toolDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show( "确定删除？ ", "系统提示 ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
string sql = "DELETE FROM SYSRULE WHERE ID_RULE=@ID_RULE ";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = sql;
sqlCmd.Parameters.Add(new SqlParameter( "@ID_RULE ", this.dtRule.Rows[bind.Position][ "ID_RULE "]));
this.dataAccess.ExecuteSql(sqlCmd);
this.dtRule.Rows.RemoveAt(bind.Position);
}
}
================================================
if (CheckData())
{
MessageBox.Show( "数据检查失败！ ", "系统提示 ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
SqlCommand sqlCmd = new SqlCommand();
string sql;
if (FormStatus == Status.AddStatus)
{
sql = "INSERT INTO SYSRULE(NO_RULE,NM_RULE,ID_EMP,RM)VALUES(@RULENO,@RULENAME,@EMPID,@RM) ";
sqlCmd.CommandText = sql;
sqlCmd.Parameters.Add(new SqlParameter( "@RULENO ", this.txtRuleNo.Text.ToString()));
MessageBox.Show(this.txtRuleName.Text.ToString());
sqlCmd.Parameters.Add(new SqlParameter( "@RULENAME ", this.txtRuleName.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter( "@EMPID ", idEmp));
sqlCmd.Parameters.Add(new SqlParameter( "@RM ", this.txtRm.Text.ToString()));
this.dataAccess.ExecuteSql(sqlCmd);
}
else if (FormStatus == Status.ModifySatus)
{
sql = "UPDATE SYSRULE SET NO_RULE=@RULENO,NM_RULE=@RULENAME,ID_EMP=@EMPID,RM=@RM WHERE ID_RULE=@RULEID ";
sqlCmd.CommandText = sql;
sqlCmd.Parameters.Add(new SqlParameter( "@RULEID ", this.dtRule.Rows[bind.Position][ "ID_RULE "]));
sqlCmd.Parameters.Add(new SqlParameter( "@RULENO ", this.txtRuleNo.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter( "@RULENAME ", this.txtRuleName.Text.ToString()));
sqlCmd.Parameters.Add(new SqlParameter( "@EMPID ", idEmp));
sqlCmd.Parameters.Add(new SqlParameter( "@RM ", this.txtRm.Text.ToString()));
this.dataAccess.ExecuteSql(sqlCmd);
}
================================dataAccess.cs的一部分
#region 执行SQL指令
public void ExecuteSql(SqlCommand sqlCmd)
{
//throw new System.NotImplementedException();
sqlCmd.Connection = this.cnn;
try
{
cnn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception( "数据更新出错！ ", ex);
}
finally
{
cnn.Close();
}
}
#endregion
[解决办法]
对数据库的操作：包括创建数据库、创建表、创建存贮过程、创建视图、删除表、删除存贮过程、删除视图、读表数据、更新整个表数据等等，非常详细。
摘录：《程序员秘书》－－源代码－－数据库－－SQL数据库各种操作
详见：http;//www.psec.net.cn
[解决办法]
string connectString = this.txtConn.Text.Trim();//数据库连接字符串,用一个字符窜来接受txt中的文本
using (SqlConnection con = new System.Data.SqlClient.SqlConnection(connectString))
{
con.Open();//打开连接
SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand();//创建一个Command对象
sqlCmd.Connection = con;
sqlCmd.CommandText = "UPDATE…… or DELETE…… ";//sql语句
sqlCmd.ExecuteNonQuery();
con.Close();//(联接结束)
}
[解决办法]
ADO.NET中的多数据表操作浅析
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
透过vs.net数据窗体向导看Ado.net
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx
