Sql Query Inner Join
-
How to use inner join in stored procedure..? And use that data to show up in dropdownlist on my page..?
Hi, check these links to understand about INNER JOIN http://sqltutorials.blogspot.in/2007/05/sql-inner-join-left-join-and-right-join.html[^] http://www.w3resource.com/sql/joins/perform-an-inner-join.php[^] So, use those concepts and frame the query which 1 or more columns for dropdownlist as DataMember and Value member.
Vande Matharam - Jai Hind
-
How to use inner join in stored procedure..? And use that data to show up in dropdownlist on my page..?
INNER JOIN Table2 t2 ON t1.Column = t2.Column and then take result from SP to a Dataset or Datatable and use .DataSource property of DropdownList - Happy Coding - Vishal Vashishta
-
INNER JOIN Table2 t2 ON t1.Column = t2.Column and then take result from SP to a Dataset or Datatable and use .DataSource property of DropdownList - Happy Coding - Vishal Vashishta