Roman Pelepei gives smart answers on questions about C# .Net, ASP .Net, WPF and Silverlight programming with examples and source code.
суббота, 20 марта 2010 г.
How to add the insert/update parameter for ASP .Net SqlDataSource
For example I am using DetailsView and SqlDataSourece. I want to insert new item to the collection using Insert DetailsViewMode. But this item have some parameters that are not present in ReadOnly DetailsViewMode. The question how to add additional parameters to the data item and pass it to the SqlDataSourece InsertCommand.
The answer is simple, follow next sample:
protected void LeadsSqldatasource_Inserting1(object sender, SqlDataSourceCommandEventArgs e)
{
SqlParameter userName = new SqlParameter("@UserName", SqlDbType.NVarChar);
userName.Value = User.Identity.Name;
e.Command.Parameters.Add(userName);
}
Подписаться на:
Комментарии к сообщению (Atom)
Комментариев нет:
Отправить комментарий