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!");

Explain the ADO . Net Architecture ( .Net Data Provider) ?

2 Answers  

---

Describe connection object in ado.net

0 Answers  

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,

---

What is data view and variable view?

0 Answers  

---

what is different between SqlCommand object and Command Behaviour Object

3 Answers  

---

What is ole in vb?

0 Answers  

---

What is datatable in ado.net?

0 Answers  

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

0 Answers  

---

Is ado.net dead?

0 Answers  

---

once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

---

differance between ADO vs ADO.Net?

0 Answers   MCN Solutions,

---

What is the main difference between ADO and ADO.Net

4 Answers   HCL,

---