I'm having a problem with Dim query As New MySqlCommand("Select count(*)....") I would like to take the variable query and do an If query <> 1 Then statement on it. Is this possible or is there a completely other way to go about this comparing the contents of a MySQL select statement. I'm rather new to Visual Basic.
View 1 RepliesI am trying to clean up my code a bit.
I made the following function:
Public Sub sqlUpdate(ByVal table As String, ByVal column As String, ByVal var1 As String, ByVal column1 As String, ByVal var2 As String)
Public CN As New MySqlConnection
Public cmd As New MySqlCommand
[CODE]...
Which is fine, if I want to use mysql update all I have to do is call something like: sqlUpdate("test", "test", 0, "test", test) I was wondering if I could do the same with the SELECT statement and make a function. I cant think of a way to do it though...
sqlConnect()
Dim cmd As New MySqlCommand
With cmd
.CommandText = "SELECT * FROM users WHERE username=""" & lblAccountName.Text & """"
[CODE]...
The data I would want to extract would be different every time.
I have the following MySqlCommand:
Dim cmd As New MySqlCommand
cmd.CommandText = "REPLACE INTO `customer` VALUES( ?customerID, ?firstName, ?lastName)"
With cmd.Parameters
[code].....
I have a class that handles execution of MySqlCommands and I'd like to have it log every query to a file. I can retrieve the query/command being executed with:
cmd.CommandText
but that just returns the original CommandText with the parameters (?customerID, ?firstName, etc.) and not the actual substituted values added by the AddWithValue functions. How can I find out the actual "final" query that was executed?
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?
I have a question regarding Select Case. I am comparing different integer in select case for different purpose. I want to run some code on the case when number is not from the list of below mentioned.Can i use this as i mentioned below in Select case?. If not then what does mean. It don't give me any error. Case Is <> 307, Is <> 1, Is <> 12, Is <> 14, Is <> 56ThanksDalbir Singh
View 3 RepliesA 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
The basicServiceFee allows for 10 free connections at $80
Anytime the connections are > 10 each addition connection is $4 plus the basic
How can I add the $4 charge and keep adding it when each number from the connectionsListBox is selected.
My code adds the first $4 charge and then stops after 11 on the connectionsListBox. How do I get 12 to be another $4 and 13 to be another $4
Here is my code:
Private Function businessTotalCharges(ByVal processingFee As Double, ByVal basicServiceFee As Double,
ByVal premiumChannelFee As Double, ByVal connections As Double) As Double
[Code]....
I have searched google and youtube for a tut on this but cant seem to find any :/I have a script that adds contents of textbox1 ans textbox2 to a online mysql database like username and and password.All this works perfect What i now need is to display the contents of the given database in a listbox or something.How would i go about this or is there any good tuts on this, all i seem to find is tuts using ms database not mysql
View 6 RepliesI have one Field in MYSQL DB. Name is ' Field1 '. I can store the Richtextbox text(it contains Bold, Italic, Etc). using the code ' Richtextbox1.rtf 'But when i am trying to display using 'Richtextbox1.rtf=dt.rows(0).item(0).tostring ',It shows 'File Format is not Valid '.
View 2 RepliesI am doing database coding for the first time. I wanted to get connected to MYSQL database with "Root" as username, "Password" as password , "DBNAME" as database name, "Local Host" as host and Append the contents of a textbox control to MYSQL column. So can anybody please post code bit in VB.Net for doing this task.
View 17 Replieshave a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I need to use a SELECT statement to select all data under a column name (like all employee names) and then to add the values to a listbox.
I usderstand that the select statement must be:
"SELECT * FROM EmployeeTable WHERE EmployeeNames LIKE *" (at least I think)
but then what? combobox1.fill ("EmployeesTable") ?
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I'm trying to select the newest OrderID by CustomerID. But it keeps saying I have an error in my SQL syntax, even though it works in PhpMyAdmin. I'm using a MySQL db and an ODBC connector.
Public Function GetOrderIDByCustID(ByVal CustID As Integer) As Integer
myconn.Open()
Dim OrderID As Integer = 0
[Code]....
So this should supply me with the OrderID of the newest Order for that Customer.
I am writing an add-in for VB.NET 2008. I am getting some strange behavior when I run the generated form and was wondering if anyone has any clue as to why this happens. I re-booted and started fresh and get the same results.
I am trying to select the contents of the textbox when the user clicks on it using the Enter event. I tried the following
private sub txtPMAItemPMAStatus_Enter(sender as system.object, byval e as system.eventargs) handles txtPMAItemPMAStatus.enter
With txtPMAItemPMAStatus
[Code]....
After I click OK on the MessageBox the text is selected. Could it be because it is a spawned instance of the IDE?
I am getting a syntax error for the code below.I am trying to create a user in the mysql database and add their information to a datagrid control all in one button click using two statements; one to create the actual user, and one to add the user and their additional information to a table on the database and then refresh the datasource which will display the new user's information in the datagrid control.
If anyone knows where i went wrong please feel free to critique my code and let me know; or simply offer more efficient alternatives to what im hoping to achieve.
For those of you that must know, i am running the latest version of MySql server, MySql Workbench, and Visual Basic 2010 Express on a windows 7 based laptop. I'm writing this program in VB.net.
[Code]...
I'm trying to execute a MySQLCommand like so[code]...
It seems to be something to do with the "size" parameter, but I don't see what is wrong with it.
I want to make a query like this.[url]...
When I test it on my mysql query browser, it works well.
Now, I want to execute it in VB with mysqlCommand. of course @rownum is defined as a parameter and waiting for its value. How can I execute that query in VB?
highlight listview item from mysql search statement then get the index?
View 6 RepliesIt is possible to check two different MySQL tables from the same sub?
For instance:
Dim Connection As MySqlConnection
Connection = New MySqlConnection
Connection.ConnectionString = "server=server; user id=userid; password=password; database=database"
Try
Connection.Open()
[Code]...
What I'm trying to get is something like an "or" function. If TextBox1.Text isn't in the database, then check if TextBox2.Text or TextBox3.Text is in the database.
I create a dictionary in a function which I pass to the function executing the sproc.
Dim PParamDict As New Dictionary(Of String, String)
PParamDict.Add("sname", name)
PParamDict.Add("sdescription", description)
PParamDict.Add("sLoggedInID", LoggedInID)
PParamDict.Add("sCompanyID", CompanyID)
The dictionary gets passed to the function PParamDict -> ParameterDict
Dim dbComm As New MySqlCommand(ProcedureName, PConnection)
Dim pair As KeyValuePair(Of String, String)
For Each pair In ParameterDict
dbComm.Parameters.AddWithValue(pair.Key, pair.Value)
[Code] .....
This works as long as the PParamDict.Add statements are in that order. If they're in a different order they get passed as they come in. This is the most ridiculous thing I've ever seen, I'm passing the keys to the MySqlCommand which are defined letter for letter in the sproc.
with the following code which gets stucked on the line of reader = Cmd.ExecuteReader(). It says the SqlException was unhandled (An expression of non-boolean type specified in a context where a condition is expected, near '7/2/2010'.)
[Code]...
I have successfuly connected to a database and have create a select statement (with access) which works most of the time except when im trying to perform a where statement with a date:
strEmployeeDepartmentLocation = Application.StartupPath
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & strEmployeeDepartmentLocation & "swineFlu.mdb"
strSQLSelectQuery2 = "SELECT NumberOfCase FROM table1 WHERE Date = 21/04/2009;"
i dont no if im writing it in the wrong format or what but it dont seem to bring back any data
I am using the following
Dim cmC As New MySqlCommand()
Dim daC As New MySqlDataAdapter()
Private Sub btnClientSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClientSave.Click
[code].....
When I add 1 client it works fine, but when I try adding another I get the following error:
When MySqlCommandBuilder.ReturnGeneratedIdentifiers is true, MySqlCommand.UpdatedRowSource must be set to None.
I have a datatable and I would like to get the MAX number from this table where Term Number (first Column) is a certain value. If my datatable is declared as dtMyTable, I'm assuming I need to use dtMyTable.Select(), but I'm not sure if this is the best way.
View 2 RepliesI'm using Vb2005 and Db MS access Is it possible to use tow Select in same sql Statement like this example:
Code:
"Select....Select......."
I have 2 dropdown lists, 1 label & 1 textbox.on selection of 'product categories' @ 1st ddl, 2nd ddl displays all product categories.question is, how may i display the product category id @ the label, and name @ the textbox, on load/selection of 2nd ddl?[code]....
View 3 RepliesIf I have a datatable with 5000 rows for example can I do a select statement by row numbers. like paging throught it so I don't have to display all 5000 in the datagrid.. i want to go forward and back by 100 rows
vb.net 2008 (vs 2008)
For example:
dgInbox.DataSource = dsInbox.Tables("Inbox").select(between rows 200 and 300)
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.
I am tryin to access a 2003 Microsoft Access Database using VB in an OleDb format. The database file name is Billings.mdb and there are 3 tables in the file the one I am trying to access is tbl Clients. When debugging the program I continue to get an Unhandled error point to the FROM part of the SELECT statement. It continues to occur regardless of my attempts to vary the input.
In the program my connection statement is as follows:
Dim connectionString As String = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = C:Documents and SettingsTrialsBillings.mdb"
The Select statement is as follows:
Dim selectStatement As String = "SELECT ID, ..., PB " & "FROM tbl_Clients " & "WHERE ID = ?sngID"