Add buttons from datatable count row?

Question

0.00/5 (No votes)

See more:

Hello!

I need help with this problem:

I have Items table in sql and Group table!

What i need:

on load event of form i want to show Buttons to number of rows in Group Table and Buttons must have text of grup name!

After the buttons are displayed i want to show items on buttons and when i click a item button , the event of buttons must be Click. After clicking button listbox must be filled with data from items table!

P.S .Sorry for my english!....

Posted 13-Apr-11 7:48am

Atmir

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Accepted Answer · 2011-04-13T08:55:00

Solution 1

This should get you started

using(SqlConnection conn = new SqlConnection(...))
{
  using(SqlCommand cmd = new SqlCommand("SELECT ID, Name FROM Group", conn))
  {
    DataReader dr = cmd.ExecuteReader();
    while(dr.Read())
    {
       Button btn = new Button();
       btn.Text = dr["Name"].ToString();
       btn.CommandArgument = dr["ID"].ToString();
       btn.Command += new CommandEventHandler(OnBtnCommand);
       Controls.Add(btn);
    }
  }
}

protected void OnBtnCommand(object sender, CommandEventArgs e)
{
   // Load dropdown based on 
   int ID = int.Parse(e.CommandArgument);
}

Posted 13-Apr-11 8:55am

Not Active

Comments

Atmir 13-Apr-11 17:11pm

its ok but i need in VB.NET not in C#!

Dave Kreskowiak 13-Apr-11 17:20pm

So? You'd be amazed at how similar the two languages are if you just bothered to look at side-by-side examples posted all over MSDN.

Using conn As SqlConnection = New SqlConnection(...)

Using cmd As SqlCommand = New SqlCommand("SELECT ID, Name FROM Group", conn)

Dim dr As DataReader = cmd.ExecuteReader() Do While dr.Read()

Dim btn As Button = New Button()

btn.Text = dr("Name").ToString()

... You don't say if you're using Windows Forms or ASP.NET (Web App)...

Controls.Add(btn)
Loop
End Using
End Using

[no name] 13-Apr-11 17:54pm

Learn it.

If you plan on doing .NET development for a while you should learn to read both

Atmir 15-Apr-11 4:48am

how to use this " btn.Command += new CommandEventHandler(OnBtnCommand);"in vb.net?

i use
"class Public Class CommandEventArgs
Inherits EventArgs

End Class"
but is not working? any idea?