string connStr1 = "server=localhost;uid=sa; pwd=sa; database=book";
SqlConnection myConnection1 = new SqlConnection(connStr1);
string borrowStr = "select count(*) from borrowinfo ";

SqlCommand myCommand1 = new SqlCommand(borrowStr, myConnection1);
myConnection1.Open();
myCommand1.ExecuteNonQuery();
myConnection1.Close();
borrowStr= borrowStr + 1;

try
{
string insertStr = "insert into borrowinfo values ('" + borrowStr + "', '" + Request["bookname"] + "',getdate(),getdate())";

SqlCommand myCommand2 = new SqlCommand(insertStr, myConnection1);

myConnection1.Open();
myCommand2.ExecuteNonQuery();
Label12.Text = "插入成功！";
}
catch
{
Label12.Text = "插入失败！";
}


为什么总是 插入失败啊 不能 这样用吗

SqlCommand myCommand1 = new SqlCommand(borrowStr, myConnection1);
myConnection1.Open();
borrowStr=myCommand1.ExecuteSclar();
myConnection1.Close();
borrowStr=borrowStr+1;

[此贴子已经被作者于2006-12-15 0:36:38编辑过]

不行啊   还是插入失败

try
{
string insertStr = "insert into [borrowinfo](指明插入的字段) values ('" + borrowStr + "', '" + Request["bookname"] + "',getdate(),getdate())";

SqlCommand myCommand2 = new SqlCommand(insertStr, myConnection1);

myConnection1.Open();
myCommand2.ExecuteNonQuery();
Label12.Text = "插入成功！";
}
catch
{
Label12.Text = "插入失败！";
}

string insertStr = "insert into [borrowinfo](borrowno,bookname,borrowdate,retudrnate) values ('" + borrowStr + "', '" + Request["bookname"] + "',getdate(),getdate())";

SqlCommand myCommand2 = new SqlCommand(insertStr, myConnection1);

myConnection1.Open();
myCommand2.ExecuteNonQuery();
Label12.Text = "插入成功！";
还是不行啊　　
在顺便问一下　　getdate()我想在系统日期的基础上+３０　天　　怎么表示

string insertStr = "insert into [borrowinfo]([borrowno],[bookname],[borrowdate],[retudrnate]) values ('" + borrowStr + "', '" + Request["bookname"] + "',getdate(),getdate())";
////////////////
int i=Convert.ToInt32(System.Date.Now.Day.ToString())+30;//你试一下，，，

错误 1 命名空间“System”中不存在类型或命名空间名称“Date”(是缺少程序集引用吗?) d:\My Documents\Visual Studio 2005\ibook\Webtushuguan\借书.aspx.cs 108 40 d:\...\Webtushuguan\

楼主，你的insert语句中的表和字段不用加“[]”

那麻烦你帮忙看下１楼的　　　为什么　是插入失败

我还是不知道　１楼的代码是那里的问题　
不过　我把　数据库的　主键字段　改成　自增型的了　　我的问题是解决了