If I want to validate that a text box contains an integer greater than or equal to zero. Do I need to use TWO asp:CompareValidator controls: one with a DataTypeCheck operator and one with a GreaterThanEqual operator?
Or is the datatype operator redundant? Can I just use a single validator with the GreaterThanEqual operator (and the type set to Integer)?
validation to check the date greater and equal to the current date .
View 1 RepliesI keep getting an error:Index (zero based) must be greater than or equal to zero and less than the size of the argument list.y code:
OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", cn);
OdbcDataReader reader = cmd.ExecuteReader();
while (reader.Read())
[code]...
I am using below code to validate interger and float in asp.net but if i not enter decimal than it give me error
<asp:TextBox ID="txtAjaxFloat" runat="server" />
<cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" TargetControlID="txtAjaxFloat" FilterType="Custom, numbers" ValidChars="." runat="server" />
i have this regex also but its giving validation error if i enters only one value after decimal. [URL]
i have textbox it should accept only integer or float values..........
View 1 RepliesI want to retrieve all the records where the datetime is greater than or equal to 30 days ago. What is the correct formatting for this line: WHERE Property.dateadded >= NOW -30 days .. Dateadded field is in datetime format.
SELECT TOP (1) Property.Name, Property.Price, Department.DepartmentTitle, Images.ImageId, Property.DateAdded
FROM Property LEFT OUTER JOIN
Department ON Property.DepartmentId = Department.DepartmentId LEFT OUTER JOIN
Images ON Property.PropertyId = Images.PropertyId
WHERE Property.dateadded >= NOW -30 days
I am bindibg data to a grid and in my asp page I have the following asp:HyperLinkField:
asp:HyperLinkField
DataNavigateUrlFields="serialno"
DataTextField="serialno"
HeaderText="serialno" DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}"
/>
This is working perfectly, but when I add a second parameter to the querystring it does not work anymore:
DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}&id={1}"This
I get the following error during DataBind to a grid: [System.FormatException] = {"Index (zero based) must be greater than or equal to zero and less than the size of the argument list."} What does this mean? Is {1} not a string or is it because of something else?
i have two text boxs for 'start date' and 'end date'. I am using the CalenderExtender to display the calender to pick the date. how can i make sure the end date is some day that is after the start date? need some way to validate the end date...i have the html code
[code]....
I've a Textbox
I can enter a Number which is greaterThan "0" or I can enter text which is only "NUMEROUS"
so
If I enter 0 (or) negetive Number (or) any text other than "NUMEROUS", i must display error msg Like
"Don't Enter 0/Negetive No./text other than "NUMEROUS"
A very easy one hopefully - what expression can I use to validate an integer to ensure it is greater or equal to zero, but less than 2,147,483,647 (i.e. the maximum value of an integer)?
For example 0 =< x < 2,147,483,648
I'm trying to validate an integer range with a CustomValidator. The range is set dynamically, so when either the min/max values on my usercontrol change, the client validation function is updated. However, I can't get the validation function to fire. I have this code:
<asp:CustomValidator ID="vldAnswerValid" runat="server" ControlToValidate="txtAnswer" Display="Dynamic" SetFocusOnError="true" ValidationGroup="answer" OnServerValidate="vldAnswerValid_ServerValidate" Enabled='<%# !IsReadOnly %>' />
Setting the function from the codebehind with: vldAnswerValid.ClientValidationFunction = " function(oSrc, args){ alert(1); args.IsValid = false; } ";
But there's no message displayed and no alert. Am I missing something?
How to validate ddmmyyyy dateformat in the textbox on the textchanged event with split method in asp.net 2.0 ....
View 1 RepliesWhat's the cleanest way, like 1 line of JavaScript code, to set one text box's text property to equal another?
e.g. the JavaScript way to accomplish this:
txtShipCity.Text = txtCity.Text;
I have an asp.net control textbox, clicking on which a jquery timepicker appears and user can select any time.But I want to validate the selected time so that it is one hour greater than the current time in the client side. I mean when textbox value will be changed it should be validated.
View 1 RepliesHere is the code:
Code:
Dim intusercount As Integer = 0
Using connection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Using command As New SqlCommand("SELECT [ID] FROM [Members] WHERE [Username]=@Username AND [Password]=@Password", connection)
command.Parameters.Add("@Username", Data.SqlDbType.VarChar).Value = TextBox1.Text
command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
connection.Open()
intusercount = command.ExecuteScalar
connection.Close()
If intusercount > 0 Then
MsgBox("Good")
Else
MsgBox("Bad")
End If
End Using
End Using
Error:
The data types text and varchar are incompatible in the equal to operator.
Source Error:
Quote:
Line 11: command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
Line 12: connection.Open()
Line 13: intusercount = command.ExecuteScalar
Line 14: connection.Close()
Line 15: If intusercount > 0 Then
Stack:
Code:
[SqlException (0x80131904): The data types text and varchar are incompatible in the equal to operator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
_Default.Button1_Click(Object sender, EventArgs e) in C:UsersUserDocumentsVisual Studio 2010WebSitesWebSite13Default.aspx.vb:13
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
Database:
So admitingly I am fairly new at .NET...I have been a PHP guy for rather long time...
Heres my code:
[code]....
Essentially what I am trying to do is query the SQL database by the username. This above code is a method within the user respository for fetching a user by their username. The variable "username" is passed in as a string.
When the method is called a recieve the following error:
The data types text and varchar are incompatible in the equal to operator.
This to me is rather confusing since the field in the database, user_username, is a text and the variable passed in, as said, is a string. They should be synonomous for all practical purposes.
Ideas? Thoughts? Fixes?
I get the following error: The data types text and varchar are incompatible in the equal to operator.here's my code (PageName is a string Parameter) :
SqlConnection sql = SQLconnection();
en();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select title, text, postdate, sticky from articles where pagename = @pagename;";
[code]...
how to display result in gridview according to textbox only if textbox2 date value is greater than textbox1 ?
i have two textboxes and gridview ... if i type in Textbox1 : 2-Jan-2011 and in textbox2 : 1-Jan-2011 then in label1 the eroor message display else ..if textbox2 value is greater then textbox1 value then gridview will display records according to textbox1 and textbox2 from database ...
how to do that?
how can I disable the single quote, greater than and less than character when typing it into textbox.
And also prevent the copy, paste that character into textbox.
I have textbox in my asp.net 3.5 VB.net webform
in my textbox1 the text is : 30-Dec-2010, 06:00:00 PM
i want when the date in textbox is greater than textbox1 then the Label text would be "No REfund !"
I am having difficulty with getting the values from two textboxes to passed the values to one function and determine that one textbox cannot be greater than the other textbox, then i can issue alert message.
For opener, i do not want onclick issue.
[code]....
I have been trying to figure out how to use <asp:requiredfieldvalidator> with ValidationExpression but am having a difficult time understanding the syntax of ValidationExpression. I'd like to make sure one textbox's number (1-12) is equal to or higher than the other textbox's (1-12) number. How is this accomplished and what's the syntax of ValidationExpression (hopefully I'm stating the question correctly).
View 2 RepliesI want to convert Label text into Integer datatype. I tried by giving Convert.Int32(Label1.Text) and int.Parse(Label1.Text) but I couldn't do Type casting . I am getting error at runtime. I searched in web I couldn't get the solution.
View 1 RepliesI have a @message parameter in SP, user sends an Integer value in that message. For Ex: @message = 'This is, a Test message 500000 and the message ends.'Now i want to get only that 500000 value from this @message param. There is no delimiters for identifying the integer value and in that param contains only one integer value
create procedure st_test (@message varchar (4000), @result int output)
as
begin
//LOGIC for get the interger value
end
I have a textbox that I want the user to enter an integer in.1) I have created a required field validator, to ensure it is not left blank.2) A compare validator, to ensure the value entered is an integer using datatypecheck.3) A range validator to limit the range of the entered integer.If a letter is entered, instead of an integer, errors from both 2) and 3) are displayed.Is there a way to only show the error from 2) if a letter is entered and 3) if the integer is out of range - rather than both?
View 1 Replies