Crystal Report - C# Discussion Boards

pass '' char to storedprocedure !!!!!!!!!

zeeShan anSari17-Jun-09 2:20

17-Jun-09 2:20

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?

Re: pass '' char to storedprocedure !!!!!!!!!

MohitBhambral17-Jun-09 2:32

MohitBhambral

17-Jun-09 2:32

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

Re: pass '' char to storedprocedure !!!!!!!!!

zeeShan anSari17-Jun-09 2:47

zeeShan anSari

17-Jun-09 2:47

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

Pass null to stored T-SQL Proc via LINQ

ProtoBytes17-Jun-09 2:56

ProtoBytes

17-Jun-09 2:56

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)[^]

Re: Pass null to stored T-SQL Proc via LINQ

zeeShan anSari17-Jun-09 3:07

zeeShan anSari

17-Jun-09 3:07

hmmm.......thanks

Re: Pass null to stored T-SQL Proc via LINQ

zeeShan anSari17-Jun-09 3:38

zeeShan anSari

17-Jun-09 3:38

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.

Re: Pass null to stored T-SQL Proc via LINQ [modified]

ProtoBytes17-Jun-09 4:20

ProtoBytes

17-Jun-09 4:20

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

Crystal Report

rema r17-Jun-09 1:38

rema r

17-Jun-09 1:38

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

Re: Crystal Report

K030617-Jun-09 2:54

K0306

17-Jun-09 2:54

try this it may be useful
http://billchamp.blogspot.com/2007/08/howto-read-crystalreportviewer-report.html[^]

project doubt

vinithakizhussery17-Jun-09 0:28

vinithakizhussery

17-Jun-09 0:28

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