C# Code for How to set readonly property to Id(database)
value?
Answers were Sorted based on User's Feedback
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];
Is This Answer Correct ? | 10 Yes | 1 No |
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();
Is This Answer Correct ? | 10 Yes | 6 No |
Distinguish between a class and struct?
What is the difference between an implicit conversion and an explicit conversion?
What is disco?
what is the diference between casting and converting?
What is delay signing..??
What is a pre-requisite for connection pooling?
What is hashset c#?
Is dictionary a collection?
You are creating a custom usercontrol, some of the newly created properties are shown in the properties window. How you can hide a new property named theme from the properties window?
Can int be null in c#?
how can i get this 123456789 1234 6789 123 789 12 89 1 9
Difference between value and reference type. What are value types and reference types?