Here is a link with code that I used to Export data as Excel: [URL]....
That set up an ASP.Net page to allow a user to export data from a database to an Excel file.
I have a small form
employeenumber ---textbox
employee name ---- textbox
employee department ---- textbox
employee sal ----- textbox
employee age ---- textbox
Now I have a webpage with search textbox
employeenumber ----- textbox (search criteria)
When user types employee number all the sql related data should fill the form containing employee name, sal, age , dept etc.
next
I have 2 buttons
excel export
automail
In excel export i have a specified format
IF IMGAE NOT DISPLAYED I HAVE CREATED MACRO
Range("A1:A2").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Selection.Merge ActiveCell.FormulaR1C1 = "LOGO" Range("A1:A2").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = True End With Range("B1:G2").Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlCenter .WrapText = False
[Code] ....
What I actually need is : when I click export button textbox data should be send to excel file and particular textbox data should be received at particular cell.
E.g:- textbox1 to send to c3 or c4
textbox 2 to send g9
when i click mail button, that data should be send to excel and automailed as attachment, i have 3 excel files with different formats, export button should view all the excel files with their respective data and mail button should send mail the excel files with data ,
1 user i excel file
2nd user 2nd excel file
3rd user 3 excel file
i am using the following tutorial, URL...I would like to add in textbox's for extra email and message body for the end user to type in before the email is sent out. like the example above the email should already have the pdf automatically attached.
View 1 RepliesI need to generate a PDF file in a folder inside the server, and attach it for sending a mail. If again want to send mail means I want to replace the new PDF file.
View 1 RepliesI have the following code to convert page to pdf
Protected Sub btnExport_Click(sender As Object, e As EventArgs)
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf")
[Code].....
But i want the file to save in the particular folder....
and send to an mail...
Actually i am working on a project i want if the user click on a applybutton
For this job automatically should send his Cv which i have it in the repeater .
Example: i have the user Personal info in 1st repeater
work Experience in 2nd repeater and education in 3rd repeater
Now I want that pdf has to generated from this repeatres and the pdf should send to specifiec email add ...
Base on the following article:
How to generate and download PDF Report from database in ASP.Net using iTextSharp C# and VB.Net
I have created a rdlc report in webapplication and i want to send it through email as a pdf or a doc or image format.so what is the procedure for it.
View 1 Replies in my project i have a problem with sending document from local machine D Drive..
when i am click send button clicks it automatically fetch the document and send automatically ..
I have a process to send report to exchange server"outlook" i want to send it as pdf format. how can i do this process??
View 1 RepliesI want to send aspx page via email. So i converted it into pdf. The problrm is the pdf is getting created before the data is saved. So when i open the pdf my testboxes are empty. Below is the code am using. Also I want to send the pdf file as attachment.
protected void SendMail() {
var userName = "anusha-4.n-4@cognizant.com";
var toAddress = YourEmail.Text.ToString();
const string Password = "Mypassword123#";
string subject = YourSubject.Text.ToString();
[Code] .....
I have a page which has about 50-60 labels in it, and the data is pulled from the database and displayed on the labels. I need to export this data to an excel sheet and Email it when I hit on an Email Button which is at the bottom of the same page 1.e below the table(which has labels displaying data). I Am able to export the data to an excel sheet but not understanding how to Email rightaway without saving or opening the excel sheet.
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
I currently have a page which displays a report of multiple tables with the data values in them based on two parameters selected in dropdowns.
Now, I need to generate the same report for each combination of the two parameters as a worksheet in an Excel workbook to be sent as an email attachment. This is to be automatically generated daily, and I'm using the Global.asax to do this task at 1 day intervals. So each sheet will display multiple tables, one below the next, just like they display on the web page where the user can go to view them on demand.
I've seen plenty of resources for exporting a gridview to Excel, where a user clicks and is prompted to download an Excel file, but this is different.
My requirement is like .... I have a text box for ToEmail address , another control is to upload "n" no of files. And a button to send those selected files ToEmail address which had entered in textbox.
View 1 RepliesHow can i send the fileupload attachment (dynamically created) through email after inserting it in database?
protected void btnUpload_Click(object sender, EventArgs e)
{
for (int i = 0; i < Request.Files.Count; i++)
{
HttpPostedFile PostedFile = Request.Files[i];
if (PostedFile.ContentLength > 0)
{
string FileName = System.IO.Path.GetFileName(PostedFile.FileName);
Stream fs = PostedFile.InputStream;
[code]....
[URL] .... I use this article for exporting gridview to Excel in asp.net - c#.....but i found some error in my code
i am using stored procedure for sql command and my code behind is as follows....
C# code
public partial class Admin_ResultDisplay : System.Web.UI.Page {
SqlConnection cn; protected void Page_Load(object sender, EventArgs e) {
cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DbConnect"].ConnectionString);
//string strQuery = "select CustomerID,City,Country,PostalCode from customers";
//SqlCommand cmd = new SqlCommand(strQuery);
[Code] ....
How can I pass sql command at page_load event ? ?
I have generated a Excel report using C#,which generated fine.now i need to do all of those field is to be noneditable.how could i do it
Here my Export to Excel COde below:
#region Export to Excel
if (dt.Rows.Count > 0)
{
string filename = reportName + ".xls";
[Code]....
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then Dim dataSet1 As New DataSet dataSet1
Dim dataSet2 As New DataSet dataSet2 Dim dataSet3 As New DataSet dataSet3
Dim dataSets As New List(Of DataSet)() dataSets.Add(dataSet1) dataSets.Add(dataSet2) dataSets.Add(dataSet3)
Dim strout As String = Server.MapPath("test1.xls") DataSetsToExcel(dataSets, strout) End If End Sub
[Code]..
How to create each excel sheet non-editable (read only)
I want to put email button in my detail view form when user press email button it automatically move towards login when he enter the id pass automatically form attached of that detail view all this records n form is store in my database how can i make this possibel?
View 1 RepliesHow to Send Attachment as email with pre-defined names in Asp.Net ...I am not sending the mail with file upload control rather i am sending it with path on my database and file on server..The Email is working fine but the issue is that I want the Name of File As "Document" in Mail box,but its showing path as file name in mail box..
View 1 RepliesI used this coding for export to excel, by using this coding i got only 65,536 rows only. How to bind more than 65,536 records or how to move the balace records to sheet 2 by using this method.
Protected Sub btnExportExcel_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim ars_stock As New DataTable
ars_stock = cls.FillDataTable("select top 70000 * from spal..po_acc_details")
Response.Clear()
Response.Buffer = True
[Code] ....
I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .
View 2 RepliesI want to Export my gridview to Excel BIFF. Could any one suggest the approaches to do this.
View 2 RepliesI am working in a project where i need to export the Gridview data into an Excel file. after that in the newly geretated excel sheet i want to put some formula so that it gives the sum of all the columns. Exporting data into an excel file is done Using following code
[Code]....
how can i enter formula dynamically in excel sheet.