update database

  1. G

    Question Update With WHERE Querie problem

    Im having a question regarding the possibility to update a row in mysql database WHERE the row to update = the row that holds a "projectname" in a label that i retrieve from another table . What im trying here is to use the "projectname" as a sort of foreign key to all my other tables in the...
  2. M

    Question Saving changes to 2 datasets but only 1 of them updates

    Hi, newbie here! :nevreness: I've been try for days to see what I've done wrong but can't figure it out for the life of me. Here my problem. I'm using 2 sets of DataAdapter and Datasets. When I click my "Apply" button, the program does a set of basic calculation and save the changes in the...
  3. G

    Help updating database through datagridview

    Hi, I am trying to update a database table via a datagridview. I can successfully populate the grid with data from the table, but when I try to call the update function I get a Syntax error. Based on the error I think I am somehow not linking the datagridview columns to the SQL Update...
  4. Runescope

    Question Update command is not passing change back to database ... sometimes.

    So, this is quite frustrating and I'm not understanding what the problem is. To start it off, this is the bit of code: FFoundRow = FDT.Select("[Code1] = '" & Code1 & "'") FFoundRow(0).Delete() FDA.Update(FDS, "Info") FHCIndex = FHDT.Columns.IndexOf(Code1)...
  5. S

    Question update problem

    Hi there, i've written all my code up to send or create data in access however I keep receiving the error of :- OleDbException was unhandled Syntax error in INSERT INTO statement. I haven't got the faintest clue of what's gone wrong, I'm a beginner hear, just started programming a few weeks...
  6. B

    Writing to database error!

    If anyone can point out my error it would be much appreciated. This is the error message: Syntax error in UPDATE statement. Here's my code: Sub addSpot(ByRef row As Integer, ByRef col As Integer, ByRef value As String) Dim con As New OleDbConnection Dim dbProvider As String...
  7. emaduddeen

    Question Database book sample code not saving changes to the database

    Hi Everyone, I'm using the book titled "Database Programming with Visual Basic® .NET and ADO.NET: Tips, Tutorials, and Code". I'm going through the chapter that has me do data binding by setting the properties of a DataGrid and TextBoxes. It had me drag a DataAdapter onto the form using the...
  8. V

    search requiers more than 1 parameter?

    Hi, my name is Viktor and i have this problem: My IT teacher at the HTMU(Chemical and Metalurgy University of sofia) gave me a project to write a database software....using the free Visual basic from Visual Studio 2008....I've started the project and got to a dead end... :-( The problem I've...
  9. P

    Question Add Item To Databound ComboBox

    This may seem like a silly question, but i'm really stuck on this. Short story of how I got to situation first. I started a Windows app using all code for database connection and validation. However, it was always losing the formatting that I had set at run time. So I thought I would use the...
  10. C

    Question Update Database using datagridview

    I am building an application in which I am using Ms Access as the database. Now when somebode searches the data is shown in Datagridview conrol using only dataadapter and dataset methods Now I want that if user do the chenges in the DataGridView and then clicks on update button then data should...
Top Bottom