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

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency

4 Answers   Digital Group,

---

What are three methods for displaying data in a syncfusion datagrid

0 Answers  

---

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

0 Answers  

---

Why do we use sqldataadapter?

0 Answers  

---

What is two way data binding android?

0 Answers  

---

Why edit is not possible in repeater?

0 Answers  

---

What is the meaning of object pooling?

0 Answers  

---

Difference between function and trigger?

1 Answers   HCL,

---

How can we save all data from dataset?

0 Answers  

---

Can you explain how to enable and disable connection pooling?

0 Answers  

---

How do you update a dataset in ado.net?

0 Answers  

---

can we change the data in dataset? if yes what is the process?

1 Answers   Artech,

---