Cant reach the datagridview1 control

yokzu

Hi,
Im facing a weird problem. I am just adding a DataGridView control to my program's interface. Then I am passing the Form1.cs then wanna write some codes with this control but VS can not see this control. I mean can not identify. All codes below ;
------------------------------------

private void button1_Click(object sender, EventArgs e)
        {
            string query = "Data Source=1.1.1.1;Initial Catalog=mdb;User Id=user;Password=qweasd;";
            SqlConnection conn = new SqlConnection(query);
            conn.Open();

            DataTable data_table = new DataTable();

            SqlDataAdapter sql_adapter = new SqlDataAdapter("SELECT * FROM table", conn);
            sql_adapter.Fill(data_table);

            datagridview1.Fill ......    --> I cant fill dataadapter to gridview..
------------------------------------

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
By default, VS will give the DataGridView control the name: dataGridView1.

So the line you say compiles is the correct capitalization.

Can you view its Properties Box OK from the VS designer?

If you can, make sure its Name property is the same as above.
0
Aarti14y ago
Hi, Try with this code:

string strCon = "Data Source=dbServer;Initial Catalog=testDB;Integrated Security=True";
string strSQL = "select * from table1";

SqlDataAdapter dataAdapter = new SqlDataAdapter(strSQL, strCon);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter.Fill(table);
dbBindSource.DataSource = table;

// Resize the DataGridView columns to fit the newly loaded content.
dbGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
// you can make it grid readonly.
dbGridView.ReadOnly = true;
// finally bind the data to the grid
dbGridView.DataSource = dbBindSource;

true;
// finally bind the data to the grid
dbGridView.DataSource = dbBindSource;
0
Satyapriya Nayak14y ago
You can also do with datatable like this...

using System.Data.SqlClient;
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
SqlCommand com;
SqlDataAdapter oda;
string str;

private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConnectionString);
DataTable dataTable = new DataTable();
com = new SqlCommand();
com.Connection = con;
con.Open();
com.CommandText = "Select * from tablename";
oda = new SqlDataAdapter(com);
oda.Fill(dataTable);
con.Close();
dataGridView1.DataSource = dataTable;
}

Thanks
0
Satyapriya Nayak14y ago
Hi Yokzu,

Try this...

OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from customer";
            com = new OleDbCommand(str, con);
            oda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oda.Fill(ds, "customer");
            dataGridView1.DataMember = "customer";
            dataGridView1.DataSource = ds;
            con.Close();

Thanks
0
yokzu14y ago
When I wrote the last line like below, it is compiling with no error.
dataGridView1.DataSource = data_table;

But VS has not recognize "dataGridView1".. I mean its not auto complete.. Not coloured.
0