thinkinterview » interview questions
« Previous

interview Questions

next »
question
If an SqlDataReader is populated with two result sets, how can we navigate the two result sets?
Answer Description:
SqlDataReader reader = myCommand.ExecuteReader()
if (reader.Read())
 {
  siteName = (string)reader["SiteName"];
 productName = (string)reader["ProductName"];                               
  }    
 if(reader.NextResult())
 {                                                      
    if (reader.Read())
    {
       CName = (string)reader["CustomerName"];                            
    }                                                                                     
  }

Next Queston » how 2 join tables in sql server...
how 2 join tables in sql serv... View full queston »

Posted in: ADO.NET(23) |