|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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..
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 
My opinion is... If someone has already posted an answer, dont post the SAME answer
|
|
|
|
|
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.
|
|
|
|
|
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;
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
|
|
|
|
|
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.
|
|
|
|
|
Thanks guys. This method seems to work just fine.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
|
Well, quite.
Regards,
Rob Philpott.
|
|
|
|
|
A new year and Homework time again!!! When does it end......  
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Hi All,
I want to create a window project, which has a vertical menu like follow:
Menu Query Save Delete
Form A display data area form A(B..)
Form B
Form C
Could you help me?
Thank you very much
Papais
|
|
|
|
|
You can use a Menustrip Control, look at your Toolbox "Menus & ToolBars" there are Menu's there
Hope it Helps
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
Hi
I would like to know write C# code for accessing dongle
|
|
|
|
|
Just a guess, but you might want to look how to read/write from the port as you insert a dongle there.
But I never did it so I might be totally wrong 
|
|
|
|
|
Hi.
I need to regitser a UltraToolbarManager(Infragestic Control) to CAB SCSF inorder to add Toolbar items at runtime..
For that i changed FormShellApplication to IGFormShellApplication, But it is giving following error.
<br />
Error 4 The type 'Microsoft.Practices.CompositeUI.WinForms.WindowsFormsApplication`2<T0,T1>' is defined in an assembly that is not referenced. You must add a reference to assembly 'Microsoft.Practices.CompositeUI.WinForms, Version=1.0.51205.0, Culture=neutral, PublicKeyToken=null'. C:\VinayCarrick\iQ-PlusClient\Source\Infrastructure\Infrastructure.Library\SmartClientApplication.cs 25 27 Infrastructure.Library<br />
Can anyone help me how to solve this issue.
thanks in advance
|
|
|
|
|
May i know in which blog i need to ask this question..?
|
|
|
|
|
hai
i am developed an application to detect web cam and get the video in panel control.
now i want to read the video stream and send that video stream to remote machine.
please help me to get the source code
Thanks
|
|
|
|
|
hi all,
I am creating online registration form application for an event .i have completed my registration process.
now when candidate click on submit button,an email should send to that candidate's email id...it should have his/her reg no. how cani do that,plz help me.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
