点点滴滴访问量:
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
string id = "zawp";
string name = "wwwwwww";
string strCon = @"Data Source=(local);Integrated Security=SSPI;Initial Catalog =northwind";
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
// 直接在sql语句中写添加的参数名,这里没有做任何类型验证,在定义参数时需要准确的类型定义和长度设置
string delegeSql = "insert into Customers(CompanyName,CustomerID) values(@Name,@id)";
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SqlConnection strConn = new SqlConnection(strCon);
strConn.Open();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SqlDataAdapter thisAdapter = new SqlDataAdapter(delegeSql, strCon);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
Console.WriteLine(thisAdapter.SelectCommand.CommandText);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
SqlCommand strComm = new SqlCommand(delegeSql, strConn);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
//生成一个名字为@Id的参数,在这里必须要准确设定参数类型和类型长度,并且必须以@开头表示是添加的参数
//注意可以用一个SqlParameter对像来添加多个参数,并且这里的参数定义、添加可以不安照sql语句里参数值的顺序(如果是存储过程的话,要注意顺序)
SqlParameter para = new SqlParameter("@id", SqlDbType.NChar, 5);
para.Value = id;
strComm.Parameters.Add(para);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
para = new SqlParameter("@name", SqlDbType.NVarChar, 40);
para.Value = name;
strComm.Parameters.Add(para);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
strComm.ExecuteNonQuery();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
strConn.Close();
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
posted on
2007-05-10 15:00
sopper
阅读(
3558)
评论()
编辑
收藏
举报