Recent content by rickydalley

  1. R

    Question Shell - doesn't work

    Found out how :D here's how System.Diagnostics.Process.Start("\Program Files\Buswork\PhoneAgent.exe", "") That does what I want to do. The 2nd parameter I have there is empty. If you want to pass arguments to the executing program put them in the 2nd parameter. regards, Ricky
  2. R

    Question Passing Value from one app to another.

    maybe try this If you don't want to put it into a database then how about you write the 1 line to a text file that both apps will point to? so VB calls C#, C# takes a photo, C# overwrites PictureFilename.txt, VB gets control back from C#, VB reads PictureFilename.txt and that should be it...
  3. R

    Question Shell - doesn't work

    Hi all. I saw on MSDN site that Shell isn't available to compact programming. I am wondering how I can run a program from within my vb.net program. I'm using VS2005 and creating my program as a Windows Mobile 5.0 Pocket PC application. I'm connecting to an SQLCompact 3.5 database and the...
  4. R

    SQLCE DATAREADER Problem (Probably simple)

    that still won't work Hi. I hit this using parameters. It won't recognise the @WORKORDERNO you have in your sql statement. SQL CE doesn't use named parameters in the sql. Use ? As you only have 1 parameter replacing the @WORKORDERNO with a single ? will fix it. If you have multi ones like...
  5. R

    Question umm stuck trying to get application folder

    I found out how Another search on the net showed me this Dim s As String = Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase Dim s1 As String = New System.IO.FileInfo(s).DirectoryName s1 will contain the application folder. regards, Ricky
  6. R

    Question umm stuck trying to get application folder

    I've tried searching the net but to no avail. I'd like to get what folder my application is running in on my ce device. Examples I've seen don't work. I'm using VB.Net 2005 on a winmobile 6 device. can anyone help? regards, Ricky
  7. R

    How to Make a Data-Driven Expense Program

    I have written a db driven application I'm using VS .Net 2005 and program in VB. I use SQL CE 3.0 database. I am a taxi driver and my app uses various tables to store data like Shifts, Fares, Tolls and others. reply here and I can help you start if you haven't already got it worked out...
  8. R

    Question Boolean formatting

    is that for desktop? I ask because we don't have a DataGridView control in .Net CF We have a DataGrid control. Also I'm not using datasets in my code - I populate a grid via a bindingsource using a command object and in some places a datareader (for populating my autocomplete combo boxes). I...
  9. R

    Question Boolean formatting

    thanks but not quite what i needed What I wanted is for when I display a datagrid that has a boolean field that it would show something other than True or False this case statement in the sql select is what does the trick Thanks to inertiam who showed me the case statement. here's the sql...
  10. R

    Question datagrid alignment of columns

    sorry - i wasn't clear The checkbox is one on the edit form - not on the grid. The grid shows Yes/No then when I load the fields of the edit form I convert the Yes/No to True/False for the .Checked property of the checkbox with the simple iif statement. It's working very well. Thanks for all...
  11. R

    Question datagrid alignment of columns

    True or False doesn't work It has to be 1 or 0. In sql boolean is represented by a bit type - 1 or 0. If I put True or False in the statement it crashes. I have it working with the 1 or 0. regards, Ricky
  12. R

    Question datagrid alignment of columns

    didn't work but finally got it to work This code is in my frmFares which has the custom column datagrid. I changed the sql statement to Select FareId,FareDate,FareHash,TimeStart,TimeEnd,Pickup,Dropoff,Fare,FareType, CASE(Booked) WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END As Booked From Fares...
  13. R

    Question datagrid alignment of columns

    Ummm that doesn't work I'm using VS2005 and Sqlce 3.0. This is my SQL statement. I put the Case statement in just like it says on the Microsoft website for v3.5 Select FareId,FareDate,FareHash,TimeStart,TimeEnd,Pickup,Dropoff,FareType, CASE Booked WHEN True THEN 'Yes' WHEN False THEN 'No' END...
  14. R

    Question Boolean formatting

    I'd like to be able to specify something other than true/false when dealing with booleans. At times I'd like to get it to show yes/no or on/off or even y/n I've searched the internet and alas I haven't seen anything. has anyone here dealt with this before? regards, Ricky P.S this is in...
  15. R

    Question datagrid alignment of columns

    one more question All the grid stuff is working good. I haven't tried the color thing. I don't have a need at this stage. I'd like to make the format of a boolean column to be yes/no instead of true/false I found some code that was make it work but alas I think it's for the desktop not ce...
Top Bottom