so say I have a string called Cmd, and the text inside the string is Restarting server in ()..., what I was wondering was how I would go about inserting different substrings like 3, 2 and 1 in between the two parentheses? I know about Cmd.Insert() but I don't know how I would make it go between the two parentheses.
View 14 RepliesAlright I am taking an XML file which has a bunch of tags and I'm trying to eliminate everything but whats inbetween certian tags for instance the input maybe
- <w:p w:rsidR="00254C13" w:rsidRDefault="001173CF" w:rsidP="001173CF">
- <w:pPr>
- <w:tabs>
[Code].....
unless they say they are safe. Average consumer can protect themselves>not knowledgeable enough to always protect selves</w:t> I want to go through and remove those end tags but when i used the remove string it didn't let me specify a string to remove it the two arguments were where to start and how long. how do i specify what to remove?
I'm trying to split a string into 2 subs. The first contains the first 236 (0 to 235) chars and the second one from 237 to the end of the string.
firststr = str.Substring(0, 235)
secondstr = str.Substring(235, strLength) 'strLength is the total length of the string
[code]....
I am trying to write a program that separates a string into 2 substrings.Lets say I need the entire string to be 15 letters long.I need to break the string up so that the program reads it as two words.Lets say that the first word has to be 8 letters long and the second word has to be 6 letters long.So if I type it like this: Computer Screen
That should be 15 letters including the space between the two words.I need the program to read the string to make sure that the entire string is 15 letters long and if its 15 letter long continue, but if it is not 15 letters long stop and give me an error.If is 15 letter long next the program needs to read and make sure that the first word is 8 letters long and if it is print out the first word and continue but if not it needs to give me error.
Lastly if the first word is 8 letters long it needs to read and make sure that the second word is 6 letters long and if it is print out the second word and then continue, but if it is not give me error.The problem I'm having how to declare the first and second word and substrings, can someone please help me understand how substrings works and declare them after I have declared a string.
I found this function that replaces multiple substrings within a string on the internet but it gives an error on one of the parameters.It doesn't like this one:
ByVal ParamArray FindChars()) As String
Can you look at the code and correct the error since I don't yet know about explicitly typed parameters?
Emad
Public Function ReplaceMultiple(ByVal OrigString As String, _
ByVal ReplaceString As String, ByVal ParamArray FindChars()) _[code]......
i've done some basic parsing with text files before.
Scenario is i have 4 textboxes String (which contains the string i'm wanting to parse) sub1, sub2, and sub3. so the string is ex. 500000-1-2
- is the char that is the seperator
so the aim here is to get
500000 into sub1
1 into sub2
2 into sub3
the real string i'm wanting to parse is much more complex, but i'm keeping it simple here for a jumping off point so i can figure the rest out.
I am doing a project of inserting the data into the database through the used of textbox. I am using 5 textboxes when I run the application. The application is working fine but the problems is that when I post this codes, there is answer that I have to modify the inserting part to make it better. Is there any other way to make it better for the part when I am inserting the data? The program that I am using to make this application is visual studios 2005 and sql server 2005 for the database.
Imports
System.Windows.Forms
Imports
System.Data.SqlClient
[code]....
The XML String I am getting from other application is converting & to & and 0F to ?F etc. I am loading the XML string into XDocument and inserting into db using linq. Is there any easy way to replace those characters with actual ones.
View 1 RepliesVB.Net (2008) doesn't seem to allow inserting formating characters (eg.) in String.Format:
'BAD MessageBox.Show(String.Format("{0}{tab}{1}", "Foo", "Bar"))
'BAD MessageBox.Show(String.Format("{0} {1}", "Foo", "Bar"))
MessageBox.Show(String.Format("{0}" & vbTab & "{1}", "Foo", "Bar"))
Is there an easier way to build a formated string that must contain formating characters?
Have the following code which creates a table of all the images in a folder.[code]What I want to do now is group all these by the first two characters and get the total number for each and insert them into individual strings. So for the above example it would be something like:[code]
View 2 RepliesBasically i have a query string that when i hardcode in the catalogue value its fine. when I try adding it via a variable it just doesn't pick it up.This works:
Dim WaspConnection As New SqlConnection("Data Source=JURA;Initial Catalog=WaspTrackAsset_NROI;User id=" & ConfigurationManager.AppSettings("WASPDBUserName") & ";Password='" & ConfigurationManager.AppSettings("WASPDBPassword").ToString & "';")
This doesn't:
Public Sub GetWASPAcr()
connection.Open()
Dim dt As New DataTable()
Dim username As String = HttpContext.Current.User.Identity.Name
[code]....
When I debug the catalog is empty in the query string but the WASP variable holds the value "WaspTrackAsset_NROI"
How would I go about finding a string of text in a text file then underneath that string of text inserting my own string? So far I have this which isn't working:
Dim MyFile() As String = System.IO.File.ReadAllLines(filePath)
Dim MySW As New System.IO.StreamWriter(filePath, False)
Dim Mytempstring As String
Dim StoreInd As String
[Code] .....
far it works! But it work's too well. What I'm trying to do is insert a string of text at a certain index position of a text file, underneath a certain line of text. So far I have:
'Controls Var 16
If CheckBox1.Checked = True Then
If Mytempstring.Contains("zrandomtextz=0") = True Then
Mytempstring = Mytempstring.Replace("zrandomtextz=0", "zrandomtextz=1")
ElseIf Mytempstring.Contains("zrandomtextz=") = False Then
[Code]...
It's inserting the text, but it's inserting it at every line of text in the file. So instead of one instance of "zrandomtextz" underneath "xinserttextx" I get "zrandomtextz" before every single line in the file. Can someone please help me as this has been an issue for months now? Edit: There are quite a few lines above this one, as in 50-150, so I removed all of the above section, however I can assure you that whenever it is simply replacing then writing to file it works flawlessly, it's only now that I'm having problems and this is when I try to insert new stuff under stuff.
I'm using Visual Studio 2010 and automating Outlook 2007. I am writing a program that executes on incoming mail (which I have that working), but I want this program to inspect the subject line for a 5 character string that will be in the format of AB123 (can be any 2 letters followed by any 3 numbers). What is the best method to accomplish that?
View 1 Repliesis it possible to compare a string with substring of other case insensitively
I have tried it through string.compare() but i is case sensitive
if(details_local.Contains(details))
true only if the case matches else it is false
I have a large string in which I need to replace specific strings with other values. For example, within this string I might see the following characters: [[sub id=5]]. I am trying to replace those substrings with values, pulled from a table and based on the id. What would be the simplest way to accomplish this. My first thought was to loop through and examine each character and note their positions when they match the pattern. I would then have to identify the id. That would be fairly complicated, however, and there must be a better way.
View 2 RepliesI have made a code where I write a recipe to a file and then I can read from the file and it is output in a listbox. I need to allow the user to change the amount of people served and then the quantities change to suit the serving number. The serving number is input and the rest of the code works apart from the changing the quantities bit.
The code that I am using is below. I have no idea if i'm doing it right though.
CODE:
I have a couple of textfields in a Windows form. One of these textfields is allowed to be NULL. When I enter a value for every field, it is all inserted, no problem. When I leave the field (txtGewicht) blank, I can't seem to be able to insert NULL in Access Database.
If Double.TryParse(txtGewicht.Text, 0) Then
klant.Gewicht = Double.Parse(txtGewicht.Text)
Else
[Code]....
This is what I get:
"Cannot set column 'Gewicht' to NULL, please use DBNull instead"
So I changed 'Nothing' to DBNull.value, but it then tells me that System.DBNull cannot be converted to type Double.
I need to find all strings in given text file which would look like:
Hi thisisme Bye Bye
Hi thisisyou Bye Bye
Hi someone Bye Bye
so, i need the result to be:
thisisme
thisisyou
someone
also, there is all sorts of other text before this and after this (in source text file)now, i have this, which doesnt work quite well:
Public Function midReturn(ByVal first As String, ByVal last As String, ByVal total As String) As String
If last.Length < 1 Then
midReturn = total.Substring(total.IndexOf(first))
[code]....
Trying to write an app to load a Text file and then search for substrings that contains some specific characters to compose a list. Tried first loading the text file into a StreamReader then search line by line for my substrings. Had to write a lot of code to identify my strings, but it worked ok. Then tried loading the text file into a RichTextBox then use RichTextBox.Find(......) to look for my substrings. The " .Find" property makes the code really simple, but using RichTextBox the app was really slow.
Using Stream the loop was completed in about 2 minutes and using RichTextBox in about 30 minutes! I will need to make a lot of searches and using RichTextBox is lots easier, but is too slow. Is there any way to perform search operations using Streams instead making a loop and go looking line by line??? Or what else would be a good solution to search for strings in a text file??
I am a little bit confused by the following VB statement
commands = Regex.Split(script, _
"GO", _
RegexOptions.IgnoreCase)
I know what regex.split does. I know what the first parameter is. The second parameter is what I'm confused by. I think it is using the word "go" as a delimiter to split the first parameter into an array of substrings. But I don't understand what that refers to.
how can i track how many times a specific word appears in a text box then display the number of times found in a message box?
for example if i type this in a textbox: today is really hot, it is not very convinient to be outside, it is better if we go swimming
and i am looking for the word "is" troughout the sentence, it appears 3 times yet I am not sure how to make a code so it does count the times "is" is being found and then display it with a message:
"your word is found 3 times in this sentence"
I'm trying to add a new record to my database but i keep getting the message - "conversion from type DBnull to type string is not valid". I think its something to do with the Employee ID when VB attempts to save it to the database my code is below
Imports System.Data.OleDb
Public Class Add
Private Sub DisplayRow()
[Code]....
I have problem when i inserted data. the error show String or binary data would be truncated. What is meaning of that??
This my code:
Try
SQLCONNECTIONS.connect()
Dim sqlcmd As New SqlCommand
[Code].....
'Code for inserting Data into the Database
Try
Dim com As New OleDbCommand
com.Connection = con
[Code].....
I'm trying to do an Insert into a couple tables on one form with data controls. The problem is I don't know the approach. You see, the client has books to sell. He has catagories and he wants to add many catagories for each book. One or more catagories. It would seem to me that this is a many to many normalization. Being that one or more catagories can belong to one or more books? If this is incorrect, please tell me, as I thought it was a one to many earlier with one book having one or more catagories? Anyway, I need to be able to allow the client to enter one book, and then assign one or more catagories? He wants the potential buyers to be able to query books by catagories obviously. Wondering what approach to use? What data controls, and is it possible with just the controls, or do I need to write a stored procedure to grab the ID from the book using the @@Identity SQL statment?
View 4 RepliesI have an asp page where I am trying to insert a checkbox value into my SQL db. I converted the value to the byte datatype so that it will be recognized as either a 1 or 0. The column in SQL is a bit datatype.
I currently have this:
[Code]...
My problem is when I try adding a new appointment I get an error that says ""Column 'AppID' does not allow nulls."" Editing existing appointments is fine and it updates the DB no problem. I don't have an INSERT statement right now (which might be the issue) so I was thinking of doing this: INSERT INTO [tablename] ( [column1], [column2], ... ) VALUES ( [value1], [value2], ...) Only problem with that is I would need to use the textbox names for the VALUES, and that form that pops up to gather appointment info is from a third party, and I can't find the names of any text boxes
View 2 RepliesI have the following code:
Code:
Imports System.Data.SqlClient
Public Class Form1
Dim ReturnValue As Object = Nothing
[Code].....
which should return back the next available sunday to me from the database. What I'm getting back is 01/01/0001 - 01/08/0001.
I've tried a couple of versions of this but they all produce the same date.
Basically I am trying to insert some data about a user into a database for a test that they complete. If it's their first time completing the test then I want their results to be automatically stored. If not then I want their results to only be overwritten if they agree to it.
Here's my code so far:
Dim sqlx As OleDbCommand = New OleDbCommand
Dim con As New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" & "Data Source =
[code]......