I have the following code on a form named: frmRegister.The aim of this form is to add a new user to a database. However, currently the code exectures with no errors and the success MsgBox is displayed, but the user is not added to the database.I can't seem to pin point the error.[code]
View 1 RepliesI have a list view with 2 columns (Prodduct and Price). I want the user to be able to add there own values to the listview and have them save so that they will always stay there.I would also like users to be able to delete specific items from the saved list.
The values added to the colums are paired, and must stay together, as one value would be a product and the other a price, So they must, stay together. as a pair
I've a question about vb.net application with ms access 2002 database.I use "Add data source" wizard to setup a connection to a access database.my application read text file into a temp data table at runtime.a button click to import data from temp table into one of access table.problem is data is not added at all.here is the code I use to do update
For Each dr In dt.Rows
DataSet1.tbl2.ImportRow(dr)
Next
DataSet1.AcceptChanges()
TableAdapterManager1.UpdateAll(DataSet1)
i recently added a login that uses mysql database now it use to pull data from text file but as i said i made it use mysql now..it works great locally but when i sent it to a friend to test the login he got this error. unhandled exception has occurred in the your application. if you click continue, the application will ignore this error and attempt to conttinue. if the click quit, the application will close immediately could not load file and assembly 'MySql.Data. version=5.1.7.0 Culture=neutral, public key token=c5687fc88969c44d' or one of its dependencies. this system cannot find the file specified.not sure what to do i was thinking about having him install the MySQL Connector net but i thought i would come here first and ask..and can someone also help me on how can i retreive data from the login part? i can get it to keep the username but for some reason i can pull the rest of the data here is the login script.[code]
View 11 RepliesI am building a program that does inventory control. I have multiple forms connected to same database. One of the forms I have a search function. When I was using the controls at the top of the page, it was working. I added buttons for the controls and now the database wont store anything. I can open the input form and I can add multiple inputs, close the form, open it back up, and nothing left in the database. I have also noticed that my database icon in the data source has a small red X in it. When I click on the icon, it is showing the db as closed. I can refresh it and it opens, until I run the program and it closes.
View 4 RepliesI am trying to create a custom control using vb.net.I have added a image to the user control and the problem I am having is that when I resize the image, the image seems to move as well.I want to be able to resize the user control height without moving the image on the user control.
everytime I resize the user control, it seems to move the image on it as well.Is there a way of leaving the image where it is without moving it as the user control moves?
I've searched until my eyes and fingers feel as if they are going to bleed. I cannot come up with the answers I'm looking for. I want to essentially create an inventory system without using a database (part of why the eyes are bleeding, keep getting directed on side tangents), that is fed by the user. IE, User enters a name of a product, it is added in to an array. As a designer I will not know the exact number of elements to be held within the array. The user will enter their chosen item in to a text box. So I'm looking for a way to take the value in the text box and add it to the array. I believe I would use the reDIM function to do this, but beyond that I've got nothing. I'm unsure of how to reference the value stored in a text box.
View 7 Replieshow would I go about creating a payment schedule based on a date and a number of months 3 or 6 or 12 to then populate the database with reoccurring dates so lets say new user added on 31/10/2011 for 6 months I need the database to add all the dates for the six months
[Code]...
I have created a datagrid of my own in vb dotnet and converted to dll. I add this dll to a project.i have 2 forms and i have added this control on 2 forms. When i run the project and open 2 forms simentaneously an error " reference not set to an instance of an object" occurs on acess of any property of that control.
View 3 RepliesI am currently wokring on a project, which is going to serve as an interface for accessing various documentation and reports. It is basically just a tabcontrol with a few pages that will be poppulated with buttons which will open the appropriate document.I am trying to allow administrative users the ability to add new, edit or remove buttons which all seems relatiively simple, but have run into the problem of how to persist the changes once they are made. I want the setting to be stored centrally, either in a SQL table or on a network share
View 1 RepliesI am trying to add icons to a listview that would contain a list of programs added by the user. I am pulling my hair out over this. I had the solution a few days ago and then I decided to go in another direction and then cleared my browser history. I have searched for that code for awhile now to no avail. First person gets a cookie.
Warning: cookies may contain nuclear waste.
I have created a User Control in VB 2005 that adds other controls dynamically. This is a fairly simple test project, with checkboxes added to the control at run-time. Here's the user control:
Public
Class UserControl1
Public x
[Code]......
Then I built the test control and tried to added it to the Toolbox. When I did this--i.e., browsed to the dll and double-clicked it, I got the errror message:
"There are no components in ... that can be placed in the toolbox."
Is it even possible to add a User Control to the Toolbox without compile-time components?
I have a form, with lables and textboxes added at runtime. The labels and textboxes are added properly on form load and display as expected. The form allows tabing into each of the textboxes, but the textbox does not allow user input.
Is this a problem with the way I show the form to the user? >> this particular form is called (frmname.show) from a different form -- If I test this form directly, without being called from a different form, it allows user input in the textboxes. Is it because of the properties I used to create the textbox? >> properties used were - .name, .size, .location, .tag
I've added an attribute for a user readable display name to my Enum values.However my code to convert from the user readable display name back to the Enum (function ToEnum) seems very convoluted.I am wondering if I am missing a better way of doing this (I am using Visual Studio 2010 with SP1.) [code]
View 10 RepliesI am trying to make a small control that has a picturebox and a few labels that can be dragged on the form it is placed on. The control was easy, and I can drag it fine when the mouse is down on the control, where there are no other controls, like not over the picturebox or labels.
When i try to click and drag the user-control and the mouse is on the picture box or labels of the control the mouse down event is not detected. I am hoping someone can tell me how to pass the mouse-down event from the controls on the user-control so the form I place it on detects the mouse down even no matter where on the control i click.
My app has text boxes to accept input from user to questions shown on labels. When the user input is valid, a literal is added to a string incorporating the user input. If the user doesn't input anything or if user inputs "no" or "None" I want the literal and the user input to not add to my string. Make any sense? See my code below:
[Code]...
what is wrong with my code? Data could not be added into database.
[Code]...
I new to vb.net. I used following code to add new row in my "customer" table. Following code does not give me any error. Still data is not added to database.
[Code]...
if could modify the following code for me so that it save data row by row from a DataGridView into SQl Server. Currently, the code saves data from all rows at time instead of saving only the recently added data in a row or rows when the user clicks a button.[code]...
View 1 RepliesMy aim is to try to add a new user to a access database. Im doing this using from a form named frmRegister. It seems like the code is working perfectly, and I get no expectations that indicate if any errors occurred. However, the user doesn't get added to the database.
The code I'm using is:
Public Class Register
Dim connectionString As String
Dim connection As OleDbConnection
Dim OLEDBAdapter As New OleDbDataAdapter
Dim OLE As String
[Code] .....
(Files too large for attaching here)
Rar format - [URL]
Zip format - [URL]
I have decided to quit using Access and trying my hand a VB.I am wanting to create a database with Forms for entering Address's.
View 1 Replieswith odbc connection in vb.net example i have add button on my database and i want that what ive added will be added on the database with odbc connection.i know how in oledb but im really confuse with odbc
View 2 RepliesThis code is driving me nuts. I have no idea what I could be missing that is preventing a record from being added to the Database. Here is what I have
[Code]...
Once I add a value into the value is added at the beginning of the database instead of the end. How do I make sure the new entered date is added at the end (last row) of the database?I load the table into a datagridview
Dim cmd As New MySqlCommand("SELECT * FROM mydatabasetable", conn)
Dim da As MySqlDataAdapter = New MySqlDataAdapter
Dim dt As DataTable = New DataTable
[code]....
Why is my bulk copy duplicating each row, so in my database table the row shows twice.
Label1.Visible = True
Dim tourid As New List(Of String)
tourid.Add(TextBox1.Text)
[Code]......
I have a form where i can enter new product. In that same form i have listbox where i show the current product from the database.
I want to know how to update that listbox as i enter new product into the database so that user can see the current content of the product table.
my code to load the listbox
Try
Dim ds As New DataSet
Dim cmd As New OleDbCommand
[Code].....
To sum it up, what i want is something that will refresh the current display of the listbox so user can see the actual and updated contents of the database.
with the above code, the newly entered product/data can only be seen when the program is closed and reopened again. Which is not very convenient.
I have two tables: HolidayRequests & HolidayEntitlementWithin the Holiday Requests I have 1 field:DaysWhen a staff member adds a holiday request it is stored as a number in the holiday requests table in days field (there are multiple requests with different days)
View 2 RepliesDisplay a Dialog Box that asks for some user input. Take that input and add a new entry to an access datatable. Refresh a List Box that displays the Keys from the datatable. Steps 1 and 2 work just fine. After the following method is executed (without closing the program) I can open the Access Database and the data has been stored to the datatable.[code]...
View 3 Replieswhen i add the record it saves and returns the save message box as it should and is viewable in the database where it saves to, but it is not viewable in the text boxes when looking back at the form until i close program and re open it, then i can see the record stored in the database, it just wont update the form,[code]
View 2 RepliesDear Friends I have Developed a Successful Database Software, it include Datagrid, First, Last, Next, Previous, Add, Delete, Edit, Update, Search just Every Thing is Working Nice, But I need help from one of expert from you. my problem is that every time when i Start program its all functions are workin including edit and delete. (mean data (rows) Added at previous run is able to be Delted at current time) but when i add new record at current run time it adds succesfully, but while at same run time session (current) i tries to Delete or edit new added roecord it is not working, in simple words new added records are not able to delete and edit at same run session. i m including project's zip file and plz try to run it and add new record, after adding record at same time try to edit or Delete new added record.
View 3 Replies