I have a fileupload and the file being uploaded is the name of an ID (from a database) and the file extension e.g. 127.gif
i need to extract just the ID and remove the extension (the extension could be anything like gif jpeg etc)
Does anyone know how to do this
i have the below which extracts the file extension i just need to do the opposite and get the ID now
[Code]....
I have a upload control in which i browse for the filename but I get the filename as "" (blank) ,
filename= uploadphoto.PostedFile.FileName
I have a datalist that is populated via and SqlDataSource. Code is VB
I am trying to extract two Values from the Item Templete and add them together. Then I want to add a new Label to the item template with the sum of the two added values.
I am able to to this using a GridView but no success with the datalist
My form code:
<asp:Label
ID="SDLabel"
runat="server"
Text='<%# Eval("SD") %>'></asp:Label><br
/>
SDT<asp:Label
ID="SDTLabel"
runat="server"
Text='<%# Eval("SDT") %>'></asp:Label><br
/>
SDS:<asp:Label
ID="SDSLabel"
runat="server"></asp:Label><br
/>
My VB Code behind Starts out:
[Code]....
I'm using ajax.toolkit asyncFileUpload to do the async image upload.
I don't know how to get the new file name that i give it in server side.
This js function
[Code]....
only returns the name of the filename on the client, not the new name that I have given server side
how can I do?
I am using file upload option in asp.net web application,how to display filename, date and time of file creation,modification date of file that we browse.
View 4 RepliesHow to know the FileName AjaxFileUpload in the event Click of a Button without going through earnest for this is what I found that is to say that the FileName is only in the event Designed AjaxFileUpload1_UploadComplete.
protected void InsertButton_Click(object sender, EventArgs e) {
lblMSG.Text = ViewState["filename"].ToString();
}
protected void AjaxFileUpload1_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e) {
ViewState["filename"] = e.FileName;
}
protected void AjaxFileUpload1_UploadComplete (object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e) {
string filePath = "~ / upload /" + e.FileName;
AjaxFileUpload1.SaveAs (filePath);
}
I'm looking for a way to have user upload as many images as they want (perhaps via drag and drop) or dynamically adding more upload box.I thought statically fixing (say 6) HTML upload input box is slightly limiting and the user have to click "Browse" button (6 times in this example) and navigating to the folder to pick the file.What is the best practice to achieve this so users find it easy to use? Perhaps with some AJAX magic?I also wouldn't mind having the user click "Upload more" to reveal (say 6 more) HTML upload input box.
View 2 RepliesI have a page within our site that allows admin users the ability to upload configuration settings into the system instead of submitting 1 at a time.
While testing yesterday, i found that one of the upload pages allowed me to upload a excel file that had alot more columns than expected and when i checked the database, the first few columns that were expected took the values from the file, and everything else was ignored, but wanted to see if there is any way to check the number of columns in the file to make sure it matches the upload logic before accepting it.
This may be something simple, but I am completely new to ASP.NET. I have been reading some tutorials based on W3Schools, and I have copied one of the files and tried to play with it by changing an element with a value to storing that same value in the attribute. Here is the edited XML (my.xml):
<?xml version="1.0" encoding="ISO-8859-1"?>
<countries>
<country>
<text value="N">Norway</text>
</country>
<country>
<text value="S">Sweden</text>
</country>
</countries>
I want to extract the N and S and use them as tooltips. Here is my aspx file:
<%@ Import Namespace="System.Data" %>
<script runat="server">
sub Page_Load
if Not Page.IsPostBack then
dim mycdcatalog=New DataSet
my.ReadXml(MapPath("my.xml"))
my.DataSource=my
my.DataBind()
end if
end sub
</script>
<html>
<body>
form runat="server">
<asp:Repeater id="my" runat="server">
HeaderTemplate>
table border="1" width="100%">
<tr>
<th>Name</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td title="<%#Container.DataItem.("text").Attributes["value"]%><%#Container.DataItem("text")%> </td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</html>
What have I missed here?
Every morning we get a few hundred emails from our various customers servers that tell us how their backup went that previous night. Somebody has to go through these and fill out an excel spread sheet. I would like to automate this, we have our own server running a .NET application so i can schedule something every morning.
There are two main parts. The first is i want to know how to create a table that has customers down the left and dates accross the right, they are called pivot tables in access but not sure how to recreate them in MSSQL and to do it on the fly as i dont want to have to sit there entering 100's of days at a time.
The second is that differnt customers use differnt backup solutions, so i want to write some code that scans a particular mailbox in exchange, looks for emails that have come in in the past 12 hours, look at the from email address and match that to one in the database, then according to the subject line it will be able to identify what type of backup solution it is, e.g. if it says "Backup Exec Job completd Sucessfully" it knows its backup exec and will look for a particular text (completed successfully, completed with exceptions, no media etc) and can insert that, or if its a differnet backup solution then go and look at a specific place in that email for it.
I have a requirement wherein a SQL query will be given in a text file.
The text file has to be read , the SQL query needs to be parsed and the column names, table names and where clauses have to be extracted and inserted into separate tables.
DB: Sql Server
I referenced this page, how to extract data from a gridview on a webpage. [URL] ....
I can extract to a Word, Excel and CSV but I can't to a pdf file. I get the following error:
Server Error in '/' Application.
Security Exception
Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: That assembly does not allow partially trusted callers.Source Error:
Line 135: Response.Write(pdfDoc);
Line 136: Response.End();
Line 137: } Line 138:
Line 139: protected void btnExportCSV_Click(object sender, EventArgs e)
[Code] ....
I m using hyperlink inside gridview. Here is my aspx code-
[Code]....
In the above code i just want to extract first three characters of sam_url in text property of hyperlink.
How can i get this using eval()?
Currently I am developing an ecommerce web site where
1. I choose the Product from a GridView (by pressing Select)
2. This product gets added to a DataView
The problem arises because I have a quantity textbox and wish to multiply the price by the quantity textbox.
How can I extract the price from the gridview to multiply it ? (and then subsequently display it in a label)
I know to populate Excel file using htmltextwriter from dataset.
I want to know how to populate Excel multiple sheets using htmltextwriter from dataset based on condition
I am using the asp.net and framework 2.0 with Ajax enable web.i have a text box and when user will enter "a" or number in this will search the name started from "a" character or number if he or she enter the number basically we can say live-search.
Employee search: Textbox.In this text box she/he will enter the first character of name or first number of employeeno and according to the a character name will search in list.
Im writing a bit of code that will extract the contents of a gridview to excel. I have all the parts working except for one. In my page_load i fetch the data from the database and then have the user select some options which filters the data and then the gridview gets populated. The problem im having is that the Response call doesnt seem to get the data from the gridview if i enclose the database fetch command within if not page.ispostback in the page_load
I have some test pages where i just fetched the data from the database bound it in a gridview in the Page_load. then on a button click export the data in the gridview to excel. Works fine if i DONT enclose the fetch command within not page.ispostback but outputs an empty excel file if i do.
Now i have to use not page.ispostback in the actual webpages because the users have to make selections which will filter the original dataset. How do i get this to work?
The page is also implementing AJAX if that helps. Here's an example of what i have:
[Code]....
I have a dataGrid with ButtonColumns in my asp page and I would like to do the following to:
When a row is clicked, I want to be able to:
1 - Hide all rows and display only the clicked row dynamically/on the fly.
trying to loop thru the datagrid and display only the Row index passed by the OnITemComman - but unsure of how to do it.
2 - Extract the row values (all cells in the row) to use as parameters in a query.
Used many ways of many examples but i always get a blank value. Managed to get the button text in the class but i need the full row values not just the cell clicked.
I have a detailsview with an upload image to the database. Image is save as binary file in database, and imagename is the name of the file. I'm able to load the image to the database using FileUpload. How do I get the image name to the database? Is there any method like OnInserting or something that allows me to retrieve the file name and save to database?
<asp:TemplateField HeaderText="Image" SortExpression="Image">
<ItemTemplate>
<img src='../Handler.ashx?PromoID=<%# Eval("PromoID") %>' />
[code]...
Afetr uploading a file from database it returns string value.I want replace the uploaded filename with new string [return ] value inside saved path .So I want to enter into my Saved filepath folder and Find uploaded filename & replace with new string value..?The reason of replacing that file with new string value is backend people know that file upload is completed.How to enter into the path..I am getting my filepath from webconfig file. My filepath is a shared network folder. i tried in below way,Fileupload method:
[Code]....
[Code]....
[Code]....
[Code]....
I have a question. How do you rename a file from an upload control and save it in webserver folder?. Actually I know how to save it in the webfolder. All I want to know is how to check if the file already exist and to rename it if it exist with an addition of number to the file uploaded? Here is my code now. But I wanna add another number to it with the orignal file name.
filepath = Server.MapPath(
"~/Resumes/" & UploadResume.FileName)
<wijmo:C1ReportViewer ID="C1ReportViewer1" Width="800px" Height="600px" runat="server" > </wijmo:C1ReportViewer>
How can I access the filename in reportviewer ....
I have a FileLoad control (see aspx code below). In the code behind, on 'btnSubmit_Click' event I am trying to get the FileName to excute the save to server. The 'fu1.FileName' is always blank. Am I missing anything here? Ideas anyone? Code Start
<asp:Content ID="Content1" ContentPlaceHolderID="MainMaster" Runat="Server">
.
.
[code]...
I'm coding my first VB web application, which allows a user to input an order number and pull up invoice and shipping data linkd to that order number.
I have the first bit down and working, where the existing data in the database is displayed in the GridViews. One of the GridViews is set up to allow data editing, and I have syntax set to make the row editable, but I'm struggling with getting the "Update" link/functionality to work. I want to assign the values in each cell to an object (ie. 'dgInvNumber' for Invoice Number), but everything I've tried (been doing a ton of Google searching for help, but no luck yet) keeps giving me an "Object reference not set
to an instance of an object" error when I click the Update link for the row of data being edited.
At this point, I don't know what syntax to use to get the edited values out of the GridView row and assigned to objects for each cell (I have a total of 10 cells that can be edited in a row).
For background info, the GridView is set up with Bound Fields. I'm using Visual Studio 2005. Alot of places I've looked talk about TextBox controls and using FindControl. Also seen some places talk about DataBoundLiteral Controls. I tried the latter with no luck (still getting error). For TextBox controls, I don't understand how to use that part, since it mentions referencing the TextBox controls declared in the EditItemTemplates of the TemplateField column fields in the GridView control. But I didn't set up anything in the EditItemTemplates (that I know of).
I have an application where the user uploads files.
GOAL:
I need to check the file name for special characters and replace them with an underscore. Is there a Select Statement OR IF Statement I can use to search the fileName for unwanted special charaters; those characters will be replaced with a blank or underscore?
I want to replace ampersand, Number sign, Apostrophe, and so on.