Format A Numeric String Using A Numeric Composite Format?
Aug 9, 2010
I've just encountered an interesting problem in a standard BoundField in a GridView. The field is for EmployeeCode, which is purely numeric, but stored in a character column in the database. The DataFormatString="{0:00000}" attribute on the BoundField doesn't work, as I assume that format is only for numeric values.
To work around this, I had to use a TemplateField, and bind the text value using the attribute Text='<%# PadNumericString(Eval("EmployeeCode").ToString(), 5) %>'. Is there no simpler way of doing this?
I'm bulding document-from-template engine. At certain points I need to match on Reg Exp groups and replace template text with content from a db.
I 'hardcoded' my RegExp initially, doing something like: Regex r = new Regex(@"{DocSectionToggle::(?<ColumnName>w+)::(?<ResponseValue>.+)}[[(?<SectionContent>.+)]]", RegexOptions.Multiline);
it does group capture, so the syntax isn't the prettiest.
Just to make things neater and because I want' to keep the patterns in web.config or elsewhere, I've 'evolved' algorithm to something like:
[code]...
But I'm getting an error: 'Input string was not in correct format'.
I am not sure of the answer, I have created a field in the Database and created a gridview.To show the .9393939393 a couple of decimal in the gridview. I used this format
.ToString("$#.################");
Through out the experiment, I found out that the decimal and the numeric are getting same format, is that right.
I'm concatenating a string in codebehind to use in a sql select statement.
in aspx
<asp:Label ID="LabelHidden" runat="server" Visible="False"></asp:Label> SelectCommand="SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)" <SelectParameters> <asp:ControlParameter ControlID="DropDownList_Employees" Name="ID" PropertyName="SelectedValue" Type="Int32" /> <asp:ControlParameter ControlID="LabelHidden" Name="ActivityName" Type="String" /> </SelectParameters> in codebehind foreach (ListItem li in ListBox_Activities.Items) { if (li.Selected) { queryBuilder += li + "', "; } queryBuilder = queryBuilder.Substring(0, queryBuilder.Length - 1); LabelHidden.Text = queryBuilder;
When i run the code it comes up blank. I did a query trace and it seems to be running as
exec sp_executesql N'SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)',N'@EmployeeID int,@ActivityName nvarchar(50)',@EmployeeID=4,@ActivityName=N'Production Technical Support'', Tools Development'','
with exta "'s
How can i format the queryBuilder string correctly in my code?
everyting working fine but with this below query only numeric value getting from excel and saving into sql database String value not getting from excel?
INSERT INTO dbo.ImportTest SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:ook1.xls;Extended Properties=Excel 8.0')...[Sheet1$]
The numbers could be different, but what I'm looking for are the X_X numeric patterns. However, I need to do a replace that will search for 2_3 and NOT return the 12_3 as a valid match.
The +/-'s are arthemtic symbols, and can be any valid value. They also ARENT required (in the example of the first) .. so, I might want to check a string that just has 12_3, and if I pass in 2_3, it would NOT return a match. Only if I passed in 12_3.
i am using one text box to enter phone number,bt here is some problem. if user enters other than Numeric ,the text box should show the error. how can i do that?
I would like to generate sequential IDs in the format ZZZ999 starting from AAA001 but this is not for batch insertion of data. I want to issue the ID to users that signup on the website with the next available ID. Mutiple users can signup and should be issued the next available unique Id. I was thinking of storing the last used Id (just one row that is always updated with last issued id) in a table that I can lookup and use to determine the next id and update it. But given that mutiple users can be signing up at the same time, what is the best way to ensure that each user is issued a unique id while maintaining the issue of sequential ID. Will record locking work? I don't think so, as the last issued id can still be read by mutiple users and that it self will generate the same Id which will not work.
I'm trying to create a web page which to be used on a touchscreen monitor and need to do data input for the webpage thru on screen numeric keyboard (on the web page it self). When user touch on the numeric keyboard, find the focus of the textBox. And show the number.
