datagrid, relations

Question

hello. i have the following db structure:
table tools
id, type_id, name

table tooltypes
id, name

i need to have a datagrid, viewing the tools table, with a combobox instead of type_id (filled with names of tooltypes, selected value corresponding to type_id). i know how to do it manually, but i want to find the right way, using databinding, relations (is it possible?). i've read some tutorials, googled a lot, still i'm confused about this. any help appreciated. thank you.

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.