sql的insert语法在c#中

[elthan888]

比方
insert(sss,cc,ss,cc) values(怎么调用变量，写法怎么写呢）
能有完整的插入例子最好

[wangsaokui]

insert_sql = "insert into table_name column_name1,column_name2,column_name3,column_name4) values ('"+var_1+"'"+var_2+"'"+var_3+"'"+var4+"')";

如果类型是整形或数字的就不用加 ‘

[win32c]

private const string INSERT_MMBE = "INSERT INTO TABLENAME VALUES('{0}', '{1}', '{2}','{3}','{4}', '{5}', '{6}', '{7}')";

string commandText=String.Format(INSERT_MMBE, TABLENAME.COLUMS, ……);
SqlHelper.ExecuteNonQuery(connection, CommandType.Text, commandText);

[wangsaokui]

string insert_sql;
insert_sql = "insert into table_name column_name1,column_name2,column_name3,column_name4) values ('"+var_1+"'"+var_2+"'"+var_3+"'"+var4+"')";

SqlCommand InsertCmd as new SqlCommand;
InsertCmd.CommandText=insert_sql;
conn.open();
InsertCmd.ExecuteNonQuery();
conn.close();

[chyich]

1.用字符串来拼:
public void ReadMyData(string myConnString)
{
string aa="1";
string mySelectQuery = "isnert Orders(OrderID, Customer) values(";
mySelectQuery +=aa;
mySelectQuery +=",'sddd'";
SqlConnection myConnection = new SqlConnection(myConnString);
SqlCommand myCommand = new SqlCommand(mySelectQuery,myConnection);
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
try
{
while (myReader.Read())
{
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
myReader.Close();
// always call Close when done reading.
myConnection.Close();
}
}
2.用Sqlparameter来传参数:
string strConn, strSQL;
strConn = "Data Source=(local)\\NetSDK;Initial Catalog=Northwind;" +
"Trusted_Connection=Yes;";
strSQL = "SELECT OrderID, CustomerID, OrderDate FROM Orders " +
"WHERE CustomerID = @CustomerID";
SqlDataAdapter da = new SqlDataAdapter(strSQL, strConn);
SqlParameter param;
param = da.SelectCommand.Parameters.Add("@CustomerID", SqlDbType.NChar, 5);
param.Value = "ALFKI";
DataTable tbl = new DataTable("Orders");
da.Fill(tbl);

[wangsaokui]

方法2：
Dim UpdateCmd As String = "UPDATE Authors SET au_id = @Id, au_lname = @LName, " & _
"au_fname = @FName, phone = @Phone, address = @Address, city = @City, " & _
"state = @State, zip = @Zip, contract = @Contract where au_id = @Id"

MyCommand = New SqlCommand(UpdateCmd, MyConnection)

MyCommand.Parameters.Add(New SqlParameter("@Id", SqlDbType.NVarChar, 11))
MyCommand.Parameters.Add(New SqlParameter("@LName", SqlDbType.NVarChar, 40))
MyCommand.Parameters.Add(New SqlParameter("@FName", SqlDbType.NVarChar, 20))
MyCommand.Parameters.Add(New SqlParameter("@Phone", SqlDbType.NChar, 12))
MyCommand.Parameters.Add(New SqlParameter("@Address", SqlDbType.NVarChar, 40))
MyCommand.Parameters.Add(New SqlParameter("@City", SqlDbType.NVarChar, 20))
MyCommand.Parameters.Add(New SqlParameter("@State", SqlDbType.NChar, 2))
MyCommand.Parameters.Add(New SqlParameter("@Zip", SqlDbType.NChar, 5))
MyCommand.Parameters.Add(New SqlParameter("@Contract", SqlDbType.NVarChar,1))

'分别给各变量赋值
MyCommand.Parameters("@Id").Value = MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
......


MyCommand.Connection.Open()
MyCommand.ExecuteNonQuery()
MyCommand.Connection.Close()

[wggwan]

string strSQL="insert into material(sort_num,m_name,m_shape,m_price,m_stocks,m_date,p_name,storage_num) values("+list1.SelectedItem.Value+",'"+txtname.Text+"','"+txtshape.Text+"',"+txtprice.Text+",'"+txtnumber.Text+"','"+byear+"','"+s+"',"+list2.SelectedItem.Value+")";

[elthan888]

还有个最终要的就是比如
ds1 = new DataSet();
myCommand1.Fill(ds1,"users") ;
dr1 = ds1.Tables["users"].Rows[0] ;
我把dr1["name"]怎么放在value里面，怎么写呢，大虾们帮我下

[flyincs]

支持 chyich() ,支持 wangsaokui(无间道)

[huangsuipeng]

顶一下！

[donglicsdn]

SqlConnection cn=new
SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
string strSQL="insert into temp1(id,kind_id)
values('"+TextBox1.Text+"','"+ListBox1.Items[i].Value+"')";
cn.Open();
SqlCommand cm=new SqlCommand(strSQL,cn);
cm.ExecuteNonQuery();
cn.Close();