I am a total beginner to Visual Basic and have a project to conduct a survey for my company. The Answers of the users need to be populated to the database. So far, all I've managed to do is to define a string which will have the answer to be updated into the access table. How am I supposed to pass the value?
View 2 Replies
Trying to make a vb.net program that is able to read values from an access database and pass them into some data sets. Here is the code I have so far, with the error line between the two dotted lines:
[Code]...
i am working in windows appl vb.net 08. And i am working in Access DataBase.I have one Table Called "Person" . In this "Person" Table one Column Name Called "OtherName". In this Column binded in one of the Combobox in a Form.But the Problem is "OtherName" Column having the Null Values.Before i bind this Column to Combobox i want to convert this NULL Values to String. Why i need the values in STRING means , In my code i using this Combobox as a filter in SQL Query.If i didn`t change the Null Value to STRING , The Combobox SelectedText or SelectedValue is Showing Nothing. So i am not able to get the Record.
Whn i write a Sql Query to Combobox and apply filter in WHERE statement like Combobox.Selectedtext or Combobox.SelectedValue In "Selected Change Committed Event" then i should get the record in the Output right but unfortunatly i am not getting the Record. The Record Count in DebugPrint showing 0.
[Code]...
I have a simple query but I am just not able to get it right. Have a look at my sample code below:
Sub Function1
My Code Here
Function2(Year,Month)
End Sub
Sub Function2(Year,Month)
Dim Str as String()
for 1 to 30
Dim MyDate As New Date(Year, Month, i)
Str = MyDate.DayOfWeek.ToString()
Next
Return Str
End Sub
how to use a String Array for passing Values
View 3 RepliesI have an input box that allows users to enter a date that when the user clicks "Ok" that it does two things, marks a field called "code" in my Exceptions SQL table as H and passes whatever date they have entered to that table as well.
View 1 RepliesHow can I instantiate an anonymous object while passing the propertynames and values as string?
new With { .SomeProperty = "Value" }
new With { ".SomeProperty" = "Value" }
I am trying to get input from user then convert it into specific format and hold it in new variable. here is my code
[Code]...
working on user input box , get any value as string and format it as 0000xx here is my code, but value not passing.
Dim dtmInputBox As String = ""
Dim strDTM As String
Do Until Not dtmInputBox = Nothing
[code]....
my input is like 20 and i want to get as 000020
I am using following code and trying to get data by given parameters. I donot know how to pass the parameter value to my query.
[Code]...
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I created a dataset and i am using OleDbDataAdapter to insert new values to access database. But when i close the program and after open it, values are not in the database. How can i solve this problem? Also, i have another problem. When i write codes that
[Code]...
how do i get the values from my database in access in vb i have a table named Rates that has column PerMinute and column Amount
i want to access the data in the amount column. and make it appear on the AmountToPay.text
I got an app, which receives data via a R232 port, convert it to a string and on the other side I got a database, where the strings are saved. How can I find a way to compare the string with all strings in one database column and get back the another stringform the same row in this database. I never programmed a database
View 1 RepliesSo I already have a smartphone application, and I already connected it to my database. How do I get data from that database to be loaded into the form? For example, I got a table 'Shops' with a column 'ShopType'. I want to put all shop types in a comboBox when a soft key is clicked.
View 1 RepliesI am making a database project in vb.net. I have one table which has 9 columns. I am using ms access database as server side. my question is that, how to insert rows with values in a table.
View 1 RepliesThe following is the code i used to get the value from textbox to listbox and store all the listbox values to the access database at the runtime.In the database, i have only one field called num which is been set as a multivalue field using the lookupwizard. But actually what happens is ,no error is occurred,but the value is not updated in the batabase.
vb.net
Imports System.Data.OleDb
Public Class Form1
Dim conn As OleDbConnection[code]...
I am making a application that has the ability to edit values on a access database table. As a simple example, My table looks something like this:
Order Number Completed
2000 No
2001 No
2002 No
The application needs to edit the Completed columns. I have 1 text box, and 1 button in my form. You enter the Oder Number in the textbox and press the button. The VB application then needs to change the Completed to Yes in the database. Example, I type in 2002 in the textbox and press a button. The application changes Completed to Yes for this order number in the access database and saves/updates the database.
I have a table called tblComparison - this table has the following columns[code]...
Once the averages for each column are created it needs to save them to tblMonthlyComparison - again the column names in this table are the same so in the fldDate column the program needs to enter 31/12/2011. In fldAverage of this table what we do is take the average that we found above for each column then plus them together and divide them by 5.
I want to create a Web Service that will insert values into a access database. Probably be something like this but dont no the code enough to complete:
[WebMethod]
public void CreateUser(string name, string password) {
msConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R: C:events.mdb"
****Insert code e.g. INSERT INTO eventstbl(User, pass) Values(name, password)***}
How update the Access database in VB.Net with NULL values using OLE DB command
View 2 RepliesI have a tblVersion that contains the versions of my application:
VersionID Version
VersionID is a bigint primary key, version is a ntext column that holds the current version... I want to be able to pick the row that has the highest version number, but version could be in this format:
MyApplication 1.0.1
If I try to convert that to a int32 it will throw an exception obviously. I would like to know if some of you have a idea how to solve this issue. I could of course make sure the column will only contain numeric values but this gives a little more flexibility.
I am trying to insert some values into my database using the sql string below:
"INSERT INTO Users" & "(Username, Password)VALUES " & "('" & Accounts.TextBox1.Text & "'," & "'" & Accounts.TextBox2.Text & "')" The error message reads: "Syntax error in INSERT INTO statement."
Access database: Inventory
Column 1: Pprice
Column 2: Date
Now what I want to do is on a button click, I want to search the database for a date range, lets say September/01/2010 thru September/30/2010. Then I want to pull all of the Pprice values and add them together to come up with an inventory parts cost for the month.
I followed the suggestion from [URL].. this thread. however i face a bit of a problem in my case i have a combobox at row(i).cells(0) the code seems to take the last new rows where there's not record and shows error the debug error msg is A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll INSERT into taken(typeID,quantity) VALUES (5,39)INSERT into taken(typeID,quantity) VALUES (,)
[Code]...
im a newbie in vb.net and i am using vb.net 2008 express edition,,i am creating a project which is importing csv data in my database,
View 5 RepliesI've now properly started implementing OO into my system (which I probably should have done from the start) but I just want to clear some best practices.So let's say I have a class called Job which contains information such as Description, Project Manager (Employee class), Value etc. at the moment, if I initialise the Job class it will initialise all the information held within it, even if I only want the job description. Is it best practice to do this or is it better to implement the class and access the database for values as and when they're needed? Or is it just better in those cases to just access the database directly?
View 1 RepliesHow it's possible to get values (string) from the database when a user connects? i use in this
[Code]...
If i have two textboxes textbox1 & textbox2 and button1 in my ASP.NET and SQL Server database
Database records are:
ID Date Seats
1 15-Dec-2010 1,2
[code].....
I've been handed an Access database with 3 columns: Name, category, e-mail. What I'm trying to do is get out, as strings, all of the e-mails that match a given category. I have a slight understanding SQL as I'm in the process of learning it. I've managed to churn out this bit of code, which populates a visual grid with the first names
Dim comm As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=.AddressBook.mdb")
Dim addda As New OleDbDataAdapter("SELECT FirstName FROM Contacts", comm)
[code].....
