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
View 2 Replies
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...
View 4 RepliesI 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
config.AppSettings.Settings["Param1"].Value = param1;
How to do it for applicationSettings?
I have developed an Asp.Net application with backend sqlserver 2008 database. Now i want to install the MSI file in client system along with database file. In client system i want to install the sqlserver with out any sql editor. i.e The sqlserver shouldn't use for development purpose. The sqlserver must acts just like engine between application and database file. In sqlserver which edition i have to install in client system to do the above things ?
View 2 RepliesI created two stored procedures in SQL Server Management Studio.
First procedure add field in ProjcetsToUsers table (for many-to-many associations)
[code]....
I can delete the user from the project and then add another, and the new one is added but removed the remains.
As for data base both this function work correctly.
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?
View 2 RepliesDetailed Error Information
Module
IIS Web Core
Notification
Unknown
Handler
Not yet determined
Error Code
0x80070032
Config Error
The configuration section 'connectionStrings' cannot be read because it is missing a section declaration
Config File
\?C:inetpubvhostscno-o.comhttpdocsweb.config
I m using VS 2010. I wan to create setup for that so what r the step to create and how can i insatll it in VS 2008.
View 4 RepliesWhat 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?
View 3 Repliesnext 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 have developed a web service. I have deployed it on Windows server 2003 with SSL (by selecting require SLL option) .
I want to ask that how can i install and configure a certificate identified by verify?
I used variety of fonts in my web project. is it needs to installing or copying that fonts to the server. If yes , how can i do that?
View 1 RepliesIs there a way to configure a web deployment project to install to create and install to a specific directory
View 1 RepliesWhat are the minmum configuration to install the visual Studio 2010 with .Net Framewark 4.0.
View 1 RepliesI'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?
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 ??
View 1 RepliesI am trying to update NuGet Package Manager from ver.1.0.11220.104 to version 1.1.229.160 using the VS extension manager, but the install fails on VS2010 Ultimate Version 10.0.31118.1 SP1Rel because of a signiture mismatch; see error below.
[Code]....
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..
View 2 RepliesI have created create.aspx view page from Terminology controller create Method .Once terminolgy create operation is suceeded it has to update other table appterminolgy,by taking that termid ,appid is available.
View 4 RepliesI have 10 tables in MSSQL I want to select some info from this tables and show on a webpage (formview maybe(based on user selection)). Also, Id like user to be able to EDIT this info, and it should go back to database.
The problem is that: the realtionships are pretty comprehensive. In sql management studio I saw awesome view creation, where u can drag and drop tables and select just the field u need, and it automatically do all joins for you.
View would work perfect for me, but i need to update database back. Maybe I can use linq classes?
I mean, its easy, but it takes a lot of time to do it by hand programatically. Is there some dragandgrop-like feature in visual studio?
what is the easiest way to bind multiple tables in one place with crud operations available?
sql datasource supports only 1 table at a time.
I Found on the web that we can use stored procedure? Do I need two stored procedures? for select and update? how we are going to bind update procedure with textobxes where user is going to edit info? Do you have some samples?
I have two tables, Customer and CustomerPhone.
Single record in Customer can have multiple CustomerPhone records. As you see in the image below, Phone and Fax resides in CustomerPhone table whereas the rest of the fields resides in Customer table. If user want to edits a customer record, obviously i will have to update the record in Customer table and at least two records from CustomerPhone (Phone and Fax).
I could write two update statements, one Update customerPhone and the second update Customer table. Is there a better solution?
Ever since I installed VS10, when I go to Project|ASP.Net configuration and security, and try to create aspnet_db, I get error that it can not connect to database. I have SQL Express 2008 installed and Machine.config is valid.
View 5 RepliesI want to update two tables using stored procedures but my data not updating to data base
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace INV_DN
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter da1;
SqlCommand cmd;
// SqlCommandBuilder cb;
DataSet ds;
public Form1()
[Code].....
I would like to update new records that get inserted in DataSet to Sql Server Database. Below is a working example of how to do this if you use "DataAdapter.Fill(ds)".
But i don't want to fill data, becouse i don't need data, i only need shema (I will use this dataset to insert new data to Sql), so i would like to use "DataAdapter.FillSchema(ds)"
[Code]....
I'm about to roll out my web site soon, and was just wondering if there's a way to roll out the db I'm working with on my dev computer, or if I have to recreate everything on the production server. If I can roll out my dev db, will the uids be the same?
View 1 Replies
