Gridview не загружает - связывает таблицу из 2 баз данных

---

Gridview Не Показывается.


1. Данные поступают из 2 баз данных WHR & WPAY

protected void Page_Load(object sender, EventArgs e)
{

///Load Begin
if (!IsPostBack)
{
try
{

txt_Run_Date.Text = DateTime.Now.Date.ToString("dd MMM yyyy");


SqlConnection connect = new SqlConnection();
connect.ConnectionString = ConfigurationManager.ConnectionStrings["WEBPAY"].ConnectionString;
connect.Open();

SqlDataAdapter da = new SqlDataAdapter("select * FROM pycntrun where runyear*100000+runmonth=(select max(runyear*100000+runmonth) from pycntrun)", connect);

DataSet ds = new DataSet();
da.Fill(ds, "PYCN");

txt_Period.Text = ds.Tables["PYCN"].Rows[0]["RUNMONTH"].ToString();
txt_Year.Text = ds.Tables["PYCN"].Rows[0]["RUNYEAR"].ToString();

lblReport.Text = ds.Tables["PYCN"].Rows[0]["LOANRUN"].ToString();


if (lblReport.Text == "YES")
{
lblReport.Text = "Loan Processing For This Month Done";
// btn_Process.Enabled = false;
}
else
{
lblReport.Text = "Loan Processing Yet To Be Run";
}

connect.Close();


GridView1.SelectedIndexChanged += new EventHandler(GridView1_SelectedIndexChanged);


SqlConnection ccc = new SqlConnection();
connect.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
connect.Open();


SqlDataAdapter daas = new SqlDataAdapter(@"Select IDNO,EMPNO,FNAME,LNAME,DEPTNAME from WHR.dbo.PAYMAST
where WHR.dbo.PAYMAST.IDNO not in
(select idno from WPAY.dbo.Paycurrt)", ccc);


DataSet dsas = new DataSet();
daas.Fill(dsas, "Paycurrt");
GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();

lblstatus.Text = "Record Load successful";
connect.Close();

GridView1.SelectedIndexChanged += new EventHandler(GridView1_SelectedIndexChanged);


}
catch (Exception ex)
{
lblstatus.Text = ex.Message;
}

}

Как мне загрузить GRIDVIEW ?

Спасибо

Что я уже пробовал:

Oongoing developmental Challenge требует помощи

---