Click here to Skip to main content
14,382,515 members
   

C#

 
GeneralRe: structured storage API Pin
Miss_hacker21-Jul-08 8:53
memberMiss_hacker21-Jul-08 8:53 
GeneralRe: structured storage API Pin
led mike21-Jul-08 8:59
memberled mike21-Jul-08 8:59 
GeneralRe: structured storage API Pin
DaveyM6921-Jul-08 9:21
mentorDaveyM6921-Jul-08 9:21 
GeneralRe: structured storage API Pin
Miss_hacker21-Jul-08 20:32
memberMiss_hacker21-Jul-08 20:32 
GeneralRe: structured storage API Pin
DaveyM6922-Jul-08 1:30
mentorDaveyM6922-Jul-08 1:30 
QuestionGenerating Incremental Values preceded with letters Pin
Banjo Ayorinde21-Jul-08 6:11
memberBanjo Ayorinde21-Jul-08 6:11 
AnswerRe: Generating Incremental Values preceded with letters Pin
Pete O'Hanlon21-Jul-08 6:41
protectorPete O'Hanlon21-Jul-08 6:41 
QuestionDate Range Function Pin
Reality Strikes21-Jul-08 5:04
memberReality Strikes21-Jul-08 5:04 
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.Confused | :confused:

private void Form2_Load(object sender, System.EventArgs e)
{
      try
      {			
	   myCon.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\sample_as400.mdb";
 	   myCon.Open();
	   string sqlQuery = "Select * from table_as400";
           myAdp = new OleDbDataAdapter(sqlQuery, myCon);

	   OleDbCommandBuilder myBldr = new OleDbCommandBuilder(myAdp);
	   myAdp.Fill(myTable);					
      }
      catch (OleDbException exceptionObject)
      {
	   MessageBox.Show(exceptionObject.Message, "PIN_PROJECT");
      }
}

		
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
	myReport.SetDataSource(myAdp);

	// Set the Report Source to ReportView 
	crystalReportViewer1.ReportSource = myReport;
}

AnswerRe: Date Range Function Pin
paas21-Jul-08 5:52
memberpaas21-Jul-08 5:52 
GeneralRe: Date Range Function Pin
Reality Strikes21-Jul-08 9:18
memberReality Strikes21-Jul-08 9:18 
AnswerRe: Date Range Function Pin
Luc Pattyn21-Jul-08 5:52
professionalLuc Pattyn21-Jul-08 5:52 
GeneralRe: Date Range Function Pin
Reality Strikes21-Jul-08 9:19
memberReality Strikes21-Jul-08 9:19 
QuestionAdd web service on windows application Time out error Pin
Rami Said Abd Alhalim21-Jul-08 4:57
memberRami Said Abd Alhalim21-Jul-08 4:57 
QuestionHow do the File System Web Sites work in ASP.NET 2.0 Pin
bruze21-Jul-08 4:48
memberbruze21-Jul-08 4:48 
AnswerRe: How do the File System Web Sites work in ASP.NET 2.0 Pin
Pete O'Hanlon21-Jul-08 4:55
protectorPete O'Hanlon21-Jul-08 4:55 
QuestionCreating Windows service to Read Mail from Outlook inbox Pin
Kathiresan Moorthy21-Jul-08 4:32
memberKathiresan Moorthy21-Jul-08 4:32 
AnswerRe: Creating Windows service to Read Mail from Outlook inbox Pin
led mike21-Jul-08 5:51
memberled mike21-Jul-08 5:51 
QuestionRe: Creating Windows service to Read Mail from Outlook inbox [modified] Pin
Kathiresan Moorthy21-Jul-08 18:43
memberKathiresan Moorthy21-Jul-08 18:43 
QuestionProblem with Windows Classic Theme [modified] Pin
Sifar - 021-Jul-08 3:09
memberSifar - 021-Jul-08 3:09 
AnswerRe: Problem with Windows Classic Theme Pin
Thomas Stockwell21-Jul-08 6:04
professionalThomas Stockwell21-Jul-08 6:04 
GeneralRe: Problem with Windows Classic Theme Pin
Sifar - 021-Jul-08 22:01
memberSifar - 021-Jul-08 22:01 
Questioncomparing two generic list Pin
enginço21-Jul-08 2:59
memberenginço21-Jul-08 2:59 
AnswerRe: comparing two generic list Pin
Guffa21-Jul-08 4:55
memberGuffa21-Jul-08 4:55 
Generalacording to me you are wrong [modified] Pin
enginço21-Jul-08 6:49
memberenginço21-Jul-08 6:49 
GeneralRe: acording to me you are wrong Pin
Luc Pattyn21-Jul-08 7:37
professionalLuc Pattyn21-Jul-08 7:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.