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 the difference between readonly and const

4 Answers   Emphasis,

---

Why do we need oops in c#?

0 Answers  

---

Why abstract class can not be instantiated?

0 Answers  

---

What is the purpose of reserved word using in c#?

0 Answers  

---

What is parallel programming in c#?

0 Answers  

---

What is a hash table in c#?

0 Answers  

---

Is std :: string null terminated?

0 Answers  

---

What is parameters in c#?

0 Answers  

---

Hello Friends..am Mohammed riyash..final year BCA in Jamal Mohamed College 2009. Trichy. My doubt is while connecting SQL2005 Built in Database withing the Visual Studio 2005 Framework.. I am getting the error.. That " An Error occurred and it may be due to , under the default settings of the Server, the connection cannot be established.." But the code works in MS Access for me.. Both in VB.Net and C#.Net am getting the same error.. Any genius please Message me to 9994558822 or mail me.. riyash.ips@gmail.com

3 Answers  

---

What is console readkey ()?

0 Answers  

---

Where are all .NET Collection classes located ?

8 Answers   TCS,

---

Can you explicitly call a destructor?

0 Answers  

---