SqlConnection

  • Thread starter Thread starter nbohana
  • Start date Start date
N

nbohana

The following code does not work because I get a message "Login failed for
user (NULL) Not associated with a trusted SQL Server. I can't find how to
fix this problem, will sombody please help!!

private void saveBidToolStripMenuItem_Click(object sender, EventArgs
e)
{

SqlConnection conn = null;

try
{

// Insert Job Information in to the SQL Data Table

conn = new
SqlConnection("Server=icc-server;DataBase=construction");
SqlCommand cmd = new SqlCommand("InsertJobInformation", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@bidnumber_1", txBidnumber.Text));
cmd.Parameters.Add(new SqlParameter("@jobname_2", txJobname.Text));
cmd.Parameters.Add(new SqlParameter("@jobaddress_3", txJobaddress.Text));
cmd.Parameters.Add(new SqlParameter("@jobcity_4", txJobcity.Text));
cmd.Parameters.Add(new SqlParameter("@jobstate_5", cbJobstate.Text));
cmd.Parameters.Add(new SqlParameter("@jobzipcode_6", txJobzipcode.Text));
cmd.Parameters.Add(new SqlParameter("@notes_7", txNotes.Text));
cmd.Parameters.Add(new SqlParameter("@companycode_8",
txCompanycode.Text));

MessageBox.Show("Insert Complete. [Job-Information] " + conn +
" Successful.","");

if (conn.State != ConnectionState.Open)
{
conn.Open();
}
}

catch( SqlException ex)
{
MessageBox.Show(ex.Message, "SQL Error");
conn.Close();
Application.Exit();
}


}
 
Back
Top