Sql won't insert :S

Would the lack of commas sperating the values affect it lo , how do u do params?

EDIT:

chnaged line to this

VALUES ('" + txtLoanBookID.Text + "','" + txtLoanUserID.Text + "', '" + txtLoanTitle.Text + "', '" + dateOutTimePicker.Value.Date + "')";

but still no luck. its as if its adding it to memmory or something and waiting to be written to the table.

W3bbo wrote:


If you're using SQL Server, have you tried using the Profiler tool to see if the database is receiving the commands and how it's executing them?

Located here: "%programfiles%\Microsoft SQL Server\80\Tools\Binn\profiler.exe"

cmdString = "INSERT INTO dbo.book_loan (book_id, user_id, title, date_taken)VALUES (@loanBookIDParam, @loanUserIDParam, @loanTitleParam, @loanDateTakenParam)";

// Create a new connection to the database and also a new command.

SqlConnection dbConn = new SqlConnection(conn);

SqlCommand cmd = new SqlCommand(cmdString);

// Some parameters for sql query.

SqlParameter param1 = new SqlParameter("@loanBookIDParam", SqlDbType.Int);

param1.Direction = ParameterDirection.Input;

param1.Value = int.Parse(txtLoanBookID.Text.ToString());

SqlParameter param2 = new SqlParameter("@loanUserIDParam", SqlDbType.Int);

param2.Direction = ParameterDirection.Input;

param2.Value = int.Parse(txtLoanUserID.Text.ToString());

SqlParameter param3 = new SqlParameter("@loanTitleParam", SqlDbType.NVarChar, 150);

param3.Direction = ParameterDirection.Input;

param3.Value = txtLoanTitle.Text;

SqlParameter param4 = new SqlParameter("@loanDateTakenParam", SqlDbType.SmallDateTime);

param4.Direction = ParameterDirection.Input;

param4.Value = dateOutTimePicker.Value.Date;

// Put params into an array.

SqlParameter[] cmdParams = { param1, param2, param3, param4 };

// Add aparemeters to command.

cmd.Parameters.AddRange(cmdParams);

But yet again it still doenst seem to add any thing to the data base. very strange.

PerfectPhase wrote:

 Is this a winforms project?  Where is the database?  What's your connection string?

I've seen people have the db in their project dir, which gets copied into the build directory and the insert is done in the copy and when you stop and restart the changes are lost.  They to spent ages looking for a reason why records do not insert

Ok ive quickly knocked this up for ya.

http://http://www.geocities.com/scottbryen/QueryProject.zip