.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Problem in Gridview - Only first row updated, Rest not updated.

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :ASP.Net

Dear All,


I have detailsview [dtlviewRecommendation], bounded with Linq DataSource [LinqDataSourceRecommendation]. In the Item Template and Edit Template in the DetailsView, I have a GridView[gvItemRecommendation] bounded with LinqDatasource[LinqDataSourceRecommendation].

When I'm editing[For Updation] the data in the gridview [Edit mode of the DetailsView], all the data are not updated in the DB except the first row.

Only Precisely, first GridViewrow is updated. Rest of Gridview row are not updated in the database.

void LinqDataSourceRecommendation_Updating  -> Hitted once.

Any can one suggest the solution for this.



View Complete Post

More Related Resource Links

Problem in Linqdatasource update in gridview-Only first row updated.


I have detailsview 

<asp:DetailsView ID="dtlviewRecommendation" DataSourceID<

GridView not getting updated



I have a small problem with GridView. I have two tables (Clients and Projects) and I used inner join condition to join one column from another table. The Clients table consists of ClientID and Client columns while the Projects column consists of ProjectID, ClientID, Client and Project. In the GridView datasource, I used inner join statement to join the ProjectID, Project and Client columns from both the tables.

Now if I change the Client (DropdownList) in GridView and click update, the record is not getting updated.

I think that the ClientID has to be updated if the Client is changed. Can anybody suggest how the ClientID can be updated automatically once the Client is changed? Thanks

Here is the HTML code:

    <form id="form1" runat="server">

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Gridview Enable Selection Problem



I have a gridview with Enable selection and Enable Paging equals to TRUE.

I also set the PageSize of my gridview to 4 so that I only displays 4 rows per page.

The problem is when I click the pager in the bottom of my gridview, my gridview is disappearing and no records appear.

Here is code behind of my gridview:

If e.Row.RowType = DataControlRowType.DataRow Then
                e.Row.Attributes("style") = "cursor:pointer"

                e.Row.Cells(2).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(3).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(4).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(5).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))
                e.Row.Cells(6).Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Select$" & e.Row.RowIndex.ToString))

Configure Datasource using gridview problem


Hi i  have one asp.net textbox control..

and one dropdownlist inside gridview itemtemplate textbox..

what my problem..?

A Textbox36 has values some thing like this A1','A2','A3

i wirte this below query in sqldatasource1 and this sqldarasource1 is binded to gridview ItemTemplate Dropdownlist..

Select ItemName from Table1 where code in (@C)

Here @C im refering to Textbox36..

It show me the record if it has one value if its multiple like A1','A2','A3 it not showing/filtering ItemName data..

Whatz the probel?

Toolbox: Updated grid controls, open-source comparison tools, and more


This time: Windows Forms grids, professional-looking date textboxes, file merging, and more.

Scott Mitchell

MSDN Magazine November 2007

SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000


XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002

problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

how to refresh image updated with AsyncFileUpload


I've created an AsyncFileUpload device that uploads an image in ListView but it doesn't refresh on the page until the page is manually refreshed. Any ideas on how to accomplish this? This is the applicable code:

In ListView control:

<asp:UpdatePanel ID="udpPhoto" runat="server">
        <span style="text-align: center; vertical-align: middle; font-size: 7pt;">
            <br />
            <asp:Button ID="btnEPhoto" Font-Bold="False" TabIndex="160" Text="Upload/Change Photo"
                UseSubmitBehavior="False" OnClick="btnPhoto_Click" runat="server" />
            <br />
            <asp:Label ID="lblEPhoto" runat="server" Font-Bold="True" Text="Uploaded Photo:" />
            <br />
            <asp:HyperLink ID="lnkEPhoto" runat="server" BorderWidth="2px" NavigateUrl='<%# Eval("Photo_Recent") %>'
                <asp:Image runat="server" ImageUrl='<%# Eval("Photo_Recent") %>' Height="50px" ID="imgEPhoto">

Excel-like experience - gridview focus problem



I'm creating a page where people can order several items from a list without having to press "edit" and "save" in between like you normally would in a gridview. The user writes down the quantity, and finally presses a "submit" button that saves the order.

I want the user to have a windows form (or excel) like eperience, so once the user puts in the quantity and moves on to the next item, either by TAB or by clicking on the TextBox, i make some calculations without the user beeing bothered with a full refresh or having to press a buton to execute the event, so I place the controls inside an UpdatePanel and use TextBox.TextChanged. The event runs code that calculates the sum for the row (price * quantity) and shows that in a column called "Sum", and updates a label in a fixed position with the new order total ("Total").

Any ideas on how to achieve this?

Right now I use a GridView with a templatefield for the Quantity and set the TextBox.TextChanged event to fire to make the calculations. The problem is that the focus then changes.

By using SmartNavigation or the ScriptManager.SetFocus I manage to retain focus on the TextBox that executed the Postback, but the user might have moved on to a textbox far down the gridview (thus causing the postback by leaving the previo

GridView Problem


I've been asked to change an ASP.NET project to MVP Architecture - which may have something to do with what is going wrong.

I make the call through the architecture to the database which returns a dataset which I've verified is correct, (using dataset.writeXML() ) just before databinding  to the gridview.

On one page everything works as expected (plus any post backs). Another page the Page_Load works correct and the gridview is populated, but any postbacks do not work- it retains the Page_Load's data. Then on the third page the GridView never shows though databinded. In all these cases I've checked that the Dataset is good data, and made sure to DataBind().

All three use the exact same logic. Any ideas or suggestions are greatly appreicated.

Thank you for your help.

public partial class UI_Admin_manageFirms : System.Web.UI.Page, IManageFirms_Pres
    static ManageFirms_Pres presentation;

    protected void Page_Load(object sender, EventArgs e)
        if (!Page.IsPostBack)
            presentation = new ManageFirms_Pres(this);

    protected void btnSearch_Click(object sender, EventArgs e)
        string firmName = (txtFirmName.Text != string.Empty) ? txtFirmName.Text : null;

KPI for updated values


I would like to show a value in a KPI and I wonder if there's a way to have a list or something simple where ONE value can be inputted and possibly overwritten (using versioning for history) and that value is updated so the KPI indicates the updated value.  Normally this value will be updated daily.

I checked out Last list value as KPI and it says that it can't be done.  I don't know if anyone has any suggestions or recommendations for this.  I know that they want a history of this and they are currently referencing it in an excel spreadsheet that is linking and the Excel Services is running but seems to be having trouble.


The Values today are: 8

The above information would be updated daily and there only needs to be ONE value put in to do that update.  Is there something I could do out of the box (I don't do programming, but I do have SharePoint Designer).  For me, if a user inputs the value in a custom list, how do I have the KPI reference the LAST item, instead of a sum or max, or min.?  Is there a way to have only ONE item in the list that overwrites the other, without having to edit it?  I know views show that, if you

Workflow doesn't complete when a task is updated directly from an infopath form.

I have an approval workflow that creates a task for a group to approve or reject an InfoPath form. But if a member of the group opens the form and updates the task from there, it doesn't complete the workflow. It only completes the workflow if they go to the actual task and update it from there. Does anyone know how to fix that?

gridview problem....

I am sending .aspx page and code behind page ,where what i want to do is i used RequiredFieldValidator and  ValidatorCalloutExtender  both and one link is their called AddNew. When  user hit the Addnew link and if txt_srno field is empty  then requiredfieldvalidator get fire and error message will show.please someone help me get the answer...

Will SQL Server Compact feature an updated and more capable OLEDB driver

Hi, Earlier, we found problems with using SQL CE 3.5 via OLEDB. While some limited functionality was available and data can be accessed via commands and recordset via OLEDB/ADO from, say, Excel or Access, we were unable to access SQL CE directly from other data-driven packages that nominally support OLEDB, most importantly SAS and SPSS. So our question is whether SQL Server Compact will feature an updated and more capable OLEDB driver? Thx and regards, Ralph

gridview problem

hi all asp.net developers i have a problem with gridview i want show ten record from table in the gridview at 2 column in five row. like this:------------gridview-------------record1 | record2record3 | record4record5 | record6record7 | record8record9 | record101 2 3 ...-----------------------

gridview problem

hi all asp.net developersi have a problem with gridviewi want show ten record from table in the gridview at 2 column in five row.thank you.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend