Re: update data? - Visual Basic Discussion Boards

Luc Pattyn22-Dec-09 2:42

22-Dec-09 2:42

File.Copy is the simple way. Copying bytes, not characters (hence using a byte array), is the alternative.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Writing the content of a text file

#realJSOP22-Dec-09 4:09

#realJSOP

22-Dec-09 4:09

Is the text in memory, or is it still in the original file?

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Re: Writing the content of a text file

hvgyufg28fh38tyr78hf22-Dec-09 5:23

hvgyufg28fh38tyr78hf

22-Dec-09 5:23

text is not in memory ..its in original text file only.

Re: Writing the content of a text file

#realJSOP22-Dec-09 8:27

#realJSOP

22-Dec-09 8:27

Then do what everyone else said, and just use File.Copy

Re: Writing the content of a text file [modified]

plecco22-Dec-09 8:41

plecco

22-Dec-09 8:41

I agree. I think File.Copy would be your best solutions if you want your text file to be exactly the same as the original.

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

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

update data?

cotdot1111122-Dec-09 1:33

cotdot11111

22-Dec-09 1:33

i have 2 following solution

the first

sqlcommand1.commandText = "insert into customers values('firstName','lastName','phone')
SqlCommand1.ExecuteNonQuery()

the second

'fill into datagridview
 SqlCommand1.CommandText = "select * from customers "
            SqlDataAdapter1.SelectCommand = SqlCommand1
            SqlDataAdapter1.Fill(DataSet1, "customers")
            DataGridView1.DataSource = DataSet1
            DataGridView1.DataMember = "customers"

'add new row into datatable
row = DataSet1.Tables("customers").NewRow()
        row.Item(0) = "firstName"
        row.Item(1) = "lastName"
        row.Item(2) = "phone"
        DataSet1.Tables("customers").Rows.Add(row)

'update data
SqlCommandBuilder1 = New SqlCommandBuilder(SqlDataAdapter1)
                   SqlCommand1.CommandText = "select * from customers "
                    SqlDataAdapter1.InsertCommand = SqlCommandBuilder1.GetInsertCommand
                    SqlDataAdapter1.Update(DataSet1, "customers")

Can you tell me what 's difference between those ?
And which is solution with higher performance D'Oh! | :doh:

Thank you very much!!

Re: update data?

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

Vimalsoft(Pty) Ltd

22-Dec-09 2:30

These two are doing different things, You cant Compare them. I suggest you buy a Book

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/

Re: update data?

The Man from U.N.C.L.E.22-Dec-09 7:06

The Man from U.N.C.L.E.

22-Dec-09 7:06

I see a lot of this.

Clearly the first is better etc. Why bother filling a dataset in order to perform an insert? The second option will produce the same SQL at the end of the day, but at high cost in processing to generating something you can type yourself in seconds.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

Re: update data? [modified]

plecco22-Dec-09 8:44

plecco

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:

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

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