I get a Type 'System.Data.SqlClient.SqlDataReader' has no constructors. error on the 5th line of code below and I get a Variable 'e' hides a variable in an enclosing block. on the last line of code below (in my catch statement).
Here is my code:
Imports System.Data.SqlClient
Public Class Form1
Dim myConnection As SqlConnection
[code]....
Need to create a form and connect the form the database on the click of a button. I have created the forms and data tables (Attached).Also want to know how can i open a form on double clicking an entry in the list box.
View 4 RepliesI need a simple snippet that will allow the user to test the connection for the FTP server entered in a textbox and the username and password from 2 other textboxes. (Server = TextBox1.Text, U/N TextBox2.Text, PW TextBox3.Text) I forgot to note something obvious - there's a "Test FTP" button
View 2 RepliesI have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
I think its better if i attach my files for you understand what i wanted to happen in my program.
We are now in our finals and for our project we need to make a program that shows connection of database(sql or access) and vb.net so dont mind if it has a problem in design or anything bcoz the objective of this project is to show what we've learn in our subject IT Programming 1 (vb.net)
I dont know what to do in this part of my program. what to do first? why is it attaching zip files is not allowed?
I am just starting to dive into the ADO.Net routines in VB.Net, have used ADO in VB6 forever just would like to make sure I am getting started on the right foot here.
'As I test I had hard coded the connection string here which I have removed from the post, I will switch it to a var that is read from a config file later.
CN.Open()
Dim Cmd As SqlCommand = CN.CreateCommand
Cmd.CommandText = "Select * from tblusers where userid=@UserID"
[code]....
btw I realize that I have not yet added a message for when the Userid is not found. I am more concerned with the method I am using to query the db and read the results as well as closing the objects afterwards.
Im a user of VB 2005. I had a problem with Simply run a project (Even Without any code in it). Indeed when i Creat a new project and i want to run and debug it (with F5). The information box show that cant debug. and because of that, the program may not run.The Message in information box is here (in Appendix).I try it with VB 2008 (But didnt work). After i Reinstall all of VB and Install again, but my problem existed even now.
View 3 RepliesI need to display a simple box on a form that can be split by the user. It represents a gang up of a number of images on a printed sheet. These images are always in a # of rows x # of columns format (1x1 or 2x4 etc). There can be from 1 - 24 rows and 1 - 24 columns.
My thought was that I would give one text box each that the user could enter the number of rows and number of columns into. When these change then the box display would repaint to display a grid that represents the gang up specified in the text boxes. My issue is that I don't see a control that I could adapt for this use for the box.
We're starting to evaluate VS 2010, but right now I'm trying to do a simple Windows application in Visual Studio 2005 on an XP box.
Eventually, this will become a web service, but I want to test the XSLT file I am using in a simple application first.
Here is the XSLT file:
CODE:
The file is added to my project, XMLTest.
The code that generates and parses the file to change to a text file is as follows:
CODE:
A sample output XML file is as follows:
CODE:
When I run the VB code to input and transform the XML output I get a filenotfoundexception error that I can not figure out, because where it is expecting the XSLT file doesn't seem to make any sense.
If it were going to always be hosted on my machine, I'd use an absolute path, but it's not going to be, and I'm going to be switching to a Windows 7 x64 box after lunch anyway.
I'm trying to create an application that is able to find products from a XML file, which will contain the following data:EAN (Barcode as a string, not an image)
Description
Price
Stock
So basically, I enter the EAN and my program will lookup the XML file for this EAN and will return the description of this product, the price and the stock in a new messagebox. However, I don't understand how to create a XML file, add items, remove items, edit items, and most of all: read items from a XML file.
I was looking to do some simple manipulations of variables based on what tab was selected.But I dont see Deselected, Or Selecting as in this example, does 2005 use somthing different?
vb
Private Sub TabControl1_Deselecting(ByVal sender As System.Object, ByVal e As System.Windows.Forms.TabControlCancelEventArgs) Handles TabControl1.Deselecting
someClassLevelVariable = e.TabPageIndex
End Sub
[code]....
I was wanting to make a simple client-server program.I saw some code for it and it was easy to understand but it was with winsock.
The program is:
Client: Clicks button.
Server: Recieves Text written in clients textbox.
Is there a reasonably easy way to do this?Maybe Net.Sockets or something similar?
I am trying to create a simple countdown timer using vb 2005 express edition. I think the code is fairly simple but I have fallen at the first hurdle. How do you display the result, i.e. which control do you use? Tried label and textbox but both return the error: "Value of type [integer or long] cannot be converted to [textbox or label].
View 3 RepliesI have compiled a Vb.Net program in which I used R Programming through R(D)COM. The statconnector library works fine. The program gives output without any error.
However whenever I try to deploy the code and create a setup file, and I run the setup file, I get the following error: There is connection for this connection ID (Exception from HRESULT: OLE_E_NOCONNECTION)
i am trying to run a stored procedure from my vb .net application and i am getting an error that says something like this:
"..under default settings sql server does not allow remote connections"
i have checked with my sql configurations and i have allowed remote connections but i am getting this error. besides i am connecting to my local machine so why should it give me a remote connection error.
I making a connection through word 2003 VBA to SQL server 2005 using the following codeDim cn As ADODB.ConnectionSet cn = New Connectioncn.ConnectionString = "Provider=SQLNCLI;Server=LEXAE29150SQLEXPRESS;" & _"Database=MCarter.mdf;Integrated Security=SSPI;"cn.openetc.cn.close.All runs fine up to cn.open.I then get the message error 'Cannot open database "MC.dbf" request by the login. The Login failed'.Tryed websearching but no succes. Been on it a week and the boss is doing his nut. I'm lost and unsure what wrong.The SQL server is set for windows authenticity and SOL Server login.In the MC database under security users my user name (Login) is their and setup as owner and sysadmin.SQLServer is running on the same machine as the word.dot.
View 3 RepliesI wrote a program in Visual Basic 2008 on my laptop that runs windows vista 64 bit, well the program attempts to access an Sql server that I am running on my laptop and it continues to give me the following error:
[Code]...
I have a an application that opens a SQL connection and over the course of a few hours creates and disposes of tens of thousands of DataReader objects. You could look at it as just one big loop. As the time goes by, the memory usage steadily climbs until the application/system runs out of memory and crashes.
Psuedo code would look something like
SQLConnection.Connect
Do Until x =1000000
Create New DataReader
Use DataReader
Close DataReader
[Code] .....
Even though I dispose of the DataReader object when I am done with it, the memory usage keeps climbing. I found that every time I am finished with the DataReader I have to close the SQLConnection and dispose of it. When I do that it keeps the memory usage very low and the processor usage is barely noticeable. I would think I could just open the SQL connection once and close it when I am done.
I'm connecting to an ftp server in my .net application. After I send the file and try to close the connection, I'm getting an error. I'm trying to send the Quit command to the FTP server but getting no reply. I'm not sure what I'm doing wrong. I call this method: [code] Do you think something is wrong with the code of could it be a problem with the ftp server?
View 2 RepliesBetween ODBC and OLEDB providers, which one is more flexible at both the application level, and at the report level using crystal report?
View 1 Replieshow to code for database connection in vb.net 2005?
View 3 Replieshow to code for database connection in vb.net 2005?
View 1 RepliesUsing - VB2008 Express, XP Pro,
Connecting to SQL 2005 across the internet
The walk throughs have several good explanations although I don't see any about connecting over the internet.
I used the wizard in VB 2005 to add my database. Under the "Applications Settings" area in VB my string is currently set to:
[Code]...
what is the connection string for Access for connecting Access Database with ADO.NET (For win app).
View 1 Repliesi have visual studio 2005 installed in my pc.i have sql server 2000 as database.i have expertise in client server software written in vb6.now im trying to do the same in vb.net.i dont know how to establish a global connection in vb.net.how to do that in vb.net?in vb6 i would just write a public function in a module and it remains throughout my application.so how can i achieve the same thing in vb.net.
View 4 Repliescode snippet to get active network card name, that is the network card currently connected to the internet in c# or vb.net?
View 5 RepliesI get an error saying that the connection was rejected by the target machine here, suggesting that my firewall is working well
How do I make sure that the connection is accepted? It's a chat program (obviously) so I'm going to need to do the same thing on users' computers when it is installed. How do I make this in such a way that the connection will be accepted but leaving security uncomprimised?
vb.net
Imports System.Net.Sockets
Public Class QuickChat
[Code]...
Dim SQLData = System.Configuration.ConfigurationManager.AppSettings("FixedLineProvisioningConnectionString")
[code].....
my project is attached. I have a very weird problem with Winsock! I made 1 program with 2 forms. 1st form is the client, 2nd form is the server. Server send snapshot for client. So, client display either Single Picture. Or stream of pictures (to simulate video capturing).
when open 1st window (client) in a computer, and 2nd window(server) in another computer... it connect and display picture without problem just once!! when press "Capture" button again it may reponse or Winsock may loss connection. and when Check "Loop"=> means for stream of pictures.. Winsock loss connection immediatly! I don't know where is the problem exactly! The code attached. Winsock ocx is attached.. see it in the release folder