ASP.NET

NanaAM19-Feb-07 22:19

19-Feb-07 22:19

Grid can be bound to any Collection type.
You can create a dummy datattable as following:-
DataTable dt = new DataTable("Try");
dt.Columns.Add("column1");
dt.Rows.Add("one");
dt.Rows.Add("two");
dt.Rows.Add("three");

and now set the datasource to dt.

Also you need to have atleast 1 row in datasource to get the grid displayed

Nana

nclauder19-Feb-07 22:33

nclauder

19-Feb-07 22:33

Thank you,
I was doing it like this. Hope
private void Page_Load(object sender, System.EventArgs e)
{
if (! IsPostBack)
{
BindDataGrid();
}
}

private void BindDataGrid()
{
SqlCommand myCommand=new SqlCommand("SELECT * from Billing",con);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
con.Open();
myCommand.ExecuteNonQuery();
dgbilling.DataSource=ds;
dgbilling.DataBind();
con.Close();
}

I had ever used this same code on another program and it worked properly.
could you help me from there please

Thanks.

NanaAM19-Feb-07 22:50

19-Feb-07 22:50

use following code-

SqlDataAdapter myAdapter=new SqlDataAdapter("SELECT * from Billing", con);
con.Open();
DataSet ds=new DataSet();
myAdapter.Fill(ds);
con.Close();
dgbilling.DataSource=ds;
dgbilling.DataBind();

you dont need sqlcommand here at all.
And one suggestion - read more about what is an adapter, dataset etc why is it used n all.
I think one should know why is he/she using the object in the code.

Nana

nclauder19-Feb-07 22:56

nclauder

19-Feb-07 22:56

Thanks for the advice. But the datagrid cannot appear,

NanaAM19-Feb-07 23:03

19-Feb-07 23:03

is the qurey returning records?
Whats the count of rows in datasource?

Nana

nclauder20-Feb-07 0:06

nclauder

20-Feb-07 0:06

In the datasource there is nonthing..
Thanks

How to delete rows that are checked in a datagrid / [modified]

PandemoniumPasha20-Feb-07 22:46

PandemoniumPasha

20-Feb-07 22:46

when you use data adapters you do not need to open or close the connection, it does it by itselt. if the connection was already open before calling the fill command in data-adapert, it will leave it open and if it was close, it will open it get the data and then close it.
the Fill() function will get the data; so, you do not need to call the ExecuteNonQuery()
command again.

you might try the following:

private void BindDataGrid()
{
SqlCommand myCommand=new SqlCommand("SELECT * from Billing",con);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds=new DataSet();
myAdapter.Fill(ds);
dgbilling.DataSource=ds;
dgbilling.DataBind();
}

this should give the required result.

Arun Hegde19-Feb-07 19:54

Arun Hegde

19-Feb-07 19:54

GOD BLESS U
Dear Friends,

i am using a datagrid control in my ASP.NET application .
The datagrid has a checkbox column in it.Now apart from this the page also contains a button control named Delete.

what i need here is that when a user selects the checkbox in the datagrid,
and clicks the Delete button then that record should be deleted from both datagrid & database.
But if the user checks the SELECT ALL checkbox which is present in the datagrid header and clicks the delete button then all the records should be deleted from the datagrid & database.

pl give me the code for the above problem
This functionality is similar to any inbox page .
Pl kindly help me

Thanks a lot

Have a good day

Arun Hegde

-- modified at 4:28 Tuesday 20th February, 2007

Re: How to delete rows that are checked in a datagrid /

PandemoniumPasha19-Feb-07 20:52

PandemoniumPasha

19-Feb-07 20:52

i'm not sure whether u want to remove the records from the datagrid only or from the database as well.
in either case u can write the data-removing code in the event handler of the delete button.
in the event handler, get the datafrom the datagrid which will usually be of the Table datatype. so, now u can get the rows that have the checkbox checked and remove them from the table and bind the resulting table to the datagrid again.

i have used this mechanism to do something similar in my project as well, and it worked.

hope this helps.

Re: How to delete rows that are checked in a datagrid /

NanaAM19-Feb-07 22:32

Display Datagrid horizontally

19-Feb-07 22:32

I dont have VS.net installed right now so i can gove u hints.
You try the proper version.

For loop counter =1 to datagrid1.Rows.Count
if(((CheckBox)(datagrid1.Rows[counter].Controls[0].Controls[1])).Checked==true)
store it in some string say strToBeDeleted;
end loop

Now delete from db using strToBeDeleted ids.
and then again fire select query and bind the grid once again

what exactly we are doing is looping through all rows of grid.
use F10 to find exact position of the control in row as the Controls[0].Controls[1] code.
then we are casting it to checkbox and searching if its checked or not

Nana

iamdking19-Feb-07 19:47

iamdking

19-Feb-07 19:47

Hello Friends ..This is Amit..and i want to use datagrid control in webpage..This control will display name and image ..Is it possible to display datagrid horizontally..detault view of datagrid is vertical...Tell me if u know..please...............

Vsree19-Feb-07 20:46

Vsree

19-Feb-07 20:46

Hi
Can you please explain your need in detail.
Normally for displaying in Horizontal format,we use Datalist control.

iamdking19-Feb-07 21:09

iamdking

19-Feb-07 21:09

hello...Actually I use 2 datalists say dtlist1 and dtlist2 and two pagers say pager1 and pager2 for each of them resp..and when the page is loaded dtlist2 is displayed by default. When user clicks on a button second dtlist2 is displayed...and after clicking on the pager for that datalist ..It shows first datalist i.e. dtlist1 ....becoz on page load dtlist2 is to displayed..To avoid such confict in pager..i decide to use datagrid which has its own pager..Then the problem occurs to show datagrid horizontally...Do u have any solution.....

luckyve19-Feb-07 22:34

luckyve

19-Feb-07 22:34

Hi. I had this problem too Frown | :(

but I couldnt find any way ... I dont think it is possible ...
just you can work with datalist.