qiuzhu

Question

string lianjie="Persist Security Info=false; user id=sa;password= ; database=pubs; "; 
        string sqlchaxun="select * from publishers";
        SqlConnection coon = new SqlConnection(lianjie);
        DataSet kongjian = new DataSet();
        SqlDataAdapter cmd = new SqlDataAdapter(sqlchaxun, coon);
        cmd.Fill(kongjian, "publishers");
        DataRow newrow = kongjian.Tables["publishers"].NewRow();
        newrow["pub_id"]="5544";
        newrow["pub_name"] = "tsing";
        newrow["city"] = "beijing";
        newrow["country"] = "CHN";
        kongjian.Tables["publishers"].Rows.Add(kongjian);
        SqlCommandBuilder cmdship = new SqlCommandBuilder(cmd);
        cmd.InsertCommand = cmdship.GetInsertCommand();
       cmd.Update(kongjian,"publishers") ;
        kongjian.Clear();
        cmd.Fill(kongjian, "publishers");------{将截断字符串或二进制数据。语句已终止。)这个地方咋解决
        DataGrid1.DataSource =kongjian ;
        DataGrid1.DataBind();

Answer 1

这里跟数据库的字段的长度设置有关系，应该是数据库中的字段长度设得太短了，传进来的值大于其长度，就会出现这种错误，检查一下字段的类型长度看看！