Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / November 2005

Tip: Looking for answers? Try searching our database.

How to generate GUID for new rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TNS - 15 Nov 2005 15:32 GMT
Hi,

I'm relatively new to Infopath development, so maybe this is a simple
question, but I haven't been able to find a clear answer anywhere.
We have a SQL Server database where the keys are uniqueidentifier
(GUID's). A simple webservice layer which returns Datasets for
viewing/quering and accepts Datasets for updating has been made. The
infopath forms use the webservice layer, but right now the end user has
to enter Guid's when inserting new rows. How can I get Infopath to
automatically create Guid's for new rows? - or could this be
accomplished in another way (i.e. the webservice layer creating the
Guid's)?

Any help would be appreciated.

Regards,
Thomas N. Sørensen
Franck Dauché - 15 Nov 2005 17:28 GMT
Hi,

One solution to this is to create an unique ID column, which is different
from your table primary key.  For new record, you can generate the ID using
the System.Guid.NewGuid() method for example.

Regards,

Franck Dauché

> Hi,
>
[quoted text clipped - 13 lines]
> Regards,
> Thomas N. Sørensen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.