Answer Posted / nitin kumar
Steps for 1. Using a SqlConnection
// Fully Commented Code
using System;
using System.Data;
using System.Data.SqlClient;
class SqlConnectionDemo
{
static void Main()
{
// 1. Instantiate the connection
SqlConnection conn = new SqlConnection(
"Data Source=(local);Initial
Catalog=Northwind;Integrated Security=SSPI");
SqlDataReader rdr = null;
try
{
// 2. Open the connection
conn.Open();
// 3. Pass the connection to a command object
SqlCommand cmd = new SqlCommand("select * from
Customers", conn);
//
// 4. Use the connection
//
// get query results
rdr = cmd.ExecuteReader();
// print the CustomerID of each record
while (rdr.Read())
{
Console.WriteLine(rdr[0]);
}
}
finally
{
// close the reader
if (rdr != null)
{
rdr.Close();
}
// 5. Close the connection
if (conn != null)
{
conn.Close();
}
}
}
}
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Why web api is better than wcf?
What is recordset asp?
What are the different validators in asp.net?
How many types of server controls do we have?Also explain differance between them taking an example of ASP.NET?
How you can return View from ASP.NET Web API method?
Write a code snippet to implement the indentation in json in web api.
What is client side state management?
What is asp.net and ado net?
Apart from IDE what are the enhancements in asp.net 2.0?
What is data caching?
How you will improve web application performance?
How to integrate angular 8 with asp.net mvc 5? : Asp.Net MVC
Where is the session stored?
What is a web based system?
How we implement web farm and web garden concept in asp.net?
