public string deletem(salaryinfo pr)
        {
            int    i   = 0;
            string msg = "";
            //int id =
            string  deletequery = string.Format("delete from employee2 where id={0}", pr.id);
            DataSet ds          = new DataSet();

            try
            {
                using (SqlConnection con = new SqlConnection(conString))
                {
                    SqlCommand     cmd = new SqlCommand(deletequery, con);
                    SqlDataAdapter da  = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    da.Update(ds);
                }
            }
            catch (Exception ex)
            {
            }

            if (i > 0)
            {
                msg = string.Format("row Deleted");
            }
            return(msg);
        }
        public string updated(salaryinfo pr)
        {
            string msg = "";
            int    i   = 0;

            // string updatequery = string.Format("update employee2 set name ={0},department={1},salary = {2} designation={3} where id={4}", pr.name, pr.department,pr.salary, pr.designation, pr.id);
            string  updatequery = "update employee2 set name='" + pr.name + "' where id='" + pr.id + "'";
            DataSet ds          = new DataSet();

            try
            {
                using (SqlConnection con = new SqlConnection(conString))
                {
                    SqlCommand     cmd = new SqlCommand(updatequery, con);
                    SqlDataAdapter da  = new SqlDataAdapter(cmd);
                    da.Fill(ds);
                    da.Update(ds);
                }
            }
            catch (Exception ex)
            {
            }
            if (i > 0)
            {
                msg = string.Format("one row inserted");
            }
            return(msg);
        }
        public string insert(salaryinfo pr)
        {
            string insertquery = string.Format("insert into employee2(id,name,department,salary,designation)values({0},'{1}','{2}',{3},'{4}')",
                                               pr.id, pr.name, pr.department, pr.salary, pr.designation);

            DataSet ds  = new DataSet();
            int     i   = 0;
            string  msg = "";

            try
            {
                using (SqlConnection con = new SqlConnection(conString))
                {
                    SqlCommand     cmd = new SqlCommand(insertquery, con);
                    SqlDataAdapter da  = new SqlDataAdapter(cmd);
                    i = da.Fill(ds);
                    da.Update(ds);
                }
            }
            catch (Exception ex)
            {
            }
            if (i > 0)
            {
                msg = string.Format("one row inserted");
            }
            return(msg);
        }
Esempio n. 4
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            int        idn = Convert.ToInt32(TextBox1.Text);
            DataLayer2 dl  = new DataLayer2();
            salaryinfo dr  = new salaryinfo {
                id = idn
            };

            string msg = dl.deletem(dr);
        }
Esempio n. 5
0
 protected void Button3_Click(object sender, EventArgs e)
 {
     int    idn  = Convert.ToInt32(TextBox1.Text);
     string name = TextBox2.Text;
     //string department = TextBox3.Text;
     // int salary = Convert.ToInt32(TextBox4.Text);
     // string designation = TextBox5.Text;
     salaryinfo dr = new salaryinfo {
         id = idn, name = name
     };
     DataLayer2 d1  = new DataLayer2();
     string     msg = d1.updated(dr);
 }
Esempio n. 6
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (this.IsPostBack)
            {
                int        idn         = Convert.ToInt32(TextBox1.Text);
                string     name        = TextBox2.Text;
                string     department  = TextBox3.Text;
                int        salary      = Convert.ToInt32(TextBox4.Text);
                string     designation = TextBox5.Text;
                salaryinfo dr          = new salaryinfo {
                    id = idn, name = name, department = department, salary = salary, designation = designation
                };
                DataLayer2 dl  = new DataLayer2();
                string     msg = dl.insert(dr);

                Response.Write("<script>alert('data inserted')</script>");
            }
        }