C#

select distinct ColumnA from Table1 union select ColumnA from Table2

select Table1.ColumnA from Table1 where Table1.ColumnA not in (select ColumnA from Table2)

select Table2.ColumnA from Table2 where Table2.ColumnA not in (select ColumnA from Table1)

Select A.ColumnA from
A left join B
on A.ColumnA=B.ColumnA
where B.ColumnA is null

Select B.ColumnA from 
B left join A
on B.ColumnA=A.ColumnA
where A.ColumnA is null

Select A.ColumnA from
A join B
on A.ColumnA=B.ColumnA

Wayne Gaylard wrote:

Hope this makes sense.

private void richTextBox1_ContentsResized(object sender, ContentsResizedEventArgs e)
 {
     textBox1.Text = e.NewRectangle.Width.ToString();
 }

 private void button1_Click(object sender, EventArgs e)
 {
     richTextBox1.Font = new System.Drawing.Font("Arial", 36F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
 }

Dave Kreskowiak wrote[^]:

If you have to hit that limit, you've got bigger issues with your application...

It's System.Int32.MaxValue, or 2,147,483,647. But since you wont be able to reach that limit without generating an OutOfMemory Exception, it's limited by available memory.

thatraja

---

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone

kgaurav.kumbhawat wrote:

add around 3000 columns to a dataset table

Mycroft Holmes wrote:

You can find the limitations in MSDN but I don't have a link.

From MSDN[^]:

To add rows to a DataTable, you must first use the NewRow method to return a new DataRow object. The NewRow method returns a row with the schema of the DataTable, as it is defined by the table's DataColumnCollection. The maximum number of rows that a DataTable can store is 16,777,216. For more information, see Adding Data to a DataTable.

thatraja

---

My Dad had a Heart Attack on this day so don't...
Pompeyboy3 here | Nobody remains a virgin, Life screws everyone

public partial class Form1 : Form
    {
        public ProgressBar Progress { get; set; }

        public Form1()
        {
            InitializeComponent();
            MyClass myClass = new MyClass();
            myClass.DoALengthyTask(Progress);
        }
    }

    class MyClass
    {
        public void DoALengthyTask(ProgressBar progress)
        {
            int i=0;
            while (true)
            {
                progress.Value = i;
                i++;
            }
        }
    }

<pre lang="cs">public partial class Form2 : Form
{
    public Form2()
    {
        InitializeComponent();
    }

    private void Form2_Load(object sender, EventArgs e)
    {

    }

    public ProgressBar ProgressBar
    {
        get { return this.progressBar; }
        set { this.progressBar = value; }
    }
}


class MyClass
{
    void InitLengthyJob()
    {

        private void BackgroundWorker1_DoWork(
            object sender,
            System.ComponentModel.DoWorkEventArgs e)
        {

            DoaLengthyJob();;
        }
    }

    void DoaLengthyJob()
        {
            int i=0;


                DoaLengthyJob() //recurssive call
                // time consuming operation
                Form2 f = new Form2;
                f.ProgressBar =i; // FROM HERE i WOULD LIKE TO UPDATE THE PROGRESS BAR
                i++

        ////do some thing


        }
}

ptr_Electron wrote:

void DoaLengthyJob()
        {
            int i=0;
            while (////)
            {
 
                // time consuming operation
                Form2 f = new Form2;
                f.ProgressBar =i;
                i++
 
            }
 

        }

<pre lang="cs">public partial class Form2 : Form
{
    public Form2()
    {
        InitializeComponent();
    }

    private void Form2_Load(object sender, EventArgs e)
    {

    }

    public ProgressBar ProgressBar
    {
        get { return this.progressBar; }
        set { this.progressBar = value; }
    }
}


class MyClass
{
    void InitLengthyJob()
    {

        private void BackgroundWorker1_DoWork(
            object sender,
            System.ComponentModel.DoWorkEventArgs e)
        {

            DoaLengthyJob();;
        }
    }

    void DoaLengthyJob()
        {
            int i=0;


                DoaLengthyJob() //recurssive call
                // time consuming operation
                Form2 f = new Form2;
                f.ProgressBar =i; // FROM HERE i WOULD LIKE TO UPDATE THE PROGRESS BAR
                i++

        ////do some thing


        }
}