public void AddAuto(string AutoName) { SqlCommand myCommand; string SQLInsertNewAuto = "INSERT INTO Auto ([AutoName]) VALUES ('{0}')"; string insertbill = string.Format(SQLInsertNewAuto, AutoName); myCommand = new SqlCommand(insertbill, myConnection); myConnection.Open(); myCommand.ExecuteNonQuery(); }
public void AddGas(string AutoNumber, string Miles, string Price, string Gallons) { SqlCommand myCommand; if (Price.Length.Equals(0)) Price = "0.0"; string SQLInsertNewGas = "INSERT INTO Gas ([AutoNumber],[Miles],[Price],[Gallons]) VALUES ('{0}','{1}',{2},{3})"; string insertbill = string.Format(SQLInsertNewGas, AutoNumber,Miles,Price,Gallons); myCommand = new SqlCommand(insertbill, myConnection); myConnection.Open(); myCommand.ExecuteNonQuery(); }