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 use of base keyword? Tell me a practical example for base keyword’s usage?

0 Answers  

---

What are extensions in c#?

0 Answers  

---

What is Custom attribute? How to create? If I'm having custom attribute in an assembly, how to say that name in the code?

0 Answers  

---

How many types of interface are there in c#?

0 Answers  

---

what is master pages how to use it. plase give one example in code vice

1 Answers  

---

Can we have a non static member function in a base class to be override in derived with static modifier?

7 Answers   Wipro,

---

How does c# generics and c++ templates compare?

0 Answers  

---

What are the different states of a thread?

0 Answers  

---

What is a pre-requisite for connection pooling?

1 Answers  

---

What does Dispose method do with the connection object?

2 Answers  

---

how to stored and retrive video in Sql server using asp.net c#......?

0 Answers   Sans Pareil IT Services,

---

I am using a data table and a datagridview. I am creating two columns in data grid view : 1)DataGridViewComboBoxColumn 2)DataGridViewTextBoxColumn. The items of datagridviewcombo are the list of all items in data table column 1. I want that the data type of the DataGridViewTextBoxColumn should be the same as the data type of the item selected from the datagridviewcombo at runtime. How can I do that.Also I want that each cell in column of datatable should be of variable data type. Pls help. thnx.

1 Answers   Storm,

---