String or binary data would be truncated.
The statement has been terminated.
string insert = "Insert into RentInformation (UserName,EmailId,Password,ConfirmPassword,Purpose,AdTitle,ADType,DescriptionofAd,RoomType,PropertyType,Mobileno,Address,Image) values ('"+TextBox12.Text+"','"+TextBox2.Text+"','"+TextBox3.Text+"','"+TextBox4.Text+"','"+DropDownList1.SelectedItem+"','"+TextBox18.Text+"','"+DropDownList4.SelectedItem+"','"+TextBox23.Text+"','"+DropDownList5.SelectedItem+"','"+DropDownList6.SelectedItem+"','"+TextBox19.Text+"','"+TextBox20.Text+"','"+Image1.ImageUrl+"') select Purpose from Base where Purpose ='"+DropDownList1.SelectedItem+"' ";
Line 118: cmd = new SqlCommand(insert,con);
Line 119: cmd.ExecuteNonQuery();<big> this line generate Exception</big>
Line 120: con.Close();
Line 121: Response.Write("<script>alert('insert in RentInformation')</script>");