I am able to insert images from sql query with image path , but i dont know, that how to do this by 3 tier architecture.
Well, if you know directly then for 3 tier, all you need is:
Create a class library - BusinessLogic
Create a class library - DataAccess
Now, from your UI, use the object model and pass on to BusinessLogic project class. This class is a Business logic class. Do the changes as per your need here.
Now, pass on the changed data from business logic class to dataAccess project class. In this class, use ADO.NET and pass on the needed values to Stored Procedure.
For getting back data, it will be transferred from DA to BL and then BL to UI layer.
Have a look at these, explaination with samples:
3-tier architecture in C#[
^]
3-Tier Architecture Examples[
^]
3-Tier Architecture in ASP.NET with C#[
^]