Answer Questions
RockyMountainer showing a picture on a form and storing in database
Hi all, I have created a simple form with several fields bound to a basic SQL database. I'm using Visual Basic Express and SQL Express. The normal data fields are no problem but I can't figure out how to store a photo in the database and then to show it on the form as part of the record. Any help would be appreciated! Thanks Dan It is recommended that you don't store the image in the database itself but to copy the image to a server and to store the reference to where the image ihas been copied to. When you store Items like pictures to a database you are storing using something called a BLOB (Binary Large Object). The following example shows ho ...Show All
NeroToxic DES File encryption problem
Hello everyone. I'm working on a project that performs file encryption. With DES and 3DES. However I've been having a problem encrypting compressed files. The code that I used was a snippet that I found in the MSDN, this code seems to work perfectly with text files. I even analyzed the text files on a binary level and everything was perfect. Now whenever I try to encrypt a *.rar or a *.zip file I always get a "The file "" header is corrupt" and/or "Unexpected end of archive" errors. This is the code for the encryption and decryption algorithms: Sub EncryptFile(ByVal sInputFilename As String, _ ByVal sOutputFilename As String, _ ByVal sKey As String) ...Show All
Musafir IDE Slow, movement of solution explorer window and others
Where oh where do i start. I am an experienced B developer + 8 years from VB3. We have been using VB 2003 for about two years and have managed to get used to it's foibles. We decided it was time to investigate VS2005. I was using Windows 2000 but due to the fact that I could not install/uninstall a new version of comonent one tools I had my machine rebuild using Windows XP and then i installed VS2005 & the latest version of our component one tools. First of all there is the problem withthe properties windows. I dave a dual monitor system, in fact all the developers have the same set-up. SO in VS2003 I have the main IDE in the left screen and the various propert windows (solution explorer, properties, toolbox etc on the r ...Show All
Frank Johannessen Logins
Can someone point me in a right direction to learn how I can use a login form to login to SQLExpress Server using SQL Authentication I am thinking that I would like to use the login for my app instead of embedding one in my application. Is that wrong to thing like that I am thinking right by using this to gain access to my application and login to the server at the same time Davids Learning what is a good example, and where does she go I got the login to function like it should, thanks again! Is there a way to keep the form from melting away, looks kinda sick just fading out when the login completes. Ah yea by the way do I have to call that in every form, or once your logge ...Show All
vijil Where is data grid when creating a Windows Application?
I have posted this on a couple other forums and have not recieved an answer. Anyone here able to point me in the right direction I am trying to create a database Application following a step by step in my text book Programming in Visual basic.net by Bradley/Millspaugh. I am told that in the following step by step tutorial I will create a web application....with only a couple of exceptions the same procedures work for a windows application.. I am trying to do the windows application. I follow the steps beginning the project, setting up the connection adding the cinnection and the data adapter to the form, naming the adapter, and geneating a data set. The next step says to add a data grid but there is no data grid in the t ...Show All
JenniferStites Today's Security Patch Throw a MonkeyWrench in my Program...
Vulnerabilities in Microsoft Excel.... I use the basic code to call Excel in my app. Well, today's patch (auto-update) put a fix in where remote access of code execution in Excel is prohibited. I understand the reason behind why MS did this but I have a registered copy (that I bought hehe) but what do I do now to use Excel with my app. Is there some way to properly register Excel with the app or what Please help and thanks in advance. Have you signed your project Can you give us some more information about what's causing you a problem with regard to this update Is something popping up that is preventing you from loading excel If you have some sample code could you post that ...Show All
rhd75 Login Form VB 2005
Hi , i can’t make a loging form, checking a database users, i already have the users db, but how can i made th validation, a full step explanation it'll be great, please help me i already read a lot of books about vs2005, but i still with this trouble i'm usin Microsoft SQL server, thanks a lot!!! yes, but first i wanna made th connection to data set, and check te names on it, but this is the trouble i don't know how, this is my first time i use sql databases, i used the acces db with visual basic 6, so it's little hard when i click in ok the user must exist on the db if not then cancel the login to the main form, please help!!! hehehehe thnaks a lot pal! well you dont need to fill anything into t ...Show All
peterjp Modulus11
Hi All, I need to populate ISBN No on btnSubmit_Click event using Modulus11 check. The input box is a text box " txtISBN" and the ISBN Number will have 10 digits. . Any idea how I can implement this Any help appreciated Ronan Jordan, I suggest you to write a regular expression in your program such as in the button click event. Here is an example on the ISBN regular expression: Title: ISBN-10 Pattern: ISBN\x20( =.{13}$)\d{1,5}([- ])\d{1,7}\1\d{1,6}\1(\d|X)$ Matching Text: ISBN 0 93028 923 4|||ISBN 1-56389-668-0|||ISBN 1-56389-016-X Non-Matchig Text: 123456789X|||ISBN 9-87654321-2|||ISBN 123 456-789X ...Show All
DonMartin Irritating effect from combo
I have got a form that I open, in the forms load event i do the following Me .EDF1TableAdapter.Fill( Me .DataSet1.EDF1) Me .ENameComboBox.Text = "" Me .ENameComboBox.DroppedDown = True Me .ENameComboBox.Focus() when the form loads, the combobox is dropdown and does have focus, but its got a mouse cursor showing wait it does go away after you click in the combobox if you dont dropdown the combo it does do it, why Davids Learning Hmm, that's interesting, it reproes on my machine. Not sure why it's doing that, but you can add this line at the end as a workaround: Me .Cursor = Cursors.Default Hope that helps, Jonathan Aneja The VB Team What happe ...Show All
siavoshkc Show and hide a form
I have a form (frmResults) that shows a list of results for a name search. I would like to keep it open but hidden after the user selects a record to view, which opens another form (frmMain) and hides itself. The frmResults' Load event fills a table adapter based on parms passed to the form (first and last name). I have a button on frmMain that returns to frmResults using My.Forms.frmResults.Show and Me.Close. Problem: when I try to return to frmResults I get this unhandled exception: "Object reference not set to an instance of an object." It happens on the line where the table adapter is filled. Is there an easy fix for this or do I have to pass the name search criteria around to get the results to show again T ...Show All
Taurkon Changing ConnectionString at runtime
In my application, i am not sure where will be the database. So i thought to put the connection string in app.conf file. So that i may read it runtime and create connection. Working good. But what if i have to change the connectionString define in app.conf at runtime It may not be necessary that i must use app.conf, you people can suggest me one better approach so that i may not be dependent on databasestring. It could be created/change at runtime. i changed the scope to "user". The behaviour of application was strange. Let me try to explain it. I made a text filed and 2 buttons. On buttone1 press the value of textfield is set to ConnectionString using the method you told. Pressing the button2 give a message which rea ...Show All
roni102 VB6 Image control in VB2005 used as feedback device in a picture
In VB6 I used Image controls to give visible feedback when the mouse moves over a 'sensitive' area in a picture: set the borderstyle to fixedsingle and set it back to none when it's outside. I am looking for a simple equivalent in VB2005. VB6 Image controls are transparent, but anything I can find in VB2005 in the form of (user-) controls is opaque (right ) and requires a lot of hassle with the underlying image. So the functionality I am looking for is to let the user know where on a picture he can click, for further info and whatever. Without ruining the picture (a bitmap in a picturebox on a panel). Should be easy, but can't find any help in the help. Help! Hi - I've been playing with this a bit ...Show All
Xaid Problems with WebBrowser objects...
Hi there! Could someone please explain why the following three functions return the same value WebBrowser_instance.Document.Body.GetAttribute( "scrollHeight" ) WebBrowser_instance.Document.Body.GetAttribute( "clientHeight" ) WebBrowser_instance.Document.Body.GetAttribute( "offsetHeight" ) I really need the object to return the right scrollHeight values. Regards, O Hi, if you want the dimensions of the webpage, then I think this Rectangle will give you that: WebBrowser1.Document.Body.ScrollRectangle with these two giving you the amounts that the page is scrolled: WebBrowser1.Document.Body.ScrollTop WebBrowser1.Document.Body.ScrollLeft and ...Show All
williambeaker Hiding the cursor when not on a form
I have tried the following for hiding the cursor from the desktop: showcursor(false) or system.windows.forms.cursor.hide() both of these only hide the cursor while it is over the form that I am developing. I would like to know if there is a way to hide a the cursor while you are not on the form. Thanks, Tim nogChoco, According to your problem, I noticed that there is a class called PaintEventArgs and it has a property ClipRectangle. I searched an article on this titled Redering a Windows Forms Control as the following link and hope that can help you with the problem: http://msdn2.microsoft.com/en-us/library/1e430ef4(VS.80).aspx Is a ClipRectangle acceptable It's annoying wh ...Show All
Alex Chub Another simple question from novice
I have a database on my SQL Server. One of the tables is called "Wyniki" and there are columns: ID, Imie, Nazwisko, Punkty, Status, DataGry, RodzajGry, Autor. There is some data already. I want to read data from it and I tried to use this code: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim Polacz As New Odbc.OdbcConnection Polacz.ConnectionString = "Driver={SQL Native Client};Server=localhost;Database=ProjektKoncowy;Trusted_Connection=yes;" Dim cmd As New Odbc.OdbcCommand("SELECT * from ProjektKoncowy.dbo.Wyniki", Polacz) Try Polacz.Open() Dim reader As Odbc.OdbcDataReader = cmd.ExecuteReader() While reader.Read ...Show All
