Not Showing Data Grid

[=?Utf-8?B?UmludSBHb3BhbGFrcmlzaG5hIFBpbGxhaQ==?=]

Hi All,

I have an application that fetch data thru a store proc and display in a
datagrid, but after successful execution of proc the data grid is not
visible.Please go thru the following code and plz let me know what is
missing.The data grid propertiy "Visible is true".

try
{
OracleDataAcces s oracleDA = new OracleDataAcces s("Data
Source=dsname;U ser ID=uid;Password =pwd");
if (oracleDA.OpenD BConnection() == false)
{
return;
}
OracleConnectio n oracleConn = oracleDA.DBConn ection;

OracleCommand psCommand = new
OracleCommand(" PKG_NAME.STORED _PROC_NAME", oracleConn);
psCommand.Comma ndType = CommandType.Sto redProcedure;

OracleParameter param = new OracleParameter ("RESULT_CURSOR ",
OracleType.Curs or);
param.Direction = ParameterDirect ion.Output;
psCommand.Param eters.Add(param );

param = new OracleParameter ("IN_DATE", OracleType.VarC har);
param.Direction = ParameterDirect ion.Input;
param.Value = txtBoxBeginDate .Text;
psCommand.Param eters.Add(param );

// Execute command
OracleDataReade r reader = psCommand.Execu teReader();

if (!reader.HasRow s)
{
reader.Close();
return;
}
OracleDataAdapt er odad = new OracleDataAdapt er(psCommand);

DataSet ds = new DataSet();

odad.Fill(ds);

GridView1.DataS ource = ds;
GridView1.DataB ind();
oracleConn.Clos e();
}
catch (Exception ex)
{

}

Thanks and Regards
Rinu G Pillai

[Nicholas Paldino [.NET/C# MVP]]

Rinu,

It seems that you are not setting the data member of the grid to point
to the table to bind to. This needs to be done for the DataGridView. If
you are using a DataGrid view, then I believe just setting the data set
should work.

Try to set the data source to the DataTable in the DataSet you just
filled.

If that doesn't work, then check to see that you are actually getting
results from the stored procedure, as that's always a possibility.

Also, if you are using the DataGridView, then make sure the
AutoGenerateCol umns property is set to true, or, if it is false, make sure
you add the columns to be bound to.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Rinu Gopalakrishna Pillai"
<Ri************ *********@discu ssions.microsof t.comwrote in message
news:DE******** *************** ***********@mic rosoft.com...

Hi All,

I have an application that fetch data thru a store proc and display in a
datagrid, but after successful execution of proc the data grid is not
visible.Please go thru the following code and plz let me know what is
missing.The data grid propertiy "Visible is true".

try
{
OracleDataAcces s oracleDA = new OracleDataAcces s("Data
Source=dsname;U ser ID=uid;Password =pwd");
if (oracleDA.OpenD BConnection() == false)
{
return;
}
OracleConnectio n oracleConn = oracleDA.DBConn ection;

OracleCommand psCommand = new
OracleCommand(" PKG_NAME.STORED _PROC_NAME", oracleConn);
psCommand.Comma ndType = CommandType.Sto redProcedure;

OracleParameter param = new OracleParameter ("RESULT_CURSOR ",
OracleType.Curs or);
param.Direction = ParameterDirect ion.Output;
psCommand.Param eters.Add(param );

param = new OracleParameter ("IN_DATE", OracleType.VarC har);
param.Direction = ParameterDirect ion.Input;
param.Value = txtBoxBeginDate .Text;
psCommand.Param eters.Add(param );

// Execute command
OracleDataReade r reader = psCommand.Execu teReader();

if (!reader.HasRow s)
{
reader.Close();
return;
}
OracleDataAdapt er odad = new OracleDataAdapt er(psCommand);

DataSet ds = new DataSet();

odad.Fill(ds);

GridView1.DataS ource = ds;
GridView1.DataB ind();
oracleConn.Clos e();
}
catch (Exception ex)
{

}

Thanks and Regards
Rinu G Pillai

[=?Utf-8?B?UmludSBHb3BhbGFrcmlzaG5hIFBpbGxhaQ==?=]

Hi Nic,

Thanks a lot for your quick response.

The real problem was "AutoGenerateCo lumns = false" , now I changed to true
and it's working.

Nic, highly appreciate if you can show some code to do the rest of the
solution you mentioned , like
1 . set the data source to the DataTable in the DataSet

2 . setting the data member of the grid to point
to the table to bind to

3 .add the columns to be bound to

Once again thanks a lot!!!!.
"Nicholas Paldino [.NET/C# MVP]" wrote:

Rinu,

It seems that you are not setting the data member of the grid to point
to the table to bind to. This needs to be done for the DataGridView. If
you are using a DataGrid view, then I believe just setting the data set
should work.

Try to set the data source to the DataTable in the DataSet you just
filled.

If that doesn't work, then check to see that you are actually getting
results from the stored procedure, as that's always a possibility.

Also, if you are using the DataGridView, then make sure the
AutoGenerateCol umns property is set to true, or, if it is false, make sure
you add the columns to be bound to.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Rinu Gopalakrishna Pillai"
<Ri************ *********@discu ssions.microsof t.comwrote in message
news:DE******** *************** ***********@mic rosoft.com...

Hi All,

I have an application that fetch data thru a store proc and display in a
datagrid, but after successful execution of proc the data grid is not
visible.Please go thru the following code and plz let me know what is
missing.The data grid propertiy "Visible is true".

try
{
OracleDataAcces s oracleDA = new OracleDataAcces s("Data
Source=dsname;U ser ID=uid;Password =pwd");
if (oracleDA.OpenD BConnection() == false)
{
return;
}
OracleConnectio n oracleConn = oracleDA.DBConn ection;

OracleCommand psCommand = new
OracleCommand(" PKG_NAME.STORED _PROC_NAME", oracleConn);
psCommand.Comma ndType = CommandType.Sto redProcedure;

OracleParameter param = new OracleParameter ("RESULT_CURSOR ",
OracleType.Curs or);
param.Direction = ParameterDirect ion.Output;
psCommand.Param eters.Add(param );

param = new OracleParameter ("IN_DATE", OracleType.VarC har);
param.Direction = ParameterDirect ion.Input;
param.Value = txtBoxBeginDate .Text;
psCommand.Param eters.Add(param );

// Execute command
OracleDataReade r reader = psCommand.Execu teReader();

if (!reader.HasRow s)
{
reader.Close();
return;
}
OracleDataAdapt er odad = new OracleDataAdapt er(psCommand);

DataSet ds = new DataSet();

odad.Fill(ds);

GridView1.DataS ource = ds;
GridView1.DataB ind();
oracleConn.Clos e();
}
catch (Exception ex)
{

}

Thanks and Regards
Rinu G Pillai

[Nicholas Paldino [.NET/C# MVP]]

Rinu,

If you want to bind to the data table, then you can get the table
yourself by accessing the Tables property on the DataSet. If you want to
use the DataMember property on the DataGridView, then you can set the
DataSource property to the DataSet instance and then set the DataMember
property to the name of the table, the same thing you would pass to the
string indexer for the collection returned by the Tables property.

To add the columns to bind to, you would have to call the Add method on
the DataGridViewCol umnCollection which is exposed by the Columns property on
the DataGridView.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Rinu Gopalakrishna Pillai"
<Ri************ *********@discu ssions.microsof t.comwrote in message
news:A3******** *************** ***********@mic rosoft.com...

Hi Nic,

Thanks a lot for your quick response.

The real problem was "AutoGenerateCo lumns = false" , now I changed to true
and it's working.

Nic, highly appreciate if you can show some code to do the rest of the
solution you mentioned , like
1 . set the data source to the DataTable in the DataSet

2 . setting the data member of the grid to point
to the table to bind to

3 .add the columns to be bound to

Once again thanks a lot!!!!.
"Nicholas Paldino [.NET/C# MVP]" wrote:

>Rinu,

It seems that you are not setting the data member of the grid to
point
to the table to bind to. This needs to be done for the DataGridView. If
you are using a DataGrid view, then I believe just setting the data set
should work.

Try to set the data source to the DataTable in the DataSet you just
filled.

If that doesn't work, then check to see that you are actually getting
results from the stored procedure, as that's always a possibility.

Also, if you are using the DataGridView, then make sure the
AutoGenerateCo lumns property is set to true, or, if it is false, make
sure
you add the columns to be bound to.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Rinu Gopalakrishna Pillai"
<Ri*********** **********@disc ussions.microso ft.comwrote in message
news:DE******* *************** ************@mi crosoft.com...

Hi All,

I have an application that fetch data thru a store proc and display in
a
datagrid, but after successful execution of proc the data grid is not
visible.Please go thru the following code and plz let me know what is
missing.The data grid propertiy "Visible is true".

try
{
OracleDataAcces s oracleDA = new OracleDataAcces s("Data
Source=dsname;U ser ID=uid;Password =pwd");
if (oracleDA.OpenD BConnection() == false)
{
return;
}
OracleConnectio n oracleConn = oracleDA.DBConn ection;

OracleCommand psCommand = new
OracleCommand(" PKG_NAME.STORED _PROC_NAME", oracleConn);
psCommand.Comma ndType = CommandType.Sto redProcedure;

OracleParameter param = new OracleParameter ("RESULT_CURSOR ",
OracleType.Curs or);
param.Direction = ParameterDirect ion.Output;
psCommand.Param eters.Add(param );

param = new OracleParameter ("IN_DATE", OracleType.VarC har);
param.Direction = ParameterDirect ion.Input;
param.Value = txtBoxBeginDate .Text;
psCommand.Param eters.Add(param );

// Execute command
OracleDataReade r reader = psCommand.Execu teReader();

if (!reader.HasRow s)
{
reader.Close();
return;
}
OracleDataAdapt er odad = new OracleDataAdapt er(psCommand);

DataSet ds = new DataSet();

odad.Fill(ds);

GridView1.DataS ource = ds;
GridView1.DataB ind();
oracleConn.Clos e();
}
catch (Exception ex)
{

}

Thanks and Regards
Rinu G Pillai

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"Rinu Gopalakrishna Pillai"
<Ri************ *********@discu ssions.microsof t.comwrote in message
news:A3******** *************** ***********@mic rosoft.com...

Hi Nic,

Thanks a lot for your quick response.

The real problem was "AutoGenerateCo lumns = false" , now I changed to true
and it's working.

A more fine grained control can be obtained by using TemplateColumns
instead. Especially regarding the header text of the column.