Code with specific condition

Israel

Hi,

I would like to resolve a logic. Little bit complicated for my.

I have four Textboxes (TextBox1, TextBox2, TextBox3, TexBox4) and three Buttons (Button1, button2, Button3).

What I need to do?

If TextBox1 and TextBox2 or TextBox1 and TextBox3 are filled by number more than 0 or minus 0 then click at Button3 (for example do Button3.PerformClick()). Otherwise don't activate Button3 and read the code above to save to my Database.

private void Button1_Click(object sender, EventArgs e)
{
////////////////////////////////////////////////////////////////////
// The condition should be here. Its should pass ONLY these TextBoxes when are not filled
//////////////////////////////////////////////////////////////////
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm1 = new SqlCommand();
comm1.Connection = conn;
SqlParameter data = new SqlParameter("@date", SqlDbType.Date);
SqlParameter nord = new SqlParameter("@number", SqlDbType.VarChar);
SqlParameter contas = new SqlParameter("@name", SqlDbType.VarChar);
comm1.Parameters.Add(date);
comm1.Parameters.Add(number);
comm1.Parameters.Add(name);
date.Value = TextBox1.Text;
number.Value = TextBox2.Text;
name.Value = TextBox3.Text;
comm1.Connection = conn;
comm1.CommandText = "insert into Table ([date],[number],[name])values(@date,@number,@name)";
{
if (MessageBox.Show("Are you sure to save?", "Saving window", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
comm1.ExecuteNonQuery();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select [date],[number],[name] from Table";
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dgvTest.DataSource = dt;
}
finally
{
dgvTest.CurrentCell = dgvTest.Rows[dgvTest.Rows.Count - 2].Cells[0];
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Accepted answer
Add the below Numeric_KeyPress event to all textbox KeyPress event.
private void Numeric_KeyPress(object sender, KeyPressEventArgs e)
{
    if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) &&
                        (e.KeyChar != '.') && (e.KeyChar != '-'))
    {
        e.Handled = true;
    }

    // only allow one decimal point
    if ((e.KeyChar == '.') && ((sender as TextBox).Text.IndexOf('.') > -1))
    {
        e.Handled = true;
    }

    // only allow one negative
    if ((e.KeyChar == '-') && ((sender as TextBox).Text.IndexOf('-') > -1))
    {
        e.Handled = true;
    }
}
Then use this condition.
if ((decimal.Parse(textBox1.Text) != 0 && decimal.Parse(textBox2.Text) != 0) ||
    (decimal.Parse(textBox1.Text) != 0 && decimal.Parse(textBox3.Text) != 0))
{
    // Code to save data to database
}
+2
Israel7y ago
@Hold On
Your codes was a big help for others functions I was looking for. Thanx!

@Nilesh Sawardekar
You are very welcome. Thank you again for the codes.

@Amit Mohanty
On the last hour you do understand my idea. Many thank and learning is every days. I have been really suffocated to resolv it. Thank you again.
0
Jes Sie7y ago
Use if else if:
protected void Button3_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(TextBox1.Text) && !string.IsNullOrEmpty(TextBox2.Text))
            {
                //insert
            }
            else if(!string.IsNullOrEmpty(TextBox1.Text) && !string.IsNullOrEmpty(TextBox3.Text))
            {
                //insert
            }

else { Button3.Enabled = false; }

        }
0
Amit Mohanty7y ago
Hey Israel i think this your condition when textBox1 and textBox2 are filled and textBox3 and textBox4 are empty then data save to database or when textBox1 and textBox2 are empty and textBox3 and textBox4 are filled then data save to database.

Then your condition:
if ((decimal.Parse(textBox1.Text) != 0 && decimal.Parse(textBox2.Text) != 0 &&
    string.IsNullOrEmpty(textBox3.Text) && string.IsNullOrEmpty(textBox4.Text)) ||
    (decimal.Parse(textBox3.Text) != 0 && decimal.Parse(textBox4.Text) != 0 &&
    string.IsNullOrEmpty(textBox1.Text) && string.IsNullOrEmpty(textBox2.Text)))
{
    // Code to save data to database
}
0
Israel7y ago
@Nilesh Sawardekar
Thank you very much for your codes. I do learn some functions.

@ Amit Mohanty
It's amazing because you get directly in my understanding. It's perfectly what I was expecting. But there's something little bits confusing me.
Its making very well the selecting between "textBoxes" I need. But the problem is Its cannot save if one more (or another textbox(es)) is or are be filled by numbers (positive or negative).
For instance:
1) On my "Form1" there are "TextBox1", "TextBox2", "TextBox3", "TextBox4"
2) When I insert datas on "TextBox1" and "TextBox2" for example when I click on my Button its cant save if its find "TextBox3" or "TextBox4" filled.
3) Should accept to save ONLY when its sees the ONLY "TextBoxes" filled.
0
Nilesh Sawardekar7y ago
1. string Str1 = textBox1.Text.Trim();
2. double Num1;
3. bool isNum1 = double.TryParse(Str1, out Num1);
5. string Str2 = textBox2.Text.Trim();
6. double Num2;
7. bool isNum2 = double.TryParse(Str2, out Num2);
9. string Str3 = textBox3.Text.Trim();
10. double Num3;
11. bool isNum3 = double.TryParse(Str3, out Num3);
13. if ((isNum1 && isNum2) || (isNum1 && isNum3))
15. Button3.PerformClick();
17. else
19. //your sql stuff
This is sample code, use your lodgic.
Happy Coding... :)
0

Israel7y ago

It's not clear my question???

Israel7y ago

The problem here is just "conditions".

I will simplify my idea:

Point 1:

On my Form1:

- Four Textboxes (TextBox1, TextBox2, TextBox3, TexBox4)

-Three Buttons (Button1, button2, Button3)

Point 2:

- I have a simple button (Button1) where the codes where I put my conditions should be

- On another area into the same Form (Form1) I have others independante two Buttons (Button2 and Button3)

Point 3:

- I need to see these conditions be activated:

when I click on the Button1, before saving to my Database its should verify if these TextBoxes are filled with numbers more than "0" (1,2,3,4,...) or minus than "0" (-1,-2,-3,-4,...).

- If its filled with these numbers its must click the Button2 (where I will write anothers codes). If not then its can pass and save data on my Database.

- Which Textboxes should obey ONLY these conditions? TextBox1 and TextBox2 or TextBox1 and TextBox3 (Not TextBox4). That all.

Nilesh Sawardekar7y ago

Please explain properly what actually you are looking for

Code with specific condition

@Nilesh Sawardekar