C# Discussion Boards - CodeProject

6-Dec-05 3:52

Hey,
I'm trying to search for a string in a datatable using DataView.Find, and ran across the Regex class. I got the find and select to work when the whole string is found, but now I need it to work for just part of the string.
Here's what I have so far:
// tCat - the table name
// searchThis - the string I want to find
// dg - the datagrid

DataView dv = tCat.DefaultView; <br />
Regex reg = new Regex(searchThis,RegexOptions.IgnoreCase);<br />
if (searchBy == "cust")<br />
{<br />
dv.Sort = "Customer ASC";<br />
int i = dv.Find(reg);<br />
if(i > dv.Table.Rows.Count || i < 0){MessageBox.Show("No file found");}<br />
else {dg.CurrentRowIndex = i; dg.Select(i);}<br />
}

I saw that IsMatch finds parts of strings, but I need to be sure that only the beginning of a string will partially match, i.e. searching for "rich" will match "Richard", but not "Fredrich".
So at the moment I'm not sure how to incorporate the IsMatch into the code above, as well as make sure that only the beginning of the string is searched.
Thanks again for any help!!!!!
Mel

S. Senthil Kumar6-Dec-05 4:37

6-Dec-05 4:37

Just add the ^ modifier at the beginning of the regex.

searchThis = @"^rich";

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

melanieab6-Dec-05 5:09

6-Dec-05 5:09

Hi again,
I tried this:
searchThis = @"^" + s.SearchThis;
since I'm transferring searchThis over from another class. It didn't work so I changed the line:
int i = dv.Find(@"^Rich");
to test and see if the row containing Richard would highlight, and it didn't.
Is there anything else I may be doing wrong?
Thanks again!
Mel

S. Senthil Kumar6-Dec-05 5:16

6-Dec-05 5:16

Well, the regex matches only if Rich is at the beginning of the string. Like

string x = "Richard rocks"; // would match
string y = "I am rich;" //would not match

Are you sure if the string starts with Rich? Maybe you are dealing with a multiline string? Could you post a sample string?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

melanieab6-Dec-05 5:47

6-Dec-05 5:47

The string definitely seems to start with Rich. I tried substituting the entire name
int i = dv.Find("Richard Chalmers");
and it worked fine. I also tried another test name "Penske", and it again worked ok if "penske" was typed in, but not if I tried @"^Pen".
Confused | :confused:

Mel

S. Senthil Kumar6-Dec-05 6:00

6-Dec-05 6:00

I'm confused now. What does dv.Find do? Could you try out this little code snippet and tell me what it prints and if that's what you expect?

string x = "Richard Rocks";
string y = "My rich uncle";
Regex regex = new Regex(@"^Rich");
Console.WriteLine(regex.IsMatch(x));
Console.WriteLine(regex.IsMatch(y));

It should print True and False. Is that what you expect?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

melanieab6-Dec-05 7:39

6-Dec-05 7:39

Ok, I did get the true and false, but it doesn't make sense (to me) why I'd have trouble below.
What my dv.Find does is get the row number in the datatable that contains "Rich" in it so that I can highlight it.

I have the code in the first post, but where the problem seems to be is:

DataView dv = tCat.DefaultView;<br />
Regex reg = new Regex(@"^Rich");<br />
int i = dv.Find(reg);

When I have "Richard" instead of @"^Rich", it highlights the row just fine.

Any other thoughts????? D'Oh! | :doh:

Thanks again for your help,
Mel

S. Senthil Kumar6-Dec-05 20:36

Custom Controls And Events

6-Dec-05 20:36

You sure DataView.Find handles regexes? MSDN[^] doesn't say anything about it handling regular expressions.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

rich_wenger6-Dec-05 3:48

rich_wenger

6-Dec-05 3:48

I've go a Custom Control that inherits from the TextBox class and I've added a ListBox; I needed to create a custom event exposed to the parent form that would fire when the ListBox changed visiblity. The code below works but I know it's now quite right. Any help appreciated.

Control Code Snippet==============================================

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;

public delegate void ListBoxEvent();

namespace TextBoxLookupLib
{
///

/// Custom Textbox Control
///

public class TextBoxLookup : System.Windows.Forms.TextBox
{
private System.Windows.Forms.ListBox listBox1;
///

/// Required designer variable.
///

private System.ComponentModel.Container components = null;

public event ListBoxEvent ListBoxVisibleChanged;

public TextBoxLookup()
{
// This call is required by the Windows.Forms Form Designer.
InitializeComponent();

// TODO: Add any initialization after the InitComponent call
this.listBox1.Visible = false;
this.listBox1.Width = this.Width;
this.listBox1.TabStop = false;
this.DoubleClick +=new EventHandler(TextBoxLookup_DoubleClick);
this.listBox1.DoubleClick +=new EventHandler(listBox1_DoubleClick);
this.listBox1.VisibleChanged +=new EventHandler(listBox1_VisibleChanged);
ListBoxVisibleChanged += new ListBoxEvent(OnListBoxVisibleChanged);
}

///

/// Clean up any resources being used.
///

protected override void Dispose( bool disposing )
{
if( disposing )
{
if( components != null )
components.Dispose();
}
base.Dispose( disposing );
}

#region Component Designer generated code
///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.listBox1 = new System.Windows.Forms.ListBox();
//
// listBox1
//
this.listBox1.Location = new System.Drawing.Point(17, 17);
this.listBox1.Name = "listBox1";
this.listBox1.TabIndex = 0;
}
#endregion

private void OpenListBox()
{
Control ctlParent = this.Parent;
ctlParent.Controls.Add(this.listBox1);
this.listBox1.Width = this.Width;
this.listBox1.BringToFront();
this.listBox1.Visible = true;

}
private void CloseListBox()
{
this.Focus();
this.listBox1.Visible = false;
this.listBox1.SendToBack();
this.Refresh();
}
private void TextBoxLookup_DoubleClick(object sender, EventArgs e)
{
this.OpenListBox();
}
private void listBox1_DoubleClick(object sender, EventArgs e)
{
this.CloseListBox();
}
private void listBox1_VisibleChanged(object sender, EventArgs e)
{
ListBoxVisibleChanged();
}

public void OnListBoxVisibleChanged()
{
//Why this method call?
}
}
}

Form Code Snippet=============================================

this.textBoxLookup1.ListBoxVisibleChanged +=new ListBoxEvent(textBoxLookup1_ListBoxVisibleChanged);

private void textBoxLookup1_ListBoxVisibleChanged()

{

if(this.textBoxLookup1.ListSelectedValue != null)

this.textBox1.Text = this.textBoxLookup1.ListSelectedValue;

}

"She folds her legs...in doing so I glimpse Xanadu."--Gilby

AutoRedraw

Sabry19056-Dec-05 2:47

Sabry1905

6-Dec-05 2:47

How to save my paint on a form or a picture box ?

.NET Remoting and recorded sound?

mikker_1236-Dec-05 1:27

mikker_123

6-Dec-05 1:27

I'm having trouble finding resources related to sound recording and streaming those files. Effect I want to make is identical to Skype (or other IM) voice chat... I want to be able to capture sound using microphone, compress it, send it over wire using .NET Remoting and than, of course, play it.

However most project I've find deal with saving file to disk, or just compressing some file... So does anyone has some expirience in this field and is willing to share it?

tnx in advance

dll

ambedkar6-Dec-05 1:26

ambedkar

6-Dec-05 1:26

how to create a dll file. where, and how it is used?

Re: dll

Colin Angus Mackay6-Dec-05 1:51

Colin Angus Mackay

6-Dec-05 1:51

ambedkar wrote:
how to create a dll file.

Create a Class Library project

ambedkar wrote:
where, and how it is used?

A DLL is, in .NET, a type of assembly that is usually a Class Library. Code behind for ASP.NET applications compile to DLL files.

It is used to hold libraries of code. For example, The business logic of an application may be put in a DLL in order to separate it from the user interface. A set of custom controls may be put in a DLL. Test fixtures are normally placed in a separate DLL from the set of classes that they test.

Basically, any code that is invoked from somewhere else.

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

algorithm for 6 digits unique number

Ronen Tidhar6-Dec-05 1:12

Ronen Tidhar

6-Dec-05 1:12

Is anyone has an idea how do I generate 6 digits unique number for the same day. (Based on time ?!) The number should be milliseconds difference.

10x
TD

Colin Angus Mackay6-Dec-05 1:19

Colin Angus Mackay

6-Dec-05 1:19

Ronent wrote:
how do I generate 6 digits unique number for the same day

same day as what? To what is the day in comparison?

Confused | :confused:

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

J4amieC6-Dec-05 2:25

J4amieC

6-Dec-05 2:25

A quick check of the number of milliseconds in a day gives 86400000

TimeSpan ts = new TimeSpan(1,0,0,0,0);<br />
Console.WriteLine(ts.TotalMilliseconds);

So, first point you are not going to be able to generate a unique 6 digit number, that is millisecond different, based on the current millisecond in a given day.

Lets see how accurate it could be....

Max 6 digit number = 999999
Milliseconds in a day = 86400000
Spread = 86400000 / 999999 = 86.4ms (approx)

So every 86.4ms (thats 0.086 seconds) a new number would be generated, every call to generate a number within that timespan would create the same number.

Now, your choices

1) If your app will never make a call to generate this number as frequently as every 100ms, you are free to use the above solution. Just get the current number of miiliseconds since midnight, divide by (approx - do the math) 86.4, round to the nearest integer and you will have a 6 digit whole number.

2) If you DO actually need this accurate within 1ms (which i doubt) you can use a bigger number (Milliseconds is usually depicted as an int).

Ronen Tidhar7-Dec-05 1:07

Ronen Tidhar

7-Dec-05 1:07

10x a lot

I guess that's very close to what I need

Ronen Tidhar7-Dec-05 1:51

Ronen Tidhar

7-Dec-05 1:51

J4amieC hi,

I used your idea and by using Hexadecimal format,
I succeed to reduce it to 8 milisecond.

decimal i = (decimal)(new TimeSpan(1,0,0,0,0).TotalMilliseconds / 9999999);
DateTime d = DateTime.Now;
TimeSpan timeSpan = d.Subtract(new DateTime(d.Year, d.Month, d.Day));
double ml = timeSpan.TotalMilliseconds;
int ii = (int)((decimal)ml / i);
Console.WriteLine("ii=" + ii.ToString("X"));

10x
TD