yablonka

Hi all, I'm new to XML...I'm trying to populate an XML using data found in SQL server. The database consists of two tables (connected by a simple relationship) of suppliers and their products. To make a long story short, this is the result I'm trying to get: <SuppliersList> <Supplier> <Name>John</Name> <City>New York</City> <Product> <ProductName>Ballons</ProductName> <ProductType>Children</ProductType> </Product> <Product> <ProductName>Toys</ProductName> <ProductType>Children</ProductType> </Product> </Supplier> <Supplier> ... <Product> ... </Product> </Supplier> </SuppliersList> I'm trying to mess around with adapters unsuccessfully. Any help would be appreciated.

Thank you... Both replys can benefit me....

Hi all, I'm writing a very simple SQL script that performs a simple "select" query. The thing is that I want to use a "top" selection (select top 20 * from MyTable), however I want to use a parameter instead of a fixed number (select top X * from MyTable) I tried this: declare @MyTop as int set @MyTop=20 select top @MyTop * from MyTable Well...it doesn't work. I'm getting a "Incorrect syntax near '@MyTop'." message. Any idea how I should do this? Thanks. P.s. - I'm working with MSSQL.

Hi all, I'm trying to create a very simple procedure in VB.NET that gets a string and gives back a boolean indicating if the string matches a certain template. For example... if the string is: abcdefg and the template is: *cd?f* (* indicates zero or multiple characters and ? indicates a single character) then in this case the string does match the template. I'm trying to mess around with regular expression unsuccesfully. Anyone? (A sample code will be very helpful) Thanks.

...Oh The data being posted is found inside the "Content" byets.

Hi, I'm trying to recreate the following HTTP POST... The packet looks at the sniffer, as follows: 1:POST /Common/default.asp HTTP/1.0 2:Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */* 3:Content-Type: application/x-www-form-urlencoded 4:User-Agent: Mozilla/4.0 (compatible; HAM) 5:Host: 192.168.21.12 6:Content-Length: 61 7:Cookie: ASPSESSIONIDGQGGQARU=MFMBCGBKSDFGK; path=/ 8: 9: Content: (61 bytes of data) Whatever I tried I just couldn't recreate this exact packet. Please, anyone? P.S. - This is the first time I'm using HTTP with VB.NET, so please write your novice-version explanations.

Hi all, I'v created a windows service with VB.NET. This service includes a timer that preforms certain actions at every timer tick. Does anyone know why sometime when I try to stop the service, it gets stuck on StopPending status and doen't stop. I'v tried to release all the resources the service holds. Perhaps I'm doing it wrong... Any one??? please?!?! Thanks,

Hi all, I'v written a windows service in VB.Net... Can the service issue a service-stop command from itself onto itself??? i.e. if the service needs to stop running at some point can it stop itself? If so, how? Thanks

Hi all, I'm trying to create a simple server software to which client softwares can connect and recieve data... I did it in VB 6 ....how do I do this in VB.NET? Thanks

I'm trying to sort a dataset after I populated it with data using the readxml method. Example: If my XML file looks something like this: <request> <firstname>First_Name</firstname> <lastname>Last_Name</lastname> <dateofbirth>2/10/1979</dateofbirth> <address> <street>Street_Name</street> <zipcode>78212</zipcode> </address> </request> <request> . . . I want the records to be sorted by "dateofbirth". Thank you.

Hello, I created a stored procedure which receive a few parameters and inserts them into the DB according to some conditions, BUT - I'm very new to VB.NET, how do I call the store procedure at runtime and how do I pass the parameters??? Thank you,

Thanks but, I tried it and as far as I could see Connection.State does not update, i.e. once the connection is established the Connection.State gets the value of "1" and then if the connection is lost (because of network problems or anything like that) Connection.State does not contain "0" but remains "1".

How can verify that my connection is still alive after the Connetion.Open method was already called succefully? Thank you.

Does anyone know how can I insert data from an XML file into a DB at runtime (using VB.Net) Thanks