I have some code in Form Load event. It is doing fine. But when it reaches to pick data from database, no commands are executing after that. There is no error at all but it just goes silent.[code]...
View 3 Replies
I have two if statements and my project sees one and not the other. Here is the code:
If (IsPostBack) Then
HandleUploadedFile()
End If
Dim savePath As String = "Images "
If (fileUpload.HasFile) Then
[Code] .....
When I trace my code I find it goes to the second if and then go to end if without running the code inside the conditional.
Basically I want to be able to do this:
session.ExecuteSql("...");
I don't need it to map to any entities or return any values.
Okay, heres the deal...I need to open up a cmd prompt, then run a file called adb.exe which opens a shell to communicate with my android cell phone...
My Form1
Code:
Label1.Text = "adb.exe shell"
[code].....
how can i execute a shell command from a string
shell("cd", StringName)
the string comes from a user entered textbox
StringName = Textbox.text
how can i get this to work?
I'm implementing an application using vb.net 2005 with oracle 10g and I came across a functionality that should Select/Insert/Update/Delete data from three different tables in oracle.So I`m wondering if there is a way to prepare all the 3 commands (SQL Statements) separately and then execute them in one shot to the oracle, so in this way I can guarantee that all of them are successfully executed or all are failed to execute, and also I could gain more performance which is critical in my case.Thus I`m looking for a syntax in vb.net that helps me execute more than one OracleCommand in one shot to the oracle.
View 1 RepliesI need to execute the following commands from my application:
Echo Y | DEL C:Folder1cache*.*
DEL C:Folder1file.abc
DEL C:Folder1file.xyz
[code].....
I'm trying to create a program that does the following:Executes the following command line string (wmic /node:computername bios get serialnumber)Prompts user for the "node" entry Displays the resulting serial number in a dialog box I'm a bit of a noob at this (I haven't coded anything in VB since early 2000s) so I'm at a bit of a loss where to start. I plan on including some functions to submit the node entry and the resulting serial number to a database in the future for archiving as well.
View 4 RepliesCan someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 RepliesI am trying to figure out how to do this:
if (phrase = hello) then
"say hello"
if (phrase = how are you?) then
[CODE]...
So basically, I want it to work like a timeline. If I say hello, then it will respond and move onto the next if statement. Get it?
Here is the code I have now:
If phrase.Result.Text = "hello" Then
synth.Speak("Hello to you too")
If phrase.Result.Text.Contains("How are you") Then
[CODE]...
I have to Create a Bowling Scores application that allows the user to enter 5 scores and then displays the high score and the low score and then clicking on the Statistics button there would be a label showing which is higher and lower. We HAVE TO USE FOR AND NEXT STATEMENTS.
View 7 RepliesHow can i implement a statement with if for this number to be greater than 0 but less than 10? More Specifically where would the < 10 go?
Quote:
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
[code].....
is there any way to use 2 for every.... statements?
i want to load up my.settings and 1 list will make new toolstripdropdownitem and the other lists is for the tooltiptexts
or I could do it another way, but how can I check the index of items in a my.setting string collection? like if I want to get the text of index number 3 how do I do that?
I am using Microsoft Visual Studio 2008 with VB.NET, and in class we were assigned this project: A procedure should calculate a 2% price increase on all red shirts, but a 1% price increase on all other items. In addition to calculating the price increase, the procedure also should calculate the new price. You can use the variables strItemColr, strItem, decOrigPrice, decIncrease, and decNewPrice. Format the original price, price increase, and new price in the lblOriginal, lblIncrease, and lblNewPrice controls, respectively.
View 1 RepliesBasically if i wanted my controls to be checked at startup id use a setting obviously
'UI Settings
chkCloseToTray.Checked = My.Settings.CloseToTray
chkAlwaysShowSystemTrayIcon.Checked = My.Settings.AlwaysShowTrayIcon
[code].....
how to combine this 2 statment..
IsConnected("Select * from manager_table", False)
Call Loader()
IsConnected("Select * from Clerk_table", False)
Call Loader()
i hve 2 listview, 2 table from accessdatabase..i put listview in tabcontrol..1 in tab 1 & second in tab 2...
I need to know if this particular block of code will work, and if not, what i need to do to make it work. I'm doing touchy business and i'd prefer to have it right the first time.
strsql = "IF COL_LENGTH('orders','nosign') IS NULL" & _
"BEGIN" & _
"ALTER TABLE orders" >& _
"ADD nosign bit;" & _
"END"
How do I make an OR Statement.
Im trying to do this
name3 = [name2].EndsWith("," Or "." Or "?" Or "!" Or ";" Or ":")
I just wanted to know if it's possible to get an if statement to accept two strings into the same text box. An example of my code so far is below: (although please note that the program does not accept the strings after the "Or" boolean)
Private Sub btnpreview_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnpreview.Click
If cbox2.Checked Then
[code].....
Okay I need two blocks of code for each of these:[code]Now both of these are under the if statements checking if the startsWith or equalsIgnoreCase check boxes are checked. (Only one is under the corresponding code not both.) At runtime when I check off the boxes neither of these two code blocks execute.
View 4 RepliesHere is my code as I have it
Code:
Public Class Form1
Dim OpePro(7) As String
[code].....
I'm having some problems getting a query to run based off another query. Here's the database diagram to give a little background. The primary keys for all the tables are automatically generated by identites. The first 2 insert statements (Donation and Food_Donation) work but I can't get the last insert into Donation_Details to work. Here's the code so far:
View 2 RepliesI cant really find any good sources for connecting to a database via connection string and executing prepared statements. Could someone show me an example or point me to a resource that might be useful?
View 2 RepliesI am trying to use if statements to add the prices of a cruises special packages together. I am using check boxes for the packages, so any, from none to all 3 are able to be checked. The packages available are VIP, excursion and restaurant. The price will also depend on the cruise length (7 or 10 day). I am wondering on which format to use, and if I even need to use if statements, how to make this statement true,
View 1 Repliesok so i am in programming 1 and im trying to use a like statement for someone imputing a password and here is the details
-Changes all vowels to "X"
-Changes all numbers to "Z"
-Changes password to origonal form
i have tried but this is all i have
Dim vowelA As String
Dim vowelE As String
Dim vowelI As String
[Code]....
I am very new VB .NET and just starting If statements. My problem is: Write an If statement that determines whether the variable CurrentBalance is greater then 1000.01. If it is, multiply the variable CurrentBalance by 1.005. Otherwise, multiply CurrentBalance by 1.007.So far I have
Sub Main()
Dim currentBalance As Boolean
System.Console.WriteLine("Enter Current Balance: " & currentBalance)
If CDbl(currentBalance) > 1000.01 Then
[code].....
I really don't even know if thats how I should be starting. Not sure what to put after the first Then on how to make it multiply currentBalance by 100.5.
Are the following 2 SQL statements the same? Will they produce the same results?
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' OR [Subject2] LIKE '" & Subject(0) & "') AND ([Day1] LIKE '" & TabDay & "' OR [Day2] LIKE '" & TabDay & "') AND ([Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "' OR [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' AND [Day1] LIKE '" & TabDay & "' AND [Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "') OR ([Subject2] LIKE '" & Subject(0) & "' AND [Day2] LIKE '" & TabDay & "' AND [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
In my case they simply produce the same results but that's because of the data i'm using.
I have a general query that I need clarifying by some intelligent boffins such as yourselves. I have the following code in a function:[code]Obviously the Dispose method will never be called on the site object or the helper object. This may be a stupid question but can I get an explanation as to how these objects actually get disposed of in memory? Is it just by the fact that the enclosing method they were created in has been disposed of?![code]
View 3 RepliesIs it considered bad practice to use colons to put two statements on the same line?
View 9 RepliesI just want to know how to create a prepared statement in VB. I know in java one would use ? and these would get replaced. I am aware that in VB you use @ParameterName. Basically my code gets down to where i use the prepare method and the error i get is that my syntax for my insert is incorrect. To me it seems that the parameter is not getting substituted in the insert statement
Eg.
Dim cmd As String = "insert into sites(id) values(@id)"
Dim odcmd As New OdbcCommand
odcmd.CommandText = cmd[code].......
