public clsProductInfo CreateData(clsProductInfo data) { data.Name = txtProductName.Text.ToString().Trim(); data.TypeId = Convert.ToInt32(cmbProductTypeID.Text.ToString().Trim()); data.UnitId = Convert.ToInt32(cmbUnitID.Text.ToString().Trim()); data.Price = Convert.ToDouble(txtPrice.Text.ToString().Trim()); data.companyName = txtCompanyName.Text.ToString().Trim(); return(data); }
private void btnSave_Click(object sender, EventArgs e) { String strQuery = ""; clsProductInfo data = new clsProductInfo(); data = CreateData(data); strQuery = "Insert into tbl_ProductInFo(Name,TypeId,UnitId,Price,CompanyName) values('" + data.Name + "','" + data.TypeId + "','" + data.UnitId + "','" + data.Price + "','" + data.CompanyName + "')"; SqlHelper.ExecuteNonQuery(clsUtil.ConnectionString, CommandType.Text, strQuery); MessageBox.Show("Save Data Sucessfully ."); ClearAllData(); }
private void btnUpdate_Click(object sender, EventArgs e) { String strQuery = ""; clsProductInfo data1 = new clsProductInfo(); data1 = UpdateData(data1); strQuery = " UPDATE [tbl_ProductInFo] " + "SET [Name] ='" + data1.Name + "'" + ",[TypeId]=' " + data1.TypeId + "' " + ",[UnitId]= '" + data1.UnitId + "' " + ",[CompanyName]= '" + data1.CompanyName + "' " + ",[Price]= '" + data1.Price + "' " + "WHERE [ProductId]=" + data1.ProductId + " "; SqlHelper.ExecuteReader(clsUtil.ConnectionString, CommandType.Text, strQuery); MessageBox.Show("Update Data Sucessfully ."); ClearAllData(); }