ASP.NET

Loading controls on page with UpdatePanel

11-Jun-10 2:28

I found following link useful for exporting formatted data
to excel by little binging.

Simple Way To Export Formatted Data Grid To Excel Sheet[^]

Exporting Data into Excel in Multiple Worksheets[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

HtmlTabHTleRow

siva45511-Jun-10 0:11

siva455

11-Jun-10 0:11

Hi,
how can i merge two colums in a HtmlTableRow using c# code.

Re: HtmlTabHTleRow

saini arun11-Jun-10 3:20

saini arun

11-Jun-10 3:20

Use ColSpan property of HtmlTableCell.

Łukasz Nowakowski10-Jun-10 23:50

Łukasz Nowakowski

10-Jun-10 23:50

I have a page with several controls that are shown or hidden depending on some checkboxes being checked or unchecked by user. The problem is that I have to run some JavaScript function in window load event for each of those controls. When I place those calls in the ascx they aren't called. Also JavaScript functions defined in those controls aren't visible.
Example:

<br />
<%@ Control Language="C#" AutoEventWireup="true" Inherits="SomeControl" CodeBehind="SomeControl.ascx.cs" %><br />
<br />
<script type="text/javascript"><br />
<br />
function test() {<br />
alert('Testing call');<br />
}<br />
</script><br />
<br />
<asp:CheckBox runat="server" Text="Label" onclick="javascript:test();" /><br />

In the above code (when control is loaded to the page with UpdatePanel (on first page call it has Visible = false and on some event Visible is set to true)) clicking checkbox does nothing or in IE8 triggers error, that object was null.

The question: how to register function test in this scenario so it was visible to the browser?

Brij10-Jun-10 23:56

10-Jun-10 23:56

If these controls are in update panel then on setting visibilty true from false only html gets renders not the javascript part.So better to the javascript function in a separet file and include that in page.Now register the startupscript from codebehibd of your control whch you want to be executed when your control loads.

Cheers!!
Brij
Check my latest Article :URL Routing with ASP.NET 4.0

Łukasz Nowakowski11-Jun-10 0:26

Łukasz Nowakowski

11-Jun-10 0:26

Almost... But when I do Page.RegisterStartupScript("scriptName", "function() { runStartupForControl(%arguments%); }"); it's get rendered at the bottom of the page (it isn't placed between "script" tags).

Łukasz Nowakowski11-Jun-10 0:37

Łukasz Nowakowski

11-Jun-10 0:37

OK, I had some errors in code... It works now. Thanks.

Brij11-Jun-10 2:22

Creating foreign key constraints through Sqlcommand.ExecuteNonQuery()

11-Jun-10 2:22

Your Welcome Smile | :)

Cheers!!
Brij
Check my latest Article :URL Routing with ASP.NET 4.0

vishnukamath10-Jun-10 23:28

vishnukamath

10-Jun-10 23:28

I have a set of Sql statements which add a column to the DataBase table and also add a foreign key relationship.The statements execute fine on the sql server where as the same set of statements fail to be executed through the SQlCommand object invoke on a button click on a ASP.NET page.

Please help...below is my code

private void CreateReferenceKey(string parentTableName,string tableName,string refcolumn,string parentRefColumn)
{
StringBuilder refQuery = new StringBuilder();

refQuery.AppendLine(" if NOT EXISTS (select * from information_Schema.columns where table_name='"+tableName +"' and column_name = '"+refcolumn +"') ");
refQuery.AppendLine("BEGIN");
refQuery.AppendLine(" alter table [dbo].[" + tableName + "] add [" + refcolumn + "] smallint NULL ");
refQuery.AppendLine("ALTER TABLE [dbo].[" + tableName + "] WITH CHECK ADD CONSTRAINT [FK_" + parentTableName + "_" + tableName + "] FOREIGN KEY([" + refcolumn + "]) ");
refQuery.Append("REFERENCES [dbo].[" + parentTableName + "] (["+parentRefColumn +"])");

refQuery.AppendLine(" ALTER TABLE [dbo].[" + parentTableName + "] CHECK CONSTRAINT [FK_" + parentTableName + "_" + tableName + "]");
refQuery.AppendLine("END");
SqlCommand command = null;
SqlConnection connection = new SqlConnection(connString);
command = new SqlCommand(refQuery.ToString(), connection);
connection.Open();

command.ExecuteNonQuery();
connection.Close();
}

Re: Creating foreign key constraints through Sqlcommand.ExecuteNonQuery()

Peace ON11-Jun-10 0:00

How display Custom Error Page when Javascript Page redirect fails

11-Jun-10 0:00

You can do the same by developing generalized SP.

Pass TableName, ColumnName and Type to add that particular
Column to the specified table.

And also do the same for adding constraint.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Fusion Chart

KhandelwalA10-Jun-10 22:47

KhandelwalA

10-Jun-10 22:47

I have created fusion chart from xml in asp.net.

If i want to create child values in a fusion a chart.Suppose i want to show the students of respective class then i can use simple chart and in this chart if I want to show number of boys and girls for respective classes then how to achieve it ?

Thanks

netnest10-Jun-10 21:46

netnest

10-Jun-10 21:46

Hi,

I am currently redirecting user to a different page, say ABC, using Javascript. Now if my page ABC doesnt exist, i dont want to show 404 page, but custom error page. The custom error page in web.config doesnt work here as page is being redirected from client site. See below me web.config code

<customerrors mode="On" defaultredirect="~/Error.aspx">
<error statuscode="404" redirect="~/PageNotFound.aspx">

On my Webform I have written the following code for redirection using javascript.

English

Javascript method

function redirectToStaticPage(language)
{
var newPageURL = "http://xyz.aspx";
try
{
window.location = newPageURL;
}
catch(err)
{
txt="There was an error on this page.\n\n";
txt+="Error description: " + err.description + "\n\n";
txt+="Click OK to continue.\n\n";
alert(txt);
}
}

Currently it takes me to http://xyz.aspx which doesnt exist. I want to show in this case custom error page.
Please help ASAP. Thanks

Re: How display Custom Error Page when Javascript Page redirect fails

Peace ON10-Jun-10 22:17

how to decide..how much time user use my website...?

10-Jun-10 22:17

I think you need to do URL Validation at server side.
Once it is validated then you can redirect to that
particular URL.

Use following code to validate URL.

Public Class UrlValidity

Public Shared Function IsValid(ByVal Url As String) As Boolean
Dim sStream As Stream
Dim URLReq As HttpWebRequest
Dim URLRes As HttpWebResponse

Try
     URLReq = WebRequest.Create(Url)
     URLRes = URLReq.GetResponse()
     sStream = URLRes.GetResponseStream()
     Dim reader As String = New StreamReader(sStream).ReadToEnd()
     Return True
Catch ex As Exception
     ‘Url not valid
     Return False
End Try
End Function

End Class

HTH

Jinal Desai - LIVE
Experience is mother of sage....

koolprasad200310-Jun-10 19:40

koolprasad2003

10-Jun-10 19:40

hi ther,

i have a project created in asp.net 2.0. i want to calcuate how much time user spend on my site ???

i can do it by using (logout time - login time) ...but what happens if user directly close the browser by clicking [X] button... D'Oh! | :doh:

what should i do ???

any idea...????

Thanks in advnace
koolprasad2003 Poke tongue | ;-P

Rating always..... WELCOME

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how to decide..how much time user use my website...?

Brij10-Jun-10 20:15

Re: how to decide..how much time user use my website...?

10-Jun-10 20:15

You can handle this by using Session_Start and Session_End in Global.asax. Handle logout time at <code>Session_End</code> .This function will also be called if user close the browser by clicking [X] button, not at the same time but when it session expires.

Cheers!!
Brij
Check my latest Article :URL Routing with ASP.NET 4.0

Peace ON10-Jun-10 21:14

help needed with passing parameters

10-Jun-10 21:14

The answer given by Brij is perfect.
I am not adding anything new to it.

But following article is useful if you want
to put timer on every page denoting the time
spent on the page.

http://www.aspnettutorials.com/tutorials/ajax/ajax-time-spent-on-page-cs.aspx[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Farraj10-Jun-10 19:07

Farraj

10-Jun-10 19:07

Hi,

i need help in passing parameters from a datalist to another page.

this is how my app works:

i have a database ( access) a table with the following columns: id,title,desc,photo.

another table with the following columns: (startsin, endsin,price,tId)

on the first page (tourpack.aspx) i have a datalist, when user clicks on a button that is in the templateitem of the datalist, he will be transfered to another page called (showtour.aspx). what im trying to do is passing the ID parameter from the first page (table 1) to the second page (showtour.aspx) with the id number so he can see the specific details of that "tour" that are located In the second table.

any idea how it works? i would appreciate any kind of help.

Thanks,

Farraj.

m@dhu10-Jun-10 19:40

m@dhu

10-Jun-10 19:40

Farraj wrote:
passing the ID parameter from the first page (table 1) to the second page (showtour.aspx)

you need to have the a column(ID) same in both the tables. Join both the tables.

pass the ID through query string to showtour.aspx
//on page load of show tour
using the id from query string get the tour details

Farraj10-Jun-10 20:26

Farraj

10-Jun-10 20:26

Thanks for your reply

Do you mean to join the both tables or the both ID columns? if so how do i do that?
and how can i the id from query string to get the tour details in the other page (which there i have a datagrid)?

Thanks for your help

Brij10-Jun-10 20:39

10-Jun-10 20:39

On the buttonclick where you are transferring the user to another page.Pass the id in querystring as showtour.aspx?tourid=1.
Now read this id at pageload on showtour.aspx as Request.QueryString["tourid"] and load the details for this ID.

Cheers!!
Brij
Check my latest Article :URL Routing with ASP.NET 4.0