Visual Basic

Windows Services CPU Usage Problem

2-Dec-04 1:31

Once again, you haven't supplied nearly enough information to be able to help you.

geekru2 wrote:
Can we open new forms through or pass form compontes to dll

Yes. So long as your .DLL handles the Form properly and Disposes of it when it's done. But, since we know nothing about your .DLL's code or any problems your having with it, it's impossible to tell you anything useful.

geekru2 wrote:
I need to pass some message to listbox handler. It is not accepting it.

Since we don't know anything about this "handler", like what language it was written in, the parameters it takes and how they're supposed to be passed, the code inside this handler, what your actually passing to it, ... It's impossible to tell you what your doing wrong.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

sayhigh1-Dec-04 22:31

sayhigh

1-Dec-04 22:31

Seniors,

Please guide me about this problem..

my situation is like this:

At first, I have 1 windows service running(started 2 weeks ago) on my computer. It is running smooth as what i expected & the figure of CPU usage, memory usage, VM size and handles in Task Manager was normal/reasonable.

Now i have another new windows service installed in my computer.

The new windows service caused the CPU usage reached 90%++ and then i closed the new windows service immediately after i noticed it.

Unfortunately, the 1st/old windows service have been affected.
The old windows service CPU usage, memory usage, VM size and handles figure gone mad..
The figure is increasing steadily.

Statistic now: CPU usage more than 40%++, memory usage 50MB++, VM size 120MB++, handles 150,000

The uncertainty is very high!

I'm really out of idea, when & how the cpu usage and memory usage will go wild?

Any idea how would it be?

thanks for your valuable reply Smile | :)

Sayhigh Soon

How can i run external application from within .NET

Member 6254861-Dec-04 21:03

Member 625486

1-Dec-04 21:03

I amade an application that uses shell command to run SQL Loader. I want the sql shell to return if the sql loader command executed successfully. If not, i want it to return the text that was at the console when the program terminated.

KnowME

Re: How can i run external application from within .NET

Mekong River2-Dec-04 10:12

Mekong River

2-Dec-04 10:12

I think the suitable solution might be came from using batch file with script file. You can write script file to perform the action what you do, it is not reach any action then post the scrite file to inform the user that it is not working and vice versa. I'm rarely to use this kind of action too but try to check the script at Microsoft Scripting Center.[^]

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Moving DataGrid Items

Mitch F.1-Dec-04 9:55

Mitch F.

1-Dec-04 9:55

Hello,
I've been trying to move items up and down in a DataGrid in the .Net Compact Framework, using Visual Basic .Net 2003. I have tried using the InsertAt command, but I have not been able to get it to work.

Here is my current code to move an item up:

Dim currentpos As Integer
currentpos = DataGrid1.CurrentRowIndex
If currentpos >= 0 Then
Dim row As DataRow
row = DataTable.Rows(DataGrid1.CurrentRowIndex)
Dim NewRow As DataRow
NewRow = DataTable.NewRow
NewRow(0) = row.ItemArray.GetValue(0)
DataTable.Rows.RemoveAt(DataGrid1.CurrentRowIndex)
DataTable.Rows.InsertAt(NewRow, currentpos - 1)
End If

My code seems to sometimes work, other times it moves two items up, and sometimes it moves items around randomly.

Could anyone please help?

Thanks

Dave Kreskowiak1-Dec-04 10:49

1-Dec-04 10:49

What is your DataGrid bound to? Move the data around in the datasource, not the grid itself.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mitch F.1-Dec-04 11:47

Mitch F.

1-Dec-04 11:47

Hello,

My DataGrid is bound to a DataTable.

In my form's declorations, I have:

Dim DataTable As DataTable
Dim MyDataSet As New DataSet

In the custom function that sets the DataSource (without the extra code that loads in the XML data into the MyDataSet's DataTable, DT1):

DataTable = MyDataSet.Tables("DT1")
DataGrid1.DataSource = DataTable

Thanks

Dave Kreskowiak2-Dec-04 1:14

2-Dec-04 1:14

In that case, you can move records around in the DataTable and then Refresh the DataGrid after the modification is completed. Once all your changes are made, you can have the DataSet object that the DataTable is in write the XML file back out.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

reflection propertinfo getvalue

Mitch F.2-Dec-04 8:27

Mitch F.

2-Dec-04 8:27

Hello,

I haven't been able to find any methods that would allow me to move items up and down. Could it be possible restrictions on the DataTable in the .Net Compact Framework?

Thanks

Member 3857011-Dec-04 7:37

Member 385701

1-Dec-04 7:37

Try this source, after you plug in a value for yourDLLpath

Dim yourDLLpath As String = ""
Dim asm As [Assembly] = asm.LoadFrom(yourDLLpath)

Try
Dim oTyp As Type
For Each oTyp In asm.GetTypes
If oTyp.BaseType.FullName = "System.Web.UI.Page" Then
Dim pi As PropertyInfo = oTyp.GetProperty("Controls.Count", GetType(Integer))
Dim valueOfControls As ControlCollection
valueOfControls = pi.GetValue(oTyp, Nothing)
End If
Next

I cannot get rid of the "Object does not match target type error." I'm getting with the line : valueOfControls = pi.GetValue(oTyp, Nothing) How do I get the value of the controls? I'm trying to iterate through the controls on web pages to get values of certain control types. Thanks.

Re: reflection propertinfo getvalue

The Man from U.N.C.L.E.2-Dec-04 1:10

The Man from U.N.C.L.E.

2-Dec-04 1:10

Your problem is twofold.

1) The code to get the property is wrong. the line to get the Controls property should read :
Dim pi As PropertyInfo = oTyp.GetProperty("Controls")

2) The first parameter of the GetValue method takes the instance of the object from which you require the value. You have passed it the Type object instead. Clearly web page controls, or any controls, have no values until you initialise them. You could create instances of the webpage classes using Activator.CreateInstance and test those, or do things a different way.

Does Anyone not know anything about importing databases

Suresh Prasad1-Dec-04 6:40

Re: Does Anyone not know anything about importing databases

1-Dec-04 6:40

Hello All:

Does anyone not know anything about importing databases. I have posted two threads and no one has responded. Am I not in the right forum?
Thanks

Dave Kreskowiak1-Dec-04 7:20

Re: Does Anyone not know anything about importing databases

1-Dec-04 7:20

1) Your questions should be posted in the SQL/ADO/ADO.NET Forum.

2) You haven't posted any real questions other than "Can someone help me?". Help you with what? What code are you having a problem with?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mekong River2-Dec-04 10:17

Mekong River

2-Dec-04 10:17

Try to post the question, what you want to know about importing database? Tell the problem that you face.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

I need help please !!!!

Suresh Prasad1-Dec-04 5:18

1-Dec-04 5:18

Can please anyone help me with this one.. I am trying to import selected tables and fields from an ODBC Data Connection Source to an access databse. Your help would be very much appreciated. Thanks. Confused | :confused:

Dave Kreskowiak1-Dec-04 6:54

1-Dec-04 6:54

Help with what? You haven't asked any questions we can answer...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Suresh Prasad1-Dec-04 6:59

1-Dec-04 6:59

I am trying to import tables and selected fields from an ODBC Source to Access. Can anyone help me with the code that automatically imports selected tables and fields from the external database. The connection to the database is thru ODBC. Does this Help?

Dave Kreskowiak1-Dec-04 7:24

1-Dec-04 7:24

There is nothing that will "automatically" do this. You must write the code to reads one database and posts the data to another. What code have you written so far?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Suresh Prasad1-Dec-04 7:36

1-Dec-04 7:36

Dave:

what I meant by automate is doing it via VB Code. I dont have any code yet. I know there are 2 phases to this.
#1 to be able to connect to the external databse. (need code for this)
#2 to be able to read and import tables into access. (need code for this)

Scenario:
In External Database Import to Access
Table1 ----> Export table1 (selected fields)
Table2
Table3 ----> Export to Access (selected fileds)
Table4

Dave Kreskowiak1-Dec-04 11:48

1-Dec-04 11:48

Is there anything you don't need code for? You just described needing code for the entire application. Not gonna happen here. You have to try it yourself first.

If your importing into Access, why not just use the "Get External Data" wizard of the "Table Link" wizard. It will let you do everything you've described so far.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Suresh Prasad1-Dec-04 12:00

1-Dec-04 12:00

Dave:

I am trying to write a application. The part I dont understand is how to automatically pull in data from external source. This is not the full application, but it is the main component of extracting data into the system. I cannot use the wizard process because I need the data extraction part to be processed when the application is started. I know how to connect to the source, but dont know how to instruct the code to only import few tables and selected fields out of the table. All I am looking for is some generic code help and I can go from there. If you don't want to share any thoughts, could you at least point me to a resource site or something where I can get basic concept on getting this code going. Many Thanks.

Dave Kreskowiak2-Dec-04 1:10

2-Dec-04 1:10

This part requires a little SQL to select the tables and fields you want returned in a recordset. The Web, and Access' documentation, is filled with examples of how to do this. (I assume your writing this in VBA for Access.) I don't have any code examples, in VBA, to show you because I haven't used Access for anything in years. Just look in the Access documentation for the terms Connection, Command and Recordset and you'll find all the objects you need to read and write a database and examples to go with it.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Suresh Prasad2-Dec-04 6:38

2-Dec-04 6:38

Dave:

I really appreciate your help this far. This is what I have got so far.
Private Sub ImportToAccess()

Dim Con1 As New ADODB.Connection
Dim Con2 As New ADODB.Connection
Dim mySQL1 As String
Dim mySQL2 As String
Dim myDSN As String
Dim mySET As String

myDSN = "DSN=Springbrook1;UID=suresh;PWD=******;"
mySET = "set schema 'pub'"
mySQL2 = "select * from customer"

Con1.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Temp\VB Sample Codes\mcwd\Connect Program\test1.mdb;" & _
"Jet OLEDB:Engine Type=5;"

Con2.Open myDSN
Con2.Execute (mySET)

mySQL1 = "SELECT * INTO [tblCutomer] FROM [mySQL2]"

Con1.Execute mySQL1

Set Con1 = Nothing
Set Con2 = Nothing
Con2.Close
End Sub

I am getting the following error message:
The Microsoft Jet databse engine cannot find the input table or query 'mySQL2'. Make sure it exists and that its name is spelled correctly.

Is my code correct? Am I missing something for the mySQL2 line. If this works, I am sure I can define selected fields to be imported. Thanks for your help.