Visual Basic

Re: operating system accounts(to login) in vb.net

13-Apr-07 0:28

I am using the following code to list the accounts of my operating system.
Currently i have just two accounts namely
1.Administator
2.Guest
But it shows 6 accounts.
can i filter the query to make it to show the actual accounts.

Dim oQuery As New Management.ObjectQuery("select * from <br />
 Win32_Account WHERE SIDType = 1")<br />
         Dim osearch As New ManagementObjectSearcher(oQuery)<br />
         Dim ocollection As ManagementObjectCollection = osearch.Get<br />
         Dim oresult As ManagementObject<br />
         For Each oresult In ocollection<br />
             TextBox1.Text = oresult("Name").ToString & " "<br />
         Next

Thank You
Pankaj

lucjon13-Apr-07 0:44

lucjon

13-Apr-07 0:44

I think it is showing the real accounts, with the `hidden` accounts, such as the help and support account, if you have VMWare installed, __vmware_user__ and other things.
You could try:

For Each oresult In ocollection
Dim oname As String = oresult("Name").ToString
If Not oname.StartsWith("SUPPORT") Then
   If oname <> "__vmware_user__" Then
      If oname <> "ASPNET" Then
          If oname <> "HelpAssistant" Then
              textBox1.Text = oname & " "
          End If
       End If
   End If
End If

I don't know if this'll work very well.

using Foxpro DB as backend to Visual Basic 2006

preci13-Apr-07 0:06

preci

13-Apr-07 0:06

hey there,

i am working in an organisation that uses foxPro for its DB needs. We are trying to convert it to SQL. how do i do that? also is there a possibility to develop a VB (not .Net) appln that uses foxpro as its back end? If there is please give me a sample of that code or where i could find it. Please some help me out with some insights.

signing off is preci

Re: using Foxpro DB as backend to Visual Basic 2006

Dave Kreskowiak13-Apr-07 3:49

Dave Kreskowiak

13-Apr-07 3:49

preci wrote:
We are trying to convert it to SQL. how do i do that?

No idea. I've never used FoxPro and, most likely, never will. I would assume that it would take a re-write of the entire database.

preci wrote:
also is there a possibility to develop a VB (not .Net) appln that uses foxpro as its back end?

Sure. You'd use the OleDb database objects, just like you would with an Access database. YOu can find the correct connection strings here[^] at ConnectionStrings.com.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

converting/mapping Foxpro DB to Visual Basic 2006

preci13-Apr-07 0:05

preci

13-Apr-07 0:05

signing off is preci

Very urgent problem in crystal reports please help

Shuaib wasif khan13-Apr-07 0:02

Shuaib wasif khan

13-Apr-07 0:02

i want to show records between two dates and my date datatype is varchar
i am inserting date in yyyy/mm/dd format
my record selection formula is
ir.RecordSelectionFormula = " {ViewPartyOrder.pcode}=' " + ComboBox2.Text + " ' and {viewpartyorder.orderdate}>=' " + DateTimePicker4.Value.ToString("yyyy/MM/dd") + " ' and {viewpartyorder.orderdate}<=' " + DateTimePicker3.Value.ToString("yyyy/MM/dd") + " ' "

ir is the object of crystal report
when i am using this i get blank record
but when i apply this into another table it works fine

Re: Very urgent problem in crystal reports please help

amaneet13-Apr-07 0:31

what is parameter range value how to use

13-Apr-07 0:31

try using ParameterRangeValue
Hope this may help u.

Shuaib wasif khan13-Apr-07 1:11

Shuaib wasif khan

13-Apr-07 1:11

i m new in crystal report please send me some code

sql query for month...

Member 387988112-Apr-07 22:55

Member 3879881

12-Apr-07 22:55

Hi based on my month and year input,
i need number of days in a month and number of sundays in that month, using sql query...,
i post this ques in sql place...,
but there i didn't get any reply..,
So if u guys know the query plz send me...,

Magi

Re: sql query for month...

jhoga13-Apr-07 5:24

jhoga

13-Apr-07 5:24

Doing that in vb fairly easy, do you have to do it with SQL.

exe in the system tray

amaneet12-Apr-07 21:04

12-Apr-07 21:04

Hi all,
My Question is concerned with the setup and deployment project in vb.net2005.
I wanted to know.... , Is there any way that I may place my exe - into the system tray after complition of the installation of my program - programatically in vb.net 2005
Thanks and regards
Pankaj Garg

Christian Graus12-Apr-07 21:56

12-Apr-07 21:56

amaneet wrote:
Is there any way that I may place my exe - into the system tray after complition of the installation of my program - programatically in vb.net 2005

No, you should write your app to behave this way, not try to make it work this way, after it is written.

Did you try google ?

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 )

lucjon12-Apr-07 22:38

lucjon

12-Apr-07 22:38

You could tell the installer to execute your program after the installation has finished.

amaneet12-Apr-07 23:29

12-Apr-07 23:29

HI there,
so what's the logic to tell the Installer.... , to do a particular thing, before the complition of the installation.
I mean can i put my poject exe into the System Configuation Utility/StartUp
programatically , before the complition of the installation.
Thanks You.

Christian Graus12-Apr-07 23:52

12-Apr-07 23:52

amaneet wrote:
I mean can i put my poject exe into the System Configuation Utility/StartUp
programatically , before the complition of the installation

You can make your installer put it in the startup, that's competely unrelated to putting it in the system tray. To do this, just add a shortcut in the Programs/Startup folder.

amaneet13-Apr-07 0:11

13-Apr-07 0:11

System Configuation Utility/StartUp(System tray)
can I make my installer put it in the System tray

Thank You Christian Graus

Christian Graus13-Apr-07 0:19

13-Apr-07 0:19

I already answered that. you were talking about startup, so I answered that, too. To put your app in the startup tray, you need to write it to be there, your installer can't do that ( like I said ).

amaneet13-Apr-07 0:43

13-Apr-07 0:43

Hi Christian,
I am not getting ur point.
My question was based on , how to pogramically put the application in the sys tray before the complition of the installation.I know the diffeence between startup and systray.Can u provide some steps to accomplish this task.
Thanks and Regards
Pankaj Garg

Christian Graus13-Apr-07 0:55

13-Apr-07 0:55

I'm sorry, I'm afraid if you can't understand English, there's not much I can do to help.

You cannot write an installer which pushes your app onto the system tray. You need to write your app to do this. And, if you google it, you'll see how to do that. Installation has nothing to do with it.

amaneet13-Apr-07 0:59

13-Apr-07 0:59

I am not afraid too , that how somebody select u as a Microsoft MVP C++

Christian Graus13-Apr-07 1:20