I 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 a listbox that contains 10 records as the follow:
1 + 1 = 2
1 - 1 = 0
2 / 1 = 1
[code].....
I want to record from a text box into data veiw grid
View 2 RepliesIs 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 am writing a program that involves the split Function. The user will enter A, B, C. I wrote a splic fuction code (below). I am not quite sure if it is right, I would also like to know how to write the code for that split function when the user preses the save button after entering there input.
Dim strInput As String 'input string
Dim strOutput() As Sting 'output string array
strInput = "A, B, C," 'user input
strOutput = Split(strInput, ",") 'splits the input string
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!
Given a string of categories, I need to split the string and insert each separate item as a new record using EF.The following does not work since string cannot be converted to Tag:
Dim s = "Books, Novels, Magazines"
s.Split(", ").ToList.ForEach(Function(x) _rdsqlconn.Tags.Add(x))
How can i split the string and insert each as a new tag record?
I have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
I got a question. I have a textfile name membership.txt and using vb2008. However my code found error when try to grab the data to an array. I use delimiter "|" to separate between each data in line to save in specific column in database.
[Code]...
I have a string "<PinX F='53mm'></PinX>", I want to access the 53 within the string and do some addition to it and then add the answer back into that string. I've been thinking about this and wasn't sure whether this can be done with regular expression or not?
View 5 RepliesI 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 a school student and having a project on importing text to access database. The problem seems easy but the issue is the text file i am trying to import has no delimiter. .
firstnamelastnamesexage
jhonlittlem15
Now how can I split the text and import it to an access database.
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 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 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 ......
I 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 Replies