向DataGrid、DropDownList控件添加数据

string conStr=ConfigurationManager.AppSettings["ConStr"];

SqlConnection  conn=new SqlConnection(conStr);

protected void Page_Load(object  sender, EventArgs  e)

{

 if(! IsPostBack){

  BindCategory();

  BindDropNewsCategory();

}

else

{

return ;

}

}

void BindCategory()

{

    string sql="select * from NewsCategoryInfo";

   SqlDataAdapter  da=new SqlDataAdapter(sql,conn);

    DataSet  ds=new DataSet();

    da.Fill(ds);

    if(ds.Table[0].Rows.Count>0)

    {

         GridView1.DataSource=ds.Table[0];

          GridView1.DataBind();

     }

void  BindDropNewsCategory()

{

    string sql="select * from NewsCategoryInfo";

   SqlDataAdapter  da=new SqlDataAdapter(sql,conn);

    DataSet  ds=new DataSet();

    da.Fill(ds);

     DropDownList1.DataTextField="NewsCategoryName";

     DropDownList1.DataValueField="NewsCategoryID";

     DropDownList1.DataSource=ds.Table[0];

       GridView1.DataBind();

     }

}

protection void Button_Click(object  sender ,EventArgs e)

{

      string  sql="insert into  NewsCategoryInfo (NewsCategoryName)value('+"txtCategoryName"+')";

      SqlCommand  cmd=new SqlCommand(sql ,conn);  // 建立执行命令与数据库的关联

       conn.Open(); // 打开数据库

       int i=cmd.ExecuteNonQuery(); //执行命令

       conn.Close();// 关闭数据库

     if (i>0)

      {

         Response.Write("添加成功“）;

         BindCategory();

       }

}

protection void Button1_Click(object  sender ,EventArgs e)

{

      int OkNewsCategoryID =Convert.ToInt32(DropDownList1.SelectedValue);

      Respons.Write("添加成功”）;

}