publicDataSetGetProviderTypeDs(){using(SqlConnectioncon=newSqlConnection(this.conStr)){SqlCommandcmd=con.CreateCommand();cmd.CommandType=CommandType.Text;cmd.CommandText=@"select*fromProviderType";con.Open();SqlDataAdapterada=newSqlDataAdapter(cmd);ada.MissingSchemaAction=MissingSchemaAction.AddWithKey;DataSetds=newDataSet();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;returnds;}}