Hello,
I have a Gridview control (.net 2.0) that I'm having trouble getting the
Update button to fire any kind of event or preforming the update. The
datatable is based on a join so I don't know if that's what's causing the
behavior or not. It seems like the Update button should at least do
something.
When the Edit button is clicked, the grid goes into Edit mode and the Cancel
button takes the grid out of Edit mode. So, I don't get what the trick is
here.
I've enabled adding records via the FooterRow.
The reason I'm using a join is to allow sorting on the joined in field. I
know that I could drop kick the join, add in a template field and then
populate it during RowDataBound but then the sort won't work...
Any ideas?
Thanks
SAL 11 6036
Hi SAL,
From your description, you're encountering some problem to get the update
function in GridView to work, correct?
As for the Updating not work, do you means if you click "Update" button,
the page doesn't postback or the page does postback but the database
updating commands are not taking effect?
Also, how do you implement the edit/update in GridView, are you directly
use SqlDataSource's two-way databinding to automatically perform update or
you manually use code to update the database (when updating event fires)?
Generally, for such issue, I would first register the "RowUpdating" event
of the Gridview(ensure it get fired) and then check all the parameters (via
the event Argument parameter) to see whether the column data user entered
have been supplied correctly in the parameter collection:
===================
protected void GridView1_RowUpdating(object sender,
GridViewUpdateEventArgs e)
{
//e.Keys;
//e.NewValues;
// e.OldValues;
...................
======================
If there is anything I omit, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "SAL" <SA*@nospam.nospam> Subject: GridView update problem Date: Tue, 8 Jul 2008 14:07:56 -0700
>Hello, I have a Gridview control (.net 2.0) that I'm having trouble getting the Update button to fire any kind of event or preforming the update. The datatable is based on a join so I don't know if that's what's causing the behavior or not. It seems like the Update button should at least do something. When the Edit button is clicked, the grid goes into Edit mode and the
Cancel
>button takes the grid out of Edit mode. So, I don't get what the trick is here. I've enabled adding records via the FooterRow. The reason I'm using a join is to allow sorting on the joined in field. I know that I could drop kick the join, add in a template field and then populate it during RowDataBound but then the sort won't work...
Any ideas?
Thanks SAL
Hi Steven. As far as I can tell, it's not even doing a postback. If an event
was firing, I could at least manually update the record. It would be nice to
have it update itself however via two-way binding.
I've implemented two way binding via an objectdatasource which is bound to a
business object and the business object is using a table adapter that was
created using the designer.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message
news:e5**************@TK2MSFTNGHUB02.phx.gbl...
Hi SAL,
From your description, you're encountering some problem to get the update
function in GridView to work, correct?
As for the Updating not work, do you means if you click "Update" button,
the page doesn't postback or the page does postback but the database
updating commands are not taking effect?
Also, how do you implement the edit/update in GridView, are you directly
use SqlDataSource's two-way databinding to automatically perform update or
you manually use code to update the database (when updating event fires)?
Generally, for such issue, I would first register the "RowUpdating" event
of the Gridview(ensure it get fired) and then check all the parameters
(via
the event Argument parameter) to see whether the column data user entered
have been supplied correctly in the parameter collection:
===================
protected void GridView1_RowUpdating(object sender,
GridViewUpdateEventArgs e)
{
//e.Keys;
//e.NewValues;
// e.OldValues;
..................
======================
If there is anything I omit, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>>From: "SAL" <SA*@nospam.nospam> Subject: GridView update problem Date: Tue, 8 Jul 2008 14:07:56 -0700
>>Hello, I have a Gridview control (.net 2.0) that I'm having trouble getting the Update button to fire any kind of event or preforming the update. The datatable is based on a join so I don't know if that's what's causing the behavior or not. It seems like the Update button should at least do something. When the Edit button is clicked, the grid goes into Edit mode and the
Cancel
>>button takes the grid out of Edit mode. So, I don't get what the trick is here. I've enabled adding records via the FooterRow. The reason I'm using a join is to allow sorting on the joined in field. I know that I could drop kick the join, add in a template field and then populate it during RowDataBound but then the sort won't work...
Any ideas?
Thanks SAL
Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the update
button is put correctly(via edit/update command field). Is it reproable via
some simplified data source? You can send me a simplified copy so that I
can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
--------------------
>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl>
>Subject: Re: GridView update problem Date: Wed, 9 Jul 2008 09:52:04 -0700
> Hi Steven. As far as I can tell, it's not even doing a postback. If an
event
>was firing, I could at least manually update the record. It would be nice
to
>have it update itself however via two-way binding.
I've implemented two way binding via an objectdatasource which is bound to
a
>business object and the business object is using a table adapter that was created using the designer.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:e5**************@TK2MSFTNGHUB02.phx.gbl...
>Hi SAL,
From your description, you're encountering some problem to get the update function in GridView to work, correct?
As for the Updating not work, do you means if you click "Update" button, the page doesn't postback or the page does postback but the database updating commands are not taking effect?
Also, how do you implement the edit/update in GridView, are you directly use SqlDataSource's two-way databinding to automatically perform update
or
>you manually use code to update the database (when updating event fires)? Generally, for such issue, I would first register the "RowUpdating" event of the Gridview(ensure it get fired) and then check all the parameters (via the event Argument parameter) to see whether the column data user
entered
>have been supplied correctly in the parameter collection:
=================== protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //e.Keys; //e.NewValues; // e.OldValues; .................. ======================
If there is anything I omit, please feel free to let me know.
Sincerely,
Steven,
I have sent a small project that exhibits this symptom.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message
news:37**************@TK2MSFTNGHUB02.phx.gbl...
Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the update
button is put correctly(via edit/update command field). Is it reproable
via
some simplified data source? You can send me a simplified copy so that I
can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
--------------------
>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl>
>>Subject: Re: GridView update problem Date: Wed, 9 Jul 2008 09:52:04 -0700
>> Hi Steven. As far as I can tell, it's not even doing a postback. If an
event
>>was firing, I could at least manually update the record. It would be nice
to
>>have it update itself however via two-way binding.
I've implemented two way binding via an objectdatasource which is bound to
a
>>business object and the business object is using a table adapter that was created using the designer.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:e5**************@TK2MSFTNGHUB02.phx.gbl.. .
>>Hi SAL,
From your description, you're encountering some problem to get the update function in GridView to work, correct?
As for the Updating not work, do you means if you click "Update" button, the page doesn't postback or the page does postback but the database updating commands are not taking effect?
Also, how do you implement the edit/update in GridView, are you directly use SqlDataSource's two-way databinding to automatically perform update
or
>>you manually use code to update the database (when updating event fires)? Generally, for such issue, I would first register the "RowUpdating" event of the Gridview(ensure it get fired) and then check all the parameters (via the event Argument parameter) to see whether the column data user
entered
>>have been supplied correctly in the parameter collection:
=================== protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //e.Keys; //e.NewValues; // e.OldValues; .................. ======================
If there is anything I omit, please feel free to let me know.
Sincerely,
Hi SAL,
I've received your email and performed some tests on the page you provided.
It seems you have many different code logic on the GridView+ ODataSource
editing/updating. I haven't looked deep into the database layer and after
some testing at the page/gridview layer, I found the following problems:
1. You have added some button and textbox in the GridView's Footer(of some
template fields) so as for inserting some records. However, since the
Textbox in insert template has requiredFieldValidator associated, when you
try editing/updating and submit update, the validation of the Insert
textbox will prevent it from postback the page. To address the problem, I
have used the following means:
#for TextBox, Validator and button in FooterTemplate, I set a separate
"ValidationGroup" for them so that they'll not affect the edit/update of
Gridview
==========
<asp:TextBox ID="txtDbsId"
...................ValidationGroup="Insert_Group"> </asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1".....................
ValidationGroup="Insert_Group">*</asp:RequiredFieldValidator>
<asp:Button ID="btnAdd" runat="server" Text="Add" CommandName="Insert"
EnableViewState="False"
ValidationGroup="Insert_Group" />
============================
After that, the page can be submit correctly when we hit "update" button in
edit mode.
2. When the page postback to server-side, the Server-side validation
function will also query database to validate some input values. I'm not
sure the actual database schema and code logic, but you also need to check
this since if this fails, the updating event will not be reached.
3. You have registered the "RowUpdating" event, however, you've also add
the following code in "Rowcommand" event:
+===========
'ElseIf e.CommandName = "Update" AndAlso Page.IsValid Then
' dsGISLayers.Update()
'End If
===================
If you want to manually do the updating, you only need the "RowUpdating"
event and you can get all the parameters from the parameters collection and
do your own ADO.NET code, after that call e.Cancel=True so as to prevent
the built-in updating code logic:
====================
Protected Sub gvGISLayerEdit_RowUpdating(ByVal sender As Object, ByVal e
As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles
gvGISLayerEdit.RowUpdating
Response.Write("<br/>gvGISLayerEdit_RowUpdating")
'get parameters from e.NewValues , e.OldValues, e.RowIndex
' and all TableAdapter to update
e.Cancel = True
End Sub
===================
Simply call ObjectDataSource.Update will not take effect since you haven't
registered its "Updating" event and supply the necessary parameters for it.
BTW, for ASP.NET data accesing, you can refer to some good examples and
tutorial from the following site: http://www.asp.net/learn/data-access/
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4I HA.5112
>Subject: Re: GridView update problem Date: Thu, 10 Jul 2008 10:31:34 -0700
> Steven, I have sent a small project that exhibits this symptom.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:37**************@TK2MSFTNGHUB02.phx.gbl...
>Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the
update
>button is put correctly(via edit/update command field). Is it reproable via some simplified data source? You can send me a simplified copy so that I can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you.
Please
>feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
Hi SAL,
How are you doing?
have you got any progress on this issue or does the information I provided
in last message help you some? If there is anything else need help, please
feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
even Cheng [MSFT])
>Organization: Microsoft Date: Fri, 11 Jul 2008 06:01:11 GMT Subject: Re: GridView update problem
> Hi SAL,
I've received your email and performed some tests on the page you provided.
It seems you have many different code logic on the GridView+ ODataSource editing/updating. I haven't looked deep into the database layer and after some testing at the page/gridview layer, I found the following problems:
1. You have added some button and textbox in the GridView's Footer(of some template fields) so as for inserting some records. However, since the Textbox in insert template has requiredFieldValidator associated, when you try editing/updating and submit update, the validation of the Insert textbox will prevent it from postback the page. To address the problem,
I
>have used the following means:
#for TextBox, Validator and button in FooterTemplate, I set a separate "ValidationGroup" for them so that they'll not affect the edit/update of Gridview ==========
<asp:TextBox ID="txtDbsId" ..................ValidationGroup="Insert_Group"> </asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"................... ..
ValidationGroup="Insert_Group">*</asp:RequiredFieldValidator>
<asp:Button ID="btnAdd" runat="server" Text="Add" CommandName="Insert" EnableViewState="False"
ValidationGroup="Insert_Group" /> ============================
After that, the page can be submit correctly when we hit "update" button
in
>edit mode.
2. When the page postback to server-side, the Server-side validation function will also query database to validate some input values. I'm not sure the actual database schema and code logic, but you also need to check this since if this fails, the updating event will not be reached.
3. You have registered the "RowUpdating" event, however, you've also add the following code in "Rowcommand" event:
+===========
'ElseIf e.CommandName = "Update" AndAlso Page.IsValid Then
' dsGISLayers.Update()
'End If ===================
If you want to manually do the updating, you only need the "RowUpdating" event and you can get all the parameters from the parameters collection
and
>do your own ADO.NET code, after that call e.Cancel=True so as to prevent the built-in updating code logic:
====================
Protected Sub gvGISLayerEdit_RowUpdating(ByVal sender As Object, ByVal
e
>As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvGISLayerEdit.RowUpdating
Response.Write("<br/>gvGISLayerEdit_RowUpdating")
'get parameters from e.NewValues , e.OldValues, e.RowIndex
' and all TableAdapter to update
e.Cancel = True
End Sub ===================
Simply call ObjectDataSource.Update will not take effect since you haven't registered its "Updating" event and supply the necessary parameters for it.
BTW, for ASP.NET data accesing, you can refer to some good examples and tutorial from the following site:
http://www.asp.net/learn/data-access/
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
================================================= = Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ault.aspx#noti
f
>ications.
================================================= = This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4 IHA.5112
>>Subject: Re: GridView update problem Date: Thu, 10 Jul 2008 10:31:34 -0700
>> Steven, I have sent a small project that exhibits this symptom.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:37**************@TK2MSFTNGHUB02.phx.gbl.. .
>>Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the
update
>>button is put correctly(via edit/update command field). Is it reproable via some simplified data source? You can send me a simplified copy so that
I
>>can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments
and
>>suggestions about how we can improve the support we provide to you.
Please
>>feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
Steven,
I created a sample test project per your instructions and e-mailed it to
you. I have been waiting on you to check that code out and reply to me
directly I thought. Maybe not though. Did you not recieve the sample
project?
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message
news:Jj**************@TK2MSFTNGHUB02.phx.gbl...
Hi SAL,
How are you doing?
have you got any progress on this issue or does the information I provided
in last message help you some? If there is anything else need help, please
feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
even Cheng [MSFT])
>>Organization: Microsoft Date: Fri, 11 Jul 2008 06:01:11 GMT Subject: Re: GridView update problem
>> Hi SAL,
I've received your email and performed some tests on the page you provided.
It seems you have many different code logic on the GridView+ ODataSource editing/updating. I haven't looked deep into the database layer and after some testing at the page/gridview layer, I found the following problems:
1. You have added some button and textbox in the GridView's Footer(of some template fields) so as for inserting some records. However, since the Textbox in insert template has requiredFieldValidator associated, when you try editing/updating and submit update, the validation of the Insert textbox will prevent it from postback the page. To address the problem,
I
>>have used the following means:
#for TextBox, Validator and button in FooterTemplate, I set a separate "ValidationGroup" for them so that they'll not affect the edit/update of Gridview ========== <asp:TextBox ID="txtDbsId" ..................ValidationGroup="Insert_Group" ></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1".................... .
ValidationGroup="Insert_Group">*</asp:RequiredFieldValidator>
<asp:Button ID="btnAdd" runat="server" Text="Add" CommandName="Insert" EnableViewState="False" ValidationGroup="Insert_Group" /> ============================
After that, the page can be submit correctly when we hit "update" button
in
>>edit mode.
2. When the page postback to server-side, the Server-side validation function will also query database to validate some input values. I'm not sure the actual database schema and code logic, but you also need to check this since if this fails, the updating event will not be reached.
3. You have registered the "RowUpdating" event, however, you've also add the following code in "Rowcommand" event:
+===========
'ElseIf e.CommandName = "Update" AndAlso Page.IsValid Then ' dsGISLayers.Update() 'End If ===================
If you want to manually do the updating, you only need the "RowUpdating" event and you can get all the parameters from the parameters collection
and
>>do your own ADO.NET code, after that call e.Cancel=True so as to prevent the built-in updating code logic:
==================== Protected Sub gvGISLayerEdit_RowUpdating(ByVal sender As Object, ByVal
e
>>As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvGISLayerEdit.RowUpdating
Response.Write("<br/>gvGISLayerEdit_RowUpdating")
'get parameters from e.NewValues , e.OldValues, e.RowIndex ' and all TableAdapter to update
e.Cancel = True
End Sub ===================
Simply call ObjectDataSource.Update will not take effect since you haven't registered its "Updating" event and supply the necessary parameters for it.
BTW, for ASP.NET data accesing, you can refer to some good examples and tutorial from the following site:
http://www.asp.net/learn/data-access/
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
================================================ == Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ault.aspx#noti
f
>>ications.
================================================ == This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe 4IHA.5112
>>>Subject: Re: GridView update problem Date: Thu, 10 Jul 2008 10:31:34 -0700
>>> Steven, I have sent a small project that exhibits this symptom.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:37**************@TK2MSFTNGHUB02.phx.gbl. .. Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the
update
>>>button is put correctly(via edit/update command field). Is it reproable via some simplified data source? You can send me a simplified copy so that
I
>>>can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments
and
>>>suggestions about how we can improve the support we provide to you.
Please
>>>feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
Okay, I got your reply now. For some reason it didn't show up when I opened
up outlook express.
I'm doing the updating manually now and took out the code from rowcommand.
I made the changes you suggested for the ValidationGroup and the Update
button is now posting back.
I didn't quite understand what you were saying in #2 below however.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message
news:Ss**************@TK2MSFTNGHUB02.phx.gbl...
Hi SAL,
I've received your email and performed some tests on the page you
provided.
It seems you have many different code logic on the GridView+ ODataSource
editing/updating. I haven't looked deep into the database layer and after
some testing at the page/gridview layer, I found the following problems:
1. You have added some button and textbox in the GridView's Footer(of some
template fields) so as for inserting some records. However, since the
Textbox in insert template has requiredFieldValidator associated, when you
try editing/updating and submit update, the validation of the Insert
textbox will prevent it from postback the page. To address the problem,
I
have used the following means:
#for TextBox, Validator and button in FooterTemplate, I set a separate
"ValidationGroup" for them so that they'll not affect the edit/update of
Gridview
==========
<asp:TextBox ID="txtDbsId"
..................ValidationGroup="Insert_Group"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1".....................
ValidationGroup="Insert_Group">*</asp:RequiredFieldValidator>
<asp:Button ID="btnAdd" runat="server" Text="Add" CommandName="Insert"
EnableViewState="False"
ValidationGroup="Insert_Group" />
============================
After that, the page can be submit correctly when we hit "update" button
in
edit mode.
2. When the page postback to server-side, the Server-side validation
function will also query database to validate some input values. I'm not
sure the actual database schema and code logic, but you also need to check
this since if this fails, the updating event will not be reached.
3. You have registered the "RowUpdating" event, however, you've also add
the following code in "Rowcommand" event:
+===========
'ElseIf e.CommandName = "Update" AndAlso Page.IsValid Then
' dsGISLayers.Update()
'End If
===================
If you want to manually do the updating, you only need the "RowUpdating"
event and you can get all the parameters from the parameters collection
and
do your own ADO.NET code, after that call e.Cancel=True so as to prevent
the built-in updating code logic:
====================
Protected Sub gvGISLayerEdit_RowUpdating(ByVal sender As Object, ByVal e
As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles
gvGISLayerEdit.RowUpdating
Response.Write("<br/>gvGISLayerEdit_RowUpdating")
'get parameters from e.NewValues , e.OldValues, e.RowIndex
' and all TableAdapter to update
e.Cancel = True
End Sub
===================
Simply call ObjectDataSource.Update will not take effect since you haven't
registered its "Updating" event and supply the necessary parameters for
it.
BTW, for ASP.NET data accesing, you can refer to some good examples and
tutorial from the following site:
http://www.asp.net/learn/data-access/
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4I HA.5112
>>Subject: Re: GridView update problem Date: Thu, 10 Jul 2008 10:31:34 -0700
>> Steven, I have sent a small project that exhibits this symptom.
S
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:37**************@TK2MSFTNGHUB02.phx.gbl.. .
>>Thanks for your reply SAL,
That seems unexpected since the postback should work as long as the
update
>>button is put correctly(via edit/update command field). Is it reproable via some simplified data source? You can send me a simplified copy so that I can also test it on my side. My email is
"stcheng" + @ + "microsoft.com"
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you.
Please
>>feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
Thanks for your reply SAL,
I'm glad that the you got the email. For the #2 point you mentioned:
I just mean the Validation event of your validator control. Since you use
server-side validation, you need to make sure that the validation doesn't
work correctly and sometimes if the validation fails or not work correctly,
that may also prevent the other sequential postback event(such as Gridview
updating) work.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.========================================= =========
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4I HA.511
>Subject: Re: GridView update problem Date: Tue, 15 Jul 2008 12:47:10 -0700
>Okay, I got your reply now. For some reason it didn't show up when I
opened
>up outlook express.
I'm doing the updating manually now and took out the code from rowcommand.
I made the changes you suggested for the ValidationGroup and the Update button is now posting back.
I didn't quite understand what you were saying in #2 below however.
S
>>>
Okay.
Thanks so much for you support.
SAL
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message
news:aR**************@TK2MSFTNGHUB02.phx.gbl...
Thanks for your reply SAL,
I'm glad that the you got the email. For the #2 point you mentioned:
I just mean the Validation event of your validator control. Since you use
server-side validation, you need to make sure that the validation doesn't
work correctly and sometimes if the validation fails or not work
correctly,
that may also prevent the other sequential postback event(such as Gridview
updating) work.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.========================================= =========
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4I HA.511
>>Subject: Re: GridView update problem Date: Tue, 15 Jul 2008 12:47:10 -0700
>>Okay, I got your reply now. For some reason it didn't show up when I
opened
>>up outlook express.
I'm doing the updating manually now and took out the code from rowcommand.
I made the changes you suggested for the ValidationGroup and the Update button is now posting back.
I didn't quite understand what you were saying in #2 below however.
S
>>>>
You're welcome.
If you need any further help on this later, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at: ms****@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "SAL" <SA*@nospam.nospam> Subject: Re: GridView update problem Date: Wed, 16 Jul 2008 10:39:42 -0700
> Okay.
Thanks so much for you support.
SAL
"Steven Cheng [MSFT]" <st*****@online.microsoft.comwrote in message news:aR**************@TK2MSFTNGHUB02.phx.gbl...
>Thanks for your reply SAL,
I'm glad that the you got the email. For the #2 point you mentioned:
I just mean the Validation event of your validator control. Since you use server-side validation, you need to make sure that the validation doesn't work correctly and sometimes if the validation fails or not work correctly, that may also prevent the other sequential postback event(such as
Gridview
>updating) work.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you.
Please
>feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: ms****@microsoft.com.
================================================= = Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscripti...ult.aspx#notif
>ications.======================================== ========== This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>>>From: "SAL" <SA*@nospam.nospam> References: <Oh**************@TK2MSFTNGP06.phx.gbl>
<e5**************@TK2MSFTNGHUB02.phx.gbl<O72hdQe4 IHA.511
>>>Subject: Re: GridView update problem Date: Tue, 15 Jul 2008 12:47:10 -0700
>>>Okay, I got your reply now. For some reason it didn't show up when I
opened
>>>up outlook express.
I'm doing the updating manually now and took out the code from
rowcommand.
>>> I made the changes you suggested for the ValidationGroup and the Update button is now posting back.
I didn't quite understand what you were saying in #2 below however.
S >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: |
last post by:
Hello,
I have created an ASP.NET 2.0 application that utilized a Gridview Control
to display and update/delete data.
The problem I am having is that the gridview control is displaying the data...
|
by: Mike Kelly |
last post by:
I've chosen to implement the "optimistic concurrency" model in my
application. To assist in that, I've added a ROWVERSION (TIMESTAMP) column to
my main tables. I read the value of the column in my...
|
by: Aws |
last post by:
My crazy GridView !!
I am using Visual Studio 2005, I have a problem with my GridView.
I have one access .mdb table and when I update a record on the table
EVERYTHING is perfect. I made a Web...
|
by: misiek |
last post by:
Hi all.
I have following problem:
1. In my web page I have a GridView control, which does not have a
DataSourceId set in designer.
2. When user presses Start button then I create...
|
by: DC |
last post by:
The problem
I'm using the .NET GridView and FormView objects for the first time and
im getting the error "An OleDbParameter with ParameterName '@ID' is not
contained by this...
|
by: Evan M. |
last post by:
Here's my GridView and my SqlDataSource
<asp:GridView ID="ContactHistoryGrid" runat="server"
AutoGenerateColumns="False" DataSourceID="ContactHistoryDS"
DataKeyNames="JobHistoryID"...
|
by: tim.cavins |
last post by:
I have a GridView populated by an ObjectDataSource.
I am having issues passing the parameters to the objectdatasource. I
have verified that the method is being called but none of the
parameters...
|
by: mohaaron |
last post by:
This seems like it should be simple to do but for some reason I have
been unable to make it work.
I would like to databind a SqlDataSource to a GridView during the
click event of a button. This...
|
by: Ed Dror |
last post by:
Hi there,
I'm using ASP.NET 2.0 and SQL Server 2005 with VS 2005 Pro.
I have a Price page (my website require login) with GridView with the
following columns
PriceID, Amount, Approved,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |