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 |
What are different types of Delegates in C#?
What does it meant to say “the canonical” form of XML ?
Error handling and how this is done ?
What is form feed and carriage return?
What is the difference between list and array in c#?
C# called c sharp why?
can you tell me what are the steps should follow to do delay signing.
Are classes passed by reference in c#?
What is jagged array?
What is base class in c#?
Where does the dispose method lie and how can it be used to clean up resources?
What is default method in c#?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)