Re:Textbox绑定基于列表框选择 [英] Re:Textbox binding Base on List box selection

问题描述

列表框SelectedIndexChanged事件我写了一些用于绑定文本框的代码，但未绑定SelectedIndexChanged事件，为什么问题是什么，请帮助我一个人

请在下面的

Hi,
List box SelectedIndexChanged event i written some code for binding of textbox but it is not binding SelectedIndexChanged event why what is the issue pls help me any one

Pls find code snippet below

protected void lstAvailableroles_SelectedIndexChanged(object sender, EventArgs e)
{
    if (lstAvailableroles.SelectedValue != null)
    {
        string role_id = lstAvailableroles.SelectedValue.ToString();
         String strConnString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
         using (SqlConnection mySqlConnection = new SqlConnection(strConnString))
         {
             try
             {
                 mySqlConnection.Open();
                 SqlCommand mySqlCommand = new SqlCommand("SELECT Role_ID,Role_Name,Description FROM roles", mySqlConnection);
                 SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySqlCommand);
                 DataSet myDataSet = new DataSet();
                 mySqlDataAdapter.Fill(myDataSet, "roles");
                 clsencryption.decryptDataSet(myDataSet);
                 txtDescription.Text = myDataSet.Tables[0].Rows[0]["Description"].ToString();
                 txtDescription.DataBind();

             }
             catch (Exception ex)
             {

             }
         }

    }
}

推荐答案

您可以直接分配TextBox的Text属性.试试这个:

You can directly assign the Text property of TextBox. Try this:

using (SqlConnection mySqlConnection = new SqlConnection(strConnString))
{
     try
     {
         mySqlConnection.Open();
         SqlCommand mySqlCommand = new SqlCommand("SELECT Role_ID,Role_Name,Description FROM roles", mySqlConnection);
         SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySqlCommand);
         DataSet myDataSet = new DataSet();
         mySqlDataAdapter.Fill(myDataSet, "roles");
         clsencryption.decryptDataSet(myDataSet);
         if(myDataSet != null){
             //Checking for null value
             if(myDataSet.Tables[0].Rows[0]["Description"] != DBNull.Value){
                txtDescription.Text = myDataSet.Tables[0].Rows[0]["Description"].ToString();
             }
         }
         //txtDescription.DataBind();
     }
     catch (Exception ex)
     {

     }
}

--Amit

--Amit

这篇关于Re:Textbox绑定基于列表框选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！