convert excel to xml file

[binny]

i use jet engine ,and oledb database but with this i get four errors which r compile time errores,plz help me to solve these errors
i wrote this programe bt it is not working .
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
using System.Data.Ole Db;
using System.Net.Secu rity;

public class oledbcon :System.Web.UI. Page
{

public static void main()
{

string connectionstrin g = " provider=micros oft.jet.oledb.4 .0;" & "data source=" & country - State.xml & ";" & "extended properties = excel 8.0;hdr=yes; imex=1;";
OleDbConnection objconnection = new OleDbConnection (connectionstri ng);
objconnection.O pen();
OleDbCommand objcmdselect=ne w OleDbCommand("s elect * from [sheet1$]",objconnection );
OleDbDataAdapte r objadapter1=new OleDbDataAdapte r();
objadapter1.Sel ectCommand=objc mdselect;
DataSet objdataset1=new DataSet();
objadapter1.Fil l(objdataset1);
objconnection.C lose();


}
}


errors:
1'.ASP.default_ aspx.GetTypeHas hCode()': no suitable method found to override
'2.ASP.default_ aspx.ProcessReq uest(System.Web .HttpContext)': no suitable method found to override

3'ASP.default_a spx' does not implement interface member 'System.Web.IHt tpHandler.IsReu sable'

4ake sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl).

[radcaesar]

The following three things need to be done.

(a)

OLD: <%@ Page Language="C#" CompileWith="De fault.aspx.cs" ClassName="Defa ult_aspx" %>
NEW: <%@ Page Language="C#" codefile="Defau lt.aspx.cs" Inherits="Defau lt_aspx" %>

(b) In your ASPX.CS source file:

OLD: public partial class Default_aspx
NEW: public partial class Default_aspx : Page

(c)

OLD: sCallBackFuncti onInvocation = this.GetCallbac kEventReference (this, "message", "ShowServerTime ", "context", "OnError");

NEW: sCallBackFuncti onInvocation = Page.ClientScri pt.GetCallbackE ventReference(t his, "message", "ShowServerTime ", "context", "OnError", false);

:)

[binny]

i write a code to convert excel to xml.
bt in this xml every time main tag closed
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
using System.Data.Ole Db;
using System.Xml;
using System.Xml.XPat h;

public partial class _Default : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
string st = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" + Server.MapPath( "countries-file.xls") + ";Extended Properties=Exce l 8.0; ";
OleDbDataAdapte r adp = new OleDbDataAdapte r("SELECT * FROM [Sheet1$]", st);
adp.TableMappin gs.Add("Table", "word");
DataSet ds = new DataSet();

adp.Fill(ds);
//XmlDataDocument doc=new XmlDataDocument (ds);
//doc.Save(Consol e.Out);

GridView1.DataS ource = ds;
GridView1.DataB ind();




out put it shows:
<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<Table>
<COUNTRY>Canada </COUNTRY>
<STATE>Albert a </STATE>
<CITY>Airdrom e</CITY>
</Table>
<Table>
<CITY>Calgary </CITY>
</Table>
<Table>
<CITY>Camrose </CITY>
</Table>
<Table>
<CITY>Canmore </CITY>
</Table>
<Table>
<CITY>Didzbur y</CITY>
</Table>
<Table>
<CITY>Drayton Vally</CITY>
</Table>
<Table>
<CITY>Edmonto n</CITY>
</Table>
bt i want
table tag closed only once at last
plz help me how iit is done

[binny]

i write a code to convert excel to xml.
bt in this xml every time main tag closed
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
using System.Data.Ole Db;
using System.Xml;
using System.Xml.XPat h;

public partial class _Default : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
string st = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" + Server.MapPath( "countries-file.xls") + ";Extended Properties=Exce l 8.0; ";
OleDbDataAdapte r adp = new OleDbDataAdapte r("SELECT * FROM [Sheet1$]", st);
adp.TableMappin gs.Add("Table", "word");
DataSet ds = new DataSet();

adp.Fill(ds);
//XmlDataDocument doc=new XmlDataDocument (ds);
//doc.Save(Consol e.Out);

GridView1.DataS ource = ds;
GridView1.DataB ind();




out put it shows:
<?xml version="1.0" standalone="yes "?>
<NewDataSet>
<Table>
<COUNTRY>Canada </COUNTRY>
<STATE>Albert a </STATE>
<CITY>Airdrom e</CITY>
</Table>
<Table>
<CITY>Calgary </CITY>
</Table>
<Table>
<CITY>Camrose </CITY>
</Table>
<Table>
<CITY>Canmore </CITY>
</Table>
<Table>
<CITY>Didzbur y</CITY>
</Table>
<Table>
<CITY>Drayton Vally</CITY>
</Table>
<Table>
<CITY>Edmonto n</CITY>
</Table>
bt i want
table tag closed only once at last
plz help me how iit is done