I can't populate my combobox with ANYTHING I code, and I don't like the click and pull system. it compiles, no exceptions, but it still doesn't populate my combo... this is the code
[Code]...
I've project where i wanna check if user is connected to internet if he isn't then form must close and another form should show up ! Problem i'm getting is i can't use check it constantly, even if i use while loop
keep looping the following code until condition is wrong or until connection is made
While IsConnectionAvailable() = False
' code goes here for when connection to hotflask can't be made[code].....
but here form 2 keep showing up and it crashes system, is there any simple way to do it .
I have been using the code below to tell if the computer has an internet connection. It works fine on my home computer but when I run it at work on our network which has internet, it fails. I can go to the sites I use below in my browser but when this is run in my app, it returns false. Any ideas why? Is there a better way i should be checking?
[Code]...
I am using the code below to test whether the user is connected using either a wireless or LAN connection. i.e. that the cable is plugged in, or the wireless is switch off. The code works fine for this. However, if you can spot any potential problems with this or you know of a better way I would be interested to learn more.
[Code]...
I've been trying to fix this for a while now and have yet to find a solution that works, I want it so that when an item is added another of the same name cannot be added. Here's what I have
Dim i As Integer
For i = 0 To ComboBox1.Items.Count() - 1
If ComboBox1.Items.Item(i) = TextBox1.Text Then
'do nothing
Else
[Code]...
I want to check if two combobox values are equal. The comboboxes are in a datagridview.I found you need to use datagridview_EditingControlShowing to add a handler to the comobo boxes for selectedindexchanged. I can do this with this code.
Code:
Private Sub dgridRegisters_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles dgridRegisters.EditingControlShowing
Dim combo As ComboBox = CType(e.Control, ComboBox)
[code]....
However, the message box comes up for every combobox in my datagrid when I change the index, not just the cmbPort2. I would like to have something like this...
If cmbPort1.selectedindex == cmbport2.selectedindex then
'do something
endif
..but it doesn't seem possible.
How I could go about checking a typed value in a combo to the values in the combo box. I am making a system to select lockerID and Supplier ID I want the user to be able to enter the value in the combo box as well as select the value form the list in the combo box. Here is the code I have been trying.
If cboStockID.Text = "" And cboStockID.Text <> cboStockID.Items.ToString Then
MsgBox("Please enter Stock ID")
Exit Sub
ElseIf cboSupplierID.Text = "" Then
MsgBox("Please Enter Supplier ID")
Exit Sub
End If
Can someone tell me why this code works exactley the opposite of the way I thought it should?
[code]...
I have a combobox (cbKeyWords). I want to make sure tbAddEdit.Text does not already exist before I save. To me I should be testing for a False result not True. But the above code, goes to the msgbox if findstringexact=false and saves the data if it's true.
why this code works exactley the opposite of the way I thought it should?
[Code]...
I have a combobox (cbKeyWords). I want to make sure tbAddEdit.Text does not already exist before I save. To me I should be testing for a False result not True. But the above code, goes to the msgbox if findstringexact=false and saves the data if it's true. Am I crazy or am I missing something? Shouldn't FindStringExact return false if it's not found?
Case: I have one ComboBox which i fill up by using DisplayMember, DataSource with DataTable.
[Code]....
When user key-in in ComboBox (not select from the list), I check with above all possible but still got nothing. According to my knowledge, .Contains(cboStudent.Text) should work. Right?
I out of idea to check this checking.
I'm using Visual Basic 2008 Express Edition. I have a problem.I'm trying but i can't solve.There is a XML file on my website.
[Code]...
I'm making an program to searsh trou a access db with a combobox it neet after selecting to show the wricht value in a textbox and a numberupdown
i have tried to load al data in combobox but when i select it nothing happen
I have a program that reads a database file(.csv or.Txt) then allows user to select data from 6 different comboxes and taext boxes are then populated based on the selection made from combobox
I would like to be able to give the user the option to save their settings so next time the program is open it will connect to the same database as the last connection and also have comboboxes go to the last selection Do I have to create a save setting value for each combobox? and the connection string?
is there a simple way to just save everything? so when the program is open it goes back to the last time it was open.
I have a little problem with application setting in VB.net 2008. I want to switch main server and backup server connection string with combobox. [Code] It did change the Application Setting connection string in the main form when combobox1 was changed. But the problem comes, when child form was called. On the child form there is DataGridView with Dataset using application connection string. Even the Backupserver was selected on the main form, child form dataset connection string doesn't change. I don't know how to pass the current connection string to child form dataset although it is set to use application setting.
View 6 RepliesIs there any better performance by checking for a true value like this:
[CODE]..............
Than like this:
[CODE]..............
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand()
cmd.Connection = My.Settings.Item("csStaffHoursWorked")
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spSaveDeltekImport"
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
i have an application. which is executed after every 5 mins. i have an open connection but it gives me the following error:
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
my code is something like this. I have shown where all i am using ExceuteScalar()
Sub Main()
Try
connection.open()
cmd.ExecuteScalar()
[code]....
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
I have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[code]....
I am attempting to write a program that will disable the Local Area Connection while leaving the Wireless connection enabled. My company is using net-books in our stores to demo air-cards and we need to keep them off of the LAN. I'm new to VB and VB.net, and it's been a while since I did any type of programming. I've gathered some code that others have posted in forums and tutorials and I'm working through a tutorial book, but I finally believe that I am stuck.
[Code]...
i make a class and when i call on form then that error occurs "ExecuteNonQuery requires an open and available connection, the connection Current stat is close "
Class Code isImports System.Data.SqlClientImports System.DataImports System.StringPublic Class DatabaseKits Dim Cn As New SqlClient.SqlConnection Public Function BuildConnection() As Boolean Try Cn.ConnectionString = "Persist Security Info=False;Integrated Security=True;Trusted_Connection=Yes;database=BizAimsPro2008;server=Server-2k3s" BuildConnection =
[code]....
I am connecting to a data stream that pushes data continuously and when I tried to set up a network stream I just could not connect and kept getting the 'not found' error. I used the httpwebrequest with webrequest.keepalive = true and started to consume the data by reading into a buffer and then appending to a stringbuilder. Once the stringbuilder reaches max size I flush it to a text file. The problem is that I get disconnected from the data stream because I am not reading the data fast enough. I need to keep the connection open and read the data while ensuring data gets stored in text files. If I use method "CONNECT" it does not connect to the stream.
While (True)
webrequest = DirectCast(Net.WebRequest.Create(url), HttpWebRequest)
webrequest.Credentials = New System.Net.NetworkCredential(username, password)
webrequest.Method = "GET"
[code]....
should I increase the buffer size and if so what is the max? that would mean I can read more data at a time and keep up with incoming push. Disparate here.
ACtually also I noticed that it gets stuck on this line
numbytesread = responseStream.Read(bufferread, 0, BUFFER_SIZE)
and then eventually I get disconnected.
I am connecting to a data stream that pushes data continuously and when I tried to set up a network stream I just could not connect and kept getting the 'not found' error. I used the httpwebrequest with webrequest.keepalive = true and started to consume the data by reading into a buffer and then appending to a stringbuilder. Once the stringbuilder reaches max size I flush it to a text file. The problem is that I get disconnected from the data stream because I am not reading the data fast enough. I need to keep the connection open and read the data while ensuring data gets stored in text files.If I use method "CONNECT" it does not connect to the stream.[code]
View 1 RepliesI understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
View 1 RepliesTry If functionmode = "ADD" Then
[Code]...
I got this error..The connection was not closed. The connection's current state is open.
This is coding to add data in Ms access in vb...
Imports System.Data.OleDb Public Class Form1
[Code]...
I'm developing a device app in VB.net that will access a SQL Server database. I need to establish a connection when the app is launched, and keep the connection open until the app is closed. I've done the following:In the Master Module:
Public CNN
As SqlConnection
In the Main menu form load:
CNN =
New SqlConnection(sqlConnString)
CNN.Open()
Then when I want to read from the database:
Dim sqlDR
As SqlDataReader
SQL = "SELECT Name FROM Table"
[code]....
When I run the same code without the global CNN, but rather dim the connection inside the Select function, all works well.
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
[Code].....
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 Replies
