I need to populate values from a database(Access) in to vb.net form. after selecting a field from first form, the next form should display all the parameters used in the selected field from the data base. Also if do editing it should be updated in the database.
View 4 RepliesPrivate ReadOnly Property Values() As Decimal()
Get
Dim X As Integer = 1
[Code]....
{"An error occurred creating the form. See Exception.InnerException for details. The error is: At least one element in the source array could not be cast down to the destination array type."}
I am populating a collection from some tables in the database which serves as a look-up from controls (combobox) I am using but what I want is rather than hitting the database each time can I just cache the collection and get the collection from the cache? The look-up table may or may not change all the time so I would want to have a way to validate if the cached collection is still valid or not.
View 2 RepliesIve created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
Im taking over a project that pulls information from a database.Currently I have everything I need except the username.The person who setup the project did it as a web project so he used the MemberShip class to create unique user keys based on the person's username.
The username is not stored anywhere in the database only these userID keys.
The client wants a desktop app that mimics the website behavior of writing to the database.
Problem:I ask the user to enter in a username at the login. The username connects to the database on the server.I have no way of grabbing any user info after this point as the primary key(USERID) is a unique key and not a username. Is there a way to convert a MemberShip ProviderUserkey into a string Username or am I screwed?
I used this coding for a reading column name from access database. But i want how to read every field values of that particular column?
dim dr as oledbdatareader
dr.item(1).tostring
Using VB.Net (Windows Application)In the form (called as FirstForm), i am using textbox, add-form Button, search button.When i click the add-form button, it will give the new form (same as FirstForm)Code for adding new form
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
Dim SecondForm As New FirstForm
SecondForm.Show()
End Sub
Search Button Code
Private Sub Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Search.Click
If FirstForm.Focus = True Then
FirstForm.textbox1.Text = gridview1.Rows(crRow).Cells("code").Value.ToString().Trim()
[code]....
The above code is working, but If i am in second Form when i click the search button and selected the value, then the value is appearing in the FirstForm textbox, it is not appearing in the SecondForm textbox.If SecondForm is showing, the selected Value should appear in the SecondForm textbox not in the FirstForm Textbox.
I am working on Visual Studio 2005, VB.At the back end,there is a table called "Marks" which has a column called "Subject". This column contains duplicate values.when the form loads,I want to display all the distinct values from the "Subject" column in the listbox.
View 2 RepliesMy code below will save records to my database as long as all the parameter have values. One of the parameter is @MI (middle initial), however, there are times that student have no middle initial so when I click my button I get error. I want to still save the record even if one of the parameter value is missing.
[code]...
am trying to populate an array like so:
Dim tmpArray As String = ""
Do Until x = Form1.arrayCal.Length
tmpArray = tmpArray & "," & x
[code].....
I am populating excel from a data grid view. Everything works fine except that header does not show in excel (just details).
Dim wapp As Microsoft.Office.Interop.Excel.Application
Dim wsheet As Microsoft.Office.Interop.Excel.Worksheet
Dim wbook As Microsoft.Office.Interop.Excel.Workbook
wapp = New Microsoft.Office.Interop.Excel.Application
wapp.Visible = True
[Code] .....
I made a quick search but couldn't find any help I need to put the values of a checklist box into an array. I've found several solutions on the internet but all of these don't seem to work for integer arrays. This is what I've got so far
" Dim RemoveValues(checklistRemoveBrew.CheckedItems.Count - 1) As Integer
Dim C As Integer
For C = 0 To checklistRemoveBrew.CheckedItems.Count - 1
RemoveValues(C) = checklistRemoveBrew.CheckedItems(C)
Next "
Does anyone know if there is a way of populating a treeview from active directory so that it can do the following:Loads a list of servers --> Double Click the Server(Expand) --> Then i can select users --> then the department they are in --> then select the user so i can manage the user. i.e change there password[code]
View 1 Repliesthis is how I set up my data object for a file parser. (
Dim mytable As New List(Of String(,))()
mytable.Add(New String(4, 16) {})
and it loads mytable like this:
mytable(x)(y, i) = sToken(i)
Let me explain the indices, I have a form with a tab control. In mytable,x is the tab number. Each tab has up to 5 groups which is y. Each group has 17 text boxes, i.Each group also has 17 labels.I started looking at Me.controls, and looking at control properties like tabindex for some way to iterate through the textboxes and mytable to load the textboxes.
so I started with:
for x = 0 to 31
msgbox(group1.control(x).text
next x
and I saw how all my objects are not in sequence as it descending halfway through my label controls, then switched to my textboxes, and then seemingly finished randomly. I am at a total loss without the old index property and what I want to do is something like (forgive my syntax)
Form(0).Tab(x).group(y).textbox(i).text = mytable(x)(y, i)
I was thinking of manually setting the tabindex of all textboxes in group1 to sequential order to try something like:
group1.component.tabindex(i).text = mytable(x)(y, i)
To me this is fun and challenging, but also very frustrating and makes me miss coding in assembly As I can't seem to find any reference to the tree structure of accessing components indirectly, if that makes sense.
I am getting an overflow somewhere while populating my database.The number of records inserted is different every time I get the error and I have been unable to trace where it is coming from.
View 7 RepliesSo i have some data in an 1 dimensional array, is it possible to dump this data into a database?
View 4 RepliesI am trying to populate listview with the code below:
Public constr As String = "Data Source=adesina-pc;Initial Catalog=AdventureWorks;Integrated Security=True"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code]....
how to populate my listview using database.
View 2 RepliesI am populating a datagridview with information from a database. One of the columns is a monetary amount. Right now my datagridview columns just show a double.
View 2 RepliesI am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
I want to create a 2 dimensional array and populate it with data from database. I wrote this following code.I made some mistakes here with the arrays.
[Code]...
I have a database that has tables in it. Tables can be added to this databse programatically as well as the data that needs to be in those tables.I need to be able to query that database to get what tables are in it, place the names of those tables into a listbox so that when a user clicks on the name of the table, It will update a DataGridview with the data that is in that table in the database.I assume that you would need to build a dataset at runtime based off of what tables are in the DB, but i have no idea how to do this.
View 2 RepliesI have a few drop down lists that I'd like to populate from a table in an SQL database. I tried setting it in the DataBindings section of Properties but I guess that doesn't work.
View 11 Repliesif this question has already been answered many times, but I am new to VB and I don't really understand any of the examples I have found by trying to research this topic. I am using VB 2008 Express Edition. My List View is called listView.
View 4 RepliesI have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
I am populating a combobox with a list of names that are coming from a database. I would like to get the names to show up in the combo box in alphabetical order. [code] There is also another combobox I'm populating with text from a database. (as below). However, in the database, in the column I'm reading data from, there are a few duplicate rows and then when the combobox is populated, the same text can be seen 2/3 times. What can I do or add to my existing code, that will ensure that there is no duplication shown in the combo box? [code]
View 3 RepliesI dont know how to dynamically populate a dataset based off the tables in an existing database.Once I can get the dataset to populate, I can then move forward with the next step of the project.
View 1 RepliesThe vb.net code for populating tree view from the SQL Server Database is given in following link: [URL]I tried the code given in the above link to solve my problem but I was unable to change the code of SQL Sever for Postgres Database. I want to do the same thing using vb.net and database Postgres.
View 1 RepliesI have a field in an access database with decimals in it. I am using ADO to read in the data and are trying to assign it to a textbox in a form. This works fine when its a whole number. But it doesnt seem to work when its a decimal for some reason.
I have declared the variable i have assigned the access field to as a double, but when i set up a test textbox which i point the variable at and times it by 1000, it doesnt work. Works perfectly when i change the access field entry to a whole number though.
This sounds like im not using the right syntax or something.
i have imported names from database table into combobox..i want to add item"all" above all names..how can i just add one single item in combobox after populating it form database tabel.
View 1 Replies