Display values in Gridview

Question

Hi everyone Am developing Hotel Management software in windows application. I have a room with 101102103104105106107108109 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...

Sujeet Suman · Answer

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

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 thisit is one of the simple method. If this is helpful for you then please Accept my answer. Thank u..!

Nilesh Jadav · Answer

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 !!