C# Discussion Boards - CodeProject

Jassim Rahma16-Jun-10 22:36

16-Jun-10 22:36

i did but still the same with no error

and my select statement is SELECT * FROM system_parameters

Message Closed

16-Jun-10 22:39

stancrm

16-Jun-10 22:39

Message Closed

modified 23-Nov-14 6:23am.

Jassim Rahma16-Jun-10 22:43

16-Jun-10 22:43

what's the use of breakpoint if no error and no problem running the application? were do you want me to set the break point?

Łukasz Nowakowski16-Jun-10 22:52

Łukasz Nowakowski

16-Jun-10 22:52

The breakpoint that was mentioned by someone you should place at the begin of the while loop Smile | :)

As to the error without exception. In this line:
if (_system_parameters_hash.ContainsKey(sql_reader["system_param_name"])) return;

you return from method. Are you sure names aren't duplicated at least once... in 20th row returned from your command?
This is something you could discover by debugging your code Big Grin | :-D

Luc Pattyn17-Jun-10 1:59

17-Jun-10 1:59

start debugging: do NOT set a breakpoint, observe closely what happens, add code to improve visibility; add a try-catch and show Exception.ToString, add an else clause that counts how many entries contain unrecognized types, look at the actual data of the very first row that does not make it to the ArrayList, consider what happens when a DBNull occurs, start thinking and acting.

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.

Jassim Rahma17-Jun-10 4:06

17-Jun-10 4:06

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

Luc Pattyn17-Jun-10 4:14

17-Jun-10 4:14

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.

Jassim Rahma17-Jun-10 4:17

17-Jun-10 4:17

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?

Luc Pattyn17-Jun-10 4:21

Png Image Saving the original size doubles

17-Jun-10 4:21

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.

VCsamir16-Jun-10 21:39

VCsamir

16-Jun-10 21:39

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

Re: Png Image Saving the original size doubles

Luc Pattyn17-Jun-10 2:04

search in dataview without filtering

17-Jun-10 2:04

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.

sana_2616-Jun-10 21:13

sana_26

16-Jun-10 21:13

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?

Re: search in dataview without filtering

Bigdeak16-Jun-10 23:56

Bigdeak

16-Jun-10 23:56

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 | :)

how to get the methods registered with an eventhandler

prasadbuddhika16-Jun-10 20:06

prasadbuddhika

16-Jun-10 20:06

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

16-Jun-10 21:31

stancrm

16-Jun-10 21:31

Message Closed

modified 23-Nov-14 6:24am.

Re: how to get the methods registered with an eventhandler

prasadbuddhika17-Jun-10 19:21

prasadbuddhika

17-Jun-10 19:21

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 ?

Naming Controls

SajjadZare16-Jun-10 18:47

SajjadZare

16-Jun-10 18:47

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

Peace ON16-Jun-10 21:11

Peace ON

16-Jun-10 21:11

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....

Luc Pattyn17-Jun-10 2:06

17-Jun-10 2:06

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.

SajjadZare17-Jun-10 6:01

SajjadZare

17-Jun-10 6:01

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