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.
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?
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.
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.
i am working in the vb.net 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")
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.
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):
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?
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).
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.
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?
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";
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!
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).
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)
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??
I have a problem using the calendar control on asp.net. 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 asp.net application. I'm doing a web-based program.
I have a detailsView bounded by some other datasource. There is a dropdown in detailsview which is bounded by sqldatasource named "sdsNature" . Here is the templatefield for dropdown:
[Code]....
I want to show FNature instead of FNatureID in the selected mode as Label and in Edit mode as dropdown. When I am running this project, in Select mode it is showing FNatureID instead of FNature and if I click to Edit the record it is displaying following error:
'lstNature' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value Do I have to give some If else condition that if FNatureID is .... then dropdown should display FNature.... If yes then what should be the code?
I have a web form with a detailsview controlled by a linkbutton in a gridview. When the user clicks the linkbutton, a panel appears with the detailsview inside it. The select statement is created based on the commandargument of the link button. So far, if there is a record associated with the ID passed through the linkbutton, the detailsview displays correctly. However, if the user needs to update this, it jumps to the default record for that detailsview after clicking the standard update link. Without a default ID set, the detailsview does not display at all, as some IDs do not yet have a corresponding record for the detailsview.
How can I get around this issue? Also - is there a way to immediately display an open detailsview for IDs with no record associated yet?
