C#.net OOP Crud Application Step by Step

In this tutorials will teach you how to calculate student marks using OOP concepts. This is an important for developing a java projects.  There are many students who struggling with this area. So that I bring this article for all to clear the doubts.

First Step Create Class Std. Class consist of attribute and behavior.

class std
    {
        public int cid { get; set; }
        public string stname { get; set; }

        public string course { get; set; }

        public string fee { get; set; }

        public void reg(string name, string course, string fee)
        {
            SqlConnection con = new SqlConnection("server =.; initial catalog=testdb; 
            User  ID=sa; Password=123");

            string sql = "insert into std (st_name,course,fee)values('" + name + "','" + course + "',
            '" + fee + "'); select @@identity;";

            con.Open();
            SqlCommand cm = new SqlCommand(sql, con);
            int c = int.Parse(cm.ExecuteScalar().ToString());
            con.Close();
        }

        public List<std> get_all_student()
        {
            List<std> li = new List<std>();
            SqlConnection con = new SqlConnection("server=.; initial catalog=testdb; User Id=sa; 
            password=123;");
            string sql = "select * from std";
            con.Open();

            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                std s = new std();

                s.cid = (int)dr["id"];
                s.stname = dr["st_name"].ToString();
                s.course = dr["course"].ToString();
                s.fee = dr["fee"].ToString();

                li.Add(s);
            }
            return li;
        }}

Form

 private void button1_Click(object sender, EventArgs e)
        {
            std ss = new std();
            ss.reg(txtName.Text, txtCourse.Text, txtFee.Text);
            MessageBox.Show("Record Addeddd");
        }

        private void button3_Click(object sender, EventArgs e)
        { 
            std ss = new std();
            List<std> cl = ss.get_all_student();
            dataGridView1.DataSource = cl;
        }

i have attached the video link below. which will do this tutorials step by step.

C#.net OOP CRUD Step by Step

Share

Watch on