I need to fill an array with whole column from database table, so i have used reader to read the values from that column, but can not figure out how to put them into array (code below doesn't work) [Code]
View 3 RepliesI have been told that the best way to do a search in VB is to fill an array with ALL the records from a table in a database and then filter the records from the array, instead of using the SQL statement Where.
View 25 RepliesI want to fill an Array and list box from a table, with ALL of the records.
I DONT want to use Displaymember. Like shown below...
CODE:
This is the code so far, but it is only filling with the first record.
CODE:
In VB 2008, I use a combobox on a form, and I want to fill it with data coming from a column of an SQL Server table
The Table is PLG_Rank, Columns are "ID_Rank, Rank_Name, Rank_Code"
I want to fill the combo with PLG_Rank.Rank_Name
After that, on a selection in the combobox, I want to use the PLG_Rang.ID_Rank for a request on the SQL_Server
is it possible to fill up a 3 column ListView with an array.
View 5 RepliesI use split button with ContextMenuStrip and i need to fill ContextMenuStrip with data in database like item name
View 2 RepliesI am using MS Access and i want to fill a combobox cmbFamily with data from a column called family in a dataset called availability and also a combobox called cmbModel with a column called model.
i have this:
cmbFamily.Items.Add(Availability.Columns.Contains("Family"))
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
'and
cmbModel.Items.Add(Availability.Columns.Contains(cmbFamily.Text))
If you're not living on the edge, you're taking up too much room
I have a table adapter for a fairly sizable piece of data. Now with this data I would like to give the user the ability to change the company name and have this reflected in the form on the drop down list of all of the companies once they have clicked submit. However, in order to do so I currently "Fill" the entire table adapter again to achieve this.Is there any way which I could just re-fill the company column from the database in the same tablea dapter.Here is my code for the sub:
Dim NewName As String = txtNewName.Text
Dim OldName As String = txtOldName.Text
Dim FieldName As String = Me.Text[code]...
how i can connect to an access database and fill a combox with data of a column?
View 1 RepliesI have 2 databases that I am working with. One is a compant customer database and the other is my personal call log. Now I am creating a front end for the Call Log. I was updating my customer list by Importing 2 tables from the customer database, a series of queries would erase all of my info, take all the data from the imported tables and move it into mine then erase the imported tables.
Im trying to accomplish the same in my VB frontend. I can connect and fill datasets from the customer database. I can erase my tables. How do I take all of this data from the newly created dataset and move it over to my empty tables?
[Code]...
Is it possible to fill a Combo Box with the names of the fields of a table(from a database)?
View 6 RepliesThis should be an easy one, looks like I got myself too confused.I get a table from a database, data ranges from varchar to int to Null values. Cheap and dirty way of converting this into a tab-delimited file that I already have is this (shrunken to preserve space, ugliness is kept on par with original):
da.Fill(dt)
' da - DataAdapter '
' dt - DataTable '
[code].....
I am new in forum and in VB 2008 as well, I have a little background in VB6 I am making a program for a project and I need to calculate some mathematical formulas and the results I want to send them in an external device via serial port. To be more specific I have a function, like y(x)=a*x+y0. I get the starting and ending x and y from textbox and I calculate the respective y but I want to store each x and the resulting y(x) in order to send them after the completion of the complete calculation to the serial port.I have tried with datagrid view and dataset but I cannot fill the tables with the results.Does anyone have any idea what I can do.
View 1 RepliesHow can I fill this Percentage array with Sql data reader..
Dim StudentID As Integer = Me.ComboBox1.SelectedValue
Dim Percentage() As Integer
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[code].....
I need to add a column to an existing table in my database. I am having trouble adding a column to my database. I physically go into Microsoft Access and add the column, my problem comes up when Visual Studio does not recognize the table. Basically, I think I'm doing something wrong.
View 5 RepliesI'm woking in aprogram that read sms from phone and show them in datagrid.berfore I link the datagrid to the database it read the show the message fine in the datagrid but now it show Error message
the code for the form load Code:Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0" & ";data source=" & Application.StartupPath & "SMS.mdb") Dim Mocmd As OleDbCommand = New OleDbCommand("Select * FROM TableMobinil", con) Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(Mocmd) Dim myDataSet As DataSet = New DataSet()
[Code]...
my Code for fill datatable is :
n1.SelectCommand = New SqlCommand("Select Code from PriceDrystore where AirplanCode = '" & lblAPcode.Text & "' and substring(Code,8,1)='" & lblRoute.Text & "' ", DS)
n1.Fill(z1)result this code = 8 items
[Code]...
I need to add a new field to an Access database table, the user has filled the table with data, so I have to add the new field but to preserve the old data.
I have found the ALTER TABLE statement, but it gives me an error (ALTER TABLE is not a valid statement)
I done this in php+mysql with "ALTER TABLE People ADD Address TEXT NULL AFTER Name" (as an example)
How can do this in VB2010?
I'm maintaining a Table in SQLserver, the Table contains Transaction of Cash In (Debit) and Cash Out (Credit) as follows:
Table Name : "BankLedger"
DATE...DETAILS........DEBIT...CREDIT...BALANCE
1/1/11.Opening Balance.................5000
1/1/11.Rent payment...........2500.....
2/1/11.Mobile Bill.............500.....
3/1/11.Monthly Share...5000............
6/1/11.Emp Salary.............3000.....
Now my requirement is how to update the Balance column respectively same as "Running Total" method???
DATE....DETAILS........DEBIT...CREDIT..BALANCE
1/1/11..Opening Balance................5000
1/1/11..Rent payment...........2500....2500
2/1/11..Mobile Bill.............500....2000
3/1/11..Monthly Share...5000...........7000
6/1/11..Emp Salary.............3000....4000
My application in Visual Basic 2010 and Database SQLserver 2008.
i am new to stored procedure and VB.Net, i am trying to insert a value to a column in a table in my database using VB.Net and Stored procedure Here's the procedure:
1. A user will input a value to a textbox, for example lastname.
2. When the user click the save button, the button will call the stored procedure.
Here's my code in stored procedure:
[Code]...
I'm looking to retrieve all the entries from one column of an access database table and copy to an array. this array i will then be randomly selecting values from it to create foootball fixtures. I'm confident of being able to achieve the random side of it but i'm struggling to get the records into the array.
View 12 RepliesI have a gridview loaded with data from my database and a gridview swapping function which after exchanging data between rows with a column call "Priority", I want to save these changes back to my database. Only the "Priority" column value will be change, how do I update only that Column of my dataset table to my SQL database?
[Code]....
I have made a Database.mdf that contains a table that Includes 3 diffrent Column Names.
1:"ID" This one i set to an primary key and i have also made it automaticlly put a number in order to the list. Like 1,2,3,4,5 for each data added. Data Type for this is int.
2:"WordCombination" Were i enter my word combination that i want it to look for)
3."TypeofCombination" Were i enter what the program should add to what i typed in texbox1 if it contains the WordCombination.
I want my program to se if texbox1 contains any of those WordCombinations in my database. And if thats true, Then i want it to show whats in the TypeofCombination + the text in texbox1 in texbox2. If i enter "What do you want ?" in Textbox1 i want the program to find that "What do you want ?" contains "you want" like in ID:1 WordCombination:you want. So becuse this is ture it should enter TypeofCombination in this case "Question:" + what i entered in Textbox1 to show in Textbox2.So if i write "What do you want ?" and click start. Textbox2 should show "Question: What do you want ?" If i Write "My name is Jake" and click start. Textbox2 should show "Answer: My name is Jake".If I Write "hello you Hi there Jacob" and click start. Textbox2 should show "Greeting: hello you Hi there Jacob".And i Should be able to add and delete Word Combinations Without having to change the program.
I want to create a class (I think) that has properties that correspond to column names in a database table, such that they come up in Intellisense when I type the dot after the class name. Is this possible to do?
View 5 RepliesI am trying to set autocomplete for a textbox using data from a column in a table an Access database. Some of those records in the table have no values. I have set the AutoComplete Mode property to SuggestAppend and the AutoCompleteSource property to CustomSource. When I run the application nothing happens when I type into the textbox. The dataset is called DatabaseDataSet and the table name in the database is called Simple and the specific field/colum is called SIM_TAG1
'Create customsource for tag textboxes to suggest tag terms based on what is in database
Dim oTag As New AutoCompleteStringCollection()
For Each term As DatabaseDataSet.SIMPLERow In Me.DatabaseDataSet.SIMPLE
[code]....
I have an application that uses an access database to fill datasets. My problem is that I have three related tables, when I add a new users to the customers table The parts table fills with data saved in the database with a cust_id of -1.
I discovered that this is caused by adding a part, not saving it and deleting the customer. I Can add code to stop the user from deleting a customer that has parts but I do not have access to the live database to delete the record that are incorrect.
Is there something I can do to delete the rows that have an id of -1 on the load statment?
I'm using one Access Database and DataSet, BindingSource And Table Adapter. My question is: how to fill one listbox on my form with dates from one row from Database.
Look at the picture:
[url]
So listbox needs to have 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20.
How to to this, code?
I got some simple sql statement to see a record but I get an error - column does not belong to table...Here's my
Dim mydataset As New DataSet
mystring = "select max(NoteRef) as max_NoteRef from notes"
Dim adapter As New SqlDataAdapter(mystring, nwindconn)
[code].....
how can i insert record in specific column name..i've used this code it works but how can i insert my record in a specific column name?? here is my code in my btnAddRecord :
If frUpdate = False Then
IsConnected("Insert into products values(" & _
Me.TextBox1.Text & ",'" & _
Me.TextBox2.Text & "','" & _
[code]....
I cant grasp it right now, lol. So here's what Im trying to do: I have two tables, a main table, and an employee table, with a foreign key in the main table pointing to the employee number in the employee table. Im trying to use a databound datagrid to show everything from the main table, and the corresponding name of the employee number referenced in the main table. Is there a way I can do that using DataSet.Table.Column.Expression, or what would be a simple way of doing this? I cant use TableAdapter b/c sometimes the database is offline, so preferably with datasets.
View 1 Replies