I built a database from an .sql script file in Microsoft SQL Server 2008 Express Management Studio.Now, I need to connect an application I'm developing to this database. So in Visual Basic 2008 Express (that's what I use) I go to:
Data-->Add New Data Source-->Database-->New Connection
In the dialog which pops up (name: Add Connection) I set:
Data Source = Microsoft SQL Server Database File
[code]....
When trying to create a new data source to a sql database (database up and running with no problems) I get the following error message when testing the database connection
Quote:
Unable to open the physical file "". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
I am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
I am usinf VB 2005 Express and I an trying to connect to a SQL Server 2005 Express Database using the "Add New Data Source"I keep gettig the following error.Unable to open physical file "C:Program FilesMicrosoft SQL Server MSSQL.1MSSQLDataHeartland.mdf. Operating system erro 32: "32(The process cannot access the file because it is being used by anither process.)"An attempt to attach an auto-named database for the file C:Program FilesMicrosoft SQL Server MSSQL.1MSSQLDataHeartland.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
View 2 Replies[Code]....
am getting error: End os statement required
When I am trying to connect to database from VB.net, I am getting error.
This is my code.
Public g_Conn As new SqlClient.SqlConnection
With g_Conn
.ConnectionString = "user id=sa ;data source= CCTSRV8; " & _
"persist security info=True; " & _
"initial catalog=pubs ;password=mrwizard"
.Open()
End With
I am getting system.data.sqlclient.sqlclientpermission error.
I am using Visual Basic 2008, and SQL Server 2005. I have a single-user client-server app (i know that sounds stupid, but its for future expandibility and also the fact that documentation was easier to find for SQL server than Access files).The app is basically a medicals records system.
In one of the tables, called 'visits', it stores the dates on which each patient visits the doctor, among other things like symptoms and diagnosis. Another table stores all the patient names and IDs along with other details, and a relation has been set up between the patient ID in the patients table and the visits table. So i dragged the visits table from within the patients table (to get only the visits for that particular patient), and dragged it onto the form to make a datagridview. However, the datagridview didn't seem to recognise MS SQL server's smalldatetime format, and tried representing it as a picture. When i changed the format of the column to text boxes, it gave me a type mismatch error (Inconvertible type mismatch between SourceColumn 'VisitDate' of DateTime and the DataColumn 'VisitDate' of Byte[].) That means, for some reason, it is trying to convert the smalldatetime data to byte before it shows it, which is leading to the error. How do i fix this?
Also, I remember seeing some option for using completely custom column types in the datagridview, but i cant seem to find it now. The options in 'Edit Columns' are very limited, but i would like to set it to a masked text box, or something with a fixed format. Can someone recommend a good column type for representing dates, and how to make the datagridview show that kinda column?
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
Does anyone know of any open source ETL applications written in either vb or c#?I am looking for some or all the features below:
* Read text files and have the ability to split files.
* Suppress records for failing validation rules.
* Transform values.
* Output the resulting data source to either one or many files and or database tables.
[code]....
I have a VB.NET WinForms application. While adding a new data source, it is giving "An item with the same already been added" on the Add Data Source wizard form.
The application does not contains any existing data source.
What could possibly be causing this error, and how might I go about resolving it?
When trying to add a new data source (connect to database with .mdf extension stored on my computer)verything goes well until I get to he step giving me the option to save the connection string, then I get the following error message: "An unexpected error has occurred. Error message: Could not load type 'Microsoft.VisualStudio.DataDesign.SyncDesigner.SyncFacade.SyncManager' from assembly'Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage, Version=9.0.0.0, Culture=neutral,PublicKeyToken=b03f5f711d5013a'. I am taking a course online in Advanced Visual Basic and most of it involves working with databases. If I cannot get past this error, I cannot do any of theassignments. I am using the free 90 day download of Visual Studio 2008 and will buy it before trial expires, but only if it starts working and stops generating error messages
View 4 Repliesthe next issue, that is only shown when the server is a Windows server 2008 machine , this is the information that I've found
[Code]...
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) error: 26 - Error Locating Server/Instance Specified.
This error is doing my head in.I have a client running Windows XP SP3 logged into a domain. It is running MS VB 2010 Express to access the server.I have a Server called dataserver3 which from the client, I can do a start, run "\Dataserver3" and it comes up and yes I can browse to the Test.mdf file, which is a new database that was created using MS SQL Server 2008 R2 Standard edition.
[Code]...
Modifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
how to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
can data reader be used as a data source for a grid control?
View 5 RepliesI have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
I use this code to get the source from a URL:
Public Function ScreenScrapeHtml(ByVal url As String) As String
Dim objRequest As WebRequest = System.Net.HttpWebRequest.Create(url)
Dim sr As New StreamReader(objRequest.GetResponse().GetResponseStream())[code]....
But what if the URL is[url].... or something else that doesn't exist, how do I handle the error? The program is crashing right now.
I recently switched to V.Studio 2008 and using VB. I can not find in the data toolbox the connection and data adapters. Should I do something else to make this appear so I can drag them in my form.
View 2 RepliesI have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1
[code].....
I am currently using vb 2008 and access 2003 as back end database. I am trying to import excel data to a data table. my excel and access table header & columns are same. I was trying to do this.........
[Code]...
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
I had someone develop me an app in visual basic, and I am having a tough time getting it to run properly on any OS. I have Windows 7 64 bit.The program runs, but anytime I click a button this error pops up and nothing happens... Any idea what the problem is? I can't get ahold of the developer anymore See the end of this message for details on invoking ust-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
[code].....
i have a probleam with my report , i try to display my report using report viewer but it show an error :The source of the report is not definition has be not specified. i am using visual studio 2005 and databse sql 2005.
View 1 RepliesI am getting an error saying that I don't have for For, for my Next statment. It looks like it doesn't even finnish the initial compile. What is going on?
Code:...................