Visual Basic

6-Sep-05 11:07

What is wrong with this code?

<br />
Structure PP<br />
<br />
    Public Name As String<br />
    Public Archive As Boolean<br />
<br />
End Structure<br />
<br />
Public Sub Inst()<br />
<br />
        Dim AddPP As New PP<br />
        With AddPP<br />
            .Name = txtPPName.Text<br />
            .Archive = True<br />
        End With<br />
<br />
        cmd = "INSERT INTO Pub_Points (PPName,Archive) VALUES ('" + AddPP.Name + "'," + AddPP.Archive + ")"<br />
<br />
End Sub<br />

It chokes with 'System.FormatException: Input string was not in a correct format.'

This is my current kluge:

cmd = "INSERT INTO Pub_Points (PPName,Archive) VALUES ('" + AddPP.Name + "'," " + CInt(AddPP.Archive).ToString + ")"<br />

But what is the point in defining a property as boolean if I have to convert it back to string to use it?

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

-- modified at 17:20 Tuesday 6th September, 2005

Re: boolean in SQL

Christian Graus6-Sep-05 11:39

6-Sep-05 11:39

DaveC426913 wrote:
But what is the point in defining a property as boolean if I have to convert it back to string to use it?

You do have to convert it into a string, it's a string because it's part of cmd, which is a string. VB is doing this for you implicitly in the first instance. What does cmd look like in the debugger in the first instance ? What's the type of the Archive column in the database ? If you go into Query Analyser, what changes do you need to make to the string in cmd in the first instance, for it to work ?

Christian Graus - Microsoft MVP - C++

Re: boolean in SQL

DaveC4269137-Sep-05 3:11

7-Sep-05 3:11

"You do have to convert it into a string, it's a string because it's part of cmd, which is a string."

Did you mean *I do* or *I do not* have to?

"What does cmd look like in the debugger in the first instance ?"

It doesn't. It chokes trying to parse that line of code. This isn't a db problem, it's a VB problem.

"What's the type of the Archive column in the database ?"

Sorry, it is bit.

"If you go into Query Analyser, what changes do you need to make to the string in cmd in the first instance, for it to work?"

Well, I have to change T/F to 1/0, which is what I'm doing.

Which brings me back to my question: why am I bothering to Dimension it as boolean?

A thought: Should my structure have a get/set that automatically converts between T/F and 0/1?

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

-- modified at 9:13 Wednesday 7th September, 2005

Re: boolean in SQL

Christian Graus7-Sep-05 12:39

7-Sep-05 12:39

DaveC426913 wrote:
Did you mean *I do* or *I do not* have to?

You *do*. the variable cmd is a string. Therefore, you have to turn whatever you pass through into a string, to make it part of the string command.

DaveC426913 wrote:
It doesn't. It chokes trying to parse that line of code. This isn't a db problem, it's a VB problem.

OK, in that case, VB isn't magically turning your boolean into a string, call it's .ToString method to get what you need.

DaveC426913 wrote:
Well, I have to change T/F to 1/0, which is what I'm doing.

Query Analyzer needs a 1 or 0, not true or false ? In that case, does VB support ? : notation ? As in myBool ? 1 : 0, returns 1 if myBool is true, otherwise returns false ?

DaveC426913 wrote:
A thought: Should my structure have a get/set that automatically converts between T/F and 0/1?

I'd try to do it inline. Or, if you used stored procedures, you can pass them a bool as a parameter, and the SP will turn it into what is needed. That's what I do, which is why I wasn't sure if SQL Server accepts true/false as bit values.

Christian Graus - Microsoft MVP - C++

script attacks

phamus6-Sep-05 8:49

phamus

6-Sep-05 8:49

Is there a function in .NET web stuff that will test a string for script attacks. For example, it tests for javascript code and html in the string the user entered in a first name blank

Thanks,
Tom

Re: script attacks

Dave Kreskowiak6-Sep-05 8:58

6-Sep-05 8:58

No there isn't. Also, if a user types that kind of code into a textbox and you directly use that value in your code, there's no way that the contents of that TextBox can be executed. So it's a moot point to begin with.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: script attacks

phamus6-Sep-05 9:01

phamus

6-Sep-05 9:01

Thanks you for the information - I thought there was but I must have been wrong

Re: script attacks

Dave Kreskowiak6-Sep-05 10:09

Hard question about Mailing in Vb.NET

6-Sep-05 10:09

There are Validation controls, but they don't check for any attacks.

What you may be thinking of is the SqlParameter and OledbParameter objects that do SQL Injection attack checking before they pass any data to an SQL Stored Procedure.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

korso_rogan6-Sep-05 8:49

korso_rogan

6-Sep-05 8:49

Well, maybe is not as hard as I think, but I was wondering if it was possible to call mozilla mail from VB.NET to create a new message with an attachment...

Thanks a lot for reading Wink | ;)

Drawing Over Video ( C# or VB.Net )

Alejandro K.6-Sep-05 6:58

Alejandro K.

6-Sep-05 6:58

Hi Guys,

I Really Really need help, i got this big project at work that is creating an application for video analisys in sports, so the thing is that i need draw over video while this is running, i got to be able to free draw or draw shapes into it, i been able to do the draw part with no problem, but i'm having a really hard time doing the overlay over the video, i had it working, but it flicks too much , and also flicks when drawing another object, anyways the question is , does anyone have links to something that can help me?? i been looking trough forums, websites, etc. and find msgs but not solutions.

Thanks.
Alex.

Re: Drawing Over Video ( C# or VB.Net )

Christian Graus6-Sep-05 11:45

Repeater or DataList minimum

6-Sep-05 11:45

How are you playing the video ? I believe if you use DirectShow, you can impliment filters, which could concievably use the DX framework to draw over the video.

Here[^] is a C++ article - you're calling COM objects, so the end result is the same ( that is, it's not hard to port ). However, Direct Show is VERY limited in the managed DX version, and very buggy. You should use COM interop to call the full DirectShow and avoid the crap they put into Managed DX.

Christian Graus - Microsoft MVP - C++

DaveC4269136-Sep-05 5:38

6-Sep-05 5:38

What are the minimum properties to set and code required to get a repeater or datalist ('lookless' controls) to show up? I follow the examples in the book as best I can, considering I'm using a different database, but they still show up invisible.

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

pulling hair out

DaveC4269136-Sep-05 5:33

6-Sep-05 5:33

I think I am going nuts over this .NET thing.

As far as I can tell, the MSDN documentation is just wrong. There is no such thing as a listbox.refresh method, nor is there such a thing as a listbox.multicolumns property, as just two examples. The docs say there is, but VS.NET gives me a compile error.

I have this wretched,sinking feeling that my confusion lies in the difference between ASP.NET programming and Visual Basic.NET programming.

Is it possible that listobx behaves two completely different ways in each? Is it possible that MSDN doesn't bother to clarify the language context of its instructions? Is it possible that not being able to filter results for one vs. the other (VB.NET vs. ASP.NET) in searches is an awful idea?

I am very frustrated.

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Dave Kreskowiak6-Sep-05 7:27

6-Sep-05 7:27

DaveC426913 wrote:
Is it possible that listobx behaves two completely different ways in each

Yes, they do behave differently. The Windows.Forms version supports a .Refresh() method, where the WebForms version doesn't. The .Refresh method just redrwas the control and it's contents in Windows Form. This can't be done on a browser version. The browser version is just a wrapper for an INPUT tag in HTML.

ListBox[^] control in ASP.NET, or WebForms.
ListBox[^] control in Windows Forms.

If you scroll up the navigation pane on the left, you'll see which namespace these controls are under. System.Windows.Forms contains all the standard Windows Forms controls, while all the standard ASP.NET, or WebForms, controls are under System.Web.UI.WebControls.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DaveC4269136-Sep-05 11:00

6-Sep-05 11:00

Arg. OK, I'm giving up on all the OledbConnect and SQLConnect examples, and sticking with ADO.

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Dave Kreskowiak6-Sep-05 13:35

6-Sep-05 13:35

OleDbConnect and SqlConnect aren't part of the .NET Base Class Library or ADO.NET. Where did these come from?

And, they don't have anything to do with your original post, so I'm afraid I'm lost.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DaveC4269137-Sep-05 3:04

7-Sep-05 3:04

"OleDbConnect and SqlConnect aren't part of the .NET Base Class Library or ADO.NET. Where did these come from?"

They are controls available to me it VS.NET when I am designing ASP.NET or VB.NET apps, and used in the tutorials and samples I'm reading in these ASP.NET and VB.NET books and at MSDN.

I'm sure if I read the books and MSDN website page by page, it will explain the difference. I guess I can't just presume that prior VB and ASP knowledge would have saved me from this confusion.

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Dave Kreskowiak7-Sep-05 3:32

7-Sep-05 3:32

OleDbConnection and SqlConnection are objects, but not OleDbConnect or SqlConnect.

I never use the database controls in the ToolBox. I always code my database stuff by hand. It gives greater control and you don't have to worry about code being generated that you can't see without going into the "Windows Form Designed generated code" region. Do it by hand and everything is in one place.

ADO.NET is strickley for database access. ASP.NET is a server-side HTML generation technology.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DaveC4269137-Sep-05 6:04

7-Sep-05 6:04

Forgive me if this is turning into a .NET tutorial, but it is very helpful to me...

So, does that mean all your code is on the .ASP page, not in the codebehind page? Is there *anything* on the codebehind page?

I confess I am confused about the relationship between the ASP page and the codebehind page in terms of what exists on each. I tried mapping one to the other, but some parts are there and some aren't. Is it possible to code ASP.NET pages without any need for a codebehind page?

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Dave Kreskowiak7-Sep-05 9:36

7-Sep-05 9:36

Everything VB.NET is in the codebehind file. Everything HTML is in the .apsx file.

The VB.NET code controls what happens when you use the controls on the HTML page. It's very similar to what's going on in Windows Forms. You see the Designer that lets you place the controls on a form and the "codebehind" that lets you attach code to the control's events, like "click".

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DaveC4269137-Sep-05 9:56

7-Sep-05 9:56

I see Visual Basic code in aspx pages in the examples. Is this not generated from the code window?

Also, when I write Visual Basic in the code window, it creates HTML/ASP/VB in the HTML page.

Are you saying that if I write everything in the HTML page, there will be nothing (or at least, nothing of consequence) in the codebehind file?

I guess I should try this so I understand it better, it just seems like I'm throwing away many of the features of Visual Studio.

Is it possible that the relationship between Visual Studio and html pages is equivalent to something like FrontPage and html pages? i.e. Frontpage is easier for designers, but it blows as far as writing clean code. I never use WYSYWIG HTML editors - I always use Homesite (which doesn't mangle code).

________________________________________________________________________
Dave
Y10K bug! Let's not get caught with our pants down **AGAIN**! (DC 02002)

Christian Graus6-Sep-05 11:42

Does not equal string????

6-Sep-05 11:42

DaveC426913 wrote:
Is it possible that MSDN doesn't bother to clarify the language context of its instructions?

No, it tells you at the top, when it tells you the namespace of the control you're reading about.

Christian Graus - Microsoft MVP - C++

daviiie6-Sep-05 5:29

daviiie

6-Sep-05 5:29

I am trying to search through a dataset using a

while League.Tables(0).Columns(0).Table.Rows(count2).Item(0) <> Winner
end while

Winner is a string, as is whatever may be contained in the datatable. So how do I get it to execute the while loop until the text in the table "Does not equal" the text in the Winner string?

Re: Does not equal string????

Dave Kreskowiak6-Sep-05 7:04