ASP.NET

Re: Answers required for the below interview questions

11-Nov-09 20:11

Question - if we gave you the answers, do you think you could fool a recruiter into hiring you ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Shameel12-Nov-09 7:09

Shameel

12-Nov-09 7:09

What do you mean by answers "required" ? You are not even ready to spend some time and effort to find out the answers yourself, you expect others to do it for you? And do you think you can fool around interviewers with what you get here ?

ASP.NET: How to refresh Saved Crystal Report to latest data? Help needed.

ssmaran11-Nov-09 17:41

ssmaran

11-Nov-09 17:41

Hi Friends,

I'm quite new to the ASP.NET + Crystal reports. Please let me know how to open a saved RPT file (Saved with Data and parameters), apply DB login and just refresh with latest data from the database. The user no need to view at the Crystal report viewer from the application. We need to show the result of refreshing either successfully refreshed or not, that's all. I'm proposing to pass the RPT file name as query string the application.

I tried different ways like Reportdoc.refresh(), used RefreshReport() of viewer component, still it doesn't help (Just for testing purpose I used viewer, I do not want the users view the report from application, they will view later with separate offline viewer). I'm getting inconsistent error mesgs like 'Login failed / Application server failed etc.

Any one has sample code on how to achieve this. Please help providng steps to do and any events we need to handle etc.

Appreciate your your help on this.

Thanks.

Problem with file path

Maxdd 711-Nov-09 15:43

11-Nov-09 15:43

I'm trying to use a upload form to read a file. The problem is, I cant access full path of the file so I can read wherever he is.

The form is something like this:

<form id="Form1" enctype="multipart/form-data" runat="server">
<tr>
  <td>Escolha ficheiro:</td>
  <td><input id="upl" type="file" runat="server"></td>
</tr>
<tr>
  <td colspan="2">
  <input type="button" id="upload" value="Inserir" 
                    OnServerClick="uploadClick" runat="server">
  </td>
</tr>
</form>

The problem its here:

string path;
     path = upl.Value;
    Response.Write(path);

Using VS 2008 I can see that when I use "Value" I am "acessing full file path on client's computer". Its exactly what I want but I'm getting on the output just the name of the file. Its very strange because also when I browse the file the textfield shows the full path. Also, if I change the type="file" to type="text" and then I input the path manually, everything works right.

What am I doing wrong?

Christian Graus11-Nov-09 15:59

11-Nov-09 15:59

I would say that you have no idea how ASP.NET works. Assuming you got the full path to the file on the client's machine, what would you hope to do with it ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 711-Nov-09 16:02

11-Nov-09 16:02

Do .txt data to SQL table operation. I'm not doing upload operation, I'm doing insert operation using upload form. The client machine is always the user machine so there's no problem. The following line

its: string[] data = File.ReadAllLines(path);

If there's another (and better) way, please say to me.

Christian Graus11-Nov-09 16:08

11-Nov-09 16:08

Why are you using pure HTML and not server controls ? Why not use a server control and just grab the file data from the stream you get passed ? Surely you're not saying your application is only ever used by someone who is on the server ? If it's never used over the internet, or a LAN, why use ASP.NET at all ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 711-Nov-09 16:16

11-Nov-09 16:16

Old habits...

What I meant to say is that the method I was trying to use works because the file its always on client side, so why not open and read data on client side and write it on server side?

I work on ASP.NET less than 48 hours so I dont know a server control to do that.

By server control you mean something like this: ?

<asp:FileUpload ID="FileUpload1" runat="server" />

What would be the diference?

Christian Graus11-Nov-09 16:20

11-Nov-09 16:20

Maxdd 7 wrote:
so why not open and read data on client side

Because your C# code never runs on the client, it runs on the server.

Maxdd 7 wrote:
What would be the diference?

This control has a property that contains the bytes of the file in question.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 711-Nov-09 17:11

11-Nov-09 17:11

I followed your advice and done:

caminho = Path.GetFullPath(FileUploadControl.PostedFile.FileName);

and

cam = Path.GetFullPath(FileUploadControl.PostedFile.FileName);

and another tries, and always have same result:

C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\file.txt (is not even the same hard drive)

I googled about it, and looks like File Upload Control does not allow getting full path of client's machine. They say its a security thing.

Christian Graus11-Nov-09 20:08

Re: Problem with file path [modified]

11-Nov-09 20:08

You didn't remotely follow my advice. you CANNOT access the file from the server to the client. The PostedFile property has a property which contains the file contents.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 712-Nov-09 6:57

Same page, different access - use Sessions?

12-Nov-09 6:57

You are right.

I found this.

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.fileupload.postedfile.aspx[^]

I've adapted to my program, but having the problem I tought. If I use streams to read the file, I will not have text data.

So I'm trying convert that stream data using:

StreamReader reader = new StreamReader( myStream );
string text = reader.ReadToEnd();

and

byte[] bytes = new byte[myStream.Length];
        string data = Encoding.ASCII.GetString(bytes);

But its not working Sniff | :^)

EDIT:

I did this and its finally working Big Grin | :-D

byte[] bytes = new byte[myStream.Length];
    myStream.Position = 0;
    myStream.Read(bytes, 0, (int)myStream.Length);
    string data = Encoding.ASCII.GetString(bytes);

modified on Thursday, November 12, 2009 1:05 PM

Maxdd 711-Nov-09 9:28

11-Nov-09 9:28

I worked many time with PHP, and always used Sessions variables. For example: I have two users, with two different access level (lets say admin is 1 user is 2). The webpage as an ordinary table with information. Admin can view and edit, but user can only view.

With PHP what I did is define the access level on a field (SQL table) of the table 'Users', and then, depending on the value of that field I do something like:

index.php (..)

if($_SESSION['level'] == 1)
include(indexAdmin.php)

if($_SESSION['level'] == 2)
include(indexUser.php)

Do you see the point? I need to do something similar with ASP.NET 3.5 C# coding, and I dont want to use and create groups on web.config.

What can I do ?

Christian Graus11-Nov-09 9:30

11-Nov-09 9:30

The session works somewhat the same, except instead of an include to pull in php code, you would actually write code to show the menu items you want to show.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 711-Nov-09 9:45

11-Nov-09 9:45

So I work on .aspx or on .aspx.cs?

Christian Graus11-Nov-09 9:49

11-Nov-09 9:49

Depends. As someone else said, one possible way is to put items in panels in the aspx, and then show/hide them in the .cs file. If you were building a menu, I'd put it in a master page, and the items for that could well be added entirely in the cs file. It depends on what the specifics are of your task.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Maxdd 711-Nov-09 9:55

11-Nov-09 9:55

I have a GridView, with Insert, Delete and Edit options, (on TemplateFields) so I dont want these operations available for all users... how can I do that?

Christian Graus11-Nov-09 10:12

11-Nov-09 10:12

I am not sure, you'll have to experiment. Those options go in the aspx usually, I'd try to see if they can be added in code, so you can do it conditionally.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Code behind .aspx.cs

David Mujica11-Nov-09 9:53

David Mujica

11-Nov-09 9:53

You put the "me.textbox1.readonly=true" in the .aspx.cs.

(I'm not sure of the C# syntax, my code behind is in VB)

David Mujica11-Nov-09 9:34

David Mujica

11-Nov-09 9:34

If you are now developing an ASP.NET page, you can set the controls property, READONLY, to either true or false depending on the user's security.

For example:
If (user is admin) then
Me.Textbox1.Readonly = False
else
Me.Textbox1.Readonly = True
end if

The other thing you can do is group the fields on a page inside a "Panel" and set it's Visible property to True/False. This will effectively remove the fields from the page.

david

Maxdd 711-Nov-09 9:58

11-Nov-09 9:58

The problem is I have a GridView, with Insert, Delete and Edit options, (on TemplateFields) so I dont want these operations available for all users... just that.