Make Datacolumns.expression?
Oct 28, 2009Dim col As DataColumn = dt.Columns(index)
' Remove (and automatically empty) the column object from the table
dt.Columns.Remove(col)
[code].....
Dim col As DataColumn = dt.Columns(index)
' Remove (and automatically empty) the column object from the table
dt.Columns.Remove(col)
[code].....
I am converting data table content to string, Say the dataset has 12 rows and 8 column.
At the end, the Dict contain 12 rows or 96 columns. what's wrong with my code below, how do I reset the row?
Dim ds As DataSet = ClsDB.GetDataSet(sql)
If Not ds Is Nothing AndAlso ds.Tables.Count > 0 Then
Dim row As New List(Of KeyValuePair(Of String, String))
[CODE]...
is there any way to change the order of the datacolumns in a datatable at runtime.
View 2 RepliesI am trying to merge multiple datacolumns in a datatable. Eg. The address data is stored in a different columns such as, Housename, street, city and postcode. I want to merge those datacolumns in to one and put it into one datacolumn as "Address".
View 1 RepliesDim orders = From tt In testTable _
Order By tt.Item("OrderNumber") _
Select tt.Item("OrderNumber"), tt.Item("OrderId")
This is breaking. Is there a way to do this? I would have thought it was easy enough. Obviously, I thought wrong....
I'm trying to convert a function in C# to VB.Net 2008 and can't seem to make the Lamda expression work. The code is taken from a neat little C# SMTP server that saves emails to Azure blob storage
[Code]...
In Entity Framework I usually do something like:
modelBuilder.Entity(Of Model).HasKey(Function(item As Model) New With {item.PropertyA, item.PropertyB })
to map a composite primary key
I need to write a generic function like[code]....
i'm trying to make the regular expression for validations, but I can't manage to get a control of the result I want.
I wanna input in a textbox the following :
(029)-234-2342342
Or what is the same, the ( ), 3 numbers inside, a "-", 3 numbers, another "-" and 7 numbers.
How can I manage it??
How do I make a regular expression to find a substring within a string that looks like: |sdrt446-7fdfs23| ? The number of characters and types change. So I need whatever in within the | |.
View 3 Repliesi try to make a regular expression format to validate phone number at this format: (555) 555-5555 Dim IsPhoneValid As New System.Text.RegularExpressions.Regex("^/([0-9]{3}/)*[0-9]{3}*[0-9]{4}$")
View 3 RepliesI got this Error. below is my code.
GenerateTheList is function.Need help
Private Sub buttGenerate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles buttGenerate.Click
Dim thread1 As New Thread(New ThreadStart(GenerateTheList))
thread1.Start()
End Sub
While looking in the dataset designer for a database table I am doing in visual basic 2008 I found a line for expressions under the property menu for a specific column. I need to know the code that I would put in this expression line so that this column adds up the numbers I input into three other columns and displays that number in the column. I need it to automatically calculate this for each row in the database table.
View 13 RepliesI am trying to write following expression on a datacolumn. But it results in error:Replicate('*', nLevel) + NameWhere: Replicate() is a user defined function (in a module). nLevel and Name are two other columns in same data table.
View 3 RepliesI am using Flee to build a formula builder. It works great but the only problem I'm facing is that Flee doesn't understand Generic Methods I guess. I have a function called IIf declared in the expression context I'm using. [code]How can I work around this. I mean cannot , in sense, write all possible overloads of the function of all .net primitive types. What approach should I take.
View 1 RepliesFrom this code
[Code]...
If I put New Action(AddressOf PrivateMesage), then I get the following error: Bounds can be specified only for the top-level array when initializing an array of arrays. on the following code
[Code]...
I must convert string data from a CNC that is arithmetic expression to a number that I can use in a VB application that I wrote. The following is what I get out of the cnc. [18722*65536+19377]/67108864. I need to evaluate this expression in my VB ap. The format of the string is not always the same as what I have illustrated.
View 2 RepliesI am calling this function when a button is CLICKED and received the error; The name "The" is not permitted in this context. Valid expression are constants, constants expression, and (in some contexts) variables. Column names are not permitted. Unclosed quotation mark after the character string 'True)'.
The function is as follows;
Private Sub Save()
Dim conn As SqlConnection = GetDbConnection()
Dim query As String
Dim cmd As New SqlCommand
I would like to know the equivalent expresion in VB for this C# expression: Container.TotalRowCount > 0 ? Math.Ceiling(((double)(Container.StartRowIndex + Container.MaximumRows) / Container.MaximumRows)) : 0
View 3 Repliesi have a string similar to this one:
Hi, <<
ame>> <<surname>>, this is an example << est>>.
I what a regex that match and split this string in:
"Hi, "
<<
ame>>
" "
[code]....
I tried this one: (<<*.*?>>)|(>>*.*?<<), but doesn't work.
What is the vb.net expression of this c# expression ?
Frame.GetController<ShowNavigationItemController>().CustomShowNavigationItem += new EventHandler<CustomShowNavigationItemEventArgs>(WindowController1_CustomShowNavigationItem);
I'm not sure if this is possible but I would like to associate a class name reference to a shared member method / property / variable. Consider:
Public Class UserParameters
Public Shared Reference As Object
Public Shared Function GetReference() As Object
[Code]....
In another part of the program I would like to simply call UserParameters and have it return Reference either by aliasing GetReference or the variable directly.
I am trying to emulate the Application, Request, or Session variable:
Session(0) = Session.Item(0)
I am dumb founded at this statement....maybe its just too many hours/days of doing C# to VB.Net conversion but i am drawing a blank on this conversion.
List<string> sColors = new List<string>(this.CustomPaletteValues.Split(','));
try {
List<Color> colors = sColors.ConvertAll<Color>(s => (Color)(new ColorConverter().ConvertFromString(s)));
What i have so far:
Dim colors As List(Of Color) = sColors.ConvertAll(Of Color)(....)
As you can see its the content of the lambda that i am hitting a brick wall with.
I saw an example of using Expression Builders, and creating your own Custom Expression Builder Classes here: [Url] However, I fail to see the value in using this approach. It doesn't seem much easier than programmatically setting values in your code behind. As far as I can tell, the only thing you can do with them is set properties. Maybe they would be useful for setting defaults on certain controls? Can anyone shed light on where this ASP.NET feature becomes powerful?
View 4 RepliesThe code you posted while similar to VB6 has method and syntax that is very similar to Crystal Reports Scripting Language
[Code]...
i didn't want to trust this one to any number of online conversion websites that I often use.I don't need to convert the declarations, just the expression '(byte)((flen & 0xff00) >> 8)'in
byte[] sendFrameData = new byte[280
ushort flen
sendFrameData[7] = (byte)((flen & 0xff00) >> 8);
'I am having trouble with the line "senda = suba(sendaobj, EventArgs.Empty)". [code]...
View 12 RepliesHere's the
Sub DestroyUser(ByRef Victomcheck As Integer, ByRef Victorcheck As Integer)
Dim num As Object
WriteSub("destroyuser")
[Code]......
I don't know what I have done wrong in this code using vb 2010 express, well here it is anyway
MsgBox(10)
MsgBoxStyle.Critical()
MsgBoxStyle.OkOnly("ERROR")
I get three errors of expression is not a method
Expression not producing a value [code]...
View 7 RepliesIn the following
For Each <reference> IN <expression>is <expression> evaluated for each iteration of the loop? Specifically, if <expression> is costly to evaluate, would it be wise to evaluate it once before the For Each statement and keep the result in a local variable to use in the For Each statement?