I am creating a hotel room booking form. In my mainform I have several controls that i can use to select/fill eg room number, date, name of visitor, number of days booking etc.I also have table adapter that binds the data source I have a save button in my form and I need to create an event so that it saves the data that I have entered in the mainform to the underlying dataset- i have to use endEdit(), DataRowView methods/properties but can't manage to write the save button event.
I'm trying to code a button which has a SELECT statement to get information from one table but I want the information displayed in a data grid view.From the data grid view, this data will be stored in a different table within the same database.Previously i had used a list box to display the information but i could not save it in the data base.[code]Is there any way you can display this on a data grid view like i did on the listbox?Im using a datagrid view textboxcolumn column.
how to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
in my form i have 4 textboxes and i want all not to be empty while saving the data.I have put condition in save button,when user presses the save button to save data, to check all the textboxes not to be empty. My question is that, i want to focus to that particular textbox which is empty during saving the data.
For example: i have txt1,txt2,txt3,txt4 as textboxes in the form if txt1 is empty while saving, the focus should switch to txt1 rather user himself have to go there.
how can i avoid data duplicate in the database?i mean if i add in the fields that has been already save it will still save.i don't know how to query or filter not to add the same info.i have the code below but it still save if i input same as already in the database.[code]i want is to query first before it add the data to avoid same info.
In the example from my book, I'm coding a button click event, and adding the code..."me.width=me.width + 20"The author states that "me refers to the object to which the code belongs(in this case the form)".
But this isn't exactly accurate, is it? The "code belongs" to the button object -- not the form object, right? So, I'm guessing that what the author really should have said is that "me refers to what ever form you're working on". Would that be true?
Im looking to add some information to a table in VB.net.The table needs 2 columns and a number of rows;1 Column needs to have numbers ranging from 1 onwards, basically representing their row number. And 1 more column which just displays any text when a button is pressed.
Each time the button is presed i need the text to go onto a new row.Ive heard alot about a DataGrid, but everything relating to this seems to be based with SQL and I was wondering if there is a differnet tool which would be simpler to use?
I am wanting to make it so when you push a button, it will save the code in the RichTextBox as a Batch file.I want it to bring up the menu like it does when you hit save as.Here is what i have so far:
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click With SaveFileDialog1 .Title = "Save File" .Filter = "Batch Files | *.bat"
Currently for the drag and drop button at run time, i am saving the button's coordinates and button text to the text file named button.text.[code]so now i'm actually trying to change the above method to saving the location and the button text in the database instead of the text file but i'm getting the error saying that there is object reference error.I think the database cant save the button x and y coordinates in.how to do using the database method?I am using this method to save the button coordinates and text in. The method is somewhat like the insert dsnewrow. [code]
I have used this form to add new records on my database(ms access) in my database I have a column name 'ID' which is my primary key 'ID' is set as auto number. Now I am having a trouble on creating my update and delete button it's always saying "cannot be delete/update"
Here's my code on add, update and delete Public Sub SaveRecord() Try Dim dbConn As OleDbConnection Dim dbInsert As New OleDbCommand Dim str1, str2, str3, str4, str5, str6, str7, str8, str9 As String [Code] .....
Note my add is working perfectly fine. I just can find the error on my delete and update. Also I have used this to view it to my datagrid I don't know if its the right thing but it's working fine too. 'declared dbpath globally' Dim dbPath As String = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=../VG.mdb;Persist Security Info=False" [Code] .....
Another thing is how to code each textbox and combobox to bind it to my records so that when I click on the datagridview each column will be distributed on each respective textbox.
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
I have three tables under one database. I'm using the built-in Navigator control for now until I get this figured out, but I'm using a button command instead of the built in navigator button. I need the "Save" button to save the data in the text fill boxes to save to the corisponding table. I used the drag and drop option to drop rows from each table to the form. See code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
I'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
I used the following code to save what the user editing , the code don't give me any error code , but in the same time it don't do any thing , the data still without any new changes: [code] I wrote the whole code , so what is the wrong exactly ?There is some columns that may have many same data in its cells .
make a program in VB.net Ultimate 2010 that will take screenshot of the current desktop and save it to MS Access Database 2000 in a single click of button.
The challenge is the form. Form must be hide first before taking the screenshot so it will capture only the current desktop. After that, it will automatically saved to the MS Access database 2000. I hope someone can help me out of this stuff.
I have a project I created for my VB class where you enter what type of ticket(combobox), how many tickets(textbox), what type of tickets(listbox) and will give you the total amount.I want to do a little more to the program and was wondering about adding the person's name, address, phone, city, state, zip and then having all the information put into a database. I wanted to also take the information entered from the program and use the printPreview control to view a report from Access(possible?).
I've only worked with viewing database information on the forms in VB but I've never entered data into the database. Is this possible?Can I have the information entered on the form be entered into a database that keeps track of all tickets purchased and customer information?I can see this working in my head but don't know if it's logistically possible.
i have two radio buttons for selecting "Local/Non Local" status of students.so if YES radio button is clicked-- "Local" should be saved in SQL DB Table column with/without using an SP(Stored Procedure) Else if NO radio button is selected then "Non Local" should be saved.Using Stored Procedure & without using SP send the code.
I have a combo box that I want to refresh the data of after the save button is clicked. I know that in web developer you can just say datasource.databind but I do not see that in vb.net.
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
Im currently doing a small programme of a register system. I need to add a new group box filed with a few textboxes and a couple comboboxes for each entry in a access 2010 database. for example if i had someone called bob in my database with his details i would like the GUI of the VB app to add in a new textbox for the name, a textbox for the address ect in a set order, this needs to work for multiple entry's so the textboxes ect don't overlap but be placed neatly below the added textbox.
