Hi,
Try this:
SqlDataSource1.DataSourceMode=SqlDataSourceMode.DataReader;
SqlDataSource1.SelectCommand = "select * from table1 where name='"+txtName.Text+"'";
SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["MyConString"].ConnectionString;
GridView2.DataSource = SqlDataSource1;
GridView2.DataBind();
DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
DataTable dt = dv.ToTable();
--Amit