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 can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers  

---

About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

1 Answers   MMTS,

---

How do you update a dataset in ado.net?

0 Answers  

---

What is the use of sqldatareader class?

0 Answers  

---

What is connection string?

0 Answers  

---

What are major difference between classic ADO and ADO.NET?

2 Answers  

---

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

9 Answers   Wipro,

---

Explain the overview of ado.net architecture?

0 Answers  

---

What are dcl commands?

0 Answers  

---

how can implement dropdownlist in particular of dataset when try to update?

0 Answers   TCS,

---

What is meant by executenonquery?

0 Answers  

---

What DataReader class do in ADO.NET ?

0 Answers   NA,

---