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]);
}
}
}
