//public DataTable GetZerolevelProcess(PL_ApplicationProgress pl) //{ // SqlCommand cmd = new SqlCommand("SPApplicationEntry", con); // cmd.CommandType = CommandType.StoredProcedure; // SqlDataAdapter ad = new SqlDataAdapter(); // DataTable dt = new DataTable(); // ad.Fill(dt); // return dt; //} public DataTable GetZerolevelProcess(PL_ApplicationProgress pl) { SqlCommand cmd = new SqlCommand("SPApplicationEntry", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter ad = new SqlDataAdapter(); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }
//for entry process public DataSet GetEntryProcess(PL_ApplicationProgress pl) { DataSet ds = new DataSet(); try { SqlCommand cmd = new SqlCommand("SPApplicationEntry", con); cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID); cmd.Parameters.AddWithValue("@Ind", pl.Ind); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(ds); } catch (Exception ex) { msg = ex.Message; } return(ds); }