c# - Invalid object name, SQL Exception. Nothing fixes it! -

Therefore, I am trying to fix it for about two months. It all started when my "Dev" machine was cut off and I set it on my laptop. It was joking on my old PC but, it does not work on my new PC and was never on the laptop.

I had already structured SQL Server as much as I had missed before, but it started giving me SQLExceptions I googled it, I searched for here, I tried various solutions None of that

I'll post the offensive code and I hope someone will be able to help me see my weaknesses. I'm sure this is something stupid.

  SqlCommand sc = sqlc.CreateCommand (); Sc.CommandText = "Select pNumber from database where pNumber = '" + number. Toastring () + "'"; SqlDataReader sdr = sc.ExecuteReader (); If (sdr.Read (). ToString ()! = Null) {sdr.Close (); Sc.CommandText = "Update word SET word = '" + Word + "' WHERE pNumber = '" + Number.ToString () + "'"; Here are the error orders where ---- & gt; Sc.ExecuteReader (); } Other {sdr.Close (); Sc.CommandText = "Insert into database values ​​(" + Number.ToString (+) + ", '' + + '', 0, 0, 0)"; Sc.ExecuteNonQuery (); Sc.CommandText = "Select * from database where pNumber = '" + number. Toastring () + "'"; SqlDataReaderDatareD = sc.ExecuteReader (); For (int x = 0; x & lt; 6; ++ x) {user [x] = dataRead.GetString (x); }} Sqlc.Close ();  

Edit: SqlException: Invalid object name: 'word' on System.Data.SqlClient.SqlConnection.OnError (...

  sc.CommandText = "update word SET word = '+ + Word'" WHERE pNumber = '"+ number.ToString () +"' ";  

should probably read

  sc.CommandText =" database default word = '"+ Word +"' WHERE pNumber = '"+ number Update toString () + "'";  

I in SQL query tablename, all this.