My Programming Life

Do you ever want to execute slq statements at once. I mean SQL Script file. Normally we are using like following commands to Execute Single SQL statement. SqlCommand cmd = new SqlCommand(sSQL, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); but this way you can execute one command at a time. We cannot execute SQL script using above command. Normal SQL Script Like this. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GO CREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [city] [varchar] (20) COLL

How to connect PDA with SQL Server 2000 When we trying to connect PDA with SQL Server 2000 It generate SQL Exception every time. We searched every where to overcome this matter. Our target was connecting PDA to Server Computer via Wifi and does the transaction to SQL Server 2000. We designed program with MS Visual Studio 2005 and Deployed to PDA. We included the Connection String as following. "Data Source=ServerName;Initial Catalog=master;Integrated Security=true;User ID=sa" Server Computer should include following connectivity software. MS .NET Framework 2.0 MS SQL Server 2000 Service Pack 3 MS SQL Server 2005 Compact Edition [ENU] MS SQL Server 2005 Mobile Edition Device SDK MS SQL Server 2000 SP3a Replication Components MS SQL Server 2000 SP4 Replication Components You can download above from the Microsoft site. After you install above software and when you trying to connect PDA with Server maybe you will still get that SQL Exception Error. What you have to do is go to yo