.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

problem with decimal type

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

I can integrate data from sql server to mysql.
I have a problem with the attribute of type decimal.

I declared variables in SSIS.
for example:

ART_CODE string (type varchar in sql server DDB)

ART_NIMP boolean (type bit in sql server DDB)

and in Execute SQL Task:

ART_CODE string 10

ART_NIMP boolean -1



I want to know how to attribute

ART_P_VTEB decimal(20, 4) (attribut in sql DDB)

how I'm declaring the variable for ART_P_VTEB in SSIS??????????????

and how I'm declaring the varia

View Complete Post

More Related Resource Links

How can I solve this problem?::Compiler Error Message: CS0433: The type 'CrystalDecisions.Web.Cryst


I upgraded my web application from visual studio 2003 to 2008. When I want to create a report in visual studio 2008 and receiving this error at runtime. I am able to compile but when runnning thats when I am getting this error.

How can I solve this problem? please help.

Compilation Error

Server Error in '/IRPSDEV' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0433: The type 'CrystalDecisions.Web.CrystalReportViewer' exists in both 'c:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Web\10.5.3700.0__692fbea5521e1304\CrystalDecisions.Web.dll' and 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\irpsdev\9e97e0a9\94a2ecd\assembly\dl3\151eb571\00df56e1_6064c201\CrystalDecisions.Web.DLL'

Source Error:

Line 161:        
Line 162:        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
Line 163:        private global::CrystalDecisions.Web.CrystalR

sove this type of problem what to do?

Hi ... Crystal Report Issue plz help ... I have developed an asp.net application with crystal report using visual studio 2005 n built in crystal report version 10 on win xp machine x86. its working fine in my PC. But the production server is 64bit OS windows server 2008 n IIS 7. My application is working fine , but am getting error in all crystal report page. They have installed Crystal report X64 in their server. Due to version conflict the report page not working. But i tried in 64bit Win 7 OS with juz crystal report x86 installed. Its working fine. I tld this to my service provider, but they are not ready to install crystal report X86 due to shared hosting. Plz help me , wat step i must take in order to resolve this issue ....

Basic data type problem with database insert

Hi,I'm trying to write some values into a database, but I think there's an issue with the data types.  Here's what I've got: public static string Hello(string pageId, string inOut) { string itemId = ""; string period = ""; var cookie = HttpContext.Current.Request.Cookies["visitorGUID"].Value; SqlConnection conn; SqlCommand comm; conn = new SqlConnection(GlobalSettings.DbDSN); comm = new SqlCommand("INSERT INTO myTable (memberGUID) VALUES (@memberGUID);", conn); comm.Parameters.Add("@memberGUID", System.Data.SqlDbType.Text); comm.Parameters["@memberGUID"].Value = cookie; try { conn.Open(); comm.ExecuteNonQuery(); return "Item added: cookie = " + cookie + " / pageId = " + pageId + " / inOut = " + inOut + " / pageId = " + pageId + " / itemId = " + itemId + " period = " + period; } catch { return "Item caught: cookie = " + cookie + " / pageId = " + pageId + " / inOut = " + inOut + " / pageId = " + pageId + " / itemId = " + itemId + " period = " + period; } finally { conn.Close(); } } At the moment I'm just trying to insert the value of the cookie into the database as a test.  It works fine when I

Problem with Dimension of type Account

Hi, I have a simple fact table where I have a dimension time and a dimension of type acount. The fact table looks like this FinanceKey AccountKey ProfitCenterKey DateKey DateAlternateKey ScenarioKey Amount 1 11 5 7308 2010-01-01 1 131 2 11 3 7308 2010-01-01 1 62115 3 11 0 7308 2010-01-01 1 27626 4 11 6 7308 2010-01-01 1 12 5 11 2 7308 2010-01-01 1 74316 6 11 7 7308 2010-01-01 1 14 7 11 5 7339 2010-02-01 1 147 The account dimension looks like this AccountKey AccountAlternateKey ParentAccountKey AccountName_en AccountName_de AccountType Operator CustomMembers ValueType CustomMemberOptions 1 1 NULL Statistical Accounts Statistische Kennzahlen Statistical ~ NULL Units NULL 11 11 1 Customer Count Anz. Kunden Balances ~ NULL Units NULL If I browse my cube I get no data for the measure amount. When I remove hte parent Account "Statistical Accounts" and ste the parent of "Customer Count" to NULL I will get the correct Customer count. Any idea?

Problem with AJAX - " Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'Syst

Hi., I'm using Visual Studio 2008 and i downloaded the toolkit from Codeplex, I downloaded the zip file which i've marked red in the below link.. This is my code, <form id="form1" runat="server"> <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </asp:ToolkitScriptManager> <asp:Panel ID="Panel1" runat="server"> Hi Simbu AJAX Works Fine ! </asp:Panel> <asp:RoundedCornersExtender ID="RoundedCornersExtender1" runat="server" TargetControlID = "Panel1" Radius = "6" BorderColor = "#FBB117" Corners = "All" > </asp:RoundedCornersExtender> </form> & this is the error i get, " Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35' " I saw this post, http://forums.asp.net/p/1273185/3439540.aspx and i changed my TOOLSCRIPTMANAGER into SCRIPTMANAGER & now i get this error ! and now c what this post says... http://forums.asp.net/t/1529516.aspx NOW WOT AM I SUPPOSE TO DO ??? PLZ GUIDE ME ! I'm struck up with this since 2 days....

Sql Order by not working with decimal/money type columns

Error Message:- Cannot convert a char value to money. The char value has incorrect syntax. DECLARE @Order NVARCHAR(50) = 'asc', @OrderBy NVARCHAR(50) = 'Shape'SELECTtop 1 Row_Number() OVER(ORDER BY  CASE WHEN @Order IS NULL OR @Order = 'asc' THEN    CASE WHEN @OrderBy IS null THEN Shape    WHEN @OrderBy = 'Shape' THEN Shape    WHEN @OrderBy = 'Cut' THEN Cut    WHEN @OrderBy = 'Color' THEN Color    WHEN @OrderBy = 'Clarity' THEN Clarity    WHEN @OrderBy = 'Price' THEN FinalPrice    --MONEY    WHEN @OrderBy = 'Carat' THEN [Weight]   --DECIMAL   END  END ASC,  CASE WHEN @Order = 'desc' THEN    CASE WHEN @OrderBy IS null THEN Shape    WHEN @OrderBy = 'Shape' THEN Shape    WHEN @OrderBy = 'Cut' THEN Cut    WHEN @OrderBy = 'Color' THEN Color    WHEN @OrderBy = 'Clarity' THEN Clarity    WHEN @OrderBy = 'Price' THEN FinalPrice  --MONEY   WHEN @OrderBy = 'Carat' THEN [Weight]  --DECIMAL   END  

Data Type Convert problem?

1/2 is inputed by user, I hope to get the result 0.5, but both Method1 and Method2 get the result 0 How can I do? Thanks! BTW, I can't require user to input 1.0/2.0      Method1:     double my = 1/2;Method2:     double my = Convert.ToDouble(1/2);  

Unable to cast object of type problem

hi I'm having a problem in this code: Public Function GetChannelList() As List(Of channel) Implements IChannelService.GetChannelList         Dim db As ChannelDataContext = New ChannelDataContext         Dim channelMatch = From channelRow In db.channels _                           Join parentChild In db.ChannelParentChildListings _                           On channelRow.channel_id Equals parentChild.parent_id _                           Order By channelRow.title Ascending _                           Select channelRow.channel_id, channelRow.title, parentChild.child,   parentChild.child_id           Return channelMatch    <-------- Error throw Unable to cast object of type 'System.Data.Linq.DataQuery`1[VB$AnonymousType_1`4[S

Problem with date type

hi i receive this date: `9/20/2010 3:32:32 PM` i need to convert to datetime. i try:     DateTime DateFrom = DateTime.ParseExact("9/20/2010 3:32:32 PM", "dd/M/yyyy", CultureInfo.InvariantCulture);                     but i get error: `String was not recognized as a valid DateTime.` in my computer the region is: `Hebrew (Israel)  dd/MM/yyyy for short date and hh:mm for short time` how to fix it ? thank's in advance

google map custom field type Rendering problem


Hi all,

I have rebuild the codeplex project of googlemapfield in visual studeio 2010 for sharepoint foundation 2010.It is able to show custom field when adding new column. I am unalbe to get  google map in display form.. I don't know where it went wrong. I am able to load a text pargaraph from control template file which is delcared in <div> as <p><cite>The Complete Manual of Typography</cite>, James Felici</p>. But not google map.

I have added safe control in web.config file and also enabled activex control scriptings in IE.

Here is my .ascx file code

<%@ Assembly Name="GoogleMapField64,Version=, Culture=neutral, PublicKeyToken=268a24657b14d504" %>
<%@ Assembly Name="Microsoft.Web.CommandUI, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" 

data type problem in import data from excel file


Dear All,

I am importing the data from excel file using following code.

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(strFolderFileName) & ";Extended Properties=HTML Import;"
                conn = New OleDbConnection(connstr)
                Dim strSQL As String = "SELECT * FROM [" & strWorkSheetName & "]"

                Dim cmd As New OleDbCommand(strSQL, conn)

                Dim da As New OleDbDataAdapter(cmd)

Now the problem is if a coulmn vlaue start with a number value like "15" then the other string value like "W15" in that column is ignored in the datatable.

eg. The excel column value     Column1


spmetal generated class and content type (for page layout) retrieve problem


I'm working with a console application to generate my sites and subsites (hierarchy). And i've got a problem with a generated spmetal class.


this doesn't work:


static void Main(string[] args)


            string SITE = string.Concat("http://"Environment.MachineName);         



Problem while creating task with custom content type in sharepoint workflow


Hi all,

I am trying to create task with custom content type in sharepoint statemachine workflow. But it is showing "Error Occured" after task creation code is excecuted. can anyone tell me what is the problem.

Task Content type


  <ContentType  ID="0x01080100A707C0079E8547c0A87515457DB90629"
      Description="Workflow Task"
      <FieldRef ID="{9da97a8a-1da5-4a77-98d3-4bc10456e700}" Name="MyComments" DisplayName="MyComments"  />
      <XmlDocument NamespaceURI="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
        <FormUrls xmlns="

Problem with an XML type column in this SQL Statement


If I use an XML type variable (@xml) everything is fine with the following SQL:

SELECT p.number as Position,
  x.value('(../name)[1]','VARCHAR(200)') AS SectionName,
  x.value('(./label)[1]','VARCHAR(200)') AS Name
FROM master..spt_values p
CROSS APPLY @xml.nodes('/xxxx_settings/section/setting[position()=sql:column("number")]') n(x) where p.type = 'p'

However, when I try to store my XML data in a table that has an XML column the following query doesn't work:

SELECT p.number as Position,
  x.value('(../name)[1]','VARCHAR(200)') AS SectionName,
  x.value('(./label)[1]','VARCHAR(200)') AS Name
FROM master..spt_values p,
  dbo.XmlDataHolder a
CROSS APPLY a.XmlData.nodes('/xxxx_settings/section/setting[position()=sql:column("p.number")]') n(x) where p.type = 'p'

The error is "The column prefix 'p' does not match with a table name or alias name used in the query."

What am I missing here?

find amounts with more than 2 decimal places in a float type column

I was trying to use charindex but that didnt work.  Also what happens if i change the column to money data type? does it round or truncate?

Content Type and Word properties problem



I defined a Site collection content type that have some required properties  and added it to a document library .

When we create a word document and then we try to save it in that document library , we have this message saying that some properties values are missing if we don't fill the mandatory ones

by pressing the button "Go to Document Information Panel"  the  “Retry  save” 

Problem with Execute SQL Task for XML type of Result Set


Hi All

I am calling SQL Query through Execute SQL Task

SELECT EmployeeID,NationalIDNumber,ContactID

FROM HumanResources.Employee

FOR XML RAW('Facility'),Root('Extract'),Elements 

and assigning the result set (XML) to a variable(Data) of String Datatype. After SQL Task I am using Script Task and  reading variable (Data) and has some C# in it.

StreamWriter outfile = new StreamWriter(@"C:\Output.xml");


when I execute the package, XML file is created but when i open the file, XML is not formed correctly and I am getting error 

" End element was missing the character '>'. Error processing resource 'file "

But the same query was successful when i run in SSMS


Please help me.

Thanks in Advance

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend