Display values in Gridview

Arun Kumar

11y945Visual Basic .NET

Hi everyone,

Am developing Hotel Management software in windows application.

I have a room with 101,102,103,104,105,106,107,108,109 fixed Numbers in a column.

I want to get the room numbers from database and display these room numbers in Gridview like below.

101 102 103

104 105 106

107 108 109.

Is it possible..?

Thank u...

3 Replies

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

Sujeet Suman11y ago
List m_RoomNumber = new List( );

using (SqlConnection conn = new SqlConnection(connectionString))
{
   conn.Open();
   using (SqlCommand cmd = new SqlCommand())
   {
      cmd.Connection = conn;
      cmd.CommandType = CommandType.Text;
      cmd.CommandText = "Select RoomNumber from dbo.DB_ROOM"
      using (SqlDataReader reader = cmd.ExecuteReader())
      {
         While (reader .Read())
         {
           m_RoomNumber .Add( myReader.GetInt32(0));
         }
      }
   }
   conn.Close();

//Add record to DataGridView
for(int i = 0; i < m_RoomNumber .count; i++)
{
      DataGridViewRow row = (DataGridViewRow)yourDataGridView.Rows[0].Clone();
      row.Cells[0].Value =m_RoomNumber[i] ;
      row.Cells[1].Value = m_RoomNumber[i+1] ;
      row.Cells[2].Value = m_RoomNumber[i+2];
      DataGridView1.Rows.Add(row);
i += 3;
}
}

If this is helpful for you then please accept my Answer.
Srinivas Rao11y ago

select "datagridview" from tool box-->and click on the form-->
just click on the grid view, u find a smallarrow on the top-right side of the gridview-->select "datasource" and then next-->next-----> select the database u created ---->then click oncheckbox {select tables}-->click finish.
run the project,
then automatically ur colums will be displayed in the gridview.
u can try like this,it is one of the simple method.
If this is helpful for you then please Accept my answer.
Thank u..!
Nilesh Jadav11y ago
You can use Datalist for this purpose, Just take one datalist and in that take one HTML table and then just bind the data to the datalist it will show the data as you shown above. For gridview you have to write custom code for this.

Thank you !!