I have a textbox that the user is suppose to enter a valid user name , the valid user names are stored in database. for example the valid user names might be U100, U101, U102 ,U103,U104,U105,U106,U107. so if the user types anything other than that he should get a error message and I dont want to implement a drop down list for that , how to do this in asp or should i explore javascript for this.
View 4 RepliesI am wanting to have a numbers/currency only textbox control. So basically it should accept this kind of input
$123
523,100
$12.50
85.59
and convert this to
123
523100
12.50
85.59
and should not accept this input
F12
309$2342
,102
I have looked at validator controls but I would like to this conversion/checking completely from the client side. What would be the best way of doing this? I also would like a clientside error(message box or something) popped up if they try to enter invalid data and prevent them from leaving the bad data in the textbox. and then when they get out of focus of the textbox it automatically converts the data into a flat number from the client side.
I have 2 text boxes one for first name and one for last name. If the user enters a first name then the last name cannot be empty. Is there a validation control i can use and how can i display the message in the validation summary.
View 5 RepliesI am trying to validate a textbox in C# to see if it is null before submitting but it still allows me to submit and does not give the warning message. here is my code
[Code]....
I have created the user control and it has got one table with few rows in it. One row has got a text box with custom validaor and other row will have check boxes dynamically added through server side.
On the main page, i am loading that user control about 10-15 times depending upon the values from the database.
Is there any way of setting the properties of user control validator on the main page? Text box will only be validated if any check box is checked in the user control.
I am also not able to find the usercontrols through the main page.
I have the following piece of code which I was hoping would result in an error message being displayed if an incorrect date format was input rather than an website error page saying "The string was not recognized as a valid DateTime."
<asp:TemplateField HeaderText="DateCompleted" SortExpression="DateCompleted"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DateCompleted") %>'> </asp:TextBox> <asp:CompareValidator ID="CompareValidator" ValidationGroup="GridView1" ControlToValidate="TextBox2" errormessage="Invalid Date" Display="Dynamic" Operator="DataTypeCheck" Type="Date" runat="Server" /> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("DateCompleted") %>'></asp:Label> </ItemTemplate> </asp:TemplateField>
I have two ddl'a which i insert into a database inform of a grid. Now i will like to make sure the two data i am inserting is not already on the databse and if it exist i want a message to show. I dont have anything right now. I just need ideas on how to go about it.
View 9 RepliesHow can i make this work like i have 5 fields in my database table . 2) i created a model for validation with datannotation and created the compare password field as well with comparepassword attribute. (now my model has 6 fields including one external field compare password and 5 database fields)3) i created a view with that model.(User)4) now i created a controller as well but the problem arise here that when calling that actionmethod the compiler complains about the external field and tells it cannot find any extension method . how can i create the extension method or solve this error?
[Code]....
I am using DropDownlist to validate culture as follows. <asp:DDL ID="ddlculture" runat ="server" /> for this ddlculture data is comming from sql database like this
dim dt as datatable
dim dr as datarow
dr(0) = ""
dr(1) ="--select culture"
dt.Rows.InsertAt(dr, 0)
ddlculture.DataTextField = "CultureName"
ddlculture.DataValueField = "Culture"
ddlculture.DataSource = dt
ddlculture.DataBind()
everything is ok... but i am trying to validate it using Required Field Validator or compare validator or javascript. it is not validating. what is the problem
I am using a bound gridview in ASP.NET 2.0. The gridview has the ability to edit/update and insert rows. One of the columns holds a number which represents a percentage. What I cannot figure out is how to ensure that all the rows in the gridview total 100% before being able to send the updates or newly inserted data to the database.
For example say there are 5 rows in the gridview, each row has 20% stored in the column so it adds up to 100% which is fine, the data is updated/inserted in the database. But say each row only had 15% totalling 75%, the user should not be able to send the updated/inserted data to the database until either they add a new row with a percentage of 25 or they edit the other rows for a cumulative total of 100%
I am not familiar with javascript or AJAX
am importing a text file database in my sql server database in asp.net c#.but i cannot fetch the column name from .txt file which contains a numeric data now what to do?
View 1 Repliesi need to make a code that changes the text to a text from my database if i click on a href.and i don't know how can you guys help me?it is asp classic btw.
View 5 RepliesIm very new to this...(3 days new) any help would be great! I'm having trouble figuring out how to auto populate data from my sql database.issue, In the website i have a "product code" text box.. once the user inputs a "product code" I'd like to have it auto-fill 3 other (ie, description, location and type) text boxes based on data in the database for that "product code"
View 4 Repliescan anyone give me a step step guide of how add data to a data base( access 2003 with oledb connection) use vb 2005 asp.net aspx pages via text boxes with a button to submit
View 2 RepliesI'm following along with Nerddinner making a few changes, and can't figure out why my Create form is not validating. I'm using Linq to SQL and trying to use Modelbinding to map my form data automatically. Using the code below, I do not receive any validation errors on the page, but can't make it past my try{} block. When unhandled, the error I receive tells me I'm unable to insert a Null value for "basetype". This is correct based on Database constraints, but why am I receiving exceptions, and not the nice red error messages and validation?
Controller:
[Code]....
[Code]....
I'm using a DataGrid with edit functionalities in my project. It's handy, compared to having to edit its source data manually, but sadly, that means that I'll have to deal with validating user input a bit more.
And my problem is basically just that. When I set my DataGrid to EDIT mode, modify the values and then set it to UPDATE, what is the best way to check if a value that I've entered is, in fact, compatible with the corresponding column's data type?
i.e. (simple example)
// assuming
DataTable dt = new DataTable();
dt.Columns.Add("aa",typeof(System.Int32));
DataGrid dg = new DataGrid();
[Code]....
I'm now working on a application which needs some pdf files (size 200kb -1Mb) to be stored into Mysql database.
View 2 RepliesI have a textbox on one page and a label on another and I want the user to beable to write into the textbox with several paragraphs then save this to the database which is working and when i reload the page the text in the textbox is shown in paragraphs which is want i want but on my page with a label when i pull the text out from the database it puts it all into 1 big paragraph instead of slpitting it up like it was written how can i get it to do
View 9 RepliesI am fairly new to asp.net, I am attempting to create a simple form using textbox controls with a submit button which will save the information entered into the fields in a database table I have created, the database table i want to store the information into is named 'Incident'.
The source code is below.
[Code]....
I am creating a winform app in C# to store formatted text from a rich text box to MySQL database, which can be retrieved back to the rich text box. The database field is a VARCHAR and my code is something similar to below. But I'm getting "file not in correct format" error. Can anyone tell what could be the problem? Is the VARCHAR field okay to store it or should I change it to a BLOB?
string rtfText = this.richTextBox1.Rtf;
// save rtfText to database field as varchar
// ...
// reload rtfText from database as string
this.richTextBox1.Rtf = rtfText;
How to read a text file and saved in data base
View 1 RepliesUser enters values into text boxes (personal information etc.) and then presses a save changes button. The values in these text boxes get stored in an SQL database. The problem I have is that when updating the database using the values from the text boxes, the page refreshes and the values in the text boxes are lost (or rather they return to the values that are already in the database as the data from the database is loaded into the text boxes on Page_Load). When I update the database using valuse stored in variables it all works fine. What is the best way to update with the values from the text boxes?
View 2 RepliesI am building a web site similar to Craigslist. I would like to know how to store the html formatted text (bold / italics / font size etc) in a sql 2008 database?In order words, the user would enter their text, format it with font size, bold etc and save the information. Whats the most efficient way to store that in a database?
View 6 RepliesI'm have started a project in MVC to get to know my way. And now i want to use it with data from a excisting database.
In the records of my exsisting database i have text and html elements like: Tekst<p><b>Title</b>Tekst</p>
How do i make mvc show this data in a view? Now it gives me the data like:
[code]....
aspx: <act:Editor ID="editor1" runat="server" Width="400px" Height="350" />
this is the editor. the text here goes to database field.
aspx.vb: editor3.Content &= str
But only 1560 characters go into db .how is that?