I have Access as my back end. Student is the database name and its path is c:Projectstudent.mdb And am having few tables in it. When i click a command button in vb.net a new table must be created in the path mentioned. And it should have the fields I declare. What s the query I need to use ? Is it possible to do like that ?
View 2 RepliesWhen Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 RepliesThe database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
[Code]...
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
I am trying to automate an access table make query through vb.net.It works fine the first time, but the second time it fails because the table already exists.Of course i can delete the table through code by it's name, but i want to let my .net-application find out wich table must be deleted. Or maybe there is a solution that doesn't fail with the error "table exists" without first deleting it.[code]
View 1 Replies[Code] my issue is that now i need two cases, first i need a query that will return the date created and modified of the table and i also need to know if its possible to query a list of table names in the database ordered by date created but that have a certain thing in their names. for example the database contains the following tables: [Code] and what i need the query to return is the tables that contain "Data", settings and employees are for the other functions of the program. so the query should return the 4 data tables in order of date created. but i have no idea how to go about doing that in the query, does anyone know how this is done?
View 6 RepliesI really need your help. I want to query in a table in MS SQL using a data in another table.This is the query I've constructed : "SELECT TABLE1.FIELD1,TABLE1.FIELD2 FROM TABLE1, TABLE2.[code]
View 1 RepliesI have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesI'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write the code to update different datagrids. I tried searching the forums, and I can't find anything that fits into the way I wrote my code. I have an update button that I want to use to save all the edited data in the form. Here's my code so far:
Public Class Form1
Private Sub Blsys_systemsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
Me.Blsys_systemsBindingSource.EndEdit()
[code]....
I am using visual studio 2010 to create a form where you can edit,delete, or insert data from an accessdatabase. When I try to run the form in a web browser I get the error "Query input must contain at least one table or query." I believe that the problem lies with my code/syntax but I am unable to determine the cause of the problem.
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/database.accdb" SelectCommand="SELECT * FROM [database]"
DeleteCommand="DELETE FROM [database] WHERE ([EmployeeID] = @EmployeeID)"
[Code].....
I am able to add an existing MDF database to my project and apply it to a form with the appropriate binders and navigators and such and it works fine. I can hard code queries that are very successful. My question is this: Is there a way to add a textbox to the form, where I could enter a valid query that would execute on a button click event? It seems like I should be able to do so with SqlCommand, but I am just stumped.
[Code]...
i am creating a search system i have one of y search querys working but when i try to do the same on a different part of the project i get this error message and one of my text boxes underlined message is : -
Error1 Argument not specified for parameter 'Param4' of 'Public Overridable Overloads Function GetDataBySearch1(Site As String, Postcode As String, Site1 As String, Param4 As String, Param5 As Object, Param6 As String, Param7 As String, Param8 As String) As WincantonDataSet.SitesDataTable'.C:search_Systemsearch_Systemsitesearch.vb2026Wincanton_System
I am using VS2008, language VB, and MySql.I have a simple database app joust for practice. It has one table that contains ID, Name, Surname and Age fields. The code I am using is:
[code]...
Now I would like to something like this:
[code]...
Value of type'System.Data.EnumerableRowCollection (of char())' cannot be converted to 'string'.What am I doing wrong?
why is this xml
<?xml version="1.0" encoding="utf-8"?>
<items>
<item id="77" cityID="EE12345" cityDatum="15.2.2010. 11:28:35" />
</items>
[Code]....
If you, as some can't replicate these results, here's a screenshot:
I have been using adodb as my database connection to mysql from vb.net, now I want to know if i can create a query string with 2 separate query like so:
vb
dim querystring as string
querystring="update table1 set columname = 'value' where columnname='value';update table2 set columname1 = 'value1' where columnname2='value1'"
Then I can include that to my recorset:
vb
dim rs as adodb.recordset
rs = new adodb.recordset
rs.open(querystring,con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
Ok I'm creating a sql query with a string variable and executing it in vb. The string would look something like: Insert Into Table (vara,varb,varc) Values ('vara','varb','varc') This works fine.
[Code]...
Is there any particular reason why creating a reference to an object in an IEnumerable Linq query would be really slow? I have a Linq query list consisting of my own objects (count is about 200).I was doing a time-critical task, and this line (which was used a lot in a loop) took nearly a millisecond to execute:
Dim CurObject as MyClass = QueryResult(CurIndex)
Dim tbl as String = Request.QueryString("tb") 'tb value = User
Dim sql As String = "Select * From @table Where @Col = @ColVal"
Dim para As New SqlParameter
[Code]....
what should I do to run the sql with given table name as parameter and avoid the sql injection.
i am trying to rename a table which is in ms Access file and i am sending a sql query through the oledb.command and the syntax i used is Rename 'table_original_name' as 'table_new_name' it show an error that invalid sql server what is the way or synax to rename the table which is in the MS Access File
View 3 RepliesI am starting with Linq to SQL in VB.NET, and trying to figure out how to make a simple query to a database.I want to do it all programaticly.I have made a connection to the database with a connectionstring, and this works fine - I can get a message if the database exists or not.But when I want to query a table, I am missing the part where I connest to the table. I have googled a lot to find an answer for thi, but [code]
View 2 RepliesI'm using Vb2005 to hit a SQL server. i have a pretty complicated query that hits identically structured databases on the server. I was looking into parameterizing the FROM clause but cant seem to do it.[code]Depending on the users needs I will hit the 'DriverDb' or the 'MaintDb' or 'DispDb' databases. the SQL string is actually much more complicated than that with references to the db in about 5 places so wanted to simplify it so that i could just replace with a parameter.
View 2 RepliesI am trying to run this query to fill a temp table.It worked once, I am not sure why it won't load anymore.. Care to take a look?
[Code]...
I was able to use it for querying out info from an XML file but now i have to use the DBF file from a folder. where i can find out how to query out DBF table using LINQ. I basically need to get data from a column of a DBF table.
View 2 RepliesIm a noob to sql query ,can anybody point to what table would be returned from ths sql Query. [code]
View 1 RepliesI have code in vb.net that was created using Visual Studio 2008. It has got queries done via data sets and table adapters. dsStagMyfileDesigner.vb and dsStagMyfile.xsd are the files having all the sql queries. They are code generated by using data table adapters I believe. Editing them might screw the system.
[Code]...
This is what I initially tried but it gives me error.
[Code]...
Below is my code for creating a database and then, from there i hope to be able to create more than one tables in the same database that i just created. But for some reason, Visual studio 2005 keeps reminding me that the SqlCeException was not handled or mishandled. Error lies in the "sqlCreateTable.ExecuteNonQuery()"[code]Actually i heard from someone that you can actually create all the tables that you need such as "Login", "Order" and so on in a single windows form(in form_load) , which will load up all your table and create them for you if that window form is the first object to start running in the order.
View 3 Repliesi have this loop i need to create a table at run time for these values in this loop
For b11 = 0 To n - 1
Dim tableofsports As New Table
MsgBox(sporttype(b11).ToString)
[Code].....