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();
}
}
}
}

What is the namespace to create thread in .net?

910

---

What is csrf attack in asp.net?

972

---

What is difference between inproc and outproc?

1094

---

What's the use of response.output.write()?

1223

---

What is anonymous authentication?

1099

---

Explain the difference between array and linkedlist?

945

---

What are the advantages and limitations of query string?

1005

---

Define repository pattern in asp.net mvc? : asp.net mvc

957

---

Which authentication uses a combination of windows and iis authentication?

1032

---

What is css and what is it used for?

955

---

Whats the difference between registerclientscriptblock, registerclientscriptinclude and registerclientscriptresource?

1011

---

What does asp in asp.net stand for?

936

---

Explain asp.net page life cycle?

1042

---

explain code with datachaching with example

2106

---

What is a session government?

859

---