Few VB.NET questions/bugs
Author
Discussion

Z064life

Original Poster:

1,926 posts

279 months

Thursday 9th August 2007
quotequote all
I've made a database driven application using .NET technologies, such as VB.NET, ADO.NET, SQL, SQL Server, and MS Reporting Services. However, to improve my knowledge, I have the following questions:

1) When I debug my VB.NET application, and I have multiple windows open in an overcrowded taskbar, the application's windows will group together but says vshost.exe. How can I change this to display the application icon and name, which has been set in the form's properties and application properties?

2) Does anyone here have any experience with .NET email components, such as those made by Rebex and other companies? Is there a way to make my app send automated emails based on the results of a query join?

3) In some table attributes, such as title, which has just 4 values really (Mr, Ms, etc), how can I make a drop down box which is databound to these table attributes?

4) One bug I have in my app is that the about box has a wait cursor and I cannot change this in the properties. Anyon here had this problem?

5) How on earth can I insert an image into a Microsoft Report (.rdlc file). I've tried everything possible.

Any help much appreciated
Thanks

slapmatt

1,132 posts

253 months

Friday 10th August 2007
quotequote all
2) It depends what you are actually trying to acheive. You can send emails from within SQL Server, but I wouldn't recommend it, as you are likely to end up tying business logic into your database layer.

3) Create a table called PersonTitle, with PersonTitleID and PersonTitleName, PersonTitleName being Mr, Mrs, Miss, Sir etc. Create a list control of PersonTitles. Then against a Person hold a PersonTitleID, rather than the actual title.

sp60

524 posts

290 months

Friday 10th August 2007
quotequote all
1) When I debug my VB.NET application, and I have multiple windows open in an overcrowded taskbar, the application's windows will group together but says vshost.exe. How can I change this to display the application icon and name, which has been set in the form's properties and application properties?

Depends how you have your app set up, if it runs as an MDI application, it should pick the title from the main mdi parent form.

2) Does anyone here have any experience with .NET email components, such as those made by Rebex and other companies? Is there a way to make my app send automated emails based on the results of a query join?

Why do you need an add in component? Visual Studio and .net has plenty of support for sending out emails, this is simple to do as a result of a query join, using a loop of yoru choice!

3) In some table attributes, such as title, which has just 4 values really (Mr, Ms, etc), how can I make a drop down box which is databound to these table attributes?

use dataadapters to fill an appropriately constucted dataset, bind the dataset to the dropdown. This is all basic stuff, do you have any .net books to help you along? Maybe you should get some demo apps to look at, there are plenty available online that you should be able to find without too much hassle.

4) One bug I have in my app is that the about box has a wait cursor and I cannot change this in the properties. Anyon here had this problem?

Could be lots of things, unlikely that you will fix it with a property change.

5) How on earth can I insert an image into a Microsoft Report (.rdlc file). I've tried everything possible.

Not an expert on reports, but this has to be pretty simple.

Sorry if I sound a bit unhelpful, but most of your questions sound like you haven't sat down an learned the basics and are trying to run before you can walk. If you are in a rush and don't have the time to learn, search for an online demo app that is close to what you are trying to do and tweak it to suit your needs. If you are seriously starting out as a developer, buy a decent book, sit down and skim through the first few chapters. An couple of hours of research learning the basics will save you an awful lot of time in the long run.

Z064life

Original Poster:

1,926 posts

279 months

Friday 17th August 2007
quotequote all
Thanks for the advice guys. I've fixed most of the bugs I had now.

To the last poster - you don't sound unhelpful. I have plenty of books on .net and vb.net which I have read and am reading. The thing about books which I don't like is that they don't tell you everything so everything else you have to experiment with or learn on your own. Your advice was good.

sp60

524 posts

290 months

Friday 17th August 2007
quotequote all
Z064life said:
Thanks for the advice guys. I've fixed most of the bugs I had now.

To the last poster - you don't sound unhelpful. I have plenty of books on .net and vb.net which I have read and am reading. The thing about books which I don't like is that they don't tell you everything so everything else you have to experiment with or learn on your own. Your advice was good.
Good man, I was making excuses more for my blunt reply really, having a bad week at work! Persevere with your learning, there are loads of good examples of projects on the web, which is my preferred way of learning ways of coding problems. There seem to be a few good coders on here too, so keep posting up your problems as you never know, someone may have an answer smile