spacebar problem for insertion

[roshid]

hai, i am using two textboxes for entering countrycode,country name, entering some datas,i checked the existancy in database,In button click existancy checking is ok but one problem is we use the spacebar first then inserting the duplicate data(using c#,asp.net) for Ex: suppose we insert the data india,ind12 using textboxes after that we connot this insertion here spacebar using infront of the insertion india, ind12 again inserting the duplicate data? how can we avoide this? help me

[SachinKumar M]

Trim those Textbox Values Ex: TextBox1.Text.Trim while inserting those values and Checking for Duplicate Data.

[roshid]

objCity.pvar_City_Name = this.txtCityName.Text.Trim().ToUpper(); objCity.pvar_City_Code = this.txtCityCode.Text.Trim().ToUpper(); i used this code, i cannot get again insert duplicate data