Gday,
I have just started c# .net about 3 months ago and have recently (last week)
upgraded to 2005 and hoping for some
assistance understanding the best approach to adding new records to a table.
The application that I am creating is a distributed application that has an
Oracle DB, an XML WebService, and a
Windows Forms application front end - similar to:
http://msdn2.microsoft.com/en-us/library/1as0t7ff.aspx
I am trying to gain a better understanding of how to create a new row in a
table, and the steps that I think I should
be doing are outlined below - if anyone can comment on as to whether or not
I am on the right track or otherwise I
would be very grateful.
-------------------------
On the WebService:
1.
Create a DataSet that contains multiple datatables using the wizard.
This becomes an <dataset>.xsd file.
2.
Now want to create a new row and display this to the user for editing on a
WinApp. (webmethod: createNewRow())
What I think I should be doing is creating a dataset that is an instance of
the <dataset>.xsd class file,
create an instance of the datatable (unpopulated) that is the table within
this dataset that I want to create
the new row for, then create the newrow object as a row of this table.
I would do this on the web service so as to be able to initialise a couple
of fields before displaying it on the form (
eg id field).
3.
Then from the WinApp it would be cool to be able to reference the datatable
that has the new row that was just created
and allow editing from here...however I think I have to pass datasets rather
than datatables as it seems you cant pass
datatables to a web service?
This appears like it *should* be fairly straightforward however I am new to
..Net and am hoping for some
advice/comments. Are there alternative ways to do this that I have not
thought of?
If this seems like the best approach I will go ahead and implement it and
post the code to the group, as I myself have
had a bit of trouble finding something that achieves this in 2005.
Thanks,
Peter