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

5-Jul-06 23:29

blurMember wrote:
And I think I never populate it on postback. It may sound simple to you, but how do I go about doing that?

It means, in the first form frm_First, you normally populate the datasource to bind to the dgDisplay datagrid only for the first time, but here you need to access this datasource in the second form with the Server.Transfer method when the button is clicked, you need to populate the datasource in the frm_First again. In a short answer, you need make sure that the GridData property is assigned a value in the first form so that you can access it in the second form after the Server.Transfer method executes. If you still don;t understand, you can post your sample code in the first form, I'll point out your issue.

minhpc_bk6-Jul-06 0:06

6-Jul-06 0:06

blurMember wrote:
this.dgDisplay.DataSource=ds;
this.GridData = this.dgDisplay.DataSource;
this.dgDisplay.DataBind();

That's enough. So here you populate the dataset ds and bind it to the grid control in the ShowAllWeek method, you then assign the datagrid's DataSource property to the GridData property of the web page, and I think that the ShowAllWeek does not execute when you hit the button. To fix this code, I suggest you saparate to your code to populate the dataset object in a seperate method, say BuildDataSource, which returns the result populated dataset ds. In the Page_Load of the first form, you can write your code like this:

 private void Page_Load(object sender, System.EventArgs e)
{
    DataSet ds = BuildDataSource();
    this.GridData = ds;

    //You may only need to bind ds to the grid just one time:
    if(!IsPostBack())
    {
         this.dgDisplay.DataSource=ds;
         this.dgDisplay.DataBind();
    }
}

blurMember9-Jul-06 17:18

9-Jul-06 17:18

Thank you very much for your help. I realised that if I called the function ShowAllWeek from the Page_Load. The datagrid is able to be transfer the information to another webform. I am confused for the reason it happened it that manner.

You mentioned earlier about BuildDataSource(). Is this correct?

public BuildDataSource()<br />
{<br />
    DataSet ds = new DataSet();<br />
    this.dgDisplay.DataSource=ds;<br />
    this.GridData = this.dgDisplay.DataSource;<br />
    this.dgDisplay.DataBind();<br />
}

I know I am extremely weak.

thanks in advance. Much appreciated.

minhpc_bk10-Jul-06 19:56

String from and to a class

10-Jul-06 19:56

blurMember wrote:
I realised that if I called the function ShowAllWeek from the Page_Load. The datagrid is able to be transfer the information to another webform. I am confused for the reason it happened it that manner.

It's simple, calling the ShowAllWeek method in the Page_Load makes sure that the you bind the datasource again to the grid, and the GridData is assigned the value also.

oskardiazdeleon5-Jul-06 14:12

oskardiazdeleon

5-Jul-06 14:12

I have 2 forms. I am using form1 as my parent and form2 as a child form. I also have a class (clBuffer) name of my class. In my class(clBuffer.cs) i have 4 strings. How do I send value to those strings from parent class, and how do I read them from the child class?

Thanks

Re: String from and to a class

minhpc_bk5-Jul-06 16:17