Application Accessing Databases And LINQ
Mar 31, 2012
This application uses a Microsoft Access database named Books to keep track of the books in a store. The database has one table named tblBooks. The table has five fields. The BookNumber, Price, and QuantityInStock fields are numeric. The Title and Author fields contain text. This application should allow a user to enter an author's name ( or part of a name ) and then display only the titles of books written by the author. Displaying the information in a DataGridView control; however, don't allow the user to add, delete, modify, or save records. I need to allow the user to specify the records he or she wants to select while the application is running. Also, i need to Add a text box and a button to the BindingNavigator control. The user will use the text box to specify the records he wants to select. The user will use the button to tell the computer to display the selected records. I also want to display the total value of the books in the store. I am not getting the BindingNavigator control in the component tray in my program I've included. Also I am working on the code for the display button but I need some tips. I am trying to complete this program and only expect guidance.[code]
View 12 Replies
ADVERTISEMENT
Jan 24, 2012
I use Microsoft Access databases for my big project but I find the performance is very hit and miss. I time the processes and sometimes there is some serious lag. Here is an example of the code I use:[code]I was told that this is a very old method of accessing databases, which doesn't surprise me since it's the same basic code I was using back in VB6 about 8 years ago.
View 39 Replies
Jul 6, 2010
I will start a new project, use the queries and dealing with databases using LINQ or SQl ,Which is better to start ???
View 4 Replies
Nov 29, 2011
how to search XML trees with LINQ using VB.net. I've found some very helpful posts for C#, but none for VB.net?How would I use LINQ to XML to get the value from example XML Getting a set of elements using linq How to get elements value with Linq To XML I want to get the inputlocation for the process where name = "MyProcess1" Based on the example links above, I have been trying code like this:
Dim inputLocation As String = xdocument.Descendants("Configurations").Descendants("process").First(Function(c) c.Element("name").Value = "MyProcess1").Element("inputLocation").Value
But the code is not returning any values. here is the xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Configurations>
<process>
[code]....
View 1 Replies
Nov 21, 2010
i am failing to write this code in vb.net 2005.
View 2 Replies
Jan 29, 2012
i wont to creat application, in wich with file location find tables and use them in my app. as databases
View 1 Replies
Sep 21, 2009
I am having an application in both windows and web domains.The web part of it have only limited features compared to it's windows counterpart.But for my case (an appointment fixing module which is done using both domains),I want both databases to update with the other database.
View 1 Replies
Apr 27, 2012
I want to design a application which can support two different types of databases same time e.g; when we install, it will ask which db it has to support and based on initial selection it should work with any db without changing anything in the application.In short it has to be developed keeping in mind that user may have either MS SQL or MySQL. It should support both.
View 4 Replies
Jul 28, 2010
I have a software called Portal sold by Synapse Inc. It is basically software which interacts with microcontrollers.I need only some of the features of that software for my use. So i am thinking of developing a GUI which can emulate those feature and interact with the microcontroller. Am i going in the right direction in starting to develop the GUI?
View 2 Replies
Nov 17, 2009
Does anyone out there have any experience programatically retreiving the lat/long from a GPS attached to a mobile PC?team I'm on is currently looking at hardware options--as the programmer who will eventually have to live with whatever is selected I was wondering if anyone out there has had experience writing .Net programs that interface with a GPS?
View 4 Replies
Mar 27, 2009
i have an application for which i have created help files which are html files. my pplication resides in a directory for which the system path comes out as c:Document and settingsvisual studio 2005crmscrmsindebugcrms.exeI have the help files put under the crms directory which has the bin as its sub directory.i.e. c:Document and settingsvisual studio 2005crmscrmshelpmain.htmlIn my application i would like to access this file and launch it in Internet Explorer. I dont want to hard code it as this will be deployed on a terminal server and therefore i would like to use a relative path. I searched on the net and could only find solutions that used Application.StartupPath or few others which point to the exe file.
I tried extracting the path before that and managed to get a substring which held contained c:Document and settingsvisual studio 2005crmscrmsTo this appended the helpmain.html, i tried launching the file as followsSystem.Diagnostics.Process.start("iexplore",s);where s, stores the appended string. This is the error i get, cannot open file at location:Document%and%settingsvisual%studio%2005crmsc rmshelpmain.htmlIts not liking the space in the path, is there anyway to resolve this.
View 4 Replies
Apr 17, 2012
I am looking for a VB.net book that strings me through the entire development process of an application (Prefered: WPF ,LINQ ,ADO). I have read a few books on OOP and VB.net with small code samples demonstrating the specific idea of the chapter.I think it would be really helpful if there was a book that programmed an entire application that uses a sql database (Northwind , Adventureworks).
View 1 Replies
Feb 11, 2010
I am using dotnet frame work 3.5. I need to access a file and reads the file which resides in a common path outside the application.
View 1 Replies
Jul 12, 2011
I have developed a windows application for my company. It is a multi user software and we are using sql 2008 as the database. The sql 2008 is installed in our company server. Within our LAN, there is no problem in accessing the software and its working pretty fine.
Now the problem is, some of the managers need to go out frequently(for business tour and all) and they need access to this software. The software is already installed in their laptops.Is there any way to access the database that is in our company server ???
We have few static IPs with us, is there any way i can use that here (Using NAT in the firewall or something)?
View 3 Replies
Oct 31, 2008
I developed a custom help system for my ACCESS 2007 application using Help Workshop. I wish to open this .chm file by a command button on a form but does anyone know how to do that?
View 9 Replies
Apr 30, 2012
I'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 Replies
Oct 6, 2010
I need to use linq in C# Windows form application working with .Net Framework 2 not 3.5 . I Know it may be some sort of stupidity to do that. but i need that for some special reasons. Can i import just linq libraries to my project by anyway ? or there is no way except for using 3.5 ?
View 3 Replies
Jun 11, 2012
I have a VB.NET application that used LINQ To SQL. Right now, I am using a single server and it is working properly. My problem right now is that my application will be used in another branch and with another server. I have to make the application able to change the connection string according to their server IP
View 1 Replies
Apr 2, 2012
i've been doing ADO.NET for a while but I would like to know if its posssible to use dao recordsets in VB.Net 2010 and where I can get tutorials and code samples to do database stuff like insert etc. I've tried to google but most of the code available is for vb6 I was going through some stuff on this link [URL]../bb243801%28v=office.12%29.aspx and i'd like to know if it works for vb.net 2010 or maybe theres something i'm missing. because the moment I put "Dim dbmyDB As dao.database" its been giving me the wavy blue line and i am now doubting if it works or maybe i'm missing some other code
View 1 Replies
Sep 9, 2009
If you are using an sql database with a vb.net application, does the user need to have anything extra other than the .net framework installed for the program to run? Meaning, if I simply compile the application, are there any extra steps I need to take to make this work?
View 1 Replies
Jun 30, 2010
Basically in visual basic 6 I could access word tables in existing templates with the code owordactivedoc.tables(1).select() where owordactivedoc refers to the active word document and tables(1) refers to the first table in the template.Trying the same code in VB 2003 just leads to errors. Secondly how do I access bookmarks or alternatively word variables.Furthermore how do one deploy web.services. For example the current program I am building is for another computer. Simply copying the web service to Inetpubwwwroot dont work because it is not picked up by the Internet Information Services program. I have to create the web service in vb2003 on the other computer change msconfig manually. Copy and paste the existing service vb file in the created folder replacing the empty vb file.
View 3 Replies
Jul 14, 2011
given this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
View 1 Replies
Aug 6, 2009
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 Replies
Feb 20, 2011
Ok, so I am on my last book of course material for college and this weekend I started making my own personal applications, stuff I can really use in everyday life, these projects also serve as a port folio for future employers
View 1 Replies
Mar 14, 2010
I recently moved over to a Windows 7 computer and I can't get databases to work with VB.net.Before I moved I used to do an Access database and connect it to VB through the ODBC thing. However, I don't have Access on this computer (open office) so I'm not sure how to create a database and connect it.I have tried to use the SQL Compact Edition that comes with Visual Studio but I not sure how to get it to work. Also would something like mySQL work with VB? I have looked at the mySQL workbench and like it, what else would I need to download to be able to use the databases created with it in Visual Studio?
View 2 Replies
Dec 14, 2010
I am trying to carry out a synchronisation of two databases: one on the server and the other on a local machine. So that even when they are not connected on the network, the local database can carry on accepting data but when the network is back on, the local database can update the server and the server can also update the local machine with data it accepted during the time when the network was off. by first comparing two tables in two databases and then if they are any differences the updating begins and i've since been stuck.
Private Sub btnCompareTables_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompareTables.Click
'dont know which arguments to put when calling this function
'How do i tell the computer which databases to compare
Comparing()
[code]....
View 1 Replies
Jun 7, 2011
I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))
datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below :
OrderID----OrderName----OrderCost--------Date
1----------A---------------54------------11/11/2010
[Code].....
note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .
View 8 Replies
Feb 5, 2010
What control(s) do I need to use and how do I use them? I am ,looking for tutorials and sample code too.
I'm working on a trivia game where the admin can remove and add questions to a database. [code]...
View 2 Replies
Apr 21, 2012
I am fairly new to programming, and even more new to using database objects. I am creating a program that will calculate a user's BMI, and that will let the user know how many calories are in a food that they choose. I found a database that has a bunch of foods, and each of their calories, so I am using that. I have the program set up so that the user selects each food from a drop down list. The user then adds each of the food to a list box after pressing a button. The program is then suppose to calculate all of the calories after the user presses another button to come up with the total calories. I got all the foods on the drop down list no problem, but now, I'm stuck on figuring out how to get the program to add all the calories for each cooresponding food. I have no idea where to start with it. I know that I'm going to have to create a variable to hold the total calories, but I just don't know how to get the calories from each food.
View 8 Replies
Feb 22, 2010
I am looking to add a local database file (.sdf) into my .Net Project, so i go right click on my project, click "Add" -> "New Item", select "Local Database" and rename it to what i want.I then click the "Add" button and get the following error."The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet assosciated with the file will not be generated."I am using Visual Studio 2008 .Net Framework 3.5.
View 4 Replies
