C#

<br />
using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.Odbc;<br />
<br />
namespace forumArt<br />
{<br />
    public partial class addNewCampaign : Form<br />
    {<br />
        public addNewCampaign()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void addNewCampaign_Load(object sender, EventArgs e)<br />
        {<br />
            // TODO: This line of code loads data into the 'dataSet1.customers' table. You can move, or remove it, as needed.<br />
            this.customersTableAdapter.Fill(this.dataSet1.customers);<br />
            // TODO: This line of code loads data into the 'dataSet1.signsDetails' table. You can move, or remove it, as needed.<br />
            this.signsDetailsTableAdapter.Fill(this.dataSet1.signsDetails);<br />
<br />
        }<br />
<br />
        private void button2_Click(object sender, EventArgs e)<br />
        {<br />
            Close();<br />
        }<br />
<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {<br />
            if (signNumber.Text == "")<br />
            {<br />
                MessageBox.Show("חובה לבחור את מספר השלט");<br />
            }<br />
            if (companyName.Text == "")<br />
            {<br />
                MessageBox.Show("נא לבחור את שם החברה המזמינה");<br />
            }<br />
            else<br />
            {<br />
                try<br />
                {<br />
                    OdbcConnection conn = new OdbcConnection("dsn=forumArtDataBase");<br />
                    OdbcCommand cmd = new OdbcCommand("insert into orders(signNumber,fromDate,toDate,companyName,comments) values ('" + signNumber.Text + "','" + fromDate.Text + "','" + toDate.Text + "','" + companyName.Text + "','" + comments.Text + "')", conn);<br />
                    conn.Open();<br />
                    cmd.ExecuteNonQuery();<br />
                    conn.Close();<br />
                    MessageBox.Show("ההזמנה התווספה בהצלחה");<br />
                    Close();<br />
                }<br />
                catch (OdbcException ex)<br />
                {<br />
<br />
                    MessageBox.Show("התבצעה שגיאה בעת ניסיון ההתחברות למסד הנתונים" + ex);<br />
                }<br />
            }<br />
        }<br />
    }<br />
}<br />