SQL Server Strings Padded with Whitespace on Insert - why?

Question

when i tried to insert some data into the SQL Server there was these extra characters

for example my textBox1.text == "SAMPLE"
then this was the code

string qry = "insert into FinalImages (FinalImageName, Date) values(@FinalImageName, @Date)";

SqlConnection c = new SqlConnection(c_string);
//Initialize SqlCommand object for insert
SqlCommand SqlCom = new SqlCommand(qry, c);

SqlCom.Parameters.Add(new SqlParameter("@FinalImageName", SqlDbType.Char, 40)).Value = textBox1.Text;
SqlCom.Parameters.Add(new SqlParameter("@Date", SqlDbType.Char, 40)).Value = DateTime.Now.ToString("MM/dd/yyyy");

but when i check in the tables the record was this "SAMPLE ", it has 34 space characters added
what should be wrong?

Answer 1

Don't use SqlDbType.Char, use NVarChar. Char is a fixed-size string, padded with spaces (a terrible monster).