public string eliminar_proveedor(DProveedor proveedor) { string respuesta = ""; SqlConnection sqlcon = Conexion.conexion(); try { SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "speliminar_proveedor"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@idproveedor", id_proveedor); sqlcmd.ExecuteNonQuery(); } catch (Exception ex) { respuesta = ex.Message; } return(respuesta); }
public DataTable buscar_num_documento(DProveedor proveedor) { DataTable dt = new DataTable("proveedor"); SqlConnection sqlcon = new SqlConnection(); try { sqlcon.ConnectionString = Conexion.cadena; SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "spbuscar_proveedor_num_documento"; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@textobuscar", textobuscar); SqlDataAdapter sqldat = new SqlDataAdapter(sqlcmd); sqldat.Fill(dt); } catch (Exception) { dt = null; } return(dt); }