give value grid.SetRowCount() Dynamically

I want to set row count dynamically. Total number of rows are increased day by day.So i want to retrieve the total row from sql server and give value in grid.SetRowCount() dynamically .How can I do this?