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:
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
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
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
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
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
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
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
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
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
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
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
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
Apr 28, 2010
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 Replies
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
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
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
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
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
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
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
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
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
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
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
