I think you are getting confused with stored procedure. Replace stored procedure parameters with simple query.
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True");
con.Open();
string query="insert into EnquiryTable values('" + txtName.Text + "','" + txtEmailid.Text + "','" + txtPhoneno.Text + "','" + txtAddress.Text + "','" + txtPincode.Text + "','" + txtHeardfrom.Text + "','" + txtEnquiryabout.Text + "','" + txtMessage.Text + "')";
SqlCommand cmd = new SqlCommand(queryString, con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
con.Close();
}
catch(exception ex)
{
}
}
Fore more information refer this
link
** To Get clear idea about STORED PROCEDURES check this
link
Refer this
link
for Using stored procedures with ado.net.