有谁能帮我讲讲ado。net中怎么用insert来插入一行

Question

SqlConnection sqlCon = new SqlConnection(ConnectionString);
Sqlcommand cmd = new Sqlcommand("insert into tablename(columnname) values(value)",sqlCon);
cmd.ExcuteNoQuery;

Answer 1

SqlCommand cmdSign=new SqlCommand();
cmdSign.Connection=new SqlConnection("workstation id=localhost;packet size=4096;user id=sa;data source=localhost;persist security info=False;initial catalog=northwind"")
cmdSign.Connection.Open();
try
{

cmdSign.CommandType=CommandType.StoredProcedure;
cmdSign.CommandText="insert into customers(CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,Postalcode,Country,Phone,Fax) values('a','b','c','d','e','f','g','h','i','j','k')"
cmdSign.ExecuteNonQuery();
}
catch(Exception ex)
{
this.m_SignUpMsg=Msgs.向数据库中添加记录失败.ToString()+ex.Message;
result=false;
}
finally
{
cmdSign.Connection.Close();
}

Answer 2

o,中间catch抛出来的一句是我忘记删掉的，应改为
catch(Exception ex)
{
   MessageBox.Show(ex.ToString());
}

Answer 3

不好意思，前面有一句也没有删掉：
请删掉：cmdSign.CommandType=CommandType.StoredProcedure;这一行。
试试吧.