1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
|
public partial class Form5 : Form
{
private DataColumnCollection TableColumnCollection;
private DataTable TableFilterData;
private DataSet DataSetRecords;
private DataView ViewRecords;
string ex_cust_pk="";
public Form5()
{
InitializeComponent();
LoadTable();
}
private void LoadTable()
{
try
{
DataSetRecords = new DataSet("DataSetRecords");
string strAccessSelect = @"select
rec_cust_fk as ID,
cust_status as Status,
cust_anr as ApoNr,
cust_adr as AdrNr,
cust_name1 as Name1,
cust_name2 as Name2,
cust_strasse as Strasse,
cust_plz as PLZ,
cust_ort as Ort,
cust_tel as Telefon,
sum(rec_anzahl) as Bestand
from tb_records
INNER JOIN tb_Customer
ON rec_cust_fk =cust_pk
group by rec_cust_fk,
cust_status,
cust_anr,
cust_adr,
cust_name1,
cust_name2,
cust_strasse,
cust_plz,
cust_ort,
cust_tel";
string connectionString = "Data Source=" + IP + "," + PORT + ";User ID=" + USERNAME + ";Password=" + PASSWORD + ";Provider = SQLOLEDB" + ";Initial Catalog=" + DB + ";Trusted_Connection=True" + ";";
OleDbConnection myConnection = new OleDbConnection(connectionString);
OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myConnection);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
myConnection.Open();
myDataAdapter.Fill(DataSetRecords, "TempAbfrage");
DataRowCollection dra = DataSetRecords.Tables["TempAbfrage"].Rows;
myConnection.Close();
TableColumnCollection = DataSetRecords.Tables[0].Columns;
ViewRecords = DataSetRecords.Tables[0].DefaultView;
DataGridTableStyle GridStyle = new DataGridTableStyle();
GridStyle.MappingName = DataSetRecords.Tables[0].TableName;
GridStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
GridStyle.GridLineColor = System.Drawing.Color.MediumSlateBlue;
DataGridRecords.TableStyles.Add(GridStyle);
DataGridRecords.SetDataBinding(ViewRecords, "");
}
catch (System.Exception a_Ex)
{
MessageBox.Show(a_Ex.Message);
}
}
private void ButtonDataFilter_Click(object sender, EventArgs e)
{
DataFilterForm DataFilter = new DataFilterForm();
DataFilter.SetSourceColumns(TableColumnCollection);
DataFilter.ShowDialog();
TableFilterData = DataFilter.GetFilterDataTable();
SetTableByDataFilter();
}
private void SetTableByDataFilter()
{
ViewRecords = new DataView(DataSetRecords.Tables[0]);
try
{
foreach (DataRow FilterRow in TableFilterData.Rows)
{
if (FilterRow["Operation"].ToString() != string.Empty && FilterRow["ColumnData"].ToString() != string.Empty)
{
if (ViewRecords.RowFilter == string.Empty)
{
ViewRecords.RowFilter = FilterRow["ColumnName"].ToString() + " " + FilterRow["Operation"].ToString() + " '" + FilterRow["ColumnData"].ToString() + "' ";
}
else
{
ViewRecords.RowFilter += " AND " + FilterRow["ColumnName"].ToString() + " " + FilterRow["Operation"].ToString() + " '" + FilterRow["ColumnData"].ToString() + "'";
}
}
}
DataGridRecords.SetDataBinding(ViewRecords, "");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void DataGridRecords_DoubleClick(object sender, EventArgs e)
{
string wert = ViewRecords.Table.Rows[DataGridRecords.CurrentRowIndex].ItemArray[0].ToString();
Form6 xForm = new Form6();
ex_cust_pk = wert;
xForm.TextToShow = ex_cust_pk;
xForm.Show();
}
} |
.