I'm trying to write my very first "serious" program using a mysql database. I use the mysql connecter dll to connect with my database. I have a subject and a visit table. I can select a subject and I can get all the visits for all subjects in a list box with:
[Code]...
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 RepliesI have a function that takes in a number of parameters.. it then does a db insert.i have a foreign key on one of the fields (modelID)i want to pass a NULL if no model ID is selected.[code]but now i get an error saying: Nullable object must have a value.if i pass in a 0, it does not insert because it breaks the DB constraints.
View 4 RepliesMy problem is that I have two forms, Form1 and Form2 ...on Form1 there is a TextBox called txtTotal (this contains the calculation of Ticket Prices, thus it's a numeric value) and on Form2 there is a TextBox called txtTotal2. All I want to do is get the same number that appears in txtTotal on Form1 to appear in txtTotal2 on Form2 .However whenever I try some of the help tips online such as using a declaring txtTotal as global or friend it dosn't work, and any other code iv tried attempts pass the textbox value as String which brings an error.
View 2 RepliesI have a function that returns a Datatable. I am passing a list of Integer as an argument. Then I thought tis would work.
Public Function GetEventsByEventType(ByVal EventType As List(Of Integer), ByVal DayInterval As Integer) As DataTable
Using con As New MySqlConnection(strCon)
[Code]...
as you can see. I use string.join to convert the list of integer to something like this. '1,2,3'. Problem is that is read as a string so i get the incorrect results. I need to have where EventType IN(1,2,3).
I am fairly new to VB.NET so I research alot when I run into bugs. Problem is I cannot find a solution to this, or anything remotely dealing with it. I am developing software to connect to a remote mysql server, run a query, and come back with a dataset. I have run this query against the server through a mysql prompt and have received a result successfully. But when i try to run this query from my app, I get an object reference error.
Through debugging I have found that the @ character used for variables in sql strings, is causing the problem in my code, but i cannot find a way to pass this query to the server without visual studio throwing errors. Every answer to the use of variables that I have found, suggests specifically stipulating the variable values in my code, which I do not want to do.
[Code]...
I am having trouble with a mySQL query with the .NET connector. When I create the query, it automatically creates my parameters as objects. I usually change the type to the correct type, which in this case is Date, but I get different results passing in the parameter as a date.When I do "Preview Query" as an object, I get the correct results, but bad results as a Date. I would just leave them as objects, but it errors out when I try to pass a date in.Here's the part of my query that I'm having trouble with:
(Tickets.Resolved >= str_to_date(@startDate, '%m/%d/%Y')) AND (Tickets.Resolved <= str_to_date(@endDate, '%m/%d/%Y')) AND
(Tickets.Status = 'resolved' OR
Tickets.Status = 'rejected')
Is that possible to save values from a listbox to mysql database? I guess yes. I have a list of values in a listbox obtained from splitting a file. The strings are like numbers but they are of type string. What I need is to get those values in the database in the integer type. How can I proceed?
View 8 RepliesI have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query.
If I declare
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
[code].....
I have two forms and I'm trying to pass a declared variable from form1 to form2 and then pass that variable in a sql query that I have in a dataset that is bound to my form. I know that my query works but it's not producing any data. I have debugged my form and can see the data being passed in the variables elsewhere on the page but I'm not sure of the syntax within the query.
[Code]...
I create a hyperlink that when clicks generates a url like so:
[URL]
And I read it into a text box like so:
Me.txtTags.Text = CType(Request.QueryString("Tag"), String)
But the result of this is that the textbox txtTags will only contain C and doesnt have the ++. I tried [URL]and the # is missing as well. But if I look at the address bar these values are there....
I have a public variable that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. If I declare:
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
How then to I declare that variable in form2 and how to I pass it to my sql query.
Here is the code I have for form1: [Code]
and when I debug this form, no data will appear. I'm sure that it's something wrong with how I'm either calling the variable in form2 or in the query. Can anyone offer any assistance on this?
I have a Form1 with a query, and I want to display the results in a DataGridView in Form2, like this:
Form1:
VB
Dim Db As New DataClasses1DataContext
Dim Qry = From country In Db.Countries
Select country
[Code]....
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
Public Shared Function getrealrequests(ByVal itemname1 As String) As ArrayList
Dim sqlStr As String = "data source=localhost;initial catalog=Customers;integrated security = true"
Dim dbRecords As ArrayList = New ArrayList
Dim dbConn As SqlConnection = New SqlConnection(sqlStr)
[Code] .....
I'm trying to pass the value of 'itemname1' to the select query. What's the correct syntax to get it to work?
I am using following code to connect to my database.
Dim conStr As String = "Data Source=.SQLEXPRESS; ![enter image description here][1]
AttachDbFilename=|DataDirectory|dbTest.mdf;
Integrated Security=True;
User Instance=True"
Dim sqlQry As String = "SELECT * FROM [tblTest] WHERE ([Name] = @Name)"
Dim dAdt As New SqlDataAdapter(sqlQry, conStr)
Dim dSet As New DataSet()
Then filling adapter with
dAdt.Fill(dSet, "tblTest")
And then I can use the data the way I want.
My question is: How to pass the value of parameter that user will give through a text box on my webform.
Dim sqlQry As String = "SELECT * FROM [tblTest] <b>WHERE ([Name] = @Name)
I mean how to pass the parameter value to my query?
Do you just need to format the date? Such as msgbox(New Date(2010, 1, 1).ToString("yyyy-MM"))
Or do you need a hashtable:
[Code]...
I want to pass a date as parameter in vb to query the data from the table.If I hardcore the value in the query it works fine for me, but if I pass it as parameter to query, like I am getting the data from edit text and trying to send that as a parameter, this does not work.
SELECT *
FROM VehicleAnalogParamDownload2
WHERE Vapd2_Date between 'From_date.Text' And 'To_Date.Text'
If I run a MySQL query at the same time I have a timer going, the timer lags, even though the query is on a seperate form. My computer has 8GB of RAM, so I doubt that that's the issue. Does VB stop the timer to run the query intentionally? Is there a way to prevent the timer from stopping/ lagging?
View 10 RepliesI'm trying to run a MySQL Query, but I keep getting a syntax error for this.[code]...
View 3 RepliesCan some please tell me how to filter integer type value for Visual basic using query. for example: [code]
View 6 RepliesI have the following query... The only unique identifier i can use is the Primary Key (Access backend). I have a txt box on the form that displays this... I know this is not the best way to accomplish this. But my problem is the datatype here. This is my query:
[Code]...
I am using following code and trying to get data by given parameters. I donot know how to pass the parameter value to my query.
[Code]...
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed.Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function:
Module Module1
Public Function LookUpNow(ByVal userInput As String) As String
LookUpNow = userInput
Return userInput
[code]....
With vb.net 2008 exp + MySQL 5.0
i am unable to get the data from a query / SP created in the database.
kindly have some patience to teach me what basically makes difference in extracting data from a table directly and from a QUERY / SP[code]....
My problem is, when I query by a usual ID, like number with no segments = 1234567890, it works nicely.
But I need to query by some kind of segmented values or ID as = 123-4567-890, when I try by 123-4567-890 this id it does not query anything in mysql although in the database this 123-4567-890 ID is present.
So what is the possible solution to search by segmented value in mysql in VB.NET Here is below, my trying codes in vb
[Code]...
So I'm working with a mysql database, and I already have some queries down. I have to make a windows application form in vb.net that can display the results of these queries in a dataGridView.Lets say I'm working with frm1, and i have datagrid1 which will be filled using the query "select * from xyz" when btn1 is clicked.Can someone please take me through the right steps to do that? References needed, connections to be made, etc. I did look through online materials, but they are mostly way too long and not dataGridView specific
View 2 RepliesI am trying to to an insert query on my MySql db using VS 2008/VB. I have this query: Insert into allservices StartDate....) values ('" & Me.datesched.Value & "', ....) When I use the single and double quotes, as it is above , I get this error: Quote: Incorrect date value '21/10/2009' for column StartDate at row 1
when I remove the single quotes and have only the double ones I get a completely different thing. The date inserted to the database is 01/01/0001. Even if my datetimepicker has a min and max date. Also if someone has any good links on using mysql with vb.net
i am using MySql with vb.net to insert some data in a MySql table and i am facing a problem with encoding.When i try to insert Greek characters the characters in the database are saved as. I made a research in net and found that a mysql query SET NAMES 'utf8'. Solves the problem. I made an execute command but doesnt work.
[Code]...