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 am having problems editting my record where i basically want to select a record from the datagrid view and change any details where the data is displayed in the text boxes i have put on my form and click edit and have the data updated on to the database as well as the dataset. As for my updating button the code seems ok but i check my database and it doesnt change. Here is my code where the edit and update button code are at the bottom:
Imports System.Data.OleDb
Public Class Stock_Control
Dim dbConnection As OleDbConnection
[CODE].....................
in my visual basic 2008 express edition project I have 2 forms (paxreportfrm,paxsearchfrm).I want to give inputs in paxreportfrm and save the record(which is working fine).then in paxsearchfrm i want to search depending on multiple criteria (working ok).when i click on the record which is in gridview in the search form,opens up the paxreportfrm again with all the details of that specific record (working fine). Now i want to update the existing record which has been populated from the gridviw of the paxsearchfrm and also want to have the option to delete the record.I am using the datacontrols(wizard) to make connection with the access2007 database.can someone give me some example of how to do the Edit and delete in the database pls.I already have a save button on the paxreportfrm(if i click on that, after changing the details on existing record, it just saves IT as a new record).so i really need something which will actually save the modifications on the existing record AND ALSO WILL BE ABLE TO DELETE IT FROM THE database. I have tried couple of methods but none of them are working.
View 4 RepliesI have a DataGridView bound to a datatable which comes from an SQL Server database.When the user edits a record my update statement changes the field datetimemodified to reflect the last date and time the record was edited (as stored procedure). The new value for datetimemodified is not brought into my DataGridView.
1) How do I refresh a DataGridView bound to a DataTable? Is there any way to refresh or resync only records that have changed instead of the entire DataTable? (Note: my update statement is working fine. I'm only wondering about refreshing the DataGridView.)
2) Would it be better to change the value of DateTimeModified on the client side so that I can avoid a refresh (assuming that this is the only reason I need to refresh the data)?
I am using Visual Basic 2009 to create a file of records to store students tests scores.Currently i can write to the file, create new records etc. However i cannot edit a particular record, im sure i have to use file seek function but i have no idea where to start.here is some of my source code to give you an idea of where im at
Do While (Not EOF(1)) And found = False 'loop until no more records or the record is found
nosrecords = nosrecords + 1
FileGet(1, onestudent, nosrecords)[code].....
While I've previously many years of relational databases and procedural languages, I'm stumbling with Visual Basic. In this problem, the simple situation is that I have two files, parent and child. The primary key of the parent file (Area file) is linked by a relation to one of the two fields that makes up the primary key in the child file (Project file) (unique key is formed from 'area' and 'project'). I have the default table adapters created on both files. I have created two maintenance forms showing one each of the two files in datagrid view format.I can create some records in the Parent (Area) file, but when I try to create a record in the child (Project) file, using one of the valid key values from the Area file, I get the 'ForeignKeyConstraint [relation name] requires the child key values [actual value] to exist in the parent table' which I'm absolutely definitely sure it does.
I haven't done any actual coding for those two maintenance forms, just dragged-and-dropped the files from the data sources screen onto separate forms so it creates the controls itself. But I can't work out, if it already knows the data does exist because I can load it back in to the Area maintence form, why it can't check itself to find out the record does exist. Why does it think the record from the parent record doesn't exist? It does exactly the same thing, whether or not the database is in access or SQL Server Express. I have all the latest updates.
Module Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[Code]...
Module Code
Imports System.Data.OleDb
Module modConnections
Public myConn As New OleDbConnection
Public myCmd As New OleDbCommand
Public MyDr As OleDbDataReader
[code]....
When I'm trying to update or remove record from database I'm getting this error:
Syntax error (comma) in query expression 'Ime='Blagojce', Prezime='', Adresa='', Grad='', Telefonski_br='( ) -', Fax='( ) -', e_mail='''
Here is my connection string:
command.CommandText = "DELETE * FROM podatoci WHERE Ime='" & ime & "', Prezime='" & prezime & "', Adresa='" & adresa & "', Grad='" & grad & "', Telefonski_br='" & broj & "', Fax='" & fax & "', e_mail='" & email & "'"
where ime, prezime and so on are ListView selected items.
hello everyone can anyone tell me
how do i fix the error when i edit
c:windowssystem32oobeackground.bmp
I am trying to edit and update a selected users details, following the tutorial
[Code]...
How do I show the error icon when the user is editing the cell?
View 2 RepliesHow do I show the error icon and ToolTip when the user is editing the cell in dataGridView?
View 8 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 have a datagrid with a lot of column, but only a few group of it can be edited by user.On a CellEndEdit event i update automatically the database with the new value when the user modify one cell and then I must recharge the dataset of the dataview.If I modify a cell and then use tab or enter to move to the next one everithing is ok, but if I change a cell and then mouse_click on another one i get thi error when i recharge the dataset:
Operation is not valid because it results in a reentrant call to the SetCurrentCellAddressCore function
What can i do ?
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]...
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]....
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 RepliesUsing 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, 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'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 RepliesCan VB 2008 use the system variable %1 that contains what filename a program was opened with? I am making a new app that when you click a .exe file and select the right option, it will edit the registry but I need to be able to keep the filename that I right clicked on so that I know what registry value to edit, is this possible?
View 1 Replies