HighTechTalks DotNet Forums  

edit multiple records in a gridview with one postback

ASP.net Data Grid Control microsoft.public.dotnet.framework.aspnet.datagridcontrol


Discuss edit multiple records in a gridview with one postback in the ASP.net Data Grid Control forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
archuleta37
 
Posts: n/a

Default edit multiple records in a gridview with one postback - 02-09-2007 , 03:57 PM






I've got a asp.net 2.0 gridview with a list of orders. I want to add a column
with a checkbox (simple enough) and make it so that when I click a submit
button, the postback sets the status on each of the records with a checkbox
so that they are completed.

So in my gridview, I have the following attribute:
DataKeyNames="order_id"

and the following code for the status:
<asp:TemplateField HeaderText="Item Status" SortExpression="status_name">
<EditItemTemplate>
<aspropDownList ID="ddStatus" runat="server"
DataSourceID="dsStatus"
DataTextField="status_name"
DataValueField="status_id"
SelectedValue='<%# Bind("order_status_id") %>'>
</aspropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblStatus" runat="server" Text='<%#
Bind("status_name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

and have added a checkbox column:
<asp:CheckBoxField HeaderText="Close" />

and outside the gridview I added:
<asp:LinkButton ID="btnCloseItems" runat="server"
CommandName="closeSelected">Close Selected</asp:LinkButton>

then in my page load method, I have:

if (IsPostBack)
{

}

but where do I go from here? I feel comfortable writing a method that
changes the status for the records, but how do I go about looping through the
records in the postback and identifying the value of the checkbox and
order_id? Is there a standard asp.net way of doing what I'm trying to do, or
is writing code to handle this the best approach? In any case, any help to
accomplish my goal would be much appreciated.

Marc



Reply With Quote
  #2  
Old   
Bruno Alexandre
 
Posts: n/a

Default Re: edit multiple records in a gridview with one postback - 02-14-2007 , 03:34 PM






all you need to do is:

read this tutorial

http://www.gridviewguy.com/ArticleDe...?articleID=219


Bruno Alexandre
Stroby, Danmark

"a Portuguese in Denmark"


"archuleta37" <archuleta37 (AT) discussions (DOT) microsoft.com> wrote

Quote:
I've got a asp.net 2.0 gridview with a list of orders. I want to add a
column
with a checkbox (simple enough) and make it so that when I click a submit
button, the postback sets the status on each of the records with a
checkbox
so that they are completed.

So in my gridview, I have the following attribute:
DataKeyNames="order_id"

and the following code for the status:
asp:TemplateField HeaderText="Item Status" SortExpression="status_name"
EditItemTemplate
aspropDownList ID="ddStatus" runat="server"
DataSourceID="dsStatus"
DataTextField="status_name"
DataValueField="status_id"
SelectedValue='<%# Bind("order_status_id") %>'
/aspropDownList
/EditItemTemplate
ItemTemplate
asp:Label ID="lblStatus" runat="server" Text='<%#
Bind("status_name") %>'></asp:Label
/ItemTemplate
/asp:TemplateField

and have added a checkbox column:
asp:CheckBoxField HeaderText="Close" /

and outside the gridview I added:
asp:LinkButton ID="btnCloseItems" runat="server"
CommandName="closeSelected">Close Selected</asp:LinkButton

then in my page load method, I have:

if (IsPostBack)
{

}

but where do I go from here? I feel comfortable writing a method that
changes the status for the records, but how do I go about looping through
the
records in the postback and identifying the value of the checkbox and
order_id? Is there a standard asp.net way of doing what I'm trying to do,
or
is writing code to handle this the best approach? In any case, any help to
accomplish my goal would be much appreciated.

Marc




Reply With Quote
  #3  
Old   
archuleta37
 
Posts: n/a

Default Re: edit multiple records in a gridview with one postback - 02-14-2007 , 03:57 PM



Oh Wow!
They make it so easy!

Thanks Bruno, I'll put this to good use.
Marc



"Bruno Alexandre" wrote:

Quote:
all you need to do is:

read this tutorial

http://www.gridviewguy.com/ArticleDe...?articleID=219


Bruno Alexandre
Stroby, Danmark

"a Portuguese in Denmark"


"archuleta37" <archuleta37 (AT) discussions (DOT) microsoft.com> wrote in message
news:01B5970F-06BB-4074-A8B4-AD7DBA70E0A7 (AT) microsoft (DOT) com...
I've got a asp.net 2.0 gridview with a list of orders. I want to add a
column
with a checkbox (simple enough) and make it so that when I click a submit
button, the postback sets the status on each of the records with a
checkbox
so that they are completed.

So in my gridview, I have the following attribute:
DataKeyNames="order_id"

and the following code for the status:
asp:TemplateField HeaderText="Item Status" SortExpression="status_name"
EditItemTemplate
aspropDownList ID="ddStatus" runat="server"
DataSourceID="dsStatus"
DataTextField="status_name"
DataValueField="status_id"
SelectedValue='<%# Bind("order_status_id") %>'
/aspropDownList
/EditItemTemplate
ItemTemplate
asp:Label ID="lblStatus" runat="server" Text='<%#
Bind("status_name") %>'></asp:Label
/ItemTemplate
/asp:TemplateField

and have added a checkbox column:
asp:CheckBoxField HeaderText="Close" /

and outside the gridview I added:
asp:LinkButton ID="btnCloseItems" runat="server"
CommandName="closeSelected">Close Selected</asp:LinkButton

then in my page load method, I have:

if (IsPostBack)
{

}

but where do I go from here? I feel comfortable writing a method that
changes the status for the records, but how do I go about looping through
the
records in the postback and identifying the value of the checkbox and
order_id? Is there a standard asp.net way of doing what I'm trying to do,
or
is writing code to handle this the best approach? In any case, any help to
accomplish my goal would be much appreciated.

Marc




Reply With Quote
  #4  
Old   
archuleta37
 
Posts: n/a

Default Re: edit multiple records in a gridview with one postback - 03-02-2007 , 06:40 PM



Hey Bruno,

I ran into another approach to this that I thought I'd share:

article:
http://blogs.msdn.com/mattdotson/articles/490868.aspx
code:
http://www.codeplex.com/ASPNetRealWorldContr


"Bruno Alexandre" wrote:

Quote:
all you need to do is:

read this tutorial

http://www.gridviewguy.com/ArticleDe...?articleID=219


Bruno Alexandre
Stroby, Danmark

"a Portuguese in Denmark"


"archuleta37" <archuleta37 (AT) discussions (DOT) microsoft.com> wrote in message
news:01B5970F-06BB-4074-A8B4-AD7DBA70E0A7 (AT) microsoft (DOT) com...
I've got a asp.net 2.0 gridview with a list of orders. I want to add a
column
with a checkbox (simple enough) and make it so that when I click a submit
button, the postback sets the status on each of the records with a
checkbox
so that they are completed.

So in my gridview, I have the following attribute:
DataKeyNames="order_id"

and the following code for the status:
asp:TemplateField HeaderText="Item Status" SortExpression="status_name"
EditItemTemplate
aspropDownList ID="ddStatus" runat="server"
DataSourceID="dsStatus"
DataTextField="status_name"
DataValueField="status_id"
SelectedValue='<%# Bind("order_status_id") %>'
/aspropDownList
/EditItemTemplate
ItemTemplate
asp:Label ID="lblStatus" runat="server" Text='<%#
Bind("status_name") %>'></asp:Label
/ItemTemplate
/asp:TemplateField

and have added a checkbox column:
asp:CheckBoxField HeaderText="Close" /

and outside the gridview I added:
asp:LinkButton ID="btnCloseItems" runat="server"
CommandName="closeSelected">Close Selected</asp:LinkButton

then in my page load method, I have:

if (IsPostBack)
{

}

but where do I go from here? I feel comfortable writing a method that
changes the status for the records, but how do I go about looping through
the
records in the postback and identifying the value of the checkbox and
order_id? Is there a standard asp.net way of doing what I'm trying to do,
or
is writing code to handle this the best approach? In any case, any help to
accomplish my goal would be much appreciated.

Marc




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.