public string eliminar(DPresentacion presentacion) { string rpts = ""; SqlConnection consql = Conexion.conexion(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = consql; cmd.CommandText = "speliminar_presentacion"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idpresentacion", idpresentacion); cmd.ExecuteNonQuery(); } catch (Exception ex) { rpts = ex.Message; } return(rpts); }
public string editar(DPresentacion presentacion) { string repuesta = ""; SqlConnection sqlcon = Conexion.conexion(); try { SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "speditar_presentacion"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@idpresentacion", idpresentacion); sqlcmd.Parameters.AddWithValue("@nombre", nombre); sqlcmd.Parameters.AddWithValue("@descripcion", descripcion); sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { repuesta = ex.Message; } return(repuesta); }
public DataTable buscarnombre_presentacion(DPresentacion presentacion) { DataTable ap = new DataTable("presentacion"); SqlConnection con = new SqlConnection(); try { con.ConnectionString = Conexion.cadena; SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = con; sqlcmd.CommandText = "spbuscar_presentacion"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@textobuscar", textobuscar); SqlDataAdapter sqldat = new SqlDataAdapter(sqlcmd); sqldat.Fill(ap); } catch (Exception) { ap = null; } return(ap); }