老蔡实验8gridview详细信息以及删除功能

1、老蔡的实验运行结果:单击详细信息：单击删除按钮：主要实现步骤：1：建立MedcineDB数据库，其中包含一张表Medcine2:添加一个DB类：其中有三个函数，代码如下：public static SqlConnection createCon() SqlConnection sqlconn=new SqlConnection(server=.;database=EmployDB;uid=sa;pwd=;); return sqlconn; public void gvDataBind(GridView gv,string sqlstr) SqlConnection sqlconn = DB.

2、createCon(); SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlconn); DataSet myds = new DataSet(); myda.Fill(myds); gv.DataSource = myds; gv.DataBind(); sqlconn.Close(); public void DataCom(string sqlstr) SqlConnection sqlconn = DB.createCon(); SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);

3、 sqlcom.ExecuteNonQuery(); sqlconn.Close();说明省略。3：程序有两个页面：页面一：Default.aspx其中代码如下：DB db = new DB(); protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) string sqlstr = select * from Medcine; GridView1.DataKeyNames = new string MedcineID ; db.gvDataBind(GridView1, sqlstr); protected

4、void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) string sqlstr = delete from Medcine where MedcineID=+GridView1.DataKeyse.RowIndex.Value+; db.DataCom(sqlstr); Response.Redirect(Default.aspx); protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) if (e.Row.R

5、owType = DataControlRowType.DataRow) (LinkButton)(e.Row.Cells4.Controls0).Attributes.Add(onclick,return confirm(确定要删除吗？); （记住，后面这两个代码是要触发gridview事件的，千万不要copy，I Hate it）页面二，showDetails.aspx其中代码如下：protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) SqlConnection sqlconn = DB.createCo

6、n(); string sqlstrshowDetails = select * from Medcine where MedcineID= + Request.QueryStringMedcineID.ToString() + ; SqlDataAdapter myda = new SqlDataAdapter(sqlstrshowDetails, sqlconn); DataSet myds = new DataSet(); myda.Fill(myds, Medcine); DataRowView mydrview = myds.TablesMedcine.DefaultView0; T

7、extBox1.Text = Convert.ToString(mydrview.RowMedcineID); TextBox2.Text = Convert.ToString(mydrview.RowMedcineName); TextBox3.Text = Convert.ToString(mydrview.RowMedcinePrice); TextBox4.Text = Convert.ToString(mydrview.RowMedcineType); TextBox5.Text = Convert.ToString(mydrview.RowMedcineIntro); sqlconn.Close(); 在做的时候，要学会思