i have a checkbox on a form, which is of type boolean in the database .when the user check the checkbox, before the data enters the database, the program should check if there exists already a "1" on the database for this field.If so the user is not allowed to check the depot.
View 5 RepliesI have a database created and tables inserted into it. One of the tables is called UserLogin. It consists of two columns, BarcodeId and Technician. I have a barcode value, and what I am trying to do is check if any of the values in the BarcodeId column of this table is equal to the barcode that I have. Then when I get a match, I want to get the Technician that matches that BarcodeId and display the Technician in a text box.
I was using this code sample:
Private Sub HasRows(ByVal connection As SqlCeConnection)
Using connection
Dim command As SqlCeCommand = New SqlCeCommand( _
[Code]....
I'm not sure if I am on the rught track or not, when the code gets to the line connection.Open during debugging, nothing seems to happen.
Is there a faster/easier and more efficient way of checking if an entry exists in SQL then this:
Private Function CustomerCheck()
Dim connString As String = ("Data Source=.SQLEXPRESS;Initial Catalog=BFS;Integrated Security=True;Pooling=True;")
Dim cmdText As String = "(SELECT * FROM Customer WHERE Customer=" + CustomerTextBox.Text.ToString + ")"[code]......
I want to now how to check if a database exists in MySQl Server from Vb2010.PBL (Visual Studio 2010 Professional, Win 7 64 bit Ultimate)
View 1 Repliesthe next code is working but when I try to insert an existing record, it gives me an error and I want to add a msgbox to let people now that the username is already taken.Only the username cannot repeat on the database because it's the primary key.. the rest of the table rows can repeat.
Dim cn As New OleDbConnection
cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Fabio\Desktop\Telemoveis\Telemoveis\Db_Tel.accdb"
[code].....
I am trying to write(what I thought would be a simple piece of code. I was wrong.
What I am trying to do is to get an application to check if a file exists, However, I have it wrong as the file obviously does exists, but when I run the application it tells me it does not.
Imports System.IO
Public Class check
Dim checkfile As New FileInfo("C:\HelloWorld")
[Code].....
I'm using then next method to check if a directory exists but it seems it doesn't work.
[Code]...
im trying to make code to check if a file with the same name exists twice in the same dir one with .dds and one with .veh file extentions and if they do put in a listbox but if only one exists then it puts it in another listbox i have made code to filter .dds in to one listbox and .veh in another but i dont know how to make the "check" if they are both there
this is the code i have to split them at the mo
For Each files In dir
Dim path() As String = files.Split("\")
Dim chunk As Integer = path.Length
[Code]....
but i wanted the Else for the .dds files that dont have the matching .veh file
I am trying to check whether username entered by user is already exist or not in database. But, I dont know how. The codes are below.
If TextBox3.Text = TextBox4.Text Then
Dim conn As New SqlConnection()
Dim cmd As New SqlCommand()
[Code].....
I think this is a really simple question to answer but I can't find a better solution. Basically I am importing data from an external source and as I go through importing each for I am doing a for loop to see if the row already exists; this is taking a life time and I feel it is a very simple way of doing it. Is there a better way to see if a row already exists using specific columns and key indexes?
View 5 RepliesI'm using ADO.Net to work with an Excel Document. Essentially, I'm looking up values in a table called "source" and creating a new table called "result" which will be populated with the results of my query.
I have a couple of questions.A) How can I check if a table exists and create a new one if it doesn't? B) Is a table the same as a sheet in Excel?[URL]...
I haven't used System.IO before, and I'm a little stuck.I need to check if a file exists, for example C:Documents and SettingsverraineDesktopSURNAME Firstname v1.docx, if this file exists the filename has to become v2, and so on. Usually there will only be a v1, but in the case that a clients position changes we have to be able to save the new version without overwriting the old one.
How would I be able to do this efficiently? I'm uncertain to say the least. Because, if I manage to find out how to save the file as a different number, that's alright, but if that next number exists as well? I can only think of ways to do this that require a lot of code.
Completely new to ASP.net
Page Language="vb"
Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
I want to check on the server for the existence of an image, then if it does exist, display the image wrapped in other code. E.g.
if "/images/name.jpg" exists then
<div><img src="/images/name.jpg"></div>
else
Do nothing.
Seems really simple to me but NOTHING I have tried has worked (compilation errors). I've tried examples using system.io, DIM stuff with 'FileInfo', Set fs. FileInfo examples produce 'not defined' errors, 'Set' says it's outdated and not used anymore and so on.
I want to check if an Outlook folder exists, if it doesn't then create it & if it does then carry on with other code. I can create the folder as a sub folder of the Inbox but once it is created I get an error because it is still looking to create when it's already created. I have tried to capture the error but still no joy.
[Code]...
I am having a ton of trouble trying to check if a record exists. I continue to get a data mismatch on my command.ExecuteScalar().
Code:
Protected Sub btnRegister_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnRegister.Click
[code].....
I've created the following function and thrown it inside of a timer:
[code]...
It works, but it keeps trying to open media player for each process it looks like. I need to continuously run the function so that Media Player opens when it's closed.how to make sure it opens only once when the process doesn't exist?
I'm checking is a file exists as follows.
If txtGradeObs.Text = "" Or Dir(txtGradeObs.Text) = "" Then
MsgBox("Specify the Grade job of Obstructions", vbExclamation, MsgBoxTitle)
Exit Sub
End If
I get an error if the drive does not exist - i.e. G: rather than C:. It used to work in VB6. How can I get it to work.
I'm trying to download files using the Net.WebClient call to DownloadFile
Using client As New Net.WebClient()
[code...]
Is there a polite way I can ask for the file instead of calling DownloadFile, and handling the exception ?
I am adding the text of a label into a datagridview. But before i do the insert, i want to check if the text does not already exist in the datagridview.
View 1 RepliesI have been on MSDN about this and searched but it's not quite telling me what I'm after. I've extracted a list of file names from an Excel spreadsheet and want to check whether they all exist in a directory which a user can select in a text box. It feels like I'm nearly there with it but currently my listbox is displaying everything, I want it to just show the files that are missing. I'm a beginner so I'm not exactly sure if I'm even telling it to compare the two things properly, I've tried a couple of ways of checking if a file exists but neither seem to work.[code]
View 1 RepliesI was wondering if anyone could show me how to check if a tag exists?Here is the code that I am using to get the information from the xml.
Dim XmlFile As New XDocument
XmlFile = XDocument.Load(WorkingDirectory & "ToolsMediaInfoMediaInfo.xml")
Dim Manage = XmlFile...<track>
For Each XmlTag In Manage
If XmlTag.FirstAttribute.Value = "General" Then
[Code]...
This is the standard way of checking if URL exists [code]....
return true; } catch (Exception ex) { return false; } But my problem is that we have to check it for around 100 URL's. It takes more then 2 minutes to check for all as it is trying to get response of all of them. Is there any way that we can check if URL exists without getting complete Response so that total response time is less.
In my code, I want to check if a referrer url exists and if the referrer url contains a specific sub string. I know how to check for the sub string:
If( InStr( Request.UrlReferrer.ToString(), "some sub string here" ) > 0 ) Then
But I don't know how to check if a referrer exists or not. No refer exists if the url is entered in manually in the address bar. So I tried this, but this does not work:
If (Not (Request.UrlReferrer.ToString() = "")) And (InStr(Request.UrlReferrer.ToString(), "some sub string here") > 0) Then
how do check if a referrer exists?
I have a windows service which fetches data from various datasources and build a XML file and send it to a webservice. For example first I will get customer details from Oracle Database and build the XML file and then the SQL Server database and build the customer details XML. I am planning to use the same function below to build the customer object irrespective of what the datasource is. But dr("age") column is not available in SQLserver datbase How can I check if a column exists or not.[code]
View 3 RepliesI am trying to check if a folder exist, it doesn't work if the folder name has a space or "_" or "-". .
here is an example of cases that don't work:
"Folder test"
"Folder_test""
"Folder-test"
I know how to make a new directory on an FTP server, but I wanted to know how I can check if a direcogtry exists, and if it exists display a message?
View 2 RepliesI am using Caspol.exe to install a custom Permission set and add Code Groups for my .Net 2.0 Windows Application.
I have created a Console Application that uses caspol.exe to add Permission Set and Code Groups. I first install the Permission Set and if I do not get an error, I continue to install the Code Groups
Now sometimes I need to add a new Code Group to the client machine, so I make the changes to the console app and it is executed on the client machine. If the client machine already has the Permission Set installed, it returns an error and stops the further processing.
So, I want to know if I can check whether a custom Permission Set is already added or not?
How would i just if a website exists, and, if so, launch a browser to open it. I am making a little tool for one of my freinds and it allow then to quickly launch websites. How would I check if that is a valid website to launch, so i don't get an error if it is not valid.[code]The error i want to stop is "Cannot start process because a file name has not been provided."So basically i want to make sure that the program can launch the URL so i don't get this error
View 3 RepliesI cant get the following code to check if my regestrykey exists can some one help. the idea is to check if it exists if so do nothing if not create it, along with its value...
the full key is HKEY_LOCAL_MACHINESOFTWAREVTSAdvanced Offset 2AdminAccess
> If Dir$("HKEY_LOCAL_MACHINESOFTWAREVTSAdvanced Offset 2Admin", vbDirectory) <> "" Then
[Code]....
I need to figure out if a registy key exists under the HKCU hive. If the key exists do this, if not then this.
View 6 Replies