I have developed a desktop program for a customer.I have used SQL Server on my ofiice while i am developing.Now its time to install the program my customer's office,Which SQL edition i should use? (At least)Only usage for them about SQL is: Backup and storing datas.
View 4 Replies
(1) Customer would like data resides with their machines/server without expose the data to internet
(2) I want ASP code resides in remote PC in my office
So the idea is they access (via internet) my office PC/server with ASP codes on it and use the software, and the client PCs use data on their own server and these 2 combined to produce the result. I know this seems impossible but any idea to fine tune and still achieve (1) +(2) practicably?
I've created a SetupWizard, but can't get it to show the Icon for the shortcut on desktop and program menu. The installation goes fine without any errors, the only problem is the icon.
I've made a shortcut of my exe file in the Application Folder and dragged the shortcut to the Desktop folder, then on the shortcut properties, I assigned it an icon picture located in Application Folder.
I am creating a Web application using MVC in asp.net . I have to create a application such that a user which is on desktop can see my applcation in that GUI and a user which is on Smart device or mobile can see application in Mobile view . Is there any use of MobileCapableViewEngine in my MVC application and how it is used ?
View 4 RepliesNow i have a database table holds all info of my (customers) such as first last names and address phone number etc ... and i able to edit delete update their info from my side using the admin page that contians gridview i created. If several customers logged into their account pages, and each one wants to update his information,
How can i let the specific customer info be showin on his page for each customer? (I have one databse table and it contains a primery key column called "MemberID") how can i make the new subscribed user get his info that he did input or i would like to add to it, showin on his account page?
show the desktop(share desktop) to other person on asp.net or in 3rd free party control.
View 7 Repliesinsert into @rawdata2 (cust,lysale,lycost,load_year)
select cust,sales,cost,load_year
from @rawdata
where load_year=@yr2
insert into @rawdata2 (cust,ytdsale,ytdcost,load_year)
select cust,sales,cost,load_year
from @rawdata b
where load_year=@yr1
how can i make them line up correctly depending on the customer name it will put it in the right field. rawdata 1&2 are tables i created in memory.
I'm not really sure where to start with this and therefore can't pick a more specific area to post. At first I though this might be something I would do in IIS7 but on reflection i think it needs to be at the application level. I am developing an application which will as part of it's function provide a unique website (custom CMS) to my customers. Each person who registers will have their own site accessible via a url such as [URL]. I need someway to take this and work out which customer it is and then load the rest of the pages with their content. So the site may have a home, about us and news pages for example and be themed to the customers requirements. Each of the pages will be the same aspx file and application for all customers but the content and style will be loaded from the database at runtime. I'd like for the duration of the visit for everything to appear as if from this subdirectory without actually creating them for each customer. so thy could visit [URL] but it actually loads [URL] and loads the content based on the customer site the visit is viewing.
I'm not really sure how to approach this. Maybe using a session value to store the customerid for the site the person is viewing which could be calculated from the URL on the first visit. I presume other people have done something simialr in the past. Where it gets more complex is if I then want to offer customers to have there own domain name pointed to the site. In that scenario they would have say [URL] which points to my server and bound to my application [URL]. All pages would have look as though they were on the customer website such as [URL] but still point to [URL] in the background and also somehow link to the customerid in the database to load the correct content.
using sql server 2005. I have table setup as follows
Table: Orders
Col: CustomerID
Col: OrderID
Col: OrderDate
so a given Customer can have many orders in this table however I only want to return the last order (using OrderDate) for each customer. how do you do this? I assume that I need to group by customerID and then use max on the OrderDate but not sure of the exact syntax.
next week i'll have to install the ASP.NET Website on a customer server on site. All server side requirements for hosting a ASP.NET website are met.
So how do i now create a installation / setup for the website to make sure that everything runs fine?
I think it's important to mention, that i'm using 3rd party compos (DevExpress).
For example where i have to install (path) the site?
I am currently building a webshop for my own where I want to increment the product-stock when the user fails to complete payment within 10 minutes after the customer placed the order. I want to gather information from this thread to make a design decision. I am using SQL Server 2008 and ASP.NET 3.5. Should I use a SQL Server Job who intervals check the orders which are not payed yet or are there better solutions to do this.
View 1 RepliesJust looking through database design and wondering what would be the better option. I have customers, who all have orders, pickings, deliveries and invoices. Now an invoice can't exist without a delivery, a delivery can't exist without a picking and a picking can't exist without an order. So I could set the tables up in a linear fashion. e.g.
Customer -> Orders -> Picking -> Delivery -> Invoice
then in Orders, there would be an ID field, with a customerID field and in Picking, there would be an ID field, with an orderID field and in Delivery, there would be an ID field, with pickingID and in Invoice, there would be an deliveryID field. Linking them altogether, again, in a 'linear' fashion.
The problem is if I want to get, say, all the invoices for a specific customer, my query would be something like
[Code]....
My other option would be to have in a customerID column in each of the tables meaning a much easier query
[Code]....
comes with another calculation query.In this one I like to get the total amount for the customer in the OrderDetail table. I can't figure out how to do it. And I only want to receive one row. With this SP I get all rows in the orderDetail table.
[Code]...
i want to develope desgin like facebook .where i have posts and comments will pick from the database that i inserted earlier.what will be the best possible way to do in the same template.
View 4 Repliesis there any way i can make use of windows programming in my asp.net based application and i can determine if my application is running on server or desktop?
View 2 Repliesi have vs team system 2008 sql server 2005, i dont have template for mvc when i clik on new website or project. providing information that "What to install to develope different application demos using asp.net 3.5,mvc,C#,WCF,WPF"
what are the steps to create best working environment, later i want to add sharepoint
so I'm in a strange development situation and am a noob at the bits I'm tasked with - just to make life fun and interesting.
My fellow developer has written programs in VB.Net and placed them on the server. He wants a web front end that users can click a link and have that run the program on the server.
Sounds simple, but I've spent days searching the internet and found only two solutions one of which looks sketchy on security and the other is so complex I'm not sure how to make it fit my local variables.
I'm writing ASP.Net on an MVC Framework using C#.
So, in terms for the simple minded to understand, is there a way to do this? Are there links which I used the wrong keywords and completely missed?
I have an executable file that works fine by hand locally. It converts a file to another new file by some parameters. I'm using ASP.Net and that executable installed win2003 server sp2. I can use it from local but, I can't execute the program from a web browser using system.diagnosting.process. When I use that, I can see the process in task manager with user name "NETWORK SERVICE", and it won't dissappear without ending process by hand and won't work. I tried impersonation, try as a web service, edited local policies, apply all privilages, etc...
View 1 RepliesSo I'm completely new to web development, but I hope to reach a level of knowledge on how to build a Web Server that can interact with my TCP program, like a chatbox basically. How can I achieve this and where should I start learning?
View 3 Repliesi would like to update database which resides on web server from my database which is on my computer. One method is to upload the file and than make a connectionstring. But its not possible while I do so in every 10 secs.
Is there any method which can make the connection string from desktop to web server or any other way.
I want to ask the following:
Does anyone have an example of some code which executes an SSIS package from a ASP.NET web app using VB.NET?
I have built a web application and want to be able to execute the SSIS package when the user clicks a button on the web page.
So far I have:
[code]....
I need to know how to set this up so it runs remotely. I have searched MSDN (useless), [URL] and sqlservercentral.
I have a problem with upload a picture from desktop to a folder on server. The problem is that it seems to work about 1 of 10 times wich confuses me. Perheps something with this code is not enterily correct ?
First I check for if Pic1.jpg or Pic1.gif exists and then delete it if it exist. Then I want the uploaded picture to be named the same. Pic1.jpg if it is .jpg format or Pic1.gif if the uploaded picture has a .gif format.
[Code]....
i hosted my application on the IIS 7
now i've a requirement to show the desktop alert on my IIS desktop when an event fires
I have been trying to make a program work with our IIS server, but it's run into a tricky problem that's been driving me nuts. When I debug the program, everything works perfectly; users are able to log in and they see the appropriate content according to the user's role. When logging in from a remote location, however, the program seems to have trouble finding the users' roles. Users can log in, but they cannot see any role-specific information, so they are stuck on the login page forever.
I tried adding a line of code to find the roles of a particular user. In debug mode, it returned the roles correctly, but when accessed through the server, it returned an empty array that caused my site to crash.
I am creating a vb 2010 application and I am using sql server express as my database. I need to create a backup and restore feature for the user so that the user can backup or restore the database while using the program. I have nop clue where to start.
View 1 Replies
