mehrshadms
جمعه 11 اسفند 1391, 00:30 صبح
سلام می خوام یه سری اطلاعات وارد دیتابیس کنم ولی این اررور رو میده قبلاً هم به این روش کار کردم
String or binary data would be truncated.
The statement has been terminated.
کدی هم که استفاده می کنم اینه
SqlConnection con1 = new SqlConnection();
con1.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
con1.Open();
SqlCommand c1 = new SqlCommand();
c1.Connection = con1;
c1.CommandText = "insert into Amlak(Ostan , Shahr , Mantaghe , NoeMelk , NoeMoamele , NoeSanad , NameMalek , Email , Address , ShomareTamas , MoshakhasateMelk , Shomare)values('" + AmlakAdmin.Ostan + "' , '" + AmlakAdmin.Shahr + "' , '" + AmlakAdmin.Mantaghe + "' , '" + AmlakAdmin.NoeMelk + "' ,'" + AmlakAdmin.NoeMoamele + "' , '" + AmlakAdmin.NoeSanad + "' , '" + AmlakAdmin.NameMalek + "' , '" + AmlakAdmin.Email + "' , '" + AmlakAdmin.Address + "' , '" + AmlakAdmin.ShomareTamas + "' , '" + AmlakAdmin.MoshakhasateMelk + "' , '" + AmlakAdmin.Shomare + "' )";
c1.ExecuteNonQuery();
String or binary data would be truncated.
The statement has been terminated.
کدی هم که استفاده می کنم اینه
SqlConnection con1 = new SqlConnection();
con1.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
con1.Open();
SqlCommand c1 = new SqlCommand();
c1.Connection = con1;
c1.CommandText = "insert into Amlak(Ostan , Shahr , Mantaghe , NoeMelk , NoeMoamele , NoeSanad , NameMalek , Email , Address , ShomareTamas , MoshakhasateMelk , Shomare)values('" + AmlakAdmin.Ostan + "' , '" + AmlakAdmin.Shahr + "' , '" + AmlakAdmin.Mantaghe + "' , '" + AmlakAdmin.NoeMelk + "' ,'" + AmlakAdmin.NoeMoamele + "' , '" + AmlakAdmin.NoeSanad + "' , '" + AmlakAdmin.NameMalek + "' , '" + AmlakAdmin.Email + "' , '" + AmlakAdmin.Address + "' , '" + AmlakAdmin.ShomareTamas + "' , '" + AmlakAdmin.MoshakhasateMelk + "' , '" + AmlakAdmin.Shomare + "' )";
c1.ExecuteNonQuery();