Hello, not sure if this is a C# or a SQL posting. I will try here first.

I have a field in the db that is Text datatype. I am trying to insert a record in the following manner.

cmd.CommandText = "INSERT INTO ContributorsJournal "
+ "(ContributorID, CreatedDateTime, EntryDateTime, Entry ) "
+ "VALUES ( @ContributorID, @CreatedDateTime, @EntryDateTime, @Entry )"
+ "SELECT @@identity AS JournalID "
+ "SET NOCOUNT OFF ";

//Add parameters
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ContributorID ", System.Data.SqlDbType.Int, 4, "ContributorID"));
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CreatedDateTi me", System.Data.SqlDbType.DateTime, 8, "CreatedDateTime"));
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EntryDateTime ", System.Data.SqlDbType.DateTime, 8, "EntryDateTime"));
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Entry", System.Data.SqlDbType.Text, 16, "Entry"));

//Populate the paramters
cmd.Parameters["@ContributorID"].Value = this.cmContributorID;
cmd.Parameters["@CreatedDateTime"].Value = DateTime.Now;
cmd.Parameters["@EntryDateTime"].Value = DateTime.Now;
cmd.Parameters["@Entry"].Value = this._journalEntry.ToString();

The Entry value (string) always gets truncated.

Any ideas??

Keith

Does it always get truncated to 16 characters? The "Length" argument in the SqlParameter constructor is the length of the field. Is your "Entry" field only 16 characters?

Also, I noticed something in your query. I think you need a semi-colon inside the query between the end of the "INSERT..." and beginning of "SELECT @@IDENTITY...":
cmd.CommandText = "INSERT INTO ContributorsJournal "
+ "(ContributorID, CreatedDateTime, EntryDateTime, Entry ) "
+ "VALUES ( @ContributorID, @CreatedDateTime, @EntryDateTime, @Entry );"
+ "SELECT @@identity AS JournalID "
+ "SET NOCOUNT OFF ";


Peter
------------------------------------------------------
Work smarter, not harder.