How to will value added to the corresponding in column in dataGridView

Ken H

hi,

   Datagridview have 50 column(these columns name is 1 to 50), need to database cycle out of the value stored in the corresponding column(Table there are 4 column stored value is also digital )
demoNUM table Data as follows:
SELECT * FROM demoNUM;
result:
   r_1 r_2 r_3 r_4
   1      2      4     50
   1      2     3     5
   2     3      5     50

Below is the effect of imitation:
datagridview columns name: 1     2    3    4 5 .....50
rows:                                       1      2          4          50
                                                 1      2    3        5
                                                         2     3       5      50
thanks

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
OK, just change the code in your Form class as follows:

namespace SSQ
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private SqlConnection connectSQL;
private SqlCommand cmdSQL;
private SqlDataAdapter adapterSQL;
private DataSet ds;

private void Form1_Load(object sender, EventArgs e)
{

connectSQL = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
try
{
connectSQL.Open();
cmdSQL = new SqlCommand("SELECT * FROM SSQ_RESULT", connectSQL);
adapterSQL = new SqlDataAdapter(cmdSQL);
ds = new DataSet();
adapterSQL.Fill(ds);
}
catch (Exception error)
{

MessageBox.Show(error.ToString(), "Program Error");
}
finally
{
if (connectSQL != null)
connectSQL.Close();
}

DataTable dt = ds.Tables[0];

dataGridView1.RowCount = dt.Rows.Count;

for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString();

for (int j = 1; j < 6; j++)
{
int k = int.Parse(dr[j].ToString());
dataGridView1.Rows[i].Cells[k].Value = k;
}
}
}
}
}
Vulpes14y ago
You have to create a new Font object.

Try it like this:

Font existing = dataGridView1.DefaultCellStyle.Font;
dataGridView1.Columns[7].DefaultCellStyle.Font = new Font(existing, existing.Style | FontStyle.Bold);
Ken H14y ago
I want to set a column font bold.i try set datagridview1.Columns[7].DefaultCellStyle.Font=Font.Bold;,but running error.way?

thanks
Ken H14y ago
well, thank for Vulpes.
Vulpes14y ago
Well, it's slightly different to what you originally described but try this:

dataGridView1.RowCount = dt.Rows.Count;

for(int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString();

for(int j = 1; j < 6; j++)
{
int k = int.Parse(dr[j].ToString());
dataGridView1.Rows[i].Cells[k].Value = k;
}
}
Nattudurai Eswaramurthy14y ago
HI,

its simple. Just look through all the rows and select a each column for the row for example
and do appropriately.

eg.
for(int i=0;i< GridView1.Rows.count;i++)
{

GridView1.Rows[i].Cells[0].Value

}
Vulpes14y ago
You have to put them in either a .zip or .rar file and then press the Choose File button to select the file and upload it.
Ken H14y ago
hi Vulpes,
i do't know how to upload attachments in here,I'd like to upload attachments may let you know some.
thanks
Vulpes14y ago
I'm assuming that you've already filled a DataTable (dt) with the records fetched from the database and that you've added 50 columns (and the appropriate headers) to the DataGridView (dataGridView1).

The code to populate the DGV's rows will then be:

dataGridView1.RowCount = dt.Rows.Count;

for(int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];

for(int j = 0; j < 4; j++)
{
int k = int.Parse(dr[j].ToString());
dataGridView1.Rows[i].Cells[k - 1].Value = k;
}
}