using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace MonitorNetwork { public partial class AddWords : Form { public AddWords() { InitializeComponent(); } private void AddWords_Load(object sender, EventArgs e) { } private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=MonitorNetworkDB;Integrated Security=True"); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Insert Into WordsTable (Words) Values (@Words)"; // Fill our parameters cmd.Parameters.Add("@Words", SqlDbType.NVarChar, 50).Value = this.textBox1.Text; //cmd.Parameters.Add("@SourceMask", SqlDbType.NVarChar, 50).Value = this.txtIpMask.Text; //cmd.Parameters.Add("@SourcePort", SqlDbType.NVarChar, 50).Value = this.txtPort.Text; //cmd.Parameters.Add("@DestinatorIP", SqlDbType.NVarChar, 50).Value = this.txtIPAddress1.Text; //cmd.Parameters.Add("@DestinatorMask", SqlDbType.NVarChar).Value = this.txtIPMask1.Text; //cmd.Parameters.Add("@DestinatorPort", SqlDbType.NVarChar).Value = this.txtport1.Text; //cmd.Parameters.Add("@Protocol", SqlDbType.NVarChar).Value = this.comboBox1.Text; try { // Execute the command conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("New Word Added Successfully!"); textBox1.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void button2_Click(object sender, EventArgs e) { textBox1.Clear(); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)