private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
if (!Page.IsPostBack )
{
BindData ();
}
}
DataSet ds = new DataSet ();
void BindData()
{
string sqlStmt = "Select * from ChemicalFormula ";
string conString = "server=localhost;database=Northwind;uid=sa;pwd=;";
SqlDataAdapter myda = new SqlDataAdapter(sqlStmt, conString);
myda.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}
protected string GetProperFormat(string fldval)
{
string strval="" ;
//Navigate through every character of the fldval
for(int i = 0;i< fldval.Length ;i++)
{ //Check for IF the value is numeric True/False
if(Char.IsNumber (fldval[i] ))
{
strval = strval + "<sub>" + fldval[i] + "</sub>";
}
else
{
strval = strval + fldval[i];
}
}
return strval;
}