Is there an easier way to do this?
The .ColorReportedDate, .ColorTypeKey, .IsColorKeyNull, etc are from my strongly typed dataset row.
If .IsColorKeyNull Then
.ColorReportedDate = Now()
ElseIf cboColorType.SelectedValue <> .ColorTypeKey Then
.ColorReportedDate = Now()
End If
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]...
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
Using an OLEDB connection I want to do a select statement but for the table I am selecting from, a table member also has to be there too which seems to be messing up my results. Normally I would write to get the column "col1":
SELECT lib1.table.col1 FROM lib1.table
For the table I need the information from, the table has a "submember". From what I have gathered the syntax is something like this:
SELECT lib1.table(submember).col1 FROM lib1.table(submember)
The problem is that the results are giving me every column within the table, not just my "col1" data.
I seem to be having a lot of trouble with this project. I am trying to update this atabaseI know that the routines are working (atleast the delete and update of records),but it seems to be going straight from the If statement right to the End If and not attempting the ElseIf statements. If it is something simple...sorry for the dumb question, I'm very new to rogramming in general.
Public Sub Delete()
Dim lngRecordNumber As Long
Dim StartTime As String
[code].....
I have the following portion of a VB Script, and for whatever reason, no matter the input data the first If statement is successful, which is cauing incorrect data in my output file.
Script excerpt (this is a function):
On Error Resume Next
code goes here
If Err.Number = 0 Then
WScript.Echo "It worked!"
[Code]...
in my prev question i was suggested with LINQ solution. It was great and simple. I tried to solve next similar but a bit diff problem with similar approach but i failed.
how can i make the below code better
For Each Item As ListViewItem In RoomsListView.Items
For Each Item1 As Room In myBookedRooms
If Item1.UIN = Item.SubItems(1).Text Then
[Code]....
I have a "if This > That then" statement, that doesn't seem to work, as it triggers regardless that "This" is smaller than "that". Does it matter that these variables are marked as strings vs integers?
View 8 RepliesI have this simple-minded query:
select a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr from mytable
This query works as long as none of the concatenated values are not NULL. If any is null, the address does not show.
I tried this:
select IsNULL(a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr,'') from table
What I would like to accomplish is to replace NULL with empty space if the value is null but I still get no values.
program I am writing needs Microsoft WinStock involved with it. Where do I find it and install it?
View 12 RepliesI would like to know what are the basic steps involved in setting up your application to able to read data from another application. Then take that data and modify it and send it back to the application. The data being read will have over 100 fields.... what is the most efficent way to store them? Put them in a class object?
View 1 RepliesI am retrieving a database object and trying to set the values of the object's fields to various textboxes in my vb.net page
View 3 RepliesI was thinking I should just change the value to "" when a null value has been read from the datasoure. But then I thought maybe there is a property that allows this. is there?
txtComments.DataBindings.Add("Text", rowEquipItem, "Comment")
Here's a bit of code
Private Sub QhBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles QhBindingNavigatorSaveItem.Click
Me.Validate()
[Code]......
I need to search a buffer for a string of characters.The buffer is essentially a binary file (it's an image) and contains lots of chr(0) characters.The string I need to locate also contains chr(0) characters. In fact it is the following string:
chr(100) & chr(0) & chr(0) & chr(163)
This is a marker in the image file for items I need to process.So I though I would do the following:
Dim sFileBuffer as String = system.io.file.readalltext("myimagefile")
Dim sLookFor as String = chr(100) & chr(0) & chr(0) & chr(163)
Dim iLocation as Integer = sFileBuffer.IndexOf(sLookFor)
The problem is that, although the characters in sLookFor definitely exist inside of sFileBuffer - IndexOf will always return -1 (not found).I tried the following:
Dim Marker() as Byte = {100, 0, 0 , 163}
Dim sLookFor as String = System.Text.Encoding.UTF8.GetString(Marker)
Dim sFileBuffer as String = system.io.file.readalltext("myimagefile", Encoding.UTF8)
Dim iLocation as Integer = sFileBuffer.IndexOf(sLookFor)
But this appears to only find occurrences of Chr(100) & Chr(0) - not the full 4 character sequence I desire. It appears to see the second Chr(0) as a termination of the search string.I think the sticking point here is the null. Yes - I can string.replace(chr(0), Chr(255)) in both the sLookFor and the sFileBuffer and adjust my search accordingly - but that seems like a mess to me.Is there not a way to search a buffer of binary data? I've tried working with byte arrays - but there appears to be no way to easily search for a sequence of byte values - just individual elements in the array.
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 RepliesI am getting null values in Environment, ApplicationName, ApplicationPath, ExceptionData when inserting rows in a SQL Server 2005 DB. My log4net configuration is as follows :
<log4net>
<appender name="ADONetAppender_SqlServer" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
[code].....
Let's say I have a MySql stored procedure that inserts a record with some nullable CHAR fields. In VB.NET if I don't check for Nothing (or Null in other languages), I get an exception from the db driver, so I write:
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("_name", if(name Is Nothing, "", name)).Direction = ParameterDirection.Input;
And this is the first thing I don't like; I'd like to pass Nothing and the driver knows it has to put NULL in the Db. But then, in the stored procedure, I have to check back the field if it is empty:
INSERT INTO mytable
(name, -- other 200 char fields)
VALUES
(NULLIF(_name, ''),
-- other 200 char fields
)
I have to check for nothingness/emptiness twice. Is there a better, more direct, way? Even worse, for non reference types (i.e: Integers) the check for nothingness makes no sense, since a primitive type can't be nothing (yes, I could set an Integer to a non meaningful value, say -1 for a positive id, but...).
Assume I have an If-ElseIf decision to make. Do all ElseIf's get executed after one has been found true? [Code] Obviously that is not a real subroutine but I wrote that just to clarify what I'm asking. When this is run, on the second ElseIf the value is equal to 5 so whatever is inside that ElseIf would execute. Once that happens do the following ElseIf's get checked or does the program immediately go to the End If?
View 5 RepliesSince plan1 and plan 2 all plans having same fields but due to their variable values total I make 4 tables having one to many relationship so that duplicate data for few fields get accomodated under different Id. and now there is no need of filtering data also and 4 databinding sources give a serial values to my comboboxes to select veriables to get further calculations.
I have another question now in further calculation there are many calculation sets with using if elseif if statment for such number of sets how to connect them since in form1.vb code file
if I place them one after other some calculations get correct some gets wrong.I hope you understand my question.is there any method to connect such sets( if elseif if) statments one by one under one buttion_click to get correct answer for all the sets.
What is the difference between nesting an 'If' statement in and 'Else' statement and using an 'ElseIf' statement? In the example below, the controls labeled [nAMEoFdAY]Limit are instances of the NumericUpDown object, each representing a day of the week. I need the application to decide which NumericUpDown to draw the value from based on the current day of the week. Will this code work or should I use the 'ElseIf' statement, and if so, how?
[Code]...
Why I can't convert the following If�Then�ElseIf statement into a Select Case statement
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
[code].....
I have a List(Of String) which corresponds to "types" on our database table. We are using the DB2 ADO.NET provider and my final query needs to look something like this: select * from table where type in (@type1, @type2, @type3, @type4).
In the past, I've built the list of query parameters / host variables using a ForEach loop, but I would really like to figure out a way to build them in one line. Of course, I can join all of the strings, but adding the "@" and the incrementing digit is giving me headaches. Anyone have any ideas on how to do this?
I've made some function that generates an email template. Code it generates is pure HTML with CSS. Problem is compiler does this odd error and highlights each time '#' sign appears which is needed to define colors in CSS. I did try to change '#' to '/pound/' and then string.Replace() on RETURN but no luck. I'm more into C# so there i can escape special characters by using '' before them but something f$#$ed up there... Once i remove '#' all back to normal and compiles well.
View 2 Repliesok after some testing, i've concluded that select case is never faster than if/elseif unless there are above 10 elseifs (or cases)is it accurate? (or rather, what shld it be)
View 9 Repliesi was trying to make a free microsoft word plugin in vb.net. It automatically fills a web form. The main problem with the plugin is that it uses web browser control and once it has filled a form it will need to navigate another form. The form can only be filled once it has completely been loaded.so my approach is
1. navigate to first site when form loads
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
WebBrowser1.Navigate("http://google.com")
End Sub
2. use an integer i and use if statements to check which form to fill :
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEv entArgs) Handles WebBrowser1.DocumentCompleted
If (i = 1) Then[code].....
3. this is the main step. you see when main form loads, i=1 so browser goes to google.com (first form), when form is completely loaded, itchecks for value of i. Since i=1, it fills google. After filling and continuing i=2 and browser goes to my personal account page. This means browser again loads the document. Now i=2, so it fills my personal detalis. Now the timer starts. Since i=3, browser navigates to second site and fills the details.
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
If (i = 3) Then
WebBrowser1.Navigate("http://blogger.com")[code]...
now the problem arises. The browser does not go to the third site. Once the timer has been stopped and started, the following code does not goto the elseif part (i.e. i=5) why is that so?
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 RepliesI'm new to visual basic, used it for a few months. My friend is addicted to using a program called Wpe Pro [URL].. and he wanted me to make it more advanced and able to do more stuff.if you no anything about this program please message me
View 5 RepliesI 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.
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?