binding data to datagrid

[shamaila]

in windows apllication, i want to select table's data and show it in datagrid
but i dont undertand how will i bind the data
is there any way to use datagrd view manager or something like this????
m confused!!!

[dip_developer]

in windows apllication, i want to select table's data and show it in datagrid
but i dont undertand how will i bind the data
is there any way to use datagrd view manager or something like this????
m confused!!!

I have given you the answer in the Codeproject.com ASP.NET forum...........

[shamaila]

I have given you the answer in the Codeproject.com ASP.NET forum...........

thank u but my prb is not yet solved...

[dip_developer]

thank u but my prb is not yet solved...

why???
where are u getting the problem...
please post your code if possible

[shamaila]

why???
where are u getting the problem...
please post your code if possible

well! isnt there any need to use data reader??
well my code is

//connection as conn

strQuery = " SELECT * FROM table";
SqlCommand com1 = new SqlCommand(strQuery, conn);


DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter();

SqlDataReader dr = com1.ExecuteReader();

if (dr.Read())
{

da.Fill(ds,"table");


}

its not working i mean data is not displaying in the grid..and the exception that is shown is

"The SelectCommand property has not been initialized before calling 'Fill'."
(i asked u the same quest in codeproject.com...) and yea i tried doing it the exactly the same way u told but no rows returnd :(

[dip_developer]

well! isnt there any need to use data reader??
well my code is

//connection as conn

strQuery = " SELECT * FROM table";
SqlCommand com1 = new SqlCommand(strQuery, conn);


DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter();

SqlDataReader dr = com1.ExecuteReader();

if (dr.Read())
{

da.Fill(ds,"table");


}

its not working i mean data is not displaying in the grid..and the exception that is shown is

"The SelectCommand property has not been initialized before calling 'Fill'."
(i asked u the same quest in codeproject.com...) and yea i tried doing it the exactly the same way u told but no rows returnd :(

why are u using datareader and dataset simultaneously???
follow this...

the code is in vb.net...i think you will convert it to c# easily...otherwise tell me.....

 
'1. Create a connection
Dim myConnection as New SqlConnection(
ConfigurationSettings.AppSettings("connectionString"))
'2. Create the command object, passing in the SQL string
Const strSQL as String = "SELECT * FROM myTable"
Dim myCommand as New SqlCommand(strSQL, myConnection)
'Set the datagrid's datasource to the datareader and databind
myConnection.Open()
DataGrid1.DataSource = myCommand.ExecuteReader(
CommandBehavior.CloseConnection)
DataGrid1.DataBind()
 

but keep in mind
A datareader is a read-only object. If you need to edit and update changes you need to use a dataset.

[shamaila]

why are u using datareader and dataset simultaneously???
follow this...

the code is in vb.net...i think you will convert it to c# easily...otherwise tell me.....

 
'1. Create a connection
Dim myConnection as New SqlConnection(
ConfigurationSettings.AppSettings("connectionString"))
'2. Create the command object, passing in the SQL string
Const strSQL as String = "SELECT * FROM myTable"
Dim myCommand as New SqlCommand(strSQL, myConnection)
'Set the datagrid's datasource to the datareader and databind
myConnection.Open()
DataGrid1.DataSource = myCommand.ExecuteReader(
CommandBehavior.CloseConnection)
DataGrid1.DataBind()
 

but keep in mind
A datareader is a read-only object. If you need to edit and update changes you need to use a dataset.

hmmmm but as i told i m working in windows application and it doesnt support databind option
is there any replacement or any directives/namespaces to include?
and what if i want to update records using dataset?

[dip_developer]

hmmmm but as i told i m working in windows application and it doesnt support databind option
is there any replacement or any directives/namespaces to include?
and what if i want to update records using dataset?

sorry shamaila I have forgotten that yours a windows application...
then you have to make a datatable with that datareader and bind it to the datagrid....

i dont see any other option for you..

[shamaila]

sorry shamaila I have forgotten that yours a windows application...
then you have to make a datatable with that datareader and bind it to the datagrid....

i dont see any other option for you..

thx i'll try it now!!