Trying to add a new data source, I create a new connection string and attach an Access DB to it, pick which tables I want, and it either gives me an error saying it can't create the data source or it creates it and puts this garbage in the data set designer:[code]
View 2 Replies
New to both Access 2007 and VB 2005. Tried to create a data source with access in vb and kept getting an error about instantiation. Removed Access 2007 and loaded 2003 and no problems.
Even tried to create a mdb file with a save as 2003, did not work.Is there a way to use Access 2007 with vb?
How to create a crystal report in vb.net 2005 using data source wizard.
View 1 RepliesI have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesI 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 RepliesWhen I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 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'.
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 want to add this to my visual studio. [URL]. I understand I should ad it like normal custom dll. but how do i get the dll file from the zipped source.
View 2 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)
Is there any way to create a new setting from source code instead of having to create the setting first and editing it later?
View 5 RepliesReasonably experienced programmer but newbie question on VB Express 2010: I have coded my 1st attempt at my project. I now want to save the work I have done and branch the code but be able to go back to what I did before if I screw up. What is the best practice? Do I get any help from Visual Studio. I could save a copy of the code in another directory or different file name
View 2 Repliesi want to create an application to store all the source code snippets and help information(as i keep learning vb.net) to refer to when i forget or need help.i came across this software.., [URL]
i want to create a similar application. how do i go about creating it? does it require a database? if yes, what kind of database?
I 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].....
My applicaiton makes use of the Event Log to log exceptions and Informational messages, however when logged in as a Standard User who has limited access, I am receiving the Exception[code]...
I understand that the Event Source cannot be found in the log I am writting to (Application) and the application is attempting to create the Event Source but before it can be registered all Logs need to be reviewed to make sure the Event Source isn't already in use.
My question is how should I go about creating an Event Source that can be used by Standard Users? The application will be operating on a corporate network whereby we lock down all users to the least required privellages.[code]...
what tools do you use to create programming flowchart/documentation from VB.NET source code? There are absolutely no comments/documentation at present. I am a beginner, i.e. I tried Sandcastle but it is way over my head and could not get it going, not even with GUI.Fatesoft's CodeVisual To Flowchart is OK but it is almost the same as the code and I still don't understand the code.
View 3 RepliesI need a bit of advice. I am working on my project with the listbox. I know how to create a source to get the strings from the text file using ReadLine method, but I have no idea how to split the strings in the text file by on the third commas and ignore the other strings while select with the matched strings on the listbox for each row.Here it is an example listbox Here it is an example items on the listbox
random item 1
random item 2
random item 3
random item 4
random item 5
And here it is an example text file.
example strings one, any strings 1, any random strings 1, other strings 1, final end of strings 1
example strings two, any strings 2, any random strings 2, other strings 2, final end of strings 2
example strings three, any strings 3, any random strings 3, other strings 3, final end of strings 3
example strings four, any strings 4, any random strings 4, other strings 4, final end of strings 4
example strings five, any strings 5, any random strings 5, other strings 5, final end of strings 5
The listbox is display the list of an example items, so if I select the "random item 1" item on the listbox, it read the strings through in the text file on the first line to get the strings on the third commas in the same line which it is (any random strings 1) to split it while ignore the other strings (other strings 1, final end of strings 1) that come fourth and fifth commas. So, if I select the "random item 2" item on the listbox, it read the the strings through in the text file on the second line to get the strings on the third commas in the same line which it is (any random strings 2) to split it while ignore the other strings (other strings 2, final end of strings 2) that come fourth and fifth commas and so on...That is what I am trying to achieve by select the each listbox item to get the correct strings for each line in the text file that come on the third commas while to ignore the other strings.
I am creating a database for Employees. In that I have some issues. I am trying to bind my data using data source. In the list box properties I set
lstemp.Datasource = Employeedatabase
lstemp.Displaymember = "EmplyeeName"
lstemp.Valuemember = "EmplyeeId"
I want to get my employee Id for displaying data in text boxes. How can get the data of the highlighted employee name in the list box to text boxes
I am creating a database for Employees. In that I have some issues.I am trying to bind my data using data source. In the list box properties I set
lstemp.Datasource = Employeedatabase
lstemp.Displaymember = "EmplyeeName"
lstemp.Valuemember = "EmplyeeId"
I want to get my employee Id for displaying data in text boxes. How can get the data of the highlighted employee name in the list box to text boxes
I am doing project in 2010...I am trying to add new data source.
[code]...
I have a vb.net windows form app that I am deploying as using the visual studio deployment project. The app needs to write event logs to the application log in the event viewer. For reasons explained here I need to create the event source during the installation process. Something like this to run as part of the installer
If Not EventLog.SourceExists(My.Application.Info.ProductName) Then
EventLog.CreateEventSource(My.Application.Info.ProductName, "Application")
End If
That code needs to be run during the installer with elevated privileges. So my questions are:
How do I execute that code above as part of the installer? How do I get the installer to do the UAC prompt to allow that code to run as part of the installation?
Iam try addingnew data source by using the Wizard but it gives me massage error (unexpected error has occured)
View 11 RepliesI'm creating a gridview using an objectdatasource and it works fine when pulling all records. But when I want to use the selectCountMethod the grid shows no values. I Step through the code and my getInvoices (gets the requested data) returns data and the getInvoicesCount (gets the total record count). But then when I go through the rowdatabound of the gridview there's nothing in there and no data displays. Here is my code to set the objectdatasource. Any reasons why it wouldn't work or something special that needs to be done for getting the selectcount to work? [code]
View 2 RepliesI used to use listboxes, but now I use listviews. I can't use data source anymore, and I am looking for an alternative.
View 4 Repliesam using visual studio 2008 professional edition and MS SQL Sever express 2005 SP2.i clicked Data then Add New Data Source choosed Database then click Nextwhen i clicked on New Connection the Data source configuration wizard disappears.
View 14 Replies
