To display report on Crystal Report I'm using, the following piece of code below.......but I'm not getting any idea of how to SELECT records between a date range ( in my database, the date field doesn't exist in date format, its splitted in multiple columns like MM, DD, YY, YY (i.e 4 columns altogether).
when I display it on Crystal Report, I can concatenate it using built-in Crystal report fucntion called CStr function.
If anyone has got any idea on how to proceed, pls help me.
private void Form2_Load(object sender, System.EventArgs e)
myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\sample_as400.mdb";
string sqlQuery = "Select * from table_as400";
myAdp = new OleDbDataAdapter(sqlQuery, myCon);
OleDbCommandBuilder myBldr = new OleDbCommandBuilder(myAdp);
catch (OleDbException exceptionObject)
private void btnReport_Click(object sender, System.EventArgs e)
// Create a CrystalReport1 object
CLIENT_REPORT myReport = new CLIENT_REPORT();
// Set the DataSource of the report
// Set the Report Source to ReportView
crystalReportViewer1.ReportSource = myReport;
One option would be to add a DateTime column to a dataset retrieved from your initial query of 'table_as400', loop through the dataset to edit/insert this DateTime column with the correct date according to the four various "date" related fields in each row of your table, and then pass that dataset object as your data source. You could then filter the date range according to the DateTime column you added. Of course, if your initial query is tens of thousands of records, this option is unlikely to be elegant.
Another option would be to concatenate the date fields in your initial query AS some new named field into a "yyyyMMdd" format and then filter against that new field.
They run in a standalone highly cut down web server called Cassini. It operates by listening to requests on a different port to the default port 80. When you start debugging your web application, it runs on the *new* port.
Deja View - the feeling that you've seen this post before.
I'm trying to Create a windows service in C#. Could some one assist me in creating a windows service that reads mail on a periodic basis from "MSoutlook inbox" of a given mail Id (say "email@example.com" with Host = "smtpx14.msoutlookonline.net" username = "uname" and password="pwd")?
I'm trying to Create a windows service in C#. Could you assist me in creating a windows service that reads mail and stores the message in to a database on a periodic basis from "MSoutlook inbox" of a given mail Id (say "firstname.lastname@example.org" with Host = "smtpx14.msoutlookonline.net" username = "uname" and password="pwd")?
I ve used one Custom Tab Control with some background image.
and ve one GroupBox in one of the Tab Page.
The backcolor of the GroupBox is Transparent.
It all works well with WindowsXP theme but when I change the Theme to
Windows Classic the Transparency of the GroupBox goes away and it is shown with System Control backcolor. But the Tab Page is having its background image.
One of the problems that developers face is the different visual styles that must be tested with an application. The best thing to do would be to detect when the theme changes and what theme it was changed too. When it happens you will have to alter the controls to better suit the visual style.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
You can't find out which one has changed by comparing the lists, as the lists only contains references to the objects. There is only one copy of each object, not one copy for each list. When you change the object, the change is visible from both lists, as they both reference the same object.
Despite everything, the person most likely to be fooling you next is yourself.
I have two issues, if u could help, would be a great assistance.
- line.unregister() using sipxtapidotnet api does not work although line.register works. why? is there any bug in sipxtapi or I am missing something?
- I want to register my line extensions to sip proxy server using sipXtapidotnet api, but how can i do that because there is only line.register() method which registers the line to the proxy server not the extentions.
thnx for the reply but why i asked here is due the fact that sipXtapidotnet is an open souce api and has no documentation or i might not be able to find. so there would be some one could help me out. could u as well.