Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System.Data.OleDb;
- string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=P:DatabaseDBdatabase.mdb";
- OleDbConnection oleDbConn;
- OleDbCommand oleComm;
- OleDbDataReader oleRead;
- oleDbConn = new OleDbConnection(ConnStr); //инициируем соединение
- oleDbConn.Open();
- private void button10_Click(object sender, EventArgs e) //
- {
- try
- {
- string path = @"P:DatabaseDB2018test.txt";
- string s = File.ReadLines(path, Encoding.GetEncoding(1251)).Skip(0).First(); //Encoding.GetEncoding(1251) чтобы не было знаков вопроса вместо кириллицы
- MessageBox.Show(s);
- textBox2.Text = s;
- //
- DataSet ds2 = new DataSet();
- OleDbDataAdapter da2 = new OleDbDataAdapter(s, oleDbConn);
- da2.Fill(ds2, "Spectr");
- dataGridView1.DataSource = ds2.Tables[0];
- }
- catch (Exception d)
- {
- Console.WriteLine(d.Message);
- }
- }
- private void button10_Click(object sender, EventArgs e) //
- {
- try
- {
- string path = @"P:DatabaseDB2018test.txt";
- string s = File.ReadLines(path, Encoding.GetEncoding(1251)).Skip(3).First(); //Encoding.GetEncoding(1251) чтобы не было знаков вопроса вместо кириллицы
- MessageBox.Show(s);
- textBox2.Text = s;
- OleDbDataAdapter adapter = new OleDbDataAdapter();
- oleComm = new OleDbCommand(s, oleDbConn);
- adapter.InsertCommand = oleComm;
- }
- catch (Exception d) // ловит исключения
- {
- Console.WriteLine(d.Message);
- }
- }
Add Comment
Please, Sign In to add comment