[WebMethod]
public void db_insert(string UserName ,int countryId ,string IsActive)
{
SqlConnection con = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
string sql = string.Format(@"INSERT INTO [Table_1].[TestDB]
([UserName]
,[countryId]
,[IsActive])
VALUES
('{0}'
,'{1}'
,'{2}')", UserName, countryId, IsActive);
SqlCommand cmd = new SqlCommand("insert into Table_1 values(@a,@b,@c)", con);
cmd.Parameters.AddWithValue("@a", UserName);
cmd.Parameters.AddWithValue("@b", countryId);
cmd.Parameters.AddWithValue("@c", IsActive);
if(con.State == ConnectionState.Closed)
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}