filling the textbox,dropdownlist from the database?? : The Official Microsoft ASP.NET Forums

Reply

filling the textbox,dropdownlist from the database??

Jan 21, 2008 11:14 AM|LINK

hello everyone..

i have a question..may be you can help.

i have a web form with server controls like textbox, dropdownlist, radio button, label etc.its a user registration form..

now what i want here is..when ever i choose a option from the dropdownlist. i want all the controls like textbox, dropdownlist etc to be

automatically filled up by the data related to that option in the dropdownlist..i want this data to be fetched from the data that is stored in the sql database.

how is it done..

anybody??

thanks..

Reply

Re: filling the textbox,dropdownlist from the database??

Jan 21, 2008 12:57 PM|LINK

Hi,

You need to call dropdownlist selected index changed event, in that fetch data from releated table and assign them to the text boxes.

If you are using ajax then you have to put all controls inside the updatepanel except and dropdown list and you can set the async postback trigger
as dropdownlist selected index changed event

otherwise you can use icallback

HTH

With Luv
Dhana

Dont forget to mark as answer if my reply helped you...

Marked as answer by Xun Ye - MSFT on Jan 23, 2008 05:28 AM

Reply

Re: filling the textbox,dropdownlist from the database??

Jan 21, 2008 01:19 PM|LINK

Hi,

I assumed that you have A dropdownlist in your webform and lets say two textboxes.. Here i am using a DataTable as my DataSource

So first populate your DropDownList with a data from your database

// A method that Populates your DropDownList

private void BindDDL()
{

    using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnString"]) // calling up your connection string that was configured in you Web Config File
        {
            DataTable dt = new DataTable();

                conn.Open();
        String sql = "SELECT Category FROM Table1"
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Connection.Open();
                cmd.ExecuteNonQuery();

        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        ad.Fill(dt);

        if (dt.Rows.Count > 0)
        {
            DropDownList1.Items.Add("Select");
            for (int i = 0; i < dt.Rows.Count; i++)
                    {

                        Cat = dt.Rows[i]["Category"].ToString();
                        DropDownList1.Items.Add(Cat);
                    }

        }
        cmd.Connection.Close();


        }
}

// A method that fetches the data from the dataBase based on the SELECTED ITEM FROM THE DropDownList

private void FetchData()
{
    using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnString"]) // calling up your connection string that was configured in you Web Config File
        {
            DataTable dt = new DataTable();

                conn.Open();
        String sql = "SELECT * FROM Table2 WHERE Category = '" +DropDownList1.SelectedItem.Text+ "'"
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.Connection.Open();
                cmd.ExecuteNonQuery();

        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        ad.Fill(dt);

        if (dt.Rows.Count > 0)
        {
            //If you want to get mutiple data from the database then you need to write a simple looping
            TextBox1.Text = dt.Rows[0]["Field1"].ToString();
            TextBox2.Text = dt.Rows[0]["Field2"].ToString();
        }
        cmd.Connection.Close();


        }

}

protected void Page_Load(object sender, EventArgs e)
{

    if (!Page.IsPostBack)
    {
        BindDDL();
    }

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

        FetchData();

   }

Hope my suggestion helps

Vincent Maverick Durano, MVP
MessageBox Controls for WebForms | Blog | Twitter | Linkedin

Marked as answer by Ivan Xin - MSFT on Jan 23, 2008 03:01 AM

Reply

jack007

Member

165 Points

588 Posts

Re: filling the textbox,dropdownlist from the database??

Jan 23, 2008 06:08 AM|LINK

Hi Vinz,

Thanks for the tips.

well i did exactly what u wrote.

but as soon as i select a item from a dropdownlist..

there displays a messagebox stating

"connectionstring property has not been initialized"

whats the problem here? any solution..

and why did u use datatable here..

thanks..

Reply

jack007

Member

165 Points

588 Posts

Re: filling the textbox,dropdownlist from the database??

Jan 23, 2008 06:18 AM|LINK

Hi Dhana

But how do i fetch data from related table and assign them to the text boxes in the dropdownlist selected index changed event.

and how can i accomplish this using Ajax.can u help me with some example or codes to do this..

thanks

Reply

dhanabalanr

Participant

978 Points

181 Posts

Re: filling the textbox,dropdownlist from the database??

Jan 23, 2008 08:57 AM|LINK

Hi jack,

here i've given the sample source code with database details

create table testtable1(id int,usrname varchar(50),usrage int)


insert into testtable1 values(1,'user1',20)
insert into testtable1 values(2,'user2',22)
insert into testtable1 values(3,'user3',25)
insert into testtable1 values(4,'user4',27)
insert into testtable1 values(5,'user5',29)
insert into testtable1 values(6,'user6',31)
insert into testtable1 values(7,'user7',33)
insert into testtable1 values(8,'user8',35)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="t-1208420.aspx.cs" Inherits="DropDownList_t_1208420" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
      <asp:ScriptManager ID ="ScripManager1" runat ="server"></asp:ScriptManager>
      <div>
        <asp:DropDownList ID ="ddl1" runat ="server" OnSelectedIndexChanged="ddl1_SelectedIndexChanged" AutoPostBack ="true">
        </asp:DropDownList>                     
    </div>
      <div>   
        <asp:UpdatePanel runat ="server" ID="UpdPnl">
          <ContentTemplate>   
            <table>   
              <tr>
                <td>
                  <asp:TextBox ID ="txtName" runat ="server"></asp:TextBox>                
                </td>
                <td>
                  <asp:TextBox ID ="txtAge" runat ="server"></asp:TextBox>                
                </td>
              </tr>
            </table>
          </ContentTemplate>
          <Triggers>
            <asp:AsyncPostBackTrigger ControlID ="ddl1" EventName ="SelectedIndexChanged" />
          </Triggers>
        </asp:UpdatePanel>
      </div>
    </div>
    </form>
</body>
</html>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class DropDownList_t_1208420 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            AssignDDLDataSource();
            ddl1_SelectedIndexChanged(null, null);
        }
    }

    private void AssignDDLDataSource()
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();
        string sqlQry = "SELECT ID DISPMEM, ID VALMEM FROM TESTTABLE1";
        SqlCommand cmd = new SqlCommand(sqlQry,con);
        ddl1.DataSource = cmd.ExecuteReader();
        ddl1.DataTextField = "DISPMEM";
        ddl1.DataValueField = "VALMEM";
        ddl1.DataBind();
    }

    private SqlConnection CreateConnection()
    {
        SqlConnection con = new SqlConnection("Enter your connection string details");
        return con;
    }

    private void AssignTextBoxValues(string val)
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();
        string sqlQry = "Select id,usrname,usrage from testtable1 where id = '" + val + "'";
        SqlCommand cmd = new SqlCommand(sqlQry, con);
        SqlDataReader rdr = cmd.ExecuteReader();
        while (rdr.Read())
        {
            txtName.Text = rdr["usrname"].ToString().Trim();
            txtAge.Text = rdr["usrage"].ToString().Trim();
        }
    }
    protected void ddl1_SelectedIndexChanged(object sender, EventArgs e)
    {
        AssignTextBoxValues(ddl1.SelectedValue);
    }
}

HTH

With Luv
Dhana

Dont forget to mark as answer if my reply helped you...

Reply

vinz

All-Star

126946 Points

17922 Posts

MVP

Re: filling the textbox,dropdownlist from the database??

Jan 23, 2008 11:19 AM|LINK

Be sure that you have set a connectionstring in your webconfig file.. Note that I am using appSettings there in setting my connection string.. so you should have something like this below

In you Web. Config file add this

<appSettings>
<add key="ConnString" value="Data Source=<Sql Server Name>;Initial Catalog=<Name of Database>;Integrated Security=SSPI;"/>
</appSettings>

Vincent Maverick Durano, MVP
MessageBox Controls for WebForms | Blog | Twitter | Linkedin

Reply

jack007

Member

165 Points

588 Posts

Re: filling the textbox,dropdownlist from the database??

Jan 24, 2008 08:04 AM|LINK

hello vinz..

thanks.it worked till the limit..

but now as soon as i pick a option from dropdownlist there pops up another error message box stating "the connection was not closed.the connection's

current state is open."

any clue..

thanks..

Reply

jack007

Member

165 Points

588 Posts

Re: filling the textbox,dropdownlist from the database??

Jan 24, 2008 08:30 AM|LINK

hi dhana..

thanks for the clue..

but i didnt get the meaning of this statement.

string sqlQry = "SELECT ID DISPMEM, DISPMEM FROM TESTTABLE1";

what does ID DISPMEM,DISPMEM  means here.

and next question.

can i populate dropdown list or listbox from the database in similar way as with textboxes.

and how should i pass my connection string here.

thanks.

Reply

vinz

All-Star

126946 Points

17922 Posts

MVP

Re: filling the textbox,dropdownlist from the database??

Jan 24, 2008 11:14 AM|LINK

Hi Jack,

Sorry for the late reply.. Anyway try to have it this way

private void BindDDL()
{

    using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnString"]) // calling up your connection string that was configured in you Web Config File
        {
            DataTable dt = new DataTable();

                if (conn.State == ConnectionState.Open) // validates if the connection state is open
                { conn.Close(); }

                conn.Open();
                String sql = "SELECT Category FROM Table1"
                SqlCommand cmd = new SqlCommand(sql, conn);

                cmd.ExecuteNonQuery();

           SqlDataAdapter ad = new SqlDataAdapter(cmd);
               ad.Fill(dt);

           if (dt.Rows.Count > 0)
            {
              DropDownList1.Items.Add("Select");
                   for (int i = 0; i < dt.Rows.Count; i++)
                       {

                        Cat = dt.Rows[i]["Category"].ToString();
                        DropDownList1.Items.Add(Cat);
                        }

            }
               conn.Close();


        }
}

Let me know if it wont work..

Vincent Maverick Durano, MVP
MessageBox Controls for WebForms | Blog | Twitter | Linkedin

filling the textbox,dropdownlist from the database?? RSS

72 replies

jack007

filling the textbox,dropdownlist from the database??

dhanabalanr

Re: filling the textbox,dropdownlist from the database??

vinz

Re: filling the textbox,dropdownlist from the database??

jack007

Re: filling the textbox,dropdownlist from the database??

jack007

Re: filling the textbox,dropdownlist from the database??

dhanabalanr

Re: filling the textbox,dropdownlist from the database??

vinz

Re: filling the textbox,dropdownlist from the database??

jack007

Re: filling the textbox,dropdownlist from the database??

jack007

Re: filling the textbox,dropdownlist from the database??

vinz

Re: filling the textbox,dropdownlist from the database??

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft