How can i perform order by tCount in this Query?
Public sub StatReport()
Dim Transaction = xmlDataset.Tables("ebus_transactions")
Dim TranCounts = From T In Transaction Take 2 _
[code]....
Would I need it in order for my VB.NET 2.0 client service to perform those actions? Is the Azure SDK only for web development?
View 1 RepliesI'm using visual basic 2008 express edition and I'm not sure how to attach my query in order for it to run? I've been using trying to use visual basic to create a form which retrieves data from a Microsoft access database and filters the data to find the record starting with the letter retrieved from the user. When it is run without the query the data grid shows all the records. However when my original query is put in the application changes it and the value shown is null in all fields.
This is what i had before:
SELECT Allergies, Breakfast, Lunch, Supper, FirstName, LastName, MealDate, StudentId
FROM [Student Checklist]
WHERE (LastName LIKE @LastName + '%')
This is what was returned:
SELECT Allergies, Breakfast, Lunch, Supper, FirstName, LastName, MealDate, StudentId
FROM [Student Checklist]
WHERE (LastName LIKE '@LastName' + '%')
Like, I want a button to start five different timers, but at 1.5 second intervals. How could I make this button start timer1, wait 1.5 seconds, start timer2, wait 1.5 seconds, start timer 3, etc, etc?
View 2 RepliesI've been reading the official DNS RFC [URL].. and looking at articles like this that explain how DNS query packets are structured [URL].. but I'm having a hard time trying to combine the two and actually get to a point where I know what to do
Basically I know that I need to use UDP to send the query and there is only one type of query I actually want to perform - an MX lookup. So I'm hoping that means I dont need to account for a lot of things that anyone creating a complete DNS Resolver would need to implement.
The only experience I have with network communication like this is with protocols that are text based (and use TCP, but I dont think that makes much difference here, if anything UDP should be easier). DNS however is binary based and I just cant figure out how I would know what bytes to send down the wire for a specific MX query..
I have created a SELECT FROM WHERE query to perform a search here is my code:
SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')
I have then put the folllowing code to rung the query within my form:
Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)
When i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
How do I perform an sql query onto a DataTable not a Database table?
View 1 RepliesIn my company we use Oracle Applications. Almoust every form in these applications have a common behaviour, which is:
Whenever the forms is opened one can immediately start entering data but one can also press F7, which makes the form to enter in query-mode. You can then fill one or more forms fileds with the data you are searching for and press F8, which executes the query and returns the data into the form. The query mode can be interrupted by pressing Ctrl+Q, returning to data entry mode.
My question is if there is a way of having similar behaviour on building VB forms. I'm using VS 2010.
I can achieve in VB what the following C# snippet does but it seems very clunky since I perform a Linq query to obtain the events for the relevant user. Is there a neat way?
ctx.FetchEventsForWhichCurrentUserIsRegistered((op) =>
{
if (!op.HasError)[code]........
I want to know if it is possible to perform a mySQL query to get a single record (searched for by ID) and then split each field into a seperate text box.I think im ok with the SQLQuery to get the record. its the splitting it into individual text boxes that im strugling with.
View 1 RepliesI have a database application connected to a sql express datafile, i am using a datagridview and have clicked on the arrow and added a query. the query is simply sort / ascending on my date field which is a text field with auto generated when the field is focused so i know the dates are entered correctly but when i use the query they are not in their correct order. [Code]
View 10 RepliesI've a structure collection like this:
Jet Owner Item Comp
AAAA AAAA 101 2210
AAAA AAAA 202 2220
[code].....
I am using a modal form with a datagridview in order to populate textboxes on a parent form. The datagridview is bound to an anonymous type resulting from a linq query, which varies depending on the textbox control whose keypress event is called. I always want to display a key value in column 0 of the datagridview (along with a variable number of additional columns), and then use that key value once the user selects a row.
However, when setting an anonymous type from a linq query as the datasource for a datagridview control, the columns are indexed alphabetically rather than in the sequence selected in the query. This requires setting the displayindex as a workaround, and then keeping track of which column contains my key value. I read elsewhere that this was something fixed in VS2008 SP1, but I still encounter the behavior.
How do I order by and group by in a Linq query?I tried..Dim iPerson = From lqPersons In objPersons Where Len(lqPersons.Person) > 0 Group lqPersons By key = lqPersons.Name Into Group Order By Group descending Select Group, key
For Each i In iPerson
tmp = tmp & vbNewLine & i.key & ", " & i.Group.Count
Next
[code].....
I have to order a table following a logical order but I cannot find the appropriate ORDER BY clause.To simplify I have 2 fields field1 and field2
1 record : field1 contains �2� and field2 contains �1�
2 record : field1 contains �1� and field2 contains �2�
3 record : field1 contains �2� and field2 contains �2�
[code].....
How to perform a mouse click using VB 2008?
View 3 RepliesDim Conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:Documents and SettingsUserDesktopContribucionescontribuciones.mdb"
rs.Open()
rs.Open("SELECT * FROM master")
rs.MoveFirst()
TextBox1.Text = rs.Fields("sueldoanual").Value
I have this error
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
can i perform sql queries on xml files?
View 9 RepliesI have a datagridview comboboxcolumn populated with jobs. these jobs have a wage attached to them. for example job "Policeman" has a wage of R20.I have 5 checkboxcolumns for each day of the week as well. so if I check 3 of the checkboxes and have the job "Policeman" selected, I must then calculate the weekly wage (3*20=60) and display the wage in the weekly wage column. which event is best to handle this.
View 2 RepliesI am trying to copy a file from 1 location to other location with a new name. The new name should be like "Oldname + date & time". I wrote the following code but getting error that the Given path format is not supported Imports System.IO[code]...
View 2 Replieswhy can't I performCllick using a button which is on other tabpage. I tried those two so far but nothing happens:
[code]
btnAdd.PerformClick()
DirectCast(My.Application.OpenForms("record"), record).btnAdd.PerformClick()
/CODE]
it must be simple I just can't do it because I need to get this done when I am in other tab
is it possible to perform an action when the tab key is pressed in a textbox or the mouse cursor is moved to another box?
View 1 RepliesI need to perform a silent download in visual studio 2008
View 1 RepliesIn VB6 I could use an asterisk as a wildcard when searching the object browser. For instance, searching on "c*Report" would find "cFooReport" and "cReport". I can't seem to do the same in VS2008, am I just missing something obvious?
View 1 Replieshow to perform the database operation such reading data and using them for comparison within the VB programming..
Please guide me with explanation as i have very little knowledge regarding the database operation...
i am using VB.Net 2008 as frontend...and MS SQL Server 2008 (express edition ) as back end...
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the data table and for each individual EMPID to calculate the sum of the PAGES for each JOBTYPE.There are four JOBTYPE's: "E", "K", "O" and "R".Here is some
Dim WebAllEmployeeQuery As String = _
"SELECT ELPallEmployees.[EMPID], ELPallEmployees.[FIRST], ELPallEmployees.[Last], ELPallEmployees.[JOBTYPE],
[code].....
I've been creating a small application and now I'm going to make a setup file for it. And I started doing this using Installshield. Here's a prtscreen of where I'm stuck: Since I've developed my Application in .Net, I don't know whether it can be installed on earlier versions of Windows such as Windows 98. Should I uncheck some options?
View 6 RepliesHow to perform add, edit, delete in a dataset that will update the database as well?
View 1 Repliesi have a button and if a specific option is set (via a checkbox) then once every 5 times the button is clicked an extra event happens.I thought a counter/Integer would be the way to do it but i cant seem to get it quite right, heres my code i have in the buttonclick event:
[Code]...
I have a combo box bound to a datasource. I need to change one combo box (of many) to order the items in descending order.I'm guessing I could order the collection in the dataset, but that will mean all my combo boxes will be reordered?
View 2 Replies