C# Discussion Boards - CodeProject

elizabeth mwash9-May-10 21:51

9-May-10 21:51

am new to linking c# to a database
am supposed to add OleDbDataAdapter to my code....is this a method and kindly show me how to do this

Regards,
Elizabeth

Re: OLEDB PROBLEM

Estys9-May-10 22:07

Estys

9-May-10 22:07

Introduction :
OleDbDataAdapter

Cheers

^I _don't like ^my _signature at ^all

split strings.

AndieDu9-May-10 21:31

AndieDu

9-May-10 21:31

Hi All,

I have this string: "1x #234 Greenock Creek - Alice's - Shiraz - 2001 - 750mL = $578.05 1x #242 Greenock Creek - Cornerstone - Grenache - 2001 - 750mL = $297.55 2x #363 Maxwell - Ellen Street - Shiraz - 2002 - 750mL = $309.10 2x #369 Maxwell - Meracus 53 - Shiraz Grenache - 2002 - 750mL = $226.60"

Now i want to split this string like this:
1x #234 Greenock Creek - Alice's - Shiraz - 2001 - 750mL = $578.05
1x #242 Greenock Creek - Cornerstone - Grenache - 2001 - 750mL = $297.55
2x #363 Maxwell - Ellen Street - Shiraz - 2002 - 750mL = $309.10
2x #369 Maxwell - Meracus 53 - Shiraz Grenache - 2002 - 750mL = $226.60

I was tring to load this string into an array of char, but the performance will be affected since i have a pretty large string input. Are there any other ways to split this string.

Thanks very much.

Re: split strings.

Pete O'Hanlon9-May-10 22:40

Pete O'Hanlon

9-May-10 22:40

You can do this with a fairly naive regex. I'm no regex expert, but I quickly knocked this one together which should satisfy your requirements here:

Regex regex = new Regex(
    @"\d+x\s\#\w*[^$]+\$\d+\.\d+",
    RegexOptions.IgnoreCase
    | RegexOptions.Multiline
    | RegexOptions.ExplicitCapture
    | RegexOptions.IgnorePatternWhitespace
    | RegexOptions.Compiled
    );

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: split strings.

AndieDu10-May-10 15:12

AndieDu

10-May-10 15:12

Thanks for your posting, but you regular expression is not working. and this is supposed to be: @"([0-9][x]\s#[0-9]+\s[A-Z,a-z,\s,',0-9]+\s-\s[A-Z,a-z,\s,',0-9]+\s-\s[A-Z,a-z,\s,',0-9]+\s-\s[0-9]+\s-\s[0-9]+mL\s=\s[$][0-9,.]+)", but it is verbose, and i need to refine it.

Re: split strings.

AndieDu10-May-10 18:27

AndieDu

10-May-10 18:27

I worked out, here is the solution:

string input = "1x #234 Greenock Creek - Alice's - Shiraz - 2001 - 750mL = $578.05 1x #242 Greenock Creek - Cornerstone - Grenache - 2001 - 750mL = $297.55 2x #363 Maxwell - Ellen Street - Shiraz - 2002 - 750mL = $309.10 2x #369 Maxwell - Meracus 53 - Shiraz Grenache - 2002 - 750mL = $226.60";

string pattern = "([0-9][x] #)";
string[] substrings = Regex.Split(input, pattern);

for (int i = 0; i < substrings.Length; i++)
{
if (substrings[i] != "")
{
int j = i + 1;
Console.WriteLine(substrings[i] + substrings[j]);
i++;
}
}

Console.ReadLine();

Re: split strings.

PIEBALDconsult10-May-10 19:29

PIEBALDconsult

10-May-10 19:29

Here's a RegEx:

(?'Quantity'\d+)x #(?'Number'\d+) (?'Winery'[^-]+)- (?'Brand'[^-]+)- (?'Type'[^-]+)- (?'Year'\d+) - (?'Size'[^=]+)= (?'Price'[0-9$\.]+)

Some of the values may need trimming.

context menu display orientation [modified]

Maddie from Dartford9-May-10 21:13

Maddie from Dartford

9-May-10 21:13

Hi,
I have created multiview C# form application and I am displaying context menu on mouse click event. Generally the display direction of menu click is towards right and it encroaches to the other view if I click the mouse near the edge of one view.

I want that if context menu is crossing the boundry it should be displayed in opposite direction in within the same view limit. How can I do it?

Thanks in advance.

modified on Monday, May 10, 2010 3:54 AM

Re: context menu display orientation

Henry Minute10-May-10 1:09

Henry Minute

10-May-10 1:09

This[^] from MSDN might help.

RTFD! Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

comparing ini files

Member 5903109-May-10 19:53

Member 590310

9-May-10 19:53

hi,
i have two ini files with same format and i have to compare them and if any change in new ini file then corporate the change in old one.hw to do that?

Re: comparing ini files

Estys9-May-10 20:37

Estys

9-May-10 20:37

Why don't you just replace the old one with the new one?

Cheers

^I _don't like ^my _signature at ^all

Re: comparing ini files

Member 5903109-May-10 20:45

Member 590310

9-May-10 20:45

no i have to jst look at keys in new ini and change respective values in old ini.I dnt want to replace.

Re: comparing ini files

Member 5903109-May-10 20:53

Member 590310

9-May-10 20:53

reason for not using replace method is i have to skip some specific keys and change others.

Re: comparing ini files

Estys9-May-10 20:59

Estys

9-May-10 20:59

More info here :
http://www.codeproject.com/KB/cs/cs_ini.aspx[^]

Cheers

^I _don't like ^my _signature at ^all

Re: comparing ini files

Peace ON9-May-10 20:52

Peace ON

9-May-10 20:52

You can use "Notepad++", it has compare feature in it's Plugins menu.
From here you can compare two file which are text based..(i.e. .txt, .doc, etc and also .ini)

You can download it from following link, it's totally free

http://notepad-plus.sourceforge.net/uk/download.php[^]

Hope this will help!

Jinal Desai - LIVE
Experience is mother of sage....

Re: comparing ini files

Member 5903109-May-10 20:57

Member 590310

9-May-10 20:57

i have to do it programatically.

Re: comparing ini files

Peace ON9-May-10 21:09

Peace ON

9-May-10 21:09

Then you can load both files in string using streamreader
and then you can compare by using equal function of it.

Jinal Desai - LIVE
Experience is mother of sage....

Re: comparing ini files

Abhinav S9-May-10 21:13

Abhinav S

9-May-10 21:13

Comparing two text files can be tricky business and may need some complex algorithms.
If you just have a few keys in your file, then it might just be faster for you to load both files in a dictionary and then compare the values.

Checking Identity field or not Using SMO

Nandakumar.n.pai9-May-10 18:27

Nandakumar.n.pai

9-May-10 18:27

I am Using Smo to Generate Insertion Script of the database.

How can I check whether a field is Identity or not Using SMO?

Re: Checking Identity field or not Using SMO

Ankur^\m/9-May-10 19:43

Ankur^\m/

9-May-10 19:43

Column.Identity Property[^]

..Go Green..

ListBox SelectedItem

Illegal Operation9-May-10 15:08

Illegal Operation

9-May-10 15:08

Hi,

I have created 2 ListBoxes. ListBox1 gets its values from a dataset. I need to enable the user to select an item in listbox1 and then move it to listbox2. The problem I am having is the following:

When I select an item in listbox1 and click the button to move that item to listbox2, I get System.Data.DataRowView. How can I display the SelectedItem in ListBox2 instead of System.Data.DataRowView?

Thanks!

Illegal Operation

Re: ListBox SelectedItem

Paramhans Dubey9-May-10 19:14

Paramhans Dubey

9-May-10 19:14

Listbox2.Items.Add(Listbox1.SelectedItem.Text)

Message Removed

9-May-10 11:05

mrkeivan

9-May-10 11:05

Message Removed

Re: Opening and printing PDF