Populate fields from dropdown selection

Hello All,

I have a page that i built that the user can enter a project and its associated features and descriptions in. The parameters are below:

sqlCmd.Parameters.Add("@dtDate", SqlDbType.DateTime).Value = strDate;

sqlCmd.Parameters.Add("@nvchNT", SqlDbType.NVarChar).Value = strNTUser;

sqlCmd.Parameters.Add("@nvchProjectNm", SqlDbType.NVarChar).Value = strProjectName;

sqlCmd.Parameters.Add("@nvchProjectDesc", SqlDbType.NVarChar).Value = strProjectDesc;

sqlCmd.Parameters.Add("@intOccurrenceId", SqlDbType.NVarChar).Value = strOccurrenceId;

sqlCmd.Parameters.Add("@nvchOccurrence", SqlDbType.NVarChar).Value = strOccurrence;

sqlCmd.Parameters.Add("@btAutomated", SqlDbType.NVarChar).Value = bAutomated;

sqlCmd.Parameters.Add("@btManual", SqlDbType.NVarChar).Value = bManual;

sqlCmd.Parameters.Add("@intStatusId", SqlDbType.Bit).Value = strStatusId;

sqlCmd.Parameters.Add("@nvchStatusName", SqlDbType.NVarChar).Value = strStatusName;

sqlCmd.Parameters.Add("@nvchAssignedMembers", SqlDbType.NVarChar).Value = strAssignedMembers;

sqlCmd.Parameters.Add("@dtCompDate", SqlDbType.DateTime).Value = strCompDate;

basically, i have a dropdownlist ddlSearch. The user can select a project from the dropdown list. The list is populated from a table in the projects database

the columns are:

RequestDate(datetime), NTLogin, ProjectName, ProjectDesc, OccurenceId(int), Occurrence, Automated(bit), Manual(bit), statusId(int), StatusName, AssignedMembers, CompletionDate(datetime)

I want these fields to be populated depending on which ProjectName the user chooses from the ddlSearch dropdownlist. Im not sure how to get those fields to populate after making a selection as i am very new. can anyone assist with coding help in C#?

Re: Populate fields from dropdown selection

Hi kcrewjap,

You can try the following method.

<asp:DropDownList ID="ddlSearch " runat="server" Height="21px" Width="74px" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>

Please set property AutoPostBack="True" for server control dropdownlist.

Then you can add the event SelectedIndexChanged handler function.

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{

        string ProjectName = DropDownList1.SelectedValue;
        SqlConnection conn = new SqlConnection(strCon);
        conn.Open();
        string sql = "select * from TableName where ProjectName='"+ProjectName+"'";
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        dgProject.DataSource = ds;
        dgProject.DataBind();
        conn.Close();

}

Then you can bind the data with GridView, it wil ok.

Let me know if I have misunderstood what you mean.
Thanks.
Hope it helps,
Hua Jun

Re: Populate fields from dropdown selection

Thank you for your reply. Just a couple questions.

1. <asp:DropDownList ID="ddlSearch " runat="server" Height="21px" Width="74px" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>

Should it say DropDownList2_SelectedIndexChanged? or ddlSearch_SelectedIndexChanged?

2. DataSet ds = new DataSet();
        da.Fill(ds);
        dgProject.DataSource = ds;
        dgProject.DataBind();
        conn.Close();

where is the dgProject comming from?

Thanks you for your help

Re: Populate fields from dropdown selection

also im not wanting to bing this to the gridview. what i am trying to do is get the select statement to populate the textfields and checkboxes..i included the variables and the field names in my initial post.

thanks

Re: Populate fields from dropdown selection

kcrewjap

1. <asp:DropDownList ID="ddlSearch " runat="server" Height="21px" Width="74px" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>

Should it say DropDownList2_SelectedIndexChanged? or ddlSearch_SelectedIndexChanged?

If you let the VS generates the event for you then basically it will generate like "ddlSearch_SelectedIndexChanged"..As you noticed It will just append the ID of the control to the event SelectedIndexChange.. But in that case you have mentioned it does not matter if you use DropDownList2_SelectedIndexChanged or ddlSearch_SelectedIndexChanged for as long as it will match the event handler in your code behind.. see below

<asp:DropDownList ID="ddlSearch " runat="server" Height="21px" Width="74px" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged" AutoPostBack="True">

if using the above declaration then event handler method should look like this below

protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{

}

Or you declare it this way

<asp:DropDownList ID="ddlSearch " runat="server" Height="21px" Width="74px" OnSelectedIndexChanged="ddlSearch _SelectedIndexChanged" AutoPostBack="True">

Then your event handler method should look like this below

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{

}

Hope you get it..

kcrewjap

2. DataSet ds = new DataSet();
        da.Fill(ds);
        dgProject.DataSource = ds;
        dgProject.DataBind();
        conn.Close();

where is the dgProject comming from?

dgProject is the ID of your Grid control that you are using..

Re: Populate fields from dropdown selection

kcrewjap

also im not wanting to bing this to the gridview. what i am trying to do is get the select statement to populate the textfields and checkboxes..i included the variables and the field names in my initial post.

What about this

private void FillTextBoxes(string ProjectName)
{

        SqlConnection conn = new SqlConnection(strCon);
        conn.Open();
        string sql = "select * from TableName where ProjectName='"+ProjectName+"'";
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
          if (dt.Rows.Count > 0)
            {
                TextBox1.Text= dt.Rows[0]["ColumnName"].TosTring(); //Where column name us the Fields for your Table that you wanted to display in the TextBoxes
                TextBox2.Text= dt.Rows[0]["ColumnName"].TosTring();
            }
       conn.Close();

}

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{

FillTextBoxes(DropDownList1.SelectedValue);

}

Re: Populate fields from dropdown selection

awesome. but what if you have a radiobuttonlist? how do you populate that from the database? rblStatus

Re: Populate fields from dropdown selection

kcrewjap

awesome. but what if you have a radiobuttonlist? how do you populate that from the database? rblStatus

Same steps

private void FillRBL(string ProjectName)
{

                      RadioButtonList1.DataSource = dt;
                      RadioButtonList1.DataTextField = "ColumnName"; // DataTextField is where the Fields are being displayed in RBL Text
                      RadioButtonList1.DataValueFieild = "ColumnName"; //DataValueFieild usually contains the ID of the fields
                    RadioButtonList1.DataBind();
            }
       conn.Close();

}

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{

FillRBL(DropDownList1.SelectedValue);

}

Re: Populate fields from dropdown selection

and for a dropdownlist

i have

ddlOccurrence.SelectedValue = dt.Rows[0]["Occurrence"].ToString();

however it doesnt like the SelectedValue nor SelectedIndex.. which option to i put for a ddl?

Thanks for all of your time and help

Re: Populate fields from dropdown selection

kcrewjap

ddlOccurrence.SelectedValue = dt.Rows[0]["Occurrence"].ToString();

however it doesnt like the SelectedValue nor SelectedIndex.. which option to i put for a ddl?

If you wanted to add Items in your DropDownList then have it this way

string strItem = dt.Rows[0]["Occurrence"].ToString();
ddlOccurrence.Items.Add(strItem);

Re: Populate fields from dropdown selection

so let me make sure im understanding you right. the ddl that i am referring to is one that will be populated with whatever is in the database for that field when all fillprojectfields method is called.. this is not the original ddl where they select the project to populate..

Re: Populate fields from dropdown selection

kcrewjap

so let me make sure im understanding you right. the ddl that i am referring to is one that will be populated with whatever is in the database for that field when all fillprojectfields method is called.. this is not the original ddl where they select the project to populate..

I'm confused here.. What exactly you are trying to do?

Re: Populate fields from dropdown selection

sorry. I have a page that has a handfull of textboxes, dropdownlists, radiobuttons and checkboxlists. at the top i have a dropdownlist of ProjectNames. when the user selcts a projectname from the dropdownlist, i am trying to have the rest of the fields populated based on that selection. make sense?

Re: Populate fields from dropdown selection

Yes i understand but you cannot assign SelectedValue and SelectedItem.Tex on DDL and RBL you need to use Items.Add method to add items on DDL and RBL based on DDL from ProjectNames... see below..

private void FillDT(string ProjectName)
{

        SqlConnection conn = new SqlConnection(strCon);
        conn.Open();
        string sql = "select * from TableName where ProjectName='"+ProjectName+"'";
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
          if (dt.Rows.Count > 0)
            {
                TextBox1.Text= dt.Rows[0]["ColumnName1"].TosTring(); //Where column name us the Fields for your Table that you wanted to display in the TextBoxes
                TextBox2.Text= dt.Rows[0]["ColumnName2"].TosTring();
                DropDownList1.Items.Add(dt.Rows[0]["ColumnName3"].TosTring());
                RadioButtonList1.Items.Add(dt.Rows[0]["ColumnName4"].TosTring());
                CheckBoxList1.Items.Add(dt.Rows[0]["ColumnName5"].TosTring());
            }
       conn.Close();

}

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)
{

FillDT(DropDownList1.SelectedValue);

}

Did you get it?

Re: Populate fields from dropdown selection

Hey Vincent,

The textboxes fill, but the ddl's dont display what should be displayed from the database, they just look like im adding a new project "Please Choose". any suggestions?

Re: Populate fields from dropdown selection

kcrewjap

The textboxes fill, but the ddl's dont display what should be displayed from the database, they just look like im adding a new project "Please Choose". any suggestions?

Post your codes here so that we can check it out... BTW does your DDL contains multiple data?if you only want to add a single value from database then use TextBox instead..

Re: Populate fields from dropdown selection

Here is my code so far. i have got everything to work except one part. In the database that this project is pulled by there is a checkboxlist (names of people working on project) when the project is initially stored, it stores all the checkboxes that are checked as numbers in a string. what i would like to do is on the update page (code below) i want to comapare the checkboxlist against the database values adn then make the appropriate checkboxes in the list be checked or not checked according to whats in the database. Heres an example of how thenames are stored as a sting in the database

column name = AssignedMemebers

CheckboxList = cblAssignedMembers

raw data in database = 2, 4, 5, 6 numbers represent different checkboxes(names) checked in the cbl.

Here is my update code so far. everything works now except the cblAssignedMembers

Thanks

protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e)

{

FillProjectFields(ddlSearch.SelectedValue);

}

private void FillProjectFields(string strProjectName)

{

SqlConnection conn = new SqlConnection(Conn.CLNXCnnString());

conn.Open();

string sql = "select * from tblAddProject where ProjectName='" + strProjectName + "'";

SqlCommand cmd = new SqlCommand(sql, conn);

SqlDataAdapter da = new SqlDataAdapter(cmd);DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

txtDate.Text = dt.Rows[0]["RequestDate"].ToString();

txtChangeUser.Text = dt.Rows[0]["NTLogin"].ToString();

txtProjectName.Text = dt.Rows[0]["ProjectName"].ToString();

txtProjectDesc.Text = dt.Rows[0]["ProjectDesc"].ToString();

ddlOccurrence.Items.Add(dt.Rows[0]["Occurrence"].ToString());

if(dt.Rows[0]["Occurrence"].ToString() == "Reoccurring")

{

ddlOccurrence.SelectedValue = "Reoccurring";

}

else if (dt.Rows[0]["Occurrence"].ToString() == "One Time")

{

ddlOccurrence.SelectedValue = "One Time";

}

rblOccurrance.Items.Add(dt.Rows[0]["Automated"].ToString());

rblOccurrance.Items.Add(dt.Rows[0]["Manual"].ToString());

ddlStatus.Items.Add(dt.Rows[0]["StatusName"].ToString());if (dt.Rows[0]["StatusName"].ToString() == "New")

{

ddlStatus.SelectedValue = "New";

}

else if (dt.Rows[0]["StatusName"].ToString() == "Assigned")

{

ddlStatus.SelectedValue = "Assigned";

}

else if (dt.Rows[0]["StatusName"].ToString() == "Complete")

{

ddlStatus.SelectedValue = "Complete";

}

cblMembersAssigned.Items.Add(dt.Rows[0]["AssignedMembers"].ToString());

txtCompletionDate.Text = dt.Rows[0]["CompletionDate"].ToString();

}

conn.Close();

}

Re: Populate fields from dropdown selection

I'm not sure if this is really what you need but i hope this will give you an idea

Put this snippet below after conn.Close();

for (int i=0; i <cblMembersAssigned.Items.Count; i++)
{
    if (cblMembersAssigned.Items[i].Text = "Values to compare here")
    {
        if it's equal then check the items in the CHeckBox
        cblMembersAssigned.Items[i].Selected = true;
    }
}

Re: Populate fields from dropdown selection

where it says "Values to compare here" in that string can i put "1, 2, 3, 4, 5, 6"??