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

What is the use of sqldatareader class?

0 Answers  

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  

---

What are the different layers of ado.net?

0 Answers  

---

What is sqldatareader?

0 Answers  

---

What is ado.net components?

0 Answers  

---

How do you sort the data in datagrid?

4 Answers   Choice Solutions,

---

What is difference between datagridview and datagrid control in winforms?

0 Answers  

---

What is data control techniques?

0 Answers  

---

What is disconnected architecture in ado.net?

0 Answers  

---

What is two way data binding android?

0 Answers  

---

What is difference between datatable and dataset?

0 Answers  

---

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

0 Answers  

---