How to bind data to gridview's textbox column

Question

Hi all.

I am new to windows application development.

I am using gridview that has all DataGridViewTextBoxColumn.

My code for binding the data to the grid view in Form_Load() is :

private void Form1_Load(object sender, EventArgs e)
{
cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Bill\\dbBill.accdb");
string query = "Select Sr,Desc,HSNCode,Qty,Rate,Qty*Rate as Amount from BillDetail";
cn.Open();
cmd = new OleDbCommand(query, cn);
da = new OleDbDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
cn.Close();

grdDetails.DataSource = ds;
}
But I am not getting the records.

Please help.

Thanks in advance.

Satyapriya Nayak · Answer

Try private void Form1_Load(object sender EventArgs e) { cn = new OleDbConnection(Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Bill\dbBill.accdb); string query = Select SrDescHSNCodeQtyRateQty*Rate as Amount from BillDetail; cn.Open(); cmd = new OleDbCommand(query cn); da = new OleDbDataAdapter(cmd); ds = new DataSet(); da.Fill(dsBillDetail); grdDetails.DataMember = BillDetail; grdDetails.DataSource = ds; cn.Close(); }

kim hsu · Answer

AutoGerenealColumn=true

Kailash Chandra Behera · Answer

can you wite the field name and the code you have written for column

Riyaz Kalva · Answer

Thanks for answer. I set the property but still not getting the record.

Kailash Chandra Behera · Answer

before binding grid with database set daabase columnt name to grid column property named 'DatapropertyName'