How to manually bind data to dropdownlist (hard coded)

[denvercr]

hi guys just want to get input from you on how can i bind data to a dropdownlist manually or in hard code?..

How can I use ObjectDataSource for this binding? or is there any other way?..

Thanks..

[pintum]

How to bind data to dropdownlist (hard coded) ,send the Code of this forum

[pintum]

Please send the code immidiate

[denvercr]

Hi Pintum,

Im so sorry for this late reply. I was out of the office already when you responded to my post on how can i possibly bind data to dropdownlist. Hope you could stil help me out.

Here is my code when Im trying to use ObjectDataSource to bind data to dropdownlist. I tried to run this in Visual Web Developer but I cannot figure out the error. I just patterned this code on tags on autamatically created by the IDE.

Dim filterByQuarterAdapter As New filterSaveTrainingResult_DataSetTableAdapters.sear chSaveDistinctQuarter_TableAdapter

Dim filterDistinctQuarter_ObjectDataSource AsNew ObjectDataSource
filterDistinctQuarter_ObjectDataSource.ID = "filterDistinctQuarter_ObjectDataSource"
filterDistinctQuarter_ObjectDataSource.OldValuesPa rameterFormatString = "original_{0}"
filterDistinctQuarter_ObjectDataSource.SelectMetho d = "filterByQuarterAdapter.GetData_ByQuarter"


Me.filterResult_DropDownList.DataSourceID = "filterDistinctQuarter_ObjectDataSource"
Me.filterResult_DropDownList.DataTextField = "quarter"
Me.filterResult_DropDownList.DataValueField = "quarter"


Me.filterResult_DropDownList.DataSource = filterByQuarterAdapter.GetData_ByQuarter.DataSet


If its confusing to you about the code, Is there a way I can send the proper arrangement of code to you so you can read it clearly? thank you so much.. you can reply direct on my email add at: [e-mail]. I will be waiting for your reply..

[nmsreddi]

hi

u can bind data dynamically from datadase by suing dataset,

SqlConnection con=new SqlConnection(" connection string");
SqlCommand cmd =new SqlCommand("query",con);
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt=new DataTable();
dt=ds.Tables[0];
DropDownList1.DataSource=dt;
DropDownList1.DataTextField=dt.Columns[1].ColumnName;

DropDownList1.DataBind();



this is comple code in c# al the best


regards

nmsreddi

[denvercr]

hi nmreddi,

very good idea!!! =) thank you so much..

regards to you.