Re: search in dataview without filtering - C# Discussion Boards

i did all that but it's still not working... it's actually existing the while loop when it reaches count 19 with no errors as if my total count in the database table is 19 only!!

any duplicates in the table? that was your question? no, duplicates, I already checked and I have also copied the entire table as excel format in this link:

system_parameters table[^]

this is my full code which I am using:

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

one of the recommendations I made was "add code to improve visibility", I see none of that.

before the reading loop, add code to show the number of rows returned, so you can check that number right away; identify the last row added, or better yet, the first one missing. Would it perhaps be the first one with type "short"? does that ring a bell?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

i copied the real code but i already did the count before when troubleshooting and I got the correct count as per my stored procedure.

what's wrong with the short? it's a data type and I am already including it in both the table row and the code?

just log intermediate results and locate the problem. it can't be hard. either the data comes in and doesn't get stored, or it does not come in. use logging, don't trust anything as one of your assumptions or observations is bound to be wrong since you don't agree with the results.

Sleepy | :zzz:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

hi friends $ Seniors,

i am trying to save an image in PNG format, the original image is 24dpi and is 16.2 mb, afterwards i add alpha channel to image and make some portion of the image transperant, after this when i save the image img.save(imagepath, imageformat.png) the size is increased to 33 mb. i wanted to know the image size increased is correct? does the image dpi changed from 24 to 32 increases the image so much?

friends, also debugging my code i found a strange thing, which i would like to share with u

Bitmap bmp = new Bitmap(imagepath);
bmp.save("c:\11.jpg"); // this saved image with 16 mb

Bitmap bmp1 = new Bitmap(bmp);
bmp1.save(c:\\22.jpg); // this saved image with 33 mb

Thanking in Advance

Regards
Samir

1. Maybe transparency uses the alpha channel, so now every pixel needs 4 bytes rather than 3?

2.
you should never use Bitmap.Save(string), always use Bitmap.Save(string,ImageFormat).

3.

VCsamir wrote:
Bitmap bmp1 = new Bitmap(bmp);

An image may hold metadata, e.g. a camera creating a JPEG file adds a lot of metadata to the pixel data. Copying a bitmap like you do does not copy the metadata.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

hello
I have a DataView and bind it to dataset. for find value in dataview, I use dataview.rowfilter
for Example :
dataview.RowFilter="FirstName like 'D*'";

This will display only those records where the FirstName column begins with D.
If I want to *select* those records where the FirstName column begins with D but still display all the records,
What can I do?

Hi, you cannot select a row by a DataView. i assume that you have bindet the DataView to a DataGridView Control. In this case, the only method to "select" the rows instead of filter, i know, is my following example.

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*'");
        }
    }

You have to use the primary key of the DataTable as Dictionary Key, there will be a exception, if you use a not non-ambiguous column as key, in this case, the primary key is index 0.

There a some performance optimizing by using a dictionary, i have desist from comment the source code, you can use the method SelectRowsInView as base idea. I hope i could help Smile | :)

i have got an eventhandler say evntHnadler , and i want to add another event that should be fired when the "evntHnadler" is fired , but before that i want to check if my second event is already registered with "evntHnadler " or not , any idea how to do it ...

Message Closed

modified 23-Nov-14 6:24am.

thanx this is ok for custom created events, but the problem is i'm trying to get the invocationlist from the button1.click, any idea ?

Hi to all,
How naming controls in C# ?
for example if you have a button for Register , a good name for this button is btnRegister

Button=btn
Label = lbl
TextBox = txt
PictureBox =? and other controls

I found very good guide for Naming convention with Dot Net.

http://www.tiobe.com/content/paperinfo/gemrcsharpcs.pdf[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

that would be OK. It is your choice. Or your company's.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

yes,it's true
but i want to find good way for naming controls

buttonAdd
buttonDelete
labelName
textBoxName
pictureBoxPerson

Hi Guys,
I have two Question.

1) How does the CLR recognize whether the assembly has been manipulated or not?

2) “The combination of hashing and digital signing allows .NET to protect your assemblies from tampering” –
Explain in steps how this is achieved in dot net.

do u have any ideas?

How can I use the VS2008 profiler to profile UI Thread ?

When I use it to profile my winform, It recorded only the function executed on the Main threadm and not the UI thread.

Thanks,
Berlus

I think I've found the problem, the function was inlined, so its name doesn't appear in the performance report.

Does anyone know how to measure such functions ?

Thanks,
Eyal

Hi everyone, I am having very hardtime manipulating the compact datagrid. I don't know how it is work, but it is not like windows datagridview at all. Can any one please help me how do I load data from a string array to the grid , row and columns wise.

thanks very much in advance.

This is not a C# question, it's more appropriate in and you've posted in the Mobile Development forum so wait for an answer in there.

Please look at the code below :

private void button1_Click(object sender, EventArgs e)
        {
            for (int j = 0; j < 3; j++)
            {
                i = j;
                myCurThread = new Thread(new ThreadStart(myThread));
                myCurThread.Start();
                myCurThread.Join();
            }
        }

private void myThread()
        {
            string result = "";
            myComport = new ComPort();
            
            myComport.Device = "COM5";
            myComport.BaudRate = 115200;
            myComport.HardwareFlowControl = myComport.asFLOWCONTROL_ENABLE;
            myComport.DataBits = (short)myComport.asDATABITS_DEFAULT;
            myComport.StopBits = (short)myComport.asSTOPBITS_DEFAULT;
            myComport.Parity = (short)myComport.asPARITY_DEFAULT;

            myComport.ComTimeout = 8000;
            myComport.Open();

            string strUSSD = "AT+CUSD=1,\"" + "*444#" + "\",15";

            myComport.WriteString(strUSSD);

            if (myComport.LastError == 0)
            {
                result = myComport.ReadString();
                while(result.IndexOf("Result") == -1)
                {
                    result = myComport.ReadString();
                    Debug.WriteLine("i = " + i + " " + result);
                }
            }

            myComport.Close();
        }

Problem is, Thread.Join make the button "halt". This is understandable since Thread.Join will make main thread wait until the other thread is finish.

How to make so the button will not "halt" and the threads is run on order? (Thread 2 wait until thread 1 finish and so on).

Is there any alternative to Thread.Join?

The threads were useless this way..
eidt: nvm, I see what you want now. Why not just make 1 thread?

Thank you harold for the suggestion.

Why not 1 Thread? it's because i need to simulate 3 or more request to thread at almost the same time.
I need the thread to run in order (2nd thread wait until 1st thread finis and so on).

If you need the threads to run in order, then they are not 'at the same time' but after eachother.
It only helps to make 3 threads then if you want to synchronize the start of thread 2 with the middle of thread 1, so there can be a bit of overlap. If no overlap is allowed you just get this:

none

[    1    ][    2    ][    3    ]

You might as well do this, it has the same length, but a different thread is doing the work:

none

[    1    ][    1    ][    1    ]

And that is, of course, the same as:

none

[               1               ]

Because a thread is already synchronized with itself.