Display Data In Data Grid View

[Aakarshan.d]

Hello, I am learning the C#. net and while learning it, I have got one problem of the displaying the data in the data grid view. If anyone is having information from which I can able to solve this problem then please provide me that. It will be helpful to me. I have tried it, but unable to get the solution. So, if you provide me help then I can do it.

[kelfro]

I have created code below for displaying the Data in the data grid. It will be helpful to you to understand it. But, test it, as I have not compiled it.

SqlConnection connection = new SqlConnection("Data Source =.\\SQLEXPRESS; AttachDbFilename = "+C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\sgbd.mdf "+"; Integrated Security = True; Connect Timeout = 30; User Instance = True");
            try
            {
                login.Open();
                string query = ("SELECT * FROM Agent_1");
                CC adaptation OleDbDataAdapter = new OleDbDataAdapter("query","Connection");
                OleDbCommandBuilder Cbulder = new OleDbCommandBuilder(CC adaptation);
                DataTable = JTable new DataTable();
                CC adaptation.Fill(JTable);
                DataGridView dgView = new DataGridView();
                BindingSource bSource = new BindingSource();
                bSource.DataSource = JTable;
                dgView.DataSource = BSource;
                CC adaptation.Update(JTable);
                dgView.DataSource= JTable;                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                login.Close();
            }

[Zecho]

As you know the DataGridView is the control which is used for the showing data from the various outside sources. It also provides you rows and columns for controlling and working on the data. If you make binding of the control with the data source then you can simply create the columns automatically based on your tables of the data source. If also provide you the facility of the hiding, deleting and managing them. It also provide you the facility of the unbounding of the data columns.

[Reegan]

It is having following features:

• By the help of it you can simply able to mix the bound and unbound data and also virtual columns in your Gridview.
• It simply provide you the facility of the virtual mode.
• You will able to get the styles for the different columns, rows or for the complete table.

[opaper]

The code provided by the kelfro requires one change as below:

OleDbDataAdapter = CC adaptation new OleDbDataAdapter(query, connection);

Instead of ... "query","login");
Then it will work fine. Else you will get the error as below:

The format of the initialization string does not conform to specification starting at index 0

[MindSpace]

Display Data In Data Grid View source code:

private void Testing_Load(object  Send, System.EventArgs e)
{
OleDbDataAdataadapterpter dataadapter = new OleDbDataAdataadapterpter("SELECT * FROM Emp","Provider=Microsoft.JET.OLEDB.4.0;dataadapterta source=C:\\mcb.mdb" );
DataSet dataset = new DataSet();
dataadapter.Fill(dataset, "Emp");
dataadaptertaGrid1.DataSource = dataset.Tables["Emp"].DefaultView ;
}

This is quiet simple code and I don't think it needs any sort of explanation. So, read it carefully and understand it.