We are an accountanting firm who wants to upload tax returns in the .pdf form for our clients. We want them to be able to login, receive that status of their return, and if completed download the .pdf. But what we cannot have is everybody having access to everybody's returns, it has to be exclusive to that client and their username and password. It also has to be a simplified process where once a .pdf is made, one of the employees will have administration access to upload the file to the website corrolating with a clients information. I'm assuming that would be done by a web application?? I have already set up a a login control, on the login.aspx page, along with the ASPNETDB.MDF through the ASP.NET Configuration tool. Also, I'm assuming the file naming process of the tax returns would fall into play somewhere?? I some how need to take the login information from the ASPNETDB.MDF and relate it to their PDF's. What I have explained is the major purpose of the site and if I could find the right help I would greatly appreciate it because I've been stuck on this road block for awhile.
Hi is it possible to have a page of a website display the status of a database or MS SQL with .Net code ?, if so what code would i use. Any help would be appreciated.Thank You
Hi all - am having trouble working out what would be the best way to do this (most efficient)I have written an order, despatch and accounts system. To get a list of orders ready for despatch, I have written a query which calculates the amount of items ordered against the amount of items despatched from that order. If there are any outstanding items, then this order is in the list of orders which are outstanding for despatch. I am having trouble working out how to go about creating a list of orders ready do be invoiced... Orders that are ready to be invoiced can be completely despatched orders or part despatched orders. That is to say that if an order is only half despatched, my client still wants to be able to raise an invoice against that part of the order. I envisage creating a query which checks my orderline table to see if the item has been invoiced and creating the list from there. But as the application is used more and more, this query will take longer to run? ANy ideas? Thanks. Steve.
I have a requirement to present computed sales order status value
Parent table : consumer Child table of consumer : sales order Child table of sales order: items
Items table has status column with awaiting, accepted , rejected.
Status of the sales order should be set as following If all items are rejected then sales order status=reject Or if at least one item is accepted then sales order status = accept Or if items status is awaiting then sales order status = pend
Query to find all sales order per consumer with computed order status for each sales order.
I am looking for assistance coming up with a function (or maybe not a function if there is a better way) to make the Status column in my order table dynamic. The default value for new records will always be "1" to designate a quote. At this point the field is not dynamic. Once the customer confirms the order, the user needs to execute a command to change the status to "3" to designate a Confirmed order. At this point the field needs to be dynamic based on the shipping records. There are two order details tables. One for sales items and one for rental items. Each of these details tables has their own shipping record. the CheckInOut Tables are for rental while the Ship tables are for sales. So, if some (but not all) of the items in either of these order details tables has a shipping record associated with it, then the status should be changed to "5". If everything has been shipping, the status is changed to "4". If everything has been shipping but some items have been returned, the status is "6" if everything has been shipping and all of the RentalDetail items have been returned then the status is "7" and if there is any other combination of a variety of ships and returns, the status is "8". Also, at any time, the user needs to be able to execute a command to change the value to "2". once the value is changed to "2" the field stops being dynamic again.
Below are my tables creation commands.
CREATE TABLE OrderHeader ( OrderID int identity primary key, Status int, StartDate datetime, EndDate datetime )--Use Type 1 = "Quote" Type 2 = "Cancelled" Type 3 = "Confirmed", Type 4 = "Shipped", Type 5 = "Part Shipped", Type 6 = "Part Returned", Type 7 = "Returned, Type 8 = "Mixed" CREATE TABLE OrderRentalDetail ( OrderRentalDetailID int identity primary key, OrderID int FOREIGN KEY REFERENCES OrderHeader(OrderID), ItemName varchar(30), Qty int, SiteID int, ) CREATE TABLE CheckInOutHeader ( CheckInOutID int identity primary key, Type int, SiteID int, ActionDate datetime )--Use Type 1 = "Ship" Type 2 = "Return" Type 3 = "Lost" CREATE TABLE CheckInOutDetail ( CheckInOutDetailID int identity primary key, CheckInOutID int NOT NULL FOREIGN KEY REFERENCES ShipHeader(ShippingID), OrderRentalDetailID int, Qty int ) CREATE TABLE OrderSalesDetail ( OrderSalesDetailID int identity primary key, OrderID int FOREIGN KEY REFERENCES OrderHeader(OrderID), ItemName varchar(30), Qty int, SiteID int, ) CREATE TABLE ShipHeader ( ShippingID int identity primary key, Type int, SiteID int, ActionDate datetime )--Use Type 1 = "Ship" Type 2 = "Return" CREATE TABLE ShipDetail ( ShipDetailID int identity primary key, ShippingID int NOT NULL FOREIGN KEY REFERENCES ShipHeader(ShippingID), OrderSalesDetailID int, Qty int )
I have to Select Order, Order Details and Order Status
Order Status is determined from Order Stage as follows:
If, at least one order detail line(from Order Details and Related Order details table) is approved, that Order status=Approved.
For the example, Order Status of Order ID=2, is Approved based on order status for order details lines 3(from table 2) and order details ID 1 and 2 (from table 3)
How to combined order stage from table 2 and table 3 and then compute order status.
We are having trouble figuring out how to create a view for this scenario:
We have a status log table that holds an order number, statusdatetime, and statuscode. This table will have multiple status' for the same order number. I want to create a view that will give me the most current status (by statusdatetime) of each order number. This view would show: order number, statusdatetime, and statuscode.
Created Prod order status report, in status, we have different status
created =0 start =4 released =3 reported as finished =5 ended =7
I have the report, in report don't want to show the Prod order for ended status, how can I add the filter for this so it can show for all the other status not ended status. when I did on filter <7 , it did not work
husband built web site, hosted by 1and1, husband can't help right now and 1and 1 won't. I can't get the connection string correct and need some advise. This is the info 1and1 gave me for my db.
Database Name db212583089 User Name xxxxxxxxxxxxxxxx Password xxxxxxxxxxx Host Name mssql02.1and1.com Description jamm Status My bd is uploaded to their server and should connect with the global.asa page, this is what I have as a connection right now and it's not working <SCRIPT LANGUAGE=VBScript RUNAT=Server> Sub Application_OnStart '==FrontPage Generated - startspan== Dim FrontPage_UrlVars(1) '--Project Data Connection Application("Database1_ConnectionString" = "PROVIDER=SQLOLEDB;DATASOURCE=msssql02.1and1.com;DATABASE=db212583089;UID=dbo212583089;PWD=xDBXzNTt" Application("Database1_ConnectionTimeout") = 15 Application("Database1_CommandTimeout") = 30
this is the error i get on my website when i try to access my db.
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/JAMMDatabase.asp, line 131
This is the code on line 131, some before and some after: strProvider=Application("Database1_ConnectionString")
set objConn = server.createobject("ADODB.Connection") objConn.Open strProvider(line 131)
set cm = Server.CreateObject("ADODB.Command") cm.ActiveConnection = objConn
right now I am totally lost with all this, if someone can help would really appreciate it, thanks, debi
Just wondering if there are any online recources on writing SQL in a website? i have a database linked to an sql server, and from access etc. i can access it no problems.. just wanting to access it from a website.
Hi i am new to SQL and have been asked to create a page with a SQL database that has got the employees names and numbers on it and i have got to display this on a webpage i have got the sql database on my local pc and have setup the fields and created the database i just need to know how to display the data on a webpage the database name is employees and i have then got fields like email, Name and Department is could someone give me an example using the database name that i have got and the fields or points me to some sites also i would like to place them in coulums how hard is this
when i select the 1st parameter in the report(in webpage) ... then the complete page is getting auto refreshed...same is happening for all the parameter selection...is it not possible to stop it from refreshing....
simply to say i want to get data without refreshing...
few ppl suggested me to use AJAX control but as iam not much familliar with AJAY iam trying to find some other way...can u help me pls....
Hello, I am trying to put on a webpage a picture with a discription, however when I create an MxDataGrid and run the page all the info in the datagrid is correct except the image. All that is in the field is "System.Byte[]". I am new to web programming but I have created many databases and using Access as a front end where this process is very straightforward. Can anyone tell me how I can make this work? I want to store images along with other info about the image in the database so that I can simply query the database and have the page fill from the query. Thanks whill1
I am happy with my mySQL install. I can quite happily created tables and fill them with initial data using mySQL Client
What I want to do now is via a web browser be able to add data to various tables etc. I need to make the web entering part of it as simple as possible for the users.
How to dynamically and partially Update the webpage? The content ofthe part of the page is from the user's requerement and get data fromthe server side.The purpose is to speed up the page update. We have a page that mostof content are static, only small part is changed per user's selectand the replying data need to get from server side database. Thanksfor help. Gene
I would like to display an asp page in a Reporting Services report. However, I do not want to have to click a button and navigate to it. I just want to display it sort of like a subreport. Is this possible?
hi this is raja sekar.k from bangalore,i need to know how to make a webform with the "BACKUP SQL DATABASE " from a user.. if it is possible.. please help me ..thanksregards Raja Sekar.kChola software consulting pvt ltd..Bangalore
i have a search engine i have built for an online store. On the search page there are 6 or 7 queries that are run that return products, finishes, styles, rooms, and things like that.
If i go into SQL management studio and run all 6 of the queries at the same time it takes usually about 3 seconds to complete all of them consistently no matter what search parameters are sent.
now when i actually go and run a search on the website itself it takes the page more like 15 seconds to load. I have made sure there are no other queries running in the header/footer or anywhere else on the page to rule out other things slowing it down. I have even turned off all the images on the page and it doesnt seem to change.
im building new dataset objects and filling them with .NET then using a for each loop to output the items. Is this the preferred way to bring data back or could that be slowing things down?
are there any tools out there i could use to view whats slowing things down?
I have created a report in reporting service 2005 and i have succesfully integrated the report in asp.net webpage. But i want to know whether it is possible to access the methods and properties of (report)rdl file in the asp.net webpage. If it is possible then please tell me how to implement it
Hi, I've installed SQL Server Express Edition and Reporting Services on my PC running Windows XP Pro SP2. When I point the browser to localhost
eports I get a "Internet Explorer cannot display web page" page.
At home I've been following the excellent video series on the msdn website for SQL Server Express everything worked okay at home, this is on my work PC.
I've checked reporting services service is running and that the reports virtual directory is in my IIS configuration. At work I had been following a Ms Visual Web Developer tutorial, I'm still able to view this site, so my web server is running.
I've also uninstalled SQL Server incl reports and tools and reinstalled but still have problem. I did notice that the report and reportserver virtual directories security is set integrated windows autentication (as is my working system at home) if I change to anonymous access the page loads but only the 'SQL Server Reporting Services' title in the top left. No menu options appear below? I was beginning to think it's something to do with my securiy setup because of this so I compared the security groups generated by reporting services with my home pc and my work pc both exactly the same:
SQLServer2005ReportingServicesWebServiceUser$mypc$SQLEXPRESS user: ASP NET
SQLServer2005ReportServerUser$mypc$SQLEXPRESS user:NT AuthorityNetwork Service
I've also checked the problems listed on: http://msdn2.microsoft.com/en-us/library/ms345220.aspx
but I still have same problem?
Can anyone help me or point me in the right direction?
Is it possible to access a webservice from within SQL 2005?What I am looking to do is place a trigger on a specific table, and detect if a specific column is being updated. If it is, I want to launch a robust process that does x, y and z. Something like this:1) record is updated indicating that an account is closed.2) SQL launched a webservice/ aspx page that builds an HTML email template and then mail it.thanks!
Hi, Does anyone know of a good resource for displaying data to an excel file from a SQL stored procedure. I'm working with VS 2005 and I have a webpage that will retrieve data from SQL 2000 and display it to an excel file. All examples I've found on the net was not exactly what I was looking for. Thanks
Got a beginner question here... Let's say I have a database table that houses server information with four columns: make, model, serial #, ip address. And assume there are ten rows with that information filled out. How could I display all the rows of information on a single webpage (ASP.NET), with all the fields being editable; and a single save button that would send any changes to the database (in reality I guess it would be sending all rows and fields to the database, and just overwrite the previous data).
Could a page such as that be created using FrontPage 2003 or Dreamweaver MX 2004?
This would be strictly for updating information. I would have a separate form for adding a new entry.
Hi all, I want to upload a text file from a webpage and save the content to our SQL Server database, a BLOB image column. I got an error on [myData] in the following sqlparameter: Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData) - Value of type '1-dimensional array of Byte' cannot be converted to 'Integer' How to fix it? Also,Did I do the right code to upload a text file? Thank you. --------------------------------------------------------------------------- Sub UploadResume_Click(ByVal source As Object, ByVal e As EventArgs) Dim ResumeFile = uploadResume.PostedFile Dim contentType As String = ResumeFile.ContentType Dim contentLength As Integer = ResumeFile.ContentLength Dim myData(contentLength) As Byte ResumeFile.InputStream.Read(myData, 0, contentLength) If Not (uploadResume.PostedFile Is Nothing) Then Try 'upload file to SQL Server If Not conHRISDb.State = ConnectionState.Open Then conHRISDb.Open() End If Dim strSQL As String strSQL = "Insert into Mgmt_App_Resume_Table (Applicant_ID, App_Resume) Values (@AppID,@AppResume)" Dim objComd = New SqlCommand(strSQL, conHRISDb) Dim parmBlob As New SqlParameter("@AppResume", SqlDbType.Image, myData, ParameterDirection.Input, False, 0, 0, Nothing, DataRowVersion.Current, myData) objComd.Parameters.add(parmBlob) objComd.ExecuteNonquery() conHRISDb.Close() Catch exc As Exception conHRISDb.Close() End Try End If End Sub
I have a webpage that should display the database names from the master.sysdatabases in a dropdownlist. The code for the stored procedure works fine in Query Analyzer and returns the list of all database names under that instance of SQL-Server 2000. The code: select name from master.dbo.sysdatabases order by 1doesn't return the sysdatabase names to the ASP.NET webpage when executing the stored procedure. It returns: System.Data.DataRowViewWhy does it do this and how can I fix it?Tx
I am trying to access the TableAdapter object from my WebPage Class on the Page_Load event , so I can modify the Command.CommandTimeout. Unfortunately, I cannot find a way to have access to the TableAdater object.
Make a few simple pages to enter data into multiple tables in my SQL DB.
I have the DB designed and IIS setup but I am trying to wrap my head around the php connection to the DB and then relating the tables/columns in the "Input" page.
After this is done I will use SRS to use these entries to show reports hourly.
Hi all! I'm a newbie when it comes to SSIS and web development (I'm currently in school for Mechanical Engineering). I'm trying to develop a website in which I can upload an excel file and have the contents written to a SQL database. I have been successful in creating a package in which I point to an excel file and it writes the contents to the desired database. With this, I was hoping that I can modify my website to take the file which is being uploaded, change the name, and then have the SSIS package run, in which it will look for the named file in a certain directory and upload the contents to the SQL server.
Ideally this would be the order of events:
User selects and uploads a file to the server (button click) Server renames it and places it in a certain directory SSIS package runs and extracts the data to SQL database
I am trying to connect to a Web page from SSIS and I've tried both http connection manager and a Script Task but none of them seems to be working.
I get the following errors:
Through Script Component: Exception has been thrown by the target of an invocation.
Through http connection manager: The remote server returned an error: (503) Server Unavailable.
Here is one of the VB code I've tried:
Public Sub Main() Dim MyWebClient As New System.Net.WebClient() Dim proxyObject As New System.Net.WebProxy("BANANA:8080", True) MyWebClient.Proxy = proxyObject
I have a Login page which asks a user for a Password (just a Password - not a Username/Password combo). The Password then is verified against my MS SQL table. If the password (unique for each user) is correct, the user is redirected to my Survey.asp page.
What is the proper code I need to display "Welcome Username" on my Survey.asp page? My SQL table does have a column titled "Username".
I know this has to be fairly simple but I'm a marketing person and not a programmer. Thanks in advance for your help!
