I am a C# programmer but dabbling in VB.Net because everybody else in my team uses it. In the interests of professional development I would like to shrink the following If... Else... statement.
If cmd.Parameters("@whenUpdated").Equals(DBNull.Value) Then
item.WhenUpdated = Nothing
Else
item.WhenUpdated = cmd.Parameters("@whenUpdated").Value
End If
I'm trying to make this cleaner... I know there's lots of shortcuts for If statements, but I don't know what's best.
If item.RecurrenceId > 0 Then
xmlTextWriter.WriteElementString("recordtype", "2")
ElseIf IsNothing(item.OngoingEndDate) = False Then
xmlTextWriter.WriteElementString("recordtype", "1")
Else
xmlTextWriter.WriteElementString("recordtype", "0")
End If
Here is, basically, how my application works:
When windows starts, my app starts. Whenever my app is running, it hides the desktop, taskbar, etc... When a button is clicked in my application ("Start program"), then my application will set its visible property at false and another application will start.
Everything seems to work perfect except I need a way for my application to set its visible property back to true, but only once the other application that was started earlier, is closed (no longer running.)
My thought was that I could use a timer to check for the applications state every so many seconds:[code...]
I have 2 concerns with this:
1. A timer checking this every few seconds will invoke unneeded stress on a computer since they are running for sometimes very long periods of time.
2. There is a better way to accomplish this that doesnt rely on a timer.
Recently I was handling a TCP/IP server-client window-based program in VB.NET. But in VB.NET. after I include the winsock on it, it cannot check the state. Normally, in VB6, to check the state is as below: If
[Code]...
Using .Net, I need to generate a response based on only the checkboxes on my form that have had there states changed. So how do I know if the check box has changed from its previous value before submission. I can't use the onchange event because the user may check multiple boxes before submitting.
View 3 RepliesHow to check weather the window is currently maximized or restored. I want to do something like if window state maximized then border none and if window state regular, then form border style sizable. This is what I wrote
[code]...
I am very new to this but i have with alote of help maked a program that comunicates with a relay board over rs232.
[code]...
In Visual Studio 2010 is it possible to check the state of variables during run time. When a run time error occurs the error is highlighted and you are able to mouse over different variables to see their values when the error happened. I would like to do something similar except without the error.
View 7 RepliesWhen DateTimePicker check state changed,ValueChanged and TextChanged events don't work always.
View 8 RepliesI want to check the state of a certain key, but only inside timer event. So my sub will be something like.......
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
Need code here along the lines of an old fashioned... 'If Input="Q" then......"
End Sub
I'm not sure how to check for keyboard input except for inside a 'Keydown' event.
So what I'm trying to do is have a program read a text file and use the information to set which checkedlistbox has which check boxes checked and which ones don't.Here's the code I have so far (filepath is the string I use to determine what file is the reference file and is changed when necessary through a different sub routine):
[Code]...
I have a DataGridView that has columns with a value type of boolean.To load the DataGridView, I load values into a DataTable then set theDataGridView.DataSource = theTable What value can I use in the table to load an intermediate check state?
Would it be better to use a check box control with a value than to use a column set to the boolean data type?
The check box is for display only, and will not need to be changed.
For almost a week I am reading and trying to find a solution for checking connection state using a TCP Client (using socket class) In my scenario I have a TCP Client that is connected to a server (it is not controlled by me) and i want that from time to time to check the connection state, and reconnect if necessary.I have read a lot of information on the internet but i did not find a suitable solution.Briefly, these are the methods that i have found on the internet and try to implement.But unfortunatelly, i have found some scenarios where the TCP Server is closed and the TCP Client is still saying Connected 1.Example from MSDN
[code]...
It looks like there is a bug in the DateTimePicker control, because I don't find any event specific for the changing the check state of the checkbox, only the ValueChanged event seems available. So that event should trigger every time the date in a dtp is changed manualy, or by choosing a date from the calender or when the checkbox in the dtp is checked or unchecked by clicking on it, the event ValueChanged should be triggered. But it doesn't do that all the time.
[Code]...
I want to store true or false value based on the state of check box here is my insert statement, the problem is this this insert statement stores 1 or 0 instead of 1 or 0 i want to store true or false how to achieve this. [code]
View 3 RepliesI shtere a way i can loop the radio buttons on a groubBox and check which one of the 3 buttons have been cheked?
[Code]...
how can I create following thing with Visual basic?I would like my excel to check the date value in a cell and compare it to current date and if the value in the cell is older than 2 months compared to current date it would change the cell's colour.
View 1 RepliesI have a DB table with the following columns
PolicyNumber
NextPremiumDate
PremiumNumber
Example For each PolicyNumber i have 5 NextPremiumDates.I want to display the 1st NextPremiumDate which is easy ...but i want to show the next NextPremiumDate only after the last NextPremiumDate has passed...How do i check if the last date has passed?I mean if i have 5 dates in the table given above...how do i check if the 1st date has passed then show 2nd date ...if 2nd has passed show 3rd and so on.
I have a sql statement
SQL = "select * from Candidate where test_date = " & TextBox2.Text
I am getting error in the line myDataAdapter.Fill(myDataSet)
Conversion failed when converting the varchar value '03/15/11' to data type int
In my sql server test_date column data type is varchar.
[code] I want to add a new try statement that will check a different folder and if its there, then redirects them... how do I insert an extra if statement without screwing the whole script up?
View 2 RepliesI have trouble with my vb application.I create query in dataset like this :Select * from Trans where year(dateTrans)=2009 and month(dateTrans)=5But is not work and error message : year and month function not identified, what is the problem ? what a sql date function ?If i create databound from dataset and drag n drop date field in form with datetimepicker control, if i had update dataset, date field is empty.Whats wrong with datetimepicket databound.
View 5 RepliesI got a quite a big sql statement and I get errors when dealing with dates and numeric values. All of this is in order to copy the data to a new table.so these variables I am trying to use for passing the data:
Dim orderdate As Date 'on my sql orderdate is datetime
Dim custntitle As integer 'on my sql is numeric(2,0)
Dim country As Integer ' on my sql is numeric(3,0)
for the date I get an out of range exception,and for these two integers (custNtitle, country) I get invalidCastExceptions when dealing with strings there's no problem but dates and numbers causes errors for me?
Imports System.Data.SqlClient
Public Class Form1
Dim serviceid As String
[code]....
Is it possible to check to see if the text in a textbox is present in a table/database and then display the corresponding data.
View 2 Repliesi am probably overthinking this but how can i check the textbox for either a 655 or 699 in the first 3 numbers in the textbox? The current code i how now works but displays an error if (im guessing) it doesnt find the other number in the textbox as well:
[Code]...
I need to run an If Statement that will check a few conditions.
Basically I want to get it to check a value held in a variable "Temperature" and if the value is within "1" eaither way i.e. +-1 of the value held within the variable to then to output a text string to Label200.Text Else if the condition is not met then out put another text string to Label200.Text.
Example:
Say if Temperature value held in the variable Temperature is 8.5 the if statement checks to see if the DewPoint value is "between" +-1 of the temperature value. i.e. 7.5 to 9.5 as well as the value in Humidity is equal to or greater than 90 and Pressure is Less than or Equal to 1013.25 then the conditon is met, else the conditon is not met.
I have put some code together below in NotePad++ to see if what I am trying to do is the correct way to go about it (note I have not yet tried this code in VB.NET as I don't have it at work).
pass comment on the code and if it is wrong explain what I should do to get it to work.
Dim DewPoint as Single
Dim Temperature as Single
Dim Humidity as Single
[Code]....
Is there a statement to check if a does not equal b? or is it necessary to
vb
if a = b then
'blank
else
[code]....
I am trying to create a statement with my dataset that uses an underlying access table. There is a date column in one of the tables in the dataset/access db. Originally the date column within the datarow was set to 'nothing'.
[Code]...
designing an inventory system and i want to generate crystal reports from sql queries.Actually want to generate monthly and yearly reports from the daily sales reports i have populated
View 4 Repliesmy program is "live" and my customer has troubles because it doesn't functioning as well as it should.I don't know what happen, did I changed something or not but suddenly data won't save to database from newly created forms. Beside this form I have additional 20 forms and everything is working like a charm and I use same code logic to save data to database. I tried to find myself what could be the reason, check by entering data directly to database table (works fine), check insert statement of dataset table (seems fine, too) and everything I could imagine. But now I ran out of ideas and I had to ask here.
Also, I added 3 fields to database table (nvarchar, int and decimal). All 3 of them allow nulls. I changed dataset and data entry form and now data won't insert if I dont enter values to int and decimal fields. Also, this decimal field doesn't accept 0 value if enter but if I assign value 0 from the code than it is ok. I'm not sure if I somehow changed concurrency and somewhere. I tried to find where I can change it but I couldn't find it. I use Visual Studio 2008 and Sql Server 2005 Express. Language vb.net.
How would I go about writing an IF statement that would check for letters? Something like:
IF field IS NOT Int THEN
Response.Write "WRONG!"
ELSE
Response.Write "OK"
END IF