.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

setup creartion with database

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :.NET Framework
how to create a setup .exe with including database file (sql 2005)

View Complete Post

More Related Resource Links

Can this code be setup to run against the whole database instead of just 1 record at a time?


We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..

We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.


            strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"        
            'get the new transaction_id out for just inserted alarm   
            strSqual = "select max(transaction_id) as transaction_id from trans"  
            set rst = getStaticRecordSet(strSqual)

Data Deployment: Streamline Your Database Setup Process with a Custom Installer


Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.

Alek Davis

MSDN Magazine September 2004

how to attach sql database file to creating .exe setup in c#

I create a Setup file and put data folder, in data folder i put database file , but the problem is i have to mannualy attach database file in sql server 2005. I have to automatically attach database file when installing setup file.

problem in setup database membership

 Hello everyoneThe teeming seen on this video http://www.asp.net/general/videos/how-do-i-set-up-the-sql-membership-provider Which explains the addition of a database to the project AlympirchibBut as they applied to explain and I had a problem, he says, Stop the server failed to note that I have is the name of the device and the database and set the defaultNo one can tell me what is the solution or the requirements for the work thanks

Including an SQL Express Database File in a Setup Project

I'm building a win app using VS 2008 in C# using an SQL Express 2005 DB.  What is the best way to include a SQL DB in a setup project.  Does the SQL need to have a .dbo or .mdf extension?  I'm new to SQL Server Express.

Mobile Web Forms - Database setup



I recently downloaded the ASP .NET mobile web forms templates for VS2010. Where/how can I get the database scripts to set up a db for the default login example? I've set my connection string hoping it would automatically create the db for me on startup, but now I'm thinking it doesn't work that way.

Any ideas?

Thanks =]


Just code it.

Reg How to create a setup for windows application with integrated database (.mdf)


Hi All,

 How to generate the setup file for windows application (VS 2008) and how to install the SQL server (2005) at client system. Should i install complete SQL Server or anything else..? or Can i integrate the database file (.mdf) into setup file...   Before install these setup at client system, should i install .NET 3.5 framework..?

Please Help me....



Balaji Chandaka.

Script Database Mail Setup


I have an application that relies on Database Mail for sending out alerts and notifications.

I have it working wonderfully... as long as I manually set up Database Mail.

How can I provide a script to take care of the details of setting up Database Mail?

Most of SQL Server Management Studio has a "script" button which will accept input, then generate a script to take the actions requested.  This doesn't exist for the "Configure Database Mail" Wizard.

Any pointers?

I was able to find "Database Mail Simple Configuration Template" in the template explorer.  My main question is how to set one of the profiles as the default profile

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend