public DataSet BindLocalBodyDAL(frmDownloadSRateBAL objBAL) { cmd = new SqlCommand(); cmd.CommandText = "uspBindLocalBodyDistrictWise"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add("@distID", SqlDbType.Int).Value = objBAL.DistID; DataSet ds = new DataSet(); da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); }
public DataSet BindStandardRates(frmDownloadSRateBAL objBAL) { DataSet ds = new DataSet(); try { cmd = new SqlCommand(); cmd.CommandText = "uspDownloadStandardRatesByLocalBody"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add("@LocalBodyID", SqlDbType.Int).Value = objBAL.LocalBodyId; da = new SqlDataAdapter(cmd); da.Fill(ds); return(ds); } catch { return(ds); } }