ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 224 Page Views: 

How do you check if connection to SQL server is open?



Posted By: Avi Date: 14 October 2010 10:15:48 AM
 Answer:

By using ConnectionState property


Posted By: avibtech


Date: 14 October 2010 10:15:48 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image GIJV36
Related Questions
ADO.Net : What does the ExecuteScalar() method?

What does the ExecuteScalar() method?

ExecuteScalar returns first column of first row from result set.
Category: ADO.Net Date: 10/14/2010 11:39:47 PM
ADO.Net : How do you delete row using dataset?

How do you delete row using dataset?

By calling Delete() method on given row
Category: ADO.Net Date: 10/14/2010 10:57:48 PM
ADO.Net : What is typed dataset?

What is typed dataset?

Is a class that derives from a DataSet and provides strongly typed method, events and properties. Ad....
Category: ADO.Net Date: 10/14/2010 9:02:47 PM
ADO.Net : How do you refresh dataset?

How do you refresh dataset?

By calling one more time Fill method on DataAdapter
Category: ADO.Net Date: 10/14/2010 9:02:47 PM
ADO.Net : How do you define in connection string that SqlConnection should use SQL Server authentication?

How do you define in connection string that SqlConnection should use SQL Server authentication?

By specifying User ID and Password and setting Integrated Security to false
Category: ADO.Net Date: 10/14/2010 8:10:48 PM