private void button4_Click(object sender, EventArgs e) { tableLayoutPanel1.Controls.Clear(); ArrayList param = new ArrayList(); param.Add(textBox1.Text); DataSet ds = new DBHandler().GetMetaData(1, param); if (ds != null && ds.Tables.Count > 0) { tableLayoutPanel1.RowCount = ds.Tables[0].Rows.Count; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Label lbl = new Label(); lbl.Text = ds.Tables[0].Rows[i]["Parameter_name"].ToString().Substring(1) + " (" + ds.Tables[0].Rows[i]["Type"].ToString() + ")"; lbl.Size = new System.Drawing.Size(300, 30); tableLayoutPanel1.Controls.Add(lbl, 0, i); TextBox txt = new TextBox(); if (ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "bigint" || ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "int" || ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "float") txt.Text = "0"; if (ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "bit") txt.Text = "false"; tableLayoutPanel1.Controls.Add(txt, 1, i); } } }
private void button1_Click(object sender, EventArgs e) { DataSet ds = new DBHandler().Getter(1, GetParams(), textBox1.Text); if (ds != null && ds.Tables.Count > 0) { dataGridView1.Visible = true; dataGridView1.DataSource = ds.Tables[0]; } }
private void button1_Click(object sender, EventArgs e) { ArrayList param = new ArrayList(); param.Add(19); DataSet ds = new DBHandler().GetAccountDetails(1, param); if (ds != null && ds.Tables.Count > 0) { MessageBox.Show(ds.Tables[0].Rows.Count.ToString()); } }
private void button2_Click(object sender, EventArgs e) { dataGridView1.Visible = false; long ID; try { string Message = new DBHandler().settter(1, GetParams(), textBox1.Text, out ID); MessageBox.Show(Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { try { ArrayList param = new ArrayList(); param.Add(19); DBHandler db = new DBHandler(); long accountId; string Message = db.DeleteAccount(1, param, out accountId); MessageBox.Show(Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
int getPrevRow() { int i = 0; ArrayList Param = new ArrayList(); Param.Add(ListViewID); Param.Add(strColumns); Param.Add(StrFilterColumn); Param.Add(Text); Param.Add(2); Param.Add(true); Param.Add(""); Param.Add(""); Param.Add(LanguageID); DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0]; if (Dt.Rows.Count > 0) { //if (!((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[0][0])) //{ DataRow dr = ((DataView)this.ItemsSource).Table.NewRow(); for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++) { dr[j] = Dt.Rows[0][j]; } ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, 0); ((DataView)this.ItemsSource).Table.Rows.RemoveAt(((DataView)this.ItemsSource).Table.Rows.Count - 1); // } } return(i); }
private void button2_Click(object sender, EventArgs e) { ArrayList param = new ArrayList(); param.Add(0); param.Add("001"); param.Add("Ikram"); param.Add("Hussain"); param.Add("1"); param.Add("2"); param.Add(19); param.Add(0); param.Add(0); param.Add(0); param.Add(0); param.Add(0); param.Add(0); param.Add(0); param.Add("Sample"); param.Add("ikmra"); param.Add(1); param.Add("UserCol1='asdfasdf'"); try { DBHandler db = new DBHandler(); long accountId; string Message = db.SetAccountDetails(1, param, out accountId); MessageBox.Show(Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
int getPrevRow() { int i = 0; ArrayList Param = new ArrayList(); Param.Add(ListViewID); Param.Add(strColumns); Param.Add(StrFilterColumn); Param.Add(Text); Param.Add(2); Param.Add(true); Param.Add(""); Param.Add(""); Param.Add(LanguageID); DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0]; if (Dt.Rows.Count > 0) { //if (!((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[0][0])) //{ DataRow dr = ((DataView)this.ItemsSource).Table.NewRow(); for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++) { dr[j] = Dt.Rows[0][j]; } ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, 0); ((DataView)this.ItemsSource).Table.Rows.RemoveAt(((DataView)this.ItemsSource).Table.Rows.Count - 1); // } } return i; }
void FillListBox() { ArrayList Param = new ArrayList(); Param.Add(ListViewID); Param.Add(strColumns); Param.Add(StrFilterColumn); Param.Add(Text); if (IsPartiralData) Param.Add(PageSize); else Param.Add(0); Param.Add(false); Param.Add(""); if (valueSelected) Param.Add(this.SelectedValue.ToString()); else Param.Add(""); Param.Add(LanguageID); DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0]; IstextChanged = true; if (Dt != null && Dt.Rows.Count > 0) { if (this.ItemsSource == null) { this.ItemsSource = Dt.AsDataView(); // ((DataView)this.ItemsSource).Table.PrimaryKey = new DataColumn[] { ((DataView)this.ItemsSource).Table.Columns[0] }; } else { ((DataView)this.ItemsSource).Table.Rows.Clear(); //Dt.PrimaryKey = new DataColumn[] { Dt.Columns[0] }; //for (int i = 0; i < ((DataView)this.ItemsSource).Table.Rows.Count; i++) //{ // if (!Dt.Rows.Contains(((DataView)this.ItemsSource).Table.Rows[i][0])) // { // ((DataView)this.ItemsSource).Table.Rows.RemoveAt(i); // i--; // } //} for (int i = 0; i < Dt.Rows.Count; i++) { //if (((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[i][0])) // continue; DataRow dr = ((DataView)this.ItemsSource).Table.NewRow(); for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++) { dr[j] = Dt.Rows[i][j]; } // if (((DataView)this.ItemsSource).Table.Rows.Count == i) ((DataView)this.ItemsSource).Table.Rows.Add(dr); //else // ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, i); } //if (popupDataGrid.Items.Count > 0) // popupDataGrid.SelectedItem = popupDataGrid.Items[0]; } //if (txt != this.Text) //{ // IstextChanged = true; // this.Text = txt; // for (int i = 0; i < popupDataGrid.Items.Count; i++) // { // if (this.Text == ((DataRowView)popupDataGrid.Items[i]).Row.ItemArray[SearchColumn].ToString()) // { // popupDataGrid.SelectedItem = popupDataGrid.Items[i]; // return; // } // } //} } IstextChanged = false; }
protected override void OnInitialized(EventArgs e) { base.OnInitialized(e); if (CostCenterID == 0) return; ArrayList Param = new ArrayList(); Param.Add(CostCenterID); Param.Add(TypeID); Param.Add(UserID); Param.Add(LanguageID); DataSet ds = new PACT.DBHandler.DBHandler().GetCostCenterListView(CompanyDBIndex, Param); ListViewID = Convert.ToInt32(ds.Tables[0].Rows[0]["ListViewID"].ToString()); this.IsEditable = true; Microsoft.Windows.Controls.DataGridTextColumn dgCol; dgCol = new Microsoft.Windows.Controls.DataGridTextColumn(); dgCol.Header = strPrimaryKey; dgCol.Binding = new Binding(strPrimaryKey); dgCol.Visibility = System.Windows.Visibility.Hidden; this.Columns.Add(dgCol); ColumnsList = new ArrayList(); for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { if (i == 0) strColumns = ds.Tables[1].Rows[i]["SysColumnName"].ToString(); else strColumns += "," + ds.Tables[1].Rows[i]["SysColumnName"].ToString(); ColumnsList.Add(ds.Tables[1].Rows[i]["SysColumnName"].ToString()); dgCol = new Microsoft.Windows.Controls.DataGridTextColumn(); dgCol.Header = ds.Tables[1].Rows[i]["UserColumnName"].ToString(); if (ds.Tables[1].Rows.Count == 1) dgCol.Width = this.Width; else dgCol.Width = Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString()); dgCol.CanUserResize = false; dgCol.CanUserSort = false; dgCol.Binding = new Binding(ds.Tables[1].Rows[i]["SysColumnName"].ToString()); iWidth += Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString()); this.Columns.Add(dgCol); } if (this.SelectedValue != null) valueSelected = true; //this.SelectedValue = new Binding(strPrimaryKey); this.SelectedValuePath = strPrimaryKey; }
private void TestSP_Load(object sender, EventArgs e) { ArrayList param = new ArrayList(); DataSet ds = new DBHandler().Getter(1, param, "GetProcedures"); if (ds != null && ds.Tables.Count > 0) { cmbProcedures.DataSource = ds.Tables[0]; cmbProcedures.DisplayMember = "name"; cmbProcedures.ValueMember = "name"; } }
void FillListBox() { ArrayList Param = new ArrayList(); Param.Add(ListViewID); Param.Add(strColumns); Param.Add(StrFilterColumn); Param.Add(Text); if (IsPartiralData) { Param.Add(PageSize); } else { Param.Add(0); } Param.Add(false); Param.Add(""); if (valueSelected) { Param.Add(this.SelectedValue.ToString()); } else { Param.Add(""); } Param.Add(LanguageID); DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0]; IstextChanged = true; if (Dt != null && Dt.Rows.Count > 0) { if (this.ItemsSource == null) { this.ItemsSource = Dt.AsDataView(); // ((DataView)this.ItemsSource).Table.PrimaryKey = new DataColumn[] { ((DataView)this.ItemsSource).Table.Columns[0] }; } else { ((DataView)this.ItemsSource).Table.Rows.Clear(); //Dt.PrimaryKey = new DataColumn[] { Dt.Columns[0] }; //for (int i = 0; i < ((DataView)this.ItemsSource).Table.Rows.Count; i++) //{ // if (!Dt.Rows.Contains(((DataView)this.ItemsSource).Table.Rows[i][0])) // { // ((DataView)this.ItemsSource).Table.Rows.RemoveAt(i); // i--; // } //} for (int i = 0; i < Dt.Rows.Count; i++) { //if (((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[i][0])) // continue; DataRow dr = ((DataView)this.ItemsSource).Table.NewRow(); for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++) { dr[j] = Dt.Rows[i][j]; } // if (((DataView)this.ItemsSource).Table.Rows.Count == i) ((DataView)this.ItemsSource).Table.Rows.Add(dr); //else // ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, i); } //if (popupDataGrid.Items.Count > 0) // popupDataGrid.SelectedItem = popupDataGrid.Items[0]; } //if (txt != this.Text) //{ // IstextChanged = true; // this.Text = txt; // for (int i = 0; i < popupDataGrid.Items.Count; i++) // { // if (this.Text == ((DataRowView)popupDataGrid.Items[i]).Row.ItemArray[SearchColumn].ToString()) // { // popupDataGrid.SelectedItem = popupDataGrid.Items[i]; // return; // } // } //} } IstextChanged = false; }
protected override void OnInitialized(EventArgs e) { base.OnInitialized(e); if (CostCenterID == 0) { return; } ArrayList Param = new ArrayList(); Param.Add(CostCenterID); Param.Add(TypeID); Param.Add(UserID); Param.Add(LanguageID); DataSet ds = new PACT.DBHandler.DBHandler().GetCostCenterListView(CompanyDBIndex, Param); ListViewID = Convert.ToInt32(ds.Tables[0].Rows[0]["ListViewID"].ToString()); this.IsEditable = true; Microsoft.Windows.Controls.DataGridTextColumn dgCol; dgCol = new Microsoft.Windows.Controls.DataGridTextColumn(); dgCol.Header = strPrimaryKey; dgCol.Binding = new Binding(strPrimaryKey); dgCol.Visibility = System.Windows.Visibility.Hidden; this.Columns.Add(dgCol); ColumnsList = new ArrayList(); for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { if (i == 0) { strColumns = ds.Tables[1].Rows[i]["SysColumnName"].ToString(); } else { strColumns += "," + ds.Tables[1].Rows[i]["SysColumnName"].ToString(); } ColumnsList.Add(ds.Tables[1].Rows[i]["SysColumnName"].ToString()); dgCol = new Microsoft.Windows.Controls.DataGridTextColumn(); dgCol.Header = ds.Tables[1].Rows[i]["UserColumnName"].ToString(); if (ds.Tables[1].Rows.Count == 1) { dgCol.Width = this.Width; } else { dgCol.Width = Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString()); } dgCol.CanUserResize = false; dgCol.CanUserSort = false; dgCol.Binding = new Binding(ds.Tables[1].Rows[i]["SysColumnName"].ToString()); iWidth += Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString()); this.Columns.Add(dgCol); } if (this.SelectedValue != null) { valueSelected = true; } //this.SelectedValue = new Binding(strPrimaryKey); this.SelectedValuePath = strPrimaryKey; }