How can i prevent a user from entering the same data twice, i guess i need some validation in somewhere?For example:I add a name of a city, added successfully to the table.Try adding it again, click add and the program crashes.What type of coding do i need for this, some type of compare tool or something for the table?
View 1 Replies
I have a listview control bound to an SqlDataSource. As part of the formatting I want to add a title to the data returned from my database. For instance if the data base returns a phone number I want to add 'Tel.' first. However I do not want to diplay this
title if the datafield is empty. Here is what I have done so far.
<ItemTemplate>
<asp:Label ID="BusinessLabel" runat="server" Text='<%# "Tel. "+Eval("Business") %>' CssClass="TeleStyle" />
Or This:Tel.
<asp:Label ID="BusinessLabel" runat="server" Text='<%# Eval("Business") %>' CssClass="TeleStyle" />
</ItemTemplate>
Business is a phone number. If the data field contains a number I get: Tel. 1234 123456. If the field is empty I get Tel. If Business is null I want nothing dsplayed, how do I do this?
Before I begin, I would like to acknowledge that I might be using incorrect terms below due to my lack of experience.
I have a GridView bound to an ArrayList of Custom Objects. I have a button as part of each row, which when clicked, I delete the row from the Arraylist, and re DataBind() the GridView. While this deletes the Row, it causes the Page to be refreshed that takes the User back to the top of the Page.
E.g. If the User clicks on the button of a row at the bottom of the Page, after the deletion, the Page gets refreshed and the User is now taken to the top of the Page.
This is irritating especially in long lists i.e. GridView with many rows. (I don't want to use paging here.) Is there any way to avoid this, or mitigate this problem.
I am trying to use a cascading drop-down for data entry. However, I'm having problems because I need to set the value of the drop-downs when I load the screen. I use a stored procedure to retrieve the values from my database, and then set the drop downs in my code-behind. Then the web service kicks in and wipes them out. :( How can I set these values and utilize the cascading drop down control?
View 3 RepliesI am currently working on a project now, i have created a web form and successfully stored the data when the user fills in the textfield, dropdownlist and radiobutton and clicks on the submit button. Now, i need to show the lastest data entry in a detailview in a new page when the user clicks the submit button. Is this posible? How should i go about it? Or is there any other way for i did not use a gridview for users to enter their information.
View 5 RepliesI am developing an ASP.Net 2.0 project that a call center will use for their scripting and data collection. Each screen will present the call center associate with a question and depending on their answer, will move on to the next screen. My question is what is the best practice for housing that data until the end of the scripting has been completed (i.e. in a Dataset or datatable), where should the storage container be declared and what's the best way to control the back button so it doesn't lose the data and try to repost?
View 8 RepliesAfter I developed the system by usin vs2008 , my supervisor asked me to develop form in the interface so they can enter information about projects as(project code,project title, country,sector,year) to the database with out dealing with the database in the backend .. so how can i develop it because i am still new to the vs.
View 1 RepliesI have a simple web form with controls such as test boxes, radio buttons, etc. I also have an empty SQL database created from within Visual Studio Express 2010, in the same project. I want to be able to open the web form, enter text, for example, in a text box, and have it saved in the corresponding field in the database. Ditto with the choice I make from a Radio List box, etc. Is there a simple way of connecting a control on a form with a field in the SQL database? I've tried a number of ways but can't seem to do it, though I realise it must be simple. I also think the control need to be in data entry mode, if there is such a thing, rather than automatically looking for data within the database to display (there is none). I'm new to SQL server and ASP.NET in general, though I've been through a lot of the excellent video tutorials etc.
View 8 Repliesmy C# web application contain accessing of database on the basis of datas selected from a dropdown list.. and my pblm is i cant access the first entry from the dropdown, dropdown list contains different dates,when user select one date from dropdown it will redirect to another page.. the page shows details from database on the basis of this particular date.....my C# dropdown's selected index changed code is shown below:-
[Code]....
and HTML code corresponding to this is:-
[Code]....
i cant access the first data from dropdwn,even it cant redirect to target page.. other entries (the 2nd 3rd entrie etc) was accessible and it shows the details from database on the basis of that corresponding value(usually some date).
I have a web page with a Form a Button, a TextBox and a DataGridView in it. The DataGridView uses a SqlDataSource as its data source. SqlDataSource has one parameter which gets it's value from a
form parameter (TextBox1). When the page is opened for the first time I set the TextBox1 default value in code behind:
protected void Page_Load(object sender, EventArgs e)
i have upgraded the requirement entry screen with some new values. I can able to insert and update the values for new entry. But if i'm trying to update the old entries the datareader does not fetching the values from database. please provide me some tips regarding the datareader
View 2 RepliesI developed a web application in asp.net.I have a module for saving values to database after clicking the button event.Thats working successfully.After that when i clicked the browser's refresh button the values reinserted to the table each time.How can i avoid this .Which is the code for this solution?
View 1 RepliesHow to validate user entry to cell in GridView and replace the cell value on the other column?
Ex :
i have a gridview with 2 columns (A & B), on both columns i change it to TemplateField (TextBox).
Now on whatever row on column A, i want to validate the user entry when user leave the cell, how to achieve that ?
Based on user entry on column A, i will do some data lookup and get a value returned from the server, how to tell the gridview to replace the value on column B (on the same row) based on the value returned from the server.
I have a detailsview form which passes data to a sql database. What I'd like to do is present a message when the number of rows in the destination table exceeds a specified number (40) or redirect the user to another page.
View 1 RepliesI working on a ASP.net project, database is MS SQL
for a reason that cannot find why, when I insert an entry to the data base, the entry is duplicated.
The controll runs this:
Protected Sub grdCustomer_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles grdCustomer.SelectedIndexChanged
Dim Quote As New QuoteBLL
Dim Customer As New BeeSafeShutterSystemTableAdapters.CustomerTableAdapter
[Code]....
I have Gridview that is populated from a data table, there are two additional template columns which are not bound (one checkbox and one textbox). I intend for the users to fill data in the unbound textbox and check the checkbox as needed. (there really is a good reason why the data is constructed in this way)
here is the problem, when the user enteres data into the textbox and hits enter, the gridview appears to postback, which wipes out the checkbox and the data in the textbox.
I tried setting the enable view state of the grid to false, that was supposed to stop postback but no luck. I have the enable view state of the textbox and checkbox set to true and autopostback set to false. but still no luck
so I need to either stop the postback or intercept the enter key in the text box and cancel the action, but that is a bit beyond me at this point
I have a simple FormView (fvDespatchPart) which updates the status of an order and it's despatch date; the despatch date being retrieved from a textbox (txtRentalDespatchDate)
held within the FormView. The FormView's DefaultMode is set to Edit.
I have been trying to set the default entry for txtRentalDespatchDate to today's date in the code behind, using:
Dim dtNow As Date = Today()
Dim txtRentalDespatchDate As Webcontrols.Textbox = fvDespatchPart.FindControl("txtRentalDespatchDate") [code].....
I have had no trouble doing this in the past with FormViews whose default mode is set to Insert or Item, but in Edit mode it just does not seem to want to co-operate. I have read a few help posts, and have tried:
Putting that code in LoadComplete, PreRender, PreRenderComplete Page events, as well as the FormView's databound event. I've also tried nesting it within a ...
If fvDespatchPart.CurrentMode = FormViewMode.Edit Then
End If
... just to make sure if is in the right mode.
Nothing yet has resulted in anything but the same old error.
I am relatively new to ASP.NET and have searched the Internet to find guidance in preventing caching of web pages (in the latest versions of IE, Firefox, Chrome and Safari). Based on my search, I found a lot of conflicting/confusing info. As best as I can tell, it appears that I need to add the following 3 lines to the <head> section of my .aspx files:
[Code]....
if the aforementioned lines are correct and if all 3 lines are necessary? I have tried using different combinations of the 3 lines, but I get conflicting results (i.e., sometimes the page is cached and sometimes it's not).
I have this simple code:
<asp:Label ID="litInfo" runat="server" meta:resourceKey="litInfo" />
<br />
<asp:TextBox ID="txtEmail" runat="server" /><br />
[Code].....
I am expecting the RequiredFieldValidator control to prevent a postback when the textbox is filled in with an incorrect data and the button pressed. What happens is that the validator displays an error message but a postback is fired.
I'm just wondering what people use to stop user from click a submission button more than once thus creating many records. Does any one have any examples that take client-side validation into account. I have done much research on this but am yet to find a feasible solution.
View 1 RepliesI 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'm using an asp:ImageButton as a custom CheckBox. When the user clicks on it it shows a dotted rectangle briefly. My code-behind immediately switches the focus to the submit button, but how can I keep this rectangle from appearing while the user has the mouse button down?
View 2 RepliesI have an existing app that has a java based search utility - this search utility has a FILTERing mechanism. You can click a button to POSTBACK to the server and there, a new window is generated displaying "blah dee da".
So, click a button to filter the utility, click a button to postback and voila, you get your popup aspx.
Unfortunately, the old aspx loses STATE when on the round trip and refreshes itself too - i lose my filter.
How do I go about NOT losing my STATE ?
I understand that specifying the following in the FORM tag on the old ASPX: target="_blank"
takes the focus away from the old aspx and so, the STATE is not lost. However, when the popup generates, a brand new aspx is created along with the asps pop-up. So, I end up with 3 aspx forms!
We have a flash site which uses POST requests to commumicate with the database, via .NET pages. There is no login, it's an open system. Since we are communicating with POST data we are using Request.Form to get the data posted from the flash. My issue is that anyone who can view that post request, in firebug for example, can then set up a post request from another server and this is not good as some of the actions are sending emails etc. Is there any standard way of preventing a POST request from another server when using Flash > .NET combo?
View 2 RepliesI have one TextBox with RequiredFieldValidator control and LinkButton on my page.
May occur the following situation on this page:
I filled the texbox and clicked the linkbutton is make postback on the server - so all ok.When I not filled the textbox and clicked linkbutton it will show message "Please enter your first name." and no postback will happen but when I filled textbox and click linkbutton I got a PROBLEM : Message "Please enter your first name." goes away (correct), but it doesn't preventing posback.
