Lining Up Different Strings (Like Columns)
Jan 19, 2010
I have a combobox that I want to fill with data from the database, but I want to show more then one column. I now have:
Dim groups = tblGroupTableAdapter.GetDataByCustomerID(CustomerID)
For Each group As OutlookSignDataSet.tblGroupRow In groups
If group.IsNull("name").Equals(False) Then cmbGroup.Items.Add(group.Name)
Next
But what I want is:
Group.Name Group.Description Group.Telephone
All nicely lined up, this of course is difficult because the values can differ in length.
View 1 Replies
ADVERTISEMENT
Mar 22, 2010
So far, I'm doing this programmatically using VB.net/ASP.net:
<table cellspacing="0" cellpadding="4" border="0" style="border-
width:0px;width:100%;border-collapse:collapse;font-size:12px;">
<tr>[code]....
This should give me four DIVS inside a container DIV. Here's what it's coming out as: The correct blocks above the non-inline blocks are from a table with the same exact widths as the ones I'm using on the Divs. There isn't any CSS adding pixels to them, I don't think.
View 3 Replies
Oct 16, 2009
Say I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
View 2 Replies
Aug 13, 2009
I am working on a UDP Client/Server, and currently i have them sending back and forth strings, which i convert to bytes, and then open the bytes to read. I want to now send an Object instead of those strings, which includes multiple unsigned integers and strings.
View 39 Replies
Oct 26, 2011
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
View 6 Replies
Nov 30, 2010
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
View 2 Replies
Aug 5, 2010
I have a list of strings. For each string in that list, I want to prepend another string. I wrote a method to do it, but I was wondering if there was something already in .NET I could use to do this. It seems like something that could be built in, but I was not able to find anything.
Here is the method I wrote:
Private Function PrependToAllInList(ByRef inputList As List(Of String), ByRef prependString As String) As List(Of String)
Dim returnList As List(Of String) = New List(Of String)
For Each inputString As String In inputList
returnList.Add(String.Format("{0}{1}", prependString, inputString))
[code].....
It works, but I would rather use built in functions whenever possible.
View 5 Replies
Oct 16, 2009
I'm migrating from VB6 to VB.NET, in hence my questions below:
I have to write a function that returns array of strings.
How can I initiate it to empty array? I need it since I have to check if it's empty array after it returns from this function.
Is list of arrays better for this purpose? If I use a list - Is it empty when it firstly defined? How can I check it it's empty?
View 3 Replies
Jun 29, 2011
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
View 1 Replies
Oct 15, 2009
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
View 1 Replies
May 23, 2011
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
View 14 Replies
Feb 21, 2011
I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
View 2 Replies
Feb 28, 2010
Averaging columns in a table - ignoring certain columns
View 2 Replies
Feb 18, 2010
What should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables
View 5 Replies
Aug 15, 2011
I have been looking for examples to find the string between two strings. This top one works fine;
Public Sub ReadData(ByRef keywordStart As String, ByRef keywordEnd As String, ByVal filename As String)
Using reader = New StreamReader(filename)
[Code].....
Now the first one is fine - Ext_Volume is result of the string between the strings <Volume> and </Volume>. <Volume> and </Volume> are unique so this is straight forward.
However the second one - "^FDExp:" is unique, but "^FS" is not unique. There are occurances of "^FS" before and after "^FDExp:".
How do I get the string to search AFTER the occurrence, not before etc?
View 5 Replies
Jun 24, 2011
Dim str As String
Dim str2 As Array
str = "blabla duhduh"
str2 = str.Split(" ")
View 2 Replies
Apr 6, 2012
Say the string is something like
bla bla bla bla (cat) bladfdskdfd dsgdsdksf (dog)
dfdshfdskdskfsdfkhsdf sdkfhdsfkdf (kathy) fdsfhdskfhdsfkd (doggy)
I want a generic.list (of string) containing
cat
dog
kathy
doggy
How to do that with regular expression in vb.net
Later I want to do something more complicated like getting all strings between "url":" and ", from this strings
[Code].....
View 1 Replies
Jan 8, 2012
Is there an easy way to find a certain string within a string and then return the strings that you find as an array?I have written this:
Public Function FindStrings(ByVal strSourceString As String, ByVal strStartString As String, ByVal strEndString As String) As String()
Dim StringStartposition As Integer
Dim StringEndPosition As Integer
Dim Currentposition As Integer = 1
[Code]...
View 16 Replies
Jan 16, 2011
I have this string called time. It's value is in this format: HH:MM:SS The numbers change, but the format stays the same. I want to separtate the code into 3 strings Hour, Minutes, Seconds.
View 2 Replies
May 14, 2009
I have a DataGridView that has some columns with dates. It binds to an in-memory Datatable which gets loaded from an string array of data passed back from the backend Some of the rows returned have nulls for the date columns. Solution 1: If I define the Date column in the DataTable as "string" I can easily convert those nulls to empty strings and display it in the grid as empty strings (desired results). However, if the user clicks on the date column header to sort by date, it doesn't order the rows as you want. You get a purely string sort order. Not acceptable
[Code]...
View 2 Replies
Oct 6, 2011
I have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?
Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable
[code]....
View 1 Replies
Aug 18, 2011
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 Replies
May 17, 2010
Here's the weird problem I am trying to solve but cannot get my mind around it. In a text box 1, the user enters 2 or more strings separated by comma. then in text box 2, the user enter 1 or more strings separated by comma. The output then puts the strings from text box 2 between the strings in text box 1
Example:
TextBox1 = visual basic, java, perl
TextBox2 = is better, compared to
[Code]...
View 1 Replies
Aug 14, 2009
I have a text box where i have time stored in it and i have another text box with the time as well. these text box have stored time as "string" . now i want to add times but gets an error message(ex on monday the emp works 2 hrs and tuesday 5 hrs and i want to display 7 hrs in total hrs worked for the week)[code]
View 5 Replies
Jul 14, 2011
I used to add 2 strings variables and it works but when I tried using VB2008 it didn't work. [code]
View 9 Replies
May 2, 2010
I need to add numbers in strings My program concatenate the numbers instead
Dim first As String
Dim complete1 As String
Dim complete As String
[Code]....
View 2 Replies
Aug 19, 2009
I have a function where I have to add two values (declared as string) on two different pages, So Iam bringing one value from one page to the second page where I have second value and adding both of them to display the result in a label. But I am not able to do that. eg: 1st value is 4.20 ( both values are time in seconds) and 2nd value is 0.34 then I want the result as 4.54( instead I am gettign the result as 4.24.0.34 , So can anyone tell me how to add these two ..My code is attached.
Dim L1 As String
L1 = main.TimeElapse(Value1).ToString
'Label1.Text value is the below line
Status.ShowSuccess("Ready: Result is " + _Myfunction.GetTimeInSeconds.ToString("N1") + TimeElapse(value1).GetTimeInSeconds.ToString("N2") + " seconds")
View 4 Replies
Aug 21, 2010
I am writing a program that uses an array with three columns and a varying amount of rows. I need to load info on a list of files in an archive(specifically: file name, size, path), and I am wondering what the most convenient way to store strings(to be loaded into the array) is.
For example: I tried creating a new .resx file in my project, and writing a function to be executed on form1_load that reads the strings from the .resx file and places them in the array in their correct column, but unfortunately had no success.
I really have no idea how resx files work, I can put strings in them using the resource editor, but I don't know how to retrieve them using resourcemanager.
I would just put the info straight into an array, but it's much easier to update a .resx file when the archive changes than it is to update the code.
Could someone please tell me how to use .resx files in vb.net? Or an easier way of accomplishing my goal?
View 7 Replies
Nov 26, 2009
I have a string that looks like this:
var expression = @"Args("token1") + Args("token2")";
I want to retrieve a collection of strings that are enclosed in Args("") in the expression.
How would I do this in C# or VB.NET?
View 4 Replies
Nov 27, 2009
When i try to put two string in a ListView1 i get this error.
Quote:
Error1Operator '&' is not defined for types 'System.Windows.Forms.ListViewItem' and System.Windows.Forms.ListViewItem'.C:UsersAdminDocumentsProForm1.vb5037FileFind
My code
Dim lvi As New ListViewItem(foundFile, 0)
Dim str(1) As String
Dim itm As ListViewItem
[Code]....
View 27 Replies
