Showing posts with label problemi. Show all posts
Showing posts with label problemi. Show all posts

Sunday, March 11, 2012

.net version of crystal reports?

is there a .net version for crystal reports, if i do my reports in 8.5 and load them in a .net application. would it be a problem?
i would be happy if someone could clarify my confusion!
thanksYes there is a .Net version that is supplied with MS Visual Studio .Net. Your 8.5 reports will be fine under CR.Net, but if you create new reports under .Net, you will not be able to open them in 8.5|||who owns the .net version of the crystal reports, is it by microsoft corporation or seagate?|||Beats me :)

Thursday, March 8, 2012

.Net passing bad formatted value to stored procedure

Hi, that's the problem:

I have a GridView, bound to a SQLDataSource, with an stored procedure as a Select query. The Select Parameters are bound to controls in the web form, acting like some filter fields.

When I submit the page, everythings works fine, except when I try to set some value in the DateTime fields. .Net is enclosing the date with extra single quotes, as I could see in the Profiler:

exec sel_despesa_procura @.codigo=NULL,@.fornecedor=NULL,@.descricao=NULL,@.vencto_ini=''2005-10-10 00:00:00:000'',@.vencto_fim=''2005-10-20
00:00:00:000'',@.pagto_ini=NULL,@.pagto_fim=NULL,@.valor=NULL,@.valor_pago=NULL,
@.centro_custo=NULL,@.pago=N'0,1'

The fields are defined as follows:

<SelectParameters>
...
<asp:ControlParameterControlID="txtFiltroVencIni"Name="vencto_ini"PropertyName="Text"Type="DateTime"/>
<asp:ControlParameterControlID="txtFiltroVencFim"Name="vencto_fim"PropertyName="Text"Type="DateTime"/>
...
</SelectParameters>

The stored procedure doesn't even execute, due to the bad formatted arguments. It returns the error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '2005'.

I'm going to change the parameter type to varchar, as a workaround, but I'd like to solve this problem.

Thanks in advance,

Anderson

That is not it's normal behavior. Just for laughs, set the pages culture and uiculture to "en-US", and run the page again and see if the problem disappears. If it does, then it's a bug with your particular culture settings.

Thursday, February 16, 2012

*.SQL File - Seemingly Easy

The Set-Up:
Remote Shared SQL Server
Local Software - SQL Server Enterprise Manager
.SQL File
The Problem:
I am trying to set up a forum on my website which tells me to use the
supplied .SQL file to set up the tables. How do I go about doing that?
Thanks in advance for any feedback."Ryan" <Ryan@.discussions.microsoft.com> wrote in message
news:D3D230D4-6344-409A-9926-54BC64CBE973@.microsoft.com...
> The Set-Up:
> Remote Shared SQL Server
> Local Software - SQL Server Enterprise Manager
> .SQL File
> The Problem:
> I am trying to set up a forum on my website which tells me to use the
> supplied .SQL file to set up the tables. How do I go about doing that?
> Thanks in advance for any feedback.
Open up Query Analyzer (from EM you can highlight the correct database and
select Tools > Query Analyzer from the main menu). Then in QA, click File >
Open ... and load your .SQL file. Then select Query > Execute (or press
F5).|||Heck ya, thanks lots!