DATAbase

chennakrishnareddy bijivemula

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

10 Replies

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

chennakrishnareddy bijivemula10y ago
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 0,1,2,3 but i want button text as what the data store in data base
chennakrishnareddy bijivemula10y ago
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 0,1,2,3 but i want button text as what the data store in data base
chennakrishnareddy bijivemula10y ago
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 bijivemula10y ago
select room_no from HOTEL_RESERV When u execute this query it takes for example 4 rooms like 190,191,192,193 then dynamical create 4 buttons and dispaly their names as 190,191,192,193
chennakrishnareddy bijivemula10y ago
windows
Vivek Bansod10y ago
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 Menoth10y ago
Hi,

The following query will return the count of RoomNO .

SELECT COUNT(RoomNO ) FROM table_name;
Sujeet Suman10y ago
Could you please let us know your query?
Rajeev Punhani10y ago
Hi,

Do you want to achieve this in windows/web application?
Shweta Lodha10y ago
What is your query?