Request With Database And Visual Basic?
Oct 6, 2009
i'm trying to use a database with Visual Basic Express Edition but I seem to be stuck with:-* Adding* Editing* Removinga record. Could anyone advise me please, or write a piece of basic code so I can achive the above?Thank You.Also (Out of interest)Can anyone explain, when I've added a entry into my Access database through my visual basic form, I have created.I can see the record, if I load the database in Microsoft Access.When I load my small project back in to Visual Basic Express Edition and run it, the database is blank?
View 5 Replies
ADVERTISEMENT
Dec 14, 2011
I am very confused about the database type to be used in my vb.net application. I have been using SSCE database, but for that user has to download and install SSCE, which many of my users do not want. If I use Access, the security issue is very very serious.I have downloaded a few database apps from the internet, which donot require any such thing to be installed and also I see no known database format in the application folder. I wonder what kind of techniques they are using.
View 12 Replies
Sep 22, 2010
I saw Beth videos, and I wanted o creat a database with Visual Basic...
I downloaded Visual Basic 2010 Express, but I saw there is no option to connect to server...
and in the Databse Explorer, there is only Data Connections and no "Servers"...
View 2 Replies
Jan 4, 2010
How to use mysql in visual basic as database?
View 2 Replies
Aug 22, 2010
I need your suggestions and comments because I'm having problems in which database I will be using MySQL or Microsoft SQL Server.
Which database is easier to use? In terms of connecting the database to Visual Basic 2008
View 2 Replies
Oct 17, 2009
I was wondering how you can add text from a text box to a database (table in visual basic). I've been looking all over the web, and i haven't found anything.
View 1 Replies
Sep 23, 2009
I'm a college student and starting to use Visua Basic 2008.Unfortunately couldn't find the right algo for adding a database in vb 08. T_TMy problem is that how to add a database access 2007 in visual basic 2008.
View 3 Replies
Mar 14, 2009
My Form 1 has a drop down list for user to select username, followed by a textbox to enter password. If correct password is entered, Form 2 will show.
Form 2 start from cbxCategory for category, then another cbxItem for item. Then a button to click �Borrow� Then it should insert.
This is my form 2_load codes:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Form1.Hide()
[Code]....
I keep getting an error when I try to insert the record. What's wrong with my code?
View 4 Replies
Jun 30, 2009
I have a form that contains a Textbox + Three sets of radiobuttons.
my project idea is to store in any database the values selected or entered by the user.
Textbox goes Name.
First set of radiobuttons are the job position - manager - superviser etc....
Second set "" "" the Period (Shift)- day - nite
Third set "" "" The Condition - part-time - full-time
Anyway, my problem is how to insert those values into a database, something very simple such as MSAccess (is possible?)
View 5 Replies
Mar 1, 2012
My problem is fairly simple. What my code is doing to start with is opening the form by loading a bunch of things from a database. After all the questions are done (because it is a questionnaire) it is meant to save the current score and the username that was entered before, for the sake of programming I have hard-coded a username and score however I think because I am using a different command builder it keeps giving me the same error!
(I am studying A-Level so that might explain the simplicity of the code)
Public Class AdditionTest
Dim inc As Integer = 0
Dim con As New OleDb.OleDbConnection
[Code]....
View 3 Replies
Apr 14, 2009
I make a program-application in visual basic and it work OK. When I pack my application in setup project and make the installation, the database(in program) it did not save a new data or any update. Where is a mistake ?
View 3 Replies
Sep 12, 2010
I want to make a POS System but my problem is can I compile the database so that when I create an installer for the system and install it in other PCs, they won't require MS SQL Server(just the .NET framework) to be installed. Is that possible?.. or I have Install MS SQL Server for every PC?
View 4 Replies
Jan 24, 2011
How do you extract source code from a VB.NET .EXE file?
View 3 Replies
Aug 13, 2011
When ever I try to add Service-based Database in Visual Basic 2010 Express Edition it just prompts me a message.
And if it means anything this error started showing right after I installed
Visual Studio 201 Professional test.
View 5 Replies
Oct 6, 2009
I used the following code to print out my database. but it is print out empty page, I would like to be able to print database from visual basic.I know how to go about it? the following code is print empty page. Private Sub PrintDocument1_PrintPage(ByVal sender As System.Object, ByVal e As
[Code]...
View 1 Replies
Aug 9, 2010
I was wondering how to get a certain data from a MS database and display in a label. Example(Database entries)
[Code]....
The name will be displayed in the label depending on the year and number typed in two text boxes. So if typed 2009 and 1001, the label should display name2. I don't have any background on SQL. The only thing I did for now is that I added the database in the data sources and added a TableAdapter.
View 2 Replies
Jan 24, 2011
I do apologise if this has been answered 9000 times already. I have looked over forums and google for days now. I want to connect to an sql database (created locally in the windows form project) i want to then interact with this db (add, update, select) however i am struggling with the connection string (server:? localhost?) the update functions (tableadapter.update(dataset)?) adding new information (newrow etc).
[Code]...
View 8 Replies
Aug 5, 2011
I am making a local database in visual studio 2010, i need to have one column that auto enters time and date when a new entry is made. How would i do this?
View 5 Replies
Mar 9, 2012
I am making a invoice system in Visual Basic 2010 and i am stuck here Here is my code
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
For Each row As DataGridViewRow In datagrid.SelectedRows
Dim selectedindex As String = datagrid.CurrentRow.Cells(0).Value.ToString()
datagrid.Rows.Remove(row)
[Code]...
This code is not working well please have a look to my invoice screen shot and suggest me a better code
When i try to delete the selected row the code does not work and if any one can tell me i can delete multiple selected rows? they are deleted from the datagrid but not from database
View 1 Replies
Feb 22, 2012
I am trying to Save my data into Local Database (*.SDF or *.MDF) but i due to some reasons i can not do it. I have seen 100s of Video on it and tried all possiable ways, but still my data is not saving into Local Database. and i do not get any error messages. However i can save my data into SQLEXPRESS database. i am using Visual Stodio 2008.
View 2 Replies
Feb 4, 2011
Write code or use tableadaptors, bindingsources, dataset, etc.? I have experience with the older ways i.e. connection strings, ado code, sql, etc. but was hoping the newer tools in vs would make the user interface easier and more flexible. So far i have been disappointed. Am I wrong and I am missing something? Am I alone in this opinion or ? What is your past experience in VB and have you found vb.net to be a step forward in db user interface design? if your answer is yes then what is the easiest way to put a table record count into a text box? should i bypass all the new stuff/objects ( adaptors, binding sources, navigators, designers, etc) and just write code or what?
View 3 Replies
May 6, 2010
I would like to be able to read a column of numbers from an Access database into a VB.NET program and then manipulate that data.For example I have a column of numbers and want to add them up and then take the averageThe maths is not a problem but how do I read the column of data into the program. I know how to do this if I first export the Access data into a CSV file, but
View 11 Replies
Apr 15, 2010
I have a database called "IMYS" and a "Customers" table in it. What I want to do is: Define a variable like "Last_Name" and retrieve last names of customers one by one. I've tried this before (and, it doesn't work for me):
===
Dim Last_Name as String
Dim I, K as Integer
Dim CustomersTable = New IMYSDataSetTableAdapters.CustomersTableAdapter
[Code]....
View 2 Replies
May 24, 2011
Visual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 Replies
Aug 15, 2011
i am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 Replies
Feb 14, 2011
I am trying to delete rows of an .sdf file using the Database Explorer utility of Visual Basic. When doing so, I get the following error message:No rows were deleted.
A problem occurred attempting to delete row 1.
Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(48 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). It is correct that the data in the rows are not unique (and not supposed to be; there is no "error" to correct), but why should this prevent deleting them?
View 4 Replies
Feb 19, 2009
I have th is little programm:
Dim dbOud As ADODB.Connection
Dim rsOud As ADODB.Recordset
Dim strCnnOud As String
[code]....
View 1 Replies
Feb 27, 2012
I have used ADOX for create some fields in my database in access but the required property of this appended fields (columns) are set in "yes" but I want to be them "No" who knows how can I solve this problem
View 3 Replies
Jun 13, 2010
I am a student and trying to start a programming career, my colleague asked me to make a multi tier or multi client desktop application for the schedule tracking using xml as a database; however the desktop application would be deployed in one or more computers but my leader can monitor the info from her office in addition she wanted me to put administrative privilege to avoid unauthorized access in some database features of the system. an info regarding multi-client desktop app.
View 3 Replies
Mar 7, 2010
i seem to have a problem when i try to update a certain record in an Access 2007 Database. I have a small Access 2007 database with 1 table which has 3 Columns and several records. The 3 columns are RecordNumber (Primary Key and it is autonumber), FirstName(text) and LastName(text). What i am trying to do in VB 2008 is implement a search form which when you find a record you can update it. I do not have any problems with the search, but i cannot seem to edit any other record than the first one. For example i search for John which exists, if that record is the 3rd record when i try to edit it whatever changes i make (for example change that to James), the changes i make are made to the first record and not the current one. I tried a lot of things but nothing works, here is my code:
[code]...
View 3 Replies