Re: Compitable source code between VB6 and Tally - Visual Basic Discussion Boards

How can I show a form while I read records from db?

JUNEYT16-Mar-07 5:54

16-Mar-07 5:54

Hello!

I got a major problem here. My function opens a database and reads 65000 records. While it does it, I want to show main form. It is hanging until all the records get loaded and then showing the form. I used Application.Doevents statment inside the loop but nothing has changed at all.

Question: How can I show form and then read from database? I placed the db function under Sub New procedure, Form.Activate, and Form.load procedure but it didn't work out? I am sure there is a way but what is it?

Thank You. D'Oh! | :doh:

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Re: How can I show a form while I read records from db?

Dave Kreskowiak16-Mar-07 7:07

Dave Kreskowiak

16-Mar-07 7:07

Ship reading the records off to a seperate thread. You UI thread will be free to show and update itself then.

But, why are you reading 65,000 records from a database? What's this for?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: How can I show a form while I read records from db?

JUNEYT16-Mar-07 7:26

JUNEYT

16-Mar-07 7:26

Hi Dave!

I am loding the words from different dictionery. I had decided not use of a seperate thread for this purpose because I thought it would be possible to show form first and then load the database but it didn't work out that way. I think you are right I better consider in using a seperate thread.

Thanks a lot. Smile | :)

What a curious mind needs to discover knowledge is noting else than a pin-hole.

WMI, Win32_Process or Process class question with IE

TenmanS1416-Mar-07 4:44

TenmanS14

16-Mar-07 4:44

just wondering if there's any way I can get the currectly active URL of IE using the process class or WMI?...

Basically I want to be able to remotely shut down IE if a certain webpage is hit.

I can get PID and name easily with the process class to put them in a datagrid, and then kill the process with WMI, just wondering how much more is possible.

Re: WMI, Win32_Process or Process class question with IE

Dave Kreskowiak16-Mar-07 7:00

Dave Kreskowiak

16-Mar-07 7:00

No, you can't get it using WMI. You have to do this using the Shell.Application object. You can then get the open browser windows from the Windows property, then iterate through those to get the LocationName and LocationURL's.

You'll need code running on each of the client machines you're monitoring because I don't think you can create the Shell.Application object on a remote server.

The other problem is that this will only work for IE browser windows. It will NOT work if the user is using any other web browser.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: WMI, Win32_Process or Process class question with IE

TenmanS1417-Mar-07 2:52

TenmanS14

17-Mar-07 2:52

Rats... was hoping to get away without having anything running on every machine... idea was to just have an old system sitting in my server room keeping an eye on things when required... I suppose it would be perfectly feasable for me to just have the client side bit of code as a very small app that can be run as a process (it won't have a GUI) when required on each client machine.

programs already doing its main job which is killing MSN on certain computers when people take advantage of my relaxed nature so I don't have to block it for everyone. I could set up the firewall to block certain sites like myspace.com but again, I don't want to kill it for everyone, only the people who are abusing it, and as I'm using IPCop its a bit of a pain to turn it on and off.

Compitable source code between VB6 and Tally

Deepak the Cool16-Mar-07 3:34

Deepak the Cool

16-Mar-07 3:34

hello

anyone give me some idea or sourc code for createin compitable between VB6 and Tally an accounting Package.i hav tou use a application at accounting module. if anyone hav some idea or source code thn share with me

Smile | :)

Deepak

Smile a Lots,Its Costs Nothing

Re: Compitable source code between VB6 and Tally

Dave Kreskowiak16-Mar-07 4:16

Dave Kreskowiak

16-Mar-07 4:16

It's very unlikely you'll get a response to this post. What you're asking is very specialized and the changes of somone seeing this post who even knows what Tally is are remote.

You're best source of information is going to be Tally Solutions[^] themselves.

Dave Kreskowiak
Microsoft MVP - Visual Basic

add jar file in vb dot net

shitendra16-Mar-07 2:00

shitendra

16-Mar-07 2:00

hi...
any body know how can we add the jar file in vb dot net 2005 version.i have only jar file not a java code.i want to use function of this jar file in vb dot net project.

thx and regards
hitendra singh

hitendra

Re: add jar file in vb dot net

Dave Kreskowiak16-Mar-07 4:10

Dave Kreskowiak

16-Mar-07 4:10

You can't call functions in a Java JAR file alone. It uses an entirely different runtime than the .NET CLR. The Java classes you want to use have to be exposed through COM in order for you to use them. If they're not already, and you don't have to source, your not going to be able to use that JAR file without writing your own Java code wrapper around those classes and exposing them to COM.

I don't do any Java development, so I don't even know if it's possible to expose that stuff through COM...

Dave Kreskowiak
Microsoft MVP - Visual Basic

serialzable XmlNode

ONeil Tomlinson16-Mar-07 0:59

ONeil Tomlinson

16-Mar-07 0:59

Im trying to serialize this class (as shown below) but im getting an error
"The type System.Xml.XmlNode is not marked as serialzable". How do i solve this problem?

<serializable()> _
Public Class Alert
Private mNotificationServer As String
Private mNewHour As Xml.XmlNode

Re: serialzable XmlNode

Marcus J. Smith16-Mar-07 2:40

Marcus J. Smith

16-Mar-07 2:40

Imports System.Xml.Serialization

<XmlRoot("Testing")> _
Public Class clsTest

    Private strName As String

    <XmlElement("NameToBeReturnedInXML")> _
    Public Property Name() As String
        Get
            Return strName
        End Get
        Set(ByVal value As String)
            strName = value
        End Set
    End Property

End Class

This is the type of setup if you are wanting to create a strongly typed object that is serialized. The XmlRoot attribute will be the main wrapper around the entire stream. The XmlElement attribute will be each element obviously.

This can get pretty ugly but it is very useful. If you wanted to have multiple employers for a person you could create an Employer class with all the information you want along with the Xml tags. Then you would create the main class and setup an array of type Employer(). You would then create the array of the object (there are other ways, this is how Ive done it) and add that array of Employers to the main class. Then when it is serialized it will do something like the following. (Note I had to remove the < >'s in order for it to show)

UserInformation
      Employers
          Employer
               EmployerName Emp1 /EmployerName
          /Employer
          Employer
               EmployerName Emp2 /EmployerName
          /Employer
     /Employers
/UserInformation

Here a site about the serialization Im showing you[^]

_Cle^aKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

selecting 2nd drop down only after selecting the 1st

hepsy16-Mar-07 0:17

hepsy

16-Mar-07 0:17

I have two drop down lists in my aspx page
One is UG and the other PG
If the user selects the PG drop down list before selecting the UG drop down list
an error or warning message should appear

Re: selecting 2nd drop down only after selecting the 1st

Smart_Boy16-Mar-07 1:19

Smart_Boy

16-Mar-07 1:19

disable PG drop down... and after selecting the 1st DD then enable PG DD.

Regards,
Smart Boy
Mumbai,
(INDIA)

Re: selecting 2nd drop down only after selecting the 1st

coolestCoder16-Mar-07 1:34

coolestCoder

16-Mar-07 1:34

Hi,
You can use AJAX for this. It is simple but powerful.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

Re: selecting 2nd drop down only after selecting the 1st

N a v a n e e t h16-Mar-07 2:32

N a v a n e e t h

16-Mar-07 2:32

function isPgSelectedBeforeUg()
{
     if ( document.getElementByid("UgName").selectedIndex == 0 )
     {
           alert("Ug should be filled before Pg");
           document.getElementByid("UgName").focus();
           return false;
     }
     else
           return true;

}

Put this code on the OnChange event of PG Dropdown.

string Cheers = "Navaneeth!!"

www.w3hearts.com

Re: selecting 2nd drop down only after selecting the 1st

hepsy16-Mar-07 21:28

hepsy

16-Mar-07 21:28

hi thanks
i wrote that function
and calling that function with this line of code

Me.ddlpg.Attributes.Add("Onselectedindexchange", "return isPgSelectedBeforeUg();")

but thats not working
can u correct it
Thanks

crystal report problem

Member 392923116-Mar-07 0:07

Member 3929231

16-Mar-07 0:07

I have used a tabcontrol in vb.net and inserted data to some textboxes and comboboxes.I want a crystal report in crystal report-10 showing the values.If the value is not entered then the field heading and the field value should be invisible.How can i do that?

Regards
Subrat Kumar Nayak

Re: crystal report problem

N a v a n e e t h16-Mar-07 2:36

N a v a n e e t h

16-Mar-07 2:36

wrote:
I want a crystal report in crystal report-10 showing the values

You can do this by adding the value to one XML file and reading the XML file to dataset and set reportsource as this dataset.

wrote:
If the value is not entered then the field heading and the field value should be invisible.How can i do that?

To do this I prefer to store the heading too in XML file. When creating XML file , check the value is null. If so make heading also null. Then in reports also heading won't come

printf("Navaneeth!!")

www.w3hearts.com

Debugging: cannot drill down into object collections in QuickWatch window

Yibbler15-Mar-07 23:47

Yibbler

15-Mar-07 23:47

My colleague and I have recently upgraded our projects from .NET Framework 1.0 and VS2002 to .NET Framework 2.0 and VS2005. We also applied the latest VS2005 service pack.

Our problem: normally when debugging we use the QuickWatch window to drill down into and view collections of objects belonging to the parent object we are "watching". THIS NO LONGER WORKS...instead, we get a message in the value line against the object collection saying:

"In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user."

This is incredibly frustrating, particularly when we have large nested collections of objects.

We are pretty sure this feature was working fine after we upgraded, but we are not so sure that it was working after we applied the VS2005 service pack.

Can anyone suggest any ideas that might help to solve this issue, as it is a massive hinderance to our productivity and our office swear box has been raking it in!!!

Cheers

Re: Debugging: cannot drill down into object collections in QuickWatch window

Kschuler16-Mar-07 7:50

Kschuler

16-Mar-07 7:50

Are you debugging a windows forms project, or a web project? Because if you are in a web project, just setting the build to debug mode isn't enough for VS2005. You would need to manually edit the web config to say debug=true instead of debug=false to get the debugger to work.

Otherwise, could you be a little more specific as to what you are quickwatching? Maybe give us the actual code you quickwatch?

Hope this helps.

Embedding Reports Within a cell !!!

fulbright15-Mar-07 20:41

fulbright

15-Mar-07 20:41

I am new to reports so might this question seamed stupid ... I am using Report Application Sever .I create a table and populate all the data required.Now I want to create a cross-tab (pivot table) instead and embed a report within the cell of cross-tab ... is it possible ?

Best Regards,

Madni

Root Directory

nitin_ion15-Mar-07 19:30

nitin_ion

15-Mar-07 19:30

I have created an application which sets IIS.
Now i am trying to install few files in the iis's root directory i.e.(c:\inetpub\wwwroot)
How can i get an iis's root directory path and also
if both versions of .net are installed (1.1 and 2.0) then how can i set to a particular version automatically.

Re: Root Directory

Ed.Poore16-Mar-07 7:18

Ed.Poore

16-Mar-07 7:18

You'll want to enumerate through the IIS variables using WMI. Try searching for "enumerating IIS directories with WMI"

the database has been placed in state by user "Admin"

charleslau285515-Mar-07 15:34

charleslau2855

15-Mar-07 15:34

hi,

Everyone know this error? the database has been placed in state by user "Admin"!

We are using a shared database in access databases. When more than one user has connect to my databases by my application (my program)the database open, the following error message appears. "The
database has been placed in a state by user 'Admin' on machine XXXXX that
prevents it from being opened or locked."

How to solve this error? please help!

My following code as below:

Try
DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb")
DB.Open()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Information, "")
End
End Try
Da = New OleDb.OleDbDataAdapter(sql, DB)
Ds = New DataSet
Da.Fill(Ds, "emp")

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.