先对数据库进行判断看看我的数据库里主键ID的最大值是多少

然后让我的主键自动往前加一,

不用数据库里ID自动增长功能.

现在就是当数据库为空里,主键怎么插入到数据库里去.

请问有没有什么办法呢解这个问题呢?

我是这样处理的.
代码如下:

SqlConnection cn=new SqlConnection("server=.;DataBase=LHBText;uid=sa");
cn.Open();
SqlCommand cmdMax=new SqlCommand("select Max(upLoadPhotoID) as upLoadPhotoID From upLoadPhoto",cn);
int upLoadPhotoID=Convert.ToInt32(cmdMax.ExecuteScalar());
if(upLoadPhotoID==0)
{
upLoadPhotoID=1;
}
else
{
upLoadPhotoID+=1;
}

//记录图片上传信息,放到数据表里去 '"+upLoadPhotoID+"',
SqlCommand cmdInsert=new SqlCommand("insert into upLoadPhoto values( " +

" '" + upLoadPhotoID + "', "+ //图片ＩＤ号
" '" + fileName + "', " + //上传图片文件名
" '" + DateTime.Now.ToString() + "', " + //上传的时间
" '" + this.lblUserName.Text + "')",cn); //哪位上传的

cmdInsert.ExecuteNonQuery();
cn.Close();

[此贴子已经被作者于2005-11-28 22:21:54编辑过]