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

Differentiate between authentication and authorization.

970

---

Why do we need Sessions?

1041

---

what is silver light when will we use silver light,

1905

---

Explain serialization and deserialization?

1022

---

If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?

1090

---

Can you use c# without .net?

979

---

Out of ASP or ASP.NET which one is stateless?

1231

---

Where is asp.net view state stored?

1004

---

Why session is used in asp.net?

1026

---

Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?

2375

---

How to display Alert in ASP.NET

1175

---

Define web.config in .net?

1075

---

What is application state?

911

---

How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

979

---

Explain about ASP.NET?

1087

---