string strCn="data source=bmonkey;initial catalog=test;uid=sa;password=123";
string strSql="insert into test values(@para)";
SqlParameter para=new SqlParameter("@para",SqlDbType.VarChar,50);
para.Value="111";
SqlConnection cn=new SqlConnection(strCn);
SqlCommand cmd=new SqlCommand(strSql,cn);
cn.Open();
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
cn.Close();
string strSql="insert into test values(@para)";
SqlParameter para=new SqlParameter("@para",SqlDbType.VarChar,50);
para.Value="111";
SqlConnection cn=new SqlConnection(strCn);
SqlCommand cmd=new SqlCommand(strSql,cn);
cn.Open();
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
cn.Close();
添加若干textBox和“增加”按钮,然后填入下列代码
sqlInsertCommand1.Parameters["@编号"].Value=textBox1.Text;
//将TextBox赋值给对应参数
sqlInsertCommand1.Parameters["@姓名"].Value=textBox2.Text;
sqlInsertCommand1.Parameters["@密码"].Value=textBox3.Text;
sqlInsertCommand1.Connection.Open();
//打开连接
sqlInsertCommand1.ExecuteNonQuery();
//执行Insert语句
sqlInsertCommand1.Connection.Close();
2. 删操作
SqlCommand sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
//声明Sql Command类对象
this.sqlDataAdapter1.DeleteCommand = sqlDeleteCommand1;
sqlDeleteCommand1.CommandText="DELETE FROM LOGIN WHERE 姓名='"+textBox2.Text+"'";
//SQL语句
sqlDeleteCommand1.Connection = this.sqlConnection1;
//声明使用的数据连接
sqlDeleteCommand1.Connection.Open();
sqlDeleteCommand1.ExecuteNonQuery();
//执行该SQL语句
sqlDeleteCommand1.Connection.Close();
3. 改操作
SqlCommand sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
//声明Sql Command类对象
this.sqlDataAdapter1.UpdateCommand = sqlUpdateCommand1;
sqlUpdateCommand1.CommandText="update LOGIN set 编号='"+textBox1.Text+"',密码='"+textBox3.Text+"' where 姓名='"+textBox2.Text+"'";
//SQL语句
sqlUpdateCommand1.Connection = this.sqlConnection1;
//声明使用的数据连接
sqlUpdateCommand1.Connection.Open();
sqlUpdateCommand1.ExecuteNonQuery();
//sqlDataAdapter1.Update(dataSet11);
//执行该SQL语句
sqlUpdateCommand1.Connection.Close();
string strSql="insert into test values(@para,@para2 ...)";
或者
string strSql="select * from test where para=@para and para2=@para2 ...";
或者
string strSql="update test set (para=@para,para2=@para2 ...)where ...";然后:
Command.Parameters.Add('@para',YouValue1);
Command.Parameters.Add('@para2',YouValue2);
...
cmd.ExecuteNonQuery();