FileUpload + string!!

Farraj

hello guys, i have an Access db. im uploading an image to my gallery table. anyway. i need to insert some text in the field before adding the filename string i need it to look this way at the db Axxx.jpg Azzz.jpg Abbb.jpg so i used the following code:

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{

    string imagefolder = "photo";
    string savepath;
    string savefile;
    Label3.Text = "A";
    
    if (FileUpload1.HasFile)
    {
        savepath = Path.Combine(Request.PhysicalApplicationPath, imagefolder);
        savefile = Path.Combine(savepath, FileUpload1.FileName);
        FileUpload1.PostedFile.SaveAs(Server.MapPath(("" + this.Label3.Text +"" + System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName))));

        AccessDataSource1.Insert();

    }

}

but i still keep getting in the db only the file's name without the text i want to add before it. any ideas? thank you.

Lost User

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string imagefolder = "photo";
string savepath;
string savefile;
Label3.Text = "prefix";

if (FileUpload1.HasFile)
{
     string entryName = Label3.Text + 
         System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);

     savepath = Path.Combine(Request.PhysicalApplicationPath, imagefolder);
     savefile = Path.Combine(savepath, FileUpload1.FileName);

     FileUpload1.PostedFile.SaveAs(Server.MapPath(entryName));

     AccessDataSource1.Insert();
}

}

Can you put a breakpoint on the highlighted line and inspect the variable entryName and post it's value?

I are Troll :suss:

Farraj

Hi Eddy thanks for ur replay Maybe i should get me a NON-Express edition of visual studio unfortunatly im using the express edition where i cant do that. if u think there is a way after all i'd love to know thanks for ur help brother !

Farraj

here i figured it out sorry! anyway the enteryname is "prefixidd9e1uDBJ-preview.jpg" as it should be, but at the database, its only the jpg name without the prefix

Lost User

What's the SQL of the AccessDataSource1.InsertCommand? Does it get the correct parameters?

I are Troll :suss:

Farraj

Lost User

You got it working you said? The "Accessdatasource1"-control should have a property called "InsertCommand". That property holds an INSERT statement, in Sql-syntax. Since you said that the variables contain the correct value, I'm guessing that it must go wrong when writing to the database. That's the task of the Accessdatasource, hence we'd want to check that next :)

I are Troll :suss:

Farraj

this is my insercommand

InsertCommand="INSERT INTO [gallery] ([file], [about]) VALUES (?, ?)"

and my insertparameters

what do u think i should do or add? thanks

Farraj

hmm.. any help please?

Lost User

How about pointing the parameter to that label?

<asp:controlParameter Name="about" Type="String" ControlID="txtBoxAbout" PropertyName="text" />

Now, when you click the button, update the label first;

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string imagefolder = "photo";
string savepath;
string savefile;
Label3.Text = "Bla" + System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);

Does that fix it?

I are Troll :suss:

Farraj

it didnt work. i also tried using the $ sign - ControlID="Label3$FileUpload1" and added <asp:ControlParameter Name="pre" Type="string" ControlID="Label3" PropertyName="text" /> still not working. this is driving me crazy.

Lost User

The idea was to point the parameter to the label; the Name should point to the parameter-name (that's "file", from your Sql statement), the ControlId should point to the control that you're binding the parameter to. The Label displays it's contents in a Text property, hence the binding;

<asp:ControlParameter ControlID="Label3" Name="file" PropertyName="Text" Type="String" />

Does the value of the label get set correctly?

I are Troll :suss:

Farraj

Hi Eddy, this didnt fix it. Any other ideas?

Lost User

don-basil wrote:

this didnt fix it. Any other ideas?

I'm out of idea's, maybe one of the ASP.NET guru's can help out :(

I are Troll :suss:

Farraj

well, Eddy! i thank you ALOTTT for your time and help. u are great. if i ever get this solved i'll post it in here:) thanks again