what is the connection string when the database copy paste in debug folder?I have a code connection string it's work but when i try to other computer cannot connect in to the database.
Try
If sqlconn.State = ConnectionState.Open Then
sqlconn.Close()
End If
[code]....
I have a table I created in SQL Server Management Studio. I had to create it there because I needed to use a function for an alpha-numeric ID column that increments itself. I then exported the table, but had to use my local server. Now, in visual studio, I have the local server connection that contains the table I want to copy to a connection for a remote server. I can right-click and select 'Copy', but I can't right-click and 'Paste' into the database I need.
View 2 RepliesAny tips on what is making the project so slow. I have about 5 report server projects, and about 3 other projects. One for My Generation and another Base Class project with one form. My machine is a 2.0 Intel with 1 gig of ram.
Some times hitting enter causes a huge delay or selecting a chunk of code (10 - 20 lines) and doing a ctrl-c causes a huge lag and then again when I do a paste. Trying to debug by step thru no longer lets me do edit and continue. I get the error "Cannot currently modify this text in the editor. It is read only"
Compiling a 6 meg project after simple changes takes a minute or two to come up.Is it a sourcesafe issue? References? Mcafee Anti virus?
I'm writing a small app to collect IE command diag. The problem is it's not waiting till the process finishes and it's errors out in the next line. My goal is to copy the log and paste it under a folder in Desktop
Try
Process.Start("C:Program FilesInternet Exploreriediagcmd.exe")
My.Computer.FileSystem.CopyFile(USERPROFILE & "DesktopIEDiag.cab", USERPROFILE & "DesktopW8IEDiag.cab",
Microsoft.VisualBasic.FileIO.UIOption.AllDialogs,
[code].....
I want to paste a file from the clipboard that has been copied from a compress folder using VB.net. By examining the clipboard, I see there is a FileGroupDescriptorW which seems to contain some information about the file. But I have not found how to use the information to grab the file and paste it.
View 1 RepliesWhat is a good approach to managing a debug and release connection string in a .NET / SQLServer application?
I have two SQL Servers, a production and a build/debug and I need a method of switching between the two when my ASP.NET application is deployed.
Currently I simply store them in the web.config and comment one or the other out, however that is error prone when deploying.
I encounter some problems when doing coding of backup file by copy and paste the database(Microsoft Access File) to another directory. Example, textbox1 will show the path of file that I want to backup, textbox2 will show the path I want to copy to. I need 1 button for browsing the file and another button for make confirmation of the path that I want to copy to.
View 2 RepliesI have a small copy/paste type of program. You put text in the boxes, click copy and it copies it to the clipboard. I have a text file attached to format the text when it is copied. what I want to accomplish is...If I don't fill in every single textbox with text, I don't want that particular field to show when I paste it. Example, I have the layout like below on the text document.
textbox1.
textbox2.
textbox3.
No matter what, when I click copy, the text document is going to copy textbox1,2,and 3. If I only put text in textbox 1 and 3, I don't want it to copy textbox2 if its empty.
I have a text box called TxtSearch on my form. The value entered should always be numeric before the search can be done if its any other data type the following Message box is give - Only a numeric value is allowed in this field", MsgBoxStyle.Information, "GCPM.. (Code shown below)
Private Sub TxtSearch_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TxtSearch.KeyPress
If Char.IsDigit(e.KeyChar) = False And Char.IsControl(e.KeyChar) = False Then[code].....
Now, when you copy and paste a String value on the textbox - TxtSearch the KeyPress doesn't work. The TxtSearch doesn't prompt the message and when you click the Search Button the application crashes - dsiplaying an error converting data type varchar to numeric.. What I want to do is if someone uses the copy and paste tool to enter the value in the textbox- TXTSearch and there is a datatype not numeric the message prompt is called ..
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 a script that checks a version table from one mdb (server) and compares it to the same table in another mdb (user folder), if the version number is mismatched it needs to replace that file from the server, to the user folder. The problem is, how to get the OLEDB connection to the user folder since, the folder destination is
E:Configurator & UserName & Detail2004.mdb
How to set this up?
Here is my code:
Dim UserName As String = Environment.UserName.Substring(Environment.UserName.LastIndexOf("") + 1)
Dim connectionString2 As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:Configurator" & UserName & "Detail2004.mdb"
Dim con2 As New Data.OleDb.OleDbConnection(connectionString2)
Dim cmd2 As Data.OleDb.OleDbCommand
Whenever I create files in VB.net, the results go by default in the bin/Debug folder. I would like them to go in bin/Debug/Test without having to write the actual location, since the project folder may change from user to user (i.e. they don't place their project in the same folder I do).
View 8 RepliesThe fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
View 2 RepliesHow 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"
in VB6 the Copy/Cut/Paste etc. feature could be setup with "AutoVerbMenu". In .net 2008 this feauture is not available as far as I know, thus I configured the functions manually.
Everything work so far as expected for my first RichtTextBox.
[Code]...
In my Sheet1, i will be having a data From column A to F and in Colunm D (The Red one) it will be empty, The data can be 10 rows or might be more the 60 rows sometimes and in Column I i will have some more Data.
Now i need a macro where in sheet 2, Automatically the Lines from Column A to F should get pasted and it shlould take the Column D from column I. Once the Total line are pasted the it should go for next list of Column I.
Exm: IF i have 50 lines in Column F and in Column I i have 5 lines Then i should get the result of (50x5=250 lines) 250 lines each of 50 as per Column I.
How do you copy (rightclick) some columns from a gridview (asp.net) and paste it in excel? When I try I get one line with all the data pasted in excel, and it should be in the same columns and rows as the gridview.
View 3 RepliesI have a form text box that populates a cell in the excel sheet.I then need to copy that value and paste it in the same column. I do not know how to define the end Range since it is varible.
This is how I am getting the info into the open Sheet.
Dim Maildate As String = maildatetx.Text
wbTemplateSAS = exTemplateSAS.ActiveWorkbook
wbTemplateSAS.Sheets("SAS").Range("G9") = maildatetx.Text
I have a datagridview and I would like to be able to select an entire row by clicking on the row header column, hit CTRL+C, then put the cursor in the next row, and hit CTRL+V to paste the contents.
Right now, it pastes all of the contents into the first cell of the new row. If I paste the contents to the clipboard, I see them correctly and they are tab delimited.
Once I get this working. I would like to be able to copy and past multiple rows at a time.
FYI, I am not using a data source at all. Most of the rows are combo boxes where a user is selecting values. There is no database connection.
I have an problem with copy and paste between 2 richtextboxes part of the problem is if I new the 2nd Richtextbox actual name I could paste it using rtf format because I have so many of them I use a loop to go through the controls until I find the right one using typeOf control. The problem is with that that it really doesn't act as a richtextbox. See code below.
Dim RTB As New RichTextBox
RTB.Name = sender.Tag
For Each itm As Control In EnumerateAllControls(Me)
[code]......
How do I access cut, copy, paste in a WebBrowser control?
View 4 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 RepliesWhat is the connection string for connecting MS Access 2010 (.accdb) database in VB.net.
View 3 RepliesOr there's another way to make it, without adding a Connection String?
View 3 RepliesMy Ms-Access .mdb file is on my website. It is in the App_Data Folder
The current connection string is:
OleDbDataAdapter Da = new OleDbDataAdapter("Select * from SerialNo",
new OleDbConnection(@"provider=microsoft.jet.oledb.4.0;
data source=ftp://ftp.WebsiteName.com/App_Data/SerialNo.mdb"));
Where am I making a mistake in above connection string?
Note: CRs added in the code for better readability
Is it possible change the connection string to a different database when the user changes the database they are using .i have a working program atm but i want to be able to change the connection with out having to change the code. the databases contain information from different years but all have the same tables queries etc.
View 2 RepliesMy query is not the straightforward connection to MS Access.I am using a third application that places all data in an Access database BUT recently they changed the database so that it doesn't end in '.mdb', instead in another suffix: '.accdb'.The database is still an Access database but I cannot connect to it using the connection strings:[code]Previously I was able to use the second connection when the database name ended in '.mdb' (Database Name.mdb).
View 1 RepliesI have an application that will be called by a database(this application is called from an access shell that uses SQL Server Tables), my question is do I need to provide a connection string to write to the database or since it is already open I can just pass the insert statement. If I am to provide a connection string do I use OLEDB JET 4.0 or ?
View 4 RepliesI have just written an application for myself and a few other users to use .rdp to connect to a number of servers, by clicking on the appropriate button. In the full version of the program I have two sets of connections one for when we are inside our vpn, which uses local ip addresses and DNS names; and the other which uses the external IP addresses and DNS names.This works quite well; if the user has stored credentials on their pc for the connection they connect straightaway; and if they don't the .rdp dialogue opens up with the server name/address filled in, ready for them to edit the rest of the required information.The problem for me is that this means I have to code 43 different Private Subs and then link the buttons; and I was hoping that instead of individually coding each connection, I could get the users to:Select by an option button whether the connection was internal or external
View 3 Replieshow to find connection string of any database or any server like, access or sql or Oracle?ans:-to find connection string.first open the new notepad.don't write anything it it.just save any side like my document,or Desktop with any name and give it's extension. " UDL ".after there will be one PC type folder will be created. double click on that folder and go to first tab that is Provider.select your provider like Access, Sql etc. and go to Next tab that is connection. if access then it will tell you enter database name or you can locate your database .mdb file and if it is sql then it will ask you your server name, authentication and database name. select it and click on text connection it will give message connection is OK.then close the file and further open that file with notepad you will get your connection string.
View 2 Replies