C#

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;
        }
    }