Visual Basic

FirstPrevNext

Re: boolean in SQL DaveC4269137-Sep-05 3:11 DaveC426913 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 Christian Graus 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 Dave Kreskowiak 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 Dave Kreskowiak 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 Hard question about Mailing in Vb.NET 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 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 Christian Graus 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++ Repeater or DataList minimum DaveC4269136-Sep-05 5:38 DaveC426913 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 DaveC426913 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) Re: pulling hair out Dave Kreskowiak6-Sep-05 7:27 Dave Kreskowiak 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 Re: pulling hair out DaveC4269136-Sep-05 11:00 DaveC426913 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) Re: pulling hair out Dave Kreskowiak6-Sep-05 13:35 Dave Kreskowiak 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 Re: pulling hair out DaveC4269137-Sep-05 3:04 DaveC426913 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) Re: pulling hair out Dave Kreskowiak7-Sep-05 3:32 Dave Kreskowiak 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 Re: pulling hair out DaveC4269137-Sep-05 6:04 DaveC426913 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) Re: pulling hair out Dave Kreskowiak7-Sep-05 9:36 Dave Kreskowiak 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 Re: pulling hair out DaveC4269137-Sep-05 9:56 DaveC426913 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) Re: pulling hair out Christian Graus6-Sep-05 11:42 Christian Graus 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++ Does not equal string???? 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 Dave Kreskowiak 6-Sep-05 7:04  daviiie wrote: while League.Tables(0).Columns(0).Table.Rows(count2).Item(0) <> Winner end while Are you incrementing count2 in that While loop? Do While League.Tables(0).Columns(0).Table.Rows(count2).Item(0) <> Winner . . count2 = count2 + 1 Loop RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Does not equal string???? Roy Heil6-Sep-05 8:32 Roy Heil 6-Sep-05 8:32  daviiie wrote: 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? If you want to execute UNTIL Winned DOES NOT equal the text, you want to execute WHILE it DOES equal the text. So... while League.Tables(0).Columns(0).Table.Rows(count2).Item(0) = Winner Roy. Error Mesage being thrown macca246-Sep-05 4:47 macca24 6-Sep-05 4:47  I keep getting the following error message in my vb.net code: "Format of the initialization string does not conform to specification starting at index 0." I get the message when I refer to a class from a web form, when this code runs: oPolicy = New Policy oDR = oPolicy.GetPolicy() I am calling the function GetPolicy in the Class Policy. Anyone nay ideas. macca Re: Error Mesage being thrown Dave Kreskowiak6-Sep-05 7:02 Dave Kreskowiak 6-Sep-05 7:02  Policy is a namespace in the .NET Framework, not a class. .GetPolicy is also, not a method of any class in the .NET Framework. You'll have to copy and paste the code snippet here. You haven't provided enough information to help with your problem. What is the Policy class? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Last Visit: 31-Dec-99 18:00     Last Update: 25-Sep-24 8:21 Refresh ᐊ Prev1...3873387438753876387738783879388038813882 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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