this.TextBox1.Text="";

            this.TextBox2.Text="";

            this.TextBox3.Text="";

            this.TextBox4.Text="";

            this.TextBox5.Text="";

            this.BindGrid();

        }

        private void BindGrid()

        {

            SqlConnection con=new SqlConnection("server=accp-lzh;uid=sa;pwd=sasa;database=pubs");

            SqlDataAdapter mysqlcom=new SqlDataAdapter("select * from publishers where pub_id like ''''99%''''",con);

            DataSet myds=new DataSet();

            mysqlcom.Fill(myds,"publishers");

            this.DataGrid1.DataSource=myds.Tables["publishers"].DefaultView ;

            this.DataGrid1.DataBind();

        }

        /// <summary>

        /// 点击编辑时触发事件

        /// </summary>

        /// <param name="source"></param>

        /// <param name="e"></param>

        private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

        {

            this.DataGrid1.EditItemIndex=(int)e.Item.ItemIndex;

            this.BindGrid();

        }

        /// <summary>

        /// 点击取消时触发该事件。

        /// </summary>

        /// <param name="source"></param>

        /// <param name="e"></param>

        private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)

        {

            this.DataGrid1.Columns[0].HeaderText="已取消";

            this.DataGrid1.EditItemIndex=-1;

            this.BindGrid();

        }

        private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)

        {

        }

        /// <summary>

        /// 点击更新时触发该事件。

上一页  [1] [2] [3] [4] [5] [6] [7] [8]  下一页