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