|
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.
|
|
|
|
|
I was using a debug writeline for the result of DialogResult, which gives None. Using debug writeline for openFileDialog1.ShowDialog() does in fact return OK.
Thanks. Still would have liked to find documentation indicating this would be the expectation from a dialog with an button other than "OK".
|
|
|
|
|
I am seeing some odd behavior in the timer_Elapsed method of a service that I am working on.
(It is an event handler for a System.Timers.Timer instance.)
If I remove the section of code marked "Detect and restore failed FSW objects", the call to "_log.Append" works fine (the _log is an instance of the Logging class described below). However, when that section is included, the "_log.Append" fails to operate. Is it possible that it can prevent the preceeding method call?
Also, everything works fine on Server 2003; this only misbehaves on Server 2008.
private List<FileSystemWatcher> _watchers = new List<FileSystemWatcher>();
private void timer_Elapsed(object sender, ElapsedEventArgs e)
{
_log.Append("Timer Cycle started.");
try
{
if ((from w in _watchers where w.Path == _firewallDirectory.Source select w.Path).Count() == 0)
{
FileSystemWatcher fw = new FileSystemWatcher(_firewallDirectory.Source);
fw.Created += new FileSystemEventHandler(fsw_Created);
fw.Renamed += new RenamedEventHandler(fsw_Renamed);
fw.EnableRaisingEvents = true;
_watchers.Add(fw);
}
}
catch (Exception ex)
{
_log.Append("ERROR in Timer - FSW Restore: " + ex.Message);
}
}
*** FYI: Simple Flat-File Logging Class ***
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
namespace Logging
{
public class Log
{
#region Constructor
public Log(string Path)
{
_logStream = new StreamWriter(Path, true);
}
#endregion Constructor
#region Private Properties
private StreamWriter _logStream;
#endregion Private Properties
#region Public Methods
public void Append(string LineToAdd)
{
lock (_logStream)
{
_logStream.WriteLine(DateTime.Now.ToString() + " " + LineToAdd);
_logStream.Flush();
}
}
#endregion Public Methods
}
}
modified on Thursday, April 15, 2010 5:25 PM
|
|
|
|
|
Here is what I discovered:
1. Although Server 2008 comes with .NET, it is 3.0, not 3.5. 3.5 must be installed via server manager.
2. Because the code (above) involves LINQ (the "from w in _watchers" part), that method will fail without 3.5. However, the rest of the app will run, install, etc.
3. Installing 3.5 fixed all problems. No code changes are needed.
|
|
|
|