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

Question

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

Vulpes · 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 { DataRow dr = dt.Rows[i]; dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString(); for (int j = 1; j { int k = int.Parse(dr[j].ToString()); dataGridView1.Rows[i].Cells[k].Value = k; } } } } }

Vulpes · Answer

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 H · Answer

I want to set a column font bold.i try set datagridview1.Columns[7].DefaultCellStyle.Font=Font.Bold; but running error.way? thanks

Ken H · Answer

well thank for Vulpes.

Vulpes · Answer

Well it's slightly different to what you originally described but try this: dataGridView1.RowCount = dt.Rows.Count; for(int i = 0; i { DataRow dr = dt.Rows[i]; dataGridView1.Rows[i].Cells[0].Value = dr[0].ToString(); for(int j = 1; j { int k = int.Parse(dr[j].ToString()); dataGridView1.Rows[i].Cells[k].Value = k; } }

Nattudurai Eswaramurthy · Answer

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 }

Vulpes · Answer

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 H · Answer

hi Vulpes i do't know how to upload attachments in hereI'd like to upload attachments may let you know some. thanks

Vulpes · Answer

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 { DataRow dr = dt.Rows[i]; for(int j = 0; j { int k = int.Parse(dr[j].ToString()); dataGridView1.Rows[i].Cells[k - 1].Value = k; } }