I have some pieces of code like this:
strSoftware = "select MobileSoftware.Entertainment, MobileSoftware.MobileApplication, MobileSoftware.RingingTone, MobileSoftware.Directory from MobileSoftware where MobileName = '" + strName + cmdSoftware = New SqlCommand(strSoftware, con)
drSoftware = cmdSoftware.ExecuteReader
When I write the query in one line, then it works. But when I do like this:
[Code]...
Sample Table
Job_ID Job_Name Status
1 TEST00001 FOR KE
2 TEST00002 FOR KE
[code]....
I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will query that.Now, what if two queries was executed at the same time? Will the two users get the same jobname? How can I avoid that?
I am using VB.NET 2008 and SQL Server 2008.My program runs the below query all the time for different values, but yesterday, this query was executed, and it set the other values correctly in myTbl, but it didn't set the "Status" column to 'C' as stated in the query.
update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
There is no error when executing the query.Why the "Status" column wasn't being set correctly, and what can cause this ?
m_cmdSQL = New SqlClient.SqlCommand
With m_cmdSQL
.Connection = adoCon
.CommandText = "update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
End With
m_cmdSQL.ExecuteNonQuery()
I'm trying to run a transaction and I'm having some issues. What would cause a query to be executed before the transaction.commit() is called? Is there a specifice order that queries should be ran when working with a transaction? I have 1 update query that will always execute no matter what, before the .commit() is called. [code]
View 4 RepliesI'm totally baffled why my next line of code is not being read after I use the .SubString method.
First, I read a webpage using WebBrowser.DocumentText
Dim TextString As String = WebBrowser2.DocumentText 'Converts page to html text
Second, I search for the string "Price"
[Code]...
In WPF I'm trying to use commands to set all the content in multiple textboxes at once. The following code is able to get a command on the toggle button to execute for which ever textbox has scope but I can't seem to get the command to execute for both at the same time.
[code]...
Is what I am trying to do possible with commands? I would prefer not having to make direct references to each textbox in code behind inside a click_event or anything like.
In WPF I'm trying to use commands to set all the content in multiple textboxes at once. The following code is able to get a command on the toggle button to execute for which ever textbox has scope but I can't seem to get the command to execute for both at the same time.
[Code]...
How can I have multiple If Not conditions on one line?
Here are the combinations that I've tried, but they either don't work, or won't build.
If Not (txtDisplay.Text = "0") And If Not (txtDisplay.Text = "")
statement1
Else
[Code]....
I am creating an application for a friend and have no issue inserting or updating the table, but I am having trouble relaying the information from the query back to the corresponding textbox when searching for an entry.
This is the closest thing I've got to a working model, but I'm still getting and "array out of index error".
[Code].....
I used to write this:
Private Sub Example()
Static CachedPeople As List(Of MyApp.Person)
If CachedPeople Is Nothing Then
[code]....
But then wondered if I could reduce this to:
Private Sub Example()
Static CachedPeople As New List(Of MyApp.Person)
...rest of code...
End Sub
will the "New" bit only be executed once when the function is first executed but in the next call, it will already exist.
Basically i know this sounds like its malicious but its not
Im trying to create a GUI for a console application but everytime a process is carried out the CMD window appears directly over then application.
Process.Start(fnvLocation.Text, "push " & recDir.Text & "Data.zip /data/local/rmo.zip")
Is it possible to stop a Sub from executing its code when you, for example, click a button?
Example:
Private Sub ExecutedCode()
'doing things here
End Sub
Private Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click 'how to stop ExecutedCode() from being executed?End Sub
I have searched everywhere, and have not found an answer. I would like to know how to enable your form to detect if a process is started. Something like this:
If Process.Start("Process.exe") Then
MsgBox("Process is running")
Else
MsgBox("Process is not running")
End If
what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
Any sample code that will cause the logic coded in the clicked event of a Button to be executed, in Powerbuilder I would code it as
Button,triggerevent(Clicked!)
I know something like this exists, I juts don't know the right word to search about it, so basically I have a cosole application and if it runs twice it crashes. I wanna dispay a message: Sorry app alerady running.I can look at processes and see if my exe is there already running but that's much harder.
View 2 RepliesI am trying to read in a TextBox line by line and take the first 7 characters of each line and output everything in another TextBox.This is what I have so far.
Dim line, lines() As String
lines = TextBox1.Text.Split(Environment.NewLine)
Dim i As Integer = 0
[code].....
I have a xml file that I know what line number the value is on. Right now I'm using a loop through, look for line number 5, when you find it do this. But it's slow. I was wondering if there was a way to say "take value from line 5", or something like that. can I query a xml file by line number?
View 7 RepliesSQL String with multi line query
View 14 Replieshow to draw a simple line chart representing sql query data results?
View 8 Repliesi have six textboxes from which the user can query the database. Now the user can decide to fill all the fields and query this i have done using AND OR in the sql syntax but the problem is when he decides to leave some blank my program is throwing an exception how can i skip the blank fields and only execute the WHERE clause for the filled boxes.
View 6 RepliesI have encountered a table with five fields refering to a customer list. The fields (c1, c2, etc..) are id's of the customer in the other table. Need a SQL statement that will resolve the customer names into a report with on line and the five entires. Example:
Table1
ID Description C1 C2 C3
1 PartyGroup 2 3 1
2 BeerFolk 1 0 2
[Code].....
I'm not sure how to do the following (in VB.NET), I'm hoping you will give me some insight or examples on how it can be done. My database is an SQL one.I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again.
So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
I'm trying to figure out how to get a query for multiple columns in my dataviewgrid.. So far i havn't even been able to make a single column query work, when i search something in First_Name for example, it returns nothing. ive used query builer, ive written the code myself, nothing seems to work.
View 3 RepliesI have a report that I want to filter using a From Date Text Box (which is a string) and a To Date Text Box (which is a string) so the user will insert a start date and and end date to filter the report, how would I do that? This is what I have:
Try
Me.FuelTableAdapter.FillByDate(Me.ShuttleRunsDataSet.Fuel, FromTextBox.Text &
ToTextBox.Text)
[code]....
how to select multiple table in vb2010? i trying to create a login so i need to retrieve the data in 3 different tables in one database i have a code but not work.[code]
View 2 RepliesI am trying to link to a Access database at runtime using a SELECT FROM WHERE query, which I can do but.......
with the WHERE part I want to select several conditions, 4 actually and it is not working, what am I doing wrong?
Here is my code,
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=V:GYMDBFLineProdSanderProduction.mdb")
[Code]....
i am trying to query multiple xml files automatically in order to get a specific data for each xml files. I have create a code but it only query one file at the time. Below is the code that i have created.
Imports System.Xml
Imports System.IO
Module ParsingUsingXmlTextReader
[Code]....
I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again. So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....