Dataset DS = new dataset ();
Sqldataadapter da = new sqldataadapter ();
Int Gg = da. Fill (DS, "TB ");
DS = ds_up (DS, GG );
Public dataset ds_up (system. Data. dataset DSS, int GC)
{
Dataset dd = DSS;
For (INT I = 0; I <GC; I ++)
{
If (DD. Tables ["TB"]. Rows [I] ["membership level"]. tostring () = "")
{Dd. Tables ["TB"]. Rows [I] ["membership level"] = "15 ";}
Else if (DD. Tables ["TB"]. Rows [I] ["membership level"]. tostring () = "B ")
{Dd. Tables ["TB"]. Rows [I] ["membership level"] = "30 ";}
Else if (DD. Tables ["TB"]. Rows [I] ["membership level"]. tostring () = "C ")
{Dd. Tables ["TB"]. Rows [I] ["membership level"] = "45 ";}
Else if (DD. Tables ["TB"]. Rows [I] ["membership level"]. tostring () = "D ")
{Dd. Tables ["TB"]. Rows [I] ["membership level"] = "60 ";}
Else if (DD. Tables ["TB"]. Rows [I] ["membership level"]. tostring () = "e ")
{Dd. Tables ["TB"]. Rows [I] ["membership level"] = "75 ";}
}
Return dd;
}