Comments by Mokshagna (Top 12 by date)

using (OleDbDataReader dr = command.ExecuteReader())
{
using (bulkcopy = new SqlBulkCopy(ConnectionString))
{
SqlBulkCopy s = new SqlBulkCopy(ConnectionString);

bulkcopy.DestinationTableName = "tablename";
bulkcopy.WriteToServer(dr);
}
dr.Close();
}
}

If I'm using datatable in this....I'm getting error: No rows found in the table eventhough I have data in the excel sheet.

Please help me...

I declared SessionID variable in my Global.asax page.
I'm using that SessionID in my aspx.cs page like "Session["UserID"].ToString"....
How can I get Session UserName from ID...Plz help on this...

I tried using the above code....

I got USERNAME which was in my login..it's like "PTC\210102" but how can I get name of that ID.please help on this...

Thank u!!!

I have checked that already....Is there anything I need to check for that error??