Re: string.IndexOf help - C# Discussion Boards

GermanDM22-Aug-07 3:50

22-Aug-07 3:50

Hi,

Can anybody please assist me with the following.I have googled but no luck.

I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database?
The dataset contains three tables and the sql database destination has the exact same tables and columns.

any help, suggestions or articles will be greatly appreciated.

Re: Write Dataset to SQL

Vasudevan Deepak Kumar22-Aug-07 5:00

Vasudevan Deepak Kumar

22-Aug-07 5:00

http://www.codeproject.com/useritems/GenerateSQL.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Write Dataset to SQL

costavo22-Aug-07 5:00

costavo

22-Aug-07 5:00

did u try doing a stored procedure and an insert sql command?

Re: Write Dataset to SQL

Giorgi Dalakishvili22-Aug-07 5:01

Giorgi Dalakishvili

22-Aug-07 5:01

Did you search here on codeproject? I'm sure you will find necessary articles.

#region signature
my articles
#endregion

string.IndexOf help

solutionsville22-Aug-07 3:28

solutionsville

22-Aug-07 3:28

I want to take the value of textBox1.text, pass it to a find routine and then display the results of all lines that have the given text.

The find portion I have figured out. the IndexOf routine I have not figured out.

Here is my find routine;

private void btnFind_Click(object sender, System.EventArgs e)
{
try
{
int StartPosition;
StringComparison SearchType;
if (chkMatchCase.Checked == true)
{
SearchType = StringComparison.Ordinal;
}
else
{
SearchType = StringComparison.OrdinalIgnoreCase;
}
StartPosition = mMain.rtbDoc.Text.IndexOf(txtSearchTerm.Text, SearchType);
if (StartPosition == 0)
{
MessageBox.Show("String: " + txtSearchTerm.Text.ToString() + " not found", "No Matches", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
mMain.rtbDoc.Select(StartPosition, txtSearchTerm.Text.Length);
mMain.rtbDoc.ScrollToCaret();
mMain.Focus();
btnFindNext.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error");
}
}

Lets say I want to search for and display every line that has the word "one" in it and then display it in a RichTextBox

one plus four
two plus four
three plus four
one minus four
one divided by four
two minus four
two divided by four
three plus five
three minus five

When the search is done, it show like this in the RTB with nothing else.;

one plus four
one minus four
one divided by four

Thanks in advance!

Brian

Re: string.IndexOf help

Martin#22-Aug-07 3:45

Martin#

22-Aug-07 3:45

Hello,

I'm not sure if I understand you right,
but if you have a multiline TextBox and want to iterate over the lines to find the lines with a search string in it.

Then use a method like this:

using System.Collections.Specialized;
 
public static StringCollection FindLinesOverSearchString(string[] LinesToSearch, string TextToSearch)
{
	StringCollection resultLines = new StringCollection();
	if(LinesToSearch!=null)
	{
		foreach(string actLine in LinesToSearch)
		{
			if(actLine.IndexOf(TextToSearch)!=-1)
			{
				resultLines.Add(actLine);
			}
		}
	}
	return resultLines;
}

And call it like this:

StringCollection textboxresult = FindLinesOverSearchString(yourTextBox.Lines, "searchstring");

All the best,

Martin

Re: string.IndexOf help

solutionsville22-Aug-07 4:06

solutionsville

22-Aug-07 4:06

Martin, if I understand you correctly,

The method will find what I want.

I am not sure I understand how I take the value of the textbox as a string and pass it to the above routine and then get it to the second textbox.

I understand the string collextion piece, as it looks fairly simple in that respect.

Thanks,

Brian

Re: string.IndexOf help

Martin#22-Aug-07 4:30

Martin#

22-Aug-07 4:30

solutionsville wrote:
I am not sure I understand how I take the value of the textbox as a string and pass it to the above routine

You don't need to do that.

The method I posted, takes a string[] as parameter for the lines to search.
The TextBox class has a property called "Lines" which is type of string[], and this will be passed as parameter.

FindLinesOverSearchString(yourTextBox.Lines, "searchstring");

The second parameter is quit simple the string to search.

The result is in my case a dynamic collection of the type: System.Collections.Specialized.StringCollection.
This class has an "Add" method, which will be used to add the matching line to the collection.

If you now have the result and want to show it in a second multiline textbox:

//Again the method call for the search
StringCollection resultLines = FindLinesOverSearchString(yourTextBox.Lines, "searchstring");
 
//create a new instance of string[], with the needed lenght
string[] resultAsStringArray = new string[resultLines.Count];
//copy data of StringCollection to the new string[]
resultLines.CopyTo(resultAsStringArray,0);
//path it to the result TextBox "Lines" property
yourTextBoxResult.Lines = resultAsStringArray;

Hope it helps!

All the best,

Martin

Re: string.IndexOf help

solutionsville22-Aug-07 4:43

solutionsville

22-Aug-07 4:43

That explains it better. I will have to mull this over a little more before I get it to sink in and work the way we are talking about.

Thanks for the help!

Brian

Re: string.IndexOf help

Martin#22-Aug-07 4:47

Martin#

22-Aug-07 4:47

You are wellcome!

All the best,

Martin

Re: string.IndexOf help

Justin Perez22-Aug-07 3:46

Justin Perez

22-Aug-07 3:46

solutionsville wrote:
Lets say I want to search for and display every line that has the word "one" in it and then display it in a RichTextBox

Here's how you can use IndexOf()

<br />
int hasOne;<br />
<br />
string strWorkString = string.Empty;<br />
strWorkString = "one plus 3";<br />
<br />
hasOne = strWorkString.IndexOf("one");<br />

That will report where in the string "one" is found. Also,

solutionsville wrote:
MessageBox.Show("String: " + txtSearchTerm.Text.ToString() + " not found", "No Matches", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

When you do that, you should really use string.Format(). Do it like so:

<br />
MessageBox.Show(string.Format("String: {0} not found", txtSearchTerm.Text.ToString()), "No Matches", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);<br />

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

C# DATE FORMAT

KETAN.RK22-Aug-07 3:09

KETAN.RK

22-Aug-07 3:09

PLS TELL ME HOW TO FORMAT STRING TO DATE FORMAT YYYYMMDD

KETAN

Re: C# DATE FORMAT

J4amieC22-Aug-07 3:10

J4amieC

22-Aug-07 3:10

YOU DONT NEED TO SHOUT!!!

But as you (almost) said please:

myDate.ToString("yyyyMMdd");

---

How to get answers to your questions[^]

Re: C# DATE FORMAT

KETAN.RK22-Aug-07 5:01

KETAN.RK

22-Aug-07 5:01

Hi,
J4amieC

Well done Baby...........
Keep it up.....

KK

Re: C# DATE FORMAT

J4amieC22-Aug-07 5:56

J4amieC

22-Aug-07 5:56

KETAN.RK wrote:
Well done Baby...........
Keep it up.....

---

How to get answers to your questions[^]

Re: C# DATE FORMAT

Levon Nalbandyan22-Aug-07 3:32

Levon Nalbandyan

22-Aug-07 3:32

Try
DateTime.Parse (string s,IFormatProvider provider)

tooltips

Sunshine Always22-Aug-07 2:11

Sunshine Always

22-Aug-07 2:11

hi my application is written in Compact framework 2003. it works for both on desktop and device but i need to show tooltips for the desktop version. the tooltip control is not present as it is CF.
any help please...
thanks.

Re: tooltips

SpiveyC#22-Aug-07 3:45

SpiveyC#

22-Aug-07 3:45

does the controls have the tooltip in its properties ?

Re: tooltips

Sunshine Always22-Aug-07 3:58

Sunshine Always

22-Aug-07 3:58

this is what i do if the application is in .NET Framework
private void button1_MouseHover(object sender, System.EventArgs e)
{
toolTip1.SetToolTip(button1,"Hello World");
}

toolTip1 is an object of the ToolTip control present in the toolbox. but i dont have this control in the toolbox for compact framework.

Re: tooltips

Luc Pattyn22-Aug-07 4:20

Luc Pattyn

22-Aug-07 4:20

Hi,

the tooltip will show itself automatically, you don't need to bother about
the hover event. Just do toolTip1.SetToolTip(button1,"Hello World"); once,
maybe in your form's constructor or its Load event.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

Wierd req from boss

SpiveyC#22-Aug-07 2:10

SpiveyC#

22-Aug-07 2:10

My boss wants me to add a function in the customer sign up that checks a database against wanted terrorists and their alias names they are using. Anyone know if there is a public database to query for names and photos.

Re: Wierd req from boss

Giorgi Dalakishvili22-Aug-07 2:12

Giorgi Dalakishvili

22-Aug-07 2:12

Why don't you ask him to give you the list?

#region signature
my articles
#endregion

Re: Wierd req from boss

PIEBALDconsult22-Aug-07 5:12

PIEBALDconsult

22-Aug-07 5:12

Whoo hoo! The "Wally Reflector"[^]!

Re: Wierd req from boss

Dan Neely22-Aug-07 5:37

Dan Neely

22-Aug-07 5:37

I get a dead link trying to access the readable version of the comic.

--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer

Re: Wierd req from boss

PIEBALDconsult22-Aug-07 5:58

PIEBALDconsult

22-Aug-07 5:58

Alas, that was the best I could find at a moment's notice.
I, of course, have it as a newspapaer clipping taped to my wall.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.