Code with specific condition

Question

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]; }

Amit Mohanty · 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 }

Israel · Answer

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

Jes Sie · Answer

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

Amit Mohanty · Answer

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 }

Israel · Answer

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

Nilesh Sawardekar · Answer

string Str1 = textBox1.Text.Trim(); double Num1; bool isNum1 = double .TryParse(Str1, out Num1); string Str2 = textBox2.Text.Trim(); double Num2; bool isNum2 = double .TryParse(Str2, out Num2); string Str3 = textBox3.Text.Trim(); double Num3; bool isNum3 = double .TryParse(Str3, out Num3); if ((isNum1 && isNum2) || (isNum1 && isNum3)) Button3.PerformClick(); else //your sql stuff This is sample code, use your lodgic. Happy Coding... :)

Israel · Answer

It's not clear my question???

Israel · Answer

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 Sawardekar · Answer

Please explain properly what actually you are looking for