public SqlDataAdapter procExecRead1(string procName) { dt = new DataTable(); SqlCommand com = new SqlCommand(procName, con); com.CommandType = CommandType.StoredProcedure; dr = com.ExecuteReader(); dt.Load(dr); da.Fill(dt); return da; }