Which one is best approach out of the following? Or Both has same effect ?
Dim carrierName As String
Dim someotherName As String
Dim anotherOne As String
[Code].....
When I am concatenating object values together to form a string in VB.NET, is there a difference in performance or a recommended best practice between using the & concat or the + concat with calls to .ToString() on each object?
Example (which is faster or best practice):
Dim result1 As String = 10 & "em"
Dim result2 As String = 10.ToString() + "em"
Is there a performance difference between these two compiling options?
View 5 RepliesI have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 RepliesCan someone explain to me the difference between a While and a Do While Statement
View 2 RepliesI am writing an application to gather, display and export system information for use with a Support Dept.Is there a performance difference between using WMI and My.Computer.X.X in VS 2005? Is one method better practice than the other?There are more lines with WMI, but am willing to write more if it's considered good practice over using My.Computer.X.X.
View 2 RepliesI would like to know how will performance go when I instantiate multiple classes in one form.e.g
Public Class frmClass
Dim obja As New ClassA
Dim objb As New ClassB
[code]....
I'm implementing a poor-man's ORM an a legacy application (.NET 2.0 web app, hand-coded SQL queries). I have two data classes: Customer and Order:
Public Class Customer
Public Property CustomerId As Integer
Public Property CustomerName As String
[code]....
I'm concerned about the performance of this method, namely if I'm pulling multiple Customer's. For each Customer pulled, I have to hit the database again (opening another connection), and getting the orders for that given customer. If I'm not mistaking, it wouldn't take many records to accumulate a large number of open connections.
How can I determine the number of new connections being made and whether or not I'll encounter any connection pooling or other such .NET-imposed limits?
One thought I've had is to pass the SQLConnection object created in the calling class to the getOrdersByCustomerId function and have that function use the (apparently?) already-open connection. I have not tested it namely because I don't know how to determine if it's better than my existing method. Thoughts?
I'm creating a search web service that returns JSON for processing by the client. The service takes a single search parameter, performs multiple lookups on different tables, then returns a custom JSON object. For example, if the user puts in what appears to be a name, I search both the Customers table for a list of the top n customers and the Orders table for the top n orders that have a customer with that name.
i have a table with data title and date of the data inserted.and right now i want to do count to make the statistic out of it.can i do multiple count in one sql statement?like from, the column date, i want to count how many on this month, and how many in this year, until month selected. this is what i have come up, for now.
SELECT a.trigger_type_code
, c.trigger_name
, COUNT(*) AS number
FROM issue_trigger a
[code]....
by this is only for one count.
How do I combine the following two similar statement into one. They are similar in the sense that they both get input from the same textbox:
Me.ReportsQueryBindingSource.Filter = "ParkingSpaceID = '" & txtSearch.Text & "'"
Me.ReportsQueryBindingSource.Filter = "StudentID = '" & txtSearch.Text & "'"
I have tried couple :
Me.ReportsQueryBindingSource.Filter = "StudentID = '" & txtSearch.Text & "'" Or "ParkingSpaceID ='"& txtSearch.Text & "'"
Me.ReportsQueryBindingSource.Filter = "StudentID Or "ParkingSpaceID ='"& txtSearch.Text & "'"
......just none of them works...
I'm wanting to to make a color scheme selection feature for my program, which involves changing the foreground and background colors of many components at once. I have the components divided into groups in which all elements should have the same background and foreground.
vb
With BtnLoad And BtnSave And TbxListname And CmbProgDifficulty And TbxRptStandard And TbxQNA And BtnAddProbQ .ForeColor = Color.White .BackColor = Color.IndianRed End With
The problem is that this get's an error message saying that you cannot use "And" (or & or +) in the statement.If I just use one object at a time,
vb
With BtnLoad .ForeColor = Color.White .BackColor = Color.IndianRed End With
it works fine. I have so many objects though, I don't really want to copy and paste this with statement 50 times. is there a way to make a with statement take multiple objects?
Is this not the correct way to do this? I get an error with it but if I change it to only one value then it works.
If dt2.Rows(0)("STATUS") = "COMP" Or "CLOSE" Or "CAN" Or "INCOMP" Or "WAPPR" Then
dt.Rows(currentRow).Delete()
End If
I need to pass four parameters to a SQL statement and i'm using the following code. It works fine for the first parameter but ignores the rest without erroring.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conz As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
[Code].....
I currently have an If...Then statement that checks if all fields of a form have been filled before saving the info in a file. I'd like to be able to tell which field has not been filled to give the user a dynamic message (at the moment, it only tells them that the checklist is not completed ) :
If (txtNoDemande.TextLength = 8 _
Or txtNoDemande.TextLength = 13 _
And txtDateLoad.TextLength <> 0 _
[CODE]...
Is there a way to determine which of these conditions is false without having to do a seperate If statement for each ?
How do you test multiple values for equality in one line?
Basically I want to do
if (val1 == val2 == val3 == ... valN)
but in VB.Net.
Can anyone help me with how to use the line continuation with an INSERT Command please. This is my
objCommand.CommandText = "INSERT INTO CollectionForm" & _
"(Region,District,Circuit,AcademicYear,Term,NameOf School,SchoolCode,Stream,Shift,DateOf,OpeningDays, InstructionalDays,EnrolKg1Boys)" & [code].....
I have this SQL:
SELECT count (1) FROM users AS total_drafts WHERE version_replace = @sid
SELECT count (1) AS unpublished_drafts FROM users WHERE version_replace = @sid AND moderated = 0
[code].....
I am trying to write a Function which will return a data table, filled with a data from a database.
The Function will accept 6 diffrenet parameters as Optional. Each one of them will be an additional condition to be added to a where clause, if it`s provided when the function is beeing called.
Is there any method in .NET to simply add a new condition to the where clause?
What iam trying to do is selecting rows on multiple column values. But the statement below doesn't preform like i thought it would...
Code:
Select Distinct Variable From TableName Where (ColumnA Like"%AAA%") And (ColumnA Like"%BBB%")
I have a form that contains multiple conditional or if statements on several defferent for controls.
Example: Radio Buttons, TextBoxes and CheckBoxes.
I am intending to create an order form(demo) where the user can select multiple products.
I have a default order number that changes by one everytime an order is successful.
An order is only successful if all the information on the form is entered correctly.
My question is where do I insert the code for the order number?
Basically for the order number I have a counter that count by increment of one if an order is successful.
Meaning when the user hit place order, and all the infromation is right, then the order numer goes to 1 from zero.
Where do I add the condition for the order number since all the fields must first be completed.
Do I have to create a whole line of if else statements?
I'm trying to create a "quiz" program in VB. The questions to be asked are placed inside text files and have the following format:
[code]...
> VB thinks that im trying to open a file named, what im trying to do is open a txt file which have a file name similar to the value of integer.
labelQuestion.text = variable.Readline().
See
Public Class Form1
Dim sql As String
Dim conn As New OleDb.OleDbConnection
Dim da As New OleDb.OleDbDataAdapter
[CODE]...
The problem, The INSERT statement works fine in the form load but not in the button click event?
I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
y friend and I are re-learning Visual Basic, and we are stumped on this bit of code.
For intAsterisks As Integer = 0 To intLine - 1
lblAsterisks.Text = lblAsterisks.Text + "*"
Next
I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
[Code]...
A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
I cant get this SQL statement to insert any of the values in the form to add to the database
sql
sql = "INSERT INTO prevresults (ExamDate, ExamTime, CorrectAnswers, PassPercentage) VALUES (date.now, time.now, rightanswers, percentage.text)"
[code]....
Return statement which is true in an if statement
View 3 RepliesI'm writing something that will examine a function and rewrite that function in another language so basically if inside my function F1, i have this line of code var x=a.b(1) how do i break up the function body into symbols or "tokens"?I've searched around and thought that stuff in System.Reflection.MethodInfo.GetMethodBody would do the trick however that class doesn't seem to be able to have the capabilities to do what i want..dit 2:basically what I'm trying to do is to write a program in c#/vb and when i hit F5 a serializer function will (use reflection and) take the entire program (all the classes in that program) and serialize it into a single javascript file. of course javascript doesn't have the .net library so basically the C#/VB program will limit its use of classes to the .js library (which is a library written in c#/vb emulating the framework of javascript objects)
View 4 Replies
