I have an asp.net web form that uploads files. Part of the code seems messy to me, but I can't figure out another way to write it.
Here it is:
CODE:
Is there a better way to write this without all the "Or" s ?
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?
i have a question about how to write an if else statement. I was experimenting with vb 2008 and wrote a program that adds few numbers together and displays the result in textboxes. for example i input the following 4 number in 4 different textboxes
14 3 1 5
and the result i get is 15 8. I was trying to simulate adding times together(eg 14:03 + 1:05 = 15:05). Everything seems to be working fine but how can i place "0" if the output for the minutes is less that 10? eg instead of having 8 in the textbox i would like to have 08.
I need to write an sql statement that has an IF condition in it
This is my current statment:
"SELECT * From History Where DelNoteNum = " & delNote & " ORDER BY StockLoc"
What I need to do though is if the StockLoc > 4000 then group by ProductCode. I definatly only need to do this if the stock location is greater than 4000 though.
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]....
How do i programmatically execute a SQL statement using datasets?
View 6 RepliesI need help with a month calendar. I want to write an If statement in a button_click event. I need an If statement that says if one date is selected then a label becomes visible. I cannot figure it out.
View 1 RepliesWrite the pseudo-code for an If..Then statement that determines the apropriate tax rate for a given annual income level using the guide below:
Under $20,000 = 2% income tax
$20,000 - $50,000 = 5%
$50,001 - $75,000 = 10%
This is what i wrote:
If Annual Income is < $20,000 Then
income tax = 2%
If Annual Income is $20,000<= $50,000 Then
[code]....
If I have the following structure:[code]How can I select it in a conditional like this? [code]I know that myUsers.Contains(.ID = "1") is totally wrong, but I am curious how to do something like that?Is it possible? Is this a job for LINQ?
View 3 RepliesIm trying to figure how to use the IF, ELSE statements OR the Select Case statement to write this program.I'm using Visual Studio 2010. The program is suppose to allow the user to input their weight in a text box and from group box 1 the select whether theyre male or female using the radios and they select inactive or active from group box two and the calculate but will determine how many calories they should intake based on the criteria below.
[Code]...
Table 1 has fields: A, B, C, Table 2, there are fields: D, E, F, Table 3 has fields: G, H, I
Connect the condition that A = D and F = I
provide a look at Table A left join B, C of the SQL statement
How to write a if else statement to check if the number user enter follow within a range.
View 5 RepliesBasically, I am trying to write a LINQ to Objects statement where the relationship is a grandparent, parent, child relationship. (You could also call it a Master Detail relationship.)
Dim coverages As New List(Of Coverage)
Dim coverage As Coverage
For Each rl In oClaimsPolicy.RiskLocations
[code].....
It has to be a simple line of code but I do not know how to construct it. Using VB 2010 Express, I have a MDI parent form and many child forms. I want the parent form to determine what child form is active and load data into the RichTextBox1 on the child form. Each Child form has a RichTextBox1. The parent form gets its data by loading a file.
I am close to a solution but just can't get there. You will see in the code below, if I make a direct reference to a specific child form, it works great. What I want to do is to use the Active Form function to determine which form to write to. I have looked at the MS tutorial which gets me close.
Private
Sub OpenToolStripMenuItem_Click(ByVal sender
As System.Object,
[Code].....
How would I be able to avoid using the imports statements on each form of the project?
i.e. just using the statements on the main form
Imports System
Imports System.IO
I don't see why this code is not running. I want the form to be hided if the statement is true, but what it does is only open the other form but not hide this one.
Dim fileExists As Boolean
fileExists = My.Computer.FileSystem.FileExists("C: est est.tx")
If fileExists = True Then[code].....
In my new application i have to process a SQL statement.Depending on the settings , the statement takes between 10 an 20 seconds.is there a possibility to display a second from / dialog / popup for this time?
View 5 RepliesHow do I(Can I) code a conditional statement in a TableAdapter query? I have a product code which can be either 8 or 9 characters long. Product codes are stored in an Access 2003 db table. I need to group products so in Access I have a simple Function which work fine in a Jet SQL query. But I can't get it to work in VB 2005.
Public Function ProdCats(ByVal Prod as string)
Dim Cat as string = Len(Prod)
Select Case Cat
[Code]....
I have a windows application. I would like to run a statement while exiting my application. I tried adding my statement on FormClosing event. but it only executes if the application is closed properly. However, If the application is closed via task manager or system is restarted or logged out, etc. then the statement in closing or disposed event is not getting executed.
Private Sub Form1_Disposed(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Disposed
MsgBox("disposed") End Sub Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As FormClosingEventArgs) Handles Me.FormClosing
MsgBox("closing")
End Sub
can some one tell me how to get my statement executed even the user tries to log out or shut down or application is closed via task manger.
[Code]....
Apparently, filetype refers to the extension of the program. But I do not want it to read .exe and .lnk programs. So how can I include this "If Else" statement into the one stated above?
I've been working of a Visual Basic Windows Form in Visual Studio 2010 as my first little VB project. It's a form which runs a stored procedure on SQL. I have this all working, however, the stored procedure has a PRINT statement execute if a duplicate is found and stops. What I'd like to do is have this PRINT statement display on the Windows form MessageLabel (label) or have a "successful" message displayed if there is no SQL print statement.
[code]...
I'm currently having some trouble getting an If statement to work. I want the statement to do its thing when it detects a form is not open. this might sound a bit confusing this is what i mean:
If Form2.open = false Then
blah blah blah
blah blah blah
blah blah blah
[CODE]...
Basically i dont know if im able to have an IF statement occur for when a form is not open and i dont know how to word it.
I'm a VB newbie in this respect so please be patient with me! I have an app that requires the user to input a bunch of values for various things in textboxes, datagridviews and propertygrids. I want this user input to be written to a text file in a specific format (say, on the click of a button, but dynamic writing wouldn't be so bad!)
View 3 Repliesthe way im connecting to database is different than any turtorial i found im using access and i need to write a ssn from a form to the database field.[code]
View 9 RepliesI'm trying to make a form that when it is return to, it will have the same state for the controlsI have 3 .net pages, testa,testb,testctesta, sets up the session and has a button to go to testb. testb has a check box and a button to go to testc. testc has a button to return to page testb.I want it so when we leave testc, and then come back the check mark will be in the same state, but it is not. it stays as uncheck when I go from page testc back to page testbThis is what i did,On the page load event, I set the check box equal to the "button" Session variable. On the button event I save the button checked state in the Session variable and call page testc
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
Server.Transfer("testb.aspx")
End Sub
[code].....
I would like to know if Visual Studio does have a setting where you can choose whether it should write nombers like 0.00000127 in scientific notation or not? I am writing such doubles to file but VB2008 writes them in scientific notation. If I treat these numbers as decimals then it writes them correctly, but I also have to take care of performance as I'm writing lots of numbers.
View 1 RepliesSo I want to post to a site with the document.getelementbyid code. What do I do when the form I want to post too has another form with the same exact id?
View 3 Repliesy 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?
