public string Insert(InsertUser user) { string msg; SqlConnection con = new SqlConnection("Data Source=ARIFBUDIMANAR;Initial Catalog=crudDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); con.Open(); SqlCommand cmd = new SqlCommand("Insert into UserTab(Name, Email) values (@Name, @Email)", con); cmd.Parameters.AddWithValue("@Name", user.Name); cmd.Parameters.AddWithValue("@Email", user.Email); int g = cmd.ExecuteNonQuery(); if (g == 1) { msg = "Berhasil Tambah data"; } else { msg = "Gagal tambah data"; } return(msg); }
public string Insert(InsertUser user) { string msg; SqlConnection con = new SqlConnection("Data Source=DESKTOP-Q6TINDB; Initial Catalog=WCF;Persist Security Info=True;User ID=sa; Password=123ricki"); con.Open(); SqlCommand cmd = new SqlCommand("Insert into UserTab (Name, Email) values(@Name, @Email)", con); cmd.Parameters.AddWithValue("@Name", user.Name); cmd.Parameters.AddWithValue("@Email", user.Email); int g = cmd.ExecuteNonQuery(); if (g == 1) { msg = "Successfuly Inserted"; } else { msg = "Failed to Insert"; } return(msg); }