Thread: how to use insert command on c# form to access database

You can call an SQL command to insert records on a button click event, if that's what you mean? Something like:-

Code:

<asp:textbox id="txt1" runat="server />
<asp:textbox id="txt2" runat="server" />
<asp:button id="btn1" runat="server" onclick="btn1OnClick" />

Code:

public void btn1OnClick(Object s, EventArgs e)
{
string text1 = txt1.Text;
string text2 = txt2.Text;
string sql = "INSERT INTO tbl1(field1, field2) VALUES('" & text1 & "','" & text2 & "')";";
//connect to db
//execute sql command on db.
}

Obviously this is a very simplified version. You should check and validate values before inserting them into the db. You could also create a class that handles your db calls rather than doing it directly in the page.

Hope that helps.