How to do object oriented programming using stored procedures

You can create procedures first after that for every procedure you can create C# methods. It is called Mapping. You can look at the example below

Create Procedure prcAddCategory
@catName nvarchar(50)
as
Insert into Categories(CategoryName) values (@catName)

and for this procedure you can create the C# method below to execute procedure

public void AddCategory(string categoryName)
{
SqlConnection conn = new SqlConnection(yourConnectionString);
SqlCommand cmd = new SqlCommand(prcAddCategory,conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@catName,categoryName);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

}

If you have error,I can check...

Legacy applications built using a client-server model where the stored procedures have much of the business domain logic need to be redesigned to an n-tier architecture so that you can get/reap the benefit of OO designs.

Try this Create a stored procedure in SQL.......







SqlConnection con = new SqlConnection("Data Source=USER-VAIO;Initial Catalog=info;Integrated Security=True");
SqlCommand cmd = new SqlCommand("login2_test",con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter ss = new SqlParameter();
SqlParameter ss1 = new SqlParameter();
ss.ParameterName = "@name";
ss1.ParameterName = "@age";
ss.Value = textBox17.Text;
ss1.Value = textBox18.Text;
cmd.Parameters.Add(ss);
cmd.Parameters.Add(ss1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();