Visual Basic

using array (or recordset???!!) as datasource for datagrid

17-Jan-03 9:00

The function of my form is to generate an order. i am doing this by populating several rows of a datagrid. I have little experience with datagrids and i wish to save the contents of the datagrid, having gone through several validations (eg ensure every cell has been filled out, is there enough quantity in stock etc). i am wondering how to loop through each row of the datagrid, first to validate and then to save each row to the database? is it something like:

for row 1 to ? ( i am unsure of what to put here as the number of rows that will be in the order cannot be predetermined)
perform validation and saving......
next row

how do i declare the rows in the datagrid?
any help would be much appreciated! Thank you!

windows services

StevensN17-Jan-03 6:22

StevensN

17-Jan-03 6:22

Hi,

I have two applications that i have developed, both of these applications need to run in the background as a windows service when ever windows boots up and a user logs in.

Can anyone point in the write direction, i.e. articles or samples, that will help me to achieve this.

Many thanks in advance

Regards
Neil

Re: windows services

Ray Cassick17-Jan-03 7:08

Ray Cassick

17-Jan-03 7:08

First hit on google...

http://www.dotnetextreme.com/articles/writingwindowsservice.asp[^]

Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."

George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."

mcm17-Jan-03 4:05

Bidirectional TCP Genuine Channels are Available.

17-Jan-03 4:05

this is a complicated question and if i dont explain properly, or you need more info, please let me know..any help would be greatly appreciated!
at present, i have bound my datagrid to a "temporary" table (OrderDetails2) in the database, which is only being used for the purposes of the datagrid. instead i wish to bind the datagrid to an array and save the contents of the datagrid later, based on this array. the way the form is working right now is that Textboxes for ProductCode, ProductDesc,txtQuantity and txtFullPrice and when a command button is hit, the OrderDetails2 table is updated and the datagrid is populated correspondingly. Similarly, this happens when the command button is pressed for a second, third time etc. What i wish to happen to store the values in an array, and populate the datagrid this way, and when the command button is hit again , the (dynamic) array is redimmed and the datagrid updates corresponding. how could i go about this or is it even possible?! i have very little experience with arrays ( and indeed datagrids!)
Thanks in advance!

RunAs / LogOnAsUser

cescosystem17-Jan-03 3:50

cescosystem

17-Jan-03 3:50

Hi, i've a problem running an application on a machine which is used by a restricted user: i can't write the registry!!!!

I tried running this prog whith runas (from a dos shell) and it works...so i thought "well, i can write a program which run my application with admin privileges Smile | :)

". I surfed the net but the only things i found are info about this api "logonasuser"...i've made some tests but with no results.

Anyone had the same problem and knows how to resolve it? pls, i'm very short in time!!!

Bye Smile | :)

Bill200217-Jan-03 0:14

Bill2002

17-Jan-03 0:14

Web site: http://test.labdotnet.com/GenuineChannels/GenuineChannels.html

Genuine Channels implement bidirectional TCP channels (for .NET Remoting infrastructure) that solve the primary problem of native tcp channels and all sequential issues. Also they implement some features that help to build durable, viable and stable client-server solutions.

Brief explanation

Microsoft .NET Framework implementation of TCP channels allows using TCP channel only as a server or client connection. If you want to provide feedback from the server to client, server must connect to the client’s port. This scheme consumes two TCP sockets and is not workable if client is behind NAT or Masquerade server. Also, native implementation closes TCP connection after non-customized period of time.

Genuine Channels use the only connection from the client to the server. There is no problem if client is behind firewall, NAT or Masquerade server. Also, Genuine Channels implement some features to help building durable, viable and stable client-server solution.

Features
Only one TCP connection is used between client and server.
Fully compatible with .NET Remoting infrastructure.
Each connection has queue of messages being sent.
Constraints on the queue are possible. It greatly helps to force reconnection if current connection is too slow.
Automatic client reconnection to the server. Server and Clients does not lose messages during reconnection. It’s very useful if your server must talk to the client.
Full support of sync, async and one-way messages.
Adjustable timeout to wait for reply from the remote host.
Real async processing. You can have any number of threads at a server and at a client that will automatically use the same TCP connection.
Each exception has unique identifier that simplifies centralizing error processing or translating error messages to any language.
Automatic ping to check TCP connection if connection has not been used for (by default) 120 seconds.
Detailed logging system that receives all events and can save even the entire incoming and outcoming TCP streams as well as exceptions, stack traces and object’s guids. You can write your own logger and attach it to the system.

Dmitry Belikov.

HOWTO Determine the Memory required for a DOMDocument

Paul Farry16-Jan-03 20:08

Paul Farry

16-Jan-03 20:08

I'd like to know just how much ram is required for a loaded DOMDocument.

I've got some XML documents that are a few meg in size, and I'd just like to get an idea of how much memory is being used when these are loaded?

Is there a way to determine this?

copying arrays

brieg100016-Jan-03 11:07

brieg1000

16-Jan-03 11:07

Private Joe as Array

Dim lookupRows() As DataRowView = overrideView.FindRows(New Object() {"lookup_address"})

Simple prob but I'm having a b**ch figuring it out. lookupRows returns an array. how can i copy the returned array to Joe??

Thanks all

Bill

Nick Seng16-Jan-03 14:34

16-Jan-03 14:34

The following code should work:

Array.Copy(lookupRows,Joe,lookupRows.Length)

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

brieg100017-Jan-03 5:04

brieg1000

17-Jan-03 5:04

I tried that and got an error: Value cannot be null. Parameter name:destinationArray.

Which is kinda silly I think but. . .
I also tried CopyTo which produced the same error.

Richard Deeming17-Jan-03 8:01

Richard Deeming

17-Jan-03 8:01

Joe = Array.CreateInstance(GetType(DataRowView), lookupRows.Length)
Array.Copy(lookupRows,Joe,lookupRows.Length)

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

brieg100020-Jan-03 3:17

brieg1000

20-Jan-03 3:17

OK That worked THANKS !!

What if I need Joe to be an array of string ?? How could I / can I "typecast" this to a string array ??

Thanks again for the help so far !!

Bill

ADODC: no recordsource specified

Richard Deeming20-Jan-03 4:01

Richard Deeming

20-Jan-03 4:01

Array.Copy won't work, since there isn't a direct cast from DataRowView to String. You'll need to copy the array manually:

Joe = Array.CreateInstance(GetType(String), lookupRows.Length)
Dim i As Integer
For i = 0 To lookupRows.Length - 1
    Joe.SetValue(lookupRows(i).ToString(), i)
Next

However, since DataRowView doesn't override the ToString function, you'll just get an array filled with the string "[System.Data.DataRowView]". The DataRowView class isn't serializable, so you would need to write your own function to convert it to a string.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Issue with ToolTips

Andrew Stampor16-Jan-03 9:20

Andrew Stampor

16-Jan-03 9:20

I am using VB6 and am having a little problem. I am using the ToolTipText property of an MSFlexGrid control, and although the tip is displayed properly, if I click on the flexgrid while the tip is displayed, the tip will disappear and leave a light gray rectangle in its place. It doesn't seem to respond to the refresh method and I am stumped. Any ideas on how to get rid of the residue?

Thanks,
Andrew

mcm16-Jan-03 8:05

updating 2tables in database based on new record in datagrid

16-Jan-03 8:05

Several of my forms contain Adodcs, whose recordsource is a SQL statement containing a variable name. the Adodc (and bound datagrid) work fine for all, but whenever i load or unload the project i always get the following msg:
"ADODC: No Recordsource specified, ADO: cmd text was not set for command object"
Is there anything i can do about this? Thank you in advance!

mcm16-Jan-03 5:17

16-Jan-03 5:17

in my datagrid i have allowed for updates. the datagrid is bound to an adodc, whose datasource is a SQL statement (ie not a table in the access database). the datagrid contains 3 columns - 2 from the products table in the database and 1 from a related price table. how do i reference these 3 fields (for an insert SQL statement) when adding and saving a new record (row) in the datagrid? if you need any additional information, please let me know! any help would be greatly appreciated!

Grid

Ilan Ehrenfeld15-Jan-03 20:50

Ilan Ehrenfeld

15-Jan-03 20:50

Hi, My name is Rachel. I'm looking for a simple grid, no bound to database.
I need the ability to define simply:
1. The number of columns and rows.
2. The height of rows and width of columns.
3. To control easily on the selected cells.
3.1. I need to the ability to select some cells that are located far from one another.

Thanks Rachel Confused | :confused:

Nick Seng15-Jan-03 21:26

15-Jan-03 21:26

Might I suggest using the vsFlexGrid .

Notorious SMC

Ilan Ehrenfeld19-Jan-03 1:35

Ilan Ehrenfeld

19-Jan-03 1:35

Thanks for the suggestion. I know this one very well from previose versions of VB but where do I found it in the .NET version

Nick Seng19-Jan-03 4:36

19-Jan-03 4:36

That's strange, I'm using .net and I'm also using the flexgrid. hmmmm ...... could you use the grid in vb6 ?

Notorious SMC

Ilan Ehrenfeld19-Jan-03 20:17

Ilan Ehrenfeld

19-Jan-03 20:17

O.K I found it. It is now as VideoSoft FlexArray and not as FlexGrid.
But now there is a new problem. It is not share componenet thay want me to buy it, almost 300$ for this. I remeber that the flexgrid was free one.

Also to your ask befor. I do not have VS6 on my computers. I used it in previos works I had. On my current computers I installed the VS.NET from the start.

Thanks Very Much

Nick Seng20-Jan-03 15:36

populating textboxes based on current record in datagrid

20-Jan-03 15:36

Actually, the flexgrid in VB6 was not free. You could use it but it kept popping up messages asking you to buy it. I guess .net just tightened the rules and made it so that you have to buy it before you can use it.. Frown | :(

Notorious SMC

mcm15-Jan-03 9:22