private void BindGrid() { OracleQuery2 cc2 = new OracleQuery2(); DataTable dt = cc2.LoadAdmin(); SQLServerQuery ss = new SQLServerQuery(); string result = ""; foreach (DataRow r in dt.Rows) { result = result + r["EMPLOYEE_ID"].ToString() + ","; } result = result.TrimEnd(','); DataTable dt_pis = ss.LoadINPIS("", result); DataTable Final_result = new DataTable(); Final_result.Columns.Add("EMPLOYEE_ID"); Final_result.Columns.Add("FULLNAMETH"); Final_result.Columns.Add("POSNAME"); Final_result.Columns.Add("UNITNAME"); Final_result.Columns.Add("IS_ADMIN"); if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0) { var results = from table1 in dt.AsEnumerable() join table2 in dt_pis.AsEnumerable() on table1["EMPLOYEE_ID"].ToString() equals table2["P_ID"].ToString() select new { EMPLOYEE_ID = table1["EMPLOYEE_ID"].ToString(), FULLNAMETH = table2["FULLNAMETH"].ToString(), POSNAME = table2["POSNAME"].ToString(), unitname = table2["unitname"].ToString(), is_admin = table1["IS_ADMIN"].ToString() == "1"?"ADMIN":"USER" }; foreach (var item in results) { Final_result.Rows.Add(item.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.is_admin); } } AdminGridView.DataSource = Final_result; AdminGridView.DataBind(); }