我在數(shù)據(jù)網(wǎng)格視圖上顯示一些數(shù)據(jù)時遇到問題。我在 form2 上將數(shù)據(jù)發(fā)送到 MySQL，然后它應(yīng)該顯示在 form1 的數(shù)據(jù)網(wǎng)格視圖中。數(shù)據(jù)網(wǎng)格視圖正在完美更新，但似乎數(shù)據(jù)表沒有填充完整信息。應(yīng)顯示 2 行數(shù)據(jù)。我在數(shù)據(jù)網(wǎng)格視圖中得到 2 個空行。我檢查了數(shù)據(jù)庫，信息在那里。是我的查詢不對嗎？我需要的是在quotes_idquotes 列中具有temp_quote.quote_id 的所有行。你能幫我嗎？這是代碼：public void RefreshGrid_parts() { ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["shopmanagerConnectionString1"]; MySqlConnection con = new MySqlConnection(conSettings.ToString()); con.Open(); MySqlCommand cmd = new MySqlCommand("select * from shopmanager.parts where quotes_idquotes = '" + temp_quote.quote_id + "';",con); DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(dt); dataGridView1.AutoGenerateColumns = false; dataGridView1.ColumnCount = 6; dataGridView1.Columns[0].HeaderText = "# Assembly"; dataGridView1.Columns[0].DataPropertyName = "assemblies_assembly_id"; dataGridView1.Columns[1].HeaderText = "# Part"; dataGridView1.Columns[1].DataPropertyName = "part_number"; dataGridView1.Columns[2].HeaderText = "# Item"; dataGridView1.Columns[2].DataPropertyName = "items_items_id"; dataGridView1.Columns[3].HeaderText = "# Description"; dataGridView1.Columns[3].DataPropertyName = "part_description"; dataGridView1.Columns[4].HeaderText = "Drawing Revision"; dataGridView1.Columns[4].DataPropertyName = "drawing_rev"; dataGridView1.Columns[5].HeaderText = "Quantity"; dataGridView1.Columns[5].DataPropertyName = "quantity"; dataGridView1.DataSource = dt; con.Close(); }
3 回答
鳳凰求蠱
TA貢獻(xiàn)1825條經(jīng)驗 獲得超4個贊
這是您的屬性示例：（是的，它的 mssql 但邏輯是相同的，只是更改類型，我手頭沒有 mysql 庫。我想您會弄清楚的。）
SqlClient.SqlCommand comand = new SqlClient.SqlCommand("Select * From ExampleTable Where Colum1 = $1");
comand.Parameters.Add(new SqlClient.SqlParameter("$1", "1234") { DbType = DbType.Int32 });
這也會將十進(jìn)制字符串解析為正確的數(shù)據(jù)類型 (int32)
肥皂起泡泡
TA貢獻(xiàn)1829條經(jīng)驗 獲得超6個贊
嘗試注釋創(chuàng)建標(biāo)題的行以測試您的數(shù)據(jù)是否會出現(xiàn)在 DataGrid 中。還將 AutoGenerateColumns 設(shè)置為 true。如果是，請檢查 DataPropertyName 是否正是您查詢中列的名稱。
public void RefreshGrid_parts()
{
ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["shopmanagerConnectionString1"];
MySqlConnection con = new MySqlConnection(conSettings.ToString());
con.Open();
MySqlCommand cmd = new MySqlCommand("select * from shopmanager.parts where quotes_idquotes = '" + temp_quote.quote_id + "';",con);
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.AutoGenerateColumns = true;
//dataGridView1.ColumnCount = 6;
//dataGridView1.Columns[0].HeaderText = "# Assembly";
//dataGridView1.Columns[0].DataPropertyName = "assemblies_assembly_id";
//dataGridView1.Columns[1].HeaderText = "# Part";
//dataGridView1.Columns[1].DataPropertyName = "part_number";
//dataGridView1.Columns[2].HeaderText = "# Item";
//dataGridView1.Columns[2].DataPropertyName = "items_items_id";
//dataGridView1.Columns[3].HeaderText = "# Description";
//dataGridView1.Columns[3].DataPropertyName = "part_description";
//dataGridView1.Columns[4].HeaderText = "Drawing Revision";
//dataGridView1.Columns[4].DataPropertyName = "drawing_rev";
//dataGridView1.Columns[5].HeaderText = "Quantity";
//dataGridView1.Columns[5].DataPropertyName = "quantity";
dataGridView1.DataSource = dt;
con.Close();
}
千巷貓影
TA貢獻(xiàn)1829條經(jīng)驗 獲得超7個贊
也許采納 Rodrigos 的建議，讓控件生成列。如果您只想更改這六列，只需更改查詢。
public void RefreshGrid_parts()
{
ConnectionStringSettings conSettings = ConfigurationManager.ConnectionStrings["shopmanagerConnectionString1"];
MySqlConnection con = new MySqlConnection(conSettings.ToString());
con.Open();
MySqlCommand cmd = new MySqlCommand("select assemblies_assembly_id as '# Assembly', part_number as '# Part', items_items_id as '# Item', part_description as '# Description', drawing_rev as 'Drawing Revision', quantity as 'Quantity' from shopmanager.parts where quotes_idquotes = $1;",con);
cmd.Parameters.Add(new MySqlParameter("$1", temp_quote.quote_id) { DbType = DbType.Int32 });
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = dt;
con.Close();
}
- 3 回答
- 0 關(guān)注
- 426 瀏覽
添加回答
舉報
0/150
提交
取消