(ASP.NET)修改和删除DataGrid行——数据库访问

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

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

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

        {

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

            SqlCommand selectCmd=con.CreateCommand();

            selectCmd.CommandType=CommandType.Text;

            selectCmd.CommandText="select * from publishers where pub_id like ''''99%''''";

            SqlDataAdapter sqlAdatper=new SqlDataAdapter();

            sqlAdatper.SelectCommand=selectCmd;

            DataSet ds=new DataSet();

            con.Open();

            sqlAdatper.Fill(ds,"publishers");

            con.Close();

            SqlCommand updateCmd=con.CreateCommand();

            updateCmd.CommandText="update publishers set pub_name=@pubname,city=@city,state=@state,country=@country where pub_id=@pub_id";

            SqlParameter PubNamePar=new SqlParameter("@pubname",SqlDbType.VarChar,40,"pub_name");

            updateCmd.Parameters.Add(PubNamePar);

            SqlParameter CityPar=new SqlParameter("@city",SqlDbType.VarChar,20,"city");

            updateCmd.Parameters.Add(CityPar);

            SqlParameter StatePar=new SqlParameter("@state",SqlDbType.Char,2,"state");

            updateCmd.Parameters.Add(StatePar);

            SqlParameter CountryPar=new SqlParameter("@country",SqlDbType.VarChar,30,"country");

            updateCmd.Parameters.Add(CountryPar);

            SqlParameter PubIDPar=new SqlParameter("@pub_id",SqlDbType.Char,4,"pub_id");

            PubIDPar.SourceVersion=DataRowVersion.Original;

            updateCmd.Parameters.Add(PubIDPar);

            sqlAdatper.UpdateCommand=updateCmd;

            DataTable table=ds.Tables["publishers"];

            table.PrimaryKey=new DataColumn[]

                {

                    table.Columns["pub_id"]

                };

            DataRow row=table.Rows.Find(((TextBox)(e.Item.Cells[2].Controls[0])).Text);

            row["pub_name"]=((TextBox)(e.Item.Cells[3].Controls[0])).Text;

            row["city"]=((TextBox)(e.Item.Cells[4].Controls[0])).Text;

            row["state"]=((TextBox)(e.Item.Cells[5].Controls[0])).Text;

            row["country"]=((TextBox)(e.Item.Cells[6].Controls[0])).Text;

            con.Open();

     &nb

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

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18