Importing CSV file

Question

Hi

I want to import a csv file into c# and then manipulate it and output a textfile.

I'm looking for help on how to go about this.

I have the oledb connection set up, however I dont want to put it into a datagrid because I have no use for the grid.

Would a hashtable be the best option? And if so what the correct way to approach the problem.

Thanks

Answer 1

Hi Kavita:

For your second question removing of previous and next month days:  you can not remove them but you can hide them by setting those days back and forecolors using OtherMonthDayStyle attribute of Calendar.

Eg: <OtherMonthDayStyle ForeColor="Blue" BorderStyle="None" BorderColor="Blue" BackColor="Blue"></OtherMonthDayStyle>


But those cells are selectable in order to suppress this, add this in DayRender event of calendar:

if (e.Day.IsOtherMonth==true)
   {
    e.Cell.BackColor = System.Drawing.Color.Blue;
    e.Cell.ForeColor = System.Drawing.Color.Blue;
    e.Day.IsSelectable = false;
  }


in Page_Load event add this:

Calendar1.Attributes["onMouseDown"] = "JavaScript:Void(0);";

try out this.