MySQL Database Multiple Selections
May 31, 2010I'm using this code to select all the IDs from the mysql database:[code]The command will return all the names. How can i process each one individually ?
View 6 RepliesI'm using this code to select all the IDs from the mysql database:[code]The command will return all the names. How can i process each one individually ?
View 6 Repliesi have a textbox1=Year and a textbox2=Month and a datagridview and as datasource access i want to know the code if i search for a year in databinding and how to look for a month of the focused year?
View 4 RepliesI have 2 listboxes, listbox1 holds File names, listbox2 holds fullpath of the files(listbox2 is hidden just to keep things looking tidy).
What i want to do is (using multiselection) is select files in listbox1 and have listbox2 have the same files(indexes) selected as well.
i am rather new to this but i have tried several ways but listbox2 only selects the first selected file from listbox1.I am using vs2010 visual basic & wpf?
In a small app for demonstrating the use of Regular Expression matching in a text box, I have set it up so I can select one of the matches at a time in the text box to emphasise it. Is it possible to set up a text box so several isolated sections in the text is highlighted so all of the matches are highlighted at the same time. I'm thinking not and could use a picture box to do this but with all the hidden features in vb.net, I wanted to be sure since this would be very handy for my project and would be more useful for large amounts of text. I've read you can make multiple selections in the text box of a combo box.
View 4 RepliesWorking with a couple of listboxes to display userid and emailaddress. I am writing an application for viewing SSRS reports instead of using the Report Manager. I am able to select the report and also send an email to users with a web link to SSRS report so that ReportViewer comes up for them to view, export or print the report. Currently I am only able to send to one recipient and I'd like to be able to send to multiple recipients. However I am having difficulty with the multi-select from a listbox. I have set the SelectionMethod to MultiExtended and so I can select multiple items from the listbox. Here is my code -
[Code]...
and I also add a messagebox.show to display my values, in EmailAddressTo variable, it displays "System.Data.DataRowView" so it was not able to capture the email address at all. Then if I debug further I eventually get the error msg - "The specified string is not in the form required for an e-mail address." because of the empty variable. Using SelectedValue, I was able to get at least the first email address but not the second one.
I am a new student of Visual Basic. I am using Vis. Studio 2010. Is there some sample VB code that I can gain access to that shows how to test on multiple selections that were selected within a listbox using the "For each" construct? In this scenario, multiple items have been selected but not 100% of them. I need to know how to test on which ones are selected as I examine each one in the list using the "For each" construct.
View 2 RepliesMy name is Tim I'm having a problem getting my multiple selections from my list box to display in the results label and there is no examples in the text any how I'm thinking I need to use a loop to get it done. is this evern in the ball park?
Option Explicit On
Option Strict On
Option Infer Off
Public Class MainForm
[code].....
Ive got 10 comboboxes on my form, each of them have the same items. I'm trying to get so that if I pick something from the first combo box it doesnt show up in the list for the 2nd box, etc. Also, I didnt want to just remove the item, incase the user changes their selection in a previous combobox. [code] Rest of the comboboxes have that last piece of code, with the boxes and stuff changed to the correct ones.
View 7 RepliesIve got 10 comboboxes on my form, each of them have the same items. I'm trying to get so that if I pick something from the first combo box it doesnt show up in the list for the 2nd box, etc. Also, I didnt want to just remove the item, incase the user changes their selection in a previous combobox.Example of the code I used, as im on a different computer right now.
Code:
Dim cboList As New List(Of String)
Dim index1, index2, index3, index4, index5, index6, index7, index8, index9 As Integer
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
Rest of the comboboxes have that last piece of code, with the boxes and stuff changed to the correct ones.Problem is that it doesnt remove the previous selections correctly.
I have code that works to place two items in listbox into two textboxes when selected (multiple select extended).
Private Sub lstOutput_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstOutput.SelectedIndexChanged
Dim i As Integer = lstOutput.SelectedIndex
[code]....
I need also to be able to modify the data in the textboxes and replace the lines in the listbox. The reverse code doesn't work properly, it only replaces the first selected item. The "lstOutput.Items(i + 1)" appears not to lead to the second selected item.
Dim i As Integer = lstOutput.SelectedIndex
lstOutput.SelectedItem = lstOutput.Items(i + 1)
lstOutput.Items(i) = txtName.Text
lstOutput.Items(i + 1) = txtPhone.Text
I have scoured the web for ways to manipulate the selected index/indices, with no success.
I am using VB.NET with a MySQL database. I want to update this code to do it all in ONE SQL instead of THREE. Here's the code I'm using, works fine but too slow with multiple lines...
If count3 = "1" Then
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim SQL As String
myCommand.Connection = conn
[Code] .....
I'm using Vb .net 2008
I could use some advice/examples to acheive the following:
I have 1 form, 4 text boxes, (textbox1 ,2, 3, 4)
Textbox1 and Text box 3 and single line text boxes.. Textbox2 is multiline.. (a description field which can be as long or short as the user desires..)
Textbox 4 is a large multi-line textbox that will contain the output of Textbox1,2,3.
I need to find out how to output the contents typed into Textbox1,2 and 3 into Textbox4 while maintaining formatting..
For example, contents of Textbox1 should always be the first text displayed in textbox4, immediately under that should be the contents of Textbox2, and under that, Textbox3
I want to ensure that the text is displayed in that order even if the user enters information into Textbox3 first.. and still displayed in the proper order if Textbox2 has 1 line of text or 20 lines of text.
How could I do this? How can I make the text from one box always be inserted before or After text from another specific textbox when its displayed in the destination Textbox.. (think of Textbox4 like a "preview window" of sorts.. which will later be outputted to an actual txt file.
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 RepliesI have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 RepliesI have a problem with my DataGridViews, actually i have a form with a TabControl with 8 tabs, each tab have a DataGridView control. I'm populating them when the form load, the problem is that i got kind of a limit here, only 3 DataGridViews are getting populated, not 3 specific ones but any 3 i put first on my code. I'm populating them manually, doing a mysql query, filling a DataTable and then making the data source equal to the DataTable.
[Code]...
This is the Query:
DELETE FROM patientpersonal,patientmedical,patientdental
WHERE patientpersonal.'" & dpatientid & "' = patientmedical.'" &
dpatientid & "' AND patientpersonal.'" & dpatientid & "' = patientdental.'"
[code].....
give me a sample code that works when uploading data from access database into MySQL database...
View 6 Repliesi am doing a project for my schooli am having difficulties in inserting data in mysqland also inserting multiple data in just a submit button
View 1 RepliesI've been working with a remote mysql database. The design of the database pretty much requires that I use SELECT commands that include multiple tables, and sometimes joins. Updating a single table query is SO EASY, yet dealing with multiple tables has me pulling my hair out.
[Code]...
What's killing me is that if I make a change to a field in the products table in the datagridview and press button1, the changes are saved. If I make a change to a field in the specials table in the datagridview and press button2, the changes are saved. If I combine the two updates together in a single routine, only the first one is saved. I presume this is because after the first update executes, the dataadapter no longer reports that there are any changes to save, since the update already happened.
I've tried breaking this up into separate dataadapters for each table, but then even using dataset relations, I can't get the data together in a single datagridview. On top of that, the grid itself is only intended to be used for searching and querying data. It still needs to be bound along with a set of textboxes that accept the input.
Lastly, this database is part of an ever-evolving website database with dozens of tables that need interfacing. I just can't see manually maintaining hand written sql statements for every table. That's why I've been working so hard to get the commandbuilder to handle it.
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Repliesi have a datatable named booking_table and i filled it with column names and values
Dim booking_table As New DataTable
booking_table.Columns.Add(
"Time", GetType(String))
[code]....
than the rowindex(0) I want it to start with "8:00" than for example the rowindex(47) should end with "19:00" extra info: every our is parted in four sections of 15 min for example 8:15, 8:30 ,8:45?i want to select the starttime by date.bind to DGV?
im helping a school run a Spelling Bee aimed at children in year 7. And to make it fair and unbiased i need an application that can choose randomise a word from the list box then transfer the string to the text box.So basically something that can pick a random string from the listbox and show it in the textbox1.text property.
View 6 Replieshere's I've got:
Private Sub frm1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim sql, pname, pid, pbrand, description[code]....
This adds the description to the listbox, no problem. How do I retrieve what's selected?I've gone over many documents on the subject, I kinda got it to work, but it gives me the entire description.... I just need the last value (3) to make it work.
im trying to get a selected time and my dataset doesn't return the selections what am i doing wrong in this statement
dim startindex as integer= 0
dim endindex as integer= 0
for each regel as datarow in my dataset.tables("Bookingen").rows
[Code].....
I have a listbox with selection mode set to multiExtended. I want to put whatever is selected into an array, but I can't seem to figure out how to do it. Here is what I have so far, but with this code the selected values go into a single variable and not into an array so only the last item selected is stored.[code]....
View 4 Repliesthis gonna sound like a really basic problem but would some1 be able to tell how me to get a checkbox selection to be displayed as a peice of a text in a listbox or a text box.
View 13 RepliesI have 2 computers. Both with w7 as os. I have installed wampserver on one of them.I have mysql database on wampserver.Then I have made a vb.net program to connect to mysql database. I have put the program on both computers.What I want to do is for those two programs to see the same database that is on one computer. For them to be able to add, delete, update that 1 database. How do I do that? How do I network the mysql database? Do I also have to install wampserver on the other computer?What do I do
View 1 Replieshow can i edit my mysql database using vb.net2008 datagridviewer?i have the code from the reply from other member but mycommand and myadapter is still undifined..
View 1 Replies