i have a column that i want to select from a table called style_number
each entry is listed as "something-stylenumber"
is there a way to strip everything from the - and to the left from the string when it is returned from mysql?
SELECT style_number FROM table1
I do not want to have to use vb.net to edit the returned string for each line that is pulled
When a WebBrowser controls loads and navigates to a page it strips out everything after the '?'
how to overcome this and pass the query string to the page?
I need to find next highest no in a field that is a stick ref it has chars at front and 0 padded How so I strip off front chars and 0's to get actual highest no number in the table field?Am using LINQ against entity framework?
View 4 RepliesI am a beginner and trying to learn. My problem is I am trying to break down a string for a part number. The string looks like" ABCD259A8755" . I need to separate it to sections like ABCD, 2, 5, 9, A, 8, 75, 5,
View 3 RepliesI am very new to VB, and am programming in VB 2008 express. Sorry if this thread is in the wrong spot I need to add two 40 digit numbers together and was thinking that the simplest way to do it would be to input them as a string and then convert the string to a single dimensional array where x(1) is the 1st digit in the number, and x(30) is the 30th digit, etc. I would do the same for the other number where y(1) is the 1st digit. I would then add the x(40) and y(40) (which are the last digits of the number) together and carry the remainder into the next addition (39th digit, 38, ...)
[Code]...
I have a string STR="CYHZ 262338Z 2700/2724 27012G22KT P6SM BKN040 TEMPO 2700/2710 5SM -SHSN BKN015 BECMG 2702/2704 28015G25KT FM271000 28018G28KT P6SM BKN040 BECMG 2722/2724 27012KT RMK NXT FCST BY 270300Z"
I want to put the new line characher before these words in the string(TEMPO, BECMG, FM, RMK) so that the output string look like this
[Code]...
Ok, sorry to be so needy this week! Here is the situation. I have discovered how to do a linq query to get my data from my xml but when I return it as a string to a list box it is coming in as one large line. No breaks.
Here is the xml:
- <record>
<jurisdiction>VA Circuit</jurisdiction>
[code].....
When trying to register a new user on the server, the server will post back messages such as "OK" and "usernameTaken". Upon comparing this returned string with another string (to perform an action based on the returned value), the compare isn't working.
Dim backupX As New CBackup
backupX.startSocket("127.0.0.1", 8888)
Dim str1 As String = backupX.registerUser("user1", "testpass")
Dim str2 As String = "usernameTaken"
[code]....
Looks to be like the socket code is working just fine.. each Function returns the corresponding Functions' Return value (registerUser -> SocketSendAndReceiveMSG -> sendAndReceiveMSG -> receiveMSG).
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 RepliesIf 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 RepliesWith 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]...
I am using VB to query a MySQl database and populate an Excel spreadsheet. All is working well, but now I would like to start distributing the spreadsheet shroughout the company and cannot protect it.If I protect the spreadsheet the VB cannot add the MySQL data, so I added an unprotect line at the start of the code. That works well, but now the sheet is
'Unprotect all sheets
Dim WSheet As Worksheet
For Each WSheet In Worksheets
[code]....
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 new in VB.NET. Can any tell me how a richtextbox query MySQL table. i.e select * from table test where name= 'Bowser' then the richtextbox will display the results.
View 3 RepliesI'm just wondering if it's possibe to get the results from a query and then assign the results to a variable. So I will run a query which will return the names of the tables stored in the database, then I want them to be stored in a variable. So it would be something along the lines of:
Dim strFrom AS String = "FROM "
strQuery = "SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'Database1'"
con.Open()
[Code]....
I am finding it exceptionally difficult to pass an sql query result (string) into a variable.No matter what I try, I can't seem to get anything but boolean output from my reader function.I need to obtain staff "account type" from my staff table and then define that account type in a variable.
View 1 RepliesI 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 want to create 1000 MySQL database on a hosting server & add 1 single user in all of them with all privileges enabled,Now I know how to create a database from MySQL query, But what I can not find is "how to add a user in the database",For example: create database 1a;This will create the database, but with the creation of the database I also want to add a user in that database from the same MySQL query, or another query to run with it, but I want both operation to run at the same time.
View 1 RepliesTrying to do a mysql parametrized query and i'm having a little issue.
cmd = conn.CreateCommand
cmd.CommandText = "insert into `rootforest` (rootforestname, BusinessName) VALUES (?rfname, ?bname)"
[Code]....
It errors on the executenonquery. Says the column rootforestname can not be null. i don't under stand why it does not fill in the value in the command text.
i am trying to insert/save the listview item/s on the database.what i am trying to do now is if the product is being entered/saved for the first time.the fcode should be 1, and increments after that.i have a combo box and a text box.the combo box items are from the database [ product table ]
let say user choose product 1
and the list view has 2 items [ a, b ]
and then save
the table would look like
fcode -- prod_id -- prod_name -- item
1 1 product 1 a
1 1 product 1 b[code]......
My DATE field always display with time in vb.net is there a select query to format it into yyyy-MM-dd?
View 3 Replieshow to input data in mysql, different tables with one query?is it possible to do in gridview in vb.net 2008?
View 4 Repliesi'm trying to populate a simple combobox with a query to a MySql database. I Just want the combobox to show the results of the query:
SELET DISTINCT models from Cars
I am using VB 2008 with Datasets, how can I achieve this?
this is the code for my save button
Dim iCount As Integer
Dim iLoop As Integer
Dim query3 As New MySqlCommand
[Code]....
every time i hit save, there is no error but it does not save on my database.
here is my code
Dim lvitem
Dim iCount As Integer
Dim iLoop As Integer
[code].....
