pls give me the complete code for it ..i tryed but not getting the output..pls help..iam pasting the code here but no output
SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["con"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("sql is connected");
SqlDataAdapter da = new SqlDataAdapter("select countryid,countryname from countryname", cn);
DataSet ds = new DataSet();
da.Fill(ds,"countryname");
ddlcountryname.DataSource = ds.Tables["countryname"];
ddlcountryname.DataTextField = "countryname";
ddlcountryname.DataValueField = "countryid";
ddlcountryname.DataBind();
}
protected void ddlcountryname_SelectedIndexChanged(object sender, EventArgs e)
{
string country_id;
country_id = ddlcountryname.SelectedValue.ToString();
SqlDataAdapter da1=new SqlDataAdapter("select stateid,statename from statename where countryid=' country_id'",cn);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "statename");
ddlstatename.DataSource = ds1.Tables["statename"];
ddlstatename.DataTextField = "statename";
ddlstatename.DataValueField = "stateid";
ddlstatename.DataBind();
}
my database is something like this...i have two tables countryname(countryid identity(1,1),countryname) and statename(stateid identity(100,1),statename,countryid)
so i have inserted 78 countries in country table in tat 73rd is india...
n i have inserted states of india in statename table(28)..how to get india's states wen india in selected
I did a similar one But now sure whether this helps you.
I created a table like
tblState has:
1)State_Id(int 4,Identity Increment by 1)
2)CountryName(char 50 Allow Nulls)
3)State_Name(char 50 Allow Nulls)
The code I has is in classic asp.I am posting just to give an idea for you.Hope this helps you.
Set Conn = Server.CreateObject("ADODB.Connection")
connStr = "Provider=; Driver={SQL Server}; Server=sample; Database=data; DSN=login; UID=vari; PWD=ullet;"
Conn.Open(connStr)
sql = ""
sql = "select * from tblState"
Set RS = Conn.Execute(sql)
If RS.BOF And RS.EOF Then
Error_Msg = "Database Connection Failed. Please contact the systems administrator."
Else
do until RS.EOF
region = RS.Fields("CountryName")
commid = cdbl(RS.Fields("State_Id"))
comm = RS.Fields("State_Name")
if region = region_form then
comm_options = comm_options & "<option value=" & commid & " selected>" & trim(comm) & "</option>"
else
comm_options = comm_options & "<option value=" & commid & ">" & trim(comm) & "</option>"
end if
RS.movenext
loop
End If
If you need more briefly let me know i can help you
terry
Marked 
