ASP.NET

Re: Displaying Sql Data As Xml

5-Jul-06 16:10

+ Use the DataSet.GetXml[^] method to get data stored in the dataset in xml format.
+ Write out the result to the outputstream of the Response object, you may also sepcify the ContentType of the output as text/xml.

teejayem5-Jul-06 16:28

teejayem

5-Jul-06 16:28

thanks man i appreciate it

Don't be overcome by evil, but overcome evil with good

Transfer of datagrid to another webform [modified]

blurMember5-Jul-06 15:23

5-Jul-06 15:23

Hi! I want to do a report generation, when the user click the view report button, the datagrid will be transfered to another webform in C#.

I am using code behind. Here is the partial code for frm_First.aspx.cs. (Assuming I have connected the database to the datgrid)

<code>private void display()
{
..........
this.GridData = this.dgDisplay.DataSource;
..........
}
private void btnReport_Click(object sender, System.EventArgs e)
{
Server.Transfer("frm_Report.aspx");
}
public object GridData
{
set
{
this.gridData = value;
}
get
{
return this.gridData;
}
}

Whereas at the frm_Report,

namespace project
{
public class frm_Report : System.Web.UI.Page
{
......................
project.frm_First objSendingPage;

private void Page_Load(object sender, System.EventArgs e)
{
this.objSendingPage = new frm_First();
receivingDG.DataSource = objSendingPage.GridData;
receivingDG.DataBind();
}
}</code>

thanks in advance. Much appreciated.

-- modified at 21:24 Wednesday 5th July, 2006

minhpc_bk5-Jul-06 16:04

5-Jul-06 16:04

blurMember wrote:
this.objSendingPage = new frm_First();

To get reference to the source page, you basically cast the Context.Handler to the source page type. In the ASP.NET 2.0, you can use the Page.PreviousPage property.

blurMember5-Jul-06 19:14

5-Jul-06 19:14

Is the method like this?

private void Page_Load(object sender, System.EventArgs e) <br />
{<br />
// Put user code to initialize the page here<br />
	if (!IsPostBack) <br />
	{<br />
	    <br />
	}<br />
            objSendingPage = ((frm_ShowAttd)(Context.Handler));<br />
            this.objSendingPage = new frm_ShowAttd();<br />
	    receivingDG.DataSource = objSendingPage.GridData;<br />
	    receivingDG.DataBind();<br />
}

thanks in advance. Much appreciated.

minhpc_bk5-Jul-06 19:54

Re: Transfer of datagrid to another webform [modified]

5-Jul-06 19:54

blurMember wrote:
objSendingPage = ((frm_ShowAttd)(Context.Handler));
//this.objSendingPage = new frm_ShowAttd();
receivingDG.DataSource = objSendingPage.GridData;
receivingDG.DataBind();

You should comment out the second line as it initializes a new object.

blurMember5-Jul-06 20:34

5-Jul-06 20:34

Thanks. I have deleted the second line. But the same problem occur. The frm_Report stubborn to display the data in the datagrid. Have I done something wrong?

namespace project<br />
{<br />
public class frm_Report : System.Web.UI.Page<br />
{<br />
       ......................<br />
       project.frm_First objSendingPage;<br />
<br />
private void Page_Load(object sender, System.EventArgs e) <br />
		{<br />
			// Put user code to initialize the page here<br />
			if (!IsPostBack) <br />
			{<br />
			}<br />
			objSendingPage = ((frm_ShowAttd)(Context.Handler));<br />
			receivingDG.DataSource = objSendingPage.GridData;<br />
			receivingDG.DataBind();<br />
}

The code at the frm_First.aspx.cs remain the same:
namespace project
{
public class frm_First : System.Web.UI.Page
{
.............
private object gridData;
}
......
}
Followed by the earlier code I commented.

thanks in advance. Much appreciated.

-- modified at 2:35 Thursday 6th July, 2006

minhpc_bk5-Jul-06 20:44

5-Jul-06 20:44

blurMember wrote:
But the same problem occur.

+ What is the problem? You didn't mention it IIRC.
+ How do you set the GridData property in the source page?
+ You can debug your application and step through your code in the Page_Load event handler.

blurMember5-Jul-06 21:41

5-Jul-06 21:41

+ What is the problem? You didn't mention it IIRC.
The problem is when I click the btnReport, the frm_Report page retrieves blank.
+ How do you set the GridData property in the source page?
Set the GridData? Like this? (Refer below)

public object GridData <br />
		{<br />
			set<br />
			{<br />
				this.gridData = value; <br />
			}<br />
			get <br />
inside a dataset<br />
				return this.gridData;<br />
			}<br />
		}

thanks in advance. Much appreciated.

minhpc_bk5-Jul-06 22:27

5-Jul-06 22:27

blurMember wrote:
the frm_Report page retrieves blank.

Looks like the datasource bound to the grid control is empty (or null).

blurMember wrote:
Set the GridData? Like this? (Refer below)
public object GridData
{
set
{
this.gridData = value;
}
get
inside a dataset
return this.gridData;
}
}

No, I mean how do you set the GridData property (or the gridData instance) in the source page? Do you populate it on postback when the button is clicked? If you don't, the property will be empty, and the grid will display nothing on the web page.

blurMember5-Jul-06 23:16

5-Jul-06 23:16

Sorry I don't understand. I don't think I set the GridData property. And I think I never populate it on postback. It may sound simple to you, but how do I go about doing that?

thanks in advance. Much appreciated.

minhpc_bk5-Jul-06 23:29