FileUpload + string!!
-
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
entryNameand post it's value?I are Troll :suss:
-
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
entryNameand post it's value?I are Troll :suss:
-
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
-
What's the SQL of the
AccessDataSource1.InsertCommand? Does it get the correct parameters?I are Troll :suss:
-
You got it working you said? The "Accessdatasource1"-control should have a property called "InsertCommand". That property holds an
INSERTstatement, 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:
-
You got it working you said? The "Accessdatasource1"-control should have a property called "InsertCommand". That property holds an
INSERTstatement, 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:
this is my insercommand
InsertCommand="INSERT INTO [gallery] ([file], [about]) VALUES (?, ?)"
and my insertparameters
<InsertParameters>
<asp:controlParameter Name="file" Type="String" ControlID="FileUpload1" PropertyName="FileName"/>
<asp:controlParameter Name="about" Type="String" ControlID="txtBoxAbout" PropertyName="text" />
</InsertParameters>what do u think i should do or add? thanks
-
You got it working you said? The "Accessdatasource1"-control should have a property called "InsertCommand". That property holds an
INSERTstatement, 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:
-
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:
-
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:
-
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.
The idea was to point the parameter to the label; the
Nameshould point to the parameter-name (that's "file", from your Sql statement), theControlIdshould point to the control that you're binding the parameter to. TheLabeldisplays it's contents in aTextproperty, 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:
-
The idea was to point the parameter to the label; the
Nameshould point to the parameter-name (that's "file", from your Sql statement), theControlIdshould point to the control that you're binding the parameter to. TheLabeldisplays it's contents in aTextproperty, 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:
-
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: