Data truncation??

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Compact
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - datetime column problem Hi all, I am trying to insert a date into the datetime column of a SQL CE database and it behaves in a very strange way. Whenever I try to insert the date such as "4/3/1975", the date that gets entered in the column looks like the following when view using the query analyser: 2004-03-04 00:00:00 Here are is code that I am using: ... cmd.Parameters["@cDOB"].Value = Convert.ToDateTime(cDOB_tb.Text).ToShortDateString(); ... where cDOB_tb.Text is 4/3/1975 Any ideas? SSP Tag: Data truncation?? Tag: 19955
  - 2
    - Prevent auto-deletion of cab file Is it possible to prevent a cab file from being auto-deleted after it is clicked and installed? If so, how? The MS FAQ states that making it read-only should prevent this but I have done that and it still is removed after it is run. Thanks. Tag: Data truncation?? Tag: 19953
  - 3
    - Control Array Hello All Is it possible to create a control array (i.e. button control array) in vb.net 2003 targeting compact framework.net Studio: VS 2003.ne Platform ce.net Language VB.ne I will appreciate any response Thanks Tag: Data truncation?? Tag: 19949
  - 4
    - XML XPath Query compact framework Hello all, Probably a really simple question, but I'm trying to write some code in VB.net using the compact framework, that will load in SQL statements from an XML file before passing them to a query processor. What are the best ways to do this? I've attached the xml file to give some context. I need a way of xpathing the relevant sql element out of the XML and returning it as a string. How are XPath node selections done in the CF? Is it supported in the xmlreader or xmldocument classes? Help! Also, if anyone knows a way in which I could use some xsl to transform the parameter values into the SQL I'd really appreciate hearing it! Thanks in advance! begin 666 SecurityAgent.xml M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@B(#\^#0H\<75E M<FEE<SX-"@D\<75E<GD@;F%M93TB=&5S=&QO9VEN(CX-"@D)/'!A<F%M971E M<G,^#0H)"0D\<&%R86T@:60](C$B(&YA;64](G5S97)N86UE(CX\+W!A<F%M M/@T*"0D)/'!A<F%M(&ED/2(R(B!N86UE/2)P87-S=V]R9"(^/"]P87)A;3X- M"@D)/"]P87)A;65T97)S/@T*"0D\<W%L/@T*"0D\+W-Q;#X-"@D\+W%U97)Y M/@T*"3QQ=65R>2!N86UE/2)S971P87-S=V]R9"(^#0H)"3QP87)A;65T97)S M/@T*"0D)/'!A<F%M(&ED/2(Q(B!N86UE/2)U<V5R;F%M92(^/"]P87)A;3X- M"@D)"3QP87)A;2!I9#TB,B(@;F%M93TB<&%S<W=O<F0B/CPO<&%R86T^#0H) M"3PO<&%R86UE=&5R<SX-"@D)/'-Q;#X-"@D)/"]S<6P^#0H)/"]Q=65R>3X- +"CPO<75E<FEE<SX` ` end Tag: Data truncation?? Tag: 19943
  - 5
    - How can I send email with VB.NET from Windows Mobile 2003 Hello, I have make prozedur to send emails from VB.NET 2003 - winforms-application. I works well. But how can I do the same for an project for mobile devices ? The reference for the system.web.dll could not be set in a project for mobile device. How can I send email with VB.NET from Windows Mobile 2003 ? Thank you for response regards Wolfgang Schwarz 34582 Borken/Germany Tag: Data truncation?? Tag: 19942
  - 6
    - SQL Server 2000 Connection I couldn't manage to connect to Sql Server 2000 within a compact framework application. i want directly connect to server, not using Sql Server CE. Do you have such sample code? Thanks Tag: Data truncation?? Tag: 19941
  - 7
    - CallerID Using C# and CF Hi, I wanted to know how can i get the CallerID of the incoming call using C# and .net cf? Is there a way? or is there a special notification when there's a missed call? Thanks Mustafa Tag: Data truncation?? Tag: 19936
  - 8
    - Query String Arguments to a client application when opening app from Pocket IE I'd be grateful for a little help on this! I'm invoking an application on the PPC from Pocket IE using <a href="file:///Program Files\App1\App1.exe?name=bob" >Activate App...</a> I want to the application to be able to pick up the url arguments, but am having a little difficulty! I've tried the usual approach to command line arguments - no success. I thought I'd found the answer with an article by Chris Sells which included: AppDomain domain = AppDomain.getCurrentDomain; object obj = domain.GetData("APP_LAUNCH_URL"); string name=(obj != null ? obj.ToString() :""); Sadly, this isn't supported in the Compact Framework. Can anyone point me in the right direction? Thanks, Ben Tag: Data truncation?? Tag: 19935
  - 9
    - Query String arguments to .NET CF app... I'd be grateful for a little help on this! I'm invoking an application on the PPC from the browser using <a href="file:///Program Files\App1\App1.exe?name=bob" >Activate App...</a> I want to the application to be able to pick up the url arguments, but am having a little difficulty! I've tried the usual approach to command line arguments - no success. I thought I'd found the answer with an article by Chris Sells which included: AppDomain domain = AppDomain.getCurrentDomain; object obj = domain.GetData("APP_LAUNCH_URL"); string name=(obj != null ? obj.ToString() :""); Sadly, this isn't supported in the Compact Framework. Can anyone point me in the right direction? Thanks, Bob Tag: Data truncation?? Tag: 19934
  - 10
    - Agressive disposing Hi, As Pocket PC's are (supposed to be) resource-restricted devices, I thought it would be wise to implement an agressive disposing strategy, i.e. add IDisposable to every class, and call Dispose() on everything. But I don't know exactly HOW agressive I need to be ;-) I.e.: - If I derive from Panel or Form, and a child controls (Me.Controls.Add...), do I need to remove and dispose those as well, or do Panels and Forms somehow dispose of their children themselves? - If I add objects to a Collection, do I need to enumerate over the collection and call Dispose() on every object, or should a Collection.Clear() accomplish the same thing? - If I add a handler (AddHandler obj.event, delegate), do I need to remove the handler myself when I want to dispose of the object? I assumed that all the above would be taken care of automatically by the garbage collector, but some of my objects start threads, and these threads are stopped in their Dispose() method (via a simple stopThreadRequested boolean flag). Yet if I quit my application, these threads appear to still be running, so it looks as if my Dispose() methods aren't called automatically... Regards, Elisa Tag: Data truncation?? Tag: 19931
  - 11
    - Deploy content to specific folder Hi, In Visual Studio .NET 2003, my Solutions Explorer window, I have the following tree: MyProject |->img | |->MyImage1.bmp | |->MyImage2.bmp |->MyClass.vb However, if I deploy, everything is dumped in the same folder (MyProject). How do I tell VS to deploy the files with the folder structure intact? Regards, Elisa Tag: Data truncation?? Tag: 19930
  - 12
    - .NET CF extremely buggy! cmd.Parameters.Add(new SqlCeParameter("@cDateReg", DbType.Date)); cmd.Parameters.Add(new SqlCeParameter("@cDate", DbType.Date)) cmd.Parameters["@cDateReg"].Value = Convert.ToDateTime(cDateReg_tb.Text).ToShortDateString(); cmd.Parameters["@cDate"].Value = Convert.ToDateTime(cDate_tb.Text).ToShortDateString(); Error Code: 80020005 Message: Data conversion failed. [OLE DB status value,,,,,,] This is typical of the crap I am going through at the moment! If it works in one instance why won't it work in another?? SSP Tag: Data truncation?? Tag: 19928
  - 13
    - PPC Power On Screen Hi all, I implemented code to try to turn on the screen in my app, since sometimes devices do not completely wake up when having an app run at a certain time. I did this with some code similar to what Peter provided on OpenNetCF site, attached below. This has worked great on my Ipaq2215, however, I had a user that upgraded PPC2002 to PPC2003 on an Ipaq3900. Apparently this doesn't work, as the app doesn't wake up when launched. I realize that this type of command is not universally supported, but I'd be surprised it didn't work on an Ipaq3900, so was thinking my implementation was wrong. Any feedback on anyone else with similar issues? Thanks, Brian using System; using System.Runtime.InteropServices; namespace OpenNETCF { /// <summary> /// Summary description for Video. /// </summary> public class Video { // GDI Escapes for ExtEscape() private const uint QUERYESCSUPPORT = 8; // The following are unique to CE private const uint GETVFRAMEPHYSICAL = 6144; private const uint GETVFRAMELEN = 6145; private const uint DBGDRIVERSTAT = 6146; private const uint SETPOWERMANAGEMENT = 6147; private const uint GETPOWERMANAGEMENT = 6148; public static void PowerOff() { IntPtr hdc = GetDC(IntPtr.Zero); uint func = SETPOWERMANAGEMENT; uint size = 12; byte[] vpm = new byte[size]; //structure size BitConverter.GetBytes(size).CopyTo(vpm, 0); //dpms version BitConverter.GetBytes(0x0001).CopyTo(vpm, 4); //power state BitConverter.GetBytes((uint)VideoPowerState.VideoPowerOff).CopyTo(vpm, 8); ExtEscapeSet(hdc, SETPOWERMANAGEMENT, size, vpm, 0, IntPtr.Zero); } public static void PowerOn() { IntPtr hdc = GetDC(IntPtr.Zero); uint size = 12; byte[] vpm = new byte[size]; //structure size BitConverter.GetBytes(size).CopyTo(vpm, 0); //dpms version BitConverter.GetBytes(0x0001).CopyTo(vpm, 4); //power state BitConverter.GetBytes((uint)VideoPowerState.VideoPowerOn).CopyTo(vpm, 8); ExtEscapeSet(hdc, SETPOWERMANAGEMENT, size, vpm, 0, IntPtr.Zero); } [DllImport("coredll", EntryPoint="ExtEscape")] private static extern int ExtEscapeSet( IntPtr hdc, uint nEscape, uint cbInput, byte[] lpszInData, int cbOutput, IntPtr lpszOutData ); [DllImport("coredll")] private static extern IntPtr GetDC(IntPtr hwnd); } public enum VideoPowerState : uint { VideoPowerOn = 1, VideoPowerStandBy, VideoPowerSuspend, VideoPowerOff } Tag: Data truncation?? Tag: 19923
  - 14
    - Reflection: does it work with CF? Hi wonder if the CF supports reflection. When I ask a simple Type.GetType("System.String").GetMethods I got uncomprensible errors. At runtime I get a NotSupportedException, on the debug window I get "Incorrect Parameter"... Also I cannot call Type.InvokeMember because it give the same errors. Some one experienced the same? Have I to renunce to Reflection? I'm testing it on the emulator 2002 and CF SP2. Thanks -- Math Parser : http://www.neodatatype.net Tag: Data truncation?? Tag: 19919
  - 15
    - TypeLoadException Hi, I have developed a chess application and I have received 2 complaints: after installing .NET CF SP2 on a PPC 2002 (one is ipaq 1910 the other one I don't know) when they launch the game, they get this error chess.exe TypeLoadException Application::Run+0xf MainForm::Main+0xa I've asked them to install other .NET CF applications and they get the same error, so it seems there is a problem with .NET CF. I've asked them to reinstall SP2, to soft reset the PPC ... nothing. The only solution I can think of is to ask them to do a hard reset, however I wish I could find a less radical solution. Do you have any suggestions? Thanks, Valentin Iliescu Tag: Data truncation?? Tag: 19915
  - 16
    - How to remove PerfCtr entries from Event Viewer? Had .NET development stuff installed but then uninstalled as part of tracking down other problems with system. Now, I get about 10 bitchy entries under Event Viewer>>Application related to CE.NET stuff being unable to find libraries, etc. Have tried a few of the things in the MSKB (running WMI dredger from cmd. line, renaming Library .DLL's) to get this stuff gone, to no avail. Really annoying. Any ideas? Tag: Data truncation?? Tag: 19914
  - 17
    - Problem distributing multi-project solution Hi, I've a VisualStudio solution with 2 project in it. These projects are not "linked" by a reference. When I do a compilation with distribution, only the main project is distribuited to the pocketpc. Is there a way to force the "total-distribution"? Thanks -- Math Parser : http://www.neodatatype.net Tag: Data truncation?? Tag: 19913
  - 18
    - Directory.GetCurrentDirectory Why this method cause a NotSupportedException? Thanks -- Math Parser : http://www.neodatatype.net Tag: Data truncation?? Tag: 19911
  - 19
    - Clear selection in ListView Hi, How do I clear the current selection in a ListView control? Regards, Elisa Tag: Data truncation?? Tag: 19905
  - 20
    - How do I serialize an object to a string? Hi, I need to serialize an object to a string. In my Desktop applications, I use thes function..... Imports System.Xml.Serialization Imports System.Xml Public Shared Function ObjXMLString(ByVal TheObject As Object) As String Dim serialise As XmlSerializer Dim ms As New IO.MemoryStream() Dim s As String serialise = New XmlSerializer(TheObject.GetType) serialise.Serialize(ms, TheObject) s = ByteArrayToString(ms.ToArray()) Return s End Function ... but the compact framework doesn't know the XmlSerializer. How can I serialize an object to a string in compact framework? Thanks!!! M O J O Tag: Data truncation?? Tag: 19902
  - 21
    - What happened to John Kennedy? (Not JFK - the other one) Hi, all If you've been around the world of Windows CE for any length of time, you've probably encountered John Kennedy. He wrote one of my favourite PPC programs, Pocket Universe, as well as one of my favourite PPC games, TankZone. He started working for Microsoft a couple (?) of years ago, and wrote several instalments of the MSDN 'Two for the Road' column. Now his web site (www.stellarmetrics.com) is dead, and he hasn't written an MSDN column for over 6 months. Anyone know what's become of him? Cheers - rick Tag: Data truncation?? Tag: 19896
  - 22
    - How can I update my Emulator for VS.NET 2003 to a recent version? The version of the emulator that installs with my 2003 setup is 4.1.0 and does not have support for storage cards (there is no option for it under the menu in the emulator). I have downloaded the Microsoft Pocket PC 2003 SDK which gave me the 2003 pocket pc images but it did not upgrade my version of the emulator. I need to be able to emulate a storage card for my VS 2003 Compact Framework development. How can I upgrade my version of the emulator to one that supports storage card emulation and can still be launched directly from within Visual Studio 2003? Thanks, - Chris D'Arrigo Tag: Data truncation?? Tag: 19893
  - 23
    - smart camera running cf.NET Hey, Anyone know of a camera that supports cf.NET? Also, can a desktop .NET client create (and use) a cf.NET remote server object? Lastly, can a cf.NET server object be accessed (is cliented a word?) simultaneously by a desktop .NET client and a local cf.NET client? Thanks, -Danny Tag: Data truncation?? Tag: 19892
  - 24
    - Query about Object and Resources This is a multi-part message in MIME format. ------=_NextPart_000_0126_01C3ED8A.C19B8350 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a custom Class "A", with a member that references custom Class = "B". I then instanciate Class "B" (objB), and then reference it from a = instance of Class "A" (objA). If I then do this: objA =3D Nothing, does this release the resources = consumed by objB? Thanks in advance, Joe ------=_NextPart_000_0126_01C3ED8A.C19B8350 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>I have a custom Class "A", with a member that = references=20 custom Class "B".</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I then instanciate Class "B" (objB), and then = reference it=20 from a instance of Class "A" (objA).</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>If I then do this:   objA =3D Nothing, = does this=20 release the resources consumed by objB?</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thanks in advance,</FONT></DIV> <DIV><FONT size=3D2>Joe</FONT></DIV></BODY></HTML> ------=_NextPart_000_0126_01C3ED8A.C19B8350-- Tag: Data truncation?? Tag: 19891
  - 25
    - Visual Basic .net 2003 Standard Ed. + Compact Framework Hi all, I have Visual Basic .net 2003 standard edition, and I'd like to develop an application for my ppc. Can I use vb.net 2003 St.ed. to do it? If yes, how? where I can find some documents decribing my problem's solution? Bye Alchol100 Tag: Data truncation?? Tag: 19886
- Next
  - 1
    - Does VS2003 .NET need to be updated for cf.NET sp1? If I download cf.net sp1 and install it on my devices do I need to update visual studio at all? Does it need any of the updates to build? Is there a way to update VS so that it deploys the cf.net sp1 when I deploy and debug a new app? Thanks, jim Tag: Data truncation?? Tag: 19870
  - 2
    - How do I use Debug.WriteLine? The documentation says that Debug.WriteLine and TraceListener.WriteLine are supported by the compact framework, but When I try calling these methods I get no output in my debug window? How do I print debug info to my debug window? jim Tag: Data truncation?? Tag: 19868
  - 3
    - Start program in background I'm using the coredll.dll function CreateProcess() to start a new process from my VB .NET app. This other app takes a few seconds to load, so I'd like to start it in the background when my program launches and then just bring it to the foreground when needed. Is there a way to start a process in the background? Or start the new process and then immediately bring my process to the foreground? Tag: Data truncation?? Tag: 19862
  - 4
    - Connecting to a named instance of SQL Server 2000 I've using Pocket PC 2002 and 2003 with SQL Server CE 2.0 installed I'm trying using Visual Studio .NET 2003 and C# to connect to SQL Server 2000 SP3 Using the following lines of code I can connection to a default instance of SQL Server using the emulator and the PDA System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection() conn.ConnectionString = @"User ID=sa;Initial Catalog=databasename;Data Source=servername" conn.Open() Using the following ConnectionString I can connection to a named instance of SQL Server using the emulator, but NOT using the PDA conn.ConnectionString = @"User ID=sa;Initial Catalog=databasename;Data Source=servername\instancename" I've tried a Pocket PC 2002 and 2003 and both get the following error "Specified SQL server not found". Any ideas or help? Tag: Data truncation?? Tag: 19850
  - 5
    - Development machine for CF w/kb and 640w screen I'm looking to buy a used handheld that will support WinCE 4.2 and the CF. I need a screen width of 640 and height of 240 or more. I need it for UI development since our target device is not yet available. It looks like Jornada's will not do the trick. Others? It appears the handheld market is going away with Windows Mobile 2003 being targeted at PocketPC form factor. Thanks, Mark Tag: Data truncation?? Tag: 19849
  - 6
    - About DataGrid and SUM Hi, I have this code to fill a DataGrid: Dim dt As New DataTable SQL = "SELECT f1, SUM(f2) AS ft FROM table GROUP BY f1" Dim adp As New System.Data.SqlServerCe.SqlCeDataAdapter(SQL, sqlConn) dt.Clear() adp.Fill(dt) Grid.Visible = False Grid.DataSource = dt Grid.Visible = True But this not display the "ft" field in my Grid. Wy?? Tx in advance. Tag: Data truncation?? Tag: 19845
  - 7
    - SMTP Server from PPC Hi I have an app using CF on PPC 2002. I am looking for way to provide support to my users for when they have problems. I am looking to have them push a button on their app and it will zip then email their SQL database to me. The problem is I need to install a default smtp server on their pda so they don't have to enter their own (which will probably be closed off so people can't spam off it). If you have other ideas I would be up for it. I though about FTP but I need to know who they are which email will allow for Thanks Aaron Tag: Data truncation?? Tag: 19843
  - 8
    - Conditional Running Hi, I have a class that must use some functions for Compact Framework, and other for DeskTop Pc: #IF (IS RUNNING ON PPC) Sub Insert() 'Insert in ppc End Sub Sub remove() 'Remove From PPc end Sub #ELSEIF (IS RUNNING ON DESKTOP) Sub Insert() 'Insert in DeskTop End Sub Sub remove() 'Remove From DeskTop end Sub #ENDIF There is a way to conditionally check for alternative functions if my DLL is runing on Desktop PC or in PPC? Thanks Tag: Data truncation?? Tag: 19842
  - 9
    - can you click for good cash Tag: Data truncation?? Tag: 19840
  - 10
    - Assembly.CreateInstance with arguments? Hi, I need to create an instance of a class in a non-referenced assembly, so I thinked to use the Assembly.CreateInstance(). The problem is that my class has a constructor with an argument. I cannot istantiate my class, since CreateInstance try to instantiate using the standard constructor that does not exists :( Is there a way to get an istance of my class? Thanks Tag: Data truncation?? Tag: 19838
  - 11
    - Flashing label Hi, Is it possilble to have a link label such as that one from OpenNETCF that is flashing all the time? Thanks Tag: Data truncation?? Tag: 19836
  - 12
    - Autoscroll webpage I built a web page with autoscroll text using Javascript but it didn't work. Is there any chance to have autoscroll web page in Pocket Internet Explorer Thanks Tag: Data truncation?? Tag: 19833
  - 13
    - TomTom navigator equiv for Windows CE.net ? Hi group, I'm looking for an equivalent to TomTom navigator on WindowsCE.net. TomTom is only available for PocketPC and it seems that they're not interested in a CE.net version. Does anyone know such a solution ? The best would be a software made for 1/2VGA size (640x240). Thanks for your advices ! Thomas. Tag: Data truncation?? Tag: 19829
  - 14
    - Baracoda Bluetooth barcode pencil Hi, Has anyone managed to use this barcode reader from VB.net or C#? Thanks, Alberto Silva Tag: Data truncation?? Tag: 19828
  - 15
    - SDAuthUtilDevice ?? I have a CE.NET device built with Platform Builder 4.2 it has CF and sdauthutildevice.exe embedded in the image. I have been able to succesfuly remotly debug a C# program before. I would start the sdauthutildevice app on the device then do the Tools->smart device authenication utility in VS type in the IP address of the device and it would connect and I could step and debug. Now all of a sudden I can't connect any more. I always get this error screen.. I can't figure out what happened. I am pretty sure I screwed up the PC side as I can connect and debug on another PC with its copy of VS. What is this strange file pubkey.blb ??? How can I repair??? Unknown error occurred while prepping deviceSystem.IO.FieldNotFoundException: Could not find file "C:\Documents and Settings\dave\Local Settings\Application Data\PubKey.blb". at System.IO__Error.WinIOError(Int32 errorCode, String str) at System.IO.FileInfo.get_Length() at Microsoft.SDAuthUtil.Form1.TCPFileToDevice(String localFileName) at Microsoft.SDAuthUtil.Form1.DoPrepDevice() Tag: Data truncation?? Tag: 19825
  - 16
    - Custom control - System.Resources.MissingManifestResourceException Thanks Michael... I succeed placing a custom picture button control on the toolbox. The example on the website http://www.codeppc.com/dotnet/createcontrol/createcontrol.htm is complete. The Imagebuttoncontrol has an icon property. Is use the control from within a Vb.net testform. When I d'ont set the icon property, the button is working. Even the click-event does work normal. When assigning an .ico file to the icon property, I get an error: An unhandled exception of type 'System.Resources.MissingManifestResourceException' occurred in mscorlib.dll Additional information: MissingManifestResourceException Any suggestions how to resolve this problem? Best regards, Mobile Boy "Michael" <anonymous@discussions.microsoft.com> wrote in message news:89DBA9E0-F23C-467E-BA60-5745115097E0@microsoft.com... > Thanks for your answers! I have found an article which describes how to create a control. > It's in french, but that doesn't matter > > http://www.codeppc.com/dotnet/createcontrol/createcontrol.htm Tag: Data truncation?? Tag: 19824
  - 17
    - Screen Saver Hi groups, Are there any ways to create a screen saver that loaded when CF .NET enabled device idle for a specified time? I tried to search this group using "screen saver" and "windows service" with no luck Thank you for your advic Abd Shomad Tag: Data truncation?? Tag: 19822
  - 18
    - Display SVG on Handheld Hi All, I am exploring an control on handheld to display Scalable Vector Graphics (SVG). I know there are some commercial viewer, but they are not programmeable. I would like to embed that into my own application to display graphics Regards, Alex Tag: Data truncation?? Tag: 19820
  - 19
    - DateTimePicker : request for CulturInfo Since there seems to be a general interest for non-US support for the DateTimePicker.cs/.vb I have created a site for this on http://www.mj10777.de/NETFramework/Compact/DateTimePicker/index.htm An Archive is offerd with the original Miscrosoft DateTimePicker.msi (03.10.2003) and the unpacked version with a changed version of DateTimePicker.cs where a bug was fixed. The Demp-Project will show bothe DateTimePickers. There is also an Internationlized version called mj10777.DateTimePicker.cs which also supports FirstDayof Week logic. The names for the Days and Months are retrieved according to the Language set on the Maschine. There is (as allways) an exception : "Today" must be hard coded for each language supported. The Method DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek does not allways return correct results (reported elseware). I would be interest in learning : - what is "Today" on non-english/German Mashines as shown in the PC-Version of DateTimePicker. - what is the First Day of the Week as shown in the PC-Version of DateTimePicker. UK : on Compact (Pocket PC 2002) DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek returns Monday. - as far as I know this should be Sunday : is this assumtion correct? See : http://www.mj10777.de/NETFramework/Compact/DateTimePicker/Doku_DateTimePicker.htm for the present results, which I will update after building in the results to the source code. I would welcome the results as an E-Mail to mj10777@mj10777.de (Subject : DateTimePicker : LanguageX) Language : SomethingInEnglish Today : "xxxx" FirstDayOfWeek : Day in English and if possible 2 gif files from the original PC-Version of DateTimePicker as shown in Doku_DateTimePicker.htm Visual Basic support : See http://www.mj10777.de/NETFramework/Compact/DateTimePicker/VB_DateTimePicker.htm Thank you. Mark Johnson, Berlin Germany mj10777@mj10777.de PS: using "Subject : DateTimePicker : LanguageX" will avoid getting lost in the Junk Box with the (allways promised, but never held) "Last critical Update" and other unpleasent things. mj10777 Tag: Data truncation?? Tag: 19813
  - 20
    - Emulator, Active Sync and Network Connection In my computer using the EMUASCFG utility I managed to setup PPC to connect to the active sync by configuring Virtual Swicth etc. But as soon as I pull the plug off my network cable it won't work any longer. The EMUASCFG starts the emulator but saying "Configuring..." and simply hangs there. I have even tried putting a MS Loop back adapter but still no luck. This problem happens on a WIN2K as well as on a WINXP computer. Anyideas on how to get this working without the network connection? Tag: Data truncation?? Tag: 19812
  - 21
    - DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek - Problems Up to now I have assumed that DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek on Compact allways returns Sunday. The reason for this was because when I changed the Original DateTimePicker.cs to support Monday as first day of week for German this function allways returned Sunday. Today I made some corrections due to problems found when running on English-Canada. During testing for US/UK/Canada-English and German I saw that on a UK-Culture returned : Monday. As far as I know this should be Sunday for the UK (as in US and Canada). After calling FirstDayOfWeek I set the Value to Monday for German and it now it looks as if I must set the Value to Sunday for UK. It looks as something has gotten mixed up. View results at : http://www.mj10777.de/NETFramework/Compact/DateTimePicker/Doku_DateTimePicker.htm Code for Demo project : http://www.mj10777.de/NETFramework/Compact/DateTimePicker/index.htm Mark Johnson, Berlin Germany mj10777@mj10777.de Tag: Data truncation?? Tag: 19811
  - 22
    - Please Help: Add items to listview from XML File I have difficulties in retreiving the data from XMl file that i have created. By using the coding as below, i m able to retrieve only 2 fields and display it in the listview Below are my coding and XML file that i have created CODING Private Sub RegisterListView( Dim item As ListViewIte lvwDisplay.Items.Clear( For Each row As DataRow In TransTable.Row item = New ListViewItem(row("Category").ToString() If Not (row("Type") Is Nothing) The item.SubItems.Add(String.Format("{0:F2}", row("Type").ToString()) End I lvwDisplay.Items.Add(item Next ro End Su XML Fil -<Table1><Desc>566</Desc><Category>ttgg</Category><Type>Deposit</Type><Amount>667</Amount></Table1 - <Table1><Desc>tt6t</Desc><Category>rrt</Category><Type>Decrease</Type><Amount>566</Amount></Table1> Tag: Data truncation?? Tag: 19799
  - 23
    - Please Help: Add items to listview from XML file I have difficulties in retreiving the data from XMl file that i have created. By using the coding as below, i m able to retrieve only 2 files and display it in the listview Below are my coding and XML file that i have created CODING Private Sub RegisterListView( Dim item As ListViewIte lvwDisplay.Items.Clear( For Each row As DataRow In TransTable.Row item = New ListViewItem(row("Category").ToString() If Not (row("Type") Is Nothing) The item.SubItems.Add(String.Format("{0:F2}", row("Type").ToString()) End I lvwDisplay.Items.Add(item Next ro End Su XML Fil -<Table1><Desc>566</Desc><Category>ttgg</Category><Type>Deposit</Type><Amount>667</Amount></Table1 - <Table1><Desc>tt6t</Desc><Category>rrt</Category><Type>Decrease</Type><Amount>566</Amount></Table1> Tag: Data truncation?? Tag: 19798
  - 24
    - Native exception occurs when application left open for some time Hi All, I've been troubled by a strange problem off late. I've created an application in which I play MP3 files using a 3rd party decoder. I P/Invoke the audio library functions in my .NET CF application to play the audio files. The problem occurs when I leave my application open for some time along with the other opened applications, and then try to access the opened application, I receive a Native exception A native exception has occurred in TalkingApp.exe. Select Quit and then restart this program or select Details for more information. ExceptionCode: 0xc0000005 ExceptonAddress: 0x0144d924 Reading: 0x4980246c What could be the source of the problem? I duly release the memory acquired by the native function within the native function itself, so I don't have to worry about freeing unmanaged resources from within my CF application. I'd appreciate if someone could throw some light on this. Please help. Regards, Asheesh Tag: Data truncation?? Tag: 19791
  - 25
    - Best way to access my SQLce Database?q I have written an application in VB.NET 2003 and I occasionally get one form not showing any data, because it is trying to open a connection to the database before the last form has completely released it's hold on the db. What is the best way to connect to the database? Is it better to connect once at the beginning and leave the connection open through the whole application. Will idividual datasets have problems running into each other? Or is it better to do it the way i have done it, connect only when you need the data and then close the connection right away. Which one is better, why? Thanks Tag: Data truncation?? Tag: 19776

Hi all,

Everytime I enter data into a SQL CE database using a windows form, the
entered data gets truncated.

When I view it using the Query analyser, I only see 6 characters. This only
happens with the nvarchar column types.

Is the data really getting truncated or is the query analyser set to display
only the first characters of the column?

SSP

Top

Re: Data truncation?? by Mark

Mark
Mon Feb 09 05:55:16 CST 2004

Are you sure that Query analyser does not show nvarchar (6) ?
With ntext this would not happen.

Mark Johnson, Berlin Germany
mj10777@mj10777.de
"SSP" <ssp@dt.com> schrieb im Newsbeitrag
news:O2h7p6o7DHA.3360@tk2msftngp13.phx.gbl...
> Hi all,
>
> Everytime I enter data into a SQL CE database using a windows form, the
> entered data gets truncated.
>
> When I view it using the Query analyser, I only see 6 characters. This
only
> happens with the nvarchar column types.
>
> Is the data really getting truncated or is the query analyser set to
display
> only the first characters of the column?
>
> SSP
>
>

Top