troubleshooting Question

Automating A Report on SQL server using a webform in c#

Avatar of Ramona
RamonaFlag for United States of America asked on
ASP.NETWeb DevelopmentMicrosoft SQL Server
25 Comments1 Solution127 ViewsLast Modified:
I have been charged with the task of Automating a report that is on a server in rackspace. I only have the following information. I do not have direct access to the server I only have the ip and the following information.

The following is the SQL the analysts run every morning. We’d like for you to create a web application in C# that will automate this process.

 

    Create a screen where they can input their start and end dates.
    Retrieve the data based on the dates provide.
    Return the results.
    Display the results on the screen.
    There is no design/specific look & feel, just make sure the form and report displayed is user friendly.
    Export report to Excel.

 

-------------------------------------

 

SQL:

SELECT [FirstName]

      ,[LastName]

      ,[Amount]

      ,[Fund]

      ,[PaymentType]

      ,[CCNum]

      ,[CCType]

      ,[ACHNum]

      ,[Frequency]

      ,[FrequencyDate]

      ,[TransDate]

      ,[TransID]

  FROM [database].[dbo].[tblName]

  where TransDate >= '07/27/2015' and TransDate < '07/28/2015'

  order by TransDate

 

-------------------------------------

 

Database connection in web.cofig:

<add name="servername" providerName="System.Data.SqlClient" connectionString="server=111.111.111.111;database=databaseName;Integrated Security=FALSE;user=*******;pwd=*******;" />
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros