C#

Guffa wrote:

Why do you have the date stored in four columns in the first place? That makes it mostly useless...

for(Int32 i = 0; i < newPDS.Tables[0].Rows.Count; i++)
{
	row = newPDS.Tables[0].Rows[i];
	string stringConCatDate;
	DateTime startDate = DateTime.Parse("07/28/1960");
	DateTime endDate = DateTime.Parse("02/14/1982");
					
	stringConCatDate = row["CADMMM"] + "/" + row["CADMDD"] + "/" + row["CADMHH"] + row["CADMYY"];
	
	DateTime dtConCatDate = DateTime.Parse(stringConCatDate);
 
	if (dtConCatDate > startDate && dtConCatDate < endDate)
	{
		row["ADM_DATE"] = stringConCatDate;
	}
}


myReport.SetDataSource(newPDS.Tables["TABLE_1"]);

Verghese wrote:

did i explained the situation clearly..........pls see the code below:

myReport.SetDataSource(newPDS.Tables["TABLE_1"].Select("ADM_DATE IS NOT NULL"));

AmitDey wrote:

I want the pixel values in a 1-D or 2-D array.

Mark Salsbery
Microsoft MVP - Visual C++

class Program
{
    [System.Runtime.InteropServices.DllImport("winmm.dll", EntryPoint = "mciGetErrorString")]
    public static extern bool mciGetErrorString(int dwError, StringBuilder lpstrBuffer, int uLength);

    [System.Runtime.InteropServices.DllImport("winmm.dll")]
    private static extern int mciSendString(string strCommand, string strReturn, int iReturnLength, IntPtr hwndCallback);

    static void Main(string[] args)
    {
        string Pcommand = "open \"" + "C:\\SomeNonExistantFile.mp3" + "\" type mpegvideo alias MediaFile";
        int err = mciSendString(Pcommand, null, 0, IntPtr.Zero);
        StringBuilder text = new StringBuilder(128, 128);

        mciGetErrorString(err, text, int.MaxValue);
        Console.WriteLine(text);

        Console.WriteLine();
        Console.WriteLine("Press Any Key");
        Console.ReadKey();
    }
}

[System.Runtime.InteropServices.DllImport("winmm.dll")]
private static extern int mciGetErrorString(UInt32 errorCode, StringBuilder buffer, UInt32 iReturnLength);

StringBuilder sb = new StringBuilder(260);
mciGetErrorString(256+37, sb, 260); //256+37 == MCIERR_BAD_TIME_FORMAT
Console.WriteLine(sb.ToString());

Mark Salsbery
Microsoft MVP - Visual C++