Answer / kalirajan

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection

SqlConnection con = new
SqlConnection("server=localhost;database=Grid_Db;uid=sa;pwd=;");

con.Open();

SqlCommand cmd = new SqlCommand("select * from Gtid_Tbl",con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();

Answer / khalid

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection
//If u provide uname & passwd to ur Database then this state //is true
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;uid=sa;pwd=;");
//else
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;");

con.Open();
if(con!=null)
msgbox("Connection sucessfully Done!");
else
msgbox("Sorry!Connection sucessfully is not Done!");

How do you handle data concurrency in .NET ?

9 Answers   Infogain, SunGard,

---

What is the use of SqlCommand object?

0 Answers  

---

What is dbcontext and dbset in entity framework?

0 Answers  

---

What are datareaders?

0 Answers  

---

What is a sqldataadapter?

0 Answers  

---

How we can provide data to ado.net?

0 Answers  

---

What is the meaning of object pooling?

0 Answers  

---

How to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

---

Where does ADO.NET and XML web services come in the architecture ?

1 Answers   IBM, TCS,

---

What is the difference between connected and disconnected environment?

0 Answers  

---

What is the meaning of executenonquery?

0 Answers  

---

What is the provider being used to access oracle database?

0 Answers  

---