62,047
社区成员
发帖
与我相关
我的任务
分享
string sqlstrb = ConfigurationManager.AppSettings["constr"];
SqlConnection conb = new SqlConnection(sqlstrb);
conb.Open();
string strb = "insert into tOrderProductInformation(ID,Name,Age,Date,Major) values(@ID,@Name,@Age,@Date,@Major)";
SqlCommand cmdb = new SqlCommand(strb, conb);
cmdb.Parameters.Add("@ID", SqlDbType.VarChar).Value = 你要插入的id;
cmdb.Parameters.Add("@Name", SqlDbType.VarChar).Value = 你要插入的姓名;
cmdb.Parameters.Add("@Age", SqlDbType.VarChar).Value =你要插入的年龄;
cmdb.Parameters.Add("@Date", SqlDbType.VarChar).Value = 你要插入的入学日期;
cmdb.Parameters.Add("@Major", SqlDbType.VarChar).Value = 你要插入的专业;
cmdb.ExecuteNonQuery();
cmdb.Dispose();
conb.Close();
conb.Dispose();
protected void Button1_Click(object sender, EventArgs e)
{
string str = ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter sda = new SqlDataAdapter("select * from students", con);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
try
{
con.Open();
cmd.CommandText = "insert into students values (@ID,@Name,@Age,@Date,@Major)";
sda.InsertCommand = cmd;
sda.InsertCommand.Parameters.Add("@ID", SqlDbType.NChar);
sda.InsertCommand.Parameters.Add("@Name", SqlDbType.NChar);
sda.InsertCommand.Parameters.Add("@Age", SqlDbType.NChar);
sda.InsertCommand.Parameters.Add("@Date", SqlDbType.NChar);
sda.InsertCommand.Parameters.Add("@Major", SqlDbType.NChar);
sda.InsertCommand.Parameters["@ID"].Value = TextBox1.Text;
sda.InsertCommand.Parameters["@Name"].Value = TextBox2.Text;
sda.InsertCommand.Parameters["@Age"].Value = TextBox3.Text;
sda.InsertCommand.Parameters["@Date"].Value = TextBox4.Text;
sda.InsertCommand.Parameters["@Major"].Value = TextBox5.Text;
sda.Update(ds);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
}
finally
{
if (con != null)
{
con.Close();
}
}
}