Editing a database in vb6 - Visual Basic Discussion Boards

plecco22-Dec-09 8:44

22-Dec-09 8:44

The first one is a little better than the second b/c your using a bit more processing power on your app server to create the dataset you have on the second. In the first, most of the processing will be performed on the database server which is optimized for doing such computations.

Plecco Technologies, Inc.
Web Design | Software Development | Internet Marketing

modified on Wednesday, January 27, 2010 10:01 AM

How to fetch cell value in MsFlex Grid in vb6.0? URGENT

Ashish Kumar Vyas21-Dec-09 23:01

Ashish Kumar Vyas

21-Dec-09 23:01

Dear All,
Could any body give me the line code for the given query.
1. If I am clicking mouse button on Row 1 column 3
then it will show in Msgbox "selected Column 3"
2. If I am clicking mouse button on Row 1 column 4
then it will show in Msgbox "selected Column 4"
.........so on.

Thanks
Ashish

Re: How to fetch cell value in MsFlex Grid in vb6.0? URGENT

Eddy Vluggen21-Dec-09 23:22

Eddy Vluggen

21-Dec-09 23:22

VB.NET

Private Sub MSFlexGrid1_Click()
  
    MsgBox CStr(MSFlexGrid1.Colsel)

End Sub

I are Troll Suspicious | :suss:

Re: How to fetch cell value in MsFlex Grid in vb6.0? URGENT

Ashish Kumar Vyas21-Dec-09 23:25

Ashish Kumar Vyas

21-Dec-09 23:25

Hi,
The below code return 0 ,Even I click on 1,2.3 ...soon column

Private Sub MSFlexGrid1_Click()      
MsgBox CStr(MSFlexGrid1.Colsel)
End Sub

Thanks
Ashish

Re: How to fetch cell value in MsFlex Grid in vb6.0? URGENT

Eddy Vluggen22-Dec-09 0:15

Eddy Vluggen

22-Dec-09 0:15

Ashish Kumar Vyas wrote:
The below code return 0 ,Even I click on 1,2.3 ...soon column

Ah, the selection isn't there yet when you click it, so one would have to check what column the mouse is on;

VB.NET

Private Sub MSFlexGrid1_Click()      
    MsgBox CStr(MSFlexGrid1.mousecol)
End Sub

That should fix it Smile | :)

I are Troll Suspicious | :suss:

How to set master volume control in windows vista or seven with VB6 code?

Member 313203821-Dec-09 19:21

Member 3132038

21-Dec-09 19:21

I Have made a program to set the master volume in XP, but with Vista and Seven this don't work. How to fix this with VB6? THanks!

Re: How to set master volume control in windows vista or seven with VB6 code?

Dave Kreskowiak22-Dec-09 3:47

Dave Kreskowiak

22-Dec-09 3:47

You're going to have to do some more research on this, but here[^] is a start.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Editing a database in vb6

offroaderdan21-Dec-09 5:21

offroaderdan

21-Dec-09 5:21

Experts i need your help!

I have a database with a search option when a record is selected i want the option for them to sign that record off (checkbox type thing) however at the moment the database seems to be ONLY READ only???
How can i make it so i can initially add bits and pieces to the record or if worse come to worse delete that record?

Many thanks

Dan

Re: Editing a database in vb6

EliottA21-Dec-09 5:22

EliottA

21-Dec-09 5:22

Make the database not "read-only"

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Editing a database in vb6

Stryder_121-Dec-09 5:53

Stryder_1

21-Dec-09 5:53

What type of database? SQL Server, MySql, Access, etc...

Re: Editing a database in vb6

offroaderdan21-Dec-09 6:13

offroaderdan

21-Dec-09 6:13

i managed to figure it out near enough, thanks any way Smile | :)

Re: Editing a database in vb6

Vimalsoft(Pty) Ltd22-Dec-09 2:31

Vimalsoft(Pty) Ltd

22-Dec-09 2:31

Dan Why VB6 D'Oh! | :doh:

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Music Sharing On LAN

Euphoric_me21-Dec-09 5:11

Euphoric_me

21-Dec-09 5:11

Hello all...

i am trying to develop a project in VB.Net as front end and MySQL or SQL server as back end.
The application is called online music sharing application which is supposed to work on LAN
All i need is that on the request of client or the keyword he types( which can be the name of singer, album or song name) is then searched in the database located at the server and so the list of files matching with the keyword is listed at the client side application.
Later the client can download any of the files among the list and listen to it
..

Here i would also admit that i have worked on VB but never on VB.Net and have no idea of, how the downloading feature and searching will be implemented.
I need to submit this project in say a week or 10 days(fully extended period and i cant take more time...)

i request if there is any help i can get as soon as possible.......
Sigh | :sigh:

Thankyou...

Re: Music Sharing On LAN

EliottA21-Dec-09 5:22

EliottA

21-Dec-09 5:22

Euphoric_me wrote:
I need to submit this project in say a week or 10 days(fully extended period and i cant take more time...)

Why would you take a project that you have no experience in, and then rely on us to (probably) complete the entire thing for you if you don't understand simple concepts like executing a search? on a DATABASE no less? I'd go back and seriously explain to the client your technical constraints and have him choose another candidate.

If this is for school, you're SOL. Maybe business school next time? I hear you can coast through that...

[Edit] What kind of help did you think you where going to get exactly?

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Music Sharing On LAN

Stryder_121-Dec-09 5:49

Stryder_1

21-Dec-09 5:49

Do you have the database structure?

If so, does the database already contain data?

Have you worked with DB queries in your VB development?

Re: Music Sharing On LAN

Mycroft Holmes22-Dec-09 0:02

Mycroft Holmes

22-Dec-09 0:02

Note the type and quality of the other questions answered here, not one will be a can you build this app for me. The people who get a positive response are people who are trying and learning to program.

You should try business school as suggested, or possibly sales, you are obviously incapable of becoming a programmer.

Never underestimate the power of human stupidity
RAH

Re: Music Sharing On LAN

Ashfield22-Dec-09 0:24

Ashfield

22-Dec-09 0:24

Is it even legal to share music across a LAN? What about copyright?

Mind you, you are obviously incapable of developing such a system, so it may not matter

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Raise Event when windows-startmenu is showing up

wdennis21-Dec-09 0:04

wdennis

21-Dec-09 0:04

Hey Guys,

is it possible to raise a custom event after I pressed left/right windows-key and the startmenu is opening up? I want to start a procedure of my application when startmenu is showing up and end the procedure when startmenu is closing.

Regards

Re: Raise Event when windows-startmenu is showing up

Dave Kreskowiak21-Dec-09 4:48

Dave Kreskowiak

21-Dec-09 4:48

There is no event for the Start menu popping up. I don't know how you're going to detect that.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Connecting A Dotnet Application to OpenBase(opensource Database) Database

sivaraman_sankaranarayanan20-Dec-09 7:15

sivaraman_sankaranarayanan

20-Dec-09 7:15

How to connect to the Openbase database ? Please Help Me regarding this ?

Re: Connecting A Dotnet Application to OpenBase(opensource Database) Database

EliottA20-Dec-09 16:20

EliottA

20-Dec-09 16:20

Connectionstrings[^] - if it isn't here, then good luck.

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: Connecting A Dotnet Application to OpenBase(opensource Database) Database

Rod Kemp20-Dec-09 17:10

Rod Kemp

20-Dec-09 17:10

Try the following links.

OpenBase Sql Connectivity APIs[^]

Actual Technologies OpenBase ODBC Driver[^] (Not Free)

Insert vs Undo

Pasan14820-Dec-09 7:02

Pasan148

20-Dec-09 7:02

When we use Insert method of a text box for insert text, why can't we use Undo method of same text box. When using Insert method, is there any other way to use Undo method.

Re: Insert vs Undo

Mycroft Holmes22-Dec-09 0:10

Mycroft Holmes

22-Dec-09 0:10

You still struggling with this one?

When you say insert method presumably you are executing a method to insert the data into the database. If you want to undo that insert it is called a delete. The data has been written to the database, unless you write code in the undo event to delete the record then how do you expect to achieve this.

Never having used the undo method I am guessing here but I would assume the undo method implements a short term cache in the local memory with the ability to step through a list of changes, restoring each subsequent change to the text property of the control. Nothing to do with insert!

Never underestimate the power of human stupidity
RAH

DateTime Problem?

cotdot1111120-Dec-09 5:48

cotdot11111

20-Dec-09 5:48

I use DateTimePicker in VB.net

But i'm form ASIAN. So I want to use DateTimePicker in day/month/year format.
What should i do?

Thank you very much

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.