Visual Basic

Christian Graus13-Feb-07 12:32

13-Feb-07 12:32

Have you stored the date in your database ? If so, your SQL can filter it. If not, I doubt you can.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

7prince13-Feb-07 13:46

7prince

13-Feb-07 13:46

Hi,

Yes. dates are in the dataset in the table. I am looking for the SQl statement to do that.

thanks, Joseph

programmer

Christian Graus13-Feb-07 17:01

13-Feb-07 17:01

GetDate() will return todays date, use that in your SQL statement. DateAdd is the other function you need to get a date that's a certain distance from today, I believe.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Event programming vs Method call programming

nlarson1113-Feb-07 16:23

nlarson11

13-Feb-07 16:23

i think you can do this

col1 = is a date colum

select col1 from table
where col1 > getdate() - 30

Marcus J. Smith13-Feb-07 8:21

13-Feb-07 8:21

What is the difference in purpose/whatever between just creating a Method or Function and calling it when necessary and creating an Event and then raising an event? I just discovered this but cant think of a whole lot of reasons for me to use it.

Cleako

Christian Graus13-Feb-07 9:27

13-Feb-07 9:27

Well, these are not competing ideas. I would write some functions that I want to have run when I call them, right away. Other functions, I want to call when an event occurs, such as a button being pushed. Just writing code in your event handlers, makes for very messy code. Your UI classes would work this way, but they would mostly just create business objects, and call their methods, which are not going to be event driven.

For example, you may have a Person class. It may have properties to specify name, address, etc, and a method to save that person to the database. You wouldn't rewrite this code in every event handler, the class would handle it, and different event handles would call it.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Marcus J. Smith13-Feb-07 9:36

13-Feb-07 9:36

Well I am looking at some code here that uses RaiseEvent for a few things so I Googled it and found this - http://msdn.microsoft.com/msdnmag/issues/05/06/EventHandling/[^]. Now I understand the UI dealing with events such as a button click but I never thought say -

If intCount = 500 <br />
Then RaiseEvent SaveInformation(Datatable) <br />
End If

or whatever, because I would have said -

if intCount = 500 <br />
Then SaveInformation(Datatable) <br />
End If

.

Is this just a way to let another class handle what happens when this occurs?

If you look at that article it makes me feel like I dont know anything!

Cleako

Christian Graus13-Feb-07 9:56

13-Feb-07 9:56

The article says that RaiseEvent is something they kept from VB6. Which means, it's crap.

cleako wrote:
Is this just a way to let another class handle what happens when this occurs?

No, delegates are how you do that. Unless RaiseEvent is a way to call a delegate in VB ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Marcus J. Smith13-Feb-07 10:00

13-Feb-07 10:00

I love hearing people say VB6 is crap. Big Grin | :-D

Cleako

Christian Graus13-Feb-07 10:11

Generating an Excel spreadsheet from vb.net forms!

13-Feb-07 10:11

*grin* Happy to oblige

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

China-Gary13-Feb-07 7:58

China-Gary

13-Feb-07 7:58

Any help/guidance with this would be much appreciated!

Im working on developing a system that ultimately generates a timetable of events, much like an timetable for a track event, allocating people to lanes etc..

I need to be able to generate an Excel spreadsheet that is populated with the data that is held within my text boxes and labels in my forms, all Strings btw.

Is there a way that i can submit an event/race to the spreadsheet, go back and submit another race that will appear underneath the race already submitted, without overwriting what is already in the spreadsheet??

I would be very grateful for help here, and have explained it as i see the nature of the problem!

Thanks

Re: Generating an Excel spreadsheet from vb.net forms!

andyharman13-Feb-07 8:05

andyharman

13-Feb-07 8:05

Try http://support.microsoft.com/kb/316934[^]
It allows you to treat MS-Excel like a database table so that you can append new records.

Alternatively, if you create an HTML file then rename it to have a ".XLS" extension then Excel will treat it like any normal spreadsheet.

Re: Generating an Excel spreadsheet from vb.net forms!

China-Gary13-Feb-07 8:08

China-Gary

13-Feb-07 8:08

Thanks, ill try it out!

Appreciate the help! Smile | :)

Using a common DLL for connection information for generated data objects

Marcus J. Smith13-Feb-07 7:42

Re: Using a common DLL for connection information for generated data objects

13-Feb-07 7:42

Is it possible to to retrieve connection information from a centralized DLL without having to manually change the generated code for a DataSet item added to the project? If so, will you point me in the right direction?

Thanks!
Cleako

Navneet Hegde14-Feb-07 2:48

Navneet Hegde

14-Feb-07 2:48

Yes Absolutely , its Very Common Idea with Professionals , I would like to help you with the same. You are always welcome with your requirement.

Develop2Program & Program2Develop

Re: Using a common DLL for connection information for generated data objects

Marcus J. Smith14-Feb-07 3:00

Re: Using a common DLL for connection information for generated data objects

14-Feb-07 3:00

Where can I find some information on this?

Cleako

Navneet Hegde14-Feb-07 18:09

Navneet Hegde

14-Feb-07 18:09

You Better Read the Way DataSet and Adapter are handled From wrox Publication books And Create dll , its easy once you start and things(dll) get better with requirements of your

Develop2Program & Program2Develop

Finding the group a user is in

KreativeKai13-Feb-07 7:00

KreativeKai

13-Feb-07 7:00

I am using VS2005 and can find a users name by using the System.Environment.Username code. With this, I know there should be a way to find out what group this user is a member of.

My program will process one function if the user is a member of windows group named GROUP1 and if the user using my program is a member of GROUP2 it performs a different function.

How can I easily check if a specific user using the program is a member of GROUP1?

Any help is appreciated Confused | :confused:

Lost in the vast sea of .NET

Re: Finding the group a user is in [modified]

Marcus J. Smith13-Feb-07 7:43

13-Feb-07 7:43

Unless you are specifically wanting to view that group you can just check for If My.User.IsInRole("GROUP1") Then ... End If.

Cleako

KreativeKai13-Feb-07 8:05

KreativeKai

13-Feb-07 8:05

I am in .NET 2.0. I tried this code before posting the message and it returns false for a group that I know I belong to.

After you posted this reply, I tried the following using the domain:

Dim blntest As Boolean = My.User.IsInRole("MYDOMAIN\Programming")
If blntest = True Then
MsgBox("True")
Else
MsgBox("False")
End If

Am I missing something? Confused | :confused:

Lost in the vast sea of .NET

Marcus J. Smith13-Feb-07 8:45

13-Feb-07 8:45

Is this for a Windows app or a Web app?

Cleako

KreativeKai13-Feb-07 8:49

KreativeKai

13-Feb-07 8:49

It's a Windows App. I've been researching into the Isinrole syntax and this is related to roles like administrator, power user, etc.

I'm looking for code that can find a group that the network administrator sets up to organize people by.

For example, "Programmers", "PayrollUser", "AppABCUser", etc....
There should be some way to look up this info?

Lost in the vast sea of .NET

Marcus J. Smith13-Feb-07 8:54