I need to modifiy my web applicaiton without affecting current transaction.
i will be having some modification in almost all days.
Right now " i stop my application and update the necessary files and strat the application again". Means i am loosing all transaction in between that modification.
Is there any way i can update my changes without affecting transaction.
i have my master page with one update panel working like a banner, so when the timer do tick every 5 sec
the image change. That works fine, but i have an update panel in my index page, this update panel works with some buttons that change the text inside the panel when click.
Now, the problem.
When i click one button to change the text and the banner change, the text returns to his default text. The update in master page is affecting the update on index page.
On my page which uses nested master pages, I have several user controls which are in their own UpdatePanels.
I've noticed that when I update something which is in UpdatePanel 2, things are shifting slightly in UpdatePanel 1. Someone told me that when UpdatePanels are used, the page is reloading anyway. Is this true?
How do I prevent UpdatePanel 2 affecting UpdatePanel 1?
P.S. All update panels are set to Conditional in their UpdateMode's.
I have an asp.net app that uses System.IO.Path.GetTempFileName() for temporary files. In the production IIS environment (W2K3), the temp folder (System.IO.Path.GetTempPath()) points to C:WindowsTemp. But on my XP dev machine it's C:documents and settingsmachinenameASPNET emp.
Is it possible to change this folder without affecting other accounts on machine?
We're having an issue with a .NET 3.5 WebForms site where occasionally our error logs start filling up with the following error message:
"Multiple controls with the same ID 'ctl09' were found. FindControl requires that controls have unique IDs."
I know very little about the exception as I have never seen it while debugging locally and have never caught it in the error logs soon enough to run a remote debugging session. I do know that an application pool recycle fixes the issue.
This only affects a single [high traffic] page in the site. The strange thing is that the site uses the pre-4.0 ID generation logic. So, when the page is working, there isn't an html element in the entire view source that isn't some autogenerated control ID prefix followed by a the 'actual' IDs (i.e. ctl09_someID_someOtherID).
What would case a control to randomly stop being built correctly? Other than the Global.asax, how can I trap this error and force the control to ... recompile? App pool to recycle?
If I use the following code, it pulls the current date from my database, I can then change the date (in the textbox), click update and the database is updated.
<asp:textbox id="UpdatedTextBox" Visible="true" runat="server" Text='<%# Bind("Updated")%>' />
I'm trying to get the textbox to automatically populate with the current date and then update the database when I click update.
If I use the command below, I get the current date (in the textbox), but date shows as blank in the database.
<asp:textbox id="UpdatedTextBox" Visible="true" runat="server" Text='<%# System.DateTime.Now.ToString()%>' />
How do I bind this so it updates my database?
After a call to initial HttpWebResponse.GetResponseStream() and reading through the stream, that stream is done for and cannot be reused.
I have a situation where I need to examine the content of the response and if it is of a certain data, get another page and then pass the new response down the line. Otherwise, pass down the original response as is. The only problem is that after examining the response to check for this "special data", that response is no good to the downstream code.
The only way, I can think of, to make this transparent to the downstream code, is to create a derived class of HttpWebResponse, and somehow cache the data streamed, and pass that cached stream down the line instead of the initial stream. I'm not sure if that's even feasible since I haven't looked into it further.
I am generating Word docs from a gridview. The Word doc gets sent to the client using a Resposne object. However, I would also like to highlight the row in question and update a file generation log display (another gridview).
All the data fucntions on the server side fire fine, but any visual updates to the current page never hit the client. The Response object seems to take over the entire response.
Is there any way to accomplish both: execute the Response and update the current page?
I have a floating div on my page that contains an image. While everything looks ok in VisualStudio 2008, when I post the page to my server, the text in the image below the upper div shifts to the left of the div.
You can see the problem in the top paragraph at this url [URL]
<%@ Page Language="VB" MasterPageFile="~/MasterPageMain.master" AutoEventWireup="false" CodeFile="About.aspx.vb" Inherits="About" title="About Us" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />....
I modified my gridview to include paging and it messed up my sorting.See a sample code below and it is not working unfortunately
[Code]...
How can I update a table with current date and time using sqldatasource control?
View 2 RepliesIn FormView EditTemplate I am trying to update record. All records are perfectly updating except one i.e. want to put CurrentDateTime (17/05/2010 10:23:00 AM). Secondly the updated Current DateTime should display in the DateTime Textbox("ClrDateTimeTextBox") in formview.
The code which I used is :
[Code]....
But I am getting following runtime error in above highlighted code:
Arithmetic overflow error converting expression to data type datetime.
I've pulling back an entity object from a database and I need to update the date to the DB server's date/time - usually you could accomplish this by setting it with the SQL getDate() function.
How can I accomplish this in the following scenario:
var client = context.client.Where(c=>c.clientID == 1).FirstOrDefault();
// the value needs to be the value of the server's current date, i.e, getDate()... not DateTime.Now
client.someDate = <somevalue>;
context.SaveChanges();
my asp net site views are different on 15" monitor than 21" screen.
site layout ruin on 21" screen however it works fine on 15".
I have a asp:ListBox wrapped inside an asp:UpdatePanel. The list box contains Bus Codes. If I select AH, for example, and then scroll down to select XY, the listbox jumps back up to the top of the list instead of staying on XY. Listbox's autopost back is set to True. As I need to get selected values and then pass it to another web page to display a crystal report. The report web page is opened using JavaScript Window.Open and on page load of the web page that contains the listbox this JavaScript is added to a button. Is there a way I can stop my list box jumping back to the 1st item?
View 13 RepliesI have built a webform as part of my project that grabs all the data out of a particular table in an Access database on the server. I have allowed the ability to update said table via the DetailsView form however when you change the details and then click on "update" it throws back an error.
No value given for one or more required parameters.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.
Source Error:
[Code]....
Stack Trace:
[Code]....
I am not sure what has happened but it simply will not allow me to update any data. Here is a copy of the select, update and delete statement.
<asp:AccessDataSource
ID="UserDetails"
runat="server"
ConflictDetection="CompareAllValues"
DataFile="\xxx.xxx.xx.xxDatabaseCSBEDBv1.0_be.mdb"
DeleteCommand="DELETE FROM [tbl_mmstafflist] WHERE [EngID] = ? AND (([EngCode] = ?) OR ([EngCode] IS NULL AND ? IS NULL))
AND (([EngName] = ?) OR ([EngName] IS NULL AND ? IS NULL)) AND (([EmailAddress] = ?) OR ([EmailAddress] IS NULL AND ? IS NULL)) AND (([Ext No] = ?) OR ([Ext No] IS NULL AND ? IS NULL)) AND (([Mobile No] = ?) OR ([Mobile No] IS NULL AND ? IS NULL)) AND (([Home
No] = ?) OR ([Home No] IS NULL AND ? IS NULL)) AND (([Address 1] = ?) OR ([Address 1] IS NULL AND ? IS NULL)) AND (([Address 2] = ?) OR ([Address 2] IS NULL AND ? IS NULL)) AND (([Address 3] = ?) OR ([Address 3] IS NULL AND ? IS NULL)) AND (([Town] = ?) OR
([Town] IS NULL AND ? IS NULL)) AND (([County] = ?) OR ([County] IS NULL AND ? IS NULL)) AND (([Postcode] = ?) OR ([Postcode] IS NULL AND ? IS NULL)) AND (([Other email address] = ?) OR ([Other email address] IS NULL AND ? IS NULL)) AND [Visa card] = ? AND
[Ex staff] = ? AND (([ExternalDirectDialNumber] = ?) OR ([ExternalDirectDialNumber] IS NULL AND ? IS NULL)) AND (([PayrollNumber] = ?) OR ([PayrollNumber] IS NULL AND ? IS NULL)) AND [NeedstoSeekApproval] = ? AND [IsStockController] = ? AND (([Group] = ?)
OR ([Group] IS NULL AND ? IS NULL)) AND (([ContractedWeeklyHours] = ?) OR ([ContractedWeeklyHours] IS NULL AND ? IS NULL)) AND (([Grade] = ?) OR ([Grade] IS NULL AND ? IS NULL)) AND (([IP] = ?) OR ([IP] IS NULL AND ? IS NULL)) AND (([StaffTitle] = ?) OR ([StaffTitle]
IS NULL AND ? IS NULL))"
InsertCommand="INSERT INTO [tbl_mmstafflist] ([EngID], [EngCode], [EngName], [EmailAddress], [Ext No], [Mobile No],
[Home No], [Address 1], [Address 2], [Address 3], [Town], [County], [Postcode], [Other email address], [Visa card], [Ex staff], [ExternalDirectDialNumber], [PayrollNumber], [NeedstoSeekApproval], [IsStockController], [Group], [ContractedWeeklyHours], [Grade],
[IP], [StaffTitle]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [tbl_mmstafflist] where ([EngID] = @EngID)"
UpdateCommand
="UPDATE [tbl_mmstafflist] SET [EngCode] = ?, [EngName] = ?, [EmailAddress] = ?, [Ext No] = ?, [Mobile No] = ?, [Home No] = ?, [Address 1] = ?, [Address 2] = ?, [Address 3] = ?, [Town] = ?, [County]
= ?, [Postcode] = ?, [Other email address] = ?, [Visa card] = ?, [Ex staff] = ?, [ExternalDirectDialNumber] = ?, [PayrollNumber] = ?, [NeedstoSeekApproval] = ?, [IsStockController] = ?, [Group] = ?, [ContractedWeeklyHours] = ?, [Grade] = ?, [IP] = ?, [StaffTitle]
= ? WHERE [EngID] = ? AND (([EngCode] = ?) OR ([EngCode] IS NULL AND ? IS NULL)) AND (([EngName] = ?) OR ([EngName] IS NULL AND ? IS NULL)) AND (([EmailAddress] = ?) OR ([EmailAddress] IS NULL AND ? IS NULL)) AND (([Ext No] = ?) OR ([Ext No] IS NULL AND ?
IS NULL)) AND (([Mobile No] = ?) OR ([Mobile No] IS NULL AND ? IS NULL)) AND (([Home No] = ?) OR ([Home No] IS NULL AND ? IS NULL)) AND (([Address 1] = ?) OR ([Address 1] IS NULL AND ? IS NULL)) AND (([Address 2] = ?) OR ([Address 2] IS NULL AND ? IS NULL))
AND (([Address 3] = ?) OR ([Address 3] IS NULL AND ? IS NULL)) AND (([Town] = ?) OR ([Town] IS NULL AND ? IS NULL)) AND (([County] = ?) OR ([County] IS NULL AND ? IS NULL)) AND (([Postcode] = ?) OR ([Postcode] IS NULL AND ? IS NULL)) AND (([Other email address]
= ?) OR ([Other email address] IS NULL AND ? IS NULL)) AND [Visa card] = ? AND [Ex staff] = ? AND (([ExternalDirectDialNumber] = ?) OR ([ExternalDirectDialNumber] IS NULL AND ? IS NULL)) AND (([PayrollNumber] = ?) OR ([PayrollNumber] IS NULL AND ? IS NULL))
AND [NeedstoSeekApproval] = ? AND [IsStockController] = ? AND (([Group] = ?) OR ([Group] IS NULL AND ? IS NULL)) AND (([ContractedWeeklyHours] = ?) OR ([ContractedWeeklyHours] IS NULL AND ? IS NULL)) AND (([Grade] = ?) OR ([Grade] IS NULL AND ? IS NULL)) AND
(([IP] = ?) OR ([IP] IS NULL AND ? IS NULL)) AND (([StaffTitle] = ?) OR ([StaffTitle] IS NULL AND ? IS NULL))">
<SelectParameters>
<asp:QueryStringParameter
Name="EngID"
QueryStringField="EngID"
Type="Decimal"
/>
</SelectParameters>
The SelectParameter is used because this page is a details page that is selected from a list. I would appreciate any help that you can offer. Unfortunately Access errors are not forth coming with information.
I have a page, let's called that Parameter page, displaying data from a database table using GridView. (The database is a SQL database.) I allow editing of data in GridView. The GridView uses stored procedure to retrieve data and to update data. In my project, users need to log in before using my asp.net project. So at every page, I know who the current user is by using HttpContext.Current.User.Identity.Name. Now as requirement changes, I need to record who has changed what (row) in the Parameter page. The information is to be written to a new table - audit log. Therefore I do not expect to change the Parameter table structure.
I have modified the stored procedure retrieving data. It returns one more column - an empty column with name currentUser. So GridView will create one more column. After data bound, I have the GridView_DataBound() to popluate that column using HttpContext.Current.User.Identity.Name.
I debug it in Visual Studio and am able to see the name of current log in user as the last column in GridView. I change the update stored procedure to take in one more parameter. That parameter, currentUser, takes default value. The default value is an empty string. So if UI part fails to send in the current user name to stored procedure, it just write the empty string as the user name. I change the <asp:SqlDataSource>. I add a <asp:Parameter> for currentUser.
[Code]....
I debug in Visual Studio. However when I save the change, the SQL profiler shows UI sends in @currentUser as NULL. Why?
I have a textbox in one grid-view column where upon entering a particular value and losing focus of the textbox, should post to the server to get the text validated through a server-side method. If the entry is valid, a result set to fill rest of row cells would be returned, else the bgcolor of the textbox needs to be changed to Red.
I tried posting back through the obvious way, i.e. making the textbox's autopostback as true and wiring up a server-side OnTextChanged event handler to validate the entered value.
It is working with this setup, but is also affecting the remaining page controls behaviour. For example, if I click a button in some other grid after entering some text in the textbox, the OnTextChanged handler gets called thus preventing the button's click event, which I also wish to call to execute its functionality.
I have two databound controls on one page. GridView, DropDownList. My page is crashing with a SQL Transaction deadlock victim error. I would like to capture this error, and attempt to re-databind the controls. My first thought was to handle an event on the controls that allow me to do this, but I don't see which event to handle. I couldn't search any answers. Where should I begin?
View 3 RepliesI am a web developer handling back end frond end both.My question is that which transaction should I use
to maintain ACID. whether transactions in Sql Server or transaction in Ado.net?
Are there any transactions around multiple webservice calls.Let me start with a commonly used example -- the travel agency. A customer intends to create a travel plan through an online travel agency. To do this, the online travel application calls the following three Web services:
-Air ticket booking
-Hotel reservation
-Taxi reservation
These three services are available from three separate vendors. If any one of these three services fails, the customer does not wish to proceed with the transaction (again, either all three services must succeed or none at all).My language programming is Asp.net c#.
Are there any transactions around multiple webservice calls?but in ASP.net forum I got the answer below:
http://jalpesh.blogspot.com/2010/05/using-transactions-with-linq-to-sql.html it's offering system.transaction.
I have an application which connect to oracle db.
I have two database hitting functions.
One is adding Userdetails(Fn Name : AddUserDtls) and another one adding address details(Fn name : AddAddresDtls) based on UserName which will get added after execution of first method ie AddUserDtls.
Problem I am facing is :
I have a single transaction and in that I have all the methods.
After the execution of first method,with out commiting i will go to second method.
and if any error occurs in second method.
I will rollback everything including the changes made by first method also.
Here one issue is there.
Since I am not committing the changes made by first method,
While I am executing the second method I am getting error that 'No user Name exists'
I understood that if we commit the transaction before the second method starts ,it will solve the issue.
But then it creates another problem.If some problem araise in the second method,then I cannot rollback the changes made by first method since it aleready commited.
I am trying to delete three related objects on one submit. Delete fails on one of the child objects, because of foreign key contraint with another table, It deletes one (the parent) but not the two child objects. All in one SubmitChanges(). I even used the TransactionScope, still same thing. So here is the scenario:
I have an object called Page which has a collection of objects called Webinars. There is another object Called Product which is one to one with Webinar.
[Code]....
i got an requirement where in the user submits the database scripts,stored procedures ,triggers ,functions or packages.i have create those in the database .if it throws an error it must be roll backed.how can i achieve this.
View 7 Replies