Support forums - can i create drop Down Textbox with databind from sqlserver 2005

Support forums » Products » Cute Editor for .NET » Re: can i create drop Down Textbox with databind from sqlserver 2005

can i create drop Down Textbox with databind from sqlserver 2005

Last post 09-13-2005, 11:17 AM by Adam. 3 replies.


	Sort Posts: Previous Next

09-12-2005, 3:17 AM 10357

anbaz
Joined on 09-08-2005
Posts 41

can i create drop Down Textbox with databind from sqlserver 2005

Reply Quote

Hi,

Am i able to customize the toolbox with new databind drop Down Textbox from sql server 2005.

if yes can you give the codings for the databind drop Down Textbox.

example :

drop Down Textbox - value 1 : singapore

drop Down Textbox value 2: USA

drop Down Textbox value3 : Canada

drop Down Textbox value4 : India.

the values come from my table in sqlSqrver2005.

09-12-2005, 4:57 AM 10366 in reply to 10357

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: can i create drop Down Textbox with databind from sqlserver 2005

Reply Quote

Yes. You need to create a server side custom button to handle this.

The example will help:

http://cutesoft.net/example/howto/RegisterCustomButton/cs/RegisterCustomButton.aspx

asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx

09-13-2005, 3:05 AM 10466 in reply to 10366

anbaz
Joined on 09-08-2005
Posts 41

Re: can i create drop Down Textbox with databind from sqlserver 2005

Reply Quote

Hi,

I tried the example given in the how to make dropdown textbox,

but i can't able to make dropdown list box databind from sqlserver 2005.

even i tried to customize the existing drop down box but how can databind from sqlserver database?

is it possible?

can u please give me the asp.net coding for databind dropdown listbox

thanks & regards,

anbaz.

09-13-2005, 11:17 AM 10481 in reply to 10466

Adam
Joined on 09-23-2003
Aurora, ON
Posts 18,678

Re: can i create drop Down Textbox with databind from sqlserver 2005

Reply Quote

Step 1:

<SELECT id="DropDownList1" name="yourDropDownList1" runat="server"></SELECT>

Step 2:

SqlConnection mycn;
SqlDataAdapter myda;
DataSet ds;
String strConn;
private void Page_Load(object sender, System.EventArgs e)
{
    if (!IsPostBack)
    {
        strConn="Data Source=localhost;uid=sa;pwd=;Initial Catalog=northwind";
        mycn = new SqlConnection(strConn);
        myda = new SqlDataAdapter ("Select * FROM CategoryTable ", mycn);
        ds = new DataSet();
        myda.Fill (ds,"Table");

        yourDropDownList1.DataSource =ds.Tables [0] ;
        yourDropDownList1.DataTextField =ds.Tables[0].Columns["CategoryName"].ColumnName.ToString();
        yourDropDownList1.DataValueField =ds.Tables[0].Columns["CategoryId"].ColumnName.ToString();
        yourDropDownList1.DataBind () ;
    }
}