Exemplo n.º 1
0
        public void update(dealer_class dc)
        {
            SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=egas;Integrated Security=True;Pooling=False");
            SqlDataAdapter da = new SqlDataAdapter("select * from dealer", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "dealer");

            cylinder_dealer_keeper cdk = new cylinder_dealer_keeper();
            dc._stock_no = cdk.count(dc._id);  

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                if (int.Parse(dr[0].ToString()) == dc._id)
                {
                    dr.BeginEdit();
                    dr[1] = dc._name;
                    dr[2] = dc._address;
                    dr[3] = dc._city;
                    dr[4] = dc._state;
                    dr[5] = dc._pincode;
                    dr[6] = dc._stock_no;
                    dr[7] = dc._password;
                    dr[8] = dc._status; 
                    dr[9] = dc._contact;
                    dr.EndEdit();
                }

            }
            SqlCommandBuilder cb = new SqlCommandBuilder(da);
            da.Update(ds.Tables[0]);
        }
Exemplo n.º 2
0
        public dealer_class GetFullDealerData(int id)
        {
            SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=egas;Integrated Security=True;Pooling=False");
            SqlDataAdapter da = new SqlDataAdapter("select * from dealer", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "dealer");

            dealer_class dc = new dealer_class();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                if (int.Parse(dr[0].ToString()) == id)
                {
                    dc._id = int.Parse (dr[0].ToString ());
                    dc._name = dr[1].ToString ();
                    dc._address = dr[2].ToString();
                    dc._city = dr[3].ToString();
                    dc._state = dr[4].ToString();
                    dc._pincode = dr[5].ToString();
                    dc._stock_no = int.Parse (dr[6].ToString()) ;
                    dc._password = dr[7].ToString();
                    dc._status = dr[8].ToString ();
                    dc._contact = dr[9].ToString(); 
                }
            }
            return dc;
        }