Thanks. -----Original Message----- From: Jure Spik [mailto:[EMAIL PROTECTED] Sent: July 21, 2004 12:47 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] Re: Recordset on the fly in ADO.NET
Hello, You should create a DataTable - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/ frlrfsystemdatadatatableclasstopic.asp - and store it in a DataSet, - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/ frlrfsystemdatadatasetclasstopic.asp - edit it, then write to database with the DataAdapter's Update() method - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/ frlrfsystemdataoledboledbdataadapterclasstopic.asp - . Examples are on site. Jure ----- Original Message ----- From: "Rajput, Goutam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 21, 2004 4:32 PM Subject: [wdvltalk] Recordset on the fly in ADO.NET > Is there a way to create recordset on the fly in ADO.NET. Basically in > ADO you could this > Set rsProp = New ADODB.Recordset > rsProp.Open App.Path & "\PropPage.rec", , , , adCmdFile > rsProp.Fields("DBName") = Trim(txtDB.Text) > rsProp.Fields("UserName") = Trim(txtUser.Text) > rsProp.Fields("Password") = Trim(txtPass.Text) > rsProp.Fields("SYSUserName") = Trim(txtSysUser.Text) > rsProp.Fields("SYSPassword") =Trim(txtSysPass.Text) > rsProp.Fields("InfoedUserName") = Trim(txtInfoedUser.Text) > rsProp.Fields("InfoedPassword") = Trim(txtInfoedPass.Text) > rsProp.Update > rsProp.Save , adPersistADTG > rsProp.Close > Set rsProp = Nothing > > Can this be done in ADO.NET or is there a work aorund for this. Any > help is appreciated. > > Thanks > G > > ____ * The WDVL Discussion List from WDVL.COM * ____ > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with > the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > ________________ http://www.wdvl.com _______________________ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To > unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: Jupitermedia > Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > > > ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
