I want to send an email to the user directly form my vb form by pressing a button.
Secondly i am using a datagrid with adodc1 to retrieve some records from the patient table. However i want only to retrieve records for a sinlge patient by pressing a serach button and only a particular patient records should be displayed on the grid but currently i am getting all patients the records being retrieved from the table. I have used select query at design mode and all setting are made in the design mode. I have tried to put the adodc1 and datagrid code and the query behind the search button but then i get errors.
For example if i say
datagrid1.recordsource=adodc1 <--- it gives an error.
Anyone have any ideas