private void ToBase(List <string> files) { List <string> error = new List <string>(); int schet = 0; foreach (string file in files) { List <string> Loaded = XmlAdapter.Load(file); List <string> NameCo = new List <string>(); List <string> NameRo = new List <string>(); NameCo.Add(NameColumns[0]); NameRo.Add(Loaded[2]); foreach (string f in NameColumns) { int i = Loaded.IndexOf(f); if (i != -1) { NameCo.Add(f); string lol = Loaded[i + 1]; lol = lol.Replace("'", ""); NameRo.Add(lol); } } textWeb.Text = textWeb.Text + SqlAdapter.AddRow("Intel", NameCo, NameRo) + "\n"; schet++; } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { label5.Text = comboBox1.Items[comboBox1.SelectedIndex].ToString(); dataGridView1.DataSource = SqlAdapter.GetTabel(comboBox1.Items[comboBox1.SelectedIndex].ToString()).Tables[comboBox1.Items[comboBox1.SelectedIndex].ToString()]; label6.Text = "Количество столбцов = " + dataGridView1.ColumnCount.ToString() + "\r\nКоличество строк = " + dataGridView1.RowCount.ToString(); for (int i = 0; i < dataGridView1.ColumnCount; i++) { NameColumns.Add(dataGridView1.Columns[i].Name); } }
private void button1_Click(object sender, EventArgs e) { string connStr = String.Format("server={0};user={1};password={2}; database={3}", textBoxServer.Text, textBoxUser.Text, textBoxPass.Text, "databasa"); if (SqlAdapter.IsConnect(connStr) == true) { List <string> tabels = SqlAdapter.GetTabels(); for (int i = 0; i < tabels.Count; i++) { comboBox1.Items.Add(tabels[i]); } } }