i added a textbox and a button in my form , now i want to type a id in textbox and on click on button i want to display a crystal report , should be display only filter record with that specific id {not the whole record/table} with sql server or access but first choice is with sql server. if anyone have the solution please send the code. i would be thank full.

i want to know that after connecting the database with datagrid , how to update and cancel records by using edit button of datagrid? manoj kumar