Search results

  1. I

    Updating Cells in a datagrid

    I forgot to mention: When I type [Net] + [Vat] as the expression it generates the error: The column mapping from SourceColumn 'Gross' failed because the DataColumn 'Gross' is a computed column. whenever I try to load up the table.
  2. I

    Updating Cells in a datagrid

    Hi cjard. I've found where you set the expression in the dataset view but cannot fathom out how to structure the expression. It's in a table called tblIncome with the three fields in question being Net,Vat and Gross and I want to add Net and Vat together and put it in Gross whenever Net or...
  3. I

    Updating Cells in a datagrid

    Hi there, I hope someone can help. In my app I have a datagrid called tblExpenditureDataGridView. In there I have numerous columns but what I want to do is that whenever a cell/row is changed two of the cells/columns (net and vat) should be added together and the result put in Gross. The way...
  4. I

    Saving Data From Form to Access Database

    Have you checked that the "Copy to output Directory" property for the database is set to "Do not copy" or "Copy if newer"?
  5. I

    Running access queries in background

    I thought that it might show the data that's going to be added when you click the preview button. When I click the execute button within the query builder it manages to tell me that 2 rows were added which is why I thought it might show the actual data. When I try to run it literally nothing...
  6. I

    Running access queries in background

    Hi there,Thanks for the links, without them I wouldn't have got this far. I tend to get lost looking through all the pages hence this reply.In the query that I create on the xsd page when I go into the query builder and click execute query it performs the insert OK. When I right click the query...
  7. I

    Running access queries in background

    I've now worked out how to paste the SQL statement above into a new query in a table adapter.So within the dataset (called sebdbdataset) there are the tables mentioned above. Tacked on to the TestingTable bit is TestingTableTableAdapter into which I have created a query called qryTesting2.What I...
  8. I

    Running access queries in background

    What i've found What i have since noticed is that the update queries etc did not appear in the data sources section but have since found them in the server explorer as stored procedures. The data structures used are: Table: tblIncomeCodes containing: Code, Category, Description, Net_Balance...
  9. I

    Running access queries in background

    I'm writing a front end application for an access database. In the database I have update, append and delete queries that update various tables in the database. I was wondering if there was a way to run these queries from within a VB.net application. I've tried dragging the query onto a form...
Top Bottom