Re: Get Active mdichild form - C# Discussion Boards

Re: Help need regarding SendMessageTimeout for IE window

vishal nerkar26-Feb-12 3:11

vishal nerkar

26-Feb-12 3:11

Thanks for the reply. Still trying to figure it out.

help me: when installing the management software, often times it built the database into it, so how do I do that? thank you!

ajax_vn25-Feb-12 5:56

ajax_vn

25-Feb-12 5:56

Re: help me: when installing the management software, often times it built the database into it, so how do I do that? thank you!

Dave Kreskowiak25-Feb-12 6:21

Dave Kreskowiak

25-Feb-12 6:21

First, the subject line of a post should be short. The body of the post should contain the question, not the other way around.

SQL servers are designed to be managed using SQL query language, including the construction of databases, tables, column definitions, security as so forth.

You build an SQL script that builds the database and when your app is installed, you include custom actions that ask for the server to attach to, the credentials to use, and then you connect to the server and execute the script, just like it would be if you were querying a database instead.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: help me: when installing the management software, often times it built the database into it, so how do I do that? thank you!

Abhinav S25-Feb-12 17:16

Abhinav S

25-Feb-12 17:16

During install, check if the database already exists.
If it does, don't create it.

Get Active mdichild form

Mr.Kode25-Feb-12 2:11

Mr.Kode

25-Feb-12 2:11

how to loop through Application openforms
and get specified form which is active
with note that may be more than one form with the same name is running

Form ActvFrm = this.ActiveMdiChild;
string cptn = ActvFrm.Name;
FrmNewPatiant FNew = (FrmNewPatiant)Application.OpenForms["FrmNewPatiant"];

foreach (Form FrmNew in Application.OpenForms)
{
if (FrmNew.Text == cptn)
{
FrmNewPatiant actvNewPat = (FrmNewPatiant)Application.OpenForms[cptn];
actvNewPat.tabNewFile.TabPages[2].Enabled = true;
actvNewPat.tabNewFile.SelectedTab = FNew.tabNewFile.TabPages[2];
}
}

Re: Get Active mdichild form

Alisaunder25-Feb-12 2:49

Alisaunder

25-Feb-12 2:49

What I used to do was store a value typically the id of the record or individual. I stored this value as the tag value of the child form created. In this way you can make certain not to replicate already created or open form by comparing this value to be created with the values stored in all of the currently open and active forms.

I now use Tabs instead of MDI in most of my applications though which is why I said used.

modified 26-Feb-12 19:14pm.

Re: Get Active mdichild form

Mr.Kode25-Feb-12 22:36

Mr.Kode

25-Feb-12 22:36

can you give me example on how to use tags for each mdi child?

Re: Get Active mdichild form

Alisaunder26-Feb-12 13:13

Alisaunder

26-Feb-12 13:13

This is how I did it when using MDI.

I used a Tree View control populated with A-Z subnodes would be names organized last to first with a comma and middle initial, and I would store the id of the record containing the information in the tag element of the Tree View like so.

private void updateTreeview()
        {
            //add letters sort nodes
            for (int i = System.Convert.ToInt32('A'); i <= System.Convert.ToInt32('Z'); i++)
            {
                treeView1.Nodes.Add(Convert.ToString((char)(i)), Convert.ToString((char)(i))); //set key and text
            }

            //add customers
            TreeNode childnode = null;
            string sContactsName = null;
            foreach (DataRow rowContacts in dtContacts.Rows)
            {
                sContactsName = string.Concat(rowContacts["LastName"].ToString(), ", ", rowContacts["FirstName"].ToString());

                if (!(System.Convert.IsDBNull(rowContacts["MiddleInitial"].ToString())))
                {
                    sContactsName = string.Concat(sContactsName, " ", rowContacts["MiddleInitial"].ToString(), ".");
                }
                //---------------------Key lines here --------------
                childnode = new TreeNode(sContactsName, 0, 1);
                childnode.Name = sContactsName; //set text as key
                childnode.Tag = rowContacts["ContactID"].ToString();
                //--------------------------------------------------

                string sortnode = sContactsName.Substring(0, 1).ToUpper(); //gets alphabet sort node by first letter
                treeView1.Nodes[sortnode].Nodes.Add(childnode);
            }

            //Update TreeView
            treeView1.Visible = true;
            treeView1.Enabled = true;
            treeView1.ExpandAll();
        }

After the node containing the name was clicked I handled it like this:

private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
    string nodeName = e.Node.Name;

    if (nodeName.Length == 1)
    {
        return; //is alphabet sort node, exit
    }

    //see if child form already exists and show it
    foreach (Form f in this.MdiChildren)
    {
        if (f.Name == nodeName)
        {
            f.Activate();
            return;
        }
    }


    string id = e.Node.Tag.ToString();

    displayContact(nodeName, id);
}

This checked the form by id to see if it was already displayed and only created a new form if it was not displayed.

to filter datagridview records having column having null value

polachan24-Feb-12 9:06

polachan

24-Feb-12 9:06

It would be very appreciate if anybody can help me.

Is it possible to pass filter condition in datagrdview.parameter to filter all the records having null value on that column

if (comboBoxOperator.Text == "xxx..") ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " LIKE '" + FilterValue + "%'";

How I can pass FilterValue as null condition .

With Many thanks
Pol

Re: to filter datagridview records having column having null value

Eddy Vluggen24-Feb-12 9:42

Eddy Vluggen

24-Feb-12 9:42

if (comboBoxOperator.Text == "xxx..") ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " IS NULL";

?

--edit;
Don't bump[^] your question.

Bastard Programmer from Hell Suspicious | :suss:

modified 24-Feb-12 19:32pm.

Re: to filter datagridview records having column having null value

polachan28-Feb-12 23:42

polachan

28-Feb-12 23:42

Many Many Thanks

Re: to filter datagridview records having column having null value

Eddy Vluggen29-Feb-12 0:26

Eddy Vluggen

29-Feb-12 0:26

You're welcome Smile | :)

data akses to mySql using c#

tian's emo24-Feb-12 2:52

tian's emo

24-Feb-12 2:52

every body.. please help me about my problem..
i need exemple of code using c#..
how to access mySql if you made class model, class dao,,and class view.
in class model : you can make "setter getter" of your komponent,,
in class dao: you can make connection and accessing database.. "save,sellect,update,delete".
in class view : you can make some form to access mySql..
please help me..

Re: data akses to mySql using c#

R. Giskard Reventlov24-Feb-12 5:32

R. Giskard Reventlov

24-Feb-12 5:32

Sounds like homework to me: go speak to your teacher.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: data akses to mySql using c#

tian's emo25-Feb-12 1:28

tian's emo

25-Feb-12 1:28

i'm sory sir.. i'm a student in high school.. so i'm just new in code to know.. jajajaajjajaajajaja.
sooo please help me sirrr

Re: data akses to mySql using c#

kid sister24-Feb-12 18:22

kid sister

24-Feb-12 18:22

Please learn how to Google. Check this Some guidelines for posting questions in the forums[^]

Join my school[^] for basic lessons.

xoxo

Kid sister Rose | [Rose]

Compress with java decompress with c#

Hossein Khalaj24-Feb-12 2:46

Hossein Khalaj

24-Feb-12 2:46

I want compress a string with Java(in Android) and decompress with c#...

I did test many algorithm.. but i cant solved my problem.

What can i do?

Re: Compress with java decompress with c#

Eddy Vluggen24-Feb-12 8:42

Eddy Vluggen

24-Feb-12 8:42

Doesn't Java support Zip[^]? .NET supports it as well. Tried it?

--edit;
Don't crosspost[^], pick a forum and stick to it.

Bastard Programmer from Hell Suspicious | :suss:

modified 24-Feb-12 19:27pm.

Re: Compress with java decompress with c#

Bernhard Hiller26-Feb-12 20:32

Bernhard Hiller

26-Feb-12 20:32

The important thing is to select an algorithm which is normally supported on Windows computers, like the "normal" zip suggested above. Do not use bzip, gzip and so on. After compressing with Java, save it to a file (with the extension .zip), and try to open that file with Windows explorer: when that works, the first step is succesfully completed. Then find out how to unzip it with C#.

Reading Null values in a byte array

si_6924-Feb-12 1:24

si_69

24-Feb-12 1:24

Hi All

I am trying to loop through a byte array (sample below) reading the values to then insert those into a database

I loop through keeping track of the position

byte[] data;
   long position=0;
   while (position < data.Length)
   {
       position = Conversion.Extract(data, out mydata, position);
       position = Conversion.Extract(data, out nextitem, position);
   }

   public static long Extract(byte[] message, out int variable, long position)
   {
       const int length = 4; // the length of an int

       if (message.Length >= position + length)
       {
           variable = BitConverter.ToInt32(message, (int)position);
           return position + length;
       }

       // there was a problem
       variable = 0;
       return -1;
   }

The data i have contains some null values, how can i extract these and successfully move onto the next value. At present if i come across a null value i dont know how to detect this and move onto the next item. Can anyone help at all

Thanks

Simon

6F 72 67 61 6E 69 73 61 74 69 6F 6E 49 64 3D 33
26 10 00 00 00 50 65 6F 70 6C 65 50 65 6F 70 6C
65 4C 69 6E 6B 6A 08 00 00 09 00 00 00 0E 00 00
00 53 65 6E 69 6F 72 50 65 72 73 6F 6E 49 64 0E
00 00 00 4A 75 6E 69 6F 72 50 65 72 73 6F 6E 49
64 11 00 00 00 53 65 6E 69 6F 72 50 65 72 73 6F
6E 4D 69 73 49 64 11 00 00 00 4A 75 6E 69 6F 72
50 65 72 73 6F 6E 4D 69 73 49 64 08 00 00 00 4C
69 6E 6B 54 79 70 65 16 00 00 00 50 61 72 65 6E
74 61 6C 52 65 73 70 6F 6E 73 69 62 69 6C 69 74
79 08 00 00 00 50 72 69 6F 72 69 74 79 0B 00 00
00 4C 61 73 74 55 70 64 61 74 65 64 07 00 00 00
44 65 6C 65 74 65 64 01 00 00 00 D7 0A 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 01 80 C3 29
C6 85 BF CE 08 00 02 00 00 00 3C 0C 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 F0 83 76 C6
85 BF CE 08 00 03 00 00 00 3C 0C 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 C0 0E 76 C6 85
BF CE 08 00 04 00 00 00 67 0B 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 01 70 CA 4B C6 85 BF
CE 08 00 05 00 00 00 67 0B 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 02 70 CA 4B C6 85 BF CE
08 00 06 00 00 00 9B 08 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 02 C0 BE B2 C5 85 BF CE 08
00 06 00 00 00 AD 09 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 02 10 6D F5 C5 85 BF CE 08 00
06 00 00 00 3F 0A 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 02 80 59 11 C6 85 BF CE 08 00 07
00 00 00 E3 0A 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 01 C0 D0 2C C6 85 BF CE 08 00 08 00
00 00 9B 08 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 01 C0 BE B2 C5 85 BF CE 08 00 08 00 00
00 AD 09 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 01 10 6D F5 C5 85 BF CE 08 00 08 00 00 00
C9 09 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 01 20 76 FA C5 85 BF CE 08 00 08 00 00 00 3F
0A 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
01 B0 CE 11 C6 85 BF CE 08 00 09 00 00 00 E3 0A
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01
90 5B 2C C6 85 BF CE 08 00 0A 00 00 00 C9 09 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 02 20
76 FA C5 85 BF CE 08 00 0B 00 00 00 F6 08 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 01 E0 C9
D2 C5 85 BF CE 08 00 0C 00 00 00 F6 08 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 02 F0 2C C9
C5 85 BF CE 08 00 0E 00 00 00 91 09 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 01 C0 C7 EF C5
85 BF CE 08 00 0F 00 00 00 91 09 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 02 90 52 EF C5 85

SQL

SeniorPersonId | JuniorPersonId | SeniorPersonMisId | JuniorPersonMisId | LinkType | ParentalResponsibility | Priority | LastUpdated              Deleted
1              | 2775           | {null}            | {null}            | {null}   | 0                      | 1        | 2012-02-22 14:31:18.200 | {null}
2              | 3132           | {null}            | {null}            | {null}   | 0                      | {null}   | 2012-02-22 14:31:18.703 | {null}
3              | 3132           | {null}            | {null}            | {null}   | 0                      | {null}   | 2012-02-22 14:31:18.700 | {null}
4              | 2919           | {null}            | {null}            | {null}   | 0                      | 1        | 2012-02-22 14:31:18.423 | {null}

modified 24-Feb-12 7:54am.

Re: Reading Null values in a byte array

Dave Kreskowiak24-Feb-12 4:07

Dave Kreskowiak

24-Feb-12 4:07

I may be misunderstanding this, but wouldn't you just check it see if variable is 0 and get the next Int32 if it was??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Reading Null values in a byte array

Matt Meyer24-Feb-12 5:21

Matt Meyer

24-Feb-12 5:21

When thinking in terms of bytes (or any integral types), null and 0 are the same. In your example, when this line

variable = BitConverter.ToInt32(message, (int)position);

returns a zero, that would correspond to a null value.

How to filter record when combobox value is null

polachan24-Feb-12 0:56

polachan

24-Feb-12 0:56

The record in datagridview is filtered on the basis of the value selected from combobox . How I can filter the record from datagridview when the combo box selected value is null.
example : combox contain ProductGrade. So the value exists in combobox is 'A','B' and may come null value.But When I select just null value, the record is not filtering. Pls help how to filter record having null value ProductGrade

Here is the code

protected override void OnFilterExpressionBuilding(object sender, CancelEventArgs e){
base.OnFilterExpressionBuilding(sender, e);
if (e.Cancel) {
FilterManager.RebuildFilter();
return;
}

string ResultFilterExpression = "";
string ResultFilterCaption = OriginalDataGridViewColumnHeaderText ;
// object FilterValue = comboBoxValue.SelectedValue;
object FilterValue = comboBoxValue.Text;
FilterValue = StringEscape(FilterValue.ToString());
//StringEscape(FilterValue);
// Managing the NULL and NOT NULL cases which are type-independent
if (comboBoxOperator.Text == "xxx..") ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " LIKE '" + FilterValue + "%'";
if (comboBoxOperator.Text == "= Ø") ResultFilterExpression = GetNullCondition(this.DataGridViewColumn.DataPropertyName);
if (comboBoxOperator.Text == "<> Ø") ResultFilterExpression = GetNotNullCondition(this.DataGridViewColumn.DataPropertyName);

Pls Help

if (ResultFilterExpression != "") {
FilterExpression = ResultFilterExpression;
FilterCaption = ResultFilterCaption + "\n " + comboBoxOperator.Text;
FilterManager.RebuildFilter();
return;
}

string FormattedValue = "";

if (ColumnDataType == typeof(string)) {
// Managing the string-column case
string EscapedFilterValue = StringEscape(FilterValue.ToString());
ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " " + comboBoxOperator.Text + "'" + EscapedFilterValue + "'";
ResultFilterCaption += "\n" + comboBoxOperator.Text + " " + comboBoxValue.Text;
}
else {
// Managing the other cases
FormattedValue = FormatValue(FilterValue, this.ColumnDataType);
if (FormattedValue != "") {
ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " " + comboBoxOperator.Text + FormattedValue ;
ResultFilterCaption += "\n" + comboBoxOperator.Text + " " + comboBoxValue.Text ;
}

}
if (ResultFilterExpression != "") {
FilterExpression = ResultFilterExpression;
FilterCaption = ResultFilterCaption;
FilterManager.RebuildFilter();
}
}

Re: How to filter record when combobox value is null

Bernhard Hiller26-Feb-12 20:39

Bernhard Hiller

26-Feb-12 20:39

You should return to your previous approach: remove the escaping of

// object FilterValue = comboBoxValue.SelectedValue;

Actually, you could use your class here, e.g.

MyClass filterValue = comboBoxValue.SelectedValue as MyClass;

And do not forget to test for NULL:

if (comboBoxValue.SelectedValue == null)
{
    //TODO: clear results
    return;
}

accessing the value of control between seperate Forms

Fred 3424-Feb-12 0:10

Fred 34

24-Feb-12 0:10

sorry, this is the second time that i ask this
questio but i didn't get an explicit answer. anyway

If we have 2 form (Form1 & Form2) whitin a project
and we added a public object (for example textBox1)
to Form1, how can we access to value of textBox1.text
from Form2.i have done this in form2 by these codes
{
Form1 fr = new Form1();
.
.
.
}

but fr.textBox1.text doesn't show the actual value.
it just show the prdefined value of it.
please explicitly tell me how can i solve this.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.