Allow User To Browse For, And Select, SQL Server & Database?
Apr 4, 2010
My application needs to be able to be pointed at different SQL Servers and different databases and I would like to provide the end user with a nice method of selecting both the server and database (the app is for use by other IT staff).Ideally, I was thinking of allowing them to browse to the server (with possibly entering credentials or even better, using their Windows credentials as the databases in question should be accessible to the relevant people via their AD account), and then listing the databases on that server allowing them to select one to use.
I would like them to then be able to easily change the server and database whenever necessary.I imagine I would then need to build the connection strings based on what they select but at the moment I have got rather stuck in just trying to create a form with some kind of Server Browser (I've not got as far as a database browser!).Failing some kind of server/database browser options, I would change to some simple text boxes where the user can enter the name of the server and database directly with some kind of connection verification button.
Finally, is it easy to connect to multiple databases on the same SQL Server at the same time? Is it just a case of creating and referencing multiple connection strings?I am using VB 2008 Professional and SQL Server 2005 Standard.
View 5 Replies
ADVERTISEMENT
Jun 22, 2011
I have a db, and one of the columns in my db is an attachment column. It stores the link to a pdf document. I want the user to be able to browse through folders and select the proper pdf file. And when the user finally hits the submit button on the form my algorithm should put the necessary link into my db. I'm just not sure how to do this with regard to VB searching and finding the file, and then using my SQL statement to insert the attachment into my db.
Here is my code so far.
Private Sub SearchFile_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SearchFile_Button.Click
Dim saveFileDialog1 As New SaveFileDialog()
[CODE]...
View 6 Replies
Oct 30, 2009
I have a databse in my project named Members.mdf is there away i can use OpenFileDialog and allow the user to browse for a database on their local machine then have that database loaded into my application?
View 3 Replies
Nov 1, 2010
I have a VB2005 winforms application that will loads city data from my database table. This is to ensure that the user enters the correct city spelling, in order to receive an accurate quote. Currently, there are about 150K cities that are being loaded to the dropdown listbox on page load. It takes about 30-40 seconds for that page to load. My initial thought was to allow the user to select the state first. Then load the city values. But the user has the option of going back and requesting a quote for a different city / state.
View 2 Replies
Jan 22, 2010
I'm making a new program.
Basically I want them to press browse and select a file.
Once selected they press a button.
Once they press that button it sends the small file they selected
To an email address.
Here is what I have.
Imports System
Imports System.IO
Public Class MainClass
Shared Sub Main()
Dim i As Integer
[Code] .....
View 10 Replies
Apr 13, 2012
I want to be able to select multiple files when I click browse on the FileUpload browse button. I have it now to where I can choose one file and add it as a list using a jquery but would I would like is to select multiple files to be added when I click open. Is there a simple way of doing this and is there maybe some kind of javascript that might be able to handle this event?
View 1 Replies
Apr 4, 2011
i want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 Replies
Feb 8, 2012
I want to select just the Year from that DOB and display that on a Listbox (or any appropriate interface on a page). We are not using SPs. So I will probably coding SQL directly from the page or using SQL datasource. Using LINQ is alright if that can be done in it
View 4 Replies
Jan 24, 2011
i need to browser the folder in Folderbrowser dialog how to done this?
View 3 Replies
Oct 23, 2010
How can I catch error if the data that user select not in database?
This is my code.[code...]
View 5 Replies
Sep 5, 2009
I'm trying to connect from VB 2008 Express Edition to a database in an instance of SQL Server 2008. Both, VB and SQL Server are running on the same machine. From a VB project, when I try to define a new Data Connection I find just three Data sources available: [Code] I selected the last one but when I browse for the mdf file I cannot select it because it tells me that the file is in USE. I have stopped all the services but still I'm not able to link the database file.
Two questions: 1. Is there a way to connect to the SQL Server Instance and from there to select the desired database? 2. How to connect using the Database file.
View 2 Replies
Nov 8, 2011
Basically I need to make a program that lets a user browse and choose a folder, then I need a box that the user can then select the files to work with, then with the selected files I need to put them into a zip file. I'm trying to use a list view box but having all kinds of problems using the data in it.
View 2 Replies
Apr 10, 2009
I am already familliar with applying an image to a form background. My application has many in it, but I want to give the user the option of browsing for an image of their own to apply to a form. I don't intend to save the images as defaults or anything. Just the option to browse and apply to a form.
View 6 Replies
Apr 9, 2010
im using form with browse button and openfileDialog as a browse function how do i get it to return the full path of the image selected to a varibal EG File then a textbox on form EG txt_pic.txt = File also how can i set it so it only allows images EG jpg bmp png gif and ico and nothing else then how would i code it so it adds the image selected to the Resorces folder so it can be used again with out browsing for it i also want a combobox that displays all images in the resorce folder?
View 7 Replies
May 11, 2010
i am working on a little project for myself in Microsoft Visual Basic 2010 and i want to add an option so that when a user clicks a button it will open a browse directory window where they can select their directory and when they click "Ok" it will copy files into it. [Code]
View 8 Replies
Oct 30, 2009
I have a databse in my project names Members.mdf is there away i can use a OpenFileDialog and allow the user to browse for a database then have that database loaded into my application?
View 2 Replies
Oct 16, 2009
I am using help of SqlServer.Management.Smo to rename an attached MS-SQL database.
Dim db As New Database = ActiveSQLServer.Databases(OLD_NAME)
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " SET SINGLE_USER WITH ROLLBACK IMMEDIATE")
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " MODIFY NAME = " & NEW_NAME)
The problem is that after renaming the database is set as a Single User.So what am i doing wrong?
View 1 Replies
Jun 3, 2011
I need to backup the sql server 2005 express database. It works fine if I make backup to specific folder"C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup". But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. "
My code is
Dim sqlBackup As New Backup()
sqlBackup.Action = BackupActionType.Database
sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString()
sqlBackup.BackupSetName = "Archive"
sqlBackup.Database = "data"
[Code] .....
View 1 Replies
Jun 3, 2010
I have made a project in vb.net 2008 and used sql server 2008 for database and how to make the setup that need to be deploy on those system which do not have sql server on their system .
View 9 Replies
Aug 10, 2010
What is the difference between vb.net application and asp.net application? How can I publish an ASP.Net application with database residing in the server and user could update that through internet?
View 2 Replies
Sep 2, 2009
I use AES encryption in my vb.net 2008 windows forms apps to ....
1. Store user passwords in sql server express database in encrypted form
2. decrypt the encrypted Sql server express connection string password on the fly when connecting to SQl Server over a vpn or direct to web based sql server database
3. decrypt the encrypted ftp site password on the fly when my application connects to my ftp site to upload client's database backups
The issue I have is that the secret key for the encryption / decryption is hard coded within the encryption/decryption functions. So anybody who decompiled my application would be able to generate the same encryption, as they would have the encryption secret key How can you hide the encryption secret key so that if anybody decompiled my app they could not reproduce the decryption function
View 1 Replies
Jan 27, 2011
IT STILL GIVES A MSGBOX IF I SELECT THE CHECKBOX BOX OR NOT ....My code below will redirect to Google in both conditions: If the user selects the checkbox, then it will redirect to www.google.com, but if a user forgets to check the checkbox then it shows the msg box with an ok button. When I click on ok it should redirect to www.google.com
I want When a user forgets to check any of the checkboxes to show a msgbox with an ok button and stay on the same page. Otherwise if user selects any of the checkboxes then redirect to google
[code]...
View 2 Replies
Dec 15, 2011
My application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
View 2 Replies
Jan 18, 2011
Write an application that tests the user�s knowledge of road signs. The application should display a random sign image and ask the user to select the sign name from a Combobox.
View 12 Replies
Aug 10, 2009
Multi-User Chat Program (Server & Client) with Main Server?
View 1 Replies
Oct 2, 2008
Dim sqlConn As New SqlConnection("Server=.\SQLEXPRESS;uid=;pwd=;database=ContactManager")
sqlConn.Open()
Above is my connection string, The programs runs up until sqlConn.Open() and then i get the same error, using no UID and Pass, or using a uid and pass.
Login Failed For User ''. The user is not associated with a trusted sql server connection
I have the SQL Servers authentication se to Windows Authentication and SQL Authentication. I'm using Visual Studio 2005 and SQL Server 2005.
View 10 Replies
Jul 29, 2011
i am having a console application. I am trying to connect to a sql server.
my connection string: Data Source=<Some server>;Initial Catalog=<some database>;Trusted_Connection=True.
when i am executing on my local machine it runs successfully. But when i am trying to run it on a server it is giving me the following error:
Login failed for user ' '. The user is not associated with a trusted SQL Server connection.
do i have to change my connection string? if so what it should be?
View 2 Replies
Feb 16, 2011
In my scenario, users are able to upload zip files to a.[url]....I would love to create a "daemon" which in specified time intervals will move-transfer any zip files uploaded by the users from a[url].....From the info i gathered so far,
The daemon will be an .ashx generic handler.
The daemon will be triggered at the specified time intervals via a plesk cron job
The daemon (thanks to SLaks) will consist of two FtpWebRequest's (One for reading and one for writing).
how could i implement step 3?
Do i have to read into to a memory() array the whole file and try to write that in b.example.com ?
How could i write the info i read to b[url].....?
Could i perform reading and writing of the file at the same time? No i am not asking for the full code, i just can figure out, how could i perform reading and writing on the fly, without user interaction.I mean i could download the file locally from a.example.com and upload it at b.example.com but that is not the point.
View 8 Replies
Mar 23, 2012
have a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
View 1 Replies
Jul 1, 2010
I have a program that allows a user to select a program to run at a certain time for a specific amount of time all choosen by the user. Everything works with the exception of if my program has launched the other program, my program become non-responsive. Meaning I am not able to look at that window again. Not that one really needs too, because when time is up my program closes the program it opened, then closes itself. I just want to be able to see my program when the other program is running. how to do this and perhaps drop me some links, that would be wonderful. This is what I have coded, but like I stated there are no code errors.
[Code]...
View 5 Replies
