public string Put(Tb_Admin_Provinsi tbadprov) { try { string query = @"UPDATE [dbo].[Tb_Admin_Provinsi] SET " + " ,[Password] = '" + tbadprov.Password + "'" + " ,[NamaLengkap] = '" + tbadprov.NamaLengkap + "'" + " WHERE [Username] = '" + tbadprov.Username + "'"; DataTable table = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LSPdb"].ConnectionString)) { using (var cmd = new SqlCommand(query, conn)) { using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } } } return("Update Successfully"); } catch (Exception err) { return(err.Message); } }
public string Post(Tb_Admin_Provinsi tbadprov) { try { string query = @" INSERT INTO [dbo].[Tb_Admin_Provinsi] ([Username] ,[Password] ,[NamaLengkap]) VALUES" + " ('" + tbadprov.Username + "','" + tbadprov.Password + "','" + tbadprov.NamaLengkap + "')"; DataTable table = new DataTable(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LSPdb"].ConnectionString)) { using (var cmd = new SqlCommand(query, conn)) { using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(table); } } } return("Insert Successfully"); } catch (Exception err) { return(err.Message); } }