Multiple Select Statement in stored procedure
-
Sir, In my ASP.NET application I have the dashboard. Number of records needs to be fetched from database into it. Hence,I want to write stored procedure which gives me these records using multiple Select statements. Is it possible to fetch it? If yes how it can be done. Thanx :)
-
Sir, In my ASP.NET application I have the dashboard. Number of records needs to be fetched from database into it. Hence,I want to write stored procedure which gives me these records using multiple Select statements. Is it possible to fetch it? If yes how it can be done. Thanx :)
Multiple select statements will return as a single datatset having more than one data tables. For example, if the stored procedure is executing 3 select statements, the dataset returned will have three data tables. You can refer them as ds.Tables[0], ds.Tables[1], ds.Tables[3], and so on.
-
Multiple select statements will return as a single datatset having more than one data tables. For example, if the stored procedure is executing 3 select statements, the dataset returned will have three data tables. You can refer them as ds.Tables[0], ds.Tables[1], ds.Tables[3], and so on.
Thanx boss !!! Its working with minor changes as =ds.Tables[0].Rows[0][0].ToString(); Thanx a lot! :)