void GridBinder()
{
string strCon = ConfigurationSettings.AppSettings["ConnStr"];
SqlConnection objConn = new SqlConnection(strCon);
string mySelectQuery = "SELECT Rname,rank,CAST(rank/"+ "(select cast(sum(rank) as float) from tblpoll) AS NUMERIC(5,2)) as Percentage from tblpoll";
/*"SELECT RName,Rank,"+ "(cast (rank as float) * 100/"+ "(SELECT CAST(sum(rank) AS FLOAT )from tblpoll AS NUMERIC(3,2) )"+ " as Percentage FROM tblPoll)"; */
//SELECT CAST(rank/(select cast(sum(rank)
//as float) from tblpoll) AS NUMERIC(5,2)) as rank from tblpoll
SqlCommand myCommand = new SqlCommand(mySelectQuery,objConn);
objConn.Open();
SqlDataReader myReader;
myReader = myCommand.ExecuteReader();
DataGrid1.DataSource = myReader;
DataGrid1.DataBind();
}