Variable For "Where" Modifier Of Update Routine For SqlCeCommand
Mar 8, 2011
with the following code:
[Code]....
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 sub routine where I pull in information from a database. I want to use variables from this sub routine in another sub routine. I tried making everything public but it doesn't want to be friendly and share.
Dim strEmail as String Public Sub readDB() strEmail = "whatever@doohikcy.com"
[Code]....
The readDB would read the database and set the variables and do whatever it needs to do. Then when they submit the form it would e-mail the form to whatever the email address was.
I am using sockets to send message between computers. I send the messages alright. What I want is when the message "x0x" comes, the client must be closed within 5 minutes. Teh admin can cancel the request by sending message "-xx" as well. The routine that checks for incoming connections and accepts messages uses WHILE TRUE...END WHILE since it must always listen. Once I get a message, I need to fire a timer control or other that fires within 5 minutes. But the program cant leave the WHILE TRUE at all. If i exit it early, the timer fires and the program does get exit. How do I fire the timer or other routine while still the WHILE TRUE routine checks for incomin connections and messages?
is there any way to reference a particular code routine in VB.net external to the current loop/routine?Example:
If Var01 < 5 [Routine A] Else [Routine B] End If
where Routine A and Routine B are code sequences at the end of the entire program -- such as outside of the current sub or class? The idea would be to reference an otherwise repetitive code.
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?
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.
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."
I have a Class with certain subs and functions declared as protected friends. From my understanding this should allow me to be able to access those subs and functions from anywhere in my project and yet it isn't working.
When adding a new control to the designer in Winforms, the modifier on the control is set to Friend, but the default modifier is Private (right clicking the property and resetting the modifier). Is there a setting to set the modifier to default (Private)?
I would like a answer to the following question: For instance:
You have a class called Main. This class created a object of another class called Math. Class Math has a method called Calculate() Class Main wants to call this method Calculate().
What kind of modifier should I use for the method Calculate()? I always used public but now I am not so sure... Friend seems to be working as well. What is the best way to do this?
The only place I've seen the Friend modifier used is in the WinForms designer, as alluded to in Why is the modifier set to Friend in Winforms? and VB.NET: what does the 'friend' modifier do?. The Friend modifier appears to be an almost arbitrarily wide access level that was created to solve some historic architectural problem in VB, I just wonder if anyone has a meaningful continued use for it?
I have had some desires to expose methods only to a given namespace so as to roll the functionalities of a related collection of objects together and manage any of their non-thread-safe methods, while exposing the safe public methods to a wider scope in the same assembly. This access level does not exist yet Friend does. Possibly a corollary question then, is my usage of assemblies and namespaces at odds with what is intended?
How can I get the state of a modifier key using VB.NET on the Compact Framework, in this case Windows Mobile 6.1. I want to be able to determine if the following keys are pressed or locked:
Shift CTRL ALT
and for the Psion Teklogix machines
Orange Blue
Although I may be able to work this out, if I can determine the others.I want to create my own on-screen indicator panel and want to poll the keys, not using events.
I have a TableAdapter created where one column.identity is set to true with an autoincrement.My problem arise when trying to insert a row at run-time. The following is my code and the error message I am trying to over come.[code]"The column cannot be modified. [ Column name = RecordNumber ]" I am not trying to edit that column name. I set it to true identity so I don't have to keep track of record numbers that may be deleted later on. So basic question.How do I programatically add a row to table adapter that has one column.identity set to 'true'.
i have information.mdb database. i have bind it to the datagrid view in vb.net. now i want to update the database using a button. for e.g. when user click 'save' button, the text on 'textbox1' will be the data to be insert into the 'textboxvalue' row in my information.mdb database. 'textboxvalue' row is in 'table1' table.
Can i do like this ? this code belong to save button click event. stitle = Me.TextBox1.Text Dim con As OleDbConnection = New OleDbConnection
im pretty much a beginner to using ASP.net and linq to sql but what im trying to do is update a column of a table based on a variable. at the momment i have
Dim db As New sqldcDataContext Dim update As tableName = (From i in db.tableNames _ Select i)
i think this selects everything, how could i have two variables, one to store what table to update and the other what column. is this possible?edit: sorry for being unclear im trying to make this as dynamic as possible so i dont have to type in the exact table/col names. something like this but in the linq to sql syntax.
mysql_query("SELECT * FROM ". $table ." WHERE `" . $column . "` = "" . $data ."");
When I develop a Windows Forms app in Visual Studio using C#, every control that I add to my form is by default marked as private, which is what I want.
When using VB.NET, every control is by default marked as Friend (the equivalent of internal in C#), which is not what I want.
Can I just change this default? It seems like surely it's a setting somewhere.
I am trying to update a table. I am trying to add the value 1 to the cells the user querys, i.e., user enters 1124 I want to add 1 to all of the cells the AccntRep = 1124
I am receiving this error "Additional information: Must declare the scalar variable "@RepNo"" I get the the value the user enters and store it in the variable RepNo
'Query to return tuples of AccntRep Me.CustomerContactsTableAdapter.Search(Me.CompanyDatabaseDataSet.CustomerContacts, New System.Nullable(Of Double)(CType(RepNoToolStripTextBox.Text, Double))) 'Get value from Query Box Dim RepNo As String RepNo = RepNoToolStripTextBox.Text [Code] .....
I think (?) this is about object design, and perhaps about structural and/or creational patterns. But a bit hard to say when I only know a couple of patterns yet.[code]But... what if we INSTEAD want each Product instance only to (in some way) refer to one instance of a specific list of Components. So we wan't to save the products list to one file, and the components list to another file. Then would I build the objects the same way, or different? So let's then say we have now Class B as below. [code]
1. Will not need to update each component variable of the products list when the components list changes.
2. If the Product object shall be shown in a DataGridView, for editing properties, it seems easier to implement the selection of the component property.
Is this wrong approach? Is it suitable in some cases, and if so, when? Are there other solutions I perhaps am not aware of that would be appropriate? Is this about structural design patterns? and if so, can the alternatives above be catagorized to some pattern type? I don't really know exactly what I'm looking for.. But I think probably I'm looking to understand whether the object design will be determined by the way the objects are saved.. And if i shall save the objects by serializing to file, vs saving to a database, would I create the business objects differently?
When entering a value in dgv I want the Tab key to fire a routine. Works out ok only thing is I have to hit the Tab twice before it fires. Don't know why, is there a way to prevent it, so that I have to hit the Tab key only once ?
Code: Imports System.Data.SqlClient Imports System.Data Public Class Main[code]...
and the sub Exceptionquery is not working. I can verify this because it is supposed to create a new table called scratchpad3. what I may be missing in that sub routine that isn't allowing it to work?
I was looking for something send keystrokes and I found this helpful routine SendKeys that I can use in a VB Script. I wanted to have "Right Control Key + (Scroll Lock & Scroll Lock)" sent to the machine. Essentially, having the Right Control Key pressed, I need Scroll Lock pressed twice. Here is what I tried:
set WshShell = WScript.CreateObject("WScript.Shell") WshShell.SendKeys"^({SCROLLLOCK}{SCROLLLOCK})"
Private Sub Exceptionquery() Dim connection As System.Data.SqlClient.SqlConnection Dim connectionString As String = "Initial Catalog=mdr;Data Source=xxxxx;uid=xxxxx;password=xxxxx"
[code]....
I get the error Invalid Object name 'Scratchpad3' on this line:
adapter.Fill(ds)
I have tried to debug this and can see that the query is correct, that the values that are being passed to the sql server are correct but it doesnt look like my code is firing off the Exceptionquery Sub. I thought to call a sub all you had to enter was the name of the sub such as this line:
Exceptionquery()
I have also verified that the mapping of the buttonclick event is mapped correctly. I have other subs that I am calling in almost the same way and those work.
Is it possible to set a project default for VB.NET winforms projects so that the default Modifier for controls added to winforms is Private (not Friend)?I know there's a "modifiers" property in the properties window so I can set it for each individual control however I would like to change the project so from now on myself and other developers have to specifically decide to change from friend to private. (Which I would strongly discourage them from doing).I believe there is no way of doing this, but on another forum a while ago someone mentioned it would be possible with an add-in (but didn't name the add-in or where to get it).
