c# 数据库 插入功能 insert 语句 values怎么填

Question

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace WebApplication1 {     public partial class CmdDataReadInsert : System.Web.UI.Page     {         private String Strconnection;         private String str;         private SqlConnection conn;         private SqlCommand cmd;         private SqlDataAdapter da;         protected void Page_Load(object sender, EventArgs e)         {             Strconnection= "Data Source =.; Initial Catalog = student; Integrated Security = True";             conn = new SqlConnection(Strconnection);             str = "select * from xsdata";             da = new SqlDataAdapter(str,conn);             SqlCommandBuilder cb = new SqlCommandBuilder();         }         protected void Button1_Click(object sender, EventArgs e)         {             try             {                 conn.Open();                 string sqltable = string.Format("select * from xsdata");                 string insertstu = string.Format("insert into xsdata(Sxh,Sxm,Sxb,Scsrq,Szy,Sdk,Ssfzh,Sjg,Sjtdz)values ");                 SqlDataAdapter da = new SqlDataAdapter(sqltable,conn);                 DataSet ds = new DataSet();                 da.Fill(ds);                 DataRow dr = ds.Tables[0].NewRow();                 dr["Sxh"] = this.Sxh.Text;                 dr["Sxm"] = this.Sxm.Text;                 dr["Sxb"] = this.Sxb.SelectedValue.ToString();                 dr["Scsrq"] = Convert.ToDateTime(this.Scsrq.Text);                 dr["Szy"] = this.Szy.SelectedValue.ToString();                 dr["Sdk"] = this.Sdk.SelectedValue.ToString();                 dr["Ssfzh"] = this.Ssfzh.Text;                 dr["Sjg"] = this.Sjg.Text;                 dr["Sjtdz"] = this.Sjtdz.Text;                 ds.Tables[0].Rows.Add(dr);                 da.InsertCommand = new SqlCommand(insertstu, conn);                 da.Update(ds);                 conn.Close();             }             catch (SqlException se)             {                 Response.Write(se.Message.ToString());             }                         }     } }c# 连接数据库做插入功能  insert 语句的 values 应该怎么填

Answer 1

insert into xsdata (Sxh,Sxm,Sxb,Scsrq,Szy,Sdk,Ssfzh,Sjg,Sjtdz) values (value1, value2...)

值对应就行了