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?
I have an access table and I want to write a query that has a case in it, but it gives me an error message when running the query Error "Syntax Error missing operator in query expression"
[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]...
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]...
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 have a table named item_details.i have some field named item_id,item_name,quantity,supplier_name etc.i want to see all details as per the item_id given in a textbox.i also want to see details as per the item_name is given.i can use 2 forms to view this type of query..one for item_id..and other to view from item_name.but..i want to use tabcontrol..in 1 tab i want go give the item_name...and want to get the details.and other tab i want to give the item_id...and want to get the details....and whenever i gave wrong information.an error message will be shown.
[Code]...
I am writing a little program that does the following:Allows the user to enter a id number.Then when the find button is clicked, we connect to the database and run a select statement for the id.I am trying to figure out how to get the first name, last name and birthdate into textboxes on my form.
I would like to have a way to display a messagebox if the resultset = 0 so as to tell the user no records found.Then if the information is correct I am going to have a button to update the information which is going to call a stored procedure I have in place to update the record.how to make the connection which I think I have working and then loading the individual fields into the appropriate textboxes.
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.
I am getting the above error in my code. I've searched the net (on this site and others) for a solution to this problem and it seems that its either something to do with a field name being a reserved name ie. Date, Time etc.... or its missing (') or (") in the SQL command. ive tried both these solutions to no avail.
Dim objDataAdapter As New OleDbDataAdapter
Dim objDataSet As New DataSet
Dim objDataReader As OleDbDataReader
Dim i As Integer
Dim SQLstr As String
[Code] .....
How to pass the query string using hidden fields in vb.net...
View 3 Replieshere is my code. dont seem to know whats the problem. i have 12 data fields in access excluding the ID field.
Dim strCon As String = "Provider=Microsoft.jet.oledb.4.0;data source=C:UsersdexterDocumentsdesktopcsci14databaseMuseum-final.mdb"
Dim dSet As New DataSet
[Code].....
i am making a simple testing application within visual studio 2010, thought im gonna be direct. in ms.acces i made a database with a few tables, this one is about the table : leden. the error indicates that i simply do not have enough values to insert into the table and i think it has to do with the ID(autincrement in acces)
[Code]...
Private Sub ButtonSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
If frUpdate = False Then
[code].....
My LINQ query contains the following Group By statement:
Group p By Key = New With { _
.Latitude = p.Address.GeoLocations.FirstOrDefault(Function(g) New String() {"ADDRESS", "POINT"}.Contains(g.Granularity)).Latitude, _
.Longitude = p.Address.GeoLocations.FirstOrDefault(Function(g) New String() {"ADDRESS", "POINT"}.Contains(g.Granularity)).Longitude}
The query works, but here is the SQL that the clause above produces
SELECT [t6].[Latitude]
FROM (
SELECT TOP (1) [t5].[Latitude]
[Code]....
but this produced an error: "A group by expression can only contain non-constant scalars that are comparable by the server."
I've been running into some errors with converting strings to dates in the following code. I have recently added the intcall.Value = DateTime.Parse(txtIntCallDate.Text) function which had gotten rid of the error message, however the records are not being updated, any of them on the form. Prior to this the strings were being updated just fine. As long as there is a date entered on the form there is no error, if it's left blank i get the "Problem converting string to datetime"
[Code]...
I have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria
I still can't assign the process the username of the session id that is associated with it.[code]...
View 1 RepliesI'm trying to query old Access database tables and compare them with SQL Server tables.They often don't have primary keys, or they have extra fields that had some purpose in the nineties, etc., or the new tables have new fields, etc.I need to find records - based on a set of fields specified at runtime - that are in one table but not another.So, I do this kind of query all the time in SQL, when I'm comparing data in different tables:
dim fields_i_care_about as string = "field1, field2, field3"
'This kind of thing gets set by a caller, can be any number of fields, depends on the
'table
dim s as string= ""
[code]....
It tells me it can't convert a Boolean - Is there any way to do this without Linq expressions? They seem far more complex than what I'm trying to do here, and they take a lot of code, and also I can't seem to find examples of Expressions where we're comparing two fields in a subquery.Is there a simpler way? I know I could do the usual EXISTS query using JOIN or IN - in this case I don't need the query to be super fast or anything. And I don't need to use a DataTable or DataSet - I can put the data in some other kind of object.
I have been programming for alot of time. Generally i program in some languages like PHP, ASP.net, Java, JavaScript and others. In all languages i have to use alot of if else statments . Like if value= 10 then ... if i review my code then i find alot of if conditions. So i would like to minimise them but how not sure. one point was using classes somewhat minimised but still they are more... like task, cat, sec and type:
[Code]...
Private Sub cmdCalculate_Click()
Dim Run As Double
Dim Rise As Double
[Code]....
I am trying to calculate from a case, and it does not seem to work, and I also need to validate when no input is entered and the person presses the calculate button. my code is a follows
Public Class Question2
Dim intSal, intCount As Single
Dim intPiece, intRates, intPay As Long
[code].....
I was so happy when I discovered IsLittleEndian field in BitConverter. I thought of course it should be there and I should be able to specify whatever endian I like. Well, my happiness didn't last long. Spent some time till found out that there is no way to set the field.The field is readonly, and it is only set to true in static constructor:
[Code]...
My question is: how come there is very useful piece of code that is already implemented and sitting there in the FCL, but there is no way to use it (unless you start messing with reflection of course)? Is it just because some developers didn't meet the deadline and left the job half-done? Even if so, why the code is not available, but the field is?I hope there is a good reason for this.
I want to make myself clear. I don't need a solution on how to handle big-endian values. I do have a solution. The solution is actually shown in my question.
I have a DataGridView and one column has DataGridViewCheckBoxColumn type .The datagrid loads from selected items of a listbox.I need to hide Check box cell in this grid according to the item. It means some items should not have checkbox in that cell(I have the list of those items which should not have checkbox in that cell).
View 3 RepliesI can't remember very well the instances where my selected items has disappeared as if I did a "Reset ToolBox", the last time I remember was when I installed the Service Pack early this year. But last year I think it has been reset frequently and I find it bothersome to reselect all those items again and again.Is there any configuration that I could set so that my selected items are safeguarded, that is they won't be removed no matter what?
View 4 RepliesI'd like to select my cases from an external location.[code]I want my users, when they click a button, to download a file from my Dropbox(a .txt file). Then, the file will read all of the code, and add it to the code..So for example if in the .txt it was something like.[code]
View 3 Replieswhat exactly the difference between using cases and if statements are.
View 4 RepliesI am having trouble figuring out what I need to do in order to get the program to drop into the different cases. I am suppose to be doing a case block for this assignment. I believe everything else is good but it always outputs the first case and doesn't progress down depending on the inputs. I tried to number them case 1, case 2, etc.. Here is the code
[Code]...
Im trying to to detect what is in the string and so something for each different result but im not sure howto, here was my first idea but it obviously doesnt work as you cant use contains that way:
Select Case omg.Contains
Case "1"
MsgBox("1")
Case "2"
MsgBox("2")
End Select
I am working with cases, I'm only learning it so far, but just can't get a drop down menu to work that would change the background of a Textbox.
Private Sub cbColours_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbColours.SelectedIndexChanged
Select Case colours
Case Is = "Red"
txtSpace.BackColor = Color.Red
[Code] .....
It isn't doing anything at all...
In the dropdown menu, it has
Red, Blue and Green one per line
When the value (e.g. Green) is clicked, it will then change the Textbox to the colour selected.
I'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.