I have one DataGridView and im trying for it to show whats in my SQL database. But when i try to open it, it says the file is in use. I found out that SQL Express is using it, but it isnt even open! So how do i close the databse in the SQL Express?
View 3 Replies
I must have inadvertly messed up my data connection but not sure how to fix it. when I check the table adapters I can view data but when I load the app I get these errors and no data loads, how can I look at this log and make sense of how to fix this?
************** Exception Text **************
System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Only one <configSections> element allowed per config file and if present must be the first child of the root <configuration> element. (C:BungeAppsBunge Post InstallerinDebugBunge Post Installer.exe.Config line 7)
[code]....
I've had this working fine, but then one day I get the error message
"The connection was not closed. The connection's current state is open."
whenever I try to move from one form using a database to another.
This is the code.
Private Sub Children_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Conn.Open()
[Code]....
I'm currently patching an asp.net program where I need to be able to send an image to an SQL Server 2005 DB. It works fine when I use the asp:fileupload control, but the trick is that when the user deletes the image, I'm supposed to replace it with an image from the server saying "empty", in code-behind. I know how to open, use and save text files in vb, but I can't find any information anywhere on how to open an image / binary file in a similar manner so that I can use it as an sql-parameter on the update query. Below is an example of how easy it is to use a file from the fileupload control.
[Code]...
The program i'm running doesn't seem to open the database in stead I get this error:"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"ErrorCode=-2146232060Is there a way to fix this error.
View 6 RepliesI want that when the application exe file is running at that time the database associated with the application shud be closed....Means...I am using the .mdb file.
View 3 RepliesI have included a database in my program and it works well except that I would like it to open in sorted order based on column 1. It manually sorts by clicking on the column, but I would like it to sort on form opening
View 1 Repliesi am making a windows form for a company and i am in a mess in getting my database connection to my datagridview by clicking a button and my data should been shown in datagridview. datasets and connection strings.and even i want to print the document.
View 8 RepliesI create a database like this:
Sub Main()
Dim wrkDefault As Workspace
Dim dbE As DBEngine
[code].....
To open a pdf file in my vb.net application I have used the following code. This is working fine while running from code. But when I am trying to package it through setup project and run in the installed application, file not getting opened. I am adding my UserGuide.pdf file inside Database folder in Application folder of setup project.
Try
Dim lStrHelpUserManualPath
As
String =
""
lStrHelpUserManualPath = Application.StartupPath
[Code] .....
I want that when the application exe file is running at that time the database associated with the application shud be closed....Means...I am using the .mdb file...is there any way that when the application starts, if the user has opened the .mdb file then it shud be closed and also that when the application is running no one shpuld be able to open the .mdb file....
View 5 Repliesi am making an application for which i need to know how to open a url using vb.net using the "POST" method and also pass parameters to the url.
[Code]...
I have created a .wsf file which on opening executes some functionality. I need to open this file in vb for my project to work, but i don't know how to do this.
View 2 RepliesOkay i know this is a noob question but what is the code for opening a program through visual basics 2010?
View 1 RepliesWe have implemented the following code in VB6 a year back and now we are trying to implement using Visual Basic 2010 Express.The req is , i need to open an excel which is placed in C: and minimize it and later we are searching cell by cell.
Private Sub cmdScriptsSearch_Click()
'Declare variables locally to search for scripts in the Excel
Dim vtemp, vSimpleCount, vComplexCount, vMediumCount As Variant
[code]....
but i am not able to use SET function
Currently I am opening a file via this
Dim myStreamReader As System.IO.StreamReader
Dim SourceString As String
myStreamReader = System.IO.File.OpenText(txtInputFilename.Text)
SourceString = myStreamReader.ReadToEnd()
Sometimes the file I am opening is quite large and I am wanting to have a progress bar displaying the progress as I am opening/writing to a file.
Okay I am trying to make a class library that takes information from an excel file and puts it into an access database, but I keep getting this dumb object reference error that always screws me over. Here is my
vb
Dim xlApp As Excel.Application Dim xlWbs As Excel.Workbooks Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim xlRange As Excel.Range Dim strExcelPath As New String("C:UsersAjDesktopTax_Research_Template_2010_-_Excel.xls") Dim accConn As String = "C:UsersAjDesktopTaxCert_be.accdb" Dim xlDT As New DataTable Dim xlDR As DataRow = xlDT.NewRow Public Sub XLMain()
[Code]...
Creating a new database in a Windows Forms project (done according to one of the MSDN tutorials) results immediately in a "The event log is full" error.The database exists as an item in the project, but cannot be opened or configured (i.e.,it doesn't exist really). newly installed MS SQL Server Compact Edition,This is a new computer (though fully updated), and to my knowledge no other versions of SQL server are installed.I note that someone else has contributed a message about the exact same problem (according to a preview in the MSDN search results page), although for unknown reasons clicking on the item does not take me to that message.
View 1 Replieshow can i open a folder with Visual Basic, preferably with a Message Box? e.g. when the user clicks "OK" on a message, a certain folder will open.
View 3 RepliesI have done some work in VB 2010 for school and the schools computers have VB 2008. is this going to be a problem? if so how can i fix it so i can open the work in vb2008 because thats where it will get marked.
View 2 RepliesAm writing a simple application which can write a to pdf,doc,xls and access files. so far it can write to word.i also want it to be able to navigate a hard disk and open these files using filters. i was using this code to write to the files
[Code]...
or saving VB 2010 project for VB 2008 use
View 2 RepliesIs there a way to delay the start of a text file? I am using this to call the TXT file after clicking a button: (opens txt file)
Process.Start("text.txt")I was wondering if there was a command to delay the TXT file from opening for a number of seconds?I use this to delay the Splash Screen: (delayed 5 seconds)
Threading.Thread.Sleep(5000)Is there something similar for TXT files??
I am making a simulation of windows loading,Ive made it show the startup screen (startup.vb) and ive got the login screen (login.vb), how can I make it stay at the startup screen for a few seconds before using the startup.show() command.( if I can use that command?)
View 4 RepliesWe have created a dll to convert an excel spreadsheet to a csv file. At the moment we open the xls file, an eror occured (file doesn't exist / is used by an other user)
Used
Dim excel As New Microsoft.Office.Interop.Excel.Application
Dim wb = excel.Workbooks.Open("d:my.xls") '<<<<<<<<<<< not possible to open
wb.SaveAs("d:my.csv", Microsoft.Office.Interop.Excel.XlFileFormat.xlTextMSDOS)
wb.Close(SaveChanges:=False)
[code]I'm trying to make it when the button is clicked it opens the txt file that is in the resources.Any idea on how to fix? I keep getting this error.Value of type 'String' cannot be converted to '1-dimensional array of Byte'And another question I had was, How do I get it to open lets say...Open the txt file IN it's own folder?
View 2 RepliesFirst time user on here, basically have been teaching myself VB and I enjoy it quite a bit! Basically I have a program now that has the File Drop-Down Menu with Open and Save options. I want to open and save in a .txt format. The open command will need to place the text in TextBox1 ; and the Save command will need to take the text from TextBox2 and save it as a .txt. I have gotten to the point where it will save it to a specified .txt file, but I would like the user to be able to "browse" the computer for where to open from and save files to.
View 4 RepliesI cannot find any up-to-date information on the internet on how to successfully open an excel document from a VS 2010 application.
What imports/declares are needed to open, save, close and (if you know) how to enter current values of variables into certain cells in the Excel document from a Visual Studio 2010 application?
I am extremly new to this concept of aps.net and vb. all the tutorials I see are c# based or very basic for vb. What I have is a contact forum with some basic information. I got the whole "check if the user has input information correctly down pat how ever Its this whole, connecting to a database (sdf) if in another vb file ands calling that method into aspx file and proessing forum input to say "take this, insert into bla..." I come from java, JSP and J2ee bak ground where its not that diffrent and I dont have all week to read books and take baby steps. I have until tuseday morning to finsih this. Right now I am as far as forum validation....
[Code]...
Dim excel As New Microsoft.Office.Interop.Excel.Application()
Dim wb As Microsoft.Office.Interop.Excel.Workbook = excel.Workbooks.Open(txtFileLocations.Lines(w))
Dim ws As Microsoft.Office.Interop.Excel.Worksheet = TryCast(excel.ActiveSheet, Microsoft.Office.Interop.Excel.Worksheet)
when the program tries to opens an excel file, it always throws me an error "Office has detected a problem with this file. Editing may hard your computer" and my program crushes.......The problem appears on the SECOND line, on DIM wb...blahblah.. i went to the office and unclicked the "protected view" checkboxes.. but it still throws me those errors. my guess is that the office i have in the computer is not the same as the one that my program uses to open excel files (i mean, i loaded/imported some excel.dll files in the program so i guess that will be the one) But how do i make the program not care if the excel file is "potentially dangerous"?
