public string Put(Tb_Jejaring tbjejaring) { try { string query = @" UPDATE [dbo].[Tb_Jejaring] SET" + " ,[Nomer_Lisensi] = '" + tbjejaring.Kode_Jejaring + "'" + " ,[Kode_KK_Terlisensi] = '" + tbjejaring.Kode_KK_Terlisensi + "'" + " ,[NPSN] = '" + tbjejaring.NPSN + "'" + " WHERE [Kode_Jejaring] = '" + tbjejaring.Kode_Jejaring + "'"; 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_Jejaring tbjejaring) { try { string query = @" INSERT INTO [dbo].[Tb_Jejaring] ([Kode_Jejaring] ,[Nomer_Lisensi] ,[Kode_KK_Terlisensi] ,[NPSN]) VALUES" + "('" + tbjejaring.Kode_Jejaring + "','" + tbjejaring.Nomer_Lisensi + "','" + tbjejaring.Kode_KK_Terlisensi + "','" + tbjejaring.NPSN + "')"; 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); } }