Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to access the parameter values in an SQLDATADAPTER
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01039774
Message ID:
01049509
Views:
22
Sorry for the lag, but I have been digging into this much more.

After much work on this now I agree with you completely. If you can use these IDE "easy" methods as-is, great. But if any external access is required or serious customization, it can be tough or outright impossible to do.


>If you're planning on doing fancy stuff like this where you're dynamically populating the data controls from values, you're probably better off using traditional ADO SqlCommand objects to set up your commands. The SqlDataSource objects are primarily meant for declarative usage in the iDE, not so much for programmatic use. They are especially frustrating because they don't expose everything exposed by the underlying ADO.NET mechanisms.
>
>
>+++ Rick ---
>
>
>>In an ASP.Net Beta 2 form I have two SqlDataSource. I need to transfer the many of the fields of SqlDataSource1 to SqlDataSource2 at one point.
>>
>>How do I directly access and set the current values of the parameters in an SQLDataSource to do it? Wihtout being in the "Inserting" or "Updating" methods of that particular SqlDataSource?
>>
>>For example, I can access the current values of SqlDataSource1 in the SqlDataSource1_Updating or _Inserting methods by accessing the parameter passed as System.Web.UI.WebControls.SqlDataSourceCommandEventArgs. Like this:
>>
>>"e.Command.Parameters("@EntryDate").Value = DateTime.Now"
>>
>>But how do I assign the SqlDataSource1 values to a DIFFERENT SqlDataSource there? From within the Inserting or Updating methods of #1 I can find no way of assigning the values to the parameters of a differnt SqlDataSource - I can only get the parameter names for it.
>>
>>Can anyone help?
Previous
Reply
Map
View

Click here to load this message in the networking platform