I have deveopmed i web site in ASP.NET and C# using Visual Studio 2008. I have a problem with performing button events twice. A user has a web page open. He click on a button (Save) and data is added to the database. He then presses F5 to update the page, and the button event is fired again adding more data to the database that should no be added. My question is how can I avoid this scenario?
View 3 RepliesI have the following data that basically I only need a few bits of information from:
Resource:X - Y;Z - Å;Type:(all) From Date:
07/12/2010 - To Date 07/12/2010 Sort
by:Time Include Referring
source/physician:No Footer:Default
Criteria:None
","Appointments","X,
Y","ZAssociates","Monday, July 12,
2010","Time","Patient Name","Patient
ID","Appt. Type","Ref. Source/
Physician","Phone","Type","DOB
","Z, X","Y","7/12/2010
12:00:00AM","Time","Patient
Name","Patient ID","Appt.
Type","Phone","Type","DOB "," 7:30
[snip]
The only things I need from this are:
Patients Name
Drs Name
Patients Phone Number
Appt Time
Appt Date
and the rest of the information I can discard. A customer uploads this as a .csv file (even though it really isn't as you can see) and I'd like to parse the needed information and post that to my SQL database and discard the rest. I think I can do this with a dataset but I've never built that before. The fields from the customer will always be the same and the fields I will need will always be the same. Also, the date time has to be in the format of yyyy/mm/dd:hhmm and the phone number always has to have 512 as a prefix. Here is the code I currently have for my site:
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub Submit1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim SaveLocation = "\xxxWEB3wwwrootWebfile1RemindersDoug_Ancildoug.csv"
If UploadFile(SaveLocation) Then
'the file was uploaded: now try saving it to the database
SaveToDatabase(SaveLocation)
End If
End Sub
Private Function UploadFile(ByVal SavePath As String) As Boolean
Dim fileWasUploaded As Boolean = False 'indicates whether or not the file was uploaded
'Checking if the file upload control contains a file
If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then
Try
'checking if it was .txt file BEFORE UPLOADING IT!
'You used to upload it first...but the file could be a virus
If File1.FileName = ("doug.csv") = False Then
'The file is not the expected type...do not upload it
'just post the validation message
message.Text = "Sorry, thats not the correct file."
message2.Text = "Please locate and upload 'doug.csv'"
Else
'The file is a .txt file
'checking to see if the file exists already
'If it does exist Deleting the existing one so that the new one can be created
If IO.File.Exists(SavePath) Then
IO.File.Delete(SavePath)
End If
'Now upload the file (save it to your server)
File1.PostedFile.SaveAs(SavePath)
'After saving it check to see if it exists
If File.Exists(SavePath) Then
'Upload was sucessful
message.Text = "Thank you for your submission."
fileWasUploaded = True
Else
'the file was not saved
message.Text = "Unable to save the file."
End If
End If
Catch Exc As Exception
'We encountered a problem
message.Text = "Your file was not in the correct format. Please contact Customer Service at xxxx-xxxx-xxxx."
End Try
Else
'No file was selected for uploading
message.Text = "Please select a file to upload."
End If
Return fileWasUploaded
End Function
Private Sub SaveToDatabase(ByVal SavePath As String)
Try
Dim sqlQueryText As String = _
"BULK INSERT dialerresults " + _
"FROM '" & SavePath & "' " + _
"WITH ( FIELDTERMINATOR = ',' , ROWTERMINATOR = '
' )"
' and bulk import the data:
'If ConfigurationManager.ConnectionStrings("Dialerresults") IsNot Nothing Then
'Dim connection As String = ConfigurationManager.ConnectionStrings("Dialerresults").ConnectionString
Dim connection As String = "data source=10.2.1.40;initial catalog=IVRDialer;uid=xxxx;password=xxxxx;"
Using con As New SqlConnection(connection)
con.Open()
' execute the bulk import
Using cmd As New SqlCommand(sqlQueryText, con)
cmd.ExecuteNonQuery()
End Using
End Using
'Else
'message.Text="ConfigurationManager.ConnectionStrings('Dialerresults') is Nothing!"
'End If
Catch ex As Exception
message.Text = "Your file was not in the correct format. Please contact Customer Service at xxxxxxx."
End Try
End Sub
End Class
I would like to create a module that is similar to the inventory system but not with a whole lot of bells and whistles. Basically, I have a jumper business and would like create a database to hold the items (jumper, pop-corn machine, etc.). I would like to have a calendar that when a user click on a date that he/she like to book my item only the available items display and not the one that is already booked. Pretty much to prevent the same item to get book by two different people on the same date. I also would like to create a form on the order page to have the booking information to go into the database.
View 11 RepliesI have the following data that basically I only need a few bits of information from: The only things I need from this are:
Patients Name
Drs Name
Patients Phone Number
Appt Time
Appt Date
and the rest of the information I can discard. A customer uploads this as a .csv file (even though it really isn't as you can see) and I'd like to parse the needed information and post that to my SQL database and discard the rest. I think I can do this with a dataset but I've never built that before. The fields from the customer will always be the same and the fields I will need will always be the same. Also, the date time has to be in the format of yyyy/mm/dd:hhmm and the phone number always has to have 512 as a prefix. Here is the code I currently have for my site:
[Code]....
Scenario : I want to add data from database to checklistbox on page_load and checked data should be stored in other table.I want to bind data to checklistbox like a gridview, i m trying but i m not able to.
View 2 RepliesI created a site that updates a database through a detailsview grid, however it wont let me input decimals. An example of my code is
HeaderText="Assignment_Job_Type" SortExpression="Assignment_Job_Type" />
Is it possible to add values from different database rows to a dropdownlist?
I'm currently trying to add both ItemSizeSmall and ItemSizeMedium, but through trial and error I can still only add one row from the database. I want the dropdownlist to display "Small" and "Medium" etc.
I guess my primary question is: How do I create a database with product size attributes?
I apologize if this thread should be in another forum, but if the dropdownlist can display two database rows I'll settle with that solution.
Could the database look like this:
table1: product
PK: productID
table2: productAttribute
PK: productID
PK: attributeValueID
table3: attributeValue
PK: attributeValueID
FK1: attributeNameID
table4: attribute
PK: attributeNameID
name
If this is right: How do I make the dropdownlist display the different sizes?
I have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
<asp:TemplateField HeaderText="Debug">
<ItemTemplate>
<asp:DropDownList ID="grdDebug" runat="server" AutoPostBack="false" SelectedValue='<%# Bind("Debug") %>'>
[code]...
I have currently have Microsoft Visual Web Developer 2008 Express Edition and SQL Server 2008 R2 installed on my PC but I am having problems finding out where I enter my data to populate tables held in my db.
On the SQL 2005 version their was a option to open the specified table and add in information.
I've looked at both 2008 programmes and it's not obvious to me on how I would do this.
I am getting some float values in front end from back end.For example suppose I get 7.770000 the through convert.double I am converting it into 7.77.This is perfectly fine.But when I have 0.00005 then convert.double is displaying it like 5E-05, which is not fine.
View 3 RepliesI have an aspx page like this:
[Code]....
Well, as you see clicking the button will redirect user to "http://www.somesite.com/somewhere" and also will post three specified fields as data to that page; which can be retrieved using Request.Form["field#"] at destination.
I want to do all these works using C# or VB.NET code, because I don't want my hidden fields to be accessible to users (who may use firebug or something similar).
I have created a web form where users input there details and submit it to an acess database. I also want the current data and time of there submition to be stored into the database along with the other information. I was thinking about making the time and data displaying in a lable or textbox and submit the the values within them into the database. I have been looking around the internt on how to do this but I couldn't get any of the examples I have tried working. Is there another way to create this funnctionality.
View 5 RepliesI have an application that needs to post data to a url on the web and then receive an xml response. I have an HTML form (provided by vendor) that posts the data correctly, however when clicking the submit button the page is redirected to the post url and the xml is displayed in the browser. I need to do this on a postback within an existing asp.net project. Basically, the user will fill out the form, the form data will post to the url, the xml response will be received, and the appropriate values will be displayed on the screen. I've found a bunch of examples for doing this but I just can't seem to get my head around it. Can anyone point me in the right direction or explain how I should go about this?
View 7 RepliesI have 2 forms and i want to pass data to the second from the first. All i get is null value or nothing. In the first page i have :
[Code]....
Before response i check the value and it's "7" Then on my second page i have. on page load, or on a button. Dim s As String = Request.Form("CurrentId") I have also tried with putting on markup:
[Code]....
I have a DropDownList on my webpage using an Access Database to fill it. However in my database record there a multible values with the same name.
My situation now:
MyDropDownList1
-ValueBaarlo
-ValueBaarlo
-ValueVenlo
-ValueMaasbree
-ValueMaasbree
-ValueMaasbree
-ValueMaasbree
What I want:
MyDropDownList1
-ValueBaarlo
-ValueVenlo
-ValueMaasbree
I only want to show every value (name) just once!
I am trying to achieve something similar to this:
[URL]
He has a drop down list and a textbox in the header of a GridView. I am able to do this if i create a new column and put the controls in the Header Template.
However I would like my column to span across the entire GridView.Columns.Count instead of having an unsightly single column.
I have two listboxes on one panel. Box on the left has names from the database, there are two buttons. High light a name and click button1 and the name move from listbox1 to listbox2. How do you do that?
View 2 RepliesI have some global variables declared and want to access them in subrorutines using the For statement.
For example, I want to use the following to place values in the global variables , i.e, dblcell1, dblcell2, dblcell3, etc.
[Code]....
[Code]....
[Code]....
I have a Datalist with 6 elements inside (Labels and Hyperlink)This is in the "results.aspx" page. The process in started by the query stings being sent to the this page:...results.aspx?q=(ItemNameSeached)&cid=(City ID number)I have this bound to an SQL Data Source. My problem is that the ITEM_NAME, ITEM_ID (for the More... link), and the ITEM_BUILDING_ID are in one table in my database; The BUILDING_NAME and BUILDING_ADDRESS are in another table.I have an sql query string working to get the information in the items table but I don't know how to get the Building Information which is on another table. I know the sql query to get the building information (SELECT building_Name, building_address FROM buildings WHERE building_id = @ITEM_BUILDING_ID). My problem is that you can't bound two sql data sources and in the buildings query how do I get the value of the ITEM_BUILDING_ID label into the query.
View 4 Replieshere's the situation:
You're using NHibernate with Fluent NHibernate for mappings.
You have an application in production with a database with live data You're adding a new feature in development and it requires a new database column.
The new column cannot be blank. For example, I recently had to a DateCreated column to a table and the app now uses that date. As the only time the data will be missing is now, it seems unnecessary to add code to check for errors.
In my application I have an updater which can execute a SchemaUpdate to add the new database column - however, the application will starting crashing as it is expecting a value in the new column.
I need to get some sensible default data into that column. In this case I manually ran an Update to set the date to the current date (good enough for the situation). In this particular case I believe that you cannot set the column default to getdate() using fluent mappings.
Keep a schema version number in a config file In the updater that runs SchemaUpdate start adding upgrade methods for each version. These methods would run updates to add default data (or other required actions).
After the schema update has been run, call all methods required for a version greater than the current version (i.e. those that haven't previously been run). So if the app is now version 4 and version 2 is installed, methods 3 and 4 would be run.
i have read and used this script.Adding Dynamic Rows in ASP.Net GridView Control with TextBoxes..it is very usful to me but i want to fetch data from sqll database and fill the newest row with it. the past row data hav to be remain same. becoz of the same name of textbox it happens. whenever i try to fetch data from database and fill textbox all rows get updated with the same data.
View 1 RepliesI've some webpage with listview control, and double click event on each row on it.
The problem is, that when I double click the row, event is fired, that's fine, but all of the page is selected (dark blue marked, you know...).
Is there some solution to prevent select all in the whole page, or whole aplication itself?
I am using Visual Studio 2010 and have a full version of SQL Server 2008 (not SQL Server Express 2008). I would like to be able to use the database that I created in Sql Server 2008 (not sql server 2008 express) but when I go to app_code -> Add Item and select SQL Server I get the following error message:
"Connections to SQL Server database files (.mdf) requires Sql Server 2005 Express or Sql Server 2008 Express to be installed an running on the local computer ..."
Do I really need to have sql server 2008 express installed on my local computer when I already have the full blown version of Sql Server 2008 installed on my local computer.
I a problem defining the variable @Bestilling in the codeBehind for adding the record to the database using a single form page. The database design with corresponding form are as below:
My ASPX.CS:
private void GridView1_BindData()
{
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter dAd = new SqlDataAdapter("SELECT kart_DemoOrder.OrderID,
[Code]....
I get error in the method: "GridView1_AddNewRecord".
Must declare the scalar variable "@BestillingID". Is there a way to use only one Add Method and not two as I did?
Some say it is not a bug it is default in asp.net. but for me it is a bug in logic. When you say refresh it should be reload the component that you are refreshing. But in asp.net i notice that they recalling all activity and viewstate like event and data that are triggered in the previous postback. My opinion it is a redo not refresh. this is only my observation on the issue dont hate me on this microsoft fan.
on aspx page:
private
static string __VIEWSTATE_FETCH;
protected void Page_Load(object sender,
EventArgs e){
[Code]....