Guest User

Untitled

a guest
Jan 22nd, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. using System.Data.OleDb;
  2.  
  3. string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=P:DatabaseDBdatabase.mdb";
  4. OleDbConnection oleDbConn;
  5.  
  6.  
  7. OleDbCommand oleComm;
  8. OleDbDataReader oleRead;
  9. oleDbConn = new OleDbConnection(ConnStr); //инициируем соединение
  10. oleDbConn.Open();
  11.  
  12. private void button10_Click(object sender, EventArgs e) //
  13. {
  14. try
  15. {
  16. string path = @"P:DatabaseDB2018test.txt";
  17.  
  18. string s = File.ReadLines(path, Encoding.GetEncoding(1251)).Skip(0).First(); //Encoding.GetEncoding(1251) чтобы не было знаков вопроса вместо кириллицы
  19.  
  20. MessageBox.Show(s);
  21. textBox2.Text = s;
  22.  
  23. //
  24.  
  25. DataSet ds2 = new DataSet();
  26. OleDbDataAdapter da2 = new OleDbDataAdapter(s, oleDbConn);
  27.  
  28. da2.Fill(ds2, "Spectr");
  29.  
  30. dataGridView1.DataSource = ds2.Tables[0];
  31. }
  32.  
  33. catch (Exception d)
  34. {
  35. Console.WriteLine(d.Message);
  36. }
  37. }
  38.  
  39. private void button10_Click(object sender, EventArgs e) //
  40. {
  41. try
  42. {
  43. string path = @"P:DatabaseDB2018test.txt";
  44.  
  45. string s = File.ReadLines(path, Encoding.GetEncoding(1251)).Skip(3).First(); //Encoding.GetEncoding(1251) чтобы не было знаков вопроса вместо кириллицы
  46.  
  47. MessageBox.Show(s);
  48. textBox2.Text = s;
  49. OleDbDataAdapter adapter = new OleDbDataAdapter();
  50. oleComm = new OleDbCommand(s, oleDbConn);
  51. adapter.InsertCommand = oleComm;
  52.  
  53. }
  54.  
  55. catch (Exception d) // ловит исключения
  56. {
  57. Console.WriteLine(d.Message);
  58. }
  59.  
  60. }
Add Comment
Please, Sign In to add comment