DataSource Controls :: How To Create User Ability To Upload Excel To Sql And Display Results As Table On .aspx Page

Mar 12, 2010

Hardware involved:
SQL Server 2000
Microsoft Server 2003 with IIS6 [code]...

The goal, from internal department (user) perspective:A department wants to "upload" an excel spreadsheet of data (product, term, rate, etc) to SQL (this will be from the internal network). The data is then saved to a webpage location for that department to view and approve. Once "approved," this data is displayed on the live web servers (public-facing website which is two load balancing servers).
Bonus:

The .NET application/SQL Server can send an email to the department reminding them to upload the latest rates (each weekday morning, then each Thursday afternoon) if rates have not yet been "approved."

From the development perspective, this is my general idea, but I may be wrong.There are three spreadsheets, each with one tab. The first spreadsheet is uploaded, and the .NET application puts it in a SQL table. I then need to display this table of data on a .aspx page for the department to approve before the .aspx page is pushed to the live web servers.

First, I need an interface for this department to upload Excel files. I need this application to save the data to SQL and display it in a .aspx page so that the department can look it over and approve it. The department needs a way to "approve" the page, and this action will push the data to the live web servers. Will this involve SQL data transformation services?

View 2 Replies


Similar Messages:

Web Forms :: Read And Import CSV File On ASPX Page And Display Results In HTML Table

Jan 24, 2016

Why do i get an error for the loop ? This piece of a script is in a asp file for reading my csv .

it needs to read all my rows in the csv ,, like now it gives me expected loop error 

if i put it under arrRows = split   it gives me only the last entry of the csv..

Do Until oInStream.AtEndOfStream
sRows = oInStream.readLine
arrRows = Split(sRows,",")
%>
<td><div align="center"><%=arrRows(0)%><br></div></td>
<td><div align="center"><%=arrRows(1)%></td>

[Code] ....

View 1 Replies

DataSource Controls :: Upload Data From Excel Sheet To A Table In Sql Server 2008?

Feb 1, 2010

i have an aspx page which has a fileuploader and a button

initially i have to browse the file and after browsing the file i have to check the extension if the extension is xsl or xslx then only i have to enable the submit button

once the submit button is enabled i have to insert this data into the table

and i have to display the number of succesfully inserted rows and no of unsuccessfull insertions .

success and failure is dependent on the mismatch of the datatype between the excel sheet and the database column

i am coding in c# but am unable to upload.

View 2 Replies

DataSource Controls :: Create A Simple Page Which Allows A User To Post Data Into A Data Table?

Jun 21, 2010

I want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.

Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?

I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.

View 4 Replies

DataSource Controls :: Database Design - Display Results On A Web Page Via The Grid View

Mar 10, 2010

Not sure if this is for SQL or .net! I have 3 tables which looks like

table1
ID Name
1 Jon

and

table2
ID Number Job
1 1 IT
2 1 Web
3 1 Admin

table1
ID ContractType
1 Temp
1 Perm

An inner join makes one table with 3 rows (I excluding the ID from table 2 for the join) which is saved as a view

viewTable
ID Name Number Job ContractType
1 Jon 1 IT Temp
2 Jon 1 Web Temp
3 Jon 1 Admin Temp
4 Jon 1 IT Perm
5 Jon 1 Web Perm
6 Jon 1 Admin Perm

I want to display these results on a web page via the grid view. However, I don't want to show the user 6 times! I want to show the user name once, the contract type once and each Job! What is the best way to do this? Is there a fault with the database design already? I assume the easiest answer is to not join them in a view but query each section 3 times from the website but I'd rather 1 connection only!

View 10 Replies

User Controls :: Upload Image And Display On User Profile Page?

Jan 8, 2014

I am making a Human resource Management system in which i have to make  employee profiles, there is a page in which i am entering employee name and uploading a rofile picture and i want the next page to show that image on a left corner of every employee...after clicking on the submit button of the previous page !

View 1 Replies

Databases :: Display Mysql Database Search Results On Aspx Page?

Aug 2, 2010

I am trying to develop a page where I am trying to search a database (MyQSL) and display the data in a table format. Some of the database entries, like category, is stored as integer values, but I want to display the category name in the search result (not the corresponding integer value). I have also another issue, every time I change the dropdown list values (which are having "auto postback" enabled) the <EmptyDataTemplate> is returned. At this moment I am using GridView. But I am ready to change this to any other method, like repeater or whatever...

View 2 Replies

Adding User Controls And Display On Default ASPX Page

Apr 7, 2013

Add 2 user controls and display them on your default aspx page. One control will be a simple list of store contact information. The other control will be a featured product control which displays a featured product of your choosing with an image and a description.

So i created a web user control page something like stewiecontrols.ascx

And I want to how to register the page <@control ...... src="" prefix name="" prefix tag="" /> the rest of the code in html <div> ..... </div> tags.

My question is this. I'm creating a master page and the default page is created using master page. So how do I register this .ascx page on default page. Should I register the .ascx page under master page or how. I want the user controls to only be shown on default.aspx page.

View 4 Replies

DataSource Controls :: Web Page To Display Data From A Table?

Apr 19, 2010

i want my web page to display data from a table, but instead of the "id" fields displayed, i want to display more meaningful field names. these are stored in other tables. my select statement is as follows:

SELECT [tblRelationship].[individual_id_1], [tblRelationship].[individual_id_2],
[tblRelationship].[relationship_type_id], [tblRelationship].[relationship_id],
[tblRelationship_Type].[relationship_type_id],
[tblRelationship_Type].[relationship_type_description],
[tblIndividual].[first_name], [tblIndividual].[individual_id] FROM
[code]...

View 12 Replies

Importing To Aspx Page From User's Excel Spreadsheet?

Mar 21, 2011

I have a requirement that the user will need to import a list of ID's to the asp.net website from their own spreadsheet. I will provide a button 'btnImport' which will use an OleDbConnection to read the spreadsheet and pull in the id's. I have that working fine in my local dev environment. My question is, when this app is running on a production server, will the user have to upload her spreadsheet to the server first? Or do I need to provide code that will find the file on her machine? I'm not sure how this part of it works.

View 4 Replies

DataSource Controls :: Display All Results In ObjectDataSource?

Oct 23, 2010

I have objectDataSource connected to report viewer.

This datasource have a select method to filter the results by Dep_id parameter

Now if i want to include all results(All Departments) what should i do ???

View 5 Replies

Forms Data Controls :: Create A Selection Table With Checkboxes And Generate Results Accordingly?

Jun 23, 2010

I need to create a selection table, i.e., a table with names and checkboxes.

When some checkboxes are selected, based on selections made on checkboxes i need to generate results(not from database), results are like different name of Is there some kind of architecture for this?

for example, we have name of columns as has legs, has feathers, has wings, can swim, carnivorous,herbivorous, etc

and based on selections i would say animal or bird or fish or amphibian, etc.

View 1 Replies

DataSource Controls :: Read And Upload (data) From Excel?

Jan 6, 2010

i have some issue and i need read and upload (data) from excel file to dbgrid threw ASPX page am using network server 2003

View 1 Replies

DataSource Controls :: Inserting Excel Data Via File Upload Into Sql Server Database?

Apr 28, 2010

I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.

View 16 Replies

Load A Base Aspx Page To Display To The User?

Jan 28, 2011

I have an asp.net project, and I load a base aspx page to display to the user. Then I ajax in the results of an ascx component and inject it via innerHTML in javascript. I have noticed that the ascx component loads slowly on the first page load, but instantly thereafter. This is really cool, but I do not understand how this can be cached, as the contents are generated by making several db calls. Does the server send some kind of hash to compare the contents to, to see if it changed on the server or not? Is this a browser thing or an asp.net thing?

View 3 Replies

SQL Reporting :: Exporting Datasource Results To Excel Not Just Report Data?

Jun 28, 2010

Exporting Datasource results to excel not just report data.My datasource is a stored procedure that returns a lot of fields that are not on the report itself. I would like the entire result of dataset to export to an excel file if user chooses.

SSRS / 2005 BIDS

View 1 Replies

Forms Data Controls :: Gridview: Filter Display Results Based On What Roll A User Belongs

Oct 20, 2010

I have enabled User Rolls and assigned several Roll names such as 10, 11, 12, etc. I have a SQL Table that contains various fields of information including one named AuthorizedUserRoll, it's nchar(2).

A logged in user should only see the records in Gridview that matches his/her roll.

I'm using Web Forms and VB.

View 1 Replies

Forms Data Controls :: Display An Excellike Pivot Table In.Net Web?

Apr 8, 2010

I need to display an Excel like Pivot table in ASP.Net web.I knew there is OWC Pivot table but it looks really ugly and not like Excel's.
Is there any control out there or we can create one of our own ?

View 3 Replies

Web Forms :: Display Windows Form User Control In Aspx Page?

Jun 10, 2010

I have the windows form user control with the name usercontrol.cs .. I want to display this usercontrol.cs in aspx page..I tried the below code..but it produced error.. how to resolve my proplem...thx

Control MyUserControl;
MyUserControl = LoadControl("usercontrol.cs");
MyPlaceHolder.Controls.Add(MyUserControl);

View 3 Replies

DataSource Controls :: How To Create The Pivot Table To Search The Table

Feb 26, 2010

I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.

I have a Gridview on my page which I need to be populated like so

Date NCMR

1/1/10-1/31/10 #

2/1/10-2/28/10 #

I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc

View 3 Replies

DataSource Controls :: Unable To Upload Xml Data To Table?

May 10, 2010

i am trying to upload excel sheet data to table which contains xml data type. one of the record in excel sheet contains xml data like below.

<location><locid>1</locid><locid>2</locid><locid>3</locid><locid>4</locid><locid>5</locid><locid>6</locid><locid>7</locid><locid>8</locid><locid>9</locid><locid>10</locid><locid>11</locid><locid>12</locid><locid>13</locid><locid>14</locid><locid>15</locid><locid>16</locid><locid>17</locid><locid>18</locid><locid>19</locid><locid>20</locid><locid>21</locid></location>

because of this length or some else...i am unable to upload excel sheet to table.

View 1 Replies

Datasource With Parameter In ASPX Page To Move In User Control

Sep 2, 2010

I have a page with some datasources in it. I am doing reenginering of the page itself and would like to split some parts of the page in several user controls.

In my code I have an ObjectDataSource object with the following params

[code]....

This piece of code automatically bind the hidden field "txtAlbumId" to the datasource. In my revision this datasource should be moved to a user control.

View 2 Replies

DataSource Controls :: BulkCopy From Excel To Sql Server 2005 Table?

Jul 1, 2010

I have an ASPNET application written in VB.NET which resides on the company's intranet. I am trying to do a bulkcopy from an excel file which is located in a secure folder on the web server to an existing table in Sql Server. The problem is that the folder requires a user name and password which is not the current logged in user or the ASPNET user. My question is how do I logon to the folder so that I can access the Excel file.

View 2 Replies

VS 2008 - Display Query Results In Table Format / Pagination In Div

Oct 17, 2012

I am displaying some query results in a div (table format). Is it possible to do pagination in vb.net in a div . Because i am not using any list view or data repeater or data grid control.

BID StartDate EndDate BidAmount Status
1 10/12/2010 14/12/2010 100000 Approved
2 05/07/2010 07/07/2010 500000 Pending for DAC

I want to display only 10 records per page.

View 6 Replies

DataSource Controls :: Create An Excel File With Sql Server?

May 10, 2010

i want create a file excel from sql server? how can i do?

and can i create it using also sqldatasource control?

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved