C#

SN = Microsoft.VisualBasic.Interaction.InputBox("Enter Serial Number", "", "", 200, 150);

using Microsoft.VisualBasic;

…
                                // Populate dataGridView with all available options for the given field (stored in oCodeList)
dgvMultiCodes.AutoGenerateColumns = false;
            dgvMultiCodes.DataSource = oCodeList.Table;

            string SQLState = ChcekedSQLStatement();        // Build SQL statement for options that are already checked

            SortedList<int, string> slCodeList = new SortedList<int, string>();
            int codeCD = 0;
            string desc = "";
            oCodeList.GoTop();
            // Save options DataTable values and keys in a SortedList
            while (!oCodeList.EoF)
            {
                codeCD = oCodeList.GetInteger("CD");
                desc = oCodeList.GetString("DEF");
                slCodeList.Add(codeCD, desc);
                oCodeList.Skip();
            }


            bool bChecked = false;
            // Select/check already selected checkboxes in the dataGridView
            ##DataReader checkedList = new ##DataReader(SQLState, currentUser.oConnection);
            while (checkedList.Read())
            {
                bChecked = slCodeList.ContainsKey(checkedList.GetInteger("KEYCODE"));

                if (bChecked)
                {
                    foreach (DataGridViewRow row in dgvMultiCodes.Rows)
                    {
                        if (row.Cells[dgvCodeCol.Index].Value.ToString() == checkedList.GetString("KEYCODE"))
                        {
                            row.Cells[dgvCheckCol.Index].Value = true;  // DOESN’T CHECK CHECKBOX IN DATAGRIDVIEW
                            break;
                        }
  }
                }

                bChecked = false;
            }
            …

public void RefreshValues() {
            if (!(this.DataGridViewColumn is DataGridViewComboBoxColumn)) {
                DataTable DistinctDataTable = this.BoundDataView.ToTable(true, new string[] { this.DataGridViewColumn.DataPropertyName });
                DistinctDataTable.DefaultView.Sort = this.DataGridViewColumn.DataPropertyName;
                comboBoxValue.DataSource = DistinctDataTable;
            }

strCmdText1 = @" cd C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE";
strCmdText2 = @"TF get $/Project_Path /recursive";

System.Diagnostics.Process.Start("CMD.exe", strCmdText1);
System.Diagnostics.Process.Start("CMD.exe", strCmdText2);

public bool validateuser(User u)
    {
        bool result = true;
        try
        {
            string validateq = "select count(*) from register where user.username = @username and user.password = @passwd ";
            cmd = new SqlCommand(validateq, con);
            cmd.Parameters.AddWithValue("@username", u.username);
            cmd.Parameters.AddWithValue("@passwd", u.password);
            con.Open();
            reader = cmd.ExecuteReader();
            reader.Read();
            int r = Convert.ToInt32(reader[0]);
            if (r > 0)
            {
                result = true;
            }
            else
            {
                result = false;
            }
            return result;

        }

        catch (Exception ex)
        {
              result = false;
            return result;
        }
    }