DataSourceID="srcyr" DataTextField="year" >

</asp:DropDownList>

<asp:SqlDataSource ID="srcyr" runat ="server"

SelectCommand="select year from tyear">

</asp:SqlDataSource>

I am trying to bind these two colum but system is giving me parser error --any one have any idea?

here's the code:-

DataTextField="org" DataValueField="year">

</asp:DropDownList>

<asp:SqlDataSource ID="srcOrg" runat ="server"

SelectCommand="select org from org where year=2003">

</asp:SqlDataSource>

1. In srcOrg datasource, you are fetching only "org"  column, but in ddlorg dropdownlist, datavaluefield is "year" which you are not selecting from that datasource.

2. Is your web config has a connection string, "StudetsConnectionString"

3. Is it studentsconnectionstring or studetsconnectionstring?

if still not solved, post your detailed exact error. if possible, post screen shot of that error.

You should avoid the keyword as your column name.You can change the year column to something like myYear. Do the same for the frst one.

DataValueField="myYear">

select org, myYear from org where myYear=2003