How do I populate a dropdownbox with a list of tables in a SQL database?

Question

Hello all! This is my first post here so hopefully my question is detailed enough for you all to help me.  I believe my question is rather simple, however, after much searching I haven't found what I am looking for.  What I have is a form with textbox and a datagridview that displays the results entered intot he textbox.  What I want is to have a dropdownbox or combobox that my users can select which sql table to search and then enter what they are searching in the textbox.  Right now I have to go into the solution and change the sql command to search a specific table and that is a hassle.

Thanks in advance and if I left any details out please let me know without bashing me please.

Kyle

Answer 1

Hi
   Declare array outside the for loop and get another variable total for sum...
You can display each number which is meet your condition i,e multiple of 3 or 5 and Lastly display Sum of these numbers. Use this code:-
using System;


namespace test
{
class Program
{
static void Main()
{
Program p = new Program();
p.sum(1000);


Console.ReadLine();
}


public void sum (int tal)
{
long total = 0;
int[] array= new int[1000];  //It does save in Array..(Here your problem get solved)
for (int i = 1; i < tal; i++)
{
if (i % 3 == 0 || i % 5 == 0)
{
array[i] += i;
 total = total + i;
Console.WriteLine(array[i]);
}
}
Console.WriteLine("Sum of multiple 3 or 5 below 1000= "+total);
}
}
}

Answer 2

Hi
   If your query resolved then mark as Correct Answer.

Answer 3

Thank you so much! :) I used this tips since I wanted to use Array.

Answer 4

Thank you so much! :) Good tips!

Answer 5

Hi.

Looking at your code I'm not sure of what you want to do... 

If you want to get the total sum, you should maybe do something like this:

namespace test
{
  class Program
  {
        static void Main(string[] args)
        {
                long totalSum = Sum(1000);
                Console.WriteLine(string.Format("Total sum: {0}", totalSum));
                Console.ReadLine();
        }

        public static long Sum(int tal)
        {
                long total = 0;
                for (int i = 1; i < tal; i++)
                {
                        if (i % 3 == 0 || i % 5 == 0)
                        {
                                total += i;
                        }
                }

                return total;
        }
   }

}