Web Forms :: Stored Procedure - Inserting And Retrieving Data From Database

I have used in line queries for inserting and retrieving data from database. How should i use stored proceduress

Insertion code

string strSQL1 = "select * from cust_details";
DataSet ds = new DataSet();
SqlConnection m_conn;
SqlDataAdapter m_dataAdapter;
m_conn = new SqlConnection(conn);

[Code] ....

Retrieval code

try {
SqlConnection conn3 = new SqlConnection(conn);
String q1;
//string ddl = DropDownList1.SelectedItem.ToString();
q1 = "select * from Product where ID ='" + DropDownList1.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(q1, conn3);

[Code] .....