|
Hi,
From datatable, how to get data with distinct values along with one condition. Its like type='S' and distinct on one columns(id).
Thanks in advance.
modified on Friday, April 16, 2010 4:14 AM
|
|
|
|
|
Could you please elaborate your question. Are "id" and "classid" primary keys in your tables - then they are of course unique.. If you made a query on tables with the "id" and "classid" as pKey's then the select distinct should help you out in the sql statement. Maybe I didn't really get your question though.. 
|
|
|
|
|
I've a datatable. type and id are the columns of datatable. I would like to filter the datatable using select method on a condition(type='s') and distinct on one column(id).
like datatable.Select("type='S' distinct id);
Hope this is clear. If not, please let me know.
|
|
|
|
|
the problem is solved. hope the solution might help some one.
DataRow[] dr = dtSimple.Select("type='S'");
foreach (DataRow dr1 in dr)
{
dt1.ImportRow(dr1);
}
DataView dv = dt1.DefaultView;
//below line gives the distinct values of column "id"
dt1 = dv.ToTable(true, "id");
|
|
|
|
|
Hi,
I have a winform application and want to add some reports to it.
Because my Data Access Layer can do MsSQL, Access, MySQL and Oracle I search for a "database independent" solution (now I use generally SQL Express). If posible I like the idea to have standalone reports so If I need to change the report I don't need to rebuild the entire solution.
I'am searching for a good tutorial to do this and have quick an easy to implement reports!
I know the first answer on this post is: Search google, but i've been there and can't find an good answer on the question so far... only more questions 
Is there someone who can give me a good hint?
thanks
|
|
|
|
|
Designing a RDLC report file and shipping into the winform application would be easy. Even if you want to change the report design, it does not require a solution build again. You can easily go ahead and change the report design. Copy the rdlc report file to the application folder and see the changes are reflecting or not.
CodingRocks
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
|
Wow. A little impatient are you? You posted that question at 3:00AM my time. Sorry, we were asleep in the States.
I highly suggest reading the forum posting guidelines at the top of each forum.
|
|
|
|
|
hiiii friends,
I am facing problem in opening crystal report.
It gives error saying Invalid username or Password
I have three reports in my application.Two of three are opens successfully but one reports asks for username and password.
I have provided servername,username,password carefully in my source code.
When i run the application from visual studio,it runs perfect.
but in case of installing application from setup it gives that error.
I think some of the components are missing.but In such case any of the reports from three should not open.
Thank in advance.
Please help me to solve this issue.
|
|
|
|
|
Hello,
I am trying to get something to run after each print job is complete.
Currently I use this to cut paper after each print job by pressing "A":
private void Form1_Load(object sender, EventArgs e) {<br />
gkh.HookedKeys.Add(Keys.A);<br />
gkh.KeyDown += new KeyEventHandler(gkh_KeyDown);<br />
gkh.KeyUp += new KeyEventHandler(gkh_KeyUp);<br />
}<br />
<br />
void gkh_KeyUp(object sender, KeyEventArgs e) {<br />
CutPaper();<br />
e.Handled = true;<br />
}<br />
<br />
void gkh_KeyDown(object sender, KeyEventArgs e) {<br />
<br />
e.Handled = true;<br />
}
I would like to be able to trigger the CutPaper() automatically after each print job.
Any help would be much appreciated!
Thank you~
|
|
|
|
|
How are you printing? PrintDocument has the EndPrint event
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Your best bet would probably be to monitor the print queue for job completion (see this[^] article).
/ravi
|
|
|
|
|
Just because the queue is empty, doesn't mean the printer is done printing.
|
|
|
|
|
Right. But it's more reliable than PrintDocument.EndPrint which indicates the document has finished rendering to the printer.
Can you suggest a better alternative?
/ravi
|
|
|
|
|
EndPrint is raised when there are no more pages to render from the application. This usually conicides with a job being completely spooled to the queue, but not always.
There is no way for the application to know when the printer is actually done printing the physical job.
|
|
|
|
|
Dave Kreskowiak wrote: EndPrint is raised when there are no more pages to render from the application.
Right. That's what I said.
Dave Kreskowiak wrote: There is no way for the application to know when the printer is actually done printing the physical job.
True. The best that can be done is to make an educated guess.
/ravi
|
|
|
|
|
i have begine to write acode with c# for haar wavelet transform and i face the problem with inverse wavelet transform how to give input(image) to my code. thanks
|
|
|
|
|
Need to stream a mpeg4 video from a milticast IP 224.168.116.253 and port 4568 and then need to show it on a webpage using any kind of video player ...
Can anybody help me with this.
|
|
|
|
|
|
Hi
i am very new to this forum and with this technology as well, I need to stream a live video from a multicast IP and need to display it on a website using silverlight player.
The video format is mpeg4. Silverlight player and IIS service is not mendatory if anybody knows any better way to do it than also its fine. Any kind of help will be highly appriciated. Please let me know if i can be more specific about my question.
Eagerly waiting for reply.
|
|
|
|
|
Just spent too much time debugging code that wouldn't open a file: Have the following line in an if loop
ofdSelect.ShowDialog() == DialogResult.OK
It initially read
ofdSelect.ShowDialog() == DialogResult.Yes
Considering the button on the open file dialog had "Open", can it be assumed than file dialog box will result in OK wheter it is Open or Save, etc.? I couldn't find anything when searching to tell me that an open file dialog will result in OK when the Open button is clicked, but obviously this is the case.
Thanks.
|
|
|
|
|
Yes, ofdSelect.ShowDialog() returns DialogResult.OK whenever open is clicked. I'm not sure if it's documented anywhere, but I've never seen it return a DialogResult.Yes
modified on Thursday, April 15, 2010 3:51 PM
|
|
|
|
|
mprice214 wrote: debugging
Did you set a breakpoint and inspect the returned value?
|
|
|
|
|
Well this is nice. The actual returned value is None. Therefore, by calling DialogResult.OK or DialogResult.None results in True. Thoughts?
|
|
|
|
|
if you have the following code:
OpenFileDialog openFileDialog1 = new OpenFileDialog();
if (openFileDialog1.ShowDialog() == DialogResult.OK)
MessageBox.Show(openFileDialog1.Filename);
else
MessageBox.Show("No file was selected.");
and the user picks a file and clicks Open - you should get DialogResult.OK from openFileDialog1.ShowDialog() and the message box will show you the selected filename.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
