Detailsview in ASP.NET

[fanfan]

I am trying to hit sql server with objectdatasource and return a datatable to fill my details view control. the selected ID value is returned by a gridview control. It seems like the datatable is not filled by adapter, and i couldn't figure out why. The ID in sql is set as a primary key (Int, 4, not null). The debugger says the Detail datatable is null. Any help is much appreciated.\[code\]public DataTable GetDetail(string ID) { if (ID == "") { return null; } else { DataTable Detail = null; using (SqlConnection conn = new SqlConnection(connection)) { string comm = @"select * from dbo.Products where ID = @ID"; conn.Open(); SqlDataAdapter adapter=null; using (SqlCommand cmd = new SqlCommand(comm, conn)) { cmd.Parameters.Add("ID", System.Data.SqlDbType.Int, 4).Value = http://stackoverflow.com/questions/14076896/Convert.ToInt32(ID); adapter = new SqlDataAdapter(cmd); adapter.Fill(Detail); return Detail; } } }\[/code\]