Problem in DataSet - C# Discussion Boards

First Prev Next

Re: Combobox Selection from Sql

boiDev9-Feb-09 23:56

boiDev

9-Feb-09 23:56

Thank You

Auto text match and replace

M3rov1ngian9-Feb-09 22:25

M3rov1ngian

9-Feb-09 22:25

Hi,

I need to create a simple application where a user types in an abbreviation of a word and this is automatically changed into the full word. The text can be entered in any application e.g. MS Word, MS Excel, Notepad, E-mail, Blog, etc.

A simple example:

Use enters.. tc<space>mw.
System recognizes a space, comma or any other punctuation and replaces the text to.. take care Matthew White.

tc -> take care
<space> triggers the previous action
mw -> Matthew White
fullstop triggers the previous action

Basically, the application matches the entered text to a dictionary (edited by user) and replaces the word with the meaning. Also the program can be running in the task bar allowing the user to disable the feature.

10x

Re: Auto text match and replace

Smithers-Jones9-Feb-09 22:33

Smithers-Jones

9-Feb-09 22:33

Sounds like fun.

Re: Auto text match and replace

Ashfield10-Feb-09 1:36

Ashfield

10-Feb-09 1:36

M3rov1ngian wrote:
I need to create a simple application

Well, what you are descibing does not fit this category, at least to my mind, but if you think its a simple application go ahead and create it - I would be interested in seeing the finished product.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Auto text match and replace

M3rov1ngian10-Feb-09 11:48

M3rov1ngian

10-Feb-09 11:48

Thanks for the reply Bob,

I already have the program working for text entered in a win form in my application Smile | :)

, but I need this functionality to work system wide automatically for other applications. Have you got any idea how can I achieve this? Confused | :confused:

Thanks

Re: Auto text match and replace

Ashfield10-Feb-09 21:31

Ashfield

10-Feb-09 21:31

As I said, its far from simple and to be honest I have no idea how you are going to do it - you need to hook into ANY app that has a text area and monitor key presses.

All I can say is good luck.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Change date format setting of {Regional and Language Options}

M Riaz Bashir9-Feb-09 22:00

M Riaz Bashir

9-Feb-09 22:00

Hi,

kindly help me, I want to change date format setting example => 21-01-2009 of "Regional and Language Option" using C#.

Thank you in advance
(Riaz)

Problem in DataSet

vinay_K9-Feb-09 21:31

vinay_K

9-Feb-09 21:31

hi.

Please see the following code.

HistoryData is also a dataset..

string strExpression = "Date >= '1/2/2009' And Date <= 2/2/2009"

Dataset dsData =  HistoryData;
DataSet dsNew = new DataSet();

DataTable dt = dsData.Tables[0];  

DataRow dr = dt.Select(strExpression);

in the above code it gives the filtered rows into dr.

but i need to apply the select command to dataset and copy the filtered data into new dataset.

Please help me..

Re: Problem in DataSet

Kaushal Arora9-Feb-09 23:53

Kaushal Arora

9-Feb-09 23:53

Hi,

first of all the statement:
DataRow dr = dt.Select(strExpression);
will return the array of rows not a single row. So it will be
DataRow[] dr = dt.Select(strExpression);

After this you can traverse in the DataRow using Foreach and then can add the same in the new table having same columns(structure)

foreach (DataRow dr in dt.Select(strExpression))
{
DataRow drRow = newtable.NewRow(); // newtable having same structure as of the main table dt
drRow["Column1"] = dr["Column1"].ToString();
drRow["Column2"] = dr["Column2"].ToString();
drRow["Column3"] = dr["Column3"].ToString();
...
drRow["Columnn"] = dr["Columnn"].ToString();
drRow.Rows.Add(drRow);
newtable.AcceptChanges();
}

This way you can get a new table having required rows.

Regards,
Kaushal Arora

Re: Problem in DataSet

Abdul Rahman Hamidy10-Feb-09 1:10

Abdul Rahman Hamidy

10-Feb-09 1:10

I think better to use DataView to create new table instead looping through all filtered rows and add them to datatable
i am suggesting following
[code]
DataView dva1=new DataView(dataTable or dataSet);
DataTable dt=dva1.toTable(filterString);
[/code]

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: Problem in DataSet

Kaushal Arora6-Apr-09 23:05

Kaushal Arora

6-Apr-09 23:05

I didnt find any option in which i can give the filterstring in the arguments.
Kindly elaborate the answer in detail. If you have any sample code then share.

MyBrowser - Kickstart C# , Make your own Web Browser in few easy steps

three6t9-Feb-09 21:24

three6t

9-Feb-09 21:24

This small tutorial will guide a newbie to make a minamilistic web browser with just three form controls

http://360-computing-tutorials.blogspot.com/2009/02/mybrowser-c-make-your-own-web-browser.html[^]

Re: MyBrowser - Kickstart C# , Make your own Web Browser in few easy steps

musefan9-Feb-09 23:24

musefan

9-Feb-09 23:24

Did somebody ask for a this? usually the people who might struggle with this kind of process are those who tend only to be interested in there own problems and prob wouldnt read other posts.

Dont mean no get you down with this, i think its very good of you to create any kind of tutorial that may help others, i just dont agree with you posting a link here

P.S i counted 4 controls in the tutorial

My opinion is... If someone has already posted an answer, dont post the SAME answer

Re: MyBrowser - Kickstart C# , Make your own Web Browser in few easy steps

Mycroft Holmes10-Feb-09 1:25

Mycroft Holmes

10-Feb-09 1:25

It's actually blog spamming and is quite rude. The reason for the down voting.

The usual method is to publish the article here and link your blog to the article, that would be appreciated rather than spamming.

Never underestimate the power of human stupidity
RAH

Re: MyBrowser - Kickstart C# , Make your own Web Browser in few easy steps

EliottA10-Feb-09 3:02

EliottA

10-Feb-09 3:02

Did you just copy and paste from Microsofts' "Build a program NOW!" book and say it's your own steps? Jeez, the plagiarists these days..

Check out the CodeProject forum Guidelines[^]

StreamReader + ProgressBar Help

MumbleB9-Feb-09 20:46

MumbleB

9-Feb-09 20:46

Hi Guys. I am in the process of making my app slightly more efficient. I have been using the FileHelpers engin previously but it it was too slow in that it reads the whole file into the Array before processing it. I have changed this to use a StreamReader instead which speeds up the processing of the file dramatically as it reads one line at a time. Now, my problem is that I can't seem to get my progressbar to work properly. It seems to reach 100% before the full file has been processed. Anybody have any ideas? I have Googled and can't find an appriopriate solution for it. Below my Progressbar code.

private void UpdateProgress()
{
    string filepath;
    filepath = txtboxSelectTxtFile.Text;

    FileInfo fi = new FileInfo(filepath);
        progressBar1.Minimum = 0;
        progressBar1.Maximum = Convert.ToInt32(fi.Length) / 1000;
        progressBar1.Value = progressBar1.Value + 1;
        int progrval = 0;
        progrval = progressBar1.Value;
        progrval = progrval + 1;
        lblProgress.Text = ((progrval * 100) / Convert.ToInt32(progressBar1.Maximum)).ToString();
        lblProgress.Refresh();
        lblPercent2.Refresh();
        lblRecordProcessed.Text = progrval.ToString();
        lblProgText.Refresh();
        lblRecordProcessed.Refresh();

}

The error I get is "Value of '237' is not a valid value. Value must be between minimum ad maximum.

From this I take it that I am not calculating the Max value correctly. I see no other way to the max value than using FileInfo.

Excellence is doing ordinary things extraordinarily well.

Re: StreamReader + ProgressBar Help

ABitSmart9-Feb-09 23:56

ABitSmart

9-Feb-09 23:56

From where is UpdateProgresss called ?

Guessing,
Are you calling it after reading everyline ? If yes, then the problem might be here,

Kwagga wrote:
progressBar1.Maximum = Convert.ToInt32(fi.Length) / 1000;

The file lenght being 236000, the max limit gets set to 236. But when you call for line 237 the max limit is crossed.

Re: StreamReader + ProgressBar Help

musefan10-Feb-09 0:01

musefan

10-Feb-09 0:01

Hmmm... i think you doing the whole thing wrong

you said you making effecient then you should def use another thread. I would suggest placing a background worker in your application, then updating the progress bar with the ReportProgress handler.

This is actually not a difficult task to do so you should give it a go. The other issue i find with other threads is debugging errors, but as you have tested code already in UI thread then im sure it would work fine

If you insist on sticking with single thread, then try creating an 'outside the loop' variable for the percentage increase per update, and setting the progress bar value to match that

i.e.

float percentIncrease = 100 / fileinfo.length;//this give you a number to update with per byte

then for each byte processed

ProgressBar.Value = (int)(byteCount * percentIncrease);

something like that anyway Smile | :)

My opinion is... If someone has already posted an answer, dont post the SAME answer

Re: StreamReader + ProgressBar Help

MumbleB10-Feb-09 0:07

MumbleB

10-Feb-09 0:07

I am calling the progressbar from a different thread already. The progressbar code is running in it's own thread called after each line of data is processed. Now, I see that StreamReader doesn't have a Length option to use so i can't use that. I was playing around with FileInfo earlier but couldn't get that to work properly as well. I'll just keep trying and hopefully stumble on something that works.

Excellence is doing ordinary things extraordinarily well.

Re: StreamReader + ProgressBar Help

musefan10-Feb-09 0:17

musefan

10-Feb-09 0:17

Is there a need to process with ReadLine()? If you can process per bytes then you can use StreamReader.BaseStream and then you can get length from that.

If you need lines for whatever reason then i think your best a approach would be a quick loop through the file and count the line, a simple loop like the following should not take alot of processing time.

StreamReader sr = new StreamReader("file");

int lineCount = 1;// set 1 for first readline
string line = sr.ReadLine();

while(line != null)
{
line = sr.ReadLine();
lineCount++;
}

sr.Close();

My opinion is... If someone has already posted an answer, dont post the SAME answer

Re: StreamReader + ProgressBar Help

ABitSmart10-Feb-09 1:22

ABitSmart

10-Feb-09 1:22

int lines = File.ReadAllLines("filename").Length;

This should give you the number of lines. The entire file is buffered and so if the file is huge you could come into trouble. Else the loop mentioned by musefan is another option.

But still, your code is failing for the reason as I pointed out before.

Re: StreamReader + ProgressBar Help

MumbleB10-Feb-09 2:25

MumbleB

10-Feb-09 2:25

Thanks guys. This method seems to work just fine.

Excellence is doing ordinary things extraordinarily well.

Simple Midia player code

Member 39168569-Feb-09 20:38

Member 3916856

9-Feb-09 20:38

Simple Midia player code

Re: Simple Midia player code