The SelectCommand property has not been initialized before calling 'Fill'.

Solutions : You have to specify select command of SqlDataAdapter before filling your table. Your SqlCommand object is not connected in any way to your SqlDataAdapter.Please check below line have you implemented in your code. adp.SelectCommand=cmd;