How can i bind the Data at a time

See more:

C#

ASP.NET

C#4.0

Hi,

This is my code , what is my question on each and every row of grid this lines of codeis executed , but depend upon the highleted lines code the browser performence is decresed. for that i want to load that total information at a time , and then i want to check my condition how can i do this.

protected void gdDocument_ItemDataBound(object sender, DataGridItemEventArgs e)
{
   if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType==                         ListItemType.AlternatingItem)
   {
           string Doc_Id = ((Label)e.Item.FindControl("lblDrawing")).Text;
           string Revision = ((Label)e.Item.FindControl("lblRev")).Text;
        string Query = "<Where>" +
       "<And><Eq><FieldRef Name='Dwg_No'/><Value Type='Text'>" + Doc_Id + "</Value></Eq>" +
"<Eq><FieldRef Name='Dwg_Rev_No'/><Value Type='Text'>" + Revision + "</Value></Eq></And>" +
"</Where>";

        DataTable dtDrawing = objFile.ListContent(objCurrentSite.SiteURL, objCurrentSite.WebSiteName, "Drawing", Query);}
}