When you insert into the table, use getdate() as the value for the DateCreated field: insert into mytesttable (MyDateField) values (getdate()) Or, to make a default value of the current datetime, in design view in the Enterprise Manager type (getdate()) in the Formula field for the table. Or, when you create the table in the Query Analyzer, do it this way: CREATE TABLE [MyTestTable] (     [IDColumn] [int] IDENTITY (1, 1) NOT NULL ,     [DateCreated] AS (getdate()) ) ON [PRIMARY] --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

-- create proc create proc abc @para int output as set @para = 1 go --exec proc declare @p int exec abc @p output select @p

You have to do it yourself. It's not access. Insert a column, right click it and click Set Primary Key. You may also want to make the column autoincrement also. ChrisB

You can try something like this: //Call Stored Proc and load values into a DataSet string conn = SqlHelper.GetConnectionString(); DataSet ds = SqlHelper.ExecuteDataset(conn, "spEmployeeRecords"); lstDropDownList.DataSource = ds; lstDropDownList.DataTextField = "FullName"; lstDropDownList.DataValueField = "EmployeeID"; lstDropDownList.DataBind();

Hi, You can use the TabStrip Web control and create tabs in it. For having different pages in it, you can use Multipage web control and you can have different pages in multipage and each page can be linked with each tab. rmr

It depends on what you are trying to do. If you can do the operation using a set based operation (what SQL is optimised for) then you are better doing it that way. If you are looping over a counter then a WHILE loop is useful. If you are looping over rows in a database then you might want to look at CURSORs. However, if you are tempted to use cursors then I would really suggest trying to find a set based method for the same thing first and use CURSORs as a last resort. Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

Stuck on your test? ;) --- b { font-weight: normal; }

Thank You Jay.:)That was really helpful.i have another question...if there are nN number of buttons in a datagrid and u want 2 know which button was clicked then what do u do?:confused: