How many records afected by this code - Visual Basic Discussion Boards

First Prev Next

Re: text file

Christian Graus8-Dec-07 9:21

Christian Graus

8-Dec-07 9:21

bapu2889 wrote:
DataWriter.WriteLine(Title + FName + MName + SName + Age)

This leaves you with one line, and no way to tell which bit is which. Write a line for each item of data, then you can read them a line at a time and know what each part of the data is.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

MPEG encryption

zeeshi_247-Dec-07 23:31

zeeshi_24

7-Dec-07 23:31

which symmetric algothrim is efficient to encrypt the MPEG file in dotnet envirnment and through which technique reduce MPEG file in dotnet. plz mention specific algothrim and technique for MPEG file.

Re: MPEG encryption

Christian Graus7-Dec-07 23:46

Christian Graus

7-Dec-07 23:46

DotNet is irrelevant, obviously. How do you want to encrypt it, so no-one can play it ?

MPEG is a known format, unless you lower image quality, I don't see how you can make files smaller. It's not like AVI, where AVI itself is uncompressed and the file extension is used by a ton of different codecs that all compress differently

About TabPane

Meenge7-Dec-07 23:02

Meenge

7-Dec-07 23:02

please tell me about tabpane and controlling tabpane

Thanks a lot for your reply message,
Wink | ;)

Re: About TabPane

pmarfleet7-Dec-07 23:43

pmarfleet

7-Dec-07 23:43

Tell you what? This forum is for specific programming questions.

If you want to learn how these controls work, try reading the documentation.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: About TabPane

Paul Conrad9-Dec-07 8:57

Paul Conrad

9-Dec-07 8:57

Meenge wrote:
please tell me about tabpane and controlling tabpane

What do you want to know about it? You need to be more specific.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: About TabPane

John_Adams9-Dec-07 23:46

John_Adams

9-Dec-07 23:46

Hi,

Are you talking about VisualStyleElement.Tab.Pane Class?

If yes then please note that this class provides a VisualStyleElement for the border of a tab control page. This class cannot be inherited.

For further details on this issue you may visit the following link:
http://msdn2.microsoft.com/en-us/library/system.windows.forms.visualstyles.visualstyleelement.tab.pane(VS.90).aspx[^]

I hope this helps.

Regards,
John Adams
ComponentOne LLC

How many records afected by this code

Vimalsoft(Pty) Ltd7-Dec-07 22:45

Vimalsoft(Pty) Ltd

7-Dec-07 22:45

hi all

i have a Procedure that return a row affected. its like this

Create Proc CheckExistance(@username varchar(50))
as
Select @@Rowcount from Login where Username = @username

And on my vb code its like this

Answer = cmd.ExecuteNonQuery()

PLease note that Answer is an integer variable, that i want to assign the value returned by a stored Procedure.

Forgive me about formatting issues, i have a problem with code project lately, buttons don't appear nicely, i cant even use pre, because it takes me to another page.

thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: How many records afected by this code

pmarfleet7-Dec-07 23:40

pmarfleet

7-Dec-07 23:40

Vuyiswa wrote:
Select @@Rowcount from Login where Username = @username

This doesn't look right. Getting the rowcount from a query in T-SQL requires a separate query.

IMHO, the most efficient way to check for the existence of a record is to use the EXISTS keyword. This is because SQL Server will stop searching as soon as it finds the first match. For instance:

IF EXISTS (SELECT TOP 1 * FROM Login WHERE Username = @username)
  RETURN 1
ELSE
  RETURN 0
END

BTW, not sure what problem you are having with <pre> tags. They're working OK for me.

Hope this helps.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: How many records afected by this code

Vimalsoft(Pty) Ltd8-Dec-07 1:25

Vimalsoft(Pty) Ltd

8-Dec-07 1:25

hi Paul

thanks for the reply, think you gave me what i needed thanks.
i think it was my connection and my browser, that wanted to move away from the page when i tried to Click "

" tag, next time i will type it , i was too lazy am sorry. 

Thanks for the help

Error handling in TAPI3.0 by vb.net

Sumit Prakash Sharma7-Dec-07 19:56

Sumit Prakash Sharma

7-Dec-07 19:56

hi friends
Currently i m working on msTAPI3.0 in vb.net. I want to call 3 customer so i user for loop. When loop play for first time the message sent successfully but second time an error occur error is:
------------------------------------------------------------------------
Uninitialized object (Exception from HRESULT: 0x80040007 (OLE_E_BLANK))
------------------------------------------------------------------------

How can i sort out this error. Plz solve my problem.
Thanks in advance

Re: Error handling in TAPI3.0 by vb.net

Dave Kreskowiak8-Dec-07 4:18

Dave Kreskowiak

8-Dec-07 4:18

You need to the post a code snippet of what is throwing this error. Without seeing it, anyone who gives you an answer is just guessing at the problem.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Error handling in TAPI3.0 by vb.net

Paul Conrad9-Dec-07 9:00

Paul Conrad

9-Dec-07 9:00

He must be expecting someone to know the error code right off the top of their head? Unsure | :~

I just take the whole error code and put it in a google search.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: Error handling in TAPI3.0 by vb.net

Paul Conrad9-Dec-07 8:58

Paul Conrad

9-Dec-07 8:58

Like Dave said, you need to post the code snippet where you are having trouble. No one can really help without seeing it.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

fra tab

Meenge7-Dec-07 18:13

Meenge

7-Dec-07 18:13

my fra tab is designed for
activetablabelbackcolor is Teal &
inactivetablabelbackcolor is Gray.
let my fra tabs be two fra tabs.
firstly,fratab_1 is active and this backcolor is Teal
and fratab_2 is inactive,then i changed to fratab_2 ,
but fratab_1 is not completely inactive,a little active
Teal color is still at top of the tab_1 ,and fratab_2
is not completely active ,a little inactive Gray color
is include at top of the tab_2

Re: fra tab

Ray Cassick7-Dec-07 20:16

Ray Cassick

7-Dec-07 20:16

My Blog[^]
FFRF[^]

Re: fra tab

Meenge7-Dec-07 23:19

Meenge

7-Dec-07 23:19

thanks a lot for ur answer

Re: fra tab

Christian Graus7-Dec-07 23:46

Christian Graus

7-Dec-07 23:46

Mate, if that is a question, it certainly makes no sense to me.

Re: fra tab

Ray Cassick8-Dec-07 7:01

Ray Cassick

8-Dec-07 7:01

I thought the reply was pretty clear but I guess not so here goes.

Please restate your question.

If no one can understand it, no one can answer you.

My Blog[^]
FFRF[^]

Finding Available DB2 Servers

Bob Bonser7-Dec-07 14:25

Bob Bonser

7-Dec-07 14:25

I am trying to build my own SQL Query Analyzer to use with our DB2 servers.

I want to have a drop down list fill with all the available DB2 servers on the network.

Does anyone know how I can accomplish this. I figured out how to listen for SQL Servers but not DB2 servers.

Any help would be appreciated.

adding multiple textboxes at runtime

craigmg787-Dec-07 10:32

craigmg78

7-Dec-07 10:32

I have found alot online about how to add a control at runtime. Unfortunately, I haven't yet found anything that explains how to add multiple controls at once from one event.

I will post what I tried to use to add three textboxes. When I run it, only the third textbox is visible and I'm not entirely sure if the first two were created. (I'm thinking that they were created but replaced by the latest new textbox.) Anyway below is my code. Thanks to anyone who can see what I am doing wrong here:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim NewTB As New TextBox
        Dim TBName As String
        Dim TBindex As Integer = 1

        For TBindex = 1 To 3
           
            TBName = "Textbox" & TBindex
            Me.Controls.Add(NewTB)
            NewTB.Name = TBName
            NewTB.Enabled = True
            NewTB.Visible = True
            NewTB.Height = 20
            NewTB.Width = 100
            NewTB.Top = 130 + ((TBindex - 1) * 25)
            NewTB.Left = 20

        Next TBindex

End Sub

"That rug really tied the room together."

Re: adding multiple textboxes at runtime

Christian Graus7-Dec-07 10:51

Christian Graus

7-Dec-07 10:51

You need to do your first line inside the loop. You created one textbox and added it three times. You need to create a new textbox to add every time.

Re: adding multiple textboxes at runtime

craigmg787-Dec-07 10:57

craigmg78

7-Dec-07 10:57

Thanks very much, Christian. That did the trick!

"That rug really tied the room together."

Re: adding multiple textboxes at runtime

nlarson117-Dec-07 10:52

nlarson11

7-Dec-07 10:52

each textbox has to have it's own instance

Dim NewTB As TextBox
Dim TBName As String
Dim TBindex As Integer = 1

For TBindex = 1 To 3
NewTB = New TextBox 'this belongs here

TBName = "Textbox" & TBindex
NewTB.Name = TBName

Me.Controls.Add(NewTB)
NewTB.Enabled = True
NewTB.Visible = True
NewTB.Height = 20
NewTB.Width = 100
NewTB.Top = 130 + ((TBindex - 1) * 25)
NewTB.Left = 20

NewTB = Nothing
Next TBindex

What is the best way to write the same VBA code for multiple Excel workbooks? [modified]

redjoy7-Dec-07 9:19

redjoy

7-Dec-07 9:19

Problem:
Currently I have 12 Excel workbooks (each with 7 worksheets).
The data is identical in nature. The common part is the VBA code.
Every time I have to make a change to one of the worksheet's VBA code,
I need to copy the changes to the other workbooks.

I can use either the Excel buit-in VB editor, or any flavor of Visual
Studio.

I would like to be able to make the modification only once and have
the workbooks reference the code instead of copying and pasting to
each workbook.

Question(s):
1. Is there a way that I can have one central location for the VBA code?
2. Would an Excel add-in be appropriate?
3. Should I program using VS (VSTO)?

I am open to any approach to this problem.

Michael
If we knew what it was we were doing, it would not be called research, would it? --Albert Einstein

modified on Friday, December 07, 2007 3:25:20 PM

Last Visit: 31-Dec-99 18:00 Last Update: 21-Jun-24 2:52

Refresh

ᐊ Prev 1...1957 1958 1959 196019611962 1963 1964 1965 1966 Next ᐅ

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