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

Which .NET framework supports Web API?

1047

---

What are the event handlers that can be included in the Global.asax file?

1079

---

Why is the standalone environment only useful during the development process?

1828

---

What does session_start () do?

1088

---

What is fulltrust?

1016

---

How will you load dynamic assembly? How will create assesblies at run time?

927

---

Where web.config file is used?

1084

---

What is the significance of ASP.NET routing?

1073

---

Can a .net web application consume java web service?

955

---

How you will improve web application performance?

1035

---

What is repository pattern in mvc.net? : asp.net mvc

992

---

explain code with multi inhertance

2104

---

What is an imagemap in asp.net?

1128

---

Who is using asp.net?

936

---

What is authentication in asp.net?

1054

---