Web Forms :: Text Box Should Accept Only Numbers?
Oct 19, 2010i want a text box in asp that should take only numbers if we enter alphabets or special characters that should give an error how can i achive this
View 8 Replies
Similar Messages:
Using Regular Expression Text Box Should Accept 1 Or 2 Or 3 Or 4 Or 5 Max Digits Numbers Only Restrict Decimal Part?
Jan 12, 2011I need to validate the text box at server side by using regular exp which should accept 1 or 2 or 3 or 4 or 5 digits numbers .Need to restrict decimal part.
Ex: 1 or 23 or 455 or 5643 or 45667 --Should accept.
1.3, .2, 33.3 , 444.55 ,5555.99 -- should not accept.
Web Forms :: How To Add Validation So It Doesn't Accept Empty Strings Or Numbers
Jan 6, 2010i am using a search box for my application which returns a dataset. however when i click on the search button it returns an empty table result. how could i add validation so it doesnt accept empty strings or numbers.
View 9 RepliesPossible To Get The CompareValidator To Accept Numbers With Commas?
Aug 31, 2010I had been doing a type check for Double for an input field on a web page but now I need to allow commas. Can this be done using a CompareValidator or do I need to use a regex validator?
View 1 RepliesRegular Expression That Accept Indian Mobile Numbers?
Jan 4, 2011i need a regular expression that should accept indian mobile numbers. for example...
9788812345
9876512345
7891234567
8122212345
Visual Studio -to Accept Just Numbers On A TextBox When Typing?
Jun 21, 2010I have a TextBox & I want to accept just numbers in this TextBox when typing?
View 3 RepliesWeb Forms :: How To Text Box Accept Only Numerics In .net
Jul 15, 2010i have text box, i want to enter age in to that,if i enter "Text" into that that text should not enter into that.only numerics only enter. Alphabetic key must be disable for that text box.
View 9 RepliesWeb Forms :: How To Validate A Text Box Such That It Should Accept Only Numeric Values
Jan 23, 2010Me with C# asp.net, how can I validate a text box such that it should accept only numeric values and -
View 6 RepliesLocalization :: Textbox Needs To Accept Text From Other Languages?
Nov 8, 2010how non English language input works with asp.net textboxes.
1. Can a regular asp.net textarea or a textbox accept text from languages other than English?
2. If yes, then how does the user enter non English language text
3. Is there a way to detect what language the user has entered text and make UI changes accordingly. (Ex: Make a button visible if non English text is entered)
4. Can non English text be stored in a varchar column in a SQL Server database? If not, how do I store this text?
Generated Excel Spreadsheet: Numbers Received As Text?
Jan 5, 2011I am generating, using a ASP routine, Visual Basic, a HTML table in a file to be read by MS Excel.
After Excel reads the file, some of the numbers (in some cells) are shown as "text", not numbers: they cannot be operated upon, like decimal numbers. (added, subtracted...)
If I click in a "number" stored as "text" cell, I can "edit" the cell and remove an invisible "apostrofe" to the left of the number; after that, the "text" becomes "number" again.
Seems like Excel is inserting a non-visible character before the number, so that it is stored as "text"
It happens to some lines and not to others...
C# - Numbers Are Converted As Text When Export Dataset To Excel
Jul 8, 2010Iam exporting dataset to excel , the numbers on the sheet shown as text when export it to excel. Here is the code:
public class Excel
{
const int rowLimit = 65000;
private static string getWorkbookTemplate()
{
StringBuilder sb = new StringBuilder(818);
sb.AppendFormat(@"<?xml version=""1.0""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<?mso-application progid=""Excel.Sheet""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:o=""urn:schemas-microsoft-com:office:office""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:x=""urn:schemas-microsoft-com:office:excel""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:html=""[URL]
sb.AppendFormat(@" <Styles>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""Default"" ss:Name=""Normal"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:Vertical=""Bottom""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Borders/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Verdana"" x:Family=""Swiss"" ss:Size=""12"" ss:Color=""#0000A0""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Interior/>{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Protection/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s62"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine);
sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s63"">{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat ss:Format=""Short Date""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" </Styles>{0}", Environment.NewLine);
sb.Append(@"{0}
</Workbook>");
return sb.ToString();
}
private static string replaceXmlChar(string input)
{
input = input.Replace("&", "&");
input = input.Replace("<", "<");
input = input.Replace(">", ">");
input = input.Replace(""", """);
input = input.Replace("'", "'");
return input;
}
private static string getCell(Type type, object cellData)
{
Object data = (cellData is DBNull) ? "" : cellData;
if (type.Name.Contains("Int") || type.Name.Contains("Double") || type.Name.Contains("Decimal")) return string.Format("<Cell><Data ss:Type="Number">{0}</Data></Cell>", data);
if (type.Name.Contains("Date") && data.ToString() != string.Empty)
{
return string.Format("<Cell ss:StyleID="s63"><Data ss:Type="DateTime">{0}</Data></Cell>", Convert.ToDateTime(data).ToString("yyyy-MM-dd"));
}
return string.Format("<Cell><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(data.ToString()));
}
private static string getWorksheets(DataSet source)
{
StringWriter sw = new StringWriter();
if (source == null || source.Tables.Count == 0)
{
sw.Write("<Worksheet ss:Name="Sheet1">
<Table>
<Row><Cell><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
return sw.ToString();
}
foreach (DataTable dt in source.Tables)
{
if (dt.Rows.Count == 0)
sw.Write("<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) + "">
<Table>
<Row><Cell ss:StyleID="s62"><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
else
{
//write each row data
int sheetCount = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((i % rowLimit) == 0)
{
//add close tags for previous sheet of the same data table
if ((i / rowLimit) > sheetCount)
{
sw.Write("
</Table>
</Worksheet>");
sheetCount = (i / rowLimit);
}
sw.Write("
<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) +
(((i / rowLimit) == 0) ? "" : Convert.ToString(i / rowLimit)) + "">
<Table>");
//write column name row
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(string.Format("<Cell ss:StyleID="s62"><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(dc.ColumnName)));
sw.Write("</Row>");
}
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(getCell(dc.DataType, dt.Rows[i][dc.ColumnName]));
sw.Write("</Row>");
}
sw.Write("
</Table>
</Worksheet>");
}
}
return sw.ToString();
}
public static string GetExcelXml(DataTable dtInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
string worksheets = getWorksheets(ds);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static string GetExcelXml(DataSet dsInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
string worksheets = getWorksheets(dsInput);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static void ToExcel(DataSet dsInput, string filename, HttpResponse response)
{
string excelXml = GetExcelXml(dsInput, filename);
response.Clear();
response.AppendHeader("Content-Type", "application/vnd.ms-excel");
response.AppendHeader("Content-disposition", "attachment; filename=" + filename);
response.Write(excelXml);
response.Flush();
response.End();
}
public static void ToExcel(DataTable dtInput, string filename, HttpResponse response)
{
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
ToExcel(ds, filename, response);
}
}
Web Forms :: Treeview / SiteMapDataSource - Get Tree Layout That Matches The Numbers Of Options But No Text On Any Of Options To Click
Jan 18, 2011I have a Default.aspx program that contains a Treeview with a SiteMapDataSource. I also have a web.sitemap loaded up with urls. When I run the deafult app I get the tree layout that matches the numbers of options but no text on any of the options to click.
View 1 RepliesControls :: Disable AutoFilter Option And Formatting Numbers To Text When Export Excel Using OpenXml?
Dec 23, 2015I was using this UR [URL] for exporting the data to excel. Can I do the following two things while exporting:
1) I want to remove the autofilter options, which are displaying now when you open the excel workbook soon after exporting finishes.
2) Some of the columns which are numerics, are formatted to text by default, and it is displaying a small green rectangular icon at the left top corner of each cell which is very disturbing while viewing the sheet.
Is it possible to fix both the above options.
How To Make A UI With A Panel Of Numbers / Highlighted Numbers
Feb 15, 2011I would like to to make a UI with a panel of numbers, and when hovered above one of them ten the number becomes larger. something like that:
[URL]
I want that when I press a numbers it shows it's value in some other textbox. In which .NET technology is it possible to do it? Windows Forms? WPF? other?
Web Forms :: Sitemap Does Not Accept Path?
Feb 14, 2011site map doesnot accept pat with ?id=2,etc.
eg:-
www.aabc.com/search.aspx?id=3 is not accepted nad gives error.
whereas, www.aabc.com/search.aspx works fine.what should i do.
Web Forms :: Accept Textbox Value Even If It's Null?
Jun 14, 2010I have a javascript to validate and avoid null values for my form but there are some textboxes that I need to be 'optional'. I tried erasing the validation for province address and province contact in javascript to make it optional, but the problem is whenever I add the values in the database, an error message appears "Input string was not in a correct format". It's in C# This is my present code wherein the provincial address and provincial contact must only be optional:
protected void submitButton_Click(object sender, EventArgs e)
Web Forms :: Only Three Email Domain Accept
Sep 20, 2015In my registration form, there is field to enter emailid of member, i want to restrinct user, so that he would able to enter to only three domain name like gmail, hotmail, yahoo like this emailids.
View 1 RepliesWeb Forms :: How To Accept Input In Textbox Control
Nov 30, 2010When I try to input < or > in a textbox control , I get a error, how can I do ?
View 6 RepliesWeb Forms :: How To Only Accept Images With Size 100 X 150 In FileUpload
Mar 12, 2010I am using a File Upload control to upload .BMP Images.
What I need to do is to Only accept .BMP Images that has the Exact size: Width: 100 and Height: 150.
[Code]....
[Code]....
Web Forms :: Validation - Accept Only Integers And Decimals?
Mar 25, 2010I have A textbox inside formview, ive add litered textbox from ajax and allow only numbers and "."Works fine. THe only problem they can enter multiple dots. I want textbox to accept only following formats: 100, 1234.56 - i.e integers and decimals.
View 2 RepliesWeb Forms :: Validation To Accept Only Alphabetic Characters
Jun 1, 2012there is a text box in my form to input name.. I apply regular expression to accept only characters ... but it is not accepting space.
i apply this regular expression
<asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server"
ControlToValidate="txtName" ErrorMessage="Only alphabets are allowed"
ForeColor="Red" ValidationExpression="[a-zA-Z]+" > </asp:RegularExpressionValidator>
Web Forms :: Implement Form To Accept Comments
Nov 28, 2013I want to accept user comments and store it in database.
View 1 RepliesWeb Forms :: Use MaskedEditExtender For Textbox To Accept Time?
Mar 26, 2016I want to set my textbox textmode="time"
View 1 RepliesWeb Forms :: ValidationExpression To Just Accept A-Z, 0-9 / Hyphens / Underscores / Spaces?
May 11, 2010Using a RegularExpressionValidator, I want my textbox to accept a max of 20 chars, and only English characters A-Z (upper and lowercase), 0-9, hyphens (-), underscores (_), and spaces. That's it.
Now that I think about it, since this text will be used by a proprietary software to create a file of the same name, and will also be included in the querystring when the page is redirected (so that I can find the file so the user can download it), I'm not sure if I should keep it safe and not accept spaces.
Web Forms :: Not To Accept Coma - Single And Double Quote
Mar 26, 2010I need a regex to not accept single quote, dobule quote and coma. I want to add this to regularExpressionValidator.
View 3 Replies