private void button1_Click(object sender, EventArgs e) { MySqlConnection connection; // objekt i library MySql.Data.MySqlClient //alla connection data i en enda sträng connection = new MySqlConnection(connectionString); connection.Open(); string sqlsats = "Select Kund_ID,FirmaNamn,Omsattning from kunder"; lblSQLsats.Text = sqlsats; //Skapa SQL-kommando MySqlCommand cmd = new MySqlCommand(sqlsats, connection); //Skapa data reader och utför kommando MySqlDataAdapter dataReader = new MySqlDataAdapter(sqlsats, connection); DataTable dt = new DataTable(); dataReader.Fill(dt); DataRow dr = dt.Rows[0]; kunder tbknd = new kunder(dr); dataGridView1.DataSource = dt; connection.Close(); }
public static GResp Parse(string query) { FieldAst field = new FieldAst(); var originalQuery = query; try { Trim(ref query); field.Name = GetQueryName(query); field.Fields = GetFields(query); GraphQLTree.Add(field); kunder kund = new kunder(); Fri00 friKund = new Fri00(); foreach (var f in field.Fields) { var res = kund.Resolver(f).Invoke(); foreach (PropertyInfo prop in friKund.GetType().GetProperties()) { if (prop.Name.ToLower() == f.ToLower()) { prop.SetValue(friKund, res); } } } return(new GResp() { Value = friKund, Name = field.Name }); } catch { throw new Exception("Error in query " + originalQuery); } }
private void button2_Click(object sender, EventArgs e) { kunder ralf = new kunder(); lblSQLsats.Text = (ralf.GetUpdateQuery()); }