ASP.NET

Mark Churchill16-Aug-07 21:28

Mark Churchill

16-Aug-07 21:28

If you want to do it using AJAX then grab the framework from ajax.asp.net. Then you just have to drop an updatepanel around what you want to update and a timer to trigger it.

Mark Churchill
Director
Dunn & Churchill

anu8116-Aug-07 21:37

anu81

16-Aug-07 21:37

hi mark,

thanks for your reply. I thought using ajax will stop refreshing the page.Can i implement the same without using ajax? if it is possible,

can you please help me with some samples?

Thanks again Smile | :)

Regards

Anuradha

Michael Sync16-Aug-07 22:03

Michael Sync

16-Aug-07 22:03

With ASP.NET Ajax extension, there are two important controls called "Update Panel" and "Timer".

1. Add the UpdatePanel control to your page.
2. Add Timer control (this control from Ajax extension. not windows timer.)
3. In Tick event of timer, do the updating your page.

I saw like that one in ASP.NET Forum.
Check-out this.

http://forums.asp.net/p/1118294/1740340.aspx

Hope it helps.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

N a v a n e e t h16-Aug-07 22:34

N a v a n e e t h

16-Aug-07 22:34

anu81 wrote:
Can i implement the same without using ajax? if it is possible,

You can put the items that needs to be refreshed in seperate frame (IFrame) and reload the frame using javascript.

My Website | Ask smart questions

My page change event does not fire for first page.

S A R I T H16-Aug-07 21:37

S A R I T H

16-Aug-07 21:37

Use atlas framework and use ajax enabled controls like UpdatePanel

Sarith...

Anees Mitha16-Aug-07 21:09

Anees Mitha

16-Aug-07 21:09

Hi,

I am having a really wierd problem. My page change event does not fire for my first page. Whenever i click on page 1 from any page the page change event does not fire. But when i click on other pages the event is fired properly.

Following is the code.

Since i am generating the Bound columns dynamically i am calling the getdata() method in OnInit in order to avoid
eventvalidation problem.

public partial class User_Control_Generic_Grid_ctlGenDGSelecttest : System.Web.UI.UserControl
{

string ReportDetails = string.Empty;

protected string MyData
{
get { return Request.Form[getClientName(this.txtRptDetails)]; }
set { txtRptDetails.Text = value; }
}

String getClientName(Control ctrl)
{
String result = ctrl.ClientID.Replace("_", "$");
return (result);
}

protected override void OnInit(EventArgs e)
{

if (IsPostBack)
{

getdata();
}

}

protected void Page_Load(object s, EventArgs e)
{
if (!IsPostBack)
{
string ReportParams = (string)Context.Items[ReportConstants.ReportParams];

//Setting DataKeyField Value
string ReportName = string.Empty;

string[] rptDetails = ReportParams.Split('|');

int ParamCount = (ReportParams.Split('|').Length) - 1;
for (int i = 0; i <= ParamCount; i++)
{
string[] ParamsRpt = rptDetails[i].Split('=');

if (ParamsRpt[0] == ReportConstants.ReportName)
{
ReportName = ParamsRpt[1];
}

}

SqlConnection conSQL = new SqlConnection("server=test;uid=sa;pwd=password;database=northwind");

SqlCommand cmdSelect = new SqlCommand("WebGetReportDetails", conSQL);
cmdSelect.CommandType = CommandType.StoredProcedure;
cmdSelect.Parameters.Add(new SqlParameter("@ReportName", ReportName));

DataSet dstProducts = new DataSet();
SqlDataAdapter aptrProducts = new SqlDataAdapter(cmdSelect);

aptrProducts.Fill(dstProducts);

txtRptDetails.Text = ReportParams;
ReportDetails = ReportParams;

getdata();

}

}

public virtual void PageIndexChanged_GridView(object s, DataGridPageChangedEventArgs e)
{

DataGrid gv = (DataGrid)s;
gv.CurrentPageIndex = e.NewPageIndex;
getdata();

}

public void getdata()
{
DataSet ds = new DataSet();

string rptDetailstxt = this.MyData;
if (rptDetailstxt == null)
{
rptDetailstxt = txtRptDetails.Text;
}

GridReports objBO = new GridReports();
ds = (DataSet)objBO.GridData(rptDetailstxt);

foreach (DataColumn c in ds.Tables[0].Columns)
{
grdvwCheckbox.Columns.Add(CreateBoundColumns(c));
}

grdvwCheckbox.DataSource = ds;
grdvwCheckbox.DataBind();

}

public BoundColumn CreateBoundColumns(DataColumn c)
{
BoundColumn column = new BoundColumn();
column.DataField = c.ColumnName;
column.HeaderText = c.ColumnName.Replace("_", " ");
column.DataFormatString = setFormating(c);
column.ItemStyle.Wrap = false;

return column;
}

private string setFormating(DataColumn bc)
{
string dataType = null;
switch (bc.DataType.ToString())
{
case "System.Int32":
dataType = "{0:#,###}";
break;
case "System.Decimal":
dataType = "{0:c}";
break;
case "System.DateTime":
dataType = "{0:dd-mm-yyyy}";
break;
case "System.String":
dataType = "";
break;
default: dataType = "";
break;
}
return dataType;
}
}

Please feel free to revert in case of any clarification.

Thanks!

Regards,
Anees

Re: My page change event does not fire for first page.

VanithaVasu16-Aug-07 22:39

VanithaVasu

16-Aug-07 22:39

Page_Init is for only initialisation purpose. We have to initalise the components which should be displayed on page_Load.

I have initalised all the components used in the page load. But i dont know how to proceed.

Since i am also having the same problem,if you got the solution please give the solution which will me very useful for me.

VanithaVasu

Re: My page change event does not fire for first page.

N a v a n e e t h16-Aug-07 23:55

N a v a n e e t h

16-Aug-07 23:55

VanithaVasu wrote:
Page_Init is for only initialisation purpose. We have to initalise the components which should be displayed on page_Load.

If your controls are dynamically created and you want to persist the value on postbacks, you need to create it on Init event. Then only ASP.NET will maintain viewstate for that.

My Website | Ask smart questions

Re: My page change event does not fire for first page.

N a v a n e e t h16-Aug-07 23:52

N a v a n e e t h

16-Aug-07 23:52

Anees Mitha wrote:
Whenever i click on page 1 from any page the page change event does not fire. But when i click on other pages the event is fired properly.

What is page change event ? I have not heard anything like that. Please make your question more clear.

My Website | Ask smart questions

Re: My page change event does not fire for first page.

Anees Mitha17-Aug-07 0:18

Anees Mitha

17-Aug-07 0:18

Sorry its PageIndexChanged event.

Re: My page change event does not fire for first page.

Anees Mitha17-Aug-07 0:59

Anees Mitha

17-Aug-07 0:59

Hi,

I got the solution. Not sure how it worked but when i changed enableviewstate from True to False, every thing is working properly.

Thanks for all the help.

Regards,
Anees

Html to Xml Conversion and viceversa

ayurhdfkl16-Aug-07 21:01

ayurhdfkl

16-Aug-07 21:01

Please help me by sending the sample codes of how to convert html(Usually a normal html page in the current project) to xml and store it in sqlserver2005 as xmldatatype and then convert back to html as a different page when clicking a button.

daniel__c16-Aug-07 21:08

daniel__c

16-Aug-07 21:08

You could try:

http://www.codeplex.com/htmlagilitypack[^]

There are some sample projects included, one of them will take a html page and return valid xml.

ayurhdfkl16-Aug-07 21:14

ayurhdfkl

16-Aug-07 21:14

I tried that link, But didnt help me , mainly because my html page lies within my project, but in the link the method given is using html pages of some other domain. But thx for the reply

daniel__c16-Aug-07 21:21

daniel__c

16-Aug-07 21:21

You would need to download the project and check out some of the samples to confirm, but i believe that you can easily create an xml document from just a string (i.e. read the contents of your file into a string) containing html.

How to clear browser's Cache.

ayurhdfkl16-Aug-07 22:54

ayurhdfkl

16-Aug-07 22:54

Yes, I have tried downloading those files.But there is no option for adding files from working project, it requires other webpages with IP addrss.

naresh51116-Aug-07 20:52

naresh511

16-Aug-07 20:52

Hi,
I am developing a Web application in ASP.NET 2.0 and having a "Signout" hyperlink on my top user control. When a logged user clicks on signout I simply clears all sessions and redirect user to my login page. The problem is that the user can still view the last page by using browser's back button. At this moment the page doesn't reload bcoz it is already in browser's cache. I just want to disable this back button (I know that this exactly is not possible) but alternatively I can clear browsers history and its cache. I already tried a lot of javascripts like window.history and all but of no use. Please correct where i am going wrong. An alternate solution is to close current browser and open a new fresh one with my homepage (so that back/forward buttons will be disabled initially) but I am unable to do this.
On Signout in codebehind I am doing this:

:-OSession.Clear();
Session.Abandon();
FormsAuthentication.SignOut();
Response.Expires = 0;
Response.Cache.SetNoStore();
Response.AppendHeader("Pragma", "no-cache");
Response.Redirect("Homepage.aspx"); Blush | :O

I also tried this Javascript but of no use:

Blush | :O

Session.Clear();
Session.Abandon();
FormsAuthentication.SignOut();
Response.Write("");

Response.Write("{");
Response.Write(" var Backlen=history.length;");

Response.Write(" history.go(-Backlen);");
Response.Write(" window.location.href='" + nextpage + "'; ");

Response.Write("}");
Response.Write("");

Thanks

Naresh

Display image along with the grid view

Sujit Mandal16-Aug-07 20:38

16-Aug-07 20:38

Hi All,

I am working on an application where I wants to display employee details in GridView. The image of the employee is stored in SQL Server 2005 table as image field . Now I wants to display the data along with the grid so how to display this can anybody help me with code.

Thanks

Regards

Sujit

N a r e s h P a t e l16-Aug-07 20:53

N a r e s h P a t e l

16-Aug-07 20:53

Hi,

First save your image to Sql Server 2005[Database] in Byte Format.And then receive it as a Byte array format at server side. NOw you have to cast this image into Stream and then into write this Stream into another UserControl.

But I am suggesting you not to store Your Image into DataBase, store it into FileSystem.

Naresh Patel

Sujit Mandal16-Aug-07 20:58

16-Aug-07 20:58

Hello

Yes You are right.But This is requirement is like that we have to store 2 images in sql server database.I have stored image in database successfully.I am facing problem in showing this image in gridview.

Sujit

N a r e s h P a t e l16-Aug-07 21:11

N a r e s h P a t e l

16-Aug-07 21:11

Hi Please wait i am giving you the code for it.

Naresh Patel

N a r e s h P a t e l16-Aug-07 23:01

N a r e s h P a t e l

16-Aug-07 23:01

Hi, Please view the atricle for Displaying And Storing Image to Database at

http://www.codeproject.com/useritems/Image.asp

Naresh Patel

Sujit Mandal17-Aug-07 2:47

17-Aug-07 2:47

Hello
Yes yours code is good.i have already done this.only problem i am facing to displaying those images in grid view.i can easily show this in aspx page by retrieving image from sql server.

Sujit

DarynRoberts17-Aug-07 2:36

DarynRoberts

17-Aug-07 2:36

Hey man.
We were having the same problem. Try do this. When you store it in the database...store the full url of where the picture can be found within your project.
For example...our image is stored inside a folder called "Properties" which is inside a folder called "Images"
So it finally worked when we saved it in the DB field as:
~\Images\Properties\officeblock1.jpg
Hope that helps
peace

Dazz

Sujit Mandal17-Aug-07 2:44