Datagrid view for MSaccess table

Question

0.00/5 (No votes)

See more:

C#

How to display selected fields in data grid view from MSaccess table . .Can anyone help in this .

Posted 12-Oct-13 8:34am

Raghavendra M

Add a Solution

2 solutions

Solution 1

Did you read the answer from OriginalGriff to your Question "Database Retriving Code"?
Database retriving code[^]
Same principle applies, just change

myListBox.DataSource = dt;

to

myDtatgridview.DataSource = dt;

Posted 12-Oct-13 8:44am

Richard.Berry100

Comments

Raghavendra M 12-Oct-13 14:48pm

Yes this i knw but i m having truble in displaying selected column . . & yes I red the previous soln . .

Raghavendra M 12-Oct-13 14:53pm

try
{
//String typ = "1BHK";
string str = "select particulars,quality,quantity,boxes from additems where fno=" + fn + "and receiptno=" + rn + "";
OleDbDataAdapter DAap = new OleDbDataAdapter(str, mycon);
DataSet DS = new DataSet();
DAap.Fill(DS, "additems");
DataTable DT = DS.Tables[0];
dataGridView1.ColumnCount = 4;
dataGridView1.DataSource = DT;
dataGridView1.Columns[0].Name = "Particulars";
dataGridView1.Columns[1].Name = "Quality";
dataGridView1.Columns[2].Name = "Quantity";
dataGridView1.Columns[3].Name = "Boxes";
dataGridView1.DataMember = "particulars";
dataGridView1.DataMember = "quality";
dataGridView1.DataMember = "quantity";
dataGridView1.DataMember = "boxes";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Real Estate... ", MessageBoxButtons.OK, MessageBoxIcon.Error);

}

this is my code but it is not showing contents of table

Richard.Berry100 12-Oct-13 15:21pm

I seldom use a dataset. What happens if you just put: dataGridView1.DataSource = DT;

and leave out all the code after that. If your select statement has 4 coulums, those should be displayed.

Also, put a breakpoint before you assign the datatable as the datasource for the dtatgridvied, and hover over the datatable. Are you sure the datatable contains data?

you could also put a statement like

MessageBox.Show("Datatable contains " + DT.Rows.Count + " Rows");
dataGridView1.DataSource = DT;

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mohitsaxena1 · Accepted Answer · 2013-10-12T09:35:00

Hi,
Two line code is ok for your requirement. first all you are already write four column in your query so don't need define column name and assign data member property.

XML

DataTable DT = DS.Tables[0]

    dataGridView1.DataSource = DT;


if you need hide some column so just write the code
dataGridView1.Columns["Boxes"].Visible = false;

one more point: your query is not correct, need more space before and condition.

  string str = "select particulars,quality,quantity,boxes from additems  where fno=" + fn + " and receiptno=" + rn + ""; 

I hope that it is useful for u.

Thanks