Comments by shunuman - CodeProject

shunuman 25-Jul-13 4:29am View

Table data like 7/15/2013 2:45:00 PM and I need 2:45 PM
I am getting gata from table and write it text file, my code is like..

SqlDataAdapter sdr = new SqlDataAdapter("select * from currentdata", santosh.destination);
DataSet ds = new DataSet();
sdr.Fill(ds, "currentdata");
DataTable dt = new DataTable();
dt = ds.Tables[0];
int Rowcount = dt.Rows.Count;
TextWriter twr = new StreamWriter(@"D:\TIDS.txt");
int RowPos = 0;
while (Rowcount > 0)
{
twr.WriteLine("");
twr.Write("STA=" + dt.Rows[RowPos].ItemArray[4];// I want to convert this value in 2:45 PM
RowPos++;
Rowcount--;

}
twr.Close();
}

shunuman 25-Jul-13 4:27am View

Table data like 7/15/2013 2:45:00 PM and I need 2:45 PM
I am getting gata from table and write it text file, my code is like..

SqlDataAdapter sdr = new SqlDataAdapter("select * from currentdata", santosh.destination);
DataSet ds = new DataSet();
sdr.Fill(ds, "currentdata");
DataTable dt = new DataTable();
dt = ds.Tables[0];
int Rowcount = dt.Rows.Count;
TextWriter twr = new StreamWriter(@"D:\TIDS.txt");
int RowPos = 0;
while (Rowcount > 0)
{
twr.WriteLine("");
twr.Write("STA=" + dt.Rows[RowPos].ItemArray[4];// I want to convert this value in 2:45 PM
RowPos++;
Rowcount--;

}
twr.Close();
}

shunuman 25-Jul-13 4:18am View

If I put my table instead of RcvDate then show 0 value.

shunuman 25-Jul-13 4:16am View

Sorry, it shows Invalid column name 'RcvDate'.

shunuman 25-Jul-13 4:14am View

Sorry, it's not working.

shunuman 25-Jul-13 3:29am View

thanks for reply but it gives 14:45:00:000 and I need 2:45 PM, Please give correct query.

shunuman 25-Jul-13 3:25am View

It's not working, I am using sqlserver 2000.

shunuman 17-Jul-13 11:02am View

Yes, I am using windows application.
can you please describe how i can use this code in timer.

shunuman 17-Jul-13 11:01am View

I am using windows application..

shunuman 17-Jul-13 11:00am View

Thank you for reply....
But it gives a error....
timer_Elapsed
The type or namespace name 'ElapsedEventArgs'.

Comments by shunuman (Top 10 by date)