private void btnGo_Click(object sender, EventArgs e)
{
if (txtQuery.Text == "")
{
return;
}
var dbCon = DBConnetion.Instance();
dbCon.DatabaseName = "ugc";
if (dbCon.IsConnect())
{
string query = txtQuery.Text; //" call clients_all()";//"SELECT * FROM tiers";
var cmd = new MySql.Data.MySqlClient.MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt16("id");
string code = (reader.IsDBNull(1)) ? "" : reader.GetString("code");
string famille = (reader.IsDBNull(2)) ? "" : reader.GetString("famille");
string raison = (reader.IsDBNull(3)) ? "" : reader.GetString("raison");
//raison = reader.GetString("raison");
decimal solde = reader.GetDecimal("solde");
string fixe = (reader.IsDBNull(5)) ? "" : reader.GetString("fixe");
string mobile = (reader.IsDBNull(6)) ? "" : reader.GetString("mobile");
string email = (reader.IsDBNull(7)) ? "" : reader.GetString("email");
string fax = (reader.IsDBNull(8)) ? "" : reader.GetString("fax");
decimal chiffre_affaire = reader.GetDecimal("chiffre_affaire");
string ville = (reader.IsDBNull(10)) ? "" : reader.GetString("ville");
string modereglement = (reader.IsDBNull(11)) ? "" : reader.GetString("modereglement");
string type = (reader.IsDBNull(12)) ? "" : reader.GetString("type");
string adresse = (reader.IsDBNull(13)) ? "" : reader.GetString("adresse");
txtResult.Text += id + "\t" + code + "\t" + raison + "\t"
+ fixe + "\t" + mobile + "\t" + fax + "\t" + email + "\t"
+ famille + "\t" + solde + "\t" + chiffre_affaire + "\t"
+ ville + "\t" + modereglement + "\t" + type + "\t" + adresse + "\r\n";
/*
* Console.WriteLine(id + "\t" + code + "\t" + raison + "\t"
+ fixe + "\t" + mobile + "\t" + fax + "\t" + email + "\t"
+ famille + "\t" + solde + "\t" + chiffre_affaire + "\t"
+ ville + "\t" + modereglement + "\t" + type + "\t" + adresse
+ );
*/
}
Console.WriteLine(reader.GetSchemaTable().TableName);
reader.Close();
// dbCon.Close();
}
}
private void openDbAnsBind()
{
var dbCon = DBConnetion.Instance();
dbCon.DatabaseName = "ugc";
if (dbCon.IsConnect())
{
MySqlDataAdapter Da = new MySqlDataAdapter();
string query = "Call clients_all()";
Da.SelectCommand = new MySqlCommand(query, dbCon.Connection);
DataTable table = new DataTable();
Da.Fill(table);
BindingSource bsource = new BindingSource();
bsource.DataSource = table;
dgClients.DataSource = bsource;
// dgClients.DataBindingComplete();
}
}
