你那个语句只是添加参数给SQL语句,要添加数据到表需要用INSERT INTO语句
帖一下.net framework的帮助
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;" +
"Initial Catalog=northwind");
nwindConn.Open();string insertStr = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";SqlCommand insertCMD = new SqlCommand(insertStr, nwindConn);
Int32 recordsAffected = insertCMD.ExecuteNonQuery();
帖一下.net framework的帮助
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;" +
"Initial Catalog=northwind");
nwindConn.Open();string insertStr = "INSERT INTO Customers (CustomerID, CompanyName) Values('NWIND', 'Northwind Traders')";SqlCommand insertCMD = new SqlCommand(insertStr, nwindConn);
Int32 recordsAffected = insertCMD.ExecuteNonQuery();
添加InsertCommand的CommandText吧,就是你的SQL语句
SqlDataAdapter da=new SqlDataAdapter("select * from info",cn);
SqlCommandBuilder cb=new SqlCommandBuilder(da);
DataSet ds=new DataSet();
da.Fill(ds,"info");
DataRow newrow=ds.Tables["info"].NewRow();
newrow["id"]="1";
newrow["name"]="aaaaa";
ds.Tables["info"].Rows.Add(newrow);
da.Update(ds,"info");
这样就没问题了
using System.Data.SqlClient;
SqlConnection cn=new SqlConnection(连接字符串);
cn.Open();
SqlCommand cmd=new SqlCommand("insert into info (name) values(@name)",cn);
cmd.Parameters.Add("@name",SqlDbType.VarChar,10);
cmd.Parameters[0].Value=textBox.text;
cmd.ExecuteNonQuery();