Consider the below code (which dynamically creates a dynamic SQL string) Is there a way to further compact string.join, so it does replace("'","''") on all array members automagically ? (without writing a custom version)
[Code]...
I'm using the following to strip special characters out of a URL:
Dim urlReg As New Regex("[^dw ]")
inurl = urlReg.Replace(inurl, "")
[code]......
I have a string which I've split into an array. I need to change a value in the array and join the string together. However I cannot set the value of the array variable as it's read only.Is there any way to do this without creating another array?
Dim LineOfText As StringDim aryTextFile As String[code...]
Is there a better way of testing if a string can be converted to an integer other than something like the following?
Public Function IsInt(ByVal value As Object) As Boolean
Try
Dim temp As Integer = CInt(value)
[code].....
I've developed a software using VB.net and SQL server 2005. This is the connection string that used. Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True But now i want to use SQL server compact edition. So what should i change in this connection string?
View 11 RepliesI have following code:Dim PendingFiles As New Queue(Of String)I need to join each element of PendingFiles with a comma and store the result as a string. How do I achieve it?[code]
View 1 RepliesI am trying to filter fields in a table that contain percent (%) and apostrophe (') characters. I kow that to filter an apostrophe you need to add another apostrophe (''). However, when a text contains the percent (%) character in combination with an apostrophe (') character, an exception is thrown. Also, when using the % character in a filter string, it will be function as an "*" (fields starting or ending with). I need the % to be considered as a character whenever the % makes part of a string in the field.
Dim TheTable As New DataTable
Dim col As New DataColumn("Col1")
TheTable.Columns.Add(col)
Dim TheRow As DataRow = TheTable.NewRow
[code]....
Is there a way to use [string].Join to concatenate html stings including spaces? I want to join html strings with a special character so I can pass them as an array to javascript from the code behind.
Dim Array(100)
As
String
ArrayString = [String].Join(",", Array)
This works great if each item in Array is one word only, but what if each item in Array contains spaces?
Ok so here's my problem. I am trying to make it so when you push a button it will add a new character to my listbox. Everytime I go to add a new character its data replaces the existing ones I have already added to the list. I know what's doing it because it's using ThisNewCharacter everytime the button is pushed, I do not know how to work around it tho! I want it so it will continue to add new characters to the list when the button is clicked that doesn't replace the other characters data.
[Code]...
I 've an ArrayList and to join all its elements with a separator in one string I m using...
Dim s As String = String.Join(",", TryCast(myArrayList.ToArray(GetType(String)), String()))
however, I would know if there is a smarter/shorter method to get the same result,or same code that looks better...
I am trying to prevent from having to escape apostrophes in my string variables by using a parameterized query with a OleDbConnection, but it is not working. I am trying to insert into an Access db and I keep getting those pesky html codes.
Dim pConn As New OleDb.OleDbConnection
pConn = New OleDbConnection(cb.ConnectionString)
Dim SqlString As String = "INSERT INTO Strings (Mlt_String_ID, Lng_ID, Strg_Name, Sht_Text, Lng_Text, Alt_Text) Values (@Mlt_String_ID,@Lng_ID,@Strg_Name,@Sht_Text,@Lng_Text,@Alt_Text)"
[code]....
I have a combo box that lists Customers:
Customers
ABC001
ABC002
ABC003
If I select ABC003 from the Combo box drop down it replaces the first line of Combo box text with that text. i:e ABC001 is now ABC003.
So if a user selects a customer and then changes their mind to say ABC001. ABC001 is no longer available.
How can I set the Combo Box from updating with the selected values?
Iwant to join two tables,'Employee' and 'Dispatch'. Dispatch has column 'DispatcherID' and 'TechnicianID' which are both foregn keys to EmployeeID in Employee table.I want to join these two tables using EmployeeID so that i can obtain the matching name to each id.but it only works when i make a single join to either DispatcherID or TechnicianID and not for both.
[code]
select Employee.firstname+' '+Employee,secondname as Technician,Employee.firstname+' '+Employee.secondname as Dispatcher from Dispatch inner join Employee on Dispatch.TechnicianID=Employee.EmployeeID inner join Employee on
[CODE]...
[Code]...
What am I doing wrong or do I use a incorrect way to extract text from an array? Using += takes up a lot of computing power when it reaches like 50000 characters so I want a method with much better performance
I am trying to prevent from having to escape apostrophes in my string variables by using a parameterized query with a SqlConnection, but it is not workinUPDATED: this is current code...
'Populate Connection Object
Dim oCnn As New SqlConnection(strConnection)
'Define our sql query
[code].....
I am working with an ArrayList of ArrayLists. Every time I add a new ArrayList to the main AL, it replaces all previously added ALs with the new one.Here's an example
Dim al As New ArrayList
Dim al2 As New ArrayList
Dim list() As String = {"one", "two", "three"}
[code].....
I would expect the Final line should be "Final: one, two, three" but that is not the case. And if I pause and check my ArrayList (al), it shows 3 items, that all have "three" in every spot which is what the last AL I added looked like.
The apostrophe is used to separate data when adding records to an Access Database data table using the "INSERT INTO" SQL statement. Having apostrophes in the data really screws things up with this new software. Is there a simple workaround? Is it possible to specify a different character? Is it possible to add data without using SQL Statements? I also noticed that the new OleDbDataAdapter Add Method generates the same SQL Error because it apparently creates an "INSERT INTO" SQL Statement.gh
View 4 Replieshowever i have always had issues with databases... so i abandoned it and went into web design instead. Php and sql are so easy there is nothing i cant do with them.I created an Sql compact database which i can connect to and navigate using the following code... but that is it. i cant seem to add to db in any way shape or form.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.AddressTableAdapter1.Fill(Me.TestsqlcDataSet1.address)
End Sub
[code]....
Im looking for some advice on the deployment of an application using SQL Compact Edition.My application will only be used by two people on two separate desktops with file sharing enabled.My goal is to deploy the application and have the .sdf file located on one of the desktops in a shared folder. So the other person using the app can connect to that database too.What is the best way to setup the deployment of this so that I can place the DB in lets say c:DBMyDB.sdf
View 5 RepliesHow can I add data to SQL Compact Database from DataGridView?Striving to do my best.
View 2 RepliesI am new to vb 2008 and I can't seem to figure this out.
When I try to add a database to my project I get this error (Please look at .jpg (Firsterror)
I have selected the correct driver SQL Compact 3.5
It will add the database to the project but the FULL PATH is always incorrect and I can't change it. (Please look at my seconderror.jpg) the correct path is C:SQLSample.sdf
I am trying to compact a Access 97 MDB file. I have found and tried the following code
Private Sub CompactDB()
Dim jro As JRO.JetEngine
jro = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>;")
MsgBox("Finished Compacting Database!")
End Sub
This codes works and seems to compact the file and it appears in the destination folder but when i try to open the new file i get an error "Unrecognized database format 'DATAPATH'"Is there something i am doing incorrect? the database file sizes range from 5Mb to 100Mb+
I am using Access database. Now i compact the database by using DAO and sometimes using JRO. But to this both, we have add the COM reference.
View 2 RepliesI am trying to set a default datetime for sql compact but I receive an overflow.
Does anyone know the default format for sql compact? I thought it was yyyymmdd
I need to create a sound if validation fails. Anyone know how to do that? It can be a wave file or any kind of format.
How can i create a sound in .net compact framework 2.0. using vb.net. I saw codes asking to use system.media class. However in compact framework there do not seem to have this class.
I want to use MySQL with my mobile phone. I have installed the "MySQL Connector" and use this
Dim conn As New MySql.Data.MySqlClient.MySqlConnection
Dim myConnectionString as String
[CODE]....
My machine has erros with "MySql.Data.MySqlClient.MySqlException" and "MySql.Data.MySqlClient.MySqlConnection"
How can i solve this problem? With the normale Framework i can use MySQL...
I cant understand why sending parameters to insert function works slow in .net compact framework.
Forexample following code inserts within 2 seconds
[Code]...
In Visual Basic 2008 Express with SQL Server Compact 3.5 and the Usual DataSet / TableAdapters, My Query is too long:Changing the names, it is a query like this:
SELECT Table1.*, Table3.*
FROM Table1
INNER JOIN Table2
ON Table1.ID = Table2.T1ID
[code].....
Problem is, Table1 and Table3 have around 10 and 5 columns each, with rather descriptive names, and The Table adapter is insistent on writing all the columns out and therefore hacks off my command. (It won't take * 's, it always says it can't find the column Table1.* )
Is there a way around this?
Its my first time playing with the sql compact edition. I am noticing a difference vs char fields in a normal sql database. I was wondering if someoen can explain to me how to get the 2 to work the 'same'...Here is my issue I am having.
View 2 RepliesI'm development an application in vb 6.0 with SQLCE but when I try to make an update in a table I recive an error 3251 or -2147217887 (80040e21) [code]...
View 1 Replies
