= new SqlParameter("@telephone", TextBox3.Text);
SqlParameter p4 = new SqlParameter("@pic", "images/" + fn);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.CommandText = "update zhigong set where number=@number";
conn.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
Response.Write("
");
conn.Close();
Showdata();
}
protected void Button4_Click(object sender, EventArgs e)
{
string fn = FileUpload1.FileName;
string fpath = Server.MapPath("images/");
string fullname = fpath + fn;
SqlConnection id=sa;password=sa";
SqlCommand cmd=new SqlCommand();
cmd.Connection=conn;
SqlParameter p1 = new SqlParameter("@number", TextBox1.Text);
SqlParameter p2 = new SqlParameter("@bumen", TextBox2.Text);
SqlParameter p3 = new SqlParameter("@telephone", TextBox3.Text);
SqlParameter p4 = new SqlParameter("@pic", "images/" + fn);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.CommandText="delete from zhigong conn.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
Response.Write("
");
conn.Close();
Showdata();
}
}
where number=@number";
conn=new SqlConnection();
conn.ConnectionString = "server =127.0.0.1;initial catalog=stu-044;user
bumen=@bumen, telephone=@telephone,pic=@pic
添加按钮示意图
查询按钮示意图
修改按钮示意图
删除按钮示意图