Hello,
pls I av an sql table like this
arc | depId | TempId | TempName
--------------------------------------------------
1 A 1 Ade
1 A 2 wole
1 A 3 SEYI
1 B 1 ZANI
1 B 2 SUYT
1 C 2 ACE
1 C 1 DAS
1 C 2 QWER
2 A 1 ASQ
2 B 1 ERE
2 C 1 CD
2 B 1 DCDS
2 B 2 CQA
3 A 1 CSAS
3 B 1 BGFF
3 C 1 QSES
so i am working on cascading dropdownlist. when I passed the parameters as follows
char FolderID = Convert.ToChar(folderdetails["DepId"]);
conn.Open();
SqlCommand cmd = new SqlCommand("Select * From Trade WHERE depId = @depId", conn);
cmd.Parameters.AddWithValue("@depId", FolderID);
cmd.ExecuteNonQuery();
it only returns t ...
Go to the complete details ...