Hi there,

I decided to start off learning C# by doing come datagrid stuff.

My problem is that I don't know how to select a few columns from a full table when I am trying to display all the data on a datagrid.

The code I am running is here:

namespace ECN

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

// TODO: This line of code loads data into the 'eCNFormsDataSet.ECN_Main' table. You can move, or remove it, as needed.

this.eCN_MainTableAdapter.Fill(this.eCNFormsDataSet.ECN_Main);

this.MaximizeBox = false;

}

private void button1_Click(object sender, EventArgs e)

{

this.eCN_MainTableAdapter.ClearBeforeFill = true;

this.eCN_MainTableAdapter.Fill("Want to fill this with specific Columns.");

}

}

}

Can anyone give me some suggestions? I already tried to look online, but the solutions are too complex for what I think should be a really simple problem. Thanks in advance!

Ke

If you are trying to limit the data returned from the database, change the SQL select statement that is used by the table adapter. If you are trying to limit thefields from the datasource that are displayed in the DataGridView, set the AutoGenerateColumns property to false, and then explicitly create the columns for the fields you want to display.

to programmatically select columns, have you tried this?

this.theDataGridView.Columns[index].Selected = true;

this will select a column at the specified index. Is this what you are after?

If you are trying to limit the data returned from the database, change the SQL select statement that is used by the table adapter. If you are trying to limit thefields from the datasource that are displayed in the DataGridView, set the AutoGenerateColumns property to false, and then explicitly create the columns for the fields you want to display.

Thanks for the reply! ^_^

I think this will be very helpful, but what I had in mind was for the datagrid to display the columns or rows I want by using C# commands, and not using SQL. Is this possible?

Thanks,

Ke

to display the columns and rows of data? Well you can, just bind the datagrid to the datasource (dataset)

this.theDataGrid.DataSource = theDataSet.Tables[index].DefaultView;

is this what you are after? It will display all the records in the dataset/datatable into the datagrid

That's why I said: