SqlDataSource Refresh Problem

Jul 16, 2007

Dear sirs:

I have a Web Form with an SqlDataSource with a simple select statement, and a GridView control that is tied to it. There is a ComboBox (which provides the filter-command parameter) and a Submit button as well. When a selection is made (the first time) in the combo box and then the submit button is clicked, the Selecting Event for the SqlDataSource fires and the code works perfect.

However, on subsequent "submits" with the button and selecting a different month from the combo box, I cannot get that event to fire again. What do I need to do to get this event to fire everytime the submit button is clicked and a new selection made from the drop down combo box; thus letting me know that new data is being fetched from the database?

Here is the code for the SqlDataSource:

<<asp:SqlDataSource
ID = "sqlDataSourceG5WingRailCar"
runat = "server"
ConnectionString = "<%$ ConnectionStrings:oracleConnectionString %>"
ProviderName = "<%$ ConnectionStrings:oracleConnectionString.ProviderName %>"
SelectCommand = "select distinct to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,
                            rh.movedescription ,
                            ( mds.pct_util * count( rh.movedescription ) )

                            from requesthistory rh

                            inner join movehistory mh on rh.itd_number = mh.itd_number
                            inner join movedescription mds on rh.movedescr_id = mds.movedescr_id

                            where rh.movedescr_id = 1 AND mh.discrepancy_id = 25 AND EXTRACT(MONTH FROM mh.historydatetime) = :MONTH_ID

                            group by to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,
                                         rh.movedescription ,
                                         mds.pct_util

                            order by to_date( mh.historydatetime , 'DD-MM-YYYY' )"

önSelecting="sqlDataSourceG5WingRailCar_Selecting" >
<<SelectParameters>>

<<asp:ControlParameter
ControlID = "dropDownListMonth"
Name = "MONTH_ID"
PropertyName = "SelectedValue" >>

<</asp:ControlParameter>>

<</SelectParameters>>

<</asp:SqlDataSource>>

There really is no code for the Selecting Event, other than just capturing some text into a label when the event occurs (for testing purposes).

Thanks

View 2 Replies


ADVERTISEMENT

Refresh An SQLDataSource Object Programmatically

Oct 27, 2006

Background - I have a page that uses a numeric value stored in a Session object variable as the parameter for three different SQLDataSource objects, which provide data to two asp:Repeaters and an asp:DataList.  Also, in the Page_Load, I use this value to to seed a stored procedure and an SQLDataReader to populate several unbound Labels.  This works fine.  In addition, I have a collection of 6 TextBoxes, an unbound Listbox, and two Buttons to allow the user to do searching and selection of potential matches.  This basically identifies a new numeric value that I store in the Session variable and PostBack the page (via one of the buttons).  This also works fine.Problem - I have been tasked with taking a different page and adding six textboxes to collect the search values, but to post over to this page, populate the existing search-oriented TextBoxes, adn programmatically triggering the search.  Furthermore, I have to detect the number of matching records and, if only 1, have the Repeaters and DataList display the results based on the newly selected record's key numeric value, as well as populating the unbound Labels.  I have managed to get all of this accomplished except for programmatically triggering the Repeaters and DataList "refresh".  These controls only populate as expected if a button is clicked a subsequent time, which makes sense, since that would trigger a PostBack and the Page_Load uses the new saved numeric key value from the Session.My history in app development is largely from Windows Forms development (VB6), this is my second foray into Web Form dev with ASP.NET 2.0.  I am willing to acceptthat what I am trying to do does not fit into the ASP environment, but I have to think that this is something that has been done before, and (hopefully) there is a way to do what I need.  Any ideas, oh great and wise Forum readers? *smile* 

View 3 Replies View Related

SqlDataSource - Need To Refresh Grid When Data Updated Programmatically

Nov 27, 2007

I am sending a GUID to a form via the query string.  If it exists I use helper functions to load most of the form text boxes.  However, if it does not then a blank form is presented and the GUID is stored in a hidden field. 
Regardless, I use this hidden field to populate a grid that is attached to a sqldatasource.
If I then add new datarows to the backend database programmatically, I cannot 'requery' the datasource to include those row upon a postback.  I cannot seem to find a simple way to force the sqldatasource to rerun the query.
Can anyone help.

View 2 Replies View Related

SELECT A Single Row With One SqlDataSource, Then INSERT One Of The Fields Into Another SqlDataSource

Jul 23, 2007

What is the C# code I use to do this?
I'm guessing it should be fairly simple, as there is only one row selected. I just need to pull out a specific field from that row and then insert that value into a different SqlDataSource.

View 7 Replies View Related

Individual SqlDataSource() Or Common SqlDataSource() ?

Mar 8, 2007

i am using visual web developer 2005 with SQL Express 2005 with VB as the code behindi have one database and three tables in itfor manipulating each table i am using separate SqlDataSource() is it sufficient to use one SqlDataSource() for manipulating all the three tables ? i am manipulating all the tables in the same page only please help me

View 1 Replies View Related

How To Refresh

Nov 9, 2005

sql2000

I have an existing data warehouse that is refreshed nightly from system1.

We will be moving to a new system2 1/1/06.
The old system1 will be phased out by the end of 2006.
Several tables on system2 will have different keys.

I have to move the data from both systems in the data warehouse.

Here's the issue.
I have to totaly refresh the data warehouse nightly.
Once system2 is phased out how do I keep the data from system1
and refresh only data from system2.

View 7 Replies View Related

Need Refresh Connection Or Something ?

Jun 23, 2007

HI,
I have a problem with  the data that I want to delete and insert new one on my SQL.It will work if I just delete a row. And work well if I just insert a row.But it will not work if I delete and insert at once on one procedure.
Here's the code :
    Protected Sub RolesRadioButtonList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RolesRadioButtonList.SelectedIndexChanged        Session("CurrentRoleId") = Me.RolesRadioButtonList.SelectedValue        ' Call Sub RemoveUsersInRoles        RemoveUsersInRoles()        ' Call Sub AddNewUsersInRoles        AddNewUsersInRoles()    End Sub        Sub RemoveUsersInRoles()        '   Create SQL database connection        Dim sqlConn As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")        Dim cmd As New SqlCommand        cmd.CommandType = CommandType.Text        '   Delete that row with correct UserId        cmd.CommandText = "DELETE aspnet_UsersInRoles WHERE (UserId = '" & Session("CurrentUserId") & "')"        cmd.Connection = sqlConn        sqlConn.Open()        cmd.ExecuteNonQuery()        '   Close SQL connecton        sqlConn.Close()    End Sub        Sub AddNewUsersInRoles()        '   Create SQL database connection        Dim sqlConn As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")        sqlConn.Open()        '   Create new row with new UserId        Dim sqlString As String = "INSERT INTO aspnet_UsersInRoles (UserId, RoleId) VALUES( '" & Session("CurrentUserId") & "','" & Session("CurrentRoleId") & "')"        Dim sqlComm As New SqlCommand(sqlString, sqlConn)        Dim sqlExec As Integer = sqlComm.ExecuteNonQuery        '   Close SQL connection        sqlConn.Close()    End Sub-------------------------------------------
I can delete the row if I call 'RemoveUsersInRoles'And I can insert new one if I call 'AddNewUsersInRoles'
But if 'RolesRadioButtonList_SelectedIndexChanged' is called, it will not work well.If the row not exist, it will insert new row. And that what I want.But If the row is exist, It wont delete that row and wont insert the new one. That's the problem.
Do I need some 'pause' or 'refresh connection' here ?
Thank You.

View 2 Replies View Related

Refresh Issue

Mar 21, 2001

Our application is C++ and datbases are Sybase. We are 11.5.1 Sybase. Lately some of our clients have complained about data refresh problems. That if a user has made some changes within the application then these data changes are taking long time to reflect to other users in the system. We do have in our application processes to automatically refresh data for other users but for some odd reason it is not working properly. Also every day we run sp_recompile and sp_stat on the tables and stored procs. Any ideas or leads ?

Thanks
Gohar

View 1 Replies View Related

Refresh Data

May 12, 2005

I want refresh data de SQL Server, every certain time at night, but I want that it does only, automaticy.

In SQL sentencs or DTS
What I can do. Thanks

View 1 Replies View Related

How Do I Refresh A View?

Jun 25, 2007

You know how I mentioned before that I was working with a database with a (bunch of) view(s) that are defined like this...

CREATE VIEW MyView AS
SELECT * FROM ExampleTable

Well, after altering the underlying table I noticed that the view is not picking up the new columns which leads me to believe I need to refresh the view.

Is this possible, if so, how?
SS 2K

View 14 Replies View Related

RECOMPILE / REFRESH UDF?

Dec 19, 2007

Is there a way (command or stored procedure) to RECOMPILE or REFRESH a USER DEFINED FUNCTION? I can recompile SPs with sp_recompile and refresh views with sp_refreshView, but I could not find any way to refresh User-defined functions (some of them are like views, with parameters).

Environment: SQL 2005 SP2.


Thanks !

View 4 Replies View Related

Nightly Refresh

Sep 19, 2007

Please help.I have Database A (Archived data), Database B (Transactional data).Both A and B do not have any timestamps in any tables.I need to bring A (only once because it is archived data) and B withonly differentials into Database C for reporting purposes.Currently C is cleared before loading B with differentials every nightand A is not loaded since it takes 15 hours to load.Now I want to bring A once and leave it and then bring B every nightwith differentials without clearing C.Please suggest some solutions.Thank You

View 1 Replies View Related

Refresh Default Value

Dec 14, 2006

Hello,



I have report parameters B with default from query.

This query depend on other report parameters A that updates befor report parameter B.

While user open the report and update report parameter A, the report parameter B get default value with the right default value but when user change his selection in parameter A, the default value in parameter B doesn't changed



Any idea ?

View 5 Replies View Related

Metadata Refresh?

May 15, 2006

What do you do to address this:

[OLE DB Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "objectName1" needs to be updated in the external metadata column collection.

A corollary question: what does right-clicking a package in Solution Explorer and clicking "Reload with Upgrade" do?

View 11 Replies View Related

Refresh In WebPage

Apr 3, 2008



Hi all...

when i select the 1st parameter in the report(in webpage) ... then the complete page is getting auto refreshed...same is happening for all the parameter selection...is it not possible to stop it from refreshing....

simply to say i want to get data without refreshing...

few ppl suggested me to use AJAX control but as iam not much familliar with AJAY iam trying to find some other way...can u help me pls....

Roopesh Babu V

View 1 Replies View Related

Metadata Refresh

Feb 26, 2007

-We are using SSIS packages for various kind of data load from excel source.
-If there are any change in the data type or format of excel, the package cries for the Metadata mismatch.
-During design time if you accept the metadata changes, all things work fine.

But in our case we have deployed the packages on Production Server, now the excel file format/data has changed. The packages are expecting a different metadata so they are not working at all.

Do you have any suggestions for the above problem?
Thanks, Vijay.

View 1 Replies View Related

How To Refresh The Package Log

Nov 20, 2007



HI,
I have attached logs for my packages which runs for every one hour.
so, by end of the day the size of the logs is getting more.
I would like to refresh the log for every day or for each time that the package runs.
How to get it done.
Could you please help in this.

Thanks in advance.

View 3 Replies View Related

Dataset Will Not Refresh

Mar 18, 2008



Hi all,


I have spent the last couple of hours searching previous posts to see if this problem has been address before, but I was unable to find anything.

My problem is this... I use a stored procedure to populate my report. The stored procedure has recently been modified, and while I can see these updated fields when I run it through the Data tab, the list of available fields in the Dataset sidebar does not reflect the changes.

I have tried refreshing the Report Datasets multiple times. I have tried deleting the *.rdl.data file. I have tried removing the dataset in question and re-adding it. I have tried creating a new project altogether. I've tried restarting, etc.

I recognize that I can go in and add/remove fields to/from the dataset to make it match, but this feels like a temporary fix (it resets every time I modify another of the report's dataset).

It definitely seems as if this is being cached somewhere, but where? And how can I reset this? I would appreciate any help or guidance on this, as my forehead is pretty sore from banging it against this brick wall.

Cheers!

View 7 Replies View Related

Refresh A Table

Jan 13, 2006

Can i referesh a open table?

The scenario is that i have two windows open... one is the table and the other is the query that modifies the same table. I was wondering if there is a way to refresh the table so that after i modify the table i don't have to close it and reopen it to verify the changes.

 

cheers

View 1 Replies View Related

Gridview Refresh After Update

Aug 14, 2006

Hi All,
I am new to development of asp. I have an SQLDataSource set as the data source for a grid view.  When I click on the edit link in the Gridview, change the data, and click update, the old data  is still displayed in the row.
I found exact same issue as here -- http://forums.asp.net/thread/1217014.aspx
Solution in the above thread is to add this
            {                if (reader != null) reader.Close();            }            conn.Close();
How do I apply above solution in my situation ?
 
I am updating through stored procedure.and don't have code at background.  My code is
Datasource :
<asp:SqlDataSource
ID="ds"
runat="server"
ConnectionString="<%$ ConnectionStrings:ds %>"

CancelSelectOnNullParameter="False"
ProviderName="<%$ ConnectionStrings:ds.ProviderName%>"
UpdateCommand="usp_save"
UpdateCommandType="StoredProcedure"
EnableCaching="False">
 
<UpdateParameters>
<asp:Parameter Name="field1" Type="String" />
<asp:Parameter Name="field2" Type="String" />
<asp:Parameter Name="field3" Type="String" />
<asp:Parameter Name="field4" Type="String"/>
<asp:ControlParameter Name="field5" Type="String" ControlID = "label7" />
</UpdateParameters>
 

View 8 Replies View Related

Database Refresh Question

Sep 8, 2006

There's a sql server 2000 database that was created as a copy of another db, let's say db1 and copy_of_db1. db1 has been updated (structure and data) since copy_of_db1 was created, while copy_of_db1 has remained static. I now need to update copy_of_db1 to be in sync with db1 and use copy_of_db1 so I can drop db1. What would be the fastest and most efficient way to update copy_of_db1 to mirror the current db1?

View 2 Replies View Related

How Do You Refresh Menu When Using SqlSiteMapProvider

Jun 23, 2005

I followed an article which was recently published by Jeff Prosise in his "Wicked Code" column in MSDN magazine and I was able to make it work.My problem is that I do not know how to refresh the menu. If I add new record in the sitemap table what needs to happen to refresh the menu.  

View 2 Replies View Related

Refresh Identity Column

May 14, 2001

Is it possible to refresh an identity column so that it re-numbers all columns in order starting with the identity seed without having to drop and recreate the column?

View 2 Replies View Related

Refresh Cache Memory In SQL 7.0

Nov 7, 2000

How can i clear cache memory in sql server 7.0 without stop and restart server. I need this for performance testing.

Thanks

View 1 Replies View Related

Refresh Access Client

Nov 18, 2005

Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

Can DTS do this? The forms I'm talking about are select only, no editing.

I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

Thanks,
Carl

View 5 Replies View Related

Need To Refresh (Killing Is Not An Option)

Oct 10, 2006

Hi Peepz! my problem is this i am managing more than 3 servers which has a many users. this servers have one common problem. the most users uses high cpu utilizations what make it worst is even if the process is already done for a long time (status = sleep) they still uses high cpu or IO utilization. One time i ask to confirm one user if they are really having that process and found out that the user have gone home already and no other is using thier computer. And assuming that we have more than 20 users with the same case it really make the server slow and occationally hangup. i try to kill these process/user but i think killing is not an option. Kindly help pls. are there any way to refresh connections or terminate it, how do you handle this situations?


Thanks,
Keez.


If you give me a fish ill eat for a day but if you teach me how to fish ill eat for life. :beer:

View 12 Replies View Related

Db Refresh - Need Input On Strategy

Oct 20, 2006

Hi Folks,

The Need : Refresh a part of local database daily from remote server.

Assumption : All updates in remote are updated in local db as well.


Need inputs on the type of strategy

1) Take full backup of remote, refresh on local

( Downside for us is Network and disk space )

2) DTS ( refresh only the objects required )

Looks good to us but does it take care of my assumption ?? Your suggestions welcome .. I may be wrong

3) replication ( Dont want it implement on the already complicated sceanrio ... so I'll pass)

4) Standy databases ( ??? Any help on this)

5) Any other


Thanks so much,

Warm Regards,
Ranjit.

--------------------------------------------------------------
The best moments of my life are often things I get paid for

View 3 Replies View Related

Refresh SSIS Pkg To Get The Change

Sep 19, 2007

Hi, all,

How do you refresh a SSIS pkg to get the latest table schema change?

I have this data flow task that will load data from a flat file into a table.

I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20.

Then I went into Management Studio and changed the column size.
Now in my dev BID I got next:
[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection.

I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.

Thanks!

View 3 Replies View Related

Suggestions On Database Refresh

Nov 19, 2007

I have been tasked with designing an automated process to restore production data to our testing environments on an as needed basis. The schedule would revolve around our software testing and deployment schedules. I'm looking for suggestions on best practices for this task in the form of advise / links to references / etc.. Instead of presenting all of my requirements here, I'll spare you that information :). Since part of it also needs to encompass data stored in Oracle (10g). I've done a several Google searches but would like to validate / invalidate my research against the advise of the experts here.

View 17 Replies View Related

How To Recompile / Refresh UDFs ?

Mar 6, 2007

Hi!I need to refresh an entire database.I can recompile SPs with sp_recompile (or DBCC FLUSHPROCINDB), andrefresh views with sp_refreshView, but I cannot find any way torefresh my user-defined functions (some of them are like views, withparameters).Any help appreciated :) !Ben

View 5 Replies View Related

Refresh SSIS Pkg To Get The Change

Sep 20, 2007

Hi, all,

How do you refresh a SSIS pkg to get the latest table schema change?

I have this data flow task that will load data from a flat file into a table.

I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20.

Then I went into Management Studio and changed the column size.
Now in my dev BID I got next:
[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection.

I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.

Thanks!

View 5 Replies View Related

REFRESH DATA WAREHOUSE

May 21, 2007

I€™m making warehouse for our HMIS (healthcare management information system)by using SSIS. I€™m facing some problems now, could you please help me to solve my problem.



Brief idea about my Warehouse:
Source: oracle 9i
Destination: Sql server 2005
ETL tool: SSIS



Problems:

How to refresh or load the current data to data warehouse.(now i'm using truncate sql task for deleting old/entire data for each packages, i really dont want to use in the production) . For example: The patient admissions data is adding everyday so i want to load the current data into my warehouse.
Could you pls suggest me good solution for this?


Refresh Cycle timings: is there any task available in SSIS?


current status:

First Time load completed, i set one Execute Sql statement ctrl flow task for Truncate the existing loaded data in the sql server 2005. and then again i process one data flow task for loading the data from oracle to sql server.

View 8 Replies View Related

Refresh Table In Access

Apr 7, 2008



Hello,

Now, that when I open a access I need to go to Data -> Databse Utilities - > Refresh Table Manager. Then I select which table to refresh. Is there a way to make it auto refresh when I the database?

Any help would be greatly appreciate.

Thank You

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved