private void Update() { FileDBF dbf = new FileDBF(); var dt1 = dbf.Execute(@"SELECT ACCT_NBR AS Номер_Аккаунта, SYMBOL AS Символ, SHARES AS Акции, PUR_PRICE AS Стоимость_Покупки, PUR_DATE AS Дата_покупки FROM holdings.dbf "); var dt2 = dbf.Execute(@"SELECT INDUSTRY AS Индустрия, SYMBOL AS Символ,CO_NAME AS Название_Компании, EXCHANGE AS Биржа, CUR_PRICE AS Цена, YRL_HIGH AS Максимальная_цена, YRL_LOW AS Минимальная_цена, P_E_RATIO AS Соотношение, BETA AS Бета, PROJ_GRTH AS Рост, PRICE_CHG AS Изменение_цены, SAFETY AS Безопасность, RATING AS Рейтинг, RANK AS Ранк, OUTLOOK AS Прогноз, RCMNDATION AS Рекомендации, RISK AS Риски FROM master.dbf "); var dt3 = dbf.Execute(@"SELECT IND_CODE AS Код, IND_NAME AS Сокращенное_Название, LONG_NAME AS Полное_название FROM industry.dbf "); dataGridView1.DataSource = dt1; dataGridView2.DataSource = dt2; dataGridView3.DataSource = dt3; }
private void button1_Click_1(object sender, EventArgs e) { if (dataGridView2.SelectedCells[0].ColumnIndex == 1) { FileDBF fld = new FileDBF(); string num = dataGridView2.SelectedCells[0].Value.ToString(); var dt3 = fld.Execute(@"SELECT ACCT_NBR AS Номер_Аккаунта, SYMBOL AS Символ, SHARES AS Акции, PUR_PRICE AS Стоимость_Покупки, PUR_DATE AS Дата_покупки FROM holdings.dbf WHERE SYMBOL = '" + num + "';"); dataGridView4.DataSource = dt3; } }
private void button2_Click(object sender, EventArgs e) { if (dataGridView3.SelectedCells[0].ColumnIndex == 0) { FileDBF fld = new FileDBF(); int num = Convert.ToInt32(dataGridView3.SelectedCells[0].Value.ToString()); var dt5 = fld.Execute(@"SELECT INDUSTRY AS Индустрия, SYMBOL AS Символ,CO_NAME AS Название_Компании, EXCHANGE AS Биржа, CUR_PRICE AS Цена, YRL_HIGH AS Максимальная_цена, YRL_LOW AS Минимальная_цена, P_E_RATIO AS Соотношение, BETA AS Бета, PROJ_GRTH AS Рост, PRICE_CHG AS Изменение_цены, SAFETY AS Безопасность, RATING AS Рейтинг, RANK AS Ранк, OUTLOOK AS Прогноз, RCMNDATION AS Рекомендации, RISK AS Риски FROM master.dbf WHERE INDUSTRY = " + num + ";"); dataGridView5.DataSource = dt5; } }