DataGrid & DataBind()

Hi,

Why does my DataGrid do not accept DataBind?

Code:

---

....

string sCnx = "server=..; uid=..; pwd=..; database=..";
SqlConnection cnx = new System.Data.SqlClient.SqlConnection(sCnx);
cnx.Open();

SqlCommand cmd = new System.Data.SqlClient.SqlCommand();

cmd.Connection = cnx;
cmd.CommandText = "GetInfo";
cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = cmd;

DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);

dgTest.DataSource = procs.GetProc();
dgTest.DataBind();

---

The error is:
'System.Windows.Forms.DataGrid' does not contain a definition for 'DataBind'

How can I fill the DataGrid with the dataSet?

are you doing web app's?

if it's in windows app's no need to put databind.

VB Code:

DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
 
dgTest.DataSource = dataset;

Ok, thanks. No need to put DataBind...

It works without, but it shows a +, not the DataGrid. If I push the + it show me the word "Table". Finally if I click the "Table" it shows me the DataGrid. Why? How can I display directly the DataGrid?

you must create a datatable to show it directly to the datagrid w/ out clicking the "+" sign.
like this one.

VB Code:

DataSet dataSet = new DataSet();
dataSet.Tables.Add(new Datatable("dt"));
dataAdapter.Fill(dataSet.Tables[0]);
 
dgTest.DataSource = dataset;