|
Oh, well that's rather disturbing. I really am getting to that age where I can't remember stuff anymore.
Regards,
Rob Philpott.
|
|
|
|
|
Yeah, I'm 40 and suff from CRS syndrome too.
|
|
|
|
|
I did change the port to 25 and still no luck. What else could be wrong?
|
|
|
|
|
hi all,
i have stored procedure it has some varchar(1) variable.
when i execute on sqlserver management studio as
EXEC exs_clearance @from ='20090316', @to ='20090316', @side = '', @symbolType = '', @symbol = '', @client = '', @account_auto_num = '', @csv = '1', @sp_instructions = '', @show_sp = '', @adp = 'ridge', @clrFirm = ''
than it gives some outputs.
but when i execute from winform through LINQ datacontext as
dataGridView1.DataSource = Context.exs_clearance("20090316", "20090316", "",'\0', "", "", "",'1','\0', '\0', "ridge", "").ToList();
than it returns zero row..........why?
how can i get data?
|
|
|
|
|
hello dear Mohit Here
Please Send me a some detail of this like if you want total fields
that are in exs_clearance then you just write
Context.exs_clearance().toList();
other wise get Id or any object so that you find record for particular
record. otherwise send me a detail i'l surely solve your problem..
regard:
Mohit Bhambral,
+91-9815645999
|
|
|
|
|
exs_clearance() has 8 arguments so Context.exs_clearance().toList(); is not possible.
my problem is that how do i pass the empty character which are varchar(1) variables to the exs_clearance storedprocedure
thanks
|
|
|
|
|
My guess is it is your use of null literal characters '\0'. LINQPad is a good tool that will help you debug, your LINQ problems. Another good tool(s) are the visualizers for LINQ and Lambda expressions. It will show you the outpus and inputs and how they are translated by the intermediate LINQ expression builder.
Try sending a null literal using the key word 'null'. Or try modifying your T-SQL to convert the '\0' into a SQL null or empty.
ScottGu's Blog on LINQ Visualizer:
LINQ Visualizer Blog[^]
Charlie Calvert's Expression Tree Visualizer Blog:
Expression Tree Visualizer[^]
LINQ Tools:
LINQ Tools (LINQPad)[^]
|
|
|
|
|
|
i enter query in LINQPad as
exs_clearance("20090316", "20090316", "","", "", "", "","1","", "", "ridge", "")
LINQPad show no error and execute but it still executing ..........i can't wait.
|
|
|
|
|
Sounds like you are running into a loop on the db. LINQPad should return the result in the same time it takes the C# to execute. Does your LINQ side query do any pre processing before handing off to the db for SQL processing? Or are you using the SProc wrapper built by the LINQ ORM mapper? The visualizers also allow you to directly enter inputs to the DataContext.
You might also try a simple query in LINQPad to verify that your DataContext is properly mapped. You must map the DataContext to your ORM. Additionally, you might need to make a refrence to the context in LINQPad so that it can find all the dependancys of your project. Ie. anything not included in the .NET Framework you are using, all of your 'Includes' spicific to your project. LINQPad is smart, but it will not tell you that an object refrence is not found in the expression builder.
Use the half split method of tracing down the problem.
modified on Wednesday, June 17, 2009 1:02 PM
|
|
|
|
|
Hi all,
How to set dynamic database connection to crystal report.
for eg all reports get connection from web.config file or from class file.
Now, we are creating connection for each report, and its given at design time.
is it possible to dynamically apply the connection string from config file to all the crystal reports.
Thank you in advance
Regards
Rema
|
|
|
|
|
|
in my computer science final project i have the submission topic
"About the project"
and
"Overview of the project"
pls explain the contents that must be included in these two
|
|
|
|
|
vinithakizhussery wrote: in my computer science final project i have the submission topic
"About the project"
and
"Overview of the project"
pls explain the contents that must be included in these two
I suggest that you discuss this with your tutor.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
We haven't seen any of these here for a while - it must be assgnment time again 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Coming up to - at least this one wasn't "urgnt plz rite 4 me"
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
If I'm not mistaken in the US they finished one semester a week or two ago and starting a new one now or next week or so.
So expect more of these to come.
|
|
|
|
|
Great - maybe it's time to hibernate 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Starts next week for me, have the week off 
|
|
|
|
|
|
You need to explain it over there what you have done indeed.
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
Give me 48 hours, to train my telepathic capabilities, and I´ll answer you.
|
|
|
|
|
And this is connected to C# how?
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Nagy Vilmos wrote: how
Computer Science has a shorthand form as CS.
C# has the file extension as .CS
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
Vas. [I can call you Vas can't I?] Don't encourage them. It's like shining a light at a moth.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
