private void Button1_Click(object sender, EventArgs e)
{
int clientID = AddClient();
int success = 0;
try
{
using (SqlConnection con = new SqlConnection("Data Source=ECHOSQL\\ECHOSQL;Initial Catalog=ChrisTestDatabase;Integrated Security=True"))
{
using (SqlCommand cmd = new SqlCommand(@"INSERT INTO dbo.ClientName(ClientID,ClientName) VALUES(@id,@name)", con))
{
string clientName = txtLastName.Text + " ," + txtFirstName.Text + " " + clientID;
con.Open();
cmd.Parameters.AddWithValue("@id", clientID);
cmd.Parameters.AddWithValue("@name", clientName);
success = cmd.ExecuteNonQuery();
con.Close();
}
if (success != 0)
{
MessageBox.Show("Client Saved");
NewClient click = this;
click.Close();
}
else
{
MessageBox.Show("Upload Failed");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void LinkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
NewClient Click = new NewClient();
Click.Show();
}