i have this code
but the data is not save in my local database please help me.
(
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;
namespace WebApplication2 { enum Insert_DATA{string Email, string Password, string Repeat_Password} {
//String s = "Data Source=HAFEEZ-PMO;Initial Catalog=PPG_Biller;Integrated Security=true;providerName=System.Data.SqlClient";
string s = "Server=HAFEEZ-PMO;Database=AHBKS;User ID=hafeez;Password=sa123;Trusted_Connection=False;"; using (SqlConnection connection = new SqlConnection(hafeez)) { try { connection.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = "SP_INSERT_DATA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Email", Email); cmd.Parameters.AddWithValue("@Password", Password); cmd.Parameters.AddWithValue("@Repeat_Password", Repeat_Password); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { if (connection.State == ConnectionState.Open) connection.Close(); }
protected void Page_Load(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) { Insert_Data("12345", "12345", 1); } } }
)