DataTable设置自增标识列的异常
public DataSet GetProviderTypeDs() { using (SqlConnection con = new SqlConnection(this.conStr)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = @"select * from ProviderType"; con.Open(); SqlDataAdapter ada = new SqlDataAdapter(cmd); ada.MissingSchemaAction = MissingSchemaAction.AddWithKey; DataSet ds = new DataSet(); ada.Fill(ds,"ProviderType"); //先设置seed再设置step导致seed设置失败,seed被设置为Table的标识列ID最大值 //ds.Tables[0].Columns[0].AutoIncrementSeed = -1; //ds.Tables[0].Columns[0].AutoIncrementStep = -1; ds.Tables[0].Columns[0].AutoIncrementStep = -1; ds.Tables[0].Columns[0].AutoIncrementSeed = -1; ds.Tables[0].Columns[0].ReadOnly = false; return ds; } }
分享标题:DataTable设置自增标识列的异常
当前网址:http://ybzwz.com/article/pojice.html