A couple of days ago I mentioned a project that I’ve been working on that is a bit out of the ordinary as far as Grid Views go.
One of the issues I’ve had is that the edit template doesn’t map to the view template very well. You see, the data that gets stored back to the database during the edit could go to two of four different tables.
In this example, I am going to retrieve values from categories table of Northwind database. Drag a Grid View into the Web Form and assign Data Key Names property with the primary key column i.e. In the gdview_Row Editing and gdview_Row Deleting event, we have used the below code to retrieve categoryid from datakey of Grid View, int catid = int.
Find Control("txtname"), Text Box) Dim stor_address As Text Box = Direct Cast(grid View.
Find Control("txtaddress"), Text Box) Dim city As Text Box = Direct Cast(grid View.
In this article we create a Gridview from database and add some additional operations such a add, edit and delete data in the Grid View control.
In the previous article , we learned how to create a simple Grid View at runtime .
Nor does it represent the opinion of my dog, because I don’t have one. I have a project that I coppied the above code into. Data Keys[Row Index]["Customer ID"]in the Update event it would be something like:int Customer ID = Convert. Format Exception: Input string was not in a correct format.
This demo is a continuation of my previous example “Binding Grid View with Data”. When I do an update, and get to the Grid View1_Row Updating, there is no value passed to "ID", and then when I go to the next row for "Company" I get the following error: Specified argument was out of the range of valid values. Text; bit when ichange it to string id =((Text Box) Grid View1. Line 136: Source Error: Line 134: string Um = ((Text Box)Grid View1.
If you are not familiar of binding the Grid View the way then I would suggest looking at my previous example first before you proceed to this example. Parameter name: index Any idea what I need to do to fix this issue?
In this demo, I presumed that you already have a basic background on how to create a simple database table. Thanks that cmd do not work fine string id = Grid View1.
That’s why I have placed different templates like Item Template (for normal view) and Edit Item Template (for edit view).
Free counters Added on January 19,2012 Follow Me @vmsdurano A bit About Me Disclaimer The opinions expressed herein are my own personal opinions and does not represent the opinions of my employers. Contol)Text; it werk just Fine any comment and thx for the code Instead of adding a Customer ID to your table and later pulling the text to get the ID number, a more reliable way to do it is to add a Data Key Names field to the grid example in the page: You can then access this information at any time with the following in code: Grid View1. Row Index]["id"]); You can do this with any field, but I've found customers get confused when they see the ID field and kept asking me why it was there, this also eliminates any issues if you change the display order of your table later (maybe add an edit/update/cancel control) Hey...great article ;)But I got a problem... So here I go with my example:protected void Grid View1_Row Updating(object sender, Grid View Update Event Args e) and the debugger says: Exception Details: System.
Now let’s start with putting the Grid View on page. Data Key Names="Auto ID" Auto Generate Edit Button="True" On Row Editing="Edit Record" On Row Canceling Edit="Cancel Record" On Row Updating="Update Record" Cell Padding="4" Header Style-Horizontal Align="left" On Row Deleting="Delete Record" Row Style-Vertical Align="Top" Fore Color="#333333" Grid Lines="None" In the above code, I have kept Auto Generate Columns as false so that Grid View will not render all the fields of the data source automatically.