Hi,
Please change the your code as following.
<Columns >
<asp:HyperLinkField HeaderText="Create Appointment" Text="Create Appointment"
DataNavigateUrlFormatString="AddPatients.aspx?name='<% Eval('name') %>'" DataNavigateUrlFields="name" />
</Columns>
Hope this will help you.
Regards,
Kiran.