how to use sqlDataReader with DataGrid

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
    - accessing VC ActiveX from .NET Hi All, I have created an ActiveX control using VC 6.0. One of the interface implements a method which takes in VARIANT FAR* as the parameter. Iam unable to call this method from C#(.NET 2003) no matter what.. I can call the same method from VB 6.0. I have been bogged down by this problem for quite some time.. I dont have a clue what to do.. The funny thing is that I created a VB stub (again an ActiveX with method taking byref Variant), which calls the earlier mentioned VC activex method with the parameter passed to it. If I call the above VB method from C# using "ref Object" param it works fine!!! Following is the code: C# static void Main(string[] args) { VBActiveX VB = new VBActiveX(); VCActiveX VC = new VCActiveX(); Object OOO = new object(); VB.TryThis(ref OOO); // This Works!!! VC.TryThis(ref OOO); // This gives Exception "Catastrophic failure" } VB6 Dim VC as New VCActiveX; Public Function TryThis(ByRef A As Variant) VC.TryThis(A) ' This Works!!! End Function VC6 short VCActiveX::TryThis(VARIANT FAR* Var) { MessageBox( "What is Wrong???", NULL, MB_OK); return 0; } Similar to this problem, I have a third party ActiveX (VC6) which has a metthod with the same signature(VARIANT *). On calling this method from C# an exception "Type Mismatch" is raised, where as from VB6 it works alright???? So where am I going wrong.. thanx a million in advance Niranjan Tag: how to use sqlDataReader with DataGrid Tag: 18480
  - 2
    - Appforge ships Crossfire Yep. A little late, but ... "AppForge, Inc., the leader in multi-platform mobile and wireless application development solutions, today announced shipment of Crossfire, AppForge's mobile and wireless application development environment for the Microsoft .NET platform. Crossfire enables the growing community of .NET developers to design, develop and deploy custom applications for mobile devices with greater speed and efficiency." I still don't figure out what crossfire is for sure, but it look interesting. I'm downloading my demo version now. Luiz Tag: how to use sqlDataReader with DataGrid Tag: 18479
  - 3
    - Send a file over a TCP network connection Hi, I posted a question a while back relating to sending data over a network, and was told to go and look into how networks send data. I know that TCP can not guarentee the order in which data is delivered to a device. In light of this, I have a problem which I can not find a way out of: I need to send a file of around 4-5Mb over a network. To prevent communicaiton thread being locked, I was attempting to segment the data into 8k segments of data to be sent. In the header of each segment, I was attaching a 4byte integer representing the segment number, which will allow the reciever to place the data in the relevant position in the output file. Occasionally the client decodes the segment identifier into a bizzare value (last time I tried this, I was expecting to see segment number 234, and recieved -432352 or similar). However, this is not working,and the data being written out to a file at the reciever is not the same as the input data at the server. Why would this be? Please can anyone shed any light on this matter, or show me an example of how I should send the data/ensure that the data at the client end is pieced together correctly? Many thanks for any help - I am very confused by this matter. David Tag: how to use sqlDataReader with DataGrid Tag: 18478
  - 4
    - Usual Values for WebService.Timeout? Hello NG! The default for the timeout of an WebService is 100 seconds. I think, this is a long time to let the user know, that the server isn't reachable (with the specified url). So what are usual values in a scenario where mobile devices connect to a server over the internet? I thought of maybe 20 seconds? In my experience thee timeout-value affects only the allowed time to get the first contact to the server. Afterwards it isn't important, how long the WebMethod takes for calculating the result, isn't it? Do client and server 'talk' to each other while the result is calculated? Thanks, D.Barisch Tag: how to use sqlDataReader with DataGrid Tag: 18476
  - 5
    - Unable to connect with web service first time. Hi. Im using web services and my two questions are the following: 1. The first time the web service is called it always seems to generate a "Culd not connect to remote server". Any calls after that goes fine. 2. If connection is available then the first call to a web service is much slower than calls after that. Is this to be expected? Are there workarounds. Note: Im using Visual Studio .NET 2003 and the emulator only to try this. Haven´t tried his on a real piece of hardware yet. Regards <P> Tag: how to use sqlDataReader with DataGrid Tag: 18469
  - 6
    - Adding version info to project I guess I'm overlooking the obvious, but how do I add version info to my application? Cheers, Lars Tag: how to use sqlDataReader with DataGrid Tag: 18468
  - 7
    - Controls.Clear() throws ObjectDisposedException Hi, why does Controls.Clear() throw an ObjectDisposedException? Shouldn't I be able to clear the control list every time that I want? Thanks, Christoph Tag: how to use sqlDataReader with DataGrid Tag: 18466
  - 8
    - Copying files I need to copy some file from a SD Card to a folder on my PPC. Using File.Copy doesn't seem to preserve the timestamp of the file, so how do I do that? An existing app/sample that can handle it would also be of great interest. Basically, I have a text file with "From / To" filenames and need to copy each one of these. Cheers, Lars Tag: how to use sqlDataReader with DataGrid Tag: 18465
  - 9
    - VB Commenter? Hi all! I installed the VBCommenter power toy, but I cannot see the .xml generated file. I cannot understand why. I noticed only the Tools -> VBCommenter Options menu that ask with a messagebox for xml generation. I say "yes", but when I build the project I don't have that file. I also don't know if my answer remain valid the next time I start VisualStudio. Thank you for help Tag: how to use sqlDataReader with DataGrid Tag: 18464
  - 10
    - Programmatically compile code for Smart Device App using C# compiler Hi! Is there a possibility to programmatically compile code for Smart Device App using C# compiler? I know that CSharpCodeProvider class give me access to c# compiler and i can build an executable from text source, but can i create Smart Device Applications that way? Thanks for any help Very kind regards! Krzysztof Tag: how to use sqlDataReader with DataGrid Tag: 18462
  - 11
    - ListView and FocusedItem Hi. We are developing an application for the Symbol 8100, with a (almost) complete hardware-keyboard. And after the release of SP2 the use of the keyboard works pretty well. But im struggling with one issue: When my form loads, i read and fill a he listview, selects the last item, call the ensurevisible, and forces the focus to the listview. Then i want my user to be able to navigate up and down in the list using the up and down keys on the keyboard. But when i use Tag: how to use sqlDataReader with DataGrid Tag: 18461
  - 12
    - PPC 2003 & 2002 Emulators both launch I've just installed the PPC 2003 SDK, and would like to run my existing project using the new 2003 emulator. I have set the project to use 2003, but it still insists on launching the 2002 emulator first. Weird thing is, it installs .net & sqlce on 2002, copies the application over to 2002, and then also copies to 2003, finally launching the app only on 2003...aarrgghh I can create a new hello world app using 2003 and it works just fine.... Is there some switch in my project other than.. /////......CUT!! I just thought about it and figured it out on my own...the problem was that I had a .dll project in the solution that was still set to 2002. Moral of the story: make sure all your projects in your solution are set to the same device! I'm still sending this in case someone else has this bonehead problem.. Thanks anyway! Chris Tag: how to use sqlDataReader with DataGrid Tag: 18453
  - 13
    - TTS SAPI with cf I am trying to build my first CE App, I am a windows / web developer (So this compact framework is rather frustrating). I started with the simplist task on this project. Text To Speak. I can't figure out how to use a COM object with this framework though. Can anyone give me a starting point? I've seen articles around, but they all are doing it with embedded vc++. I would assume if it can be done with c++ it can be done with .NET. Any help would really be apprciated Tag: how to use sqlDataReader with DataGrid Tag: 18451
  - 14
    - .Net Compact Framework and Ping I cannot get an implementation of Ping to work, because the Windows CE OS does not support raw sockets (in spite of the fact that the MSDN docuemntation says it does). Does anyone have any information on working around this? Tag: how to use sqlDataReader with DataGrid Tag: 18446
  - 15
    - messagewindow not listening after losing focus Hey guys, I have 2 CF apps where one sends message and the other listens through a messagewindow. The problem occurs when focus is taken away from the listener app (e.g. by starting up another app), from that point on the messagewindow no longer receives messages even though the sender app is still sending them. I was wondering if any of you have run into this problem or have ideas as to what's going on. Yusuf Here is some of the code that does the communication: sender: Win32_PostMessage(new IntPtr(HWND_BROADCAST),RegisterWindowMessage(TRIGGER),0, IntPtr.Zero); receiver (the messagewindow is created in a form): private int WM_TRIGGER_ID = -1; public myMessageWindow() { WM_TRIGGER_ID = RegisterWindowMessage(TRIGGER) } protected override void WndProc(ref Message msg) { if (msg.Msg == WM_TRIGGER_ID) //do stuff base.WndProc(ref msg); } Tag: how to use sqlDataReader with DataGrid Tag: 18444
  - 16
    - Last item of a Hashtable Hi, is there a way to get the last inserted item of a hashtable in the compact framework?? What would you recomend?? Thanks. Isaias Formacio Tag: how to use sqlDataReader with DataGrid Tag: 18440
  - 17
    - ExtractIconEx using *.ico files? Hi I am trying to use ExtractIconEx to show an icon on the notification area. The notification side of things is OK and working fine. However I need to be able to show a variety of icons; currently I am usin ExtractIconEx(System.Reflection.Assembly.GetCallingAssembly().GetModules()[0].FullyQualifiedName, 0, 0, ref m_hIcon, 1) which uses the current application icon; however I would like to point to a resource file or ico file to display. Tag: how to use sqlDataReader with DataGrid Tag: 18438
  - 18
    - cstring to class Hi: I have 10 Labels in my FORM! lable0,lable1,lable2......lable9. and i have a cstring [] username = new cstring[10]; I use lable0.text = username[0]; lable1.text = username[1]; ...... lable9.text = username[9]; How can i use for(int i=0;i<10;i++) { ?("lable"+i.ToString()).text = username[i]; } Thank you! Tag: how to use sqlDataReader with DataGrid Tag: 18437
  - 19
    - GetCurrentMethod alternative Does anybody know an alternative to System.Reflection.MethodInfo.GetCurrentMethod() that can be used in the .Net Compact framework? thanks Tag: how to use sqlDataReader with DataGrid Tag: 18423
  - 20
    - SqlCeRemoteDataAccess Pull Im using RDA (SqlCeRemoteDataAccess) to retrieve data from a remote sql server to a pocket pc device It works no problem, in that if no sql server ce database exists on the device the pull method retrieves the required data and creates a local sql server ce database The problem I have is refeshing the data I initially retrieved. I have tried using the same code but it fails. Now if before using the same code i delete the sdf file off the file system and then use rda pull again it works fine. I tried leaving the database intact and dropping the local table i want to refresh and then trying rda pull again but that fails too So it appears to use rda pull the database must NOT exist and the call to pull creates the database. The problem i have is that there are numerous tables in the local sql server ce database and i only want to refresh the data in a couple of tables rather than retrieving the whole database as this is not required. My question really is just to confirm , can you use rda pull to refresh data in a local ce database file that already exists. My experience leads me to believe you can't but could someone confirm or deny this THank An Tag: how to use sqlDataReader with DataGrid Tag: 18420
  - 21
    - How to change messages between .Net CF app and EVC app? I need to send a message or event from a Smart Device Application to a Embedded VC application. Any sugestion? Thanks Ricardo Tag: how to use sqlDataReader with DataGrid Tag: 18414
  - 22
    - Image on Toolbar Hello everybody when I disable my toolbar image the whole image turns black. It doe not "grey out". Is there something wrong with my image or should I ad another image that is "grey out" and set that image to the toolbar whe it is disabled thanks adam Tag: how to use sqlDataReader with DataGrid Tag: 18412
  - 23
    - Symbol PPC barcode scanner problem Hi all, I've got a problem with a Symbol PocketPC with integrated barcode scanner (in particular a 2800 series). With the .net CF Symbol libraries: I cannot read (I see the symbol samples) barcodes (type interlaved 2/5) with less than 8 characters. I can read "12345678", "1234567890" but not "1234" or "123456". Someone can help me? Thank you -- Math Parser : http://www.neodatatype.net Tag: how to use sqlDataReader with DataGrid Tag: 18399
  - 24
    - List View Control CF .NET. Change the Color of a row. Good Morning, does anybody know how to change the color of the one row to "list view control" on CF .NET ? I 've installed Service Pack 2 Compact FrameWork .NET, but I can`t change the color of the row to list view control. Thanks and best regards. Alamo Tag: how to use sqlDataReader with DataGrid Tag: 18394
  - 25
    - Get make of Device Is there an easy and generic way of getting the make of a device? I.e. Dell, Compaq/HP, Intermec etc... Tag: how to use sqlDataReader with DataGrid Tag: 18382
- Next
  - 1
    - Device ID I know you can use platform invoke to get the Device ID on pocket PC but why didn't they just provide a method in the CF that would return this? Drew Tag: how to use sqlDataReader with DataGrid Tag: 18377
  - 2
    - Resize label height to fit wrapped text. Hello, Since CF doesn't support the 3-arg MeasureString(), how can I dynamically set the height of a label (I'm doing a tooltip kind of control) to fit its text? I have this so far: Label text = new Label(); int tipWidth = 180; [...] SizeF sz = e.Graphics.MeasureString(Tip, font); int lines = Convert.ToInt32(sz.Width / tipWidth) + 1; int height = Convert.ToInt32(lines * (sz.Height)); text.Size = new Size(tipWidth, height); // add a pixel all round to fit the border on this.Size = new Size(tipWidth + 2, height + 2); The problem with this is that it doesn't take into account space wasted by word-wrapping. How can I calculate how many extra lines I need? Is there some way of extracting n pixels from a drawn string and working out if the last word is complete? Thanks for any help, .pd. Tag: how to use sqlDataReader with DataGrid Tag: 18373
  - 3
    - DataSet.GetXml() removes unused columns Hello, I just wanted to ask if it is expected behavior, that unused columns get removed in the string that I get from DataSet.GetXml(). So, when I reload from that XML, I have to check for myself if all columns are available? Thanks, Christoph Tag: how to use sqlDataReader with DataGrid Tag: 18368
  - 4
    - PDA--> Desktop 2-way Comms Hi all I'm trying to find examples of way so have 2-way communication between the PDA and the desktop. I thought I was into a winner when I tried to make use of the examples from Microsofts' .Net Compact Framwork Core Reference book, but the Netstream code was written for WinCE (PPC2002 here) and I can't get it to work even after replacing console calls with dumping stuff to a text box (error is generated: An unhandled exception of type 'System.IO.IOException' occurred in System.dll Additional information: Unable to read data from the transport connection. ) Was wondering if anyone has any pointers. Thanks Paul Tag: how to use sqlDataReader with DataGrid Tag: 18367
  - 5
    - can i use the ppc2002 RegEdit on ppc2003 (that was stupid 2 have my name on the subject. SORRY ALL) hi can i use the registry editor of the pocket pc2002 on a pocket pc2003 running? or will it cause trouble and show wring key's? i tried it and figured then for instance the launch keys in hkey_local_machine/init/launch10 seem not 2 work at all. anyone knows about this? anyone knows where 2 look for the registry call on explorer.exe? best regards -- kurt -- Tag: how to use sqlDataReader with DataGrid Tag: 18366
  - 6
    - -- kurt -- h can i use the registry editor of the pocket pc2002 on a pocket pc2003 running? or will it cause trouble and show wring key's? i tried it and figured then for instance the launch keys in hkey_local_machine/init/launch10 seem not 2 work at all anyone knows about this anyone knows where 2 look for the registry call on explorer.exe best regard -- kurt -- Tag: how to use sqlDataReader with DataGrid Tag: 18364
  - 7
    - TCP send interval Hi all, how long is the time in which tcp sends a package again if the package not received. can i also set this time? Thx Tag: how to use sqlDataReader with DataGrid Tag: 18360
  - 8
    - SNTP Client for PPC 2002 or Alternative ? Hi All, I need an C# SNTP Client for my PPC 2002 app, in order to sync the time with my server. I've stumbled across some clients that use UDP but it's unreliable and hangs since no Time Out value can be set. Does anyone know of an SNTP Client that allows me to set a Time Out value? or any other way to sync time with the server ? Cheers, Ciaran Tag: how to use sqlDataReader with DataGrid Tag: 18359
  - 9
    - Interrupting Events from within Parent Control Hello, ive got the following problem, which i hope gets solved here. I ve got a Form with a Number of Controls in it (Button, Listboxes and Textboxes). The user can use a config-file to control the output target of an attached scanner. If i use the scanner while a Textbox is focussed, the scanned code gets inserted into that textbox. My problem is, that i need to decide where the scanned code gets put to. For example, if the output target is Textbox 'A' and Textbox 'B' and Button '1', then the scanned code has to be atttached to these three controls. Dows anyone knows how to intercept a Keypressed event for example on a parent control(Form), since all the controls i mentioned above, are added to the Form. The reason for this is, that if the scanner is used, i want to decide in this one event, where to put the scanned text to and even if i handle the scanned code in any way. Thanks in advance Greeting Jens Meyer Tag: how to use sqlDataReader with DataGrid Tag: 18356
  - 10
    - Full setup program ? Hello, Is it possible to create a setup program which could be executed from the Pocket pc himself ? I do not want to use a desktop PC but i would like to provide a full setup program (.EXE or .MSI) on a SD card. It will contain sql CE, CF and my smart application. Thanks, PJ Tag: how to use sqlDataReader with DataGrid Tag: 18353
  - 11
    - ListView: some lines bold / first column right-align? Hi, two question about the ListView: 1.) why can't i set the first column to "right aligned"? It works with the sub-items - but not for the first column. 2.) how can i set the font for some lines (depending on the date i like to display) to bold or italic or change the color? thanks Boris Tag: how to use sqlDataReader with DataGrid Tag: 18352
  - 12
    - function names, debugging Hi, I'm currently adding log file functionality to a project to help with trouble shooting after its been deployed to clients. I'd like to be able to write out a function name or some other constant to indicate where execution is up to. In c++ you can use things like _FILE_ and _LINE_ to output the file name and a line number. In the full .Net framework you can use GetCurrentMethod but I havent been able to find anything to use in the .Net CF. The best I've come up with is: System.Reflection.MethodInfo mi = this.GetType().GetMethod("Download",System.Reflection.BindingFlags.DeclaredO nly|System.Reflection.BindingFlags.NonPublic|System.Reflection.BindingFlags. Instance); App.Log(mi.DeclaringType+"::"+mi.Name); But obviously I'd prefer not to have to type the function name (in this case 'Download') every time I wish to log something. Any suggestions would be appreciated. Any constant that can be traced back to a particular place in the source files would be fine. Thanks Josh Tag: how to use sqlDataReader with DataGrid Tag: 18343
  - 13
    - Numeric Keypad? Does anyone know if there is such thing as a numeric keypad control that can pop up similar to the way some of the third party date/time picker controls do? I have a data entry app that requires a lot of numeric entry and would like to have the ability to pop up a small numeric (only) keypad to enter the information. I would like to avoid using the SIP as much as possible mostly because it can take up a lot of screen space and it's numeric keyboard is more complicated than I need. Any input would be greatly appreciated! Mike Tag: how to use sqlDataReader with DataGrid Tag: 18329
  - 14
    - read sms in compactframewok how get sms message in cf. thanks Tag: how to use sqlDataReader with DataGrid Tag: 18319
  - 15
    - Windows CE Platform and Driver Engineer Needed Our company in Dallas is looking for a top-notch engineer wit Windows CE platform and driver development experience. Here are the facts o Megger is a world leader in advanced test and measuring instruments for telecom and electrical power applications. o We are looking for a key team member who can hit the ground running on the design, development, integration and test of a CE platfor and device drivers for a CE-based test device Candidates must have the following credentials and experience o A BSEE or BSCE degree with a minimum of 4 years related experienc o A minimum of 2 years Windows CE platform and driver developmen using Platform Builde o Excellent written and verbal communication skill Experience in the following areas is a plus o TCP/IP networkin o RNDIS developmen o Hardware desig U.S. Citizen or permanent resident - no H1 visa sponsorshi Megger offers an excellent work environment and competitive compensatio program. For consideration, email resume to hr@megger.com. Megger is a equal opportunity employer Tag: how to use sqlDataReader with DataGrid Tag: 18316
  - 16
    - help reading a key from the register: RAPI This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C3DF6B.E043A490 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I wrote a key to the registry of my PPC using the OpenNETCF.Win32 = utility (this is a VB.NET program that runs in the PPC itself). This key = is but the Device ID that I also get using RAPI in VB.NET. I store this = id in \HKEY_LOCAL_MACHINE\HARDWARE\UUID\DeviceID=3D123-456-789 where the value for DeviceID is the actual id of my PPC. I verified that this entry is indeed in the registry by reading the = subkey "HARDWARE\UUID" with = OpenNETCF.Win32.Registry.LocalMachine.OpenSubKey("HARDWARE\UUID").GetValu= e("DeviceID") . Now from a desktop application (aka vb6 now), I need to read this value = to identify the PPC I'm conecting to. I'm using the RAPI functions: = CeRegOpenKey and CeRegQueryValueEx. CeRegOpenKey opens the registry at HKEY_LOCAL_MACHINE and returns a = handle that is used by CeRegQueryValueEx. CeRegQueryValueEx runs = successfully, I can confirm that it reads a string value of size 72 = bytes ....... but the actual value it reads is empty: Public Declare Function CeRegQueryValueEx Lib "rapi.dll" ( _ ByVal hkey As Long, _ ByVal lpValueName As Long, _ ByVal lpReserved As Long, _ lptype As Long, _ ByVal lpData As Long, _ lpcbData As Long) As Long Public Function GetCERegistryValue(ByRef hkey As Long, ByRef value As = String) As Long Dim subkey As String Dim lpData(1000) As Byte Dim cbData As Long Dim lptype As Long =20 subkey =3D "DeviceID" GetCERegistryValue =3D CeRegQueryValueEx(hkey, StrPtr(subkey), 0, = lptype, lpData(0), cbData) If GetCERegistryValue <> ERROR_SUCCESS Then value =3D UnicodeToAnsiByte(lpData) Exit Function Else value =3D UnicodeToAnsiByte(lpData) End If =20 End Function Private Function UnicodeToAnsiByte(bString() As Byte) As String Dim index As Integer Dim stemp As String stemp =3D "" While Not (bString(index) =3D 0 And bString(index + 1) =3D 0) stemp =3D stemp & Chr(bString(index)) index =3D index + 2 Wend UnicodeToAnsiByte =3D stemp End Function I put a breakdown at the red line to see what is stored in the variables = lptype, lpData, and cbData. lpData should store the value of DeviceID, but it does not. It returns = an empty array. However, lptype is set to 1, which means it read a "null = terminated string", and cbdata is set to 72, or 72 bytes for whatever it = read (this is the actual value of the ID =3D = E60A00E6-105F-E135-0038-0050BFE45CE5) what am I doing wrong here? any ideas? ------=_NextPart_000_0016_01C3DF6B.E043A490 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.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I wrote a  key to the registry of = my PPC using=20 the OpenNETCF.Win32 utility (this is a VB.NET program that runs in the = PPC=20 itself). This key is but the Device ID that I also get using RAPI in = VB.NET. I=20 store this id in=20 \HKEY_LOCAL_MACHINE\HARDWARE\UUID\DeviceID=3D123-456-789</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>where the value for DeviceID is the = actual id of my=20 PPC.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I verified that this entry is indeed in = the=20 registry by reading the subkey "HARDWARE\UUID" with=20 OpenNETCF.Win32.Registry.LocalMachine.OpenSubKey("HARDWARE\UUID").GetValu= e("DeviceID")=20 .</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Now from a desktop application (aka vb6 = now), I=20 need to read this value to identify the PPC I'm conecting to. I'm using = the RAPI=20 functions: CeRegOpenKey and CeRegQueryValueEx.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>CeRegOpenKey opens the registry at=20 HKEY_LOCAL_MACHINE and returns a handle that is used by = CeRegQueryValueEx.=20 CeRegQueryValueEx runs successfully, I can confirm that it reads a = string value=20 of size 72 bytes ....... but the actual value it reads is = empty:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>Public Declare Function = CeRegQueryValueEx Lib=20 "rapi.dll" ( _<BR>    ByVal hkey As Long, = _<BR>   =20 ByVal lpValueName As Long, _<BR>    ByVal lpReserved As = Long,=20 _<BR>    lptype As Long, _<BR>    ByVal = lpData As=20 Long, _<BR>    lpcbData As Long) As Long</FONT></DIV> <DIV><FONT face=3DCourier size=3D2></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>Public Function = GetCERegistryValue(ByRef hkey As=20 Long, ByRef value As String) As Long<BR>    Dim subkey As = String<BR>    Dim lpData(1000) As = Byte<BR>    Dim=20 cbData As Long<BR>    Dim lptype As = Long<BR>   =20 <BR>    subkey =3D "DeviceID"<BR>   =20 GetCERegistryValue =3D CeRegQueryValueEx(hkey, StrPtr(subkey), 0, = lptype,=20 lpData(0), cbData)<BR>    <FONT color=3D#ff0000>If=20 GetCERegistryValue <> ERROR_SUCCESS=20 Then<BR></FONT>        value =3D=20 UnicodeToAnsiByte(lpData)<BR>        = Exit=20 Function<BR>   =20 Else<BR>        value =3D=20 UnicodeToAnsiByte(lpData)<BR>    End = If<BR>   =20 <BR>End Function</FONT></DIV> <DIV><FONT face=3DCourier size=3D2></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>Private Function = UnicodeToAnsiByte(bString() As=20 Byte) As String<BR>    Dim index As = Integer<BR>   =20 Dim stemp As String<BR>    stemp =3D = ""<BR>    While=20 Not (bString(index) =3D 0 And bString(index + 1) =3D=20 0)<BR>        stemp =3D stemp &=20 Chr(bString(index))<BR>        index = =3D index=20 + 2<BR>    Wend</FONT></DIV> <DIV><FONT face=3DCourier></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>    UnicodeToAnsiByte = =3D=20 stemp<BR>End Function</FONT></DIV> <P><FONT face=3DArial size=3D2>I put a breakdown at the red line to see = what is=20 stored in the variables lptype, lpData, and cbData.</FONT></P> <P><FONT face=3DArial size=3D2>lpData should store the value of = DeviceID, but it=20 does not. It returns an empty array. However, lptype is set to 1, which = means it=20 read a "null terminated string", and cbdata is set to 72, or 72 bytes = for=20 whatever it read (this is the actual value of the ID =3D=20 E60A00E6-105F-E135-0038-0050BFE45CE5)</FONT></P> <P><FONT face=3DArial size=3D2>what am I doing wrong here? any = ideas?</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P></BODY></HTML> ------=_NextPart_000_0016_01C3DF6B.E043A490-- Tag: how to use sqlDataReader with DataGrid Tag: 18314
  - 17
    - is it possible to install the .NET compact framework? this may be a dumb question, but i'm working with some HW that is going to be running Windows CE 4.2 . this doesn't necessarily mean that the .NET compact framework is going to be available in their SDK does it? or does it? from what i read on this FAQ (http://msdn.microsoft.com/mobility/prodtechinfo/devtools/netcf/FAQ/default.aspx) it seems that the SDK has to have it included w/ the SDK, so i'm guessing you can't install it later thanks ... Tag: how to use sqlDataReader with DataGrid Tag: 18311
  - 18
    - Help with bug... In CF SP2 if I press ESC in a text control on my app, the app crashes and I have to reset my machine to get my app to restart. I can't even go to the Task Manager to close it, it must be a soft reset. Has anyone else come across this problem? If so, are there any known workarounds or fixes? Thanks. Atley Tag: how to use sqlDataReader with DataGrid Tag: 18307
  - 19
    - XSLT in .NET Compact Framework Whidbey? Hello! I may read that .NET Compact Framework Whidbey adds support for XPath, but what about XSLT, is XSLT also supported in .NET Compact Framework Whidbey? Best regards, Henrik Dahl Tag: how to use sqlDataReader with DataGrid Tag: 18299
  - 20
    - TabOrder problem How do I set the TabOrder for controls in my VB.net 2003 app? I just don't get this... I have tried to order the creation of the objects in the code in the order I want them to tab in to no avail. Any suggestions? Atley Tag: how to use sqlDataReader with DataGrid Tag: 18297
  - 21
    - ANN: OpenNETCF.Desktop.Communication v2.4 Released OpenNetCF.org has released v2.4 of the OpenNETCF.Desktop.Communication Library. The Desktop.Communication Library contains classes used for communicating with a CE device from a PC such as Microsoft's Remote API (RAPI). We've made a minor bug fix in GetSubKeyNames() Get the source and binaries here: http://www.opennetcf.org/communication.asp A sample is available here: http://www.opennetcf.org/samples.asp All OpenNETCF.org libraries are covered by the OpenNETCF Shared Source License. For more information visit: http://www.opennetcf.org/License.asp -- Chris Tacke, eMVP Advisory Board Member www.OpenNETCF.org --- Windows CE Product Manager Applied Data Systems www.applieddata.net Tag: how to use sqlDataReader with DataGrid Tag: 18294
  - 22
    - KeyDown and others... Hi everyone! I can get the KeyDown, up, and other directional events in my app. But my Ipaq allows the center of the dpad to be pressed like a button; is there a handler for this? I can't seem to figure out how to capture this event. Thanks, Tom Tag: how to use sqlDataReader with DataGrid Tag: 18289
  - 23
    - saving signature I've honestly been looking through more than 50 posts and I wonder whether someone's got an interesting solution. I had a look at and played around with Alex's NoteTaker. I have to admit, it's amazing. You get some kind of graphic file back that is less than a kiloByte and the quality's great! I don't really care about the format tbh as I can still open it in Word. The only problem is that I get cannot just show the panel in of my tabs-it's always on top. Secondly I get a NullReferenceException when I want to save it. Pretty weird I know. I also had a look at Martin Stave's post on OpenNETCF.org (http://www.opennetcf.org/Forums/topic.asp?TOPIC_ID=339), but I just don't quite understand how to use that code in my form. Furthermore, the size (>300kiloBytes) is enormous compared to the first option. Although I will be using a storage card in each PPC (probably >256MB) I still don't think this is the best option as I would also have to synchronize the signatures along with other data by WiFi every day (approx. 50 signatures per PPC). Obviously, I didn't forget to look at the thread that explains how to save a signature as a string. You come out with a file that is about one kiloByte but then yeh, it's a text file. I'd love to have an easy to open graphic file without the need to use some other kind of special desktop application. I also re-opened the MSDN article that explains how to save a signature as a text file then encrypt it and decrypt it using a custom-made desktop application. I just don't need the whole encypt-decrypt shmooze and don't want a text file. Finally, dearest Hood Canal Systems, I did not forget you. Forgive me if you are last - but you're not free (cheap is still not free:/). Looks interesting, I supose I could buy the software and implement it into my program but I guess I'd more interested to just try out something on my own or have a look at some other code and try to implement it in my application. So here goes again, has anyone actually found a way to save a signature to a graphic file without too much trouble ? I have looked through so many posts and couldn't find one satisfying answer. Thanks again jez Tag: how to use sqlDataReader with DataGrid Tag: 18283
  - 24
    - how to get the mouse pos on Poket pc I am developping an application under windows CE .net. the platform is a pocket pc with a stylus, I need to get the position of the stylus (or the position on it's last click). the Control.mousePosition works with the emulateur but not with the real stuff. i can't use the mouse event handler neither. Is there a way? thanks Tag: how to use sqlDataReader with DataGrid Tag: 18280
  - 25
    - No OverLoad in my version of Invoke ?? In most of exemple found on the web the this.Invoke have 2 overload... in my VisualStudio .Net 2003 I have only one!! I need to pass some parameters to the delegate function... so how can I do?? Thanks ____________________ Franky Franky@Boucheros.com Tag: how to use sqlDataReader with DataGrid Tag: 18277

I want to fill fastest is possible a Datagrid, get data from remote database
include.

So the DataReader if faster than DataSet... BUt How can i use it (fastest
way) for fill my DataGrid?

Thanks
____________________
Franky
Franky@Boucheros.com

Top

Re: how to use sqlDataReader with DataGrid by William

William
Thu Jan 22 09:01:44 CST 2004

The only way I know of is to use the datareader to build a datatable and
bind to it. Behind the scenes, a datareader is used to create a datatable
when you call fill so I'm not sure how much of a performance gain you are
going to see (the methods are roughly equivalent - calling da.fill vs using
a DataReader and creating your own datatable) but you'll have to write some
more code just for filling and the same will hold for updating...moreover
you'll need to come up with a mechanism to handle concurrency unless you
just want to ignore it as an issue (which I'd advise against).

HTH,

Bill
"Franky" <franky@boucheros.com> wrote in message
news:e2DxI1O4DHA.2512@TK2MSFTNGP09.phx.gbl...
> I want to fill fastest is possible a Datagrid, get data from remote
database
> include.
>
> So the DataReader if faster than DataSet... BUt How can i use it (fastest
> way) for fill my DataGrid?
>
>
> Thanks
> ____________________
> Franky
> Franky@Boucheros.com
>
>

Top