Inserting a command into a database

[Lars]

Hi

I have the following method. HOw do I performe the task to the table in the
database?

protected void FormView1_PageI ndexChanging(ob ject sender,
FormViewPageEve ntArgs e)
{
Button S = sender as Button;

if (S != null)
{
TextBox Name = (TextBox) S.Parent.FindCo ntrol("tbName") ;
TextBox Company = (TextBox) S.Parent.FindCo ntrol("tbCompan y");
TextBox Email = (TextBox) S.Parent.FindCo ntrol("tbEmail" );
TextBox Subject = (TextBox) S.Parent.FindCo ntrol("tbSubjec t");
TextBox Message = (TextBox) S.Parent.FindCo ntrol("tbMessag e");
Label ID = (Label) S.Parent.FindCo ntrol("lblID");
SqlDataSource DS = (SqlDataSource)
S.Parent.FindCo ntrol("SqlDataS ource1");

SqlDataSource1. InsertCommand = "insert into Emails (ID, Name,
Company, Subject, Message ) values ( @ID, @Name, @Company, @Subject,
@Message );";
if ((Name != null) && (Company != null) && (Email != null) &&
(Subject != null) && (Message != null) && (ID != null) &&
(DS != null) )
{
SqlDataSource1. InsertParameter s["ID"].DefaultValue = ID.Text
+ 1;
SqlDataSource1. InsertParameter s["Name"].DefaultValue =
Name.Text;
SqlDataSource1. InsertParameter s["Company"].DefaultValue =
Company.Text;
SqlDataSource1. InsertParameter s["Email"].DefaultValue =
Email.Text;
SqlDataSource1. InsertParameter s["Subject"].DefaultValue =
Subject.Text;
SqlDataSource1. InsertParameter s["Message"].DefaultValue =
Message.Text;
}
SqlDataSource1.
}
}