C#

DR = scmd.ExecuteReader();
             foreach (int VouType in DR)

Member 12899746 wrote:

foreach (int VouType in DR)
{
   vochcombox.Items.Add(VouType);
}

Member 12899746 wrote:

while (DR.Read())
{
   this.vochcombox.Items.Add(DR.GetOrdinal("VouType"));
}

public void FillCompVouType()
{
    Cursor = Cursors.WaitCursor;
    try
    {
        using (var connection = new SqlConnection(cs.sourceConn1))
        using (var command = new SqlCommand("Select Distinct VouType From Table_name Where Colum=1 order by VouType", connection))
        {
            vochcombox.Items.Clear();
            
            connection.Open();
            using (var dr = command.ExecuteReader())
            {
                while (dr.Read())
                {
                    vochcombox.Items.Add(dr.GetInt32("VouType"));
                }
            }
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
    finally
    {
        Cursor = Cursors.Default;
    }
}

SomeObjectProcessorResult myObject = SomeObject.Process(someString,Processor_Option_1);
var res = myObject.result;

public class SomeObject {
   public static SomeObjectProcessorResult Process(string someString, ProcessorType option) {
      // process and return
   }
}

public class SomeObjectProcessResult {
   public Type result; // for property, Result.
}

TheOnlyRealTodd wrote:

Option 2 also uses class state member variables whereas 1 just passes it function-to-function as argument.

if (row.Cells[this.invoiceNO.Index].Value == true)

Member 12899746 wrote:

Operator '==' cannot be applied to operands of type 'object' and 'bool'

if ((bool)row.Cells[this.invoiceNO.Index].Value == true)

if ((bool)row.Cells[this.invoiceNO.Index].Value)

Rebyc Rebyc wrote:

because it is being used by another process"

private Dictionary<char, int> numbers;
        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            string number = tbHint1.Text + tbHint2.Text + tbHint3.Text + tbHint4.Text + tbHint5.Text + tbHint6.Text;
            numbers = number.GroupBy(c => c).ToDictionary(g => g.Key, g => g.Count());
            if (char.IsDigit(e.KeyChar) || char.IsSymbol(e.KeyChar))
            {
                char keyPressedByUser = e.KeyChar;
                if (!number.Contains(keyPressedByUser))
                {
                    e.Handled = true;
                    return;
                }
                int inputCount = textBox1.Text.ToUpper().Where(c => c == keyPressedByUser).Count() + 1;
                if (inputCount > numbers[keyPressedByUser])
                {
                    e.Handled = true;
                    return;
                }
                e.Handled = false;
            }
            else
            {
                e.Handled = true;
            }
        }

Public Const IntegerStrings As String = "0123456789" + ChrW(8) ' Numbers & backspace

Public Sub IntegerKeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles tbHigh.KeyPress, tbLow.KeyPress
        '
        ' Ignore non-numeric keys
        '
        If IntegerStrings.IndexOf(e.KeyChar) = -1 Then
            e.Handled = True
        End If
    End Sub