Date field in Datagrid from SQL server _ Most Urgent

[Sreenath Rao Nellutla]

Hai All,

1.

I need help regarding displaying Date in to DataGrid from SQL Server 2000 database in the required format.

Sql Server data : smalldatetime

DataGrid : Date (Only I want. But I am getting Date & Time).


Code I am Using is:

 code goes here
 
SqlDataAdapter da=new SqlDataAdapter("select statement",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table name");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
 
 

2. I want cursor to remain in the textfield when the web page loaded.
If I am using tabindex property of page, first address bar is getting activated and next it is coming to the that control.

If I use FrameSet, then the sequence of activation isas follows:

address bar,
Title frame,
web controls in the title frame,
contents frame and their controls,
and then to the main frame and its controls.

But I want control to activate webcontrol in the page displayed in the main frame.


Plz help in this regard. Most Urgent.