i have datagrid on my interface with few columns eg. student name, address and age. on top of that there is a text box to include the group name. i want to save all the grid data into table called "groups" in access database. as an instance under group 1 all the students names and their details.
View 1 RepliesI have this code and whenever i try to run it, I always get an ODBCEXCEPTION WAS UNHANDLED ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char VALUES('101','noodles')' at line 1
[Code]...
I use This Code To Save Data in Table First I delete record Then Insert record
View 4 RepliesHow do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 RepliesThis code i had use for create a field in DB Access 2003:
SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)"
Dim command1 As New OleDb.OleDbCommand(SQL, con1)
con1.Open()
command1.ExecuteNonQuery()
con1.Close()
like you see the code create a Text field with 40 lenght...Well the problem is:When i save a new record the record it's save in this mode: "100......... .........................." - the points means spaces and should be:"100"After try a lot of things i'm without more solutions in find why this happen!
I am trying to add a new record everytime i do my navigation gets all messed up I also need an update button... I would like so when i hit new record the record of will be(ex. If Im adding record number 30 it will say record 30 of 30, hit add new it will say record 31 of 31) my code is below.
'Class File
Module Class1
Public MasterConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db1.mdb;Persist Security Info=False;")
[code].....
I am building an application in vb 2010 that uses wmp ocx to play videos from remote streaming servers. Is there a way to record or save that video simultaniously? Which technique should I use? I have searched a lot on this but unable to find solution yet. Do i need to use Directshow library?
View 1 RepliesThis is the only line for saving a NEW record.
[code]...
I want to record from a text box into data veiw grid
View 2 RepliesI have it mostly working right now, I can edit existing data and have it save to the database so when I re-open the program all the new data is still there. Now I get an error saying "Column 'AppID' does not allow nulls." when I try to create a new record. AppID is a column in the DB that I use to number the appointments. I guess it's looking for this value when it tries to save the new data, and since it isn't a field on the form it doesn't get an entry and fires that message. I've tried changing the AppID column to an AutoNumber field so it generates by itself but I still get the same error.
Here is my
vb
Public Class Form1
Public Structure ScheduleOwner
Dim _index As String
Dim _description As String
Public Sub New(ByVal row As DataRow)
[Code] .....
Do I need to code an INSERT command to get it to add a new record? I'm using an Access database right now. This is the from that pops up to enter new information:
I want to know the code used to ADD, SAVE AND DELETE records in VB 2010. eg. I have a fully created DataSet, etc and I have three Buttons.. So to add a new record what code do I put in, same for the other two ( Save, Delete)
I know the code for VB6: Adodc1.Recordset.addnew ......
Is there a way to have a record automatically save like in Access? I would like to save the record before going to the next record or before exiting.
View 2 RepliesI currently have a listbox that is filled with input from a user and is currently saved to a textfile. What I need to do is, when the listbox (holds 10 records) displays the records which are shown [code]And so on. I need to save to a table in MS Acess that have the following fields:[code]
View 2 RepliesI have been working on capturing image and recording video in VB using webcam. From the cource code,I have successfully captured and saved images, however for the video part I have failed to save it in any selected directory. I've checked the code with some other sample codes in internet. Couldn't see any problem or differences. My code for recording and saving are as follow:
Recording:
SendMessage(hWnd, WM_CAP_SEQUENCE, 0, 0)
Saving:
Dim save As Integer
save = MsgBox("Do you want to save your recording video", MsgBoxStyle.YesNo + MsgBoxStyle.Information, "Recording Video")
If (save = MsgBoxResult.Yes) Then
[code]....
I had following code:
If File.Exists("OTS_Username.txt") Then
File.Delete("OTS_Username.txt")
End If
Dim numCols As Integer = dgvExp.ColumnCount
Dim numRows As Integer = dgvExp.RowCount - 1
[Code]...
I have the following code on the SaveItem_Click event of the BindingNavigator..[code]how can i adapt the code to also save any other cell changes on the DGV existing rows (even if the row is not new)?
View 2 RepliesHere is the code i am using to save record from data grid to db
Try
For r = 0 To DataGridView1.RowCount - 2 ' Why RowCount-2?
For Each cell As DataGridViewCell In DataGridView1.Rows(r).Cells
[Code]......
Error is
"Conversion Form type dbnull to Type date is not valid" Please view the attached image what should i do to remove this error.
I can't seem to save data in the database when updating a record. The record appears to be updated and even displays the new record on my form but as soon as I close and restart the program the old record is back and no changes are made to the database. Is there something im missing here ?
If CN2.State = ConnectionState.Open Then
Dim Comand As New SqlCeCommand("SELECT * From Incentives Where IncentiveCode = '" & TxtCode.Text & "'", CN2)
Dim rs As SqlCeResultSet
rs = Comand.ExecuteResultSet(ResultSetOptions.Sensitive + ResultSetOptions.Updatable)
If rs.Read Then
[Code]...
I have table name "WO" in oracle db I want "Whenever I start my program, I want it it look at all the works orders, and if any works order has a date that is exactly one month before today's date, then I want the program to display a message and create copies of those works orders with a schedule date of today's date and save it".
Here is the structure of my database
DESCRIPTION VARCHAR2(200)
REQ_DATE DATE
WO_T VARCHAR2(30)
TASK_PER VARCHAR2(50)
ORIGINATOR VARCHAR2(70)
[Code] ....
Please also view the attached project file by following the given link [URL]
sort out this problem;
[Code]...
after click on save button the below mentioned error is ocuured Error: No value given for one or more required parameters. MOD EDIT: When posting code...USE CODE TAGS!!!
Webcam capture code are below:
Dim capturesource As New CaptureSource
' Get the default video capture device
Dim _videoCaptureDevice As VideoCaptureDevice =
[code].....
I am using webcam and want to record video and save it on disk, the video time must be constant for such 20 or 30 sec, what i want is to change CAPTUREPARMS members which contain fLimitEnabled & wTimeLimit
'---capcaptureget function
Function capCaptureGetSetup(ByVal hWnd As Integer, ByVal s As Long, ByVal wSize As Integer)
capCaptureGetSetup = SendMessage(hWnd, WM_CAP_SET_SEQUENCE_SETUP, wSize, s)
End Function
[Code]...
I have a bound windows form with a bindingnavigator control. I want to add save and new record commands to a menustrip. How do I code the menustrip selections?
View 1 RepliesHow to Show and Save latest record on VB.net 2008 form with Label? I have a vb.net form to insert database to file *.mdb (Ms Access). But after I inserted database I want it save and show record that I just added on VB.net form. It's mean that current save without database...Show and Save Direct on Form's Label.
View 1 RepliesI am attempting to create a program which saves customer information for a business e.g first name, last name, address etc. but i am having trouble coding the save , new, print, next/previous record buttons.
View 2 RepliesIs there a way that I can record sound, and save it in the program so that it can be replayed?I'm making an alarm clock program, and I thought it would be cool if the user could record his/her own audio, and have it play back for him/her.
View 1 RepliesMy query is i want to save record from an excel sheet to my Database Table.
But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row wise.Inserting the records is not the only thing but my major issue is i want to check and compare the Primary Key column of my Table with the Column in my Excel.
Suppose Table1 is my Sql Database Table,and RegistrationNo is the Primary Key Column.Similarly there is also a column of Registration Number in my Excel Sheet.
Now before inserting each record the RegistrationNo column should be compared.If the a registrationNo in the excel sheet say RegistrationNo 112 is already present in the table then it should not Insert the record and if its not present then it should insert.
Also the other issue is the number of columns in my Database table are more than the number of columns in my excel Sheet.So the columns that are not present in the excel sheet should be set to NULL while inserting the record in the Table.
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
I'm new to VB.NET 2010, i have a form that has textboxes and i need to update my Database but i am failing to do so.I maged to create the login page and i can search from my db but i cannot add or insert a record.
My form has the following textboxes, Name, Surname, Username, Password and i have to insert to a table with the same columns
[Code]...
Everytime i run the program and update the data in database. I got the error in this code da.Update(ds, "reservationdata") Dim dt As DataTable = ds.Tables("reservationdata") If resno.Text = "" Or custname.Text = "" Or custaddress.Text = "" Or TextBox1.Text = "" Or endTime.Text = "" Or amouttopaid.Text = "" Or InitialDeposite.Text = "" Or RemainingPayment.Text = "" Or DateTimePicker1.Text = "" Then
[Code]...