Public Class Customer
Private m_CID As Integer
Private m_FirstName As String
[Code].....
My question is that do I need to add an OID in customer class or I can directly send a query to customer table when ever an order is made.
Office 2010; Windows7; Visual Studio Basic 2008 (VB.Net)
[Code]...
The following strSQL string is not working as expected when run in VB.Net Interop to Access: (NOTE: The line-feeds " _" are used below are for reading only - are not in actual code line)
[Code]...
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
ALTER DATABASE test SET ENABLE_BROKER this is the sql query i wish to execute while program is executing.because i do not want to everytime i change computer also need open sql management tool to execute this query rath
View 3 RepliesThere is a "submit" button and a textbox, when the button is pressed, i want to connect to access database and search for the entered text in the textbox . if true i want to show "okay" a string .
View 4 RepliesHow to execute a query in visual studio 2008. What is the smooth process?
View 2 Repliesi got an execute non query error... heres the
Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
Dim da As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
Dim obj As New OleDb.OleDbCommand
[code]....
I don't like the verbose way of adding DataRows one by one via Tbl.Rows.Add, so i've created this pseudo LINQ query that does nothing but adding rows implicitely:
Private Function GetData() As DataTable
Dim years = {"2010/2009", "2009/2008", "2008/2007", "2007/2006", "2006/2005", "2005/2004", "2004/2003"}
Dim tbl = New DataTable
tbl.Columns.Add(New DataColumn("Year"))
[code]....
As you can see i don't need the result of the query at all, it's only purpose is to iterate and call DataTable.Rows.Add. So the result is already available in the DataTable itself and not needed from the query.Admittedly this question is somewhat hyphotetical because there would not be a big difference in using f.e. ToList and normally a query's purpose is to return something.But anyway, what's the cheapest way(in terms of memory consumption, execution time) to execute a LINQ query when only the execution and not the result matters?Edit: Ok, thisquestion was a quick-shot and a chicken-and-egg problem. I wanted to reduce 20 lines of code to a single line but noticed that i need some kind of DataSource for the LINQ-Query. Therefor i've created the Array. But at this point i could have simply used a for-each loop as well to add the DataRows.
Conclusion: Use a LINQ-Query for what it's for: a query. Then this question is pointless since there is no cheapest way but only that which returns the correct result.
I would like to run a query in background (using a BackgroundWorker) in this way[code]...
...but, because of deferred execution, the actual getting of the data does not happen in the "BackgroundWorker" thread, but in the "RunWorkerCompleted" Sub, making the BackgroundWorker itself useless.Is there a right way to do this without looping through the "MyQuery" to get the results and copying them to another object to pass it to the BindingSource?
I'm testing the Compiled Queries for the first time.[code]...
View 3 RepliesI'm trying this for long time and I still can not figure it, I'm trying to query a database "password" with the field to check if the login is there "login" and if it find the login in the table execute start.show() but I still geting errors.
code.
Imports System.Data.SqlClient
Imports System.Data
Public Class login
[CODE]...
How can i execute my query to insert records in tables?[code]...
View 7 Replies[Code] Now the problem is that after i put this user-control in a form, I have to set a value for the Handled file. Otherwise it gives me a value cannot be null exception. Is there a way that i can set code that would execute in the case of the value being null? [Code]
View 14 RepliesWhenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
[Code]...
I'm new to VB.NET. I'm trying very hard to not go screaming back to VB6...... I have a Query stored in an Access2000 database called 'build_VNMON'. (Does that make it a Stored Procedure ?) It uses multiple tables and multiple Union Statements to arrive at the desired results. It may not need to be as convoluted as it is, but I inherited it, and it works. What I really need is to output one column of the build_VNMON result to a text file, so I'm trying to use an OleDbDataReader.
[Code]...
I'm fairly new to VB.NET and I'm looking to create a module that will contain all general SQL functionality like connect, disconnect and execute a sql query etc. I think I'm almost there but the code keeps bombing in one place. Can anyone see what is wrong with the following code?
[Code]...
How do we make a visual basic listbox to respond directly when the user clicks on the items in the textbox? (such as making a menu appear or displaying info in a label when the items are clicked)
I have used the SelectedIndexChange event but nothing happens when the listbox items are clicked. The SelectedIndexChange event only seems to work when a button is added. It seems that the button's click event gets the listbox's selectedindex change event to start working. The listbox's textchanged event doesnt seem to work also.
Is there any way to make the listbox respond directly to the user's clicks without the use of button controls?
I have a very simple class that holds a few public properties - ID, Text, Colour, etc. and a Boolean called 'SelectedItem'. Just like the Checked property on RadioButtons, only one item can have its SelectedItem property set to True within a particular group. Note: there will be several separate groups (lists), each allowed to have only one item with SelectedItem = True.
My first thought was that I would probably just have to handle everything outside of the class, setting SelectedItem to False for every other item in a particular list when another item was selected. But that seems rather inelegant to me. So I've been trying to think of how this might be done within the class. For example: could I perhaps have a private string property called say "GroupName" - set in the New sub when adding a new instance of the class - and then use a private shared method to set every item's SelectedItem property to False, provided the item has the same GroupName as the newly selected item? I would have a go at doing this but I have no idea how to enumerate every instance of a class from within that class, or whether that's even possible. Is it? Or is there another (better) way to achieve my goal? Here is a cut-down version of what I've got so far:
Public Class ResourceItem
Public ID As Integer
Public Text As String[code]....
As can be seen: instead of instantiating a new ResourceItem and passing that as an argument to the manager's Add procedure, I'm simply passing the details of the new item and the procedure is creating the item from those. I don't know whether this is a good or bad idea - please advise - but I've done it because I couldn't figure out how to make the SelectedItem property only writeable by the manager, so I wanted to avoid having directly accessible objects that could have their SelectedItem property set to True without it deselecting all the other items in the same group. Of course that still leaves the possibility of setting a variable to one of the manager's list items and setting it from there, so I would still like to know how I could prevent that, if possible.
UPDATE: I didn't use the code above in the end, deciding instead to go with Cyborgx37's solution - which seems to work perfectly well for me despite the warnings about best practice. I also realised I would need to use the same class in another scenario where multiple items could be selected, so it was easy to add a Boolean property to the manager to enable that.
I have the following property in a property grid in VB.Net 2010.
<Description("Rapid Entry Post Car Wash Settings CarWashOptionPushButtons"), _
Category("Post Car Wash")> _
Public Property CarWashOptionPushButtons() As String
[code]....
I need to make this property a list box that gets the values from a database table and populates the list box with the values from the table. I have tried numerous things to no avail.
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.
about execute a program, what do I have to do in order I can make the program run on any other computer. I have a program on a floppy disk, and I have a copy on my desktop. when I run the program on my desktop it always say "File not found", when I put the floppy disk it's working fine. So, is there anything I can do, to make it run on any other desktop without saying "File not found"
View 10 RepliesHow to make a procedure to be executed only once when an application is installed freshly.
I mean if my application is installed, i want to execute a procedure only one time at the first use of the application.
I have a database in MS SQL Server 2008, I have Stored Procedures. One of them does an INSERT with parameters. It works in Server Management Studio.Now I'd like to make a button in Visual Basic 2008 that executes this SP. I have made a DataSet, it contains my 3 SP's, I can easily use 2 of them, because they return data, but the one I'm having trouble with doesn't. Could anyone please tell me how to make VB to execute it? (The command should look like this: "EXECUTE SP2 a, b, c, d".)
View 1 Replieshow to make the timer automatic execute a code weekly?The timer will automatic generate a report for every monday(8am),how 2 do it?
View 1 RepliesCan I make a menu item to execute 3 tasks? For instance when I select a file from a ListBox and I press ToolStripMenuItem1, the program will move the selected file to a directory, execute archive.bat file and the move the archived file to another directory? I tried but I can make only one operation - to move the file.
View 6 RepliesHow do I make a subroutine (LoadIntro()) execute on another thread?
View 6 RepliesLearning about threads at the moment, barely managing to wrap my head around it, anyway I was wondering how you would go about making threads run sequentially from threadpool if you added them with
threadpool.queueuserworkitem()
In my code currently I know it is not running sequentially as I set it up to call a function and print a number each call. I gather this could be achieved with using synch lock but not quite sure how.
Can I make a menu item to execute 3 tasks?For instance when I select a file from a ListBox and I press ToolStripMenuItem1, the program will move the selected file to a directory, execute archive.bat file and the move the archived file to another directory?Hmmm... I tried but I can make only one operation - to move the file. Can someone post a helping code or something?
View 2 RepliesI am trying to write a LINQ query which will return true if there are multiple objects which have a property with the same value.
Here is what I have come up with so far:
Formatters.Where(Function(f As DataModel.Formatter) _
Formatters.Select(Function(f2 As DataModel.Formatter) f2.Name.ToLower()).Contains(f.Name.ToLower())).Count > 1
However the above always returns true as long as their are more then 1 elements in the list?