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 to aggregating data across related tables?

0 Answers  

---

Which architecture does Datasets follow?

0 Answers  

---

What is openrowset?

0 Answers  

---

Some important instruction regarding ADO.NET connection string ?

0 Answers   NA,

---

Being fresher How would i answer to the question that what is your salary exception?

4 Answers  

---

What are the parameters that control most of connection pooling behaviours?

0 Answers  

---

how to keep track of index in listbox items.

2 Answers  

---

Explain how to find the given query is optimised one or not?

0 Answers  

---

Explain the difference between an ado.net dataset and an ado recordset?

0 Answers  

---

What is the difference between ado.net and entity framework?

0 Answers  

---

Which is faster datareader or dataadapter?

0 Answers  

---

What is the default view of Data Grid?

5 Answers   TCS,

---