Write Dataset to SQL - C# Discussion Boards

L Henson22-Aug-07 5:13

L Henson

22-Aug-07 5:13

Just a couple of ideas:
1) Call BeginUpdate before you add the nodes and then EndUpdate once you are done.
2) If possible, use the Nodes.AddRange method instead of the Nodes.Add method.

Regardless, half a million lines in a treeview sounds a tad daft...

martin_hughes22-Aug-07 5:46

martin_hughes

22-Aug-07 5:46

I think your approach is wrong here - populating anything user oriented (except my bank account) with 500,000 somethings is pointless. No user would be able to make sense of that much data.

"It was the day before today.... I remember it like it was yesterday."

-Moleman

pbraun22-Aug-07 8:40

pbraun

22-Aug-07 8:40

I agree. The approach is wrong. There are other approaches that work better. I'm betting that someone somewhere has implemented a control that can keep a portion of the file in the visible window while the user scrolls up or down. It may not be the ideal solution, but it definitely is not the worst.

Phil

Re: Saving PageSetupDialog.PageSettings;

Whytespot22-Aug-07 10:44

Whytespot

22-Aug-07 10:44

Load it dynamically. On form load, load the first-level tree nodes, and when the user expands and individual node load it's children.

If they are all first-level nodes you have some serious design issues to deal with.

Luc Pattyn22-Aug-07 4:39

Luc Pattyn

22-Aug-07 4:39

Hi,

within a single run of your app you can get this for free by creating the
dialog only once, and reusing it over and over.

Across app sessions, you obviously would need to store and retrieve the info
somehow.

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

Re: Saving PageSetupDialog.PageSettings;

udikantz22-Aug-07 5:09

udikantz

22-Aug-07 5:09

hey thanks for the reply,
ofcourse my problem is on Across app sessions,
the problem is when i store the PageSettings
and and set the PageSetupDialog.PageSettings
it shows the default values... and not the values that i have saved.
and im sure that the PageSettings that i have saved in the Properties
do not contain the default values...

maybe when you do PageSetupDialog.PageSettings = somePageSettings;
it doesnt effect the PageSetupDialog... i dont know cause evrything
i do results with displaying the default values again...

Net

Write Dataset to SQL

GermanDM22-Aug-07 3:50

GermanDM

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

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

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

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

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

Martin#22-Aug-07 4:47

Martin#

22-Aug-07 4:47

You are wellcome!

All the best,

Martin

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

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[^]

KETAN.RK22-Aug-07 5:01

KETAN.RK

22-Aug-07 5:01

Hi,
J4amieC

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

KK

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[^]