ASP.NET

Re: Problem with file path

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.

Petr Pechovic11-Nov-09 10:14

Petr Pechovic

11-Nov-09 10:14

Hi,
You can use this (as David above mentioned):

<asp:Panel runat="server" ID="pnlAdmin">
… my admin section
</asp:Panel>

<asp:Panel runat="server" ID="pnlUser">
… my common user section
</asp:Panel>

If (user is admin)
  pnlAdmin.Visible = true;
else if (user is user) {
  pnlUser.Visible = true;
  pnlAdmin.Visible = false;
}

It’s easy but it’s not so excellent. Consider to read this article to get more info: http://ryangaraygay.com/blog/post/2008/04/PlaceHolder-and-Panel-Visibility-and-ViewState.aspx[^]

Petr Pechovic

Maxdd 711-Nov-09 16:28

.txt to SQL (MS SQL Server) [modified]

11-Nov-09 16:28

Thank you very much to all Smile | :)

Thanks for your pacience, I'm iniciating ASP.NET and there's a lot of things to learn so sometimes I know I could be a little Sleepy | :zzz:

so please be pacience, I'm trying.

Maxdd 711-Nov-09 8:53

Re: .txt to SQL (MS SQL Server)

11-Nov-09 8:53

I have to load .txt data to sql table. Im doing this:

string path = "E:\\fich.txt";

       
        string query;
        query = "LOAD DATA INFILE '" + path + "'";
        query += " INTO TABLE Filmes";
        SqlCommand com = new SqlCommand(query, Conn);
        string q;
        q = (string)com.ExecuteScalar();

But getting error: incorrect syntax near E:\fich.txt

Any ideas? What am I doing wrong?

modified on Wednesday, November 11, 2009 3:43 PM

Christian Graus11-Nov-09 9:29

11-Nov-09 9:29

Maxdd 7 wrote:
StreamReader sr = File.OpenText("E:\\fich.txt");

Why would you open the file in a stream that you never use ? I'd suspect that is locking the file. Unless the file contains single quotes ( which you can fix with a string.Replace call ), I'd be more inclined to use File.ReadAllText and just do a normal insert of that text.

Are you sure that execute scalar would return a string in this instance ?

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:44

11-Nov-09 9:44

Ups, I forgot to delete that line in this post.

I really would like to use Load Data Infile, just have sintax problems, cant you help me?

Christian Graus11-Nov-09 9:49

11-Nov-09 9:49

Did you try without that line and still got the error ?

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:56

11-Nov-09 9:56

Yes.

Still having incorrect syntax near 'e:\fich.txt'

Christian Graus11-Nov-09 10:10

11-Nov-09 10:10

I am reading the books online, where are you getting the documentation that makes you think this will work 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 10:22

11-Nov-09 10:22

There isnt documentation that makes me think this will work. I used LOAD DATA INFILE a lot of times, and it works perfectly.

The problem is, I never used with ASP.NET C# coding, but MS SQL is MS SQL I just need to make the syntax right.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html[^]

Christian Graus11-Nov-09 11:18

11-Nov-09 11:18

That's documentation for MySQL. My google search turned that up, too. MS SQL is NOT My SQL. I can find NO docs for INFILE in the docs that come with SQL Server, or on the web.

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 11:36

11-Nov-09 11:36

My mistake.

Probably you are right. My apologies. I was seeing that like a horse with closed eyes Roll eyes | :rolleyes:

I already starting working on natural solution but having another problem now:

My file is for example:

field1,field2,field3
anotherfield1,anotherfield2,anotherfield3

Just works for first line. I'm really amateur on C#, how can I do read all other lines? (having also triplicated data because the use of for instead foreach, but I will solve this problem later)

string MystringLine;
string[] MystringArray;
char[] charArray = new char[] { ',' };

FileStream MyFileStrema = new FileStream("E:\\fich1.txt", FileMode.Open);
StreamReader MyStreamReader = new StreamReader(MyFileStrema);

MystringLine = MyStreamReader.ReadLine();
MystringArray = MystringLine.Split(charArray);

int tamanho;
tamanho = MystringArray.Length;

//for (int i = 0; i <= MystringArray.GetUpperBound(0); i++)
for (int i = 0; i < tamanho; i++)
{
    //            Response.Write(MystringArray[0]);
    string query;

     query = "INSERT INTO Filmes(Name, Genre, Year)";
    query += " VALUES ('" + MystringArray[0] + "','" + MystringArray[1] + "','" + MystringArray[2] + "')";

    SqlCommand com = new SqlCommand(query, Conn);
    SqlDataReader datareader = com.ExecuteReader();
    datareader.Close();

}

MidwestLimey11-Nov-09 11:39

MidwestLimey

11-Nov-09 11:39

If the file is well structured, perhaps you could try issuing a BULK INSERT statement to MS SQL server?

I just hit a problem where I needed to push > 200k records in multiple tables, worked in under a couple of minutes.

10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011

Maxdd 711-Nov-09 12:02