get data from gridview without querying database

Posted by frank2009 on Stack Overflow See other posts from Stack Overflow or by frank2009
Published on 2009-11-11T21:58:01Z Indexed on 2010/03/28 8:03 UTC
Read the original article Hit count: 175

Filed under:

gridview

|

select

Hi there

I am new at this so please bear with me...

I have managed to get the following code to work...so when I click on the "select" link in each row of the gridview, the data is transfered to other label/textbox on the webpage.

So far so good, the thing is that everytime I click on select...it goes and checks on the database for the data and there is a delay of a few seconds... I was hoping that the data, since it is already visible on the gridrows, is simply "picked up" and used on other labels/textboxes...without requerying the database.

Is this possible ? Thanks in advance

Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
    Label1.Text = GridView2.SelectedRow.Cells(8).Text
    Label2.Text = GridView2.SelectedRow.Cells(9).Text
    TextBox1.Text = GridView2.SelectedRow.Cells(7).Text
End Sub

© Stack Overflow or respective owner

Related posts about gridview

ASP.NET: Repeater with Button inside GridView: Call OnRowCommand of the GridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a asp:Repeater in one of my asp:GridView columns. In the template of the repeater I have a button. When that button is clicked, how can I get the OnRowCommand of the GridView to be called instead of the Repeater one? >>> More
Nesting gridview/formview in webuser control inside a parent gridview

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm developing an ASP.net 2 website for our HR department, where the front page has a matrix of all our departments against pay grades, with links in each cell to all the jobs for that department for that grade. These links take you a page with a gridview populated dynamically, as each department… >>> More
Display ASP.NET GridView inside a selected row in another GridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been given a mockup that I do not know is possible to code in ASP.NET without being a real html and javascript wizard. I want a GridView that when a row is selected, the selected row expands and below the selected row a panel of additional information is shown, which would also include another… >>> More
Even if GridView.DataKeyNames is set, Gridview.DataKeys[] is still empty

as seen on Stack Overflow - Search for 'Stack Overflow'
hi GridView.DataKeynames stores the names of the primary key fields for the items displayed in a GridView control. 1) Even though I’ve set DataKeyNames, GridView still doesn’t store record’s primary key value(s) in DataKey object: protected void SqlDataSource1_Selected(object sender, … >>> More
Find GridView Row from another gridview

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done? >>> More

Related posts about select

HTML muliple select should look like HTML select

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below ` <SELECT NAME="toppings" MULTIPLE SIZE=5> <OPTION VALUE="mushrooms">mushrooms <OPTION VALUE="greenpeppers">green peppers </SELECT> When the size is set to 1 small scrollbar appears… >>> More
MySQL Query Select using sub-select takes too long

as seen on Stack Overflow - Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables: SELECT * FROM table_1 WHERE id IN ( SELECT id_element FROM table_2 WHERE column_2=3103); This query took approximatively 242 seconds. But when I executed the subquery SELECT id_element FROM table_2 WHERE column_2=3103 it… >>> More
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to… >>> More
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?

as seen on Programmers - Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 }; var contacts = from c in context.Contacts where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault() select c; foreach (var item in contacts) Console.WriteLine(item.ContactID); Linq-to-Entities… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More