C#

mobasher wrote:

also do you think that the anti viruses warn about it?

public void get_system_properties()
{
    try
    {
_system_parameters_hash = new Hashtable();

_system_parameters_hash.Add("SQL_SERVER_CONNECTION", null);
_system_parameters_hash.Add("SQL_SERVER_DATABASE", "Cure");
_system_parameters_hash.Add("EVENT_LOG_DESCRIPTION", null);

_system_parameters_hash["SQL_SERVER_CONNECTION"] = "Data Source=";
_system_parameters_hash["SQL_SERVER_CONNECTION"] += cure_registry_current_user.GetValue("SQLServer").ToString();
_system_parameters_hash["SQL_SERVER_CONNECTION"] += ";initial catalog=";
_system_parameters_hash["SQL_SERVER_CONNECTION"] += cure_registry_current_user.GetValue("SQLDatabase").ToString();
_system_parameters_hash["SQL_SERVER_CONNECTION"] += ";User Id=";
_system_parameters_hash["SQL_SERVER_CONNECTION"] += cure_registry_current_user.GetValue("SQLUser").ToString();
_system_parameters_hash["SQL_SERVER_CONNECTION"] += ";Password=";
_system_parameters_hash["SQL_SERVER_CONNECTION"] += cure_registry_current_user.GetValue("SQLPassword").ToString();
_system_parameters_hash["SQL_SERVER_CONNECTION"] += ";Connection Timeout=";
_system_parameters_hash["SQL_SERVER_CONNECTION"] += cure_registry_current_user.GetValue("SQLTimeout").ToString();

sql_connection = new SqlConnection((string)_system_parameters_hash["SQL_SERVER_CONNECTION"]);
sql_connection.Open();
sql_command = new SqlCommand("sp_get_system_parameters", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_reader = sql_command.ExecuteReader();

while (sql_reader.Read())
{
    if (_system_parameters_hash.ContainsKey(sql_reader["system_param_name"])) return;

    if (sql_reader["system_param_value"] == DBNull.Value)
    {
_system_parameters_hash.Add(sql_reader["system_param_name"].ToString(), null);
    }
    else
    {
if ((string)sql_reader["system_param_type"] == "bit") _system_parameters_hash.Add((string)sql_reader["system_param_name"], Convert.ToBoolean(sql_reader["system_param_value"]));
else if ((string)sql_reader["system_param_type"] == "string") _system_parameters_hash.Add((string)sql_reader["system_param_name"], (string)sql_reader["system_param_value"]);
else if ((string)sql_reader["system_param_type"] == "int") _system_parameters_hash.Add((string)sql_reader["system_param_name"], Convert.ToInt32(sql_reader["system_param_value"]));
else if ((string)sql_reader["system_param_type"] == "int64") _system_parameters_hash.Add((string)sql_reader["system_param_name"], Convert.ToInt64(sql_reader["system_param_value"]));
else if ((string)sql_reader["system_param_type"] == "short") _system_parameters_hash.Add((string)sql_reader["system_param_name"], Convert.ToInt16(sql_reader["system_param_value"]));
    }
}

Trace.Write(_system_parameters_hash.Count);
    }
    catch (Exception exp)
    {
create_event("System", "Error populating system properties!!", exp, EventLogEntryType.Error, 1000, false);
MessageBox.Show("Error populating system properties!!" + Environment.NewLine + "Please contact your system administrator.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
    }
    finally
    {
if (sql_reader != null) sql_reader.Close();
if (sql_connection != null)
{
    if (sql_connection.State == ConnectionState.Open)
sql_connection.Close();
}
    }
}

VCsamir wrote:

Bitmap bmp1 = new Bitmap(bmp);

public partial class Form1 : Form
    {
        private DataView _dataView;

        public Form1()
        {
            InitializeComponent();

            for (int i = 0; i < 10000; i++)
            {
                dataSet1.Tables[0].Rows.Add("A" + i, "A", "A", "A");
                dataSet1.Tables[0].Rows.Add("Ae" + i, "Ae", "Ae", "Ae");
                dataSet1.Tables[0].Rows.Add("B" + i, "B", "B", "B");
                dataSet1.Tables[0].Rows.Add("Be" + i, "Be", "Be", "Be");
                dataSet1.Tables[0].Rows.Add("C" + i, "C", "C", "C");
                dataSet1.Tables[0].Rows.Add("D" + i, "D", "D", "D");
                dataSet1.Tables[0].Rows.Add("E" + i, "E", "E", "E");
                dataSet1.Tables[0].Rows.Add("F" + i, "F", "F", "F");
            }            
            
            _dataView = new DataView(dataSet1.Tables[0]);

            dataGridView1.DataSource = _dataView;
        }

        public void SelectRowsInView(string filter)
        {
            Dictionary<string, DataGridViewRow> dataGridViewRows = new Dictionary<string,DataGridViewRow>();

            DataRow[] dataRows = _dataView.Table.Select(filter);
                        
            foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows)
            {
                if (dataGridViewRow.Cells[0].Value != null){
                    dataGridViewRows.Add(dataGridViewRow.Cells[0].Value.ToString(), dataGridViewRow);
                }
            }

            dataGridView1.ClearSelection();

            foreach (DataRow row in dataRows)
            {
                if ( dataGridViewRows.ContainsKey( row[0].ToString() ) )
                {
                    dataGridViewRows[row[0].ToString()].Selected = true;
                }
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SelectRowsInView("Column1 like 'B*'");
        }
    }