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)
DataView dv = dt1.DefaultView;
//below line gives the distinct values of column "id"
dt1 = dv.ToTable(true, "id");
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
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.
"Winners don't do different things. They do things differently. ...
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.
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.
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.