DATAbase

Question

i have one table ROOM and in this RoomNO is one column and in this some roomnos are already stored then now i am retrive that room numbers and and count how many are there. print equal no.of buttons and display roomno as button Text

chennakrishnareddy bijivemula · Answer

SqlConnection cn = new SqlConnection(conn); cn.Open(); string s =  select room_no from HOTEL_RESERV; SqlCommand cmd = new SqlCommand(s cn); SqlDataAdapter da = new SqlDataAdapter(cmd); // SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); int i = da.Fill(dt); // if (dr.Read()) { for (int n = 0; n < i; n++) { Button button = new Button(); button.Location = new Point(100 30 * n + 10); button.Click += new EventHandler(button1_Click); button.Tag = n; this.Controls.Add(button); button.Text = n.ToString(); button.BackColor = Color.Orange; } its create 4 buttons but it dispaly button text as 0123 but i want button text as what the data store in data base

chennakrishnareddy bijivemula · Answer

SqlConnection cn = new SqlConnection(conn); cn.Open(); string s =  select room_no from HOTEL_RESERV; SqlCommand cmd = new SqlCommand(s cn); SqlDataAdapter da = new SqlDataAdapter(cmd); // SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); int i = da.Fill(dt); // if (dr.Read()) { for (int n = 0; n < i; n++) { Button button = new Button(); button.Location = new Point(100 30 * n + 10); button.Click += new EventHandler(button1_Click); button.Tag = n; this.Controls.Add(button); button.Text = n.ToString(); button.BackColor = Color.Orange; } its create 4 buttons but it dispaly button text as 0123 but i want button text as what the data store in data base

chennakrishnareddy bijivemula · Answer

SqlConnection cn = new SqlConnection(conn); cn.Open(); string s =  select room_no from HOTEL_RESERV; SqlCommand cmd = new SqlCommand(s cn); //cn.Close(); //cn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); // SqlDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); int i = da.Fill(dt); // if (dr.Read()) { for (int n = 0; n < i; n++) { Button button = new Button(); button.Location = new Point(100 30 * n + 10); button.Click += new EventHandler(button1_Click); button.Tag = n; this.Controls.Add(button); button.Text = n.ToString(); button.BackColor = Color.Orange; }

chennakrishnareddy bijivemula · Answer

select room_no from HOTEL_RESERV When u execute this query it takes for example 4 rooms like 190191192193 then dynamical create 4 buttons and dispaly their names as 190191192193

chennakrishnareddy bijivemula · Answer

windows

Vivek Bansod · Answer

Hi You need to dynamically create button and assign values to button properties. when you have values from DB available - loops through table rows and assign it to button.Text = Value from DB Refer this thread for quick help - http://stackoverflow.com/questions/4942208/assign-text-value-to-buttons-from-database-in-net Also go through this link for dynamic button creation with propertied & its events like button click http://www.c-sharpcorner.com/uploadfile/mahesh/creating-a-button-at-run-time-in-C-Sharp/ Let me know if this helps

Rajeesh Menoth · Answer

Hi The following query will return the count of RoomNO . SELECT COUNT( RoomNO ) FROM table_name;

Sujeet Suman · Answer

Could you please let us know your query?

Rajeev Punhani · Answer

Hi Do you want to achieve this in windows/web application?

Shweta Lodha · Answer

What is your query?