Topics
-
- 1 reply
- 1.2k views
Hi all I am trying to display images that are stored in the database on my web page. From what I have read, I should get the images and display them on one page, and then link my image control to the page i.e. Photo.aspx would contain the code for downloading and displaying my image. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try OpenConnection() sqlCmd = New SqlCommand sqlCmd.Connection = conSql sqlCmd.CommandText = "SELECT Picture, ImageType FROM myImages WHERE Identification = " & Request.QueryString("ID").ToString Dim myDataReader As SqlDataReade…
Last reply by mike55, -
- 3 replies
- 1.2k views
This is an open thread to general thoughts and ideas about programming and interacting with a database. I have been developing windows applications that rely on a database for the past few years. I am the only developer for the company I work for, so I don't have anyone to bounce ideas off of. I got some experience in college and graduate school, but I don't seem to have the time to just play around with different programming ideas. I seem to always need to be productive. So, I wanted to see how other programmers design and implement applications that communicate with a database. Currently, I don't like to rely on binding any fields to a DataTable. I usually …
Last reply by grip003, -
- 0 replies
- 723 views
In VS.2005 Using VB.NET on a windows XP (sp2) fully patched. I have a project that has a Microsoft DataGridView on it. Occasionally, when I click on a column header, I get: ArgumentExceptionIsUnHandled At least one object must implement IComparable this problem is Intermittent, it doesn't happen all the time, but happens about once in every five clicks of the column header. I am at a total loss as to what this could be. Thanks in Advance, Laurence Here is the detail: System.ArgumentException was unhandled Message="At least one object must implement IComparable." Source="mscorlib" StackTrace: at System.Collections.Comparer.Comp…
Last reply by JohnOb, -
- 1 reply
- 1k views
I have 2 list boxes bound to a database. The 1st list box displays services ordered by the customer. I want the 2nd list box to display services not yet ordered by the customer. For example. My services are A, B, C, D and the customer has ordered A and B. List box 1 should show A, B List box 2 should show C,D I have list box 1 working. Can someone give me some help as to how I need to setup the query for list box 2? Thanks for your help. Weste
Last reply by Weste, -
-
- Administrators
- Leaders
- 3 replies
- 1.3k views
Recently I turned option strict on in my new applications. I understand that when its on implicit conversion are not allowed. I also understand that this is a good thing. However I'm getting a few errors that I need to cleanup. Also a good thing. The problem I'm having is that I don't have a good grip on the definitions of Late and Early binding. I have the following event that has a late binding error in the eventSender.Checked portion of my code. Can someone explain this to me in layman's terms? I'd really appreciate it. I've looked it up and still don't get it. Private Sub OptArch_CheckedChanged(ByVal eventSender As System.Object, ByVal eventArgs As System.Even…
Last reply by snarfblam, -
-
-
- Administrators
- 3 replies
- 1.2k views
Sadly, I don't get to mess with Visual Basic very much and so my brain likes to rust. So when I have to come back to it about once a year, I have to relearn everything. Yay. I'm trying to get a listbox to populate with some SQL data. When I run it, it always stops at "myConnection.Open" with an error. Here's what I got so far. Am I missing something? Public Class fmMain Inherits System.Windows.Forms.Form Dim myConnection As SqlConnection = New SqlConnection("server=home;database=dbRawMaterials") Dim myDataAdapter As New SqlDataAdapter Dim myDataSet = New DataSet --- Private Sub fmMain_Load(ByVal sender As System.Object, ByVal e As Syste…
Last reply by TheWizardofInt, -
-
- 1 reply
- 1.2k views
I have two tables that I need to join to get the required data, but I get too many rows returned with everything I have tried. Basically, both tables have and IDEA_ID field, and a simple SELECT query on TABLE1 will give me the data that I want from that table, but I get too many rows returned from TABLE2 as there are multiple rows with the same IDEA_ID in TABLE2. Basically, SELECT * FROM TABLE1 gives me all the data I need with the exception of 6 columns for which the data is in TABLE2. TABLE2 has 3 columns - IDEA_ID, ROLE_ID and ADATE. IDEA_ID matches the IDEA_ID field in TABLE1; ROLE_ID is a number from 1 to 6; and ADATE is a date. There can be 1 to 6 rows …
Last reply by IUnknown, -
-
- Administrators
- Leaders
- 3 replies
- 2.5k views
i have written a visual basic.net 2003 application and upon it closing I want it to kill all instances of the application that are running, so I used the code below Dim proc() as Process proc = Process.GetProcessesByName("AppName") For Each SingleProcess as Process in Proc SingleProcess.Kill Next The above code works generally well but there are occasions when it will not close all instances of the application and I am not sure why. If anyone can shed some light as to the reason, it would be greatly appreiciated. Thanks
Last reply by lothos12345, -
-
- 0 replies
- 1.5k views
The Datagrid in vb.net will all wordwrap and multiline but there seems to be a slight problem. Multiline wrap only in the cell that has the focus. Once thefocus is lost the cell will show only the first characters that fit in the cell and nothing more. Is there a solution to this or is it a bug in the datagrid of vb.net?
Last reply by jacky brown, -
-
- Administrators
- 4 replies
- 8.2k views
I am encountering some performance issues with my SERVER<->CLIENTs tcp communication and I think it is related to how I perform my communication. Specifically - the way it works today - I have tried the following two approaches: 1- Foreach Client the main form launches (create and start) a thread per client (so many threads), each thread performs the tcpclient connection, sends the data, and then close. 2- Main thread launches a single thread (create and start) which will loop through the list of clients (tcpclient connection, send data, close) and send the data In both cases I use TCPClient & NetworkStream to perform the actual transfer (so create a TCPClie…
Last reply by Shaitan00, -
-
- 1 reply
- 2.5k views
Hi, I'm trying to get the path of a directory from a Windows Explorer window. So far, I have been able to use API calls to get the handle of a foreground window and determine if it is an explorer window. However, I can't figure out how to get the path of the directory that is currently displayed in that Explorer window. Is this possible to do using Win32 API? Thanks
Last reply by cementboot, -
-
- Administrators
- 2 replies
- 1.4k views
Couple of questions, but first a background. Have a server with Server 2003 on it. IIS 6.0, SQL 2005. Bought a domain from god*ddy. I also have internet running through a DSL router. Currently router is set to let http traffic through on port 80. Question is does anyone have any good sites for getting IIS setup correctly for me to host a ASP.NET app. Also any tips on getting the domain to point to the local server through the router. The router has a public IP, server does not. NAT is enabled and the routing should route port 80 to the private IP of the server. Suggestions or tips? Thanks a lot!
Last reply by mskeel, -
-
- 3 replies
- 1.4k views
Hi All, I have got this issue that seems to only happen in I.E. 6. I have a datagrid on the page which gives the user 2 options via 2 drop down boxes. The first one is how many results will appear in the datagrid and the second is what criteria to sort the results by. These work great. The issue is if you click the back button in the browser, the drop down boxes show the criteria the user selected but the datagrid goes back to the default settings. Has anyone got any ideas? Cheers, Dave.
Last reply by davearia, -
- 3 replies
- 19.6k views
Is there any easy way to convert a string that contains a file URL ("file:///C:/") to file Path ("C:\") in VB .Net?
Last reply by cementboot, -
- 1 reply
- 1.2k views
I am trying to figure out how to achieve the same functionality as VS.NET 2005 has where you right click the project (solution explorer) and select 'Publish' and then the wizard comes up. How do I do that in VS.NET 2003?
Last reply by scaldwe, -
- 1 reply
- 2.3k views
Hi All, I need to be able to parse the settings in app.config and change some of them. Then have .NET persisit the changes back to the user.config file since the properties I want to change are user scope. Below is the approach I am taking. // Get the properties object Properties.Settings appSettings = ProgramName.Properties.Settings.Default; // Get the properties collection SettingsPropertyCollection SettingsCollection = ProgramName.Properties.Settings.Default.Properties; // get a couple of property objects from the collection System.Configuration.SettingsProperty Day = zeusSettings…
Last reply by rickmmrr, -
-
- Leaders
- 5 replies
- 1.6k views
This is the third thread I have started for this problem, and so far I can not get any solution here. Please look at this link, download the code and go through the steps I have listed. It is just not working for me. I am using VS2003 Pro.
Last reply by grip003, -
-
-
- Administrators
- 16 replies
- 2.2k views
I am currently using SQLite.NET Wrapper from http://www.phpguru.org/static/SQLite.NET.html I am currently facing a problem on retrieving the data. My codes are as below... SQLiteResultSet tempResult; ArrayList tempString; tempResult = sqlite.Execute("SELECT * FROM MARKET;"); tempString = tempResult.Rows; for(int i=0; i<tempString.Count; i++) { Debug.Print((String)tempString[i]); } I am trying to typecast the tempString which is an ArrayList to String. But receive this error "Unable to cast object of type 'System.Collections.ArrayList' to type 'System.String'." I am new to C#, please kindly teach me how to convert this? Thanks.
Last reply by FZelle, -
-
-
- Administrators
- 6 replies
- 1.5k views
This code work fine in 1.1 but not 2.0. Any help? Thank you. Dim Con As Object Dim sDB As String = "SQL" If sDB = "SQL" Then Con = New System.Data.SqlClient.SqlConnection Else Con = New System.Data.OleDb.OleDbConnection End If Con.Open("xxx") I get this error: System.MissingMemberException was unhandled by user code Message="Overload resolution failed because no accessible 'Open' accepts this number of arguments." Source="Microsoft.VisualBasic" StackTrace: at Microsoft.VisualBasic.CompilerServices.OverloadResolution.ResolveOverloadedCall(String MethodName, MemberInfo[] Members, Object[] …
Last reply by bungpeng, -
-
-
- Administrators
- 2 replies
- 7.9k views
Okay - I was expecting to find a lot of documentation on this problem but oddly enough I seem to be coming up pretty blank... I am creating a SERVER / CLIENT network game - in this game the client will send a UDP "HELLO|XXX.XXX.XXX.XXX" message to the SERVER - the server will respond to the client with a "HEY|XXX.XXX.XXX.XXX". Then both client and server will form TCP connections using these IP-Addresses. Now this works fine in my LAN (of course) but when I try to play online it doesn't work for one obvious reason, the IP-Address sent back-and-forth is the LAN IP and since I have a router it is not my REAL internet ip-address... I use the following code to determine …
Last reply by mooman_fl, -
-
Who's Online 0 Members, 0 Anonymous, 47 Guests (See full list)
- There are no registered users currently online