public void LoadDetailsData(string code) { DataTable dt = Connstring.SqlDataTable(@"SELECT Item AS 'Item Name', Quantity, 'Remove' AS Action FROM dbo.OrderItem WHERE (OrderNo = '" + code + "')"); dgvOrderData.DataSource = dt; dgvOrderData.Columns[0].Width = 212; }
private void btnSave_Click(object sender, EventArgs e) { string Code = txtOrderNo.Text; if (Code != "") { DataTable dt = Connstring.SqlDataTable(@"SELECT COUNT(*) AS CheckData FROM [dbo].[Order] WHERE (OrderNo = N'" + Code + "')"); int CheckData = Convert.ToInt32(dt.Rows[0]["CheckData"].ToString()); if (CheckData == 0) { string CustomerName = txtCustomerName.Text; string strDate = txtDate.Value.ToString("yyyy-MM-dd"); if (CustomerName != "" && strDate != "0") { string sql = @"INSERT INTO dbo.[Order] (OrderNo, Date, CustomerName) VALUES (@OrderNo,@Date,@CustomerName)"; SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn); MyCommand.Parameters.AddWithValue("@OrderNo", Code); MyCommand.Parameters.AddWithValue("@Date", strDate); MyCommand.Parameters.AddWithValue("@CustomerName", CustomerName); Connstring.conn.Open(); int Result = MyCommand.ExecuteNonQuery(); Connstring.conn.Close(); if (Result == 1) { SaveDetailsData(Code); lblMessage.Text = "Successfully saved."; } else { MessageBox.Show("Save failed."); } } else { lblMessage.Text = "Please fill all required fields."; } } else { MessageBox.Show("Already exist."); } } else { MessageBox.Show("Please select code."); } }
//Genarate XML and insert into another table one by one row. public bool DBtoXML() { try { int count = 0; DataTable dt = Connstring.SqlDataTable(@"SELECT id, name, age FROM dbo.Users"); List <User> Users = new List <User>(); if (dt.Rows.Count < 1) { MessageBox.Show("No data found"); return(false); } foreach (DataRow row in dt.Rows) { var user = new User(); int id; int age; int.TryParse(row["id"].ToString(), out id); user.Name = row["name"].ToString(); int.TryParse(row["age"].ToString(), out age); user.Age = age.ToString(); var XmlData = XmlManager.SerializetoXML <User>(user); string sql = @"INSERT INTO dbo.[Xml] (xmldata, userID) VALUES (@XmlData, @userID)"; SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn); MyCommand.Parameters.AddWithValue("@XmlData", XmlData); MyCommand.Parameters.AddWithValue("@userID", id); Connstring.conn.Open(); int Result = MyCommand.ExecuteNonQuery(); Connstring.conn.Close(); if (Result == 1) { count++; label2.Text = count + " data updated"; } else { label2.Text = "Data Sync failed"; } } return(true); } catch (Exception ex) { return(false); } }
//.........Auto selected value for Press combobox(dropdown)......... private void GetPressCodeData() { DataTable dt = Connstring.SqlDataTable(@"SELECT [Press Code] AS Code, [Press Name] AS Name FROM prd.[Press Info]"); DataRow Drw; Drw = dt.NewRow(); Drw.ItemArray = new object[] { 0, " Please Select " }; dt.Rows.InsertAt(Drw, 0); cboPressCode.ValueMember = "Code"; cboPressCode.DisplayMember = "Name"; cboPressCode.DataSource = dt; }
private void Form4_Load(object sender, EventArgs e) { db_ppl Connstring = new db_ppl(); DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[hrd].[Employee]"); pplDataGridView1.DataSource = dt; }
private void Form8_Load(object sender, EventArgs e) { db_ppl Connstring = new db_ppl(); DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[dbo].[Users]"); this.pplDataNavigation1.Datatable = dt; }
//------------ public void voucher_no() { try { string year = DateTime.Now.ToString("yy"); string month = DateTime.Now.ToString("MM"); string Newmonth = month; if (month == "11" || month == "12" || month == "10") { Newmonth = month; } else { Newmonth = month.Substring(1); } DataTable dt = Connstring.SqlDataTable(@"SELECT MAX(No) AS Max, MONTH(AddDate) AS Month FROM Inv.OpeningStock GROUP BY MONTH(AddDate) HAVING (MONTH(AddDate) = '" + Newmonth + "')"); if (dt.Rows.Count >= 1) { string sqldata = dt.Rows[0]["MAX"].ToString(); string[] tokens = sqldata.Split('-'); string middle = tokens[tokens.Length - 2]; string increment = Convert.ToString(Convert.ToInt32(middle.ToString()) + 1); string zero = "00000"; int get_lengt = zero.Length - increment.Length; string lenght = zero.Substring(0, get_lengt); string cash_memo = lenght + increment; Txt_cash_memo_no.Text = year + "-" + cash_memo + "-" + month; } else { Txt_cash_memo_no.Text = year + "-" + "00001" + "-" + month; } } catch { MessageBox.Show("Database Connection Faild OR User is out of SalesCounter", "Alart", MessageBoxButtons.OK, MessageBoxIcon.Warning); //btn_save.Enabled = false; //btn_report.Enabled = false; } Connstring.conn.Close(); }
private void btn_save_Click(object sender, EventArgs e) { string Code = txtSubjectCode.Text; string Name = txtSubjectName.Text; if (Code != "" && Name != "") { DataTable dt = Connstring.SqlDataTable(@"SELECT [Subject Code], [Subject Name] FROM RND.[Subject Information] WHERE ([Subject Code] = N'" + Code + "') AND ([Subject Name] = N'" + Name + "')"); if (dt.Rows.Count == 0) { string sql = @"INSERT INTO RND.[Subject Information]([Subject Code], [Subject Name]) VALUES (@SubjectCode,@SubjectName)"; SqlCommand MyCommand = new SqlCommand(sql, Connstring.conn); MyCommand.Parameters.AddWithValue("@SubjectCode", Code); MyCommand.Parameters.AddWithValue("@SubjectName", Name); Connstring.conn.Open(); int a = MyCommand.ExecuteNonQuery(); Connstring.conn.Close(); if (a == 1) { lbl_sell.Text = "Save Successfully."; } else { MessageBox.Show("Save Faild."); } } else { MessageBox.Show("Already exist."); } } else { lbl_sell.Text = "Please fill all required fields."; } SubjectList(); }
private void button1_Click(object sender, EventArgs e) { DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[dbo].[Users]"); BindingSource bs = new BindingSource(); DataNamesMapper <User> mappaer = new DataNamesMapper <User>(); List <User> users = mappaer.Map(dt).ToList(); bs.DataSource = users; pplNavigation1.BindingSource = bs; pplNavigation2.BindingSource = bs; }
public void GenarateHierarchy() { var root = new RootItem(); DataTable dt = Connstring.SqlDataTable(@"SELECT [id], RTRIM(LTRIM([name])) AS name, RTRIM(LTRIM([parentID])) AS parentID, weight FROM [PPLDEV].[dbo].[hierarchy];"); var parents = GetTopLevelRows(dt); root.nodeStructure = CreateItem(dt, parents); var serializer = new JavaScriptSerializer(); serializer.RegisterConverters(new JavaScriptConverter[] { new NullPropertiesConverter() }); var json = serializer.Serialize(root); }
private void button1_Click(object sender, EventArgs e) { DataTable dt = Connstring.SqlDataTable(@"SELECT * FROM [PPLDEV].[hrd].[Employee]"); BindingSource bs = new BindingSource(); bs.DataSource = dt; pplNavigation1.BindingSource = bs; sampleBindingSource = bs; //var model = this.sampleBindingSource.DataSource as Sample; //var item = model.Count; //var AnotherSample = new Sample(); //AnotherSample.Count = "ddddddddd"; //AnotherSample.FirstName = "ddddddddd"; //AnotherSample.LastName = "ddddddddd"; //this.sampleBindingSource.DataSource = AnotherSample; }
//---Product Category Load public void Category() { try { cboCategory.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cboCategory.AutoCompleteSource = AutoCompleteSource.ListItems; DataTable dataTable = Connstring.SqlDataTable(@"SELECT ID, Name FROM Inv.ProductCategory ORDER BY ID"); if (dataTable.Rows.Count > 0) { cboCategory.DataSource = dataTable; cboCategory.DisplayMember = "Name"; cboCategory.ValueMember = "ID"; cboCategory.SelectedIndex = cboCategory.FindString("Name of a item"); cboCategory.SelectedText = ""; cboCategory.SelectedText = "---- Select Please ----"; txtItemName.Text = "1"; } else { cboCategory.DataSource = dataTable; cboCategory.ValueMember = ""; } } catch { } }