如何选择要向DataGridView中添加数据的列？

debugcn 发表于 Dev

Dabuleanu Catalin

我有此源代码：

private void button1_Click(object sender, EventArgs e)
    {
        dataGridView1.Visible = true;
        dataGridView2.Visible = true;
        SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Olimpiada\SistemSolar\SistemSolar\DBSistem.mdf;Integrated Security=True;User Instance=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT Denumire FROM Caracteristici", con);
        SqlCommand cmd1 = new SqlCommand("SELECT Valoare FROM Valori", con);
        SqlDataReader sdr = cmd.ExecuteReader();
        while (sdr.Read())
        {
            string[] RowData = { sdr.GetString(0) };
            dataGridView2.Rows.Add(RowData);
        }
        sdr.Close();
        //SqlCommand cmd1 = new SqlCommand("SELECT Valoare FROM Valori", con);
        SqlDataReader sdr1 = cmd1.ExecuteReader();
        while(sdr1.Read())
        {
            string[] RowData1 = { sdr1.GetString(0) };
            dataGridView2.Rows.Add(RowData1);
        }
        sdr1.Close();
        SqlCommand cmd2 = new SqlCommand("SELECT UM FROM Caracteristici", con);
        SqlDataReader sdr2 = cmd2.ExecuteReader();
        while (sdr2.Read())
        {
            string[] RowData2 = { sdr2.GetString(0) };
            dataGridView2.Rows.Add(RowData2);
        }
        sdr2.Close();

    }

我对此有一个疑问：在我完成插入RowData之后，如何选择移至另一列？因为使用此代码，所有数据仅在单个列上。

Dabuleanu Catalin

我解决了问题，我将解决方案留在这里：

string[] x = new string[100];
        string[] y = new string[100];
        string[] z = new string[100];
        string[] den = new string[100];
        SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBSistem.mdf;Integrated Security=True;User Instance=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("SELECT Denumire FROM Caracteristici", con);
        SqlCommand cmd1 = new SqlCommand("SELECT Valoare FROM Valori", con);
        SqlDataReader sdr = cmd.ExecuteReader();
        int i = 0;
        while (sdr.Read())
        {
                x[i] = sdr.GetString(0);
                i++;
        }
        sdr.Close();
        SqlDataReader sdr1 = cmd1.ExecuteReader();
        i = 0;
        while(sdr1.Read())
        {
            y[i] = sdr1.GetString(0);
            i++;
        }
        sdr1.Close();
        i = 0;
        SqlCommand cmd2 = new SqlCommand("SELECT UM From Caracteristici", con);
        SqlDataReader sdr2 = cmd2.ExecuteReader();
        while (sdr2.Read())
        {
            z[i] = sdr2.GetString(0);
            i++;
        }
        sdr2.Close();
        for (i = 0; i <= 10; i++)
        {
            string[] RowData = { x[i], y[i], z[i] };
            dataGridView2.Rows.Add(RowData);
        }

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。