Autocomplete dropping leading zeros and trailing zeros after a hyphen
Autocomplete Web Service Code 1    Imports System.Web2    Imports System.Web.Services3    Imports System.Web.Services.Protocols4    Imports System.Data.SqlClient5    Imports System.Data6    7    ' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.8    <System.Web.Script.Services.ScriptService()> _9    <WebService(Namespace:="http://tempuri.org/")> _10   <WebServiceBindi...

GridView & FormView dropping leading zeros from numbers set as strings
I'm storing in a SQL database a certain field (an employee number) as a varchar data type. Throughout the app (datasource, update/insert stored procedures, etc.) I'm working with it as a string. I've even ensured that it's being used as a string "behind the scenes" by watching it in SQL Profiler. Problem is, the GridView & FormView that display it always drop any leading zeros. Wierder yet, when I put the GridView in Edit mode & add a zero, it saves to the database with the zero, but the leading zero doesn't display in the GridView! Anyone kn...

Displaying Search String Results in GridView using String Array
I created a .aspx page with a search function to look for records in the database based on the keyword the user inputs into the textbox and then display the results in a gridview when the user clicks the submit button.  As of right now I have setup an SQLDataSource on the page that runs the following query:SELECT * FROM [recipe] WHERE ([keyword] LIKE '%' + @keyword + '%') I also setup an event handler for the Button1_Click event to set the SQLDataSource I created as the DataSource for the GridView and then did a Databind();protected void Button1_Click(object send...

Leading zero in a string
Hi All, I have a variable I'm reading off of the command line: my $option = shift; That variable should hold a number between 1 and 31 (yes, a day of the month) I am checking to make sure that the number does indeed lie in that range. However, I need to pass that variable to another system command which expects any "day" value less than 10 to have a leading zero, so 7th day of the month should say '07'. How can I check for that leading zero? If it's missing, I know I could easily: $option = "0".$option; But I can't seem to figur...

result as array or string
tablea ID SEQ_NO CODE 1 1 343 1 2 243 1 3 3243 1 4 NULL OR SPACE 1 5 343 1 6 NULL OR SPACE what i currently have is select id, @min_seq_no = min(seq_no), @max_seq_no = max(seq_no) from tablea where CODE > '' group by id select @iCount = @min_seq_no WHILE (@iCount <= @max_seq_no) BEGIN - do some insert based on seq_no SELECT @iCount = @iCount + 1 END ----- unfortunately this doesn't solve the purpose since the seq_no returned are 1 2 3 5 and i...

Zero-width split() match creates empty trailing strings but not empty leading strings
The perlfunc documentation spells this out clearly, and it matches what I see: $ perl -e 'for (split(//, "fob", -1)) { print "$_\n"; }' | sed -e 's/^$/<blank>/' f o b <blank> The question on my mind is why. In particular, is it a decision worth replicating to language's libraries? Thanks for any pointers. I tried to find the source for split, and I think I may have found it in pp_split in pp.c. But there's not really any reason to expect the source code to include the justification, and I couldn't find one. http:/...

Excel has dropped leading zeros
Hello all, I have a problem with code that exports data from SQL Server to Excel and removes leading zeros from the data in the spreadsheet. My code is below.  Is there a formatting option or something that I need to add to maintain these leading zeros?  I know that you need to treat the data as text but how is that done programmatically? DataSet objDs = new DataSet();             string source = UtilityClass.decode(ConfigurationManager.AppSettings["DSN"]);          ...

Array string in vb.net
Hi everyone, I had some problem with array string in vb.net. I cannot assign value to string. Could anyone tell me what is the problem with code. Dim str() as string For i = 0 to count str(i) = "Some string" Next I had an error message saying "Object reference not set to an instance of an object" Thanks HenryToronto Trade show displays | Toronto Printing Solutions | Toronto Printing [VB.NET] Dim str As String() = New String(Count) Dim str() As String = New String(Count) [C#] string []str = new string[Count + 1];Picky...

How to pad string with leading zeroes
*** please ignore the post entitled 'Brian'. Its a duplicate of *** this post without a matching title Hi, I have a requirement to convert a 3-digit integer to a 3 character string padded with leading zeroes as I SELECT it from the database. Examples: ========= 1 converts to '001' 21 converts to '021' 321 converts to '321' I have played with several string functions to no avail. Any help/suggestions would be appreciated. Brian Two possible ways to get you going: select substring(convert(char(4),column + 1000),2,3) OR ...

Datareader results to string array
Good Day Everyone,  How can i build a "dynamic " string array from a datareader that it's returned from a query, i mean dynamic because the values returned from the database can change (more items or less items) Here the code i have so far:   Function GetLocationsForUser(ByVal UserAlias As String) As String() Dim ProcedureStrings As New ProcedureStrings() strSQL = ProcedureStrings.strSQL_GetLocationsForUser() GetConnection() Dim myCommand As New OleDbCommand(strSQL, oConn) myCommand.Parameters.AddWithValue(&quo...

Split a string and put results into Array...
Ok I really have forgotten how to do this. I have a string: "ABCD" and I have 4 images with the names "imgA, imgB, imgC, imgD" So sometimes the string will read "AD" or "BCD" or "A", etc...  what do i need to do get 'string [] split' to contain '{'A', 'B', 'C'}' if my string is 'ABC'? Here is what I have so far: string [] split = strTemp.Split(new Char[]{}); I would use myString.ToCharArray() to convert them in to a char[] and then work on them like that. Try this: string s...

returning the results from a querry to a String array
Hi all I am having some issues that I think I am pretty close on but I am not too sure. I have a table with only 2 records in it.  I dataset with a tableadapter that has a method with nothing more than a simple SQL statment  select username from admin  in my ASP I have a button that I create an object to the tableadapter and run the method.pRequestTableAdapters.AdminTableAdapter admin = new pRequestTableAdapters.AdminTableAdapter(); String[] admins = admin.FillByAdminName();    I would just like to fill ethe admins array with the values found in ...

Convert string to string array.
Hi, We have a string array argument in datawindow object for 'IN' sql statement. Our user enter a string in a single line edit. How to convert the string to a string array for the argument of datawindow? ex. user input : 'A', 'B', 'C' => str_arr[]={'A', 'B', 'C'} dw_1.retrieve(str_arr) Thanks in advance. Take a look at the n_cst_string object in the pfc. It has a method called of_ParseToArray that does exactly what you're looking for. It's a pretty simple task to 'port' the code ...

Dropping leading zeros in a GridView nvarchar field
I have a GridView that displays a column where the data is an "nvarchar" type.  These values are numbers, but look like this: "001", "002", "009", "010", "011". I would like to trim off the leading zeroes in the displayed GridView.  I have experimented with using a DataFormatString, but that is not working, as the values are not numbers - they are strings, essentially.  I know I could modify my database to store integers (as all of these values are in fact, numbers), but that brings up another problem.  I have &...