ASP.NET

27-Mar-10 8:35

Hi,

I have a database (access) that contains a table GALLERY.
Now i need while uploading a file to insert the path in this way to the db
"~/photo/XXX.JPG"

What i get right now is only the file's name.

This is what i used for saving the path

FileUpload1.SaveAs(Server.MapPath("~/photo/" + FileUpload1.FileName));

I've tried it with and without the Server.MapPath.
The resault without the server.mappath was "The SaveAs method is configured to require a rooted path..bla bla bla"
With the Server.MapPath it works but not the way i need it. as i said it inserts only the file's name to the DB.

Can anyone please help me with that.

Thank you,
Basil.

Sandeep Mewara27-Mar-10 9:02

Sandeep Mewara

27-Mar-10 9:02

The FileUpload control has a SaveAs(string path) method. You can use that method to save the file to any path using any filename you want. Just make sure ASP.NET has permissions to write to that path. So, you can do something like this to save the uploaded file to the uploads folder in the root of your website:

fileUpload1.SaveAs(Server.MapPath("~/uploads/") 
+ System.IO.Path.GetFilename(fileUpload1.FileName));

Farraj27-Mar-10 9:09

27-Mar-10 9:09

thank u for ur reply
i've tried that, still at my database i get only the file's name without the path ~/folder/...
i need to add it as a string before the file's name.

or! if there was a way for inserting like an auto text option to that column each time i insert the data (before the file name).

any idea how?

thanks

Not Active27-Mar-10 9:12

27-Mar-10 9:12

Do not post to multiple forum Mad | :mad:

I know the language. I've read a book. - _Madmatt

Farraj27-Mar-10 9:18

27-Mar-10 9:18

im sorry actually i disabled the code lol
now im running this code ugave me and im getting some errors.

System.IO.Path' does not contain a definition for 'GetFilename'
The name 'fileUpload1' does not exist in the current context

michaelschmitt28-Mar-10 23:48

michaelschmitt

28-Mar-10 23:48

Hi there,

the ID of your upload Control is "FileUpload1" in your example, not "fileUpload1". Always pay attention to the letter case. Same with GetFilename. The Method is written "GetFileName".

What the upload control does, is the following: it saves your
selected file to the file-system. No path-saving to your database at this point. Where
are you saving the path to your db? there you have to save the virtual path of your upload
folder in addition to your filename. Just concat the strings there.

Good Luck

Farraj29-Mar-10 2:05

Re: Fileupload problem, please help. [modified]

29-Mar-10 2:05

Hi michaelschmitt,
thank you for ur reply and for ur information Smile | :)

the letters are actualy as they should be.

____

I still cannot get it fixed even after adding the System.IO.Path..

//

FileUpload1.PostedFile.SaveAs(Server.MapPath(("~/photo/" + System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName))));

//

michaelschmitt29-Mar-10 3:35

michaelschmitt

29-Mar-10 3:35

What i was trying to say is that your posted code does not include any interaction with
your access database. It just takes the selected filename from your upload control and saves this
file to the desired folder. This code alone would not insert the filename into your access-database table.

To clarify:

"~/photo/" is the virtual path of your upload folder. Server.MapPath is needed to tranform this to the corresponding
physical directory on your web-server (e.g.: c:\http\mysite\photo). FileUpload1.SaveAs(...) saves your file to this folder.

Use

string virtualFilePath = "~/photo/" + FileUpload1.FileName;

to get your desired Path und save it to your database.

modified on Monday, March 29, 2010 9:43 AM

fetch date and time separately from datetime field in C#.net

ships_agr27-Mar-10 6:57

ships_agr

27-Mar-10 6:57

i want to fetch time and date information separately from a datetime type field of a table created using sql 2005 of asp.net...i wasn't able to understand the pages displayed on google for the same query...??

Re: fetch date and time separately from datetime field in C#.net

Tarakeshwar Reddy27-Mar-10 7:19

Tarakeshwar Reddy

27-Mar-10 7:19

Not sure if I understood your question correctly.

You can use the convert method and pass in the style. You can get the date by using styles 101 to 107 and 108 or 114 to get the time part.

This MSDN article[^] provides you with the syntax and shows the output for the various styles.

Tarakeshwar Reddy

There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi

Re: fetch date and time separately from datetime field in C#.net

ships_agr27-Mar-10 7:38

ships_agr

27-Mar-10 7:38

i've used a gridview datasource control to display the schedule ....thr in i've specified the time field as datetime datatype in the table....nw when i'm displaying the page along with time, date is also being displayed...i don want to display the date....but only time....can you help me...???

Re: fetch date and time separately from datetime field in C#.net

Tarakeshwar Reddy27-Mar-10 7:50

Tarakeshwar Reddy

27-Mar-10 7:50

You can use a bound field and set the DataFormatString.

<asp:BoundField HtmlEncode="False" DataField="Time" DataFormatString = "{0:T}" HeaderText="Time">

Take a look at the Standard DateTime Format Strings [^] and this article[^] which shows you how to create a bound field.

Tarakeshwar Reddy

There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi

Message Removed

27-Mar-10 3:29

Re: sending email with text and url

27-Mar-10 3:29

Message Removed

Not Active27-Mar-10 3:43

email sending with some text and url

27-Mar-10 3:43

See responses to below.

You should stop and do some research on your own. These are not difficult problems to solve and there are plenty of resources available.

I know the language. I've read a book. - _Madmatt

kunjumonu27-Mar-10 3:23

Re: email sending with some text and url

27-Mar-10 3:23

Am doing aE-greetings project . so i need to send mail with some text and url of the greeting cards (which is selected by the user) . so pls help me and i have to send automatic email for reminders . please let me also know the technique behind this also. pls

Not Active27-Mar-10 3:42

27-Mar-10 3:42

What part of this are you having difficulties with? What research have you done? What have you tried?

We are not here to do the work for you. If you are having difficulties with a particular part, then ask, but you should first at least try something yourself.

I know the language. I've read a book. - _Madmatt

Message Removed

27-Mar-10 3:16

Re: image button in placeholderr

27-Mar-10 3:16

Message Removed

Not Active27-Mar-10 3:40

Re: image button in placeholderr

27-Mar-10 3:40

You question not clear.

I know the language. I've read a book. - _Madmatt

kunjumonu27-Mar-10 23:51

Re: image button in placeholderr

27-Mar-10 23:51

string path = MapPath("~/cards/");
        string full = path + Session["file"] + "/";
        string[] s = Directory.GetFiles(full);
        
        foreach (string str in s)
        {
            string f = Path.GetFileName(str);
            
            ImageButton im = new ImageButton();
            im.Width = 150;
            im.Height = 150;
           
            im.ImageUrl = "~/cards/" + Session["file"] + "/" + f;
            Session["selected"] = im.ImageUrl;


            im.Click += new ImageClickEventHandler(im_Click);
           
            
            
            PlaceHolder1.Controls.Add(im);
            
            EnsureChildControls();
  
       }
        
    }
    protected void im_Click(object sender,ImageClickEventArgs f)
    {

      //  Session["selected"] = g;
      //  Label1.Text = Session["selected"].ToString();
        Response.Redirect("editor.aspx");
    }

kunjumonu27-Mar-10 23:52