Basically for normal select queries from my database I have no problems as I would put the following and then bind it to a controller to display the iteam, however now I am trying to query sum of a field from the database, but I think it should be different as It's giving a Nullable value:
SELECT SUM(PointsRedeemed) AS tAward
FROM [Transaction]
WHERE (BusinessId = ?) AND (CardNo = ?)
[Code]....
querying a remote Access database! We are currently using this because thus far we have failed at hooking up a sp_linkedserver. I feel like it's a terrible hack and want to be done with this whole network mapping business once and for all!
[Code]...
I am trying to search for the occurence of a string within MS Access database with 1000000 records using VB.Net. The program does not respond once it is run or it is taking a very long time. However, if I reduce the size of the database the program runs.[code]...
View 2 Repliesthe remaining code for my vb.net project? In my Project, I have a table name tblBatch that has a field name btchGravel. Since in my project, a field name gravel has more than 10 inputs from the 10 textboxes in my main form. I manage to save it in this manner:
'Save the textboxes in a single string, separated by comma
Dim GravelLine As String
GravelLine = txt1G.Text & "," & txt2G.Text & "," & txt3G.Text _
[code]......
I'm trying to open a connection and create an SQL statement with two different tables in different Access DBs. Is this possible? I'd like to join the tables in a query.
Is there a great advantage in splitting somewhat large Access databases? Or is it best to just create a large access database with many tables?
I am trying to autocomplete a Textbox using the AutoComplete Extender. My Web Service is as Follows:
Code:
Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
[Code].....
I'm looking for the most efficient way to query an Access table from VB.Net. I think throughout the life of a run I'm going to need to query the table ~1,000,000 times. I'm using Access 2003 to hold my data. What I've been doing so far is this:
[Code]...
I am querying the MS Access Database to display the results in a datagridview. This is my
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb"
Dim SQLString As String = "SELECT * FROM Groups where Selected = Yes"
Dim OleDBConn1 As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConnString)
[code]....
The variable Selected from the query statement ("SELECT * FROM Groups where Selected = Yes") is a Boolean in the MS Access Database. However, this statement returns empty result even though most of the values for Selected are Yes. In the access database however, if I enter a 'Yes' for the value of Selected, it shows up as -1 and 'No' shows up as 0. So I even tried changing the query statement to ("SELECT * FROM Groups where Selected = -1") and also ("SELECT * FROM Groups where Selected = 'Yes'") but none of them work. Can you please help me fixing this query because I can't change the database?Also if I change the query statement to ("SELECT * FROM Groups"), then all the data shows in the datagridview, however, the values for Selected column do not display. Instead I see check boxes and I can't click them. How can I display the values correctly?
I have an access database with a table called [yearly stats cape town] This table has the following relevant columns to my query. [CASE NO], [B/W/C] [1ST APP MAG CRT].The goal of the windows form I am doing is to return the total number of unique case where [B/W/C] = C (in custody) and [1ST APP MAG CRT] contains a date longer than 6 months ago from the current system date. To determine the total amount of cases I use the following query.
SELECT COUNT(*) AS [CASE NO]
FROM (SELECT DISTINCT [CASE NO] AS [CASE NO 2]
FROM [YEARLY STATS CAPE TOWN]) derivedtbl_1
I`d like to do a query to a SQL server database using the statements like "SELECT...FROM...." an so on. Then I`d like to save results of the query to an array or other variables. I`d like to handle the data of the query results "manually". I don`t want to use the datagridview and tableadapters and so on which are created when I drag a table from the datasources window to the form. is the ADO.NET and datasets the right tool at all? If yes, I believe these are the first steps needed:
- create a connection string
- create a connection and open it
- create a dataadabter
- create a dataset and populate it with the dataadabter
The first problem is the connection string. When I create a connection to a new data source in datasources window, a string is created and saved to some configuration file. Can I use it and how?
vb
Dim conn As New OleDb.OleDbConnection(ConnStr)
conn.Open()
[code].....
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 RepliesI have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesIErrorInfo.GetDescription failed with E_FAIL(0x80004005).I get this error when trying to send a query to a database. Its an access 2000 DB. Google suggests the error indicates that I am using a vb keyword as a field name or table name. I have checked with these here and can't see anything that matches.
View 6 RepliesI'm using VB.net for a project i'm building for a friend. He has access to data on all the schools in our country and also data on the local area Authorities which run these schools. I have a database with two related tables; 'TBLlocalauthority' and 'TBLschools'. Each localauthority can have several schools, but each school can only have one local authority.
[Code]...
Is there a particular class in .NET available that will allow a user to query IIS to see what websites are running on the local server? I would like to try to write a simple program that programmitically lets me know which websites are running in IIS along with some basic information about them. Can this be done in VB?
View 3 RepliesWhenever I have
Dim catID as integer
And I use this in a query like this:
cmd.CommandText = "select * from categories where parentid='" + catID + "'"
I get:
Conversion from string select * from categories where p to type Double is not valid.
Why is it so?The parentid datatype in sql is integer.
My form has a DateTimePicker and a DataGridView on it. I need to have it query a SQL Server DB and return the table to the DGV. The query is to search the Date_Joined field for date less than the date that the user input with the DTP. With the code below, my DGV is populated with all data and not the filtered data I need. I also have added a Go button for the purpose of execution instead of using the ValueChanged sub for the DTP.
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
Dim query As String
'dtpDateJoined is a DateTimePicker on the form
[code].....
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
Is it possible to re-use a DataTable in .net? Here's an example from code-behind:
[Code]...
I have some sql statement error while querying the DB and to display the result on a data grid view. Could someone check the codes below and let me know the problem with the codes.
Dim cm As New System.Data.OleDb.OleDbCommand
Dim rd As System.Data.OleDb.OleDbDataReader
Dim Conn As OleDbConnection
[code].....
I am trying to create a stock scanner which allows users to filter stocks based on multiple criteria that they select. Like the following example with 2 criteria:
Criteria 1 Filtered Result: StockA, StockB, StockC, StockD
Criteria 2 Filtered Result: Stock B, Stock C, StockE, StockF
SCANNER RESULT: Stock B, StockC (ideally this result would be displayed in a GridView)
[code]......
Given the following XML file:
<users>
<user name="admin" password="foobar" roles="Admin,Guest" />
<user name="guest" password="foobar" roles="Guest" />
</users>
How do I find a specific node? In this case I want to find the node that has its name attribute to be "admin"
Dim authGroup As XElement = XElement.Parse(myXMLDoc.OuterXml)
Dim foundUser As IEnumerable(Of XElement) = From i In authGroup.Elements Where i.Attributes("name") = "admin" Select i
[Code].....
good afternoon people, i got a problem here on my program, i need to query from a different tables in database but it gives me error, here is my code
[Code]...
I have a DataTable filled with employee names and hours. I want to query that data to make a list of all the unique employees and the total hours for each, but I don't know how to do that. If I were to query the database directly I would do something like this
View 6 Replies(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE: