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

Reply

dhanabalanr

Participant

978 Points

181 Posts

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

Jan 24, 2008 12:56 PM|LINK

Hi Jack,

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

"SELECT ID DISPMEM, ID VALMEM FROM TESTTABLE1"

dispmem is DataTextField for ddl and valmem is DataValueField for ddl

for your second question answer is yes. In that way only i've populated the ddl

copy my sample code and run it in a test page.

HTH

With Luv
Dhana

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

Reply

jack007

Member

165 Points

588 Posts

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

Jan 25, 2008 04:24 AM|LINK

hi vinz,

sorry it did not work.i copied the code and paste it.but it prompts me with the same error msg.

i also tried by removing this line of code : conn.Open();

but it shows another error message saying : invalid object name 'addressbook'.

here addressbook is the name of the table in my database.

any clue..

thanks.

Reply

jack007

Member

165 Points

588 Posts

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

Jan 25, 2008 04:34 AM|LINK

hi dhana..

thanks for the answer..

but my 2nd question was not that.

what i meant was , in the example u showed me, there u could select a option from

the dropdownlist and get ur textboxes automatically populated by the data in the database.there's no problem till here.

but my question is,

similarly, can i select a option in the dropdownlist and populate listbox, another dropdownlist , radio button , checkbox instead of textbox?

thanks..

Reply

dhanabalanr

Participant

978 Points

181 Posts

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

Jan 25, 2008 06:28 AM|LINK

HI Jack,

Yes we can do that also

here is my sample(i modified the previous source code it self)

database updates

alter table testtable1 add gender char(1)( u need to update the gender values in the testtable1)  


create table testtable2 values (id int, subject varchar(10))


insert into testtable2 values (1,'A')
insert into testtable2 values (1,'B')
insert into testtable2 values (1,'C')
insert into testtable2 values (1,'D')
insert into testtable2 values (1,'E')
insert into testtable2 values (1,'F')
insert into testtable2 values (1,'G')
insert into testtable2 values (1,'H')


insert into testtable2 values (2,'A')
insert into testtable2 values (2,'B')
insert into testtable2 values (2,'C')
insert into testtable2 values (3,'D')
insert into testtable2 values (3,'E')
insert into testtable2 values (3,'F')
insert into testtable2 values (4,'G')
insert into testtable2 values (4,'H')


insert into testtable2 values (4,'A')
insert into testtable2 values (4,'B')
insert into testtable2 values (5,'C')
insert into testtable2 values (5,'D')
insert into testtable2 values (5,'E')
insert into testtable2 values (6,'F')
insert into testtable2 values (6,'G')
insert into testtable2 values (6,'H')

1    <%@ 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:DropDownList ID ="ddl2" runat ="server"></asp:DropDownList>
                </td>
                <td>
                  <asp:RadioButton ID ="rdoBtnMale" runat ="server" GroupName ="Gender" Text ="Male" />
                  <asp:RadioButton ID ="rdoBtnFeMale" runat ="server" GroupName ="Gender" Text ="Female" />
                </td>
              </tr>
              <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("Data Source=10.100.1.66;Initial Catalog=mirage;Persist Security Info=True;User ID=mirage;Password=mirage");
        return con;
    }

    private void AssignTextBoxValues(string val)
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();

        AssignSubjectDDL(val);
        string sqlQry = "Select id,usrname,usrage,gender 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();
            if (rdr["gender"].ToString().Trim() == "M")
            {
                rdoBtnMale.Checked = true;
                rdoBtnFeMale.Checked = false;
            }
            else if (rdr["gender"].ToString().Trim() == "F")
            {
                rdoBtnMale.Checked = false;
                rdoBtnFeMale.Checked = true;
            }
            else
            {
                rdoBtnMale.Checked = false;
                rdoBtnFeMale.Checked = false;
            }
        }
    }

    private void AssignSubjectDDL(string val)
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();
        string sqlQry = "SELECT SUBJECT DISPMEM, SUBJECT VALMEM FROM TESTTABLE2 where id = '" + val + "'";
        SqlCommand cmd1 = new SqlCommand(sqlQry, con);
        ddl2.DataSource = cmd1.ExecuteReader();
        ddl2.DataTextField = "DISPMEM";
        ddl2.DataValueField = "VALMEM";
        ddl2.DataBind();

    }
    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

jack007

Member

165 Points

588 Posts

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

Jan 25, 2008 09:29 AM|LINK

Hi Dhana..

Thank you very much for the code.

See the code u gave me works very fine when ever i copy-paste and run it.

but whenever i try to include it in my existing project in doesnot work.

since i m very new to ajax, i could have made mistake.

anyway, let me tell u my project scenario more clearly ok.

See i have a web form.In that i have used Asp.net Ajax cascading drop down list.

so when ever i choose a option from the first dropdownlist the related data gets automatically populated in

the second drop down list..Its completely working till here..

now my problem is when ever i choose a option from the second dropdownlist i want the related data to that option to be

filled in rest of the textboxes ,listbox, radiobuttons etc in my web form..hope u r getting my point.

my cascading dropdownlist is working fine.only when i choose a option from second dropdownlist the related data(from database) is not showing in rest

of the controls at all.

and i am not using database to populate my dropdownlist.(i m using xml file)

well can anything be done to accomplish this.?

Thanks..

Jack.

Reply

dhanabalanr

Participant

978 Points

181 Posts

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

Jan 25, 2008 10:42 AM|LINK

Hi Jack,

jack007
and i am not using database to populate my dropdownlist.(i m using xml file)

How do you populate the both DDL? Both using XML?

Didnt you using DataBase?

can you give me a sample xml?

With Luv
Dhana

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

Reply

jack007

Member

165 Points

588 Posts

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

Jan 27, 2008 04:47 AM|LINK

Hi Dhana.

If you want to see how this works..then check the following link.

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/CascadingDropDown/CascadingDropDown.aspx

and if you want to get the full source code and xml file u can get using this link.

http://www.codeplex.com/AtlasControlToolkit/Release/ProjectReleases.aspx?ReleaseId=8513

well i didn't do it by myself. i just downloaded the code from the above site and made little bit

modification..i hope u could play around with it too.

ok dhana..lets have another scenario here.(like u said)

lets say i use my sqldatabase to populate both the dropdownlist.then after selecting the the option from the second dropdownlist i get a required

textboxes,listboxes filled automatically from the database.lets say option for the first dropdownlist comes from 1st table and the option for

the 2nd dropdownlist and the remaining data to be populated in the textboxes comes the 2nd table.

well i dont know idea to do this..any tips on how can i accomplish this?

thanks.

Jack..

Reply

dhanabalanr

Participant

978 Points

181 Posts

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

Jan 28, 2008 10:04 AM|LINK

Ok Jack,

here is the sample code as you want

DataBase Queries

create table teamtable (teamcode int, teamname varchar(10))
insert into teamtable values(1,'teamA')
insert into teamtable values(2,'teamB')
insert into teamtable values(3,'teamC')


create table teammemtable(teamcode int, memcode int, memname varchar(50), memage int, memgndr char(1))
insert into teammemtable values(1,1,'dhana',27,'M')
insert into teammemtable values(1,2,'balan',27,'M')
insert into teammemtable values(1,3,'deepa',24,'F')


insert into teammemtable values(2,1,'balaji',26,'M')
insert into teammemtable values(2,2,'thunaivan',35,'M')
insert into teammemtable values(2,3,'geetha',28,'F')


insert into teammemtable values(3,1,'jibin',21,'M')
insert into teammemtable values(3,2,'rajan',27,'M')
insert into teammemtable values(3,3,'uma',26,'F')

aspx page

<%@ 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:DropDownList ID ="ddl2" runat ="server" OnSelectedIndexChanged="ddl2_SelectedIndexChanged" AutoPostBack ="true"></asp:DropDownList>
                </td>
                <td>
                  <asp:RadioButton ID ="rdoBtnMale" runat ="server" GroupName ="Gender" Text ="Male" />
                  <asp:RadioButton ID ="rdoBtnFeMale" runat ="server" GroupName ="Gender" Text ="Female" />
                </td>
              </tr>
              <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>

CS file

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 TEAMNAME DISPMEM, TEAMCODE VALMEM FROM TEAMTABLE";
        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("Data Source=yourservername;Initial Catalog=database;Persist Security Info=True;User ID=username;Password=password");
        return con;
    }

    private void AssignTextBoxValues(string teamval,string memval)
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();

        //AssignSubjectDDL(val);
        string sqlQry = "Select MEMNAME,MEMAGE,MEMGNDR from TEAMMEMTABLE where TEAMCODE = '" + teamval +"' AND MEMCODE = '" + memval + "'";
        SqlCommand cmd = new SqlCommand(sqlQry, con);
        SqlDataReader rdr = cmd.ExecuteReader();
        while (rdr.Read())
        {
            txtName.Text = rdr["MEMNAME"].ToString().Trim();
            txtAge.Text = rdr["MEMAGE"].ToString().Trim();
            if (rdr["MEMGNDR"].ToString().Trim() == "M")
            {
                rdoBtnMale.Checked = true;
                rdoBtnFeMale.Checked = false;
            }
            else if (rdr["MEMGNDR"].ToString().Trim() == "F")
            {
                rdoBtnMale.Checked = false;
                rdoBtnFeMale.Checked = true;
            }
            else
            {
                rdoBtnMale.Checked = false;
                rdoBtnFeMale.Checked = false;
            }
        }
    }

    private void AssignSubjectDDL(string val)
    {
        SqlConnection con = CreateConnection();
        if (con.State != ConnectionState.Open)
            con.Open();
        string sqlQry = "SELECT MEMNAME DISPMEM, MEMCODE VALMEM FROM TEAMMEMTABLE where TEAMCODE = '" + val + "'";
        SqlCommand cmd1 = new SqlCommand(sqlQry, con);
        ddl2.DataSource = cmd1.ExecuteReader();
        ddl2.DataTextField = "DISPMEM";
        ddl2.DataValueField = "VALMEM";
        ddl2.DataBind();
        ddl2_SelectedIndexChanged(null, null);

    }
    protected void ddl1_SelectedIndexChanged(object sender, EventArgs e)
    {
        AssignSubjectDDL(ddl1.SelectedValue);
    }
    protected void ddl2_SelectedIndexChanged(object sender, EventArgs e)
    {
        AssignTextBoxValues(ddl1.SelectedValue,ddl2.SelectedValue);
    }
}

HTH. Let me know the results

With Luv
Dhana

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

Reply

jack007

Member

165 Points

588 Posts

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

Jan 28, 2008 11:17 AM|LINK

Hello Dhana,

First of all Thanks a lot for clarifying the concept with such an easy

example.

Well i was going too deep.But the solution u gave seems very appropriate and short.

Anyway i need to first import this code in my project and see how it works.

If there is any problem i ll surely inform you.

Anyway thankyou very much.

jack..

Reply

dhanabalanr

Participant

978 Points

181 Posts

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

Jan 28, 2008 03:41 PM|LINK

Hi Jack,

Thanks. Let me know the results

With Luv
Dhana

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

filling the textbox,dropdownlist from the database?? RSS

72 replies

dhanabalanr

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

jack007

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??

jack007

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

dhanabalanr

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

jack007

jack007

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

dhanabalanr

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??

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

Follow Us On:

Microsoft