.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

I need a for to submit to SQL DB then generate and email report.

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
Hi Everyone,   I am new to the forums as well as new to asp.net as well as most programming languages.  I am needing to develope a page for a website where customers can fill in a form on the page and click submit.  I would like the form data to be inserted into a fresh brand new SQL DB.  I then want the data from each customer to be turned into some sort of file (ie PDF or just a form) and emailed to a specific user as the user hits the submit button to submit their information.   Is there an easy way to do this or is this something that should be handled by a few different methods or software or languages?  Any and all scenerios and information is greatly appreciated!   Thank you,   Wesley Sothard

View Complete Post

More Related Resource Links

How to generate pdf from 2005 rdl report files from command prompt?

Hi All, I have a scenario like this, i have 10 rdl reports, which needs to run on a job basis with out any user interaction. Tell me is there any way to generate the pdf from command prompt using existing 2005 rdl files. Your help is more appreaciated!! Thanks, Sarvesh M  Sarvesh

generate ID after click submit

hi all..!I create a webform to register new customer..In my form i have "ID" for customer.And i have database with table "CustomerDetails" with existing data..Existing data "ID" start from 300000 and already have data till 302000..Now i want to use the database to register new customer with "ID" 302001..and i want to generate ID when click "submit" button...this is my problem..i wanna generate ID after click submit..

Generate Report Excel from Client??

Hi all, is it possible to create an Excel report from client?i have a webform that uses the libraries Interop.Excel.dll, Interop.Office.dll, Interop.VBIDE.dll to create an excel report (with statistics graphics) but it do it using excel from server. By company policies we must uninstall office from the server. But the Excel's reports are still useful and i need a way to remake it. then, is possible use the client's Excel to make the reports? exists another tool that allow me make this reports without using excel???Thx in advance!!


I have to generate a report in this format:   staffcode   Name   dateintime    dateoutime   duration   for example: Staffcode  Name     01-08-2010intime   01-08-20100uttime   01-08-2010duration 1001        Amit             09:00                   18:30                     09:30 In sql server management studio for 5 days i have written query like this Declare @intime table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 InTime] datetime, [02-08-2010 InTime] datetime, [03-08-2010 InTime] datetime, [04-08-2010 InTime] datetime, [05-08-2010 InTime] datetime ) Declare @outtime table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 outTime] datetime, [02-08-2010 outTime] datetime, [03-08-2010 outTime] datetime, [04-08-2010 outTime] datetime, [05-08-2010 outTime] datetime ) Declare @Duration table ( Staffcode varchar(7), Name varchar(100), [01-08-2010 Duration] datetime, [02-08-2010 Duration] datetime, [03-08-2010 Duration] datetime, [04-08-2010 Duration] datetime, [05-08-2010 Duration] date

report generate vwd 2008 - website data sources window empty

I need to create report in asp.net web application, I'm working on vwd 2008 express, installed report add-on i have create dataset file xxx.xsd and use storder procedure for data adapter. when I am trying to add columns into report body I cannot see dataset in website data sources window. when i right click on window it just show refresh option. how can I get my data set into window. and add columns in to report? please help... 

generate dynamic fields crystal report

  I want to add a Dynamic column in Crystal report at run time. Because I dont know about the columns in design time. The columns will come based on the user selection. So i want to Add a column to Crustal report at run time. I am using Crystal report. If it is not support to add column in Crystal report at runtime. Please kindly give the other solution or other third party tool like. Which version will support to add dynamic column in Crystal report? i already used the crosstab report but thats not work for my scenario.becoz i want to add another colums at right side ( after total of each row ) , which is crosstab report not supported 

How to generate report from RPL file


I have Integrated my Reporting service 2008 R2 with Sharepoint foundation 2010. I have created few reports. For one of the report I have setup a subscription. Type of subscription set is RPL Renderer.

Once this subscription was executed, I can see RPL file in my Sharepoint document library. Now the question is what to do with this RPL file. How can I generate Report from this RPL file.

I checked that Neither Report viewer control nor Report builder accepts this RPL file.

I also could not find much help over RPL renderer on Internet.

submit infopath form to sharepoint library and email



how can i submit an infopath form to a SP library as well to the approvers email.

the email has to send to the manager's emailaddress that is automatically filled in the form.

i now how to submit to an email address but how can i use 1 submit button for both actions?


Error for delivering a report via email by using the data-driven subscription



I have created a SSRS 2005 report to export in the Excel format as a batch execution. I have made a data-driven subscription, I have specified the from mail address (with my address) and the smtp server in the RS configuration tool, I have set the SQL Server Agent account with my domain user, but I have an error about the from address is refused from the server and the client was not authenticated. I have tried to specify the IP for the smtp server.

Any suggests to me in order to solve this issue, please? Many thanks

how to generate one report from 4 cube


how can i generate one report from 4 cube? is there any process that i have to follow and which type of cube use for which dimension like MOLAP,ROLAP,HOLAP.

e.g if i have product dimesion then which kind of cube i have to use

thnx in advance


How to generate an excel and send it as email attachment in SSIS 2005 Script Task Component?


I am using a "Script Task" component. I am trying with following three simple steps:

1) Obtain the excel content in HTML

Dim reportInHtml As String = GenerateHTMLReport()

2) Generate an excel with below code:

Dim message As MailMessage

message = New MailMessage(fromAddress, toAddress, subject, String.Empty)

Using memoryStream As MemoryStream = New MemoryStream()

        Dim contentAsBytes As Byte() = Encoding.UTF8.GetBytes(reportInHtml)
        memoryStream.Write(contentAsBytes, 0, contentAsBytes.Length)
        memoryStream.Seek(0, SeekOrigin.Begin)

        Dim contentType As ContentType = New ContentType()
        contentType.MediaType = "application/ms-excel"
        contentType.Name = "Excel_Report.xls"

        Dim excelAttachment

Generate report in Excel format with formulas



I have a report with simple calculations (adds some fields). The report is requested in excel format via Reporting Services WebService.

I would like to have the generated excel file to have the formulas, not just the results. I tried to put the formula text in report definition, but it does't work, it appears in excel as text, not as formula.

How can I do this?



Trying to generate dynamic link to a document within approval workflow email message


In the out of the box approval workflow, the fields below are used to dynamically create a link within the email for a user to access the item/document to be reviewed:


Review [%TaskProcess:Item Title%].[%Variable: InternetLink%]

If I create an approval workflow and modify the text around what comes out of the box, the link works.  If I add those exact fields (period and space included) via the "Add or Change Lookup" box (field selector), it doesn't work. It displays the title as a link but without a document extension of XML (for Infopath form for instance).


I don't want to have to delete my workflow and recreate it just to get that link to work.

Any ideas on why the "[%TaskProcess:Item Title%].[%Variable: InternetLink%]" only works when it is created out of the box versus building the string manually ?

change "View Report" Submit button Caption in parameter area


Hi All.

Using SSRS 2008.

Can please suggest, Is there a way to change the caption of submit button that appears when we have report parameters. "View Report" to something else

Thanks for replies.



Generate a dynamic number of custom report item instances in a report


Are there any solid examples/tutorials/demos of how to dynamically generate custom report item instances in a report based on the amount of rows in a data set?

Additionally I would like to insert these custom report items in a particular order based on a field in the data set.

Any help/pointers/articles would be appreciated!

Generate Report in excel


Hey im new to this could u please tell me this

ive got a table and any updated to this is captures in a new table2.

all I need to do is to generate any update's ( which are captured in table 2 ) to be reported in an  excel sheet.

how do i do this.

i only need to show the updates in the excel .

thanks for the help. 

Dynamically generate a number for email title.


Hi, which part of the code do i modify in alerttemplate.xml to make my email title appear in such  a way that it is:

"Please approve Request 01"

"Please approve Request 02"

"Please approve Request 03"




... and so on


The title which i input is Please approve Request. I want the number to be auto generated and auto increment each time a new email is sent. 


Thanks in advance! :D

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend