Configuration :: Creating Tables And Sprocs From Install?
Sep 18, 2010
I'm going to deploy my first app soon, and I would like to do a few things:1. Deploy the tables and sprocs needed for asp.net's membership stuff2. Create my own sprocs and set rights3. Edit the web.config fileIs there any way to do both of these? The only thing I will have to go on will be the connection string...
on installation of an application i need to lookup 2 tables and add rows on the next availible(free) row as well as edit a (field in colum) in the new row. I dont know any sql really how would i go about doing this? I have a custom installer class i just dont know the sql
In Visual Studio 2010, I don't see the Visual Studio installed template to create an ASP .Net Web Service Website (when I click on File->New->Web Site..) if the target framework is 4.0. However if I switch to FW 3.5 or lower, I do see the template.
I need to add potentially a large number of items to a dataset, this currently works but is quite slow. There are some minor changes I can make to make this fast however the main culprates are the insert statements which are quite complex, With the deletes I changed the structure to be DELETE FROM TABLE WHERE ID IN () Instead of a per ID statement which made quite a difference executing for every 25 rows.The SPROC is linq enabled DbContext.MYSPROC(params) is there a way I could add the Sproc in the context to a batch group that I then execute when the currrent count of insertable items = 25? for each item in insertitems 'Don't want it to execute here
Batch.AddSproc(DbContext.MYSPROC(params)) If Count = 25 THEN Batch.RunSProcs next
Anyway, I need to pick up on another person's project who has left and essentially what I have is his code base which compiles under Visual Studio2010 Ultimate. I need to dig into his code (VisualBasic) in order to fix some minor problem & make some enhancements. So anyway, I started it up and compiled everything. Then I press the little green arrow button, and the project starts up and launch the browser which then access and run this project. However I need to run this under IIS because I have to try access the webservice from a remote platform. Meaning this has to serve a remote connection and not just the browser from within VisualStudio. Could someone give me a little howto in order to set this up and running under IIS?
I want to update some values in the applicationSettings section (*not* appSettings) in the web.config file but all examples use this which only works for appSettings
how to create tables in my database programaticlly for my website. I've looked all over trying to figure this out, but cannot seem to get anything. Pretty much what is going to happen is the user is going to create an article, and it will have different sections. So each article will be a table, each table will have columns such as "title", "literature","tags", etc... and each section of the article will be a row. The reason why I need the sections of the article to be rows is because the number of sections in each article will vary.
What is the best way to go about accomplishing this? or is there a better way of doing it? I cannot think of anything.
What files all go to the site? Somewhere I read that source code is not necessary to post to the site. I use VS 2010. I wonder what files go to the site and how to install website from localhost on the server?
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 want to create a dropdown of Vendors. I have a Vendors table in my DB, containing a VendorID and a CompanyID. The Company table contains a CompanyID and a Name.
I would like to have a dropdown with items that have the VendorID as the value and the Company Name as the text. But I don't know how to get the Name field from the related table to put in the dropdown, so I have the VendorID as the value and text. Here's what I have right now.
I'm passing in a model that contains this:
public IEnumerable<Vendor> Vendors { get; set; }
In my controller, I'm setting the value of Vendors like this:
MyDBEntities _entities = new MyDBEntities(); Vendors = _entities.Vendors;
Here is my dropdown list on the page:
<%= Html.DropDownListFor(m => m.VendorId, new SelectList(Model.Vendors, "VendorID", "VendorID"), "- Select a Vendor -")%>
I thought I could create a custom function - GetVendorsForDropdown - that would return only the data I needed, and changing my model to contain IEnumerable<Something>. But I don't know what the return type should be.
I've created a Web application (VS2008) that contains a single Generic Handler (handlername.ashx) and a web.config. I've also added a Web Setup project to use for deployment that uses the primary output from the Handler project. Install works without any errors and all the referenced DLLs are installed in the target location, with one issue. It doesn't install the ASHX file or the web.config.
Publishing the web app to the target location works as expected (includes both DLLs and the ASHX/Config files).
Is there something specific I need to do for the Web setup to include the ASHX/Config files?
I'm creating an AppHarbor MVC3 application and want to use the standard membership provider support. The AppHarbor guys told me I needed to create script for the table structure that I can run on my AppHarbor database. I'm not really familiar with databases, however. How do I go about creating and executing a script for the default membership tables?
I have a dataset with 3 tables that are inner joined. Thsi dataset is connected to an object datasource which is connected to a gridview. So at runtime it displays data from the database. The problem is when I click on a save button to add information to the database it throughs me an error saying Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. But if i have two tables in my dataset it works 100%. But the problem i need that 3 tables in order to pull the required information. And if i populate the gridview using code to select the information from the database and insert information it also works 100%.
Excuse me this common error. I´ve found a lot of info in Google but I´ve not found my error. I´m trying to read some data from a custom section in web.config and I don´t know which is my error?
We are running asp.net website on windows server 2003 with framework 2.0 and asp.net ajax 1.0 extensions. now we planned to migrate websites to windows server 2008 r2. since my websites on framwork 2.0, I need to install same framework on windows server 2008 r2 but I didnt find 2.0 version for windows server 2008 r2. Is it possible to install 2.0 version on windows server 2008 r2 ??
Example: we have different articles in a database like cars, jewelery, boats. The data related to these articles is different in the tables. I have to show that data in a textboxes and let the user change those data and update. I can do the update and reading the data from database. But the problems is for each item the no.of columns and rows will differ.
My task is I need to get the data according to the use selection in the table with textboxes. I dont know which container (gridview, formview or etc) will suites for my requirement. send me any sample code or any tutorial related to this.
Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))
I tried to install VS 2008 on my different systems already having Framework 2 installed, it failed to install. I tried it may a times even on different systems. It runsbut after Serial No. and next i see error .net framework 3.5 installation failed and there down a list of all componetns it shown which have not been attempted. I am going to devlpe the software and without t i can;t do anything..