There are four types of columns in datagrid and they all have visible property assign it values as following is given, "BoundColumn Visible=False" or if you want to assign value through design end then right click on datagrid-->select property builder and then select columns tag, under selected colomns list select the desired column to hide and check out its visible property. Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623 -- modified at 0:50 Wednesday 25th January, 2006

By using DataTable check following code. ----------------------- objDataTable.Rows.Count; This will return you the rows in a DataTable ---------------------------------------------- If you are using DataSet then check following code --------------------------------------------------- objDataSet.Table[0].Rows.Count; --------------------------------------------------- Here DataTable is the object of DataTable and DataSet is object of DataSet Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623

firstly add the time and date from web form to database table for each user. then add only one job that run after each minute in Management-->SQL Jobs. Now what this job will be done ?. It will first check the date and time of users and then it will send mail using following code if the user is reach to its exact time. Code you can view from following link: http://www.vbforums.com/archive/index.php/t-280616.html and read about how to add a new SQL server job in database in detail. Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623

UpdateDate = GETDATE() please past the error message hint, if UpdateDate is datatime then it will work properly. Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623