insert语句的用法?

Question

string sql = "insert into 表(字段1,字段2) value({0},{1})";
sql = String.Format(sql,textbox1.Text,combobox1.SelectText);
SqlCommand cmd = new SqlCommand(sql,conn );
conn.Open();
cmd.ExecuteNonQuery();

Answer 1

SqlConnection conn = new SqlConnection(sqlConn );
 SqlCommand cmd = new SqlCommand("insert into 表(字段1,字段2..) value(textbox1.text.trim(),combobox.selelctvalue,datetimepacker.value,……)",conn );
conn.Open();
cmd.ExecuteNonQuery();

Answer 2

字符：'"+ text.Text1+ "'
整数： "+text.Text1+"

Answer 3

我想问一下这里面的值1怎么能变成textbox1或datetimepicker或combobox的值?比如要传textbox1和textbox1的值,可以先赋给变量,比如给test1,test2那就传value(test1,test2),也可以直接传value(textbox1.text.trim(),textbox2.text.trim())

Answer 4

来晚咯 不过写个另外的方法
SqlConnection conn = new SqlConnection(sqlConn );
 SqlCommand cmd = new SqlCommand("insert into 表(字段1,字段2..) value(@值1,@值2)",conn );
//SqlDbType后面的数据类型用表内值1,值2的数据类型
objCmd.Parameters.Add("(@值1",SqlDbType.VarChar);
objCmd.Parameters.Add("(@值2",SqlDbType.VarChar);objCmd.Parameters["@值1"].Value=tbxName.Text.Trim();
objCmd.Parameters["@值2"].Value=combobox.Text.Trim();
conn.Open();
cmd.ExecuteNonQuery();

Answer 5

objCmd.Parameters.Add("(@值1",SqlDbType.VarChar);
写错了
@前多了个(号 @_@

Answer 6

string insert="insert into 表（字段1，字段2) values('";
       insert+=textbox1.text.trim()+"','"
       insert+=textbox2.text.trim()+"')";

Answer 7

int i;
                SqlConnection conn = getConn();   
                conn.Open();
                string insert = "insert into Customers (CustomerID,CompanyName,Phone,City,Country) values('";
                insert += textBox1.Text.Trim() + "','";
                insert += textBox2.Text.Trim() + "','";
                insert += textBox5.Text.Trim() + "')";
                SqlCommand sqlcom = new SqlCommand(insert,conn);
                i = sqlcom.ExecuteNonQuery();
                conn.Close();好用的

Answer 8

SqlConnection conn = new SqlConnection("Data Source=PX-JCZX-05;Initial Catalog=wzgl;Integrated Security=True");
            conn.Open();
            string str1 = comboBox1.Text.Trim();
            string str2 = textBox3.Text.Trim();
            string str3 = comboBox2.Text.Trim();                     
            string str5 = textBox5.Text.Trim();
            string str6 = textBox7.Text.Trim();            string sqlStr = "insert into azyda(dw,xm,xb,csny,jtzz,dh,rksj) values('" + str1 + "','" + str2 + "','" + str3 + "','"dateTimePicker1.Value;"','" + str5 + "','" + str6 + "','" dateTimePicker2.Value "')";
            SqlCommand cmd = new SqlCommand(sqlStr, conn);
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            conn.Close();
这样写代码怎么提示错误?

Answer 9

提示什么错误？
string sqlStr = "insert into azyda(dw,xm,xb,csny,jtzz,dh,rksj) values('" + str1 + "','" + str2 + "','" + str3 + "','"+dateTimePicker1.Value+"','" + str5 + "','" + str6 + "','" +dateTimePicker2.Value+ "')";
你dateTimePicker少了+号。

Answer 10

string sqlStr = "insert into azyda(dw,xm,xb,csny,jtzz,dh,rksj) values('" + str1 + "','" + str2 + "','" + str3 + "',dateTimePicker1.Value,'" + str5 + "','" + str6 + "',dateTimePicker2.Value)";