Answer / karthikeyan

String connectionString = @"Data
Source=.\SQLExpress;Initial Catalog=Nwind;Integrated
Security=SSPI";
SqlConnection con = new SqlConnection(connectionString);
string conString = "Select * From Customers";
SqlDataAdapter dataAdpter = new SqlDataAdapter(conString,
con);
DataSet ds = new DataSet();
dataAdpter.Fill(ds);
ds.Tables[0].Columns[0].ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];

Answer / deepak ray

Just retrieve the id from database using reader or dataset
and store the id in a string.
and
set the string in a public readonly property like this.


string _UserId;
public string UserId
{ get { return _UserId; } }

SqlDataReader dr = null;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
_UserId = dr["UserId"].ToString();
}
dr.Close();
dr.Dispose();

What is Asynchronous call and how it can be implemented using delegates?

0 Answers  

---

What is static class in C#?

0 Answers   Winsol Solutions,

---

What is the difference between overriding and overloading in systemverilog?

0 Answers  

---

How can we convert XML Data to DataBase Table in C#.Net?

2 Answers   Wipro,

---

Is system a class in c#?

0 Answers  

---

How can I develop an application that automatically updates itself from the web?

0 Answers  

---

What is msil in c#?

0 Answers  

---

What is icomparable in c#?

0 Answers  

---

What is difference between static and readonly in c#?

0 Answers  

---

Why do I get a "cs5001: does not have an entry point defined" error when compiling?

0 Answers  

---

What is indexers in C#

4 Answers   Bodhtree,

---

Why do we Need of static class in c#?

0 Answers   NA,

---