I m trying to retrieve all tables with thr names to a listbox from my access DB.My DB in remotely located
Imports System.Data.OleDb
Public Class Form1
Dim objconn As OleDbConnection
Dim objcmd As OleDbCommand
[Code]....
I am making a survey-application in winforms that is connected to a MySQL database. Now I want to show the alternatives of a question, and how many answered each question. I have a table for alternatives called tblAlt and a table for answers from users called tblAnswers.
There are only 5 alternatives for each question. Is there a way to get each alternative, and how many answered each of them with one query?
This is what I made so far, but this is definitely wrong:
SELECT tblAlt.altText, Count(tblAnswers.answerID)
FROM tblAlt, tblAnswers
WHERE tblAlt.questionID = " & CInt(questionID) & "
[Code]....
This is my coding in vb.net. I have used two database (1) party (2)partydup. Structure of the tables: party table: fields :code, name1,add1,add2 etc. partyduptable: fields: code, description
In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error.
Imports System.IO
Imports System.Data.OleDb
Imports System.Data.OleDb.OleDbConnection
[Code].....
I was just wondering if I can retrieve two tables from my database to one form? because i'm trying it but it doesn't seem to be working. just the first table i'm trying to retrieve is working.
View 7 RepliesI need to retrieve data from database to Listbox.
Ex:
Database Fields: IndexID, Name, Value
Sample Values:
IndexID: 145214
[Code]......
When I double click on one of selection, it must retrieve IndexID value.
If any one have method to get data inside listbox with columns
here'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.
I want to retrieve all the items in a listbox with a For loop. there are only two itemsin the listbox. I'm able to retrieve the first item in the listbox when the counter of the for loop is 0. when it gets to 1 an IndexOutOfRange Exception is generated.
Here is my code.
Dim i As Integer
Dim count As Integer=Me.ListBox1.Items.count
Dim sel As String
For i=0 To count-1
sel=Me.ListBox1.Items.item(i).ToString
MsgBox(sel)
Next i
This is how I add the 2 textblock to my listbox as an item
Dim StkP As New StackPanel
StkP.Name = "Stack"
Dim txtLine_1 As New TextBlock
[Code]....
But it is always returning the last input of "lblScore_1"
how i can retrive data from database system(access) and then present it to the user in the form of list box ,so i can select one of them? *retrieved data= only one column from the table
View 2 Replies1, How to retrieve all characters in listbox?
2, How to know which lines (multiple and random lines) are selected by mouse?
3, How to scroll to bottom automatically when more lines added?
i need to create one search box using textbox and the result will display on listbox.
I have textbox1 as inputbox, button1 as search button , listbox1 to display the value , Database1.mdb as my database.
I am using 1 listbox and 4 text box. I want to retrieve data from my database i.e. ms access database into listbox I am firing the select query by using this code on Page Load event and list box selecetedindex change event which is following. [code]...
View 1 RepliesI have inherited some code from an external contractor that I have to modify. Firstly, he uses a strongly typed dataset to retrieve some data from an SQL database and then uses that data to populate a listbox. I have decided to use a dropdown list (as the user can only ever select one value at a time).This is the code that populates the DropDownList
Private Sub FillUserComputer(ByVal userId As String)
Try
TraceDebug("Begin FillUserComputer"[code]....
This works well for the first two entries in the DropDownList. However, whenever I select one of the other options and click the Send Request button it "jumps back" to the 2nd entry in the list and sends that data instead, completely ignoring the option I selected.I think I have narrowed down the problem to the fact that the DataValue for the second entry in the list is a Null value.
is there a way to retrieve text value from a listbox based on index ?like if i enter index 0 and want to retrieve it's text value from the listbox
View 5 RepliesI want to retrieve the selected items in a listbox, save them to a collection, and then use that collection later. I thought that was simple enough, but when I clear the selected items in the listbox, my collections (items, indices) change. I found this out by stepping through the code.
Basically what I'm wanting to do is move items in the listbox up or down (up in this case), and still keep them selected.
[Code]...
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesIf I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
SQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
This code bellow to compile a single listBox on form1 to listBox on form2 then listBox on form3.
I want to modified this code to compile 169 of ListBoxs on form1 to 169 listboxs on form2
and 169 listBoxs on form3.Try this code,not need the new coding.
Original code from JoOl and modified by John Anthony oliver
[Code]...
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesI am using VB.NET (version 2008). I have two types of items populating in a listbox (checked listbox). For example: lets say one is type "A" and other is "Type B". Their names maybe same so if the user sees those items in listbox then he won;t be able to determine their type until he click on them and checks out its properties. I wanted that I add each item to listbox and colour them so that blue for example means type "A" is there and red means the other. So this way I will be able to know at a glance that how many item of what type is present. I guess it may not be possible to do that in a standard checkedlistbox. I am also using component factory's krypton controls which enhance the gui of an application. But I dunno if I can progress using that.
View 5 RepliesThe scrollbar that comes with the ListBox is too small for touch screens, so I use my own scrollbar instead. But when you do this on various forms you end up repeating a lot of code. So my solution was to create a custom scollbar that has a property I can set to the control I want it to be a scrollbar for. In vb6, I can use the withevents keyword to get access to the control's events so that all the scrollbar related code can be in the custom scrollbar object I created, except...I had to create a refresh method for the consuming code to use to let the scrollbar know when the number of items changes. The scrollbar doesn't need to be told how many items there are because it has access to the control, but for a listbox there is no event to tie into when an item is added/removed so not 100% of the scrollbar related code could be encapsulated.
View 2 RepliesIs it possible to select an item in one listbox and then display the data of another listbox with the same indexed position? I am planning a project and this is something I would like to attempt but I haven't figured out how to do it.[code..]
I tried doing the above code but instead of displaying the listbox text the message box just returned false.
I am using Visual Basic 2008 Express Edition and I am trying to set a listbox so it starts to scroll when it hits the middle point of what is viewable on my list. I also want to set it so the list is always visible so you when you reach the bottom of the list you can scroll down to the bottom but if you scroll back up once it reaches that middle point it will start to scroll up again.
View 2 Replies