How to direct get the value form database to button.text?

Question

Hi  How to get directly the lastName and firstName from database to my button text?

Vulpes · Answer

The code should either be like this: conn.Open(); string query = select firstName lastName from Captain order by LastName; // or whatever SqlCommand cmd = new SqlCommand(query conn); SqlDataReader reader = cmd.ExecuteReader(); int num = 0; while (reader.Read() && num { num++; Button btn = (Button)this.Controls[btnCandidates + num.ToString()]; btn.Text = reader[0].ToString() +   + reader[1].ToString(); } conn.Close(); // or if you want to assign to the buttons individually like this: conn.Open(); string query = select firstName lastName from Captain order by LastName; // or whatever SqlCommand cmd = new SqlCommand(query conn); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); btnCandidates1.Text = reader[0].ToString() +   + reader[1].ToString(); reader.Read(); btnCandidates2.Text = reader[0].ToString() +   + reader[1].ToString(); reader.Read(); btnCandidates3.Text = reader[0].ToString() +   + reader[1].ToString(); reader.Read(); btnCandidates4.Text = reader[0].ToString() +   + reader[1].ToString(); reader.Read(); btnCandidates5.Text = reader[0].ToString() +   + reader[1].ToString(); conn.Close();

Satyapriya Nayak · Answer

Hi Black Try thisHere in Full Name button while clicking one after another all name will bind to the button. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace filter_dropdown { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oledb; string str; BindingManagerBase bm; DataSet ds; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from employee; com = new OleDbCommand(str con); oledb = new OleDbDataAdapter(com); ds = new DataSet(); oledb.Fill(ds employee); button1.DataBindings.Add(Text ds employee.empfirstname).ToString(); button2.DataBindings.Add(Text ds employee.emplastname).ToString(); bm = this.BindingContext[ds employee]; bm.Position = 0; con.Close(); button1.Visible = false; button2.Visible = false; } private void button3_Click(object sender EventArgs e) { button3.Text = button1.Text +   + button2.Text; bm.Position += 1; } } } Thanks If this post helps you mark it as answer

Vulpes · Answer

Assuming the buttons have been placed directly on the form (and not in a panel or other container) my code would change to: SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = select firstName lastName from table where empId SqlCommand cmd = new SqlCommand(query conn); SqlDataReader reader = cmd.ExecuteReader(); int num = 0; while (reader.Read() && num { num++; Button btn = (Button)this.Controls[button + num.ToString()]; btn.Text = reader[0].ToString() +   + reader[1].ToString(); } conn.Close();

Black Diamond · Answer

hi Vulpes Thank's a lot vulpes...it works properly....

Black Diamond · Answer

hi Vulpes Thank's a lot vulpes...it works properly....

Black Diamond · Answer

Hi Nayak; I saw the code you attach but it uses access and i use sql server 2005...

Black Diamond · Answer

hi vulpes This is the code i use to code in my project but it only display the btncandidates1.tex the first row of my table in my database i want that the rest of the buttons should display the other row of my table of my database... conn.Open(); string query = select firstName lastName from Captain order by LastName; // or whatever SqlCommand cmd = new SqlCommand(query conn); SqlDataReader reader = cmd.ExecuteReader(); int num = 0; while (reader.Read() && num { num++; btnCandidates1.Text = reader[0].ToString() +   + reader[1].ToString(); btnCandidates2.Text = reader[0].ToString() +   + reader[1].ToString(); btnCandidates3.Text = reader[0].ToString() +   + reader[1].ToString(); btnCandidates4.Text = reader[0].ToString() +   + reader[1].ToString(); btnCandidates5.Text = reader[0].ToString() +   + reader[1].ToString(); } conn.Close();

Vulpes · Answer

I assume that the query is now returning at least 5 rows. Have you remembered to change the 'if' statement to a 'while' statement?

Black Diamond · Answer

it's not work vulpes the first code you give to me works my button1 have displayed the 1st row of my table in my database but the rest of my button which is button2 and so on can't display the text comming from my table another rows in my database...the last code you give to me it's not working there's nothing display the text.

Black Diamond · Answer

Hi guyz! I have 5 buttons i need to put my lastName and FirstName in row0 to button1.text and the next button2.text is another row which is consist of LastName and firstName...i apply the code you've give to but the only one row can store to my button .

Satyapriya Nayak · Answer

Hi Black Here is your solution using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace filter_dropdown { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; string str; public Form1() { InitializeComponent(); } private void button1_Click(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from employee; com = new OleDbCommand(str con); OleDbDataReader reader = com.ExecuteReader(); if (reader.Read()) { //textBox1.Text = reader[empfirstname].ToString(); //textBox2.Text = reader[emplastname].ToString(); button1.Text = reader[empfirstname].ToString() +   + reader[emplastname].ToString(); } con.Close(); reader.Close(); } } } Thanks If this post helps you mark it as answer

Vulpes · Answer

The code to do that would be something like this: SqlConnection conn = new SqlConnection(connectionString); conn.Open(); string query = select firstName lastName from table where empId = 1; // or whatever SqlCommand cmd = new SqlCommand(query conn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { button1.Text = reader[0].ToString() +   + reader[1].ToString(); } conn.Close();