I instal my program to other pc and now when i want to use it.it pop out "Operation must use updateable query".when i create it. it run perfectly.but when i instal to other pc.it pop up this error.what can i do to run my program perfectly on others pc...?
View 5 RepliesI'm working in a windows app. with vb.net it is working very fine with me but after I make it as a setup file and install it it shows an error.I will explane the problem hereunder:the App. is for importing the data from xsl.file(user select it from file dialog)and store it in DB access file. It works pretty good when it is running in VS .. but after installation it is not.The error msg: "Operation must use an updateable query.""When JIT debugging is enabled, any unhandled exception.will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box."
View 4 RepliesI have an error when I try update values from one data table into another.I am using microsoft access 2007.For the datatable in question I can Insert data into it no problem, but I get the following error when trying to update -
Operation must use an updateable query.I dont think it can be a permissions problem or a file access problem because I can execute an insert sql query on the same file.
[Code]...
Operation must use an updateable query (database access 2007)
View 3 RepliesPublic Class Form1
Dim inc As Integer
Dim MaxRows As Integer
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
Dim ds As New DataSet
[Code]...
I reproduced the following code to update a database and I get the error" Operation must use a updateable query"
[Code]...
I have the following query:
Dim roommates = From p In dbroom.Residents _
Where p.room = queryStudent.First.r.id _
Where p.building = queryStudent.First.b.id _[co
de].....
But I still get the same error: The method 'First' can only be used as a final query operation. Consider using the method 'FirstOrDefault' in this instance instead.
The code below works fine on my development PC, but when I deployed the app, it crashes.
Here is the lines of code that are relvant
Private TdsTypesList As List(Of TDS_Type)
...
TdsTypesList = (From tt In db.TDS_Types Select tt).ToList
[Code].....
I have many queries that are using linq, and none of them throw any errors. The set of data is not very large either, less that 100 rows. I dont know if I have any other queries that do not have where statements in them that work.
Running .net 3.5 without sp1 on the client machine, although I am running sp1 on my development PC. looking for a solution that doesn't require sp1 to be installed.
Edit Code breaks on the second line when remote debugging.
I looked over [URL] and tried the following, with the same error.
TdsTypesList = tl.OfType(Of TDS_Type)().ToList
I finally found a dirty workaround. Instead of pulling all of columns from that table, I was able to re-write the query to omit 1 column. This returns an object of anonymous type, and I can use that object. I still would like to know what causes this though.
I have a continious Form which opens and shows records of people with whatever criteria the user had chosen the screen before. When the form opens it checks which button was pressed and then changes the recordsource of the continious form.
When I try to edit the records it says "Recordset not updateable". I have done everything I can think of, I have change the type of recordset from dbopensnapshot to dbopendynaset.
I have this error when I run my program Can not update order id field not updateable, This happens when I try to enter data into a text box and press save. to my data grid.
View 9 RepliesI'm populating a datagrid using Linq--standard kind of stuff (code below). For some reason however my ultraDataGrid is stuck in some kind of read-only mode. I've checked all the grid properties I can think of. Is that a result of binding to a Linq data source? Any example code of an updatable grid that uses Linq?
db = New DataContext
myData = New dataClass
dataUltraGrid.DataSource = From table _
In db.profiles _
Select table.field1, table.field2...
Public Sub db_UpdateWorkHistory(ByVal WorkHistory_tablename As String, ByVal WorkHistory As DataSet)
Dim Conn As OleDbConnection
[code].....
I'm trying to convert code from Delphi to .Net. I'm stuck on one line:
//Delphi code ss := Copy(ss, Length(ss), 1) + Copy(ss, 1,Length(ss) - 1); 'vb.net code ss = ss.Substring(0, ss.Length - 1) + ss.Substring(1, ss.Length - 1)
Delphi combines the two substrings, while .Net just concatenate them like a copy.
Quote:
Dim conReader As New StreamReader(con.GetStream)
Dim conCont As String = conReader.ReadLine
It just reads the first line of the server I'm trying to connect to, I want to make it read all the messages that the server is sending. btw, con is: Dim con As New TcpClient
I'd like to have an updateable DataGridView that's bound to a database-driven business object. It needs to handle all aspects of CRUD and be sortable and filterable as well.
Most of them simply bind to an object (non-database, manually filled) and do not allow you to Add, Delete, and Edit records. Furthermore, they basically never show how you would perform sorting and filtering.
I think the biggest things I'm not understanding are:
1) How do you make the DataGridView perform additions, deletions, and edits on an object.
2) How do you program your object to handle additions, deletions, and edits. Do you just need methods that use ADO.Net, NHibernate, or Linq to SQL (or any other CRUD handling mechanism)?
3) How to make this filterable and sortable.
Is this overly difficult to do or why am I have so much trouble finding examples for this?
Here 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 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
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 to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders
FROM Report_qry
WHERE (Customer= 'JohnDoe')
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI've got confused at the moment.I've got one database to developed for MLM (Multi level marketing) company.so, there's one Members database.. each member have unique ID called membercode.. and all members can members under them.. can make 2 members down to 1 member.. all members are added in same table named "tbMembers" and for each member there's a "parentID" where I add member's membercode under whome that member is?.. right?
Now what's the matter is .. I want a SQL Query which can go under and under.. like 'John Doe' having two members under him named 'Suzan' and 'Ellie' and 'Suzan' is also having 2 members under her.. and same for Ellie. and for example.. 'John Doe' having about 300 members in his down line? All members are making transactions.. like they purchase product and Invoices are being generated (invoices tables have 'memberID'). Now the query is how to generate query which can calculate John Doe's Downline's TurnOver from invoices table's 'totalAmount' field's SUM?
I'm using Asp.net 2.0 (VB.net) and use SQL Server 2005 Express.
I have created a parameterized query in my tableadapter. Here is the SQL:
SELECT CalcinerID, Comments, CorrectiveActions, CrucibleOxideWt, CrucibleWeight, DCPressure, DCTemperature,
Date, DischargePressure, FeedPressure, FiredCrucibleOxideWt, GmSampleWt, LIMSNumber, LotNumber, MaterialType,
OperatorID, QualLabOperator, QualLabTimeStamp, RecordID, ToteBinNumber [code]....
When I use the Execute Query button in the Tableadapter Query Builder, the query works fine; I get all the rows I expect. However, when I run this in my code, the query behaves like an equality statement (i.e. Lotnumber = @Lotnumber) rather than a LIKE statement (Lotnumber LIKE '%' + @Lotnumber + '%').Here is the code that is not behaving correctly. Note that I have a textbox, LotSearchTextbox, where I enter the portion of the Lotnumber that I want to use as the filter. I also have a button, LotSearchButton:
Private Sub LotSearchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LotSearchButton.Click
Try
Dim SomeNumber As Integer = Me.LotCalcinerO2TableAdapter.FillByLotNumber(Me.CalcinerDBDataSet.LotCalcinerO2,[code].....
why the query works in the Query Builder but not in the code?
I have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012
I have 7 company Divisions that sit in an access database.I then use this list to populate two comboboxes in my windows form.However I get a syntax error in my SQL Query if the Division name is more than one word.For example in my access database I have two columns one is a status column and the other is a division column. If for example the Division is called 'Corporate' the status column is called 'Status Corporate' and the division column is called 'Corporate'.The SQL query works fine in this scenario.However if I have a Division that is more than one word, lets say 'Operations Division' I get an error in my SQL Query that says -
Quote: Syntax error (missing operator) in query expression 'Operations Division'.Here is my code
sqlNewTenderDetails = "SELECT " & Me.DivisionBox.SelectedValue & " From BidRefCodes Where " & "[Status " & Me.DivisionBox.SelectedValue & "='Active'"
daNewTenderDetails = New OleDb.OleDbDataAdapter(sqlNewTenderDetails, NewTenderDetailsTableCon)[code]....
I've recently been trying to figure out a way to get parameterized queries to work and i think i'm almost there but seem to be getting an error when executing my query
Here's the code
[code]...
I want to query an access database with variable data defined by the user. The "Search" criteria would be in a textbox. I made a query like
SELECT askID, Question
FROM chita
WHERE (askID LIKE 'Textbox10.text%')
and referring to this query as
Form1.ChitaTableAdapter.searchrec(Form1.ChitaDataSet1.chita)But id does not take the value of the textbox, instead it takes the Textbox10.text as a value. Is it possible to refer to it like this, or should I Linq?
[Code]...