Hi, I

 have created a table with 2 columns and 5 textboxes..these textboxes will fill 5 parameters out of 6 in an sqldatasource control .

The 6th parameter is the logged in users userid.

1) I want the sqldatasource controls insert command to be fired on the click of a button i create on the form.

How can i do this? what do i write in the buttons on_click event?

2) How can i call the sqldatasource control in the submit buttons on_click event?

I saw this on 4guysfromrolla..a similar thing didnt work on my form..

SqlDataSource DataSource = (SqlDataSource)CreateUserWizardStep2.ContentTemplateContainer.FindControl("InsertExtraInfo");

Thanks

Call SqlDataSource.Insert() to invoke whatever specified in SqlDataSource.InsertCommand

In you button click

Dim cmd As SqlCommand = New SqlCommand("INSERT INTO YourTable (LoggedInUser) Values(@LoggedInUser)", conn)

cmd.Parameters.AddWithValue("@LoggedInUser", 1)           ' This ill enter 1 as the the value in your table for the user bing logged in. you can set it to be anything else.