转换 varchar 值 '20061224162330k' 时溢出了整数列错误
我根本就没有把这一列去转成int为什么他自已去转换呢。
protected void Page_Load(object sender, EventArgs e)
{
//string bill_state = "新预订单";
if (!Page.IsPostBack)
{
SqlConnection con = Operate.createCon();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select bill.*,client.* from bill,client,diary where bill.bill_autoid=diary.bill_autoid and client.client_autoid=diary.autoid ", con);//这些字段都是自动编号的
DataSet ds = new DataSet();
sda.Fill(ds, "perw");
this.DataGrid1.DataSource = ds.Tables["perw"];
this.DataGrid1.DataBind(); }
我根本就没有把这一列去转成int为什么他自已去转换呢。
protected void Page_Load(object sender, EventArgs e)
{
//string bill_state = "新预订单";
if (!Page.IsPostBack)
{
SqlConnection con = Operate.createCon();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select bill.*,client.* from bill,client,diary where bill.bill_autoid=diary.bill_autoid and client.client_autoid=diary.autoid ", con);//这些字段都是自动编号的
DataSet ds = new DataSet();
sda.Fill(ds, "perw");
this.DataGrid1.DataSource = ds.Tables["perw"];
this.DataGrid1.DataBind(); }
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货