J'ai besoin de convertir cette table mysql:
FirstName | LastName | Street | City | State | Zipcode | Contact Number
----------+----------+-------------+---------+-------+---------+----------------
John | Doe | 123 W. Main | Chicago | IL | 60600 | (312)555-7458
Jane | Doe | 321 W. Main | Chicago | IL | 60600 | (312)555-6628
à cette table dans datagridview:
Name | Address | Contact Name
---------+-------------------------------+--------------
John Doe | 123 W. Main Chicago, IL 60600 | (312)555-7458
Jane Doe | 321 W. Main Chicago, IL 60600 | (312)555-6628
J'ai essayé le code ci-dessous mais les colonnes datagridview 0 et 1 sont vides
string Query = "SELECT * FROM people.client";
MySqlConnection myConn = new MySqlConnection(myconnection);
MySqlCommand cmdDataBase = new MySqlCommand(Query, myConn);
MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
myDataAdapter.SelectCommand = cmdDataBase;
DataTable dbdataset = new DataTable();
myDataAdapter.Fill(dbdataset);
//Set AutoGenerateColumns False
dataGridView1.AutoGenerateColumns = false;
//Set Columns Count
dataGridView1.ColumnCount = 3;
//Add Columns
dataGridView1.Columns[0].HeaderText = "Name";
dataGridView1.Columns[0].DataPropertyName = "FirstName+ ' ' +LastName";
dataGridView1.Columns[1].HeaderText = "Address";
dataGridView1.Columns[1].DataPropertyName = "Street+ '' +City+ '' +State+ '' +Zipcode";
dataGridView1.Columns[2].HeaderText = "Contact Number";
dataGridView1.Columns[2].DataPropertyName = "Contact Number";
dataGridView1.DataSource = dbdataset;
Toute aide serait appréciée. Merci d'avance.
SELECT CONCAT(FIRSTNAME, " ", LASTNAME) AS NAME,
CONCAT(STREET, " ", CITY, ", ", STATE, " ", ZIPCODE) AS ADDRESS, PHONE
FROM people.client
Cela sélectionne vos deux champs et les sépare par un espace.
Cet article est collecté sur Internet, veuillez indiquer la source lors de la réimpression.
En cas d'infraction, veuillez [email protected] Supprimer.
laisse moi dire quelques mots