how to use stored procedure in asp.net using three tier architecture with example code

Question

Dorababu Meka · Answer

This is sample where in DAL change as per below public bool getUserInfo(out DataSet ds Entity.Entity objentity) { ds = new DataSet(); SqlConnection con = new SqlConnection(ConnectionString); SqlCommand cmd = new SqlCommand( SelectDetails  con); cmd .CommandType = CommandType.StoredProcedure; cmd .Parameters.AddWithValue(_EmpID objentity.EmpID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet oDs = new DataSet(); da.Fill(oDs); ds = oDs; if (oDs.Tables[0].Rows.Count > 0) { m_flag = true; } else { m_flag = false; } return m_flag; } I used Mysql db you can change to SQL where ever needed As per my code I am retrieving the values from database and display the result in Textboxes. You can write that query in stored procedure like Create PROCEDURE SelectDetails ( @id INTEGER ) AS BEGIN Select * from tblDemo where Id=@id; END