|
You can replace the value in the query. Note that you have to return the value as varchar, as a number can not be an empty string.
..., case SomeField when 0 then '' else cast(SomeField as varchar(50)) end, ...
---
single minded; short sighted; long gone;
|
|
|
|
|
No i dont want to modify in my stored procedure...,
Becoz it will affect all other datas too...,
I already used case condition with that only displaying the datas in my grid...,
Its possible to do any other action in back end codes?,
If its there plz tell me...,
Regards,
Magi
|
|
|
|
|
In the Select statement write case in the sql query
Select
(CASE WHEN data = 0 THEN '' ELSE data END) AS Data
FROM Table
.......
.......
and so on.
The datagrid will get empty string when you data is 0 otherwise it will show the actual data
|
|
|
|
|
No i dont want to modify in my stored procedure...,
Becoz it will affect all other datas too...,
I already used case condition with that only displaying the datas in my grid...,
Its possible to do any other action in back end codes?,
If its there plz tell me...,
Regards,
Magi
|
|
|
|
|
code in your datagrid's itemdatabound event
|
|
|
|
|
hi
you can change the value 0 the ""
In databind event of your control.
I thing it is the best option for you
|
|
|
|
|
Hi,
I'm working on a application that requires conversion of webpages to PDF. Can any one of you tell me... how to achieve this.
1 . IS there any class in .net that is related to webpages-to-PDF conversion.
2. Should we use any third party tools to achieve this.
3. When I googled about it I found http://www.colorpilot.com/pdfsample_aspnet.html
Please let me know your thoughts.
Regards,
dhulipudi
|
|
|
|
|
1 - no
2 - yes
3 - sounds good, try it
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thank U Christian Graus,
Can you suggest any third party tools for webpage to PDF conversion. Are there any Free tools for it.
Plz let me know.
Many Thanks!!
Dhulipudi
|
|
|
|
|
|
i am displaying time from 10:00 to 00.00 in a textbox. it's working fine .but the problem is when i click a button it is again starting from 10:00.How can i solve this problem
|
|
|
|
|
If you do a postback, your variable is reloaded. You can store the value in a hidden field and get it from there when the page reloads.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I have a crystal report with 5 columns in it.
The last column is getting cut into half along with the report title.
I am using Crystal Reports for VS2005.
|
|
|
|
|
Hi,
It could be because your paper size is too small for the column sizes. You can either make the box sizes smaller if they dont get cut off, or you can change the page settings by looking at:
1. Your margin settings, Right-click>Design>Page Settings
OR
2. Change your page to landscape rather than portrait, Right-click>Design>Printer Settings.
Hope this helps.
Regards,
Elizma
|
|
|
|
|
hai,
i am new to .net,i created one template coloumn in grid view i placed a dopdownlist in that i set allow pageing is true .
the problem is when i select any value in dropdown list and go to the nextpage index and back ro the orginalpage the value which i selected is disappearing ,please help me
|
|
|
|
|
|
Hi,
it seems to me as postback problem.
Are you binding grid in page_load event then use ispostback.
|
|
|
|
|
Hi Guys and Gals.
Me again. So, I finally got my report to work the way I want in ASP.NET 2005 C# on my development server. On the production server however it throws a configuration error where my Crystal Report Engine has been registered. On my production server only the Framework is installed and not Visual Studio.
Any Idea what could be the cause of this?
Regards,
Elizma
|
|
|
|
|
hey you again....
What is the error you are getting now?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Server Error in '/ReportTest' Application.
--------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 22: <compilation debug="false">
Line 23: <assemblies>
Line 24: <add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">
Line 25: <add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">
Line 26: <add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">
Source File: c:\inetpub\wwwroot\reporttest\web.config Line: 24
Assembly Load Trace: The following information can be helpful to determine why the assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
|
|
|
|
|
Have you added crystal report merge modules in your setup project?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
I am not making use of a setup project. I copy the folder across to the IIS of the development server, then I just re-configure the application in IIS. All the other projects works, only this one that make use of Crystal doesn't work.
Regards,
Elizma
|
|
|
|
|
You will not get the crystal report dlls with the framework. So you have to include the crystal report dlls from Visula studio.net. So you must go setup and deployment wizard and adding crystal reports merged modules.
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
In one of my project i also get the same error.
.net framework did not have support of crystalreport dlls.
So i use crystalreport msi setup in my visual studio setup file(you can have it where you install visual studio in you computer).
And then i use that msi setup and install in my server. it's works.
So i thing same problem you may have.
|
|
|
|
|
i am doing an application in which i want to clear all textboxes in the page
anyone please help me...
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)