T04Command04 = New SqlCeCommand("Update GameResults Set CN01=@T04Var02 Where Counter=@T04Var03", T04Database01)
T04Command04.Parameters.AddWithValue("@T04Var02", T04N01)
T04Command03.Parameters.Add("@T04Var03", T04ClnRec01)
T04Command04.ExecuteNonQuery()
I am trying to use two different variables in this SqlCeCommand series, to (1) update only a particular record in the database (2) with a particular variable value. However, I get the following error:
"An SqlCeParameter with ParameterName 't04var03' is not contained by this SqlCeParameterCollection."
In VB.NET I would like to create a complicated data structure with multiple types of data stored in an array like format (see below). I am trying to create a data structure that would look something like this: [Name; xLoc; yLoc; zLoc; [Jagged Array]] Note: Name needs to be dimensioned as a string, xLoc and so forth as integers. The Jagged Array would look like this:
I have a simple table in an access database that I'm using in a VS2010 project. I have a combobox control that a user can select the horse power of a motor. I then take that selected value from the control and copy it to a string variable called gstrSelectedHP. All I want to do is run a query that will pull up the full load amps of that horse power motor from the table. I have the query already, but I need to somehow put the gstrSelectedHP in the WHERE part of the query so that it only returns that value.
I got this in my SQL statement. I "BOLDED" the problem.SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddressShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID =@CustomerID
Dim gg = From gs In AllData_TableList Order By gs.Biology Descending, gs.ChemistryDescending, gs.English Descending, gs.Frensh DescendingAll I need is to make this Statement order Dynamically like this
Dim Variable1 as string=Biology Dim Variable2 as string=Chemistry Dim Variable3 as string=English
I am trying to figure what is the best way of using SQL in my app in the manner of run time.I need to select data from my database let say 60 times a day maybe more I can use the dataset and its adapters or use the SqlCeCommand to build my own Q What do you recommend?
I have a listbox that is dynamically filled by certain values depending on what table has been selected from another list box. Once a value is selected, it is being graphed vs a date & time range. With my ignorance of linq: depending on what value is selected, the linq to sql statement I need to create to grab data from my database is different as I can't use an index on an anonymous type.
result = From t In db.APS _ Where t.DateTime >= startDate And _ t.DateTime <= finishDate And t.Weight = weight _ Select t.DateTime, t.TotalConcentration
t.TotalConcentration should be selected if my listbox value is "Total Concentration", but if it's something else, like "Temperature" or "Flow Rate" (connected to appropreate database columns) - this method obviously isn't going to work. I need to be able to dynamically select a specific column from the anonymous type list, or use some other method I'm unaware of to do this.
While measuring the select case performance I encounter a strange behavior of Select Case statement with the constant expression. I don't understand why its behavior is dependent on the values to be compared.
UPDATE: I've modified the code to drop the indexes before the inserting, but it makes not difference.I've been asked to resolve an issue with a .Net/SqlServerCe application. Specifically, after repeated inserts against the db, performance becomes increasingly degraded. In one instance at ~200 rows, in another at ~1000 rows. In the latter case the code being used looks like this:
Dim cm1 As System.Data.SqlServerCe.SqlCeCommand = cn1.CreateCommand cm1.CommandText = "INSERT INTO Table1 Values(?,?,?,?,?,?,?,?,?,?,?,?,?)" For j = 0 To ds.Tables(0).Rows.Count - 1 'this is 3110
[code]....
The specifics aren't super important (like what 'tbl' is, etc) but rather whether or not this code should be expected to handle this number of inserts, or if the crawl I'm witnessing is to be expected.
I am using an INSERT INTO ... VALUES statement in the following matter to insert data into a new row of a database:
[Code]...
How can I substitute variables for the explicit values of X and Y in this statement (for example, variables XName, XAddress supplied by user input via text box)?
I am looking for the correct configuration to allow a variable for the Where modifier of the SqlCeCommand(Update) routine. Within the database, T01 is a bigint field, and T02 and T03 are nvarchar fields. A literal coding such as Where T01=2 works fine, but an attempted variable configuration such as above produces the error The column name is not valid. [ Node name (if any) = ,Column name = T03Ctr ] at the ExecuteNonQuery() line.
I have a "if This > That then" statement, that doesn't seem to work, as it triggers regardless that "This" is smaller than "that". Does it matter that these variables are marked as strings vs integers?
I'm a long time VB.NET developer and has recently switched to C#. I found out that some of the built-in VB.NET functions (which predates .NET back to 6.0 and BASIC itself) such as the String.Left, or Right, or advanced functions like saving to the registry (SaveSettings and GetSettings) are noticeably absent. What I did was create a new project in the same solution with VB.NET as its language and recreate basically all the functions I need that are available in VB.NET. And then I just call that to the C# code I'm writing.Since compiling the code in .NET pretty much boils down to the same CIL, it shouldn't matter performance-wise what language I wrote the code in or whether I mix C# with VB.
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
I'm trying to write 2 extension methods to handle Enum types.One to use the description attribute to give some better explanation to the enum options and a second method to list the enum options and their description to use in a selectlist or some kind of collection.You can read my code up to now here:
<Extension()> _ Public Function ToDescriptionString(ByVal en As System.Enum) As String Dim type As Type = en.GetType Dim entries() As String = en.ToString().Split(","c)
[code]....
So my problem is both extension methods don't work that well together. The methods that converts the enum options to an ienumerable can't use the extension method to get the description.
I'm working with a third-party library interfacing to an old database system. There's a method - CallProg that calls a "stored procedure" (for lack of a better translation - any Pick users in the crowd?). However, instead of doing something like this:
Public Sub CallProg(ProgName, ParamArray ProgArgs() As String) ... End Sub
I have 3 textbox's and 1 dropdownlist and I am trying to combine all that data into one string. Here is what I tried but is not working:
Private Sub FullAddressTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FullAddressTextBox.TextChanged FullAddressTextBox.Text = AddressTextBox.Text & " , " & CityTextBox.Text & " , " & StateDropdown.text " , " & ZipCodeTextBox.Text End Sub
My goal is to combine these simultaneously as whoever is filling in the data or after I hit my submit button, if so it has to occur as the first event.
I think my problem has to do with .text after the statedropdown, Is it suppose to be .tostring?
I've seen several posts on the subject, but none seem to answer this particular dilemma. I have two datatables that I obtained by querying two separate servers.[code]
I have two (actually many) .png images in my application. Both have transparent areas here and there.I want, in my application, to take both images, combine them, and display the result in a picture box. Later I want to save the result through a button.So far I managed to find the two images and combine them, but it seems the transparency thing won't work. I mean, if you put one image over another, only the top image is visible as the result because, apparently, the image's background is a plain white box. Which is not. Here is a bit of my code:
Dim Result As New Bitmap(96, 128) Dim g As Graphics = Graphics.FromImage(Result) Dim Name As String[code]....
resourcesPath is the path to my resources folder. Bases is a folder in it. And Name is the image's name.
How to combine these two conditions in one section Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating 'condition 1 ' check given value is numeric or charactr type If e.ColumnIndex = 3 Then If Not IsNumeric(e.FormattedValue) Then DataGridView1.Rows(e.RowIndex).ErrorText = " must be a numeric value" [Code] ..... 'condition 2 ' check given value is greater than 0 or not If e.ColumnIndex = 3 Then If (e.FormattedValue.ToString = "0") Then [Code] .....
Let's say I have 3 tables: carts, baskets and eggs where a basket can contain many eggs and where carts contain many baskets. Each basket has a foreign key that maps to a cart and each egg has a foreign key that maps to a basket.I need to return a table that contains these 3 columns:Cart Name | Count of Baskets in Cart | Count of Eggs in Cart.Each table is an EF and I'm using linq with VB.So far, I have 2 queries: one that returns the columns Cart Name and Count of Basket and another one that returns Cart Name and Count of Eggs. How can I combine these two result tables so that I get the results in one table?
Dim query1 = (From cart In myEntities.Carts Where cart.UserID = TheUserID Join baskets In myEntities.Baskets On baskets.CartID Equals cart.CartID
I'm trying to combine two arrays. Simply append 1 array to another. I have two string arrays. Lets just say array1 and array2.would the following be correct?
array1.Copy(array1, array2, UBound(array1)) I guess I'm slightly confused about the parameters. When I try to use the above code I get green squigglies with the following error.Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.
this is my code right now i want to make it so that it will keep adding the total. meaning if i get an answer then get another answer i want both of them to add up and show.how can i change it so that it will do tat??