Database

Ashfield wrote:

Have a try, post your sql and then someone may help you

"Data Source=dbserver;Initial Catalog=mydb;Persist Security Info=True;User ID=user;Password=password;Connection Timeout=60;Packet Size=16384;Pooling=false"

1. EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;
2. Client client = Application.GetClient();
3. db.GetPartsByClientType(...)</entitiesdatacontext>

public static T Current {
			get {
				string key = typeof(T).FullName;
				T datacontext = (T)System.Web.HttpContext.Current.Items[key];
				if (datacontext == null)
					System.Web.HttpContext.Current.Items.Add(key, datacontext = new T());
				return datacontext;
			}
		}

EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;</entitiesdatacontext>

CREATE TABLE #T (ID INT IDENTITY(1,1), FirstName nvarchar(20))
INSERT INTO #T (FirstName) SELECT 'John'
INSERT INTO #T (FirstName) SELECT 'Kyle'
INSERT INTO #T (FirstName) SELECT 'Stacey'

INSERT INTO 
	OPENROWSET (
		  'Microsoft.Jet.OLEDB.4.0'
		, 'Excel 8.0;Database=c:\testXL.xls;HDR=YES;'
		, 'SELECT ID, FirstName FROM [Sheet1$]'
	)
SELECT 	ID, FirstName  
FROM #T

DROP TABLE #T

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

EXECUTE msdb.dbo.sysmail_configure_sp 'LoggingLevel' , '2';

sysmail_help_queue_sp @queue_type = 'Mail';