สอบถามการ select maxid c#.net 2005 ครับ (มือใหม่)

 $sql_select  ="SELECT max(BookID) AS maxID  FROM book  ";


$query = mysql_query($sql_select);
$num_row = mysql_num_rows($query);

$result = mysql_fetch_array($query);
$maxID = $result[maxID];
$ID = $maxID+1

MySqlConnection objCon;
        MySqlCommand objCmd;
        String StrConnection, Sql;

        StrConnection = "Server=localhost;User ID =root;Password=22;Database=1;Pooling=false";

        objCon = new MySqlConnection(StrConnection);
        objCon.Open();
        Sql = "SELECT max(BookID) AS maxID  FROM book ";

        objCmd = new MySqlCommand(Sql, objCon);
        MySqlDataAdapter dtAdepter;

        dtAdepter.SelectCommand = objCmd;

        DataSet dt = new DataSet();

        dtAdepter.Fill(dt,"myBook");