public DataSet BindGrid(PL_PayPostingRegister plobj) { DL_PayPostingRegister objdl = new DL_PayPostingRegister(); DataSet ds = new DataSet(); if (plobj.Ind == 0) { return(ds); } else { ds = objdl.BindGrid(plobj); return(ds); } }
internal DataSet BindGrid(PL_PayPostingRegister plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SpPayPostingRegister", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@Edcdind", plobj.Edcdind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); return(ds); } catch { return(ds); } finally { con.Close(); con.Dispose(); } }