I am currently working on downloading the data automatically on this page[url]...
I would like to somehow be able to control the URL so that, say, when I use the [URL]..
the option selected for Location parameter would be PJM and when I do[code]...
I'm trying to create a sql query to search within an Access table that is showing inside a datagrid.
The search criterias used in the "where" bit are retrieved from info entered by the user in 3 textboxes and 1 DateTimePicker control. The first 2 fields are String type, the 3rd field is a date type (entered by the user using the DateTimePicker) and the last field in the DB table is Integer type.[ode]...
This LINQ to SQL query From g In Db.Context.Current.Groups Select g.GroupID
generates this SQL:
SELECT [t0].[GroupID] FROM [dbo].[Groups] AS [t0]But this query From g In Db.Context.Current.Groups
Select g.GroupID, g.MemberCount
[Code]...
I very much want to select only the fields I need. How can I persuade LINQ to SQL not to select all columns?
Table relationship[code]...
There are some TimeSheet that have no TimeRecord, which I need to select as well. How can I select all of them to make selection like above wanted result? I'm thinking of how I can include some condtion checking in the query to see if this TimeSheet has no TimeRecord then no need to Sum(tr.BonusHour) just assign TotalHour to zero.
I am working on an application in Visual Basic Express using an Access 2000 database.I am trying to get athe following SQL query to work but get an error in Access.
The query is:
SELECT [ID], [Title], [Author], [Series], [YearPublished], [ISBN], [CoverPrice], [Style], [Condition], [Signed], [Comments], Count([Title]) AS CountOfBooks, Sum([CoverPrice]) AS TotalCoverPrice
FROM tblBooks
WHERE ID=[@ID];
The error is:"You have tried to execute a query that does not include the spec ified expression 'ID' as a part of the aggragate function."
The query works fine without the 'Count' and 'CoverPrice' count and sum to the query.
In VBE I have a combobox, a button and a listview.
SELECT * FROM table
WHERE description = @cmbDescription.text
My combobox has three items:
1 All
2 Item1
3 Item2
4 Item3
When user will select any Item the query will return the data related to that Item. My question is how to implement if user selects the option ALL in the combobox.
Can anyone see what I'm doing wrong in this
Dim connStr As String = "connection string goes here"
Dim conn As New Odbc.OdbcConnection(connStr)
Dim comm As New Odbc.OdbcCommand("insert into mytable values (0, @P1, @P2, null, @P3, 'n')", conn)
[Code]....
I get "A syntax error has occured." It appears as though my parameters aren't getting replaced with the values I'm telling it to use.
Microsoft Access queries with somecolumnname = [?] do not show up in the list of Views in the New DataSource Wizard in Visual Studio.
The query works perfectly from within Microsoft Access by just prompting for the values of the parameters.
The columns of the query should populate labels on my form based on the values in a couple textboxes.
What is the "best-practices" way to use parameter queries in my .NET application?
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
When I run this code :
Dim username As String = TextBox1.Text
Dim pass As String = TextBox2.Text
Dim con As New OleDb.OleDbConnection con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=""C:Documents and SettingsSaeedMy DocumentsVisual Studio 2008Projects
[Code] .....
I get these error message:
"No value given for one or more required parameters." at the line:
dr = cmd.ExecuteReader(CommandBehavior.Default)
what is the error.
I want to query items from countries that are selected from a treeview (with checkboxes). However the number of countries that is selected by the user is not known beforehand. So how can I make a proper query when the number of OR operators is unknown? For example: SELECT DISTINCT Item FROM Countries WHERE Country LIKE @c1 OR @c2 OR @c3 etc� and then add the parameter values based on the selected countries in the treeview. I looked into parameter arrays but can�t make sense out of it really
View 13 RepliesHow do I get Linq to ignore any parameters that are empty? So Lastname, Firstname, etc? If I have data in all parameters it works fine...
refinedresult = From x In theresult _
Where x.<thelastname>.Value.TestPhoneElement(LastName) And _
x.<thefirstname>.Value.TestPhoneElement(FirstName) And _
x.<id>.Value.TestPhoneElement(Id) And _
[code]....
I'm trying to bind a datagridview to a tableadapter which contains a query that requires parameters (for the WHERE statement of the query). The datasource is a SQL Server database. When I bind the datagridview in design view, it does not let me choose which tableadapter method I would like to use. The way I've been fixing this is to go into the code behind that form, where Visual Studio puts in some auto-generated code that fills a datatable in the dataset and I change the method that it's using there and put in my parameters. I don't think this is the proper way to do it, however, especially because sometimes that code doesn't even get generated! My other solution is to just programatically bind the datagridview to a datatable which I have filled using the tableadapter. This seems like more work than it should be, though.
View 5 RepliesI'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information.All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and that is the correct data type.But when I run the update query I get an error message saying something like values haven't been entered for some required parameters (my Visual Studio is the Spanish version, so I can't give the exact error message in English).The bit of code where the error occurs is inside the procedure called by my "Ok" button:
Dim campo1, campo2, campo3, campo4, campo5 As String
Dim campo6, campo7, campo8 As Double
Dim campo9, campo10 As Integer
[code]....
(I didn't post the whole code inside the procedure, but of course I'm creating the connection and everything)
The table has 10 fields, and the data is read from the textboxes and stored in variables (campo1, campo2, campo3, etc.), which I'm then using in the "set" query command.
"id" is the first field from the selected row in the datagrid, which I'm sending as a parameter to the procedure called by the "OK" button.The error message shows at runtime, so I'm guessing it's something in the query. Am I writing it correctly?
I have a search function de build.We are using pure ASP.NET w VB.NET We have multiple DropDownLists and we're building a search query with whatever was selected in those DDLs. My question is, how can I handle the blank values (unselected dropdownlist values) with the SQL Query ? I'm using AND operators in the query so if anything is blank it'll fail the search. If the dropdownlist has no selected value, i don't want the value to be part of the search. It would be easy to code with just 2-3 parameters, but we're looking thru at least 10 items and doing a SWITCH CASE or multiple IFs would soon become mayhem.
View 1 RepliesBanging my head against a wall here. I have a query that looks like this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE 'JOE%'
That works absolutely fine in query wizard and the DataTablePreview data window. However, when I do this.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName LIKE ?
I get nothing when I run the fillby method. If I change the LIKE to =.
SELECT FirstName, LastName, Address
FROM Members
WHERE FirstName = ?
Everything works great. I need to get LIKE working though so I can wildcard search.
I'm using the SQL server OLE db connections if that means anything.
UPDATE
Using the LIKE operator doesn't work at all. When I just swap out = for LIKE. Nothing is returned.
GOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
Trying to search a database from vb.net I have the following function
[Code]...
No value given for one or more required parameters. I found the code in a vb.net book someone lent me. It doesnt work at the moment and I wondered if I have everything correct the bit at the top in brackets (Phone LIKE?) is that saying check if there is a row in the 'Phone' column that is the same? Because I am also selecting Phone (the column) in that line? Later I say compare to Form3.Textbox1.Text so I am not sure whether they should both be 'Phone' inthe SQL line? Is it saying that If it finds something display whatever is in the details column to display in the text box?
I am trying to bind my SQL param's qurey to bind to a table. My problem is i get this error "Fill: SelectCommand.Connection property has not been initialized."
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
If RadioButton3.Checked = True Then
Dim connectionGrid As SqlConnection = New SqlConnection("Data Source=BST;Initial Catalog=dsfs;uid=dfsdf; pwd='dsfsf'")
Dim commandgrid As SqlCommand = New SqlCommand()
[code]....
I'm writing a query to select all records that has any part of parameter. I have one table called Employees. Some people have name like this: John David Clark If the parameter is
[Code]....
I should be able to get result back as long as there's a match in the parameters. If I use Function Contains (q.FirstName & " " & q.LastName).Contains(employeeName), I will not get any result back if employeeName is "John Clark" Function Contains looks only for next words from left to right. It doesn't match a single word at a time. So that's why I used this in the Linq to SQL:
[Code]....
I am getting error [07002] the # binded parameters < the # of parameters makers, i checked both parameters were perfect even though i am getting this error here is my code
[Code]...
Basically Commands has Parameters and parameters has functions like Add, AddWithValue, and etc. In all tutorials i've seen, i usually noticed that they are using Add instead of AddWithValue.
[Code]...
since it saves my coding time. So which is better to use? Which is safe to use? Does it improves performance?
is there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
View 3 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
When 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 Repliesi have a c# script the validates emailadresses. I want to access the script in my vb project. I imported the .cs file but i have no clue to access it.
So far i added:imports microsoft.csharp
There seems no way to reach it, system does not seems to know it is there..
Is it possible to include an SWf in an EXE? (So that there is no separate file?)
View 8 RepliesI am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [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