how to update datagrid's datasource from another frame page

Hi,

I have a page that is split into two frames: top and bottom. The top page is
a search parameters page and the bottom is the results page; which holds the
datagrid. The search page sends the parameters to a stored procedure. I
would like to update the datasource of the datagrid based on the results of
the stored procedure. I have tried referencing the datagrid explictly based
on its class name of the codebehind file but I am unsuccessful. My stored
procedure has been tested and it works. Any ideas how I can update the
datagrid's datasource from the other page?
Thanks.

Nov 18 '05 #1

Subscribe Reply

1686

Tommy

If I understand correctly, your search page retrieve the data from
that database, and you want to transfer that data to the result page,
and all this needs to happen in a single reqeust.

I don't think it is possible because when you get to the server side,
you don't have an instance of the result page class. You could save
the data to a session object, redirect the client to the result page,
and have the result page retrieve the data from the session. However,
this will be a bad design because your web server will scale well
under high volume.

Instead, I think your search page should post the parameters to the
result page, the result page then calls the stored procedure, and bind
the data to the datagrid.

Tommy,

"Mo" <mu****@astleyg ilbert.com> wrote in message news:<#U******* *******@TK2MSFT NGP10.phx.gbl>. ..

Hi,

I have a page that is split into two frames: top and bottom. The top page is
a search parameters page and the bottom is the results page; which holds the
datagrid. The search page sends the parameters to a stored procedure. I
would like to update the datasource of the datagrid based on the results of
the stored procedure. I have tried referencing the datagrid explictly based
on its class name of the codebehind file but I am unsuccessful. My stored
procedure has been tested and it works. Any ideas how I can update the
datagrid's datasource from the other page?
Thanks.

Nov 18 '05 #2

Hi Tommy,

Thanks for the suggestions. I sent my search page values as url parameters
to the results page then I called the stored proc and did the binding, and
everything works great!
"Tommy" <We**********@H otmail.com> wrote in message
news:a8******** *************** ***@posting.goo gle.com...

If I understand correctly, your search page retrieve the data from
that database, and you want to transfer that data to the result page,
and all this needs to happen in a single reqeust.

I don't think it is possible because when you get to the server side,
you don't have an instance of the result page class. You could save
the data to a session object, redirect the client to the result page,
and have the result page retrieve the data from the session. However,
this will be a bad design because your web server will scale well
under high volume.

Instead, I think your search page should post the parameters to the
result page, the result page then calls the stored procedure, and bind
the data to the datagrid.

Tommy,

"Mo" <mu****@astleyg ilbert.com> wrote in message

news:<#U******* *******@TK2MSFT NGP10.phx.gbl>. ..

Hi,

I have a page that is split into two frames: top and bottom. The top page is a search parameters page and the bottom is the results page; which holds the datagrid. The search page sends the parameters to a stored procedure. I would like to update the datasource of the datagrid based on the results of the stored procedure. I have tried referencing the datagrid explictly based on its class name of the codebehind file but I am unsuccessful. My stored procedure has been tested and it works. Any ideas how I can update the
datagrid's datasource from the other page?
Thanks.

Nov 18 '05 #3

Similar topics

4929

Editable DataGrid Shows Old Values "After" Update

by: Kevin Pedersen | last post by:

Hello, I am using an editable datagrid. After I save the changes the datagrid shows the old values. I've read the posts about the Page_Load and not binding the datagrid each time. The SQL that is being sent to the database is correct and the changes are eventually being made. If I refresh the page after the update then the new values appear. I noticed that when I put a breakpoint in my update handler everything works fine. When I take...

ASP.NET

1488

Framesets - Event in frame 'A' triggering update of frame 'B' -How ?

by: JAW | last post by:

I have posted this in a couple of the other newsgropus but have not recieved any responses. Thought I would try it here. I have a frameset that contains frames (top and bottom). In the bottopm frame I have a datagrid, with a command button on the first column of the grid. When I click on the button for the appropiate row of data, I retreive information from the row of the datagrid and place this information into session variables for the...

ASP.NET

2647

innertext, javascript, datagrid, database update

by: Lyners | last post by:

I have a web page writen in ASP.NET that contains some javascript so that when a user presses a button, or edits a certain field in a datagrid, another cell in the datagrid is filled with a value. My probelm.... when I have the user press the update button (which does a post back that loops through the datagrid and updates a database) the field/cell that is filled by the javascript appears to be blank in my update code, even though I can...

ASP.NET

2276

Big DataGrid Update Problem-MVP Help Please????

by: steroche | last post by:

I would REALLY appreciate help please please please! Im sure it is probably blindingly obvious to most of you but I am totally in the dark here!I am lost - i thought i had finally figured out this dataSet updating lark when i realised that i think i am right back at square 1!!! Here's my scenario - i have a SQLDB and i retrieve all my data from that into a dataset and display this to a datagrid(WebForm). I have got this grid sorted and...

ASP.NET

2146

MDB Database won't update

by: Jonathan Upright | last post by:

Greetings to anyone who can help: I'm using WebMatrix to make ASP.NET pages, and I chose the "Editable DataGrid" at the project selector screen. As you may know, it defaults to the Microsoft SQL database "pubs". I've followed the instructions in the comments and also changed everything pertaining to SQL over to OLEDB. (i.e. Changed SqlDbType. to OleDbType.) I also changed the datafield names and variable names accordingly. The page...

ASP.NET

4290

Currency Violation. Update command affect 0 records

by: Geraldine Hobley | last post by:

Hello I'm getting the above mentioned error in my applicatio I have a datagrid bound to a datasource like s MyDatagrid.DataSource = Mydataset.Tables(Order) - this all works fine However I have another field on the form which is a richtextbox and is bound to another field in the same datasourc like s Me.RtxtDialog.DataBindings.Add("text", MyDataset.Tables.Item("Orders"), "MyRichTextField") - this field accepts nulls in the databas

Visual Basic .NET

2451

How to use one datagrid to update/insert into another

by: shookim | last post by:

I don't care how one suggests I do it, but I've been searching for days on how to implement this concept. I'm trying to use some kind of grid control (doesn't have to be a grid control, whatever works best) to display a dropdown menu of fields populated from table tblInvoiceData. This control also includes a textbox which the user can input a value. These two columns are side by side and not in a vertical layout. The user then clicks on...

Visual Basic .NET

2294

how to update data in datagrid by an update button outside the datagrid

by: geeteshss | last post by:

Dear all, actually i spent a whole month on the R&D of datagrid edit ,update,cancel events but recently my guide told me to make it user friendly because no user would like to go on searching rows and columns in a datagrid if there are number of rows and columns.so in my web page i have got two labels two textboxes and three buttons namely add update and delete so when i click on the add button the data is added to datagrid and also displayed...

.NET Framework

3080

populating Crystal Reports from DataGrid data

by: Brock | last post by:

I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report reflect the values they anticipate committing to see hypothetical totals of columns from a set of records. These records are displaying properly on my DataGrid but I'm not sure how to get Crystal Reports 10 to use as its datasource the dataset...

ASP.NET

8691

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9180

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8920

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7755

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6536

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5877

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4378

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4633

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2351

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP