ASP.NET

Re: get control id from the content page

16-Mar-07 5:37

I'm sorry, I must have misunderstood your post. If you'd like the server code to fire, simply change the javascript function to return true instead.

--Jesse
"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi

srinandan..18-Mar-07 21:08

srinandan..

18-Mar-07 21:08

thanks Jesse Smile | :)

my problem has been solved if rmove the return value or return the true.
thanks for making reply.

Regards,
Srinandan

Mysterious Web User Controls Related Problem

powered_by_xanax16-Mar-07 2:54

powered_by_xanax

16-Mar-07 2:54

Hi, I’m somehow new to user controls in asp.net plz help me out!
I’ve two major problems with the following code:
protected void Page_Init()
{
for (int i = 0; i < 10; i++)
{
ctrl_new_friend temp_new_friend = (ctrl_new_friend)LoadControl("ctrl_new_friend.ascx");
temp_new_friend.ID = "ctrl_new_friend_" + i;
// >> For Debugging Purposes And Should Be Replaced By Data From DB
temp_new_friend.image_name = "hamed";
//End Debugging <<
ph_new_friends.Controls.Add(temp_new_friend);

Image img_separator = new Image();
img_separator.ImageUrl = "~/anonsec/misc/xuniv_separator_blue.gif";
ph_new_friends.Controls.Add(img_separator);
}
}
First: It works fine but sometimes – mysteriously - get an “Unable to cast” error;
Second: It doesn’t seem to be performance friendly, and if I put the LoadControl() outside of the for() block it adds the control just one time.
I think I’m making a mistake using such coding!
Thanks for your help.

How to transfer data from HTML table to excel or through dataset to excel.

AjayKrSh16-Mar-07 2:53

AjayKrSh

16-Mar-07 2:53

Hi,
I wanna create an Excel file cell by cell with formating in asp.net.
I have data in dataset or in HTML file.Now is there any way through which i could transfer the data in HTML in same format in excel.
If i have to do it through Dataset to Excel then i need a method through which i could access each cell of excel.Else i need a method through which entire HTML can be transfered in Excel with all its format.

Can any1 have the solution....Thnx...

Re: How to transfer data from HTML table to excel or through dataset to excel.

Jesse Squire16-Mar-07 3:27

Re: How to transfer data from HTML table to excel or through dataset to excel.

16-Mar-07 3:27

There are a few ways that you can go about this, depending on how complex your spreadsheet and formatting needs are. In a simple case, the approach that you mention of forming HTML and tricking Excel into parsing it, is a good one. There are plenty of articles available if you care to google, but the basic implementation involves you setting header values from your page. For example:

Response.AddHeader("content-disposition", "attachment; filename=MyExcelSheet.xls");
Response.ContentType = "application/ms-excel";

That technique only works if the formatting is simple. If you require more advanced formatting or the use of formulas, you may wish to consider purchasing one of the commercial components that allow you to work with the Excel native format without Office being present on the machine, such as this[^] one.

As a last resort, it is possible to install Office on the server and use the Office interop assemblies to automate Excel. Please note that I label this the last resort, because it is slower, consumes more resources, and requires client software to be installed on a server (potentially increasing the attack surface.)

Hope that helps. Smile | :)

--Jesse
"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi

AjayKrSh16-Mar-07 3:48

AjayKrSh

16-Mar-07 3:48

Thnx for your reply....
i got this article from net but still not even able to create an object of application...i have included ref of excel object too...dont knw why Application object in first line now created...

code is as follows:-

In this article, we are going to see how to open a write a dataset to a excel file and open the excel file in the browser.

In order for this to work, there is an important modification in web.config file. We have to add <identity impersonate="true"> else you will get an 'Access is denied' error.

In the application, we have to add a reference for a COM component called "Microsoft Excel 9.0 object library".

Now we have to just loop through the dataset records and populate to each cell in the excel.

Code:

private void createDataInExcel(DataSet ds)

{

Application oXL;

_Workbook oWB;

_Worksheet oSheet;

Range oRng;

string strCurrentDir = Server.MapPath(".") + "\\reports\\";

try

{

oXL = new Application();

oXL.Visible = false;

//Get a new workbook.

oWB = (_Workbook)(oXL.Workbooks.Add( Missing.Value ));

oSheet = (_Worksheet)oWB.ActiveSheet;

//System.Data.DataTable dtGridData=ds.Tables[0];

int iRow =2;

if(ds.Tables[0].Rows.Count>0)

{

// for(int j=0;j

Re: How to transfer data from HTML table to excel or through dataset to excel.

Jesse Squire16-Mar-07 3:54

16-Mar-07 3:54

What you're attempting to do in that code is to use COM interop to automate the Excel client. You are most likely failing because Excel is not installed on your web server. As I mention in my original reply, I'd strongly recommend that you use this approach only as a last resort.

Please refer to my original reply for some alternatives.

--Jesse
"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi

listbox and arrays

Kunal P16-Mar-07 2:47

16-Mar-07 2:47

hi
i have a multiple selection listbox in the webform. i want to add the items of the listbox into a database, where in each item goes in a particular column.

i am implementing this using arrays. but wat i am not getting is how should i declare an array for the listbox.

i have declared an string type array with size 6, cuz i dont want more than 6 values to be selected.

finally, how shud i implemnt it...

string[] list = new string[5];

Kunal Piyush

browser's back button

yogita charhate16-Mar-07 2:27

yogita charhate

16-Mar-07 2:27

I am clicking login button which is on home page.then login page comes up. After login that login button converted into logout on home page and at time if I clicked on the browser BACK button I get login page.But I am already logined, So I don't want that page when logout button is active on home page.

yog
hui gfgh kgdgrt njjn hjgkn

Kunal P16-Mar-07 2:40

16-Mar-07 2:40

u will need to maintain sessions or cookies to obtain this functionality. this would add more security. also now if u logout and click a back button, you wont be redirected to the logged in home page.

Kunal Piyush

yuvachandra16-Mar-07 2:48

yuvachandra

16-Mar-07 2:48

heay kunal....could u send some artiles relateing to this stuff

or the procedure to follow ...! Rose | [Rose]

Kunal P16-Mar-07 4:45

16-Mar-07 4:45

yuva..read the msdn documentation.. session states

there u will get exaustive info about the same.

Kunal Piyush

yogita charhate16-Mar-07 4:13

yogita charhate

16-Mar-07 4:13

Thank you for reply.
I have used javascript
Window.history.go(+1)
in order to prevent user from going to the signin page .
Currently I'm not getting sign in page in all conditions whether user is logged in or not.
But I want this to happen only when user is already logged in .
I have maintained session for userid when user is logged in.
But don't understand how to restrict this code to execute only when user is logged in.

yog
hui gfgh kgdgrt njjn hjgkn

Kunal P16-Mar-07 4:48

Setting _DEBUG for web project

16-Mar-07 4:48

i dont know why u r using javascript.. this will go a page forward in the browsers history

wen u have already maintained a session id, add the code in the page_load event of the web form.

if (Session["user"] != null)

this means that if the user is logged in... add ur own code

hope it helps.

Kunal Piyush

Leo Smith16-Mar-07 2:26

Leo Smith

16-Mar-07 2:26

I would like to find out if there is a way to set a conditional switch so that sections of code could be accessed depending on location. Something like C++ #ifdefine and #else switches. I have code that I am debugging, but I need to remove certian elements from the code while I debug, then when the code is ported to production, I don't want to have to readd the other code. Any ideas like something in the web.config that might allow me to do this simply. The hard way would be to make a global value then in the code use it in an if statement.

Leo T. Smith

Re: Setting _DEBUG for web project

Jesse Squire16-Mar-07 2:56