Using vs2008 9.0.30729.1 SP. Inserting a new record works but editing a record doesn't. Tried databindingsource but no joy as well.
Private Sub Gr1A_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Gr1D.CheckedChanged, Gr1C.CheckedChanged, Gr1B.CheckedChanged, Gr1A.CheckedChanged
sAns1 = ""
If Gr1A.Checked = True Then
sAns1 = "A"
ElseIf Gr1B.Checked = True Then
[Code] ......
I have a datagridview binded with a bindingsource with all the options of editing,saving,deleting enabled.But i am unable to understand the problem that is why the data from my datagridview is not getting saved.This is the code which I am using
Private Sub frmDvdMovieData_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Library.category' table. You can move, or remove it, as needed.
Me.CategoryTableAdapter.Fill(Me.Library.category)
[code].....
I am using the following codes to Save records to MySQL database from VS2008.
Dim cmd As New MySqlCommand
If cmdSave.Text = "&Save" Then
'save computer main
ConnectComputerDB()
cmd.Connection = CompDBCon
cmd.CommandText = "INSERT INTO tbl_items " _
[Code] .....
Is it the right way and proper method to save records to MySQL database...?
I would like to be able to read data from a text file, be able to edit it and save the new edits to that file over writing the old ones.
Dim FILE_NAME As String = "C:cat4 ext.txt"
Dim TextLine As String
If System.IO.File.Exists(FILE_NAME) = True Then
[code].....
I have a file with information about people, and use the following code to show the contents ofthe file in a list box..
[Code]...
I have a DataGridView binded to a DataAdapter to manage the details of an invoice(products). The Table fields are:
ID_Invoice int (PK)
ID_Product int (PK)
Quantity numeric(18,2)
[code].....
I was trying to edit and update an existing record in my database. I am getting an error, my code is here:
Editing Records
Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
Dim qry As String
[code]....
I am adding an undo feature for a DataGridView using the Command Design Pattern. To create the EditCommand, I have to know what was the previous value of the cell, so I can re-enter it in case the user hits undo. I'm doing it using the CellBeginEdit and CellEndEdit events. With the CellBeginEdit, I save the value of the cell in a private variable and at the CellEndEdit function, I use the saved value to create the EditCommand. It's working fine, but I wonder if there is a more saner way to do it. Maybe a event that holds together the previous and the new cell value. Bonus points if I could actually prevent the DataGridView from updating itself and let the EditCommand do it.
View 1 RepliesI have a datagridview on my form which is not bounded to any database table.The datagridview is only used for data entry. When the user has populated the datagridview and click the save button, I want to be able to save all the rows into a table in my database.At the moment, if more than one row is populated, my code is saving only the second row of the datagridview and everything else is ignored. If only one row is populated, it works fine.I am using Oracle database 11g and a store procedure to insert the records. Below is my code.
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim cmd As New OracleCommand("MHMS_Package.Insert_Service", conn)
Dim strCmd As New OracleCommand("MHMS_Package.Insert_Service_Details", conn)[code].....
I have a DatagridView which displays the following: IDNo, SubjectName, FirstName,MI, LastName, YearLevel, Address, Gender. I want to save whatever is displayed in it to my database...My code below does not save the SubjectName all the rest are saved.
Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click
Try
[code].....
The following code throws an error on saving a record: "Conversion from string "TDT" to type 'Integer' is not valid" The following code is highlighted:
da.InsertCommand.Parameters.Add("@TDT", OleDbType.Date, "TDT")
"TDT" is a MS Access field name for storing date.
I'm trying to save the contents for a listbox, which can contain up to 10 records(items) as follow:
1 + 1 = 2
1 - 1 = 0 and so on.
The code that I currently have is recording only the last item of the listbox
Below what I have so far:
Imports System.Xml.Serialization
Imports System.IO
Public Class SerializeData
' Save - serialize the object to disk...'
[Code].....
I am trying to learn XML, for which i have created a simple Employees Program. I want to save the records of the employee in an xml file, so far i have the following code:
vb
Private Sub SaveRecord(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim XMLSettings As New XmlWriterSettings
XMLSettings.Indent = True
XMLSettings.IndentChars = " "
XMLSettings.NewLineOnAttributes = True
[Code] .....
This is only working for a single record, How should I insert more employees records within this xml file?
My program runs with no errors, but the actual .accdb file does not reflect changes when I make them in the running program. Also when I fill in the text boxes and click the "Add New Item" Button, the "ID" text box displays a -1. "ID" is the primary key in my Access Database.
Imports System.Data.OleDb
Public Class addMemberForm
Inherits System.Windows.Forms.Form
[code].....
I'm working on a simple data logging program, and I have little to no database experience. I wrote a little VB forms app to log the data to ms access and then graph the data, but I'm having trouble with adding records to the database. First, I created a simple one table database in access. Then, I added the database to the project as a data source, and gave it a data set using the wizard. Right now my code looks like this:
[Code]...
There are no problems during build or run time, but I do not see changes to database after the program runs.
I am working on creating a program that records animal data (wombats) and stores it into a database, using vb.net. I am trying to add new records into a database but every time I click add, to execute that, there are duplicate records that gets added. How do i write the code so itonly adds it one time. I am using a data reader. Here is the
[Code]...
im trying to edit an existing excel file. some cells were merged but after saving the file, all merged cells were unmerged again. Here's my code
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
[code]....
rewriting a class I use for saving Treeview data to a XML file for use of saving ListView data I can't really figure out the rewrite, I'm stucked, unfortunately Listviews seems to be a big problem for me in general.
Option Strict On
''' <summary>
''' The TreeViewDataAccess class allows the nodes within a TreeView to be
''' persisted to xml for later retrevial.
''' </summary>
[Code]....
I have created a program in vb2008 that when first run will make all the required regisry changes it requires by creating a path in the registry.
View 10 RepliesI have a datagridview, 3 textboxes, 1 NumericUpDown and a button.What I want is that when the user clicks the button, the current row that is selected in the datagridview will change to the values in the textboxes and NumericUpDown.
View 4 RepliesIs it possible to disable editing a combobox. With a textbox you have the option readonly. Is there something like that for the combobox?
View 7 RepliesIt gets some links in a listbox, And i had to create a new ListBox for because i only want to keep some items, So i got this.[code]But i had to do a new listbox for it, I dont mind that, But the problem is, It creates duplicates, I've tried making it delete the item from the first listbox after it was added to the new listbox, But it is not edible during the process structure so i thought i could get some help here because im getting so many Duplicates of 1 item.
View 8 RepliesI can add new data to the database and have it saved and everything (though my method not be great, but it works) but I'm having a hard time figuring out how to edit existing data and save it. assume it would be better to have it check whether or not the row exists, and if it does, just update it rather than trying to insert new rows? This is the code I have right now to
Dim newRefractiveRow As EyeBaseDataSet.Spectacle_RxRow
newRefractiveRow = EyeBaseDataSet.Spectacle_Rx.NewSpectacle_RxRow
With newRefractiveRow
[code].....
I have one CheckedListBox called cListBox, and I have one ListBox called ListBox.In my cListBox I have, for example:IDS_PROPITEM_TXT_011131Space Cadet Set for male characters comes complete with hair piece, Space Fleet Uniform, hands, and boots.IDS_PROPITEM_TXT_011141Space Cadet Set for female characters comes complete with hair piece, Space Fleet Uniform, hands, and boots.It is ALWAYS the case that you have IDS_PROPITEM_TXT_somekindof6longvalue (TAB seperator) some kind of text.
View 2 RepliesI have this code here:
Public Declare Function RegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" (ByVal hKey As Integer, ByVal lpValueName As String, ByVal Reserved As Integer, ByVal dwType As Integer, ByVal lpData As String, ByVal cbData As Integer) As Integer
Public Declare Function RegCreateKeyEx Lib "advapi32.dll" Alias "RegCreateKeyExA" (ByVal hKey As Integer, ByVal lpSubKey As String, ByVal Reserved As Integer, ByVal lpClass As String, ByVal dwOptions As Integer, ByVal samDesired As Integer, ByVal
[code]....
But when I execute it it doesn't correctly change the value of the DWORD from 0 to 1, it creates an invalid value.
I have problem, when i click on save it gives me an error.'Cannot perform '=' operation on System.Int64 and System.String.'My code looks as follow....
vb.net
Private Sub ItemsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ItemsBindingNavigatorSaveItem.Click
[code].....
I've been searching in google for some time now and i've just found answers like "Resources are embedded in the exe so you can't retrieve the path" and other answers which are complicated and not even explained how to use the code. ~~However my problem is that i have a .txt resource file in my resources and i want to edit the content of the file so i triedIO.File.WriteAllText(My.Resources.MyTextFile, "some string")but that didn't work out since [My.Resources.MyTextFile] retrieves the content/value of the resource so what i want to do is edit the resource file simply, from within my application, not by going to My Project > Resources and from there, edit the file
View 1 RepliesNot sure if I'm posting this in the right area, but here goes anyway. I've been working with sql databases for practice, but can't seem to get around one thing; after I add it as a data source, I can't go back and add tables.
I start off by going through the project, then add item, choose the service-based database, and go from there. I add the tables, then go in and add it as a data source.
After I've added it as a data source, I can go back into the .mdf form and add lines and edit properties, but it wont update in the data sources. So, I can't add it to the form.
I must change the textbox value of a form a thread that is located on an other module. I've already tried with the CheckForIllegalCrossThreadCalls to False on the onLoad event of the textbox's form but it doesn't seems to work because everytime the thread executes the lines that should change the textbox value nothing happens at all (not even a warning). I really don't want to use that "safe cross threading" with delegates and stuff because it's too much trouble for me, I don't know how to use it and I just have one thread on my project and it's the only control that is accessing those textboxes.
View 2 RepliesI reopened my project to edit it but it is only showing the code not the design I cant get it back how do I do it?
View 3 Replies