No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[code] using (SqlConnection connection = new SqlConnection(DataHelper.ConnectionString)) { using (SqlDataAdapter Adapter = new SqlDataAdapter()) { try { Adapter.InsertCommand.Connection.Open(); Adapter.InsertCommand = new SqlCommand("Sample", connection); Adapter.InsertCommand.CommandType = CommandType.StoredProcedure; Adapter.InsertCommand.Parameters.AddWithValue("@reqno", "emid"); Adapter.InsertCommand.Parameters.AddWithValue("@vouno", "emname"); Adapter.InsertCommand.ExecuteNonQuery(); } catch (Exception aa) { MessageBox.Show("x " + aa); } [B] Adapter.InsertCommand.Connection.Close();[/B] // It Shows error in here } …
|