State Management :: Data Being Saved To Wrong Table In Wrong Instance Of Sqlserver Of Wrong Database?

Aug 1, 2010

I have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?

View 7 Replies

Similar Messages:

ADO.NET :: Data Saving To Wrong Database On Wrong Instance Of Sqlserver

Aug 1, 2010

I have a very weird thing happening. I have two databases that have exactly the same tables but different database names on the same virtual machine, but in different instances of SQL Server. For some reason, when using one of them, it will save to the other. In debug, looking at my connection string..I have verified that it is correct, yet when I allow the save, I look in the table and it isn't there, it is in the other database that is in a table with a completely different name and in a different instance of SQL Server.

View 1 Replies

DropDownList Passing Wrong Value To Database Sqlserver

Feb 11, 2010

I'm working with a series of 4 dropdownlists. The First and Third seem to be passing correct values to the database. The second and fourth pass correct value from 0 to 9 but will not pass two digit values. If selected value is 23 the value 1 is sent to database. The four dropdownlists are entered sequentially with other data and sent to database by submit button. All other fields seem to be updating correctly.

The data fields which will not update with two digits are integers. Value 0 to 9 works, 10 to 31 do not. I'm pretty new at this and totally stumped.

View 7 Replies

SQL Server :: Insert Data Into Temp Table Will Occurs Wrong Order By Performance?

Jan 3, 2011

i just create table simply like this: create table tblDemo

PK_intID int primary key identify(1,1),
intHits int not null


View 3 Replies

C# - Wrong State In Server Controls With Same ID's When Dynamically Adding UserControl To UpdatePanel?

Feb 6, 2010

Here is what I am trying to do. I have a page with two link buttons and an updatepanel (the two linkbuttons trigger the updatepanel). I have two usercontrols which have labels with same ID's. When I click the first link button, I add the first usercontrol to the updatepanel and set the label value to

when i click the second link button i add the second usercontrol but i see that the value of the label from the first control is set in the label in second user control. if the id's are different there is no problem - but in my case the usercontrols are being developed by different teams and I am integrating them in the way i mentioned - so they may have same ids.

View 2 Replies

Sql Server - App Pointing To Wrong Database

Feb 28, 2011

I've got a web app that uses a MS SQL Server 2008 database. Recently I made two copies of the database, one for ongoing development, the other for users to begin testing and evaluting the application.

I've got two seperate web applications now. I've changed the web.config of the 'test' version to point to the test DB, but it still seems to be using the previous version.

Is this cached somewhere? I've run IISRESET on the box, but the the 'test' version of my web app still seems to point to the wrong DB.

View 3 Replies

SQL Server :: Try MD5 Hash For (submited Value+table Field) Get The Wrong Answer

Jul 15, 2010

I have two pages:

1) login and send username,password, machineID and a rand string to the server
2) check the machineID whether it exists in the table.

Problem is the checking machine procedure:

select MachineID from computer where MD5MachineID=@MD5MachineID2 and SUBSTRING((master.dbo.fn_varbintohexstr(HASHBYTES('MD5',MachineID+@RString))),3,32)=@MIDST

RString,MD5MachineID2,MIDST are submited by Login MD5MachineID is stored in table.

I need the check if MD5(MachineID+RString) is match the MIDST (submited).

Now the situation is :

if RString is a fixed string(not a variable).like 'abcdefg', the MD5 is correct.

if I use the RString (submited value as a variable), the MD5 is incorrect.

View 1 Replies

SQL Server :: Inserting Wrong Date In Database

Dec 15, 2010

i am working in the and inserting the date into DATETIME field sql db. During duging am checking it shows correct date but when insert into db it show "1/1/1900 00:00:00" . I dont know whats the problem. Code:

Dim ObjDob As DateTime = CDate(Me.ddlDates.SelectedValue & "/" & Me.ddlMonths.SelectedValue & "/" & Me.ddlYears.SelectedValue).ToString("dd/MM/yyyy")

View 6 Replies

Access :: Wrong Values Being Input To The Database?

Oct 26, 2010

I have been writing a customer based applicationweb form. In the case "the button" takes information from textboxes and "updates" the Access database with the input. The problem I am running into is that for "LName, Zip, and Phone" -- the program is returning values of zero for only these 3. Here is the code.

protected void Button1_Click(object sender, EventArgs e)
string ss = TextBox1.Text;
string fName= TextBox2.Text;
string mName= TextBox3.Text;
string lName = TextBox4.Text;


View 3 Replies

Data Controls :: DropDownList Is Showing Wrong Data In Selected Value From Database?

Mar 12, 2014

There is a Dropdown(named "Station") in my code.

<asp:DropDownList ID="DStation" runat="server" Width="100%"></asp:DropDownList>

Im fetching the data saved in DB inside dropdown SelectedValue on page load as below:

protected void Page_Load(object sender, EventArgs e)
if (!Page.IsPostBack)


But its always showing "ABC" (i.e, 1st Id's station) in selectedValue of dropdown, for every "id" dont know why.

View 1 Replies - IIS7 Application Using Wrong SQL Server 2008 Express Database?

Sep 8, 2010

I'm stumped. I have a client site on a virtual private server - Windows Web Server 2008 SP2, IIS7, SQL Server 2008 Express.I'm trying to setup a second web application, to allow him to review updates prior to their going live. I've created the web application in IIS7, and I have added a second database to SQL Server. The second db is essentially a copy of the production db, with 'DEV' prefixed to the database name and a few new fields in a few tables.My production site works fine. However, the test site comes back with an SqlException: "Invalid column name 'version'." This is one of the new fields - which leads me to believe that my dev site is referring to the production database, and not the dev database. Connection strings, however, do point to different databases (although the login is the same for both):


View 1 Replies

SQL Server :: Search A Text In The Database Even If User Writes Wrong Spelling?

Dec 11, 2010

i want to search a text in the database even if user writes wrong spelling.

I am using LIKE operator. But I am not getting exact result.

For example: I want to search 'Norrebro' if user types 'Norebro' (wrong spelling)

LIKE operator does not work in this case. So how can I get the exact result??

View 1 Replies

AJAX :: Webservice Returns Wrong Data?

Jun 25, 2010

So I have a WebMethod that I call using jQuery. The method is supposed to return a unique URL to a image file created dynamicly.

The WebMethod is called in a for loop so anywhere from 1 to 50 calls gets fired async.

The problem is that the webservice seems to be using the same instance of the object, so that it returns the same value to a couple of the requests.


Shouldn't the WebMethod create a new instance of the class for each call, so that all values are stored individually in memory?


View 3 Replies

Web Forms :: Wrong Data Getting Inserted Into Printed Report?

Jan 26, 2011

So I have an ASPX page. the only thing i am doing is creating a XPS/PDF report to be sent to a customer. everything works well but now we have a bunch of customers and people are hitting the page quite a bit and we got a complaint about wrong data being in the report. i can reproduce this when i hammer the aspx page with like 10 reports at once. I will see the 2nd persons data in the first persons report randomly. is there something going on with cacheing or is it using the same instance of the page when the 2nd request comes in while the first report is getting generated?

View 6 Replies

ListView Controls Display Wrong Data The 3rd Time?

Aug 11, 2010

I have a ListView that populates and displays a user's data (via a profile system in VWD 2008) during Page_Load and also when I go from the EditItemTemplate to the ItemTemplate.

When I go to the edit screen again, my DropDownList and RadioButtonList controls display the first items in the corresponding tables instead of the correct profile values.

I don't understand why the controls populate correctly the first and second times but not on the third time (that's right, the third time is NOT a charm).


View 2 Replies

AJAX :: Tabcontainer Shows Wrong Tab Data After Postback

Feb 22, 2011

My setup is as follows: I have 4 tabs of data, all of which are invisible when the page loads. The user enters some search criteria, hits the search button, and then the first tab fills up a gridview with data and becomes visible. One of the columns in this grid is a linkbutton named 'detail'. When they click on 'detail', the 3 remaining tabs go and get their data from the database and become visible. On tab#2, I have a listview which allows editing/adding of data. Here is my problem: When I click the imagebutton on the listview that puts the listview into edit mode, the data from the first tab is now shown on the second tab.

So the correct tab (tab#2) remains selected, but the other tab's data is being displayed. Has anyone else run across this? I have tried numerous combinations of update panels and triggers but I always get the same results. Also, the last 3 tabs each contain a usercontrol. I don't know if that has anything to do with it.

View 6 Replies

Forms Data Controls :: Gridview Edits Wrong Row?

Jan 11, 2011

I have a page with a gridview. It has a select command and an edit command which are both SPs. I added a standard "Edit, Update, Cancel" CommandField to the gridview so that I can edit. The edit and update are working fine. However, I have found that if the underlying data changes after I have loaded the page and before I hit "Edit", and this change causes the row I'm going to edit to be in a different row than before, the gridview will open the wrong row for editing.

For example, say the gridview is sorted by the a field called ID, and currently there are rows in the DB with ID of 2,4,6 and 8. I load the page and see those 4 records. While I'm looking, someone adds a record with ID of 1. When I click Edit on the row with ID = 4, I will actually end up editing the record with ID 2. Basically, i'm clicking on Edit in the second row, and I end up editing the record in the 2nd row, but the 2nd row is now a different record than before.

It seems like there HAS to be a way to fix this, otherwise editing in the gridview seems exceptionally dangerous. Is there any easy way to handle this, to make sure the user is editing the row they think they are?

View 17 Replies

Forms Data Controls ::Pie Chart Display Wrong Percentages

Apr 19, 2010

I have use chart controller in my web application but it display wrong percentages this are the value:
TOTAL COST : 75000000000.00
LOYALTY DISCOUNT : 7500000000.00

When it display on pie chart it display TOTAL COST :90.91% and LOYALTY DISCOUNT=9.09%
but it should be 90% and 10 % how can I correct it
chtSavingBrekDown.Series["Series1"].Points.AddXY("Total Cost", totalCost);
chtSavingBrekDown.Series["Series1"].Points.AddXY("Discounted Dolers", discountValue);
chtSavingBrekDown.Series["Series1"].ChartType = SeriesChartType.Pie;// Set the Pie width
//chtSavingBrekDown.Series["Series1"]["PointWidth"] = "0.5";// Show data points labels
chtSavingBrekDown.Series["Series1"].IsVisibleInLegend = true;
chtSavingBrekDown.Series["Series1"].LegendText = "#AXISLABEL";
chtSavingBrekDown.Series["Series1"].Label = "#PERCENT";
chtSavingBrekDown.Series["Series1"]["BarLabelStyle"] = "Center";// Show chart as 3D
chtSavingBrekDown.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;// Draw chart as 3D
chtSavingBrekDown.Series["Series1"]["DrawingStyle"] = "Cylinder";
chtSavingBrekDown.Series["Series1"].Points[1].Color = System.Drawing.Color.Yellow;
chtSavingBrekDown.Series["Series1"].Points[0].Color = System.Drawing.Color.Blue;
chtSavingBrekDown.Series["Series1"].Points[1]["Exploded"] = "true";
chtSavingBrekDown.Legends[0].Enabled = true;
chtSavingBrekDown.Titles[0].Text = "SAVING ESTIMATE BREAKDOWN";

View 1 Replies

JavaScript - Client Side Validation Causes Wrong Data To Be Displayed

Apr 5, 2011

I have a form that contains multiple and different input controls .. and I have two types of validation:

This type insures that the user input doesn't violate my application's constraints (required, max length, regExp).. and this is done on the client side using the ASP.NET Validation Controls .. and it's enforced by a server side validation.

This type works on a deeper level, like the database. it check if the entry is duplicate and any other check that can't be done on the UI level.

I use the ValidationSummary control to display the first type's errors, and a label for the second's type errors. I tried to test it with the JavaScript disabled and it worked fine, then I turned the JS back on and *Here comes the problem: *

I first try to raise an error on the db layer (by entering a name that already exists) and the error is displayed on the label and everything is good .. now I try to remove the name from the textbox and press the submit so I could raise a required field validator error the expected output is "This field is required" only but what I see is "the name already exists" and "This field is required".

I think it's because when the ASP.NET RequiredValidator works, it doesn't make a postback, so the database layer will never be validated and won't even get the label cleared!

View 1 Replies

Web Forms :: ListView List Controls Display Wrong Data The 3rd Time?

Aug 10, 2010

I have a ListView that populates and displays a user's data (via a profile system in VWD 2008) during Page_Load and also when I go from the EditItemTemplate to the ItemTemplate. Then when I go to the edit screen again, my DropDownList and RadioButtonList controls display the first items in the corresponding tables instead of the correct profile values. I don't understand why the controls populate correctly the first and second times but not on the third time (that's right, the third time is NOT a charm).






View 2 Replies

Forms Data Controls :: ComboBox DropDownList Displaying In Wrong Place On Page?

Nov 8, 2010


View 6 Replies

Forms Data Controls :: Grouping Gridview With Gridhelper Returns Wrong Row Index?

Oct 15, 2010

I'm using a GridView and GridViewHelper Class [URL] for grouping the grid by desired field. On the grid I also include an "edit" RowCommand.


ID ... Name ... Company ... Year ... RowCommand

1 ... Alex ... Comp1 ... 1999 ... Edit
2 ... Jane ... Comp2 ... 1999 ... Edit

3 ... Mike ... Comp1 ... 1999 ... Edit

Now when I click edit in the second row of the grid (ID=1, the Group itself is shown in the first row) I have the following code on RowCommand:


and the index returned is 0 instead of 1. Why? And how can I fix this, because the edit command returns error or points to the wrong records??

View 11 Replies

Forms Data Controls :: Datagrid Item.ItemIndex Keep Selecting The Wrong Row Number?

Sep 1, 2010

I apologize in advance for my poor english:1. I have a dropdownList within my datagrid and its already populated fine (22 rows in my datagrid)2. The select item for the 21 row is the same as the select item of the 22 row3. When trying to do selectedIndexChange for the 22 row, it didn't seem to work.The error:

Dim ddl As DropDownList = CType(sender, DropDownList)
Dim dgi As DataGridItem = CType(ddl.Parent.Parent, DataGridItem)
Dim rowID As Integer = dgi.ItemIndex

The rowID keep staying at 20 even though the selectedIndexChanged is happening in row 22( ie. rowID should be 21)

View 3 Replies

Forms Data Controls :: To Limit The Number Of Login Attempts, Say Not More Than 5, In Case Of Wrong?

Dec 8, 2010

I'm creating a login page. I want to limit the number of login attempts, say not more than 5, in case of wrong.I want to do it without using the asp:loghin controls and the membership.How can restrict it??

View 3 Replies

Forms Data Controls :: Wrong Time Displayed On Selected Date From Calendar?

Nov 28, 2010

I have a problem using the calendar control on Whenever I pick a date from the calendar to input it on my table which is from sql server 2005, I the wrong time. For example the time today is 6pm, 12 AM will be shown on my table. What do you think is the problem?

Do you think I have a problem with my timezone on mysql server 2005 or with my application. I'm doing a web-based program.

View 1 Replies

Copyrights 2005-15, All rights reserved