public DataTable ProfileDelete(PL_ProfileCreation ObjPlProfile) { //ObjPlProfile.UserTypeId = UserTypeID; //ObjPlProfile.Ind = Ind; //ObjPlProfile.ItemId = ItemId; DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter(); dt = ObjDlProfile.ProfileDelete(ObjPlProfile); return(dt); }
public DataTable ShowProfile(PL_ProfileCreation ObjPlProfile) { DataTable dt = new DataTable(); // int i=0; try { cmd = new SqlCommand("SpProfileCreation", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", ObjPlProfile.Ind); con.Open(); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); // cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { msg = ex.Message; } return(dt); }