Click here to Skip to main content
15,922,894 members
Home / Discussions / Database
   

Database

 
QuestionAn error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl17-Jul-08 21:55
dasha_pl17-Jul-08 21:55 
AnswerRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius18-Jul-08 5:29
mentorWendelius18-Jul-08 5:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 6:54
dasha_pl21-Jul-08 6:54 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius21-Jul-08 8:29
mentorWendelius21-Jul-08 8:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 20:27
dasha_pl21-Jul-08 20:27 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 1:52
dasha_pl22-Jul-08 1:52 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius22-Jul-08 5:33
mentorWendelius22-Jul-08 5:33 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 21:44
dasha_pl22-Jul-08 21:44 
My connection string:
"Data Source=dbserver;Initial Catalog=mydb;Persist Security Info=True;User ID=user;Password=password;Connection Timeout=60;Packet Size=16384;Pooling=false"

I could not pass all programming code, it's very huge, I'll describe common steps,so, I click some button then:

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


Here is this property for my class httpDataContext<t> for step 1:
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;
			}
		}


For step 2 . In function GetClient I'm using the same
EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;</entitiesdatacontext>
to get db context.

And then on step 3 my query executing several time in cycle "for".
I hope this information will help Smile | :)
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius23-Jul-08 5:48
mentorWendelius23-Jul-08 5:48 
QuestionExcel Query [modified] Pin
Sunil Wise17-Jul-08 21:01
professionalSunil Wise17-Jul-08 21:01 
AnswerRe: Excel Query [modified] Pin
Sunil Wise17-Jul-08 21:32
professionalSunil Wise17-Jul-08 21:32 
QuestionHow to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8717-Jul-08 4:22
guriqbal8717-Jul-08 4:22 
AnswerRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
leoinfo17-Jul-08 5:17
leoinfo17-Jul-08 5:17 
GeneralRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8720-Jul-08 20:50
guriqbal8720-Jul-08 20:50 
AnswerCross Post Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionSending Email Pin
jonhbt17-Jul-08 3:38
jonhbt17-Jul-08 3:38 
AnswerRe: Sending Email Pin
Wendelius17-Jul-08 8:06
mentorWendelius17-Jul-08 8:06 
QuestionNested Cursor loop problem Pin
Member 387988117-Jul-08 3:25
Member 387988117-Jul-08 3:25 
AnswerRe: Nested Cursor loop problem Pin
Mark J. Miller17-Jul-08 9:27
Mark J. Miller17-Jul-08 9:27 
GeneralRe: Nested Cursor loop problem [modified] Pin
Member 387988117-Jul-08 19:59
Member 387988117-Jul-08 19:59 
GeneralRe: Nested Cursor loop problem Pin
Mark J. Miller18-Jul-08 5:20
Mark J. Miller18-Jul-08 5:20 
QuestionCompact database not working Pin
krishnan.s17-Jul-08 2:41
krishnan.s17-Jul-08 2:41 
AnswerRe: Compact database not working Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionNot In operation? Pin
Member 387988117-Jul-08 1:03
Member 387988117-Jul-08 1:03 
AnswerRe: Not In operation? Pin
TheFM23417-Jul-08 3:00
TheFM23417-Jul-08 3:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.