Search results for query: *

  1. michaelw

    Dataset fill

    ok manged to sort previous post out have one more snag? on the line objdataview.Table(0).ow(inum).item("URN") = "TEST" it says it can not be indexed because it has no default value
  2. michaelw

    Urgent DataAdapter

    Ok this is what i come up with thanks for the help I am having a problem with the objadapter objdataview inum are telling me that declartions are needed?? I thought this would be done when i dim them?? Dim objconnection as New SqlClient.SqlConnection("Initial catalog=testbooking;" &...
  3. michaelw

    Urgent DataAdapter

    u are dircetly using the update mehod of dataadapter ( OK no problem i understand this) but nowhere have u used the update query of sql ( sorry do not understand where i would place the SQL to relate to the coloums and values) and there are also no paramaters collection. ( this is new to...
  4. michaelw

    Urgent DataAdapter

    This seems to have done somthing but not update the table, it does not crash anymore but it does not update the table either and i cant figure out why? any suggestions my code now is> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click...
  5. michaelw

    Urgent DataAdapter

    Where you put table name is that the table in sql server or the datagrid name and do you have to put it in the <>??
  6. michaelw

    Urgent DataAdapter

    I am using the wizard to create a oledbdataadapter. i can fill the dataset but when i change a field value and update it brings back an error. When i created the adapter it created all but the update and delete statements. My code is Private Sub Button1_Click(ByVal sender As...
  7. michaelw

    Urgent DataAdapter

    When i create my data adapter using the wizard it does not create the update and delete, this has thrown me
  8. michaelw

    Dataset fill

    The erro message i get is: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: Update requires a valid UpdateCommand when passed DataRow collection with modified rows. my code is Private Sub Button1_Click(ByVal sender As...
  9. michaelw

    Dataset fill

    Hi thanks for your help with this, i have moved on and am now using the oledb adapter but have come across anothe problem, i generate this through the wizard and when it has finsihed it tells me it can not create the update or delete commands. My project as it stands is this: I have an...
  10. michaelw

    Dataset fill

    The connection you posted is the same as mine but it throughs the error message back???
  11. michaelw

    Dataset fill

    No it is SQL server it just giives me an error with the sql adapter method. I will try you way and keep you posted thanks
  12. michaelw

    Dataset fill

    Hi i am trying to connect to a database using an sql adapter, when i fill the dataset i get an error in the output window it says "Unhandled Exception: System.Data.SqlClient.SqlException: Cannot open database requested in login 'testbooking'. Login fails." But the server does exsit and so...
  13. michaelw

    Database update

    hi another prob here, i have a datset imported from excel, that i wish to update the data to a database table. the dataset hase two coloums [URN], [invoiceNo] i wish to update a table called jobs where the URN matches and updates it with the invoice number placed in the excel dataset, any help...
  14. michaelw

    Merging datasets

    Please excuse me i am a bit of a newbie Where does the datset schema come from/ created?
  15. michaelw

    Merging datasets

    hello all, Having a bit of a prob. i have two datasets one named ds and the other ds1 i want to merge them into one dataset. ds is populated with excel data and ds1 is populated with database data. thanks
  16. michaelw

    Crystal Report Problem

    Hi david thanks for your suggestion i am trying to complete this task using your first idea i have now one dataset with the information i require then i create a xml file, i then drag the table i want from the databse and creat the link, i then create the report based on the xml schema but for...
  17. michaelw

    Crystal Report Problem

    Hi, I have data in an excel xls that i want to compare with data in a database using crystal reports when i make the report it tells me i need to set the database location and i am using more than one driver, any help will be great
  18. michaelw

    SQL Update

    Hi, i have a bit of a problem, i am inserting a excel file into a datset with one colum of data in, i now need to update a database with the value inserted into a text box to each of the values within the datset. any help would be really apprecieated.
  19. michaelw

    Inserting into SQL server

    still need some help on this if anyone can?
  20. michaelw

    Inserting into SQL server

    Sql hi at the momment it has one row of data in it for testing purpose but soon there will be mre coloums with multiple rows
Back
Top