ASP.NET

Re: Is it possible to make a directory not under the application directroy in www.root ?

10-Oct-06 21:46

HI
Guys i have new problem now, the problem is that when the user views the uploaded document,the user gets the path of the document from the address bar, so the user can access that document by copy and pasting it in the address bar any other time.What i want to do is to make separate private folder and upload the document in it and the path of this folder should not be accessible to the user so that user cann't access the document by copy and pasting the path in the address bar of browser, how is this possible, can any one help me out, if it can not be done in the way mentioned above
is there any other way to do it. Plz reply me ASAP.thankx in advance.

perlmunger12-Oct-06 5:19

perlmunger

12-Oct-06 5:19

You have to make filesystem calls and basically do what the web server does--send header information and then the data stream. I haven't actually done this in ASP .NET, but I did it a long time ago in perl. Here is an article that should set you off in the right direction: http://www.eggheadcafe.com/articles/20011006.asp[^] . Basically what you have to do is:

1. Display links to the files that actually call an event where you can grab the appropriate file based on whatever validation you want (use Directory.GetFiles() to get the files you want from the directory outside the web tree).

2. When the user clicks on the link you've created for each file, in the event handler, check that they have all the appropriate credentials and then load the file into a filestream which you will then write back in the response after writing the "Content-disposition" header. See the above article for the details of how to do that.

I hope that helps.

-Matt

------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Access to Excel

aaraaayen10-Oct-06 21:20

aaraaayen

10-Oct-06 21:20

Hi friends,

In my asp.net application, I want to convert ms-access data to excel. for this first i get the access data to gridview and from this i am fetching into excel. Its working well for smaller number of records. (say for eg. 5000). But for me in access there are 2 lacs records. While fetching these its giving problem. i am using the following code. Please can anyone help me is there are any alternatives for this.

DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=D:/Database/Viewer.mdb;");
cn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select Parcel,Land,LandUse from Collection where class='E'", cn);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
// DataSet ds = new DataSet();
da.Fill(ds, "Collection");
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
return;
}

Thanks in advance

Thanks and Regards,

Prya

Re: Access to Excel

perlmunger12-Oct-06 5:27

perlmunger

12-Oct-06 5:27

You'll probably be better off if you just write out a CSV file. To create an Excel spreadsheet document you'll either need to use Office Automation or you'll have to find some third-party library that will create the file for you. What I would do is just write the data out as a CSV file and then send that back to the client. In all liklihood, the CSV will open in Excel anyhow.

-Matt

------------------------------------------

The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall

Menu control or load data from dataset to linbutton

Vipin.d10-Oct-06 21:16

Vipin.d

10-Oct-06 21:16

hai all
in my webapplication ,i want to creat a menu.

The pblm is the content of the menu is from database.

when i click one menu item i need its value to a label. how can i take it??

in this purpose without using menu control, can i use dataset???

ie.retrive data from dataset and dynamically create linkbutton and load lnkbut.text as dataset.table.row[0] .

then how???

i want to move forward and backward.ie at a time 5 item from datbase is laod to hyperlink and when click to "move next" button will load next 5......

thanks in advance

All I ever wanted is what others have....

CrazySanker

Context Menu on Tree view node

joe_elsy10-Oct-06 20:48

joe_elsy

10-Oct-06 20:48

How do we show a context menu on the right click of tree view node?
Do we have to write some javascript to populate the menu?
Please help me....

Issues in VS 2005+Crystal Report+Atlas

skannapiran10-Oct-06 20:29

skannapiran

10-Oct-06 20:29

Hi All,

I got problem with my ASP.Net application + Crystal Report + Atlas.

My application holds Crystal report (Report.rpt) displayed through "Atlas"

I designed my Report and I made attempt to display it. The output of my report(report.rpt) differs from the designed report.

My application is free from errors.

Why this controversy?

Kindly give me solution

Kannapiran S

How to connect ASP.NET to Lotus Notes

justprashant10-Oct-06 20:15

justprashant

10-Oct-06 20:15

Hi ,

I'm developing a web based system(ASP.NET with C#) ...where in I have to export the data in the database onto an excel sheet and mail using Lotus Notes ..

Can anyone help me with this ....... ?
Can I connect the .Net framework to Lotus Notes ?

javascript error

srilu nagalla10-Oct-06 20:06

srilu nagalla

10-Oct-06 20:06

Hi,plz check this

winobj=new object();
function winopen1()
{

winobj=window.open("setcustmailbody.aspx");
return;
}
function winclose1()
{
winobj.close();
return;

}

When i call the winclose1() the window is not closed,whats wrong in this

Re: javascript error

CWIZO10-Oct-06 22:59

CWIZO

10-Oct-06 22:59

If you open this site in firefox and look into the JavaScript console, what error do you get?

--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

ASP.Net Uploading Problem

King Shez10-Oct-06 19:59

10-Oct-06 19:59

HI
Guys the problem i am facing is that, when the user uploads the file in my application greater then 4 MB , the white page "page of death comes in front of the user",i know this is the default limit of ASP.NET which can be increased too in web.comfig and machine.config, but i don't want it to increase the file uploading size limit in web.config or machine.config, what is the solution for this ASP.NET uploading problem,plz reply ASAP, thankx in advance.

Andrei_KS10-Oct-06 20:09

10-Oct-06 20:09

Hi,

I think you can use next attribute in web.config - <httpRuntime maxRequestLength="8192" />

King Shez10-Oct-06 20:40

10-Oct-06 20:40

but wht if the user uploads the file greater then the max request length mentioned in web.config, the application will be going to crash, how to handle this situation ,when user uploads the file greater then the max request length mentioned in web.config,plz reply me asap, thankx for ur reply.

Andrei_KS10-Oct-06 20:50

10-Oct-06 20:50

You can use client JavaScript for verify file size. And if this size greater, you dont make DoPostBack.

Andrei_KS10-Oct-06 21:01

10-Oct-06 21:01

See next link Check file size with Javascript

_AK_10-Oct-06 21:11

_AK_

10-Oct-06 21:11

But this depends on the user whether he has activeX enabled or not. This cannot be the safe methods. I think server side checking will also be required. Smile | :)

Best Regards,
Apurva Kaushal

Andrei_KS10-Oct-06 21:39

10-Oct-06 21:39

Then I think you can see HttpModule and so on (handler for upload file's). See next link's - HttpHandler or HttpModule for file upload, large files, progress indicator? and HttpModule and upload files.

King Shez10-Oct-06 22:40