Visual Basic

Stephen McGuire20-Aug-06 11:13

20-Aug-06 11:13

Thanks for your input.

I have got an MCSD in .NET 1.1 so I'm fairly familiar with that. I do feel that I need to update my skills to .NET 2.0 and SQL Server 2005.

I've had no real need for it as yet, but I would like to know more about it before I am thrown in the deep end!

I learned for a long time from the Microsoft books. It was quite some time before I realised that other people are so much better at teaching than Microsoft are. I just want to know if anyone has any recommendations, so that I don't have to battle with Microsoft's grammar again! I was also surprised of how much they actually have WRONG in their books...

Steve

Kevin McFarlane20-Aug-06 11:58

Kevin McFarlane

20-Aug-06 11:58

If you're an MCSD I'm sure you'll get along just fine without books. Smile | :)

Kevin

Stephen McGuire21-Aug-06 11:27

21-Aug-06 11:27

Well that's comforting to know. That leads me to believe that there is not much new in .Net 2.0...

I'll take your advice and look at the online resources...when I get the chance!

Thanks for your input.

Steve

Dave Sexton21-Aug-06 1:01

Dave Sexton

21-Aug-06 1:01

Stephen McGuire wrote:
I have got an MCSD in .NET 1.1

Same here and I've also been flirting with .NET 2.0. I've been getting most of my info from MSDN.

Stephen McGuire21-Aug-06 11:37

21-Aug-06 11:37

That seems to be the common advice.

Have you found it to be that much different?

I have been talking to a few others about this and I am told that some features in 1.1 are now obsolete! I think the discussion was something about retrieving AppSettings from a config file. Seems there is a new ConfigurationManager...

I'll not ask too many questions since I have not done much research yet. I just wanted to jump the gun and see if anyone had any suggestions. Seems I can find all I need online.

Thanks for your input.

Steve

Dave Sexton21-Aug-06 20:44

Dave Sexton

21-Aug-06 20:44

There are a number of new features in .NET 2.0 (+400 say the ads), & I like most of those that I've come across. I've been playing around with 2.0 using the express editions. I haven't used it to build anything noteworthy just yet - I'm still just feeling it out.

tanya foster21-Aug-06 5:44

tanya foster

21-Aug-06 5:44

Steve,
Don't know if these recommendations are of use but I really liked Mastering Visual Basic .NET by Evangelos Petroutsos ISBN 0-7821-2877-7. Maybe this same author has a newer book which covers your needs. Also, when I wrote code in asp.net for 2005, I wish I had a book with the treeview class. You might be able to date a book on asp.net if it has a section on that book. The asp.net book I have is Mastering asp.net with vb.net by A. Russell Jones ISBN 0-7821-2875-0. Again, maybe this book/author has a later version to help your needs. Both books have screens shots, good code examples, and what I thought were good technical explanations.
Hope this helps
tanya

Stephen McGuire21-Aug-06 11:40

21-Aug-06 11:40

Thanks Tanya.
I'll keep those authors in mind.
I have sourced quite a few Microsoft books on the subject but I am loathed to try them from my past experience with Microsoft teaching materials.

Thanks for your input.

Steve

Kevin McFarlane22-Aug-06 22:40

Kevin McFarlane

22-Aug-06 22:40

This might be a useful starting-point too.
http://www.asp.net/QuickStart/aspnet/[^]

Kevin

Stephen McGuire24-Aug-06 8:42

move data from access db to sql 2005 using ado.net

24-Aug-06 8:42

Great! many thanks Kevin.

Steve

playout20-Aug-06 3:44

playout

20-Aug-06 3:44

Hi,

I need move data from a access database to a sql 2005 database, using ado.net and VB.net

Basically, the user will select which access database to move to sql 2005, choosing from a select box on a webpage. I use an FileUpload tag to let the user select the access database(MDB file), to convert to sql 2005 database.

At the moment I can get all the data from the access database into a dataset using OleDbConnection. I just dont know how to move this information in the dataset to the sql database, in one function.

Does anyone know if there is code out there that does this, of know where I can find info on this?

Really appreciate the help.
Thanks

Re: move data from access db to sql 2005 using ado.net

Guffa20-Aug-06 4:43

Re: move data from access db to sql 2005 using ado.net

20-Aug-06 4:43

Please don't cross post.

---
b { font-weight: normal; }

Stephen McGuire20-Aug-06 6:03

Re: move data from access db to sql 2005 using ado.net

20-Aug-06 6:03

Does the DB already exist in SQL Server?
If so, read your data into an ADO.NET DataSet and then write it to your SQL database.

If not, you will need to do the same as above but also use some TRANSACT SQL to build your database and tables in SQL Server.

I don't know of any publicly available (free) code that will do this for you. You will have to create it yourself. However, you may be able to purchase a pre-written utility that does this for you, don't know of one though...

Steve

playout20-Aug-06 21:51

playout

20-Aug-06 21:51

Thanks Steve,

Yes, the database is already in sql, just need to get the info from mdb, and export to sql.
I used the dataset method, and it seems to work very nicely. Just need to run a few tests and do some validation now.

Regards
Playout

xml upload [modified]

spelltwister19-Aug-06 21:27

spelltwister

19-Aug-06 21:27

Hey all,

Is there a way to upload an xml document to a script that can then use it as xml and parse it.

I created a php script that will take an xml file off the server, and parse it the way I want, however I do not want to write the file to the server first, I want it to just take the uploaded xml document and begin parsing it.

here's the current uploader that i was using for just string data:

visual basic code:--------------------------------------------------------------------------------
Public Function PostToWebUpdate(ByVal postData) As Boolean
Dim Client As WebClient
Try

Dim dataBytes As Byte() = Encoding.ASCII.GetBytes(postData)

Client = New WebClient
Client.Headers.Add("Content-Type", "application/x-www-form-urlencoded")
Dim returnedBytes As Byte() = Client.UploadData("http://www.1483online.com/sciptThatIwant", dataBytes)

Dim myResponse As String = New String(Encoding.ASCII.GetChars(returnedBytes))

Return myResponse = "SAVED"
Catch ex As Exception
MessageBox.Show("Error: PostToWeb: " & ex.Message)
Return False
Finally
Client.Dispose()
Client = Nothing
End Try
End Function--------------------------------------------------------------------------------

However, would this be a parsable xml file or some other thing that I have to convert to xml?

I'm thinking that I cannot use the above post code. I used to have to write a string like this:

game=12&turn=18&unit=Infantry........

Then, I pulled in the variables using php's $HTTP_POST_VARS['game'] (which would return 12). However, I do not know what the $HTTP_POST_VARS['thisvariablename'] would be. Any ideas?

Thanks,

Mike

Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!

Guffa19-Aug-06 22:16

19-Aug-06 22:16

As the data that you post doesn't follow the format that you specified (urlencoded), you can not read the request using $HTTP_POST_VARS['anything'].

You have to read the entire request stream as binary data. In ASP and ASP.NET this is done using the BinaryRead method, but how that is done in PHP I have no idea.

---
b { font-weight: normal; }

spelltwister20-Aug-06 17:38

spelltwister

20-Aug-06 17:38

is there a way to alter the format to make it readable by grabbing the post data? (what would that be ;-D)

Thanks

Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!

Guffa20-Aug-06 22:55

20-Aug-06 22:55

Then you would put the xml document as a posted value by url encoding it, so that the data that you post looks something like this:

doc=%3C%3Fxml+version%3D%221.0%22%3F%3E%0D%0A%3C...

---
b { font-weight: normal; }

spelltwister21-Aug-06 7:59

spelltwister

21-Aug-06 7:59

could you please give an example, I'm not following very well. :-/ The only thing that I saw for urlencoding was in an httputility but I couldn't use it for some reason (maybe referencing).

If I have this (a very basic xml file):

Dim XMLDoc As New XmlDocument
Dim xNodeList As XmlNodeList
Dim xNode As XmlNode

XMLDoc.LoadXml("<units>")

Dim info As XmlElement = XMLDoc.CreateElement("info")
info.SetAttribute("attacker", "greek")
XMLDoc.DocumentElement.AppendChild(info)

What do I do to the newly created XmlDocument to get it posted and encoded correctly?

Also, what is the referencing post name?

Thanks,

Mike

Gaming at the GuildofBlades.com is the only way to really experiece the level 99 Soul-Sucking Sword!

Guffa22-Aug-06 8:27