June 28th, 2001, 01:54 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
how to display data & xml file simultaneously
<i><b>Originally posted by : vivek (vivek_68@usa.net)</b></i><br />Friends..<br />i am using 2 tables with same field name & same data types.<br />Data of first table,i stored in xml form.<br />So, i want to retrieve data...just like UNION form in SQL.<br />Codes are :<br /> <script language="C#" runat="server" ><br />SQLConnection myConnection;<br /><br />protected void Page_Load(Object Src, EventArgs E)<br />{<br /><br /> DataSet ds=new DataSet();<br /> myConnection = new SQLConnection("server=vivek;uid=sa;pwd=;database=aptech");<br /> string sCommand = "SELECT title,dob,gender FROM trial";<br /> SQLDataSetCommand DSCmd = new SQLDataSetCommand(sCommand,myConnection);<br /> DSCmd.FillDataSet(ds,"trial");<br /><br /> DataSet ds=new DataSet();<br /> FileStream fstream = new FileStream(Server.MapPath("/vivek_port81/vivdata1.xml"),FileMode.Open,FileAccess.Read);<br /> StreamReader xmlstream=new StreamReader(fstream);<br /> ds.ReadXml(xmlstream);<br /> fstream.Close();<br />DataGrid1.DataSource=ds.Tables[0].DefaultView;<br />DataGrid1.DataSource=ds.Tables[1].DefaultView;<br />DataGrid1.DataBind();<br />}<br /><br /></script><br /><body><br /><form runat="server"><br /><asp  ataGrid id="DataGrid1" runat="server"/><br /></form><br /></body><br /></html><br /><br /><br />O/p of this display only one table at a time...& i want to display both How?????<br />please help<br />
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
