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();

Howmany five tracing levels in System.Diagnostics.TraceSwitcher? Why they are using?

0 Answers   Siebel,

---

Why var is used in c#?

0 Answers  

---

What is an escape sequence in c#?

0 Answers  

---

What is desktop example?

0 Answers  

---

How is lazy loading achieved?

0 Answers  

---

Explain the difference between abstract class and interface.

0 Answers   Accenture,

---

What are class fields?

0 Answers  

---

public void A() { int x; x = 8; x *= 4 + 8 / 2; } Given the above code, what is the value of "x"?

8 Answers  

---

How can you read 3rd line from a text file?

0 Answers  

---

What is the difference between values and reference types?

0 Answers   Alcatel-Lucent,

---

What is difference between array and collection?

0 Answers  

---

why C++ Partial Object Oriented Programming Language and C# and Java Fully Object Oriented Language

11 Answers   3i Infotech, Alexa, Assyst, Naresh i Technologies, TCS,

---