在线等待,为什么只能接收最多77条记录? 表有由三个字段构成: 名称 类型AutoID 自动编号IPAddress 文本(15)DateTime 文本(19) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 试试这种方法: void Page_Load(object sender,EventArgs e) {string UserHostAddress = Request.UserHostAddress.ToString(); ipaddress.Text = UserHostAddress; string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string strConnection; strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += "Data Source=D:\FlowMisWeb\WebApp\company\database.mdb"; OleDbConnection MyConnection = new OleDbConnection(strConnection); string strSQLInsert = "insert into GuestInfo(IPAddress,[DateTime]) values('" + UserHostAddress + "','" + dt + "')"; string strSQLSelect = "select count(*) as num from GuestInfo"; OleDbCommand myCommand; mycommand = new OleDbCommand(strSQLInsert, MyConnection); MyConnection.Open(); MyCommand.ExecuteNonQuery(); myCommand = new OleDbCommand(strSQLSelect, MyConnection); OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); if (myreader.Read) { lblGuestCount.Text = myReader.Item("num"); } myReader.Close(); } 简化了一下: void Page_Load(object sender,EventArgs e) {string UserHostAddress = Request.UserHostAddress.ToString(); ipaddress.Text = UserHostAddress; string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string strConnection; strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += "Data Source=D:\FlowMisWeb\WebApp\company\database.mdb"; OleDbConnection MyConnection = new OleDbConnection(strConnection); string strSQLInsert = "insert into GuestInfo(IPAddress,[DateTime]) values('" + UserHostAddress + "','" + dt + "')"; string strSQLSelect = "select count(*) as num from GuestInfo"; OleDbCommand myCommand; mycommand = new OleDbCommand(strSQLInsert, MyConnection); MyConnection.Open(); MyCommand.ExecuteNonQuery(); myCommand = new OleDbCommand(strSQLSelect, MyConnection); lblGuestCount.Text = ((int)myCommand.ExecuteScalar()).ToString(); MyConnection.Close(); } 没见你是如何添加记录的啊?虽然有个strSQLInsert SQL语句,但没有执行过。 对啊insert根本就没有执行啊 这个就是执行的呀:MyCommand.ExecuteNonQuery(); 我用上面完全的代码,都能进行写入,现在记录已经80多条了。但就是只能读取到77条! 非常感谢: modou(魔豆) 先帮我解释一下为什么我的不行,你的就能吗?而且为什么我的到了第77行开始就不行了呢? ++++++++++++++++gridview自定义删除列实现删除功能+++++++ SQL语句求解 问各位高手一个问题??(解决给分!!!) asp.net中使用iframe实现无刷新功能 这句话是什么意思? 2进制文件读写的问题 cookies怎么加密 ASP.NET+Crystal Report 导出问题 急用!!在asp.net里能不能实现类似于DatePicker的功能?? 高手请进!请教一个问题! 又一个菜鸟问题 如何把从数据库中读出来的数据赋值到DataTable上
{
string UserHostAddress = Request.UserHostAddress.ToString();
ipaddress.Text = UserHostAddress;
string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string strConnection;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=D:\FlowMisWeb\WebApp\company\database.mdb";
OleDbConnection MyConnection = new OleDbConnection(strConnection);
string strSQLInsert = "insert into GuestInfo(IPAddress,[DateTime]) values('" + UserHostAddress + "','" + dt + "')";
string strSQLSelect = "select count(*) as num from GuestInfo";
OleDbCommand myCommand;
mycommand = new OleDbCommand(strSQLInsert, MyConnection);
MyConnection.Open();
MyCommand.ExecuteNonQuery();
myCommand = new OleDbCommand(strSQLSelect, MyConnection);
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (myreader.Read) {
lblGuestCount.Text = myReader.Item("num");
}
myReader.Close();
}
{
string UserHostAddress = Request.UserHostAddress.ToString();
ipaddress.Text = UserHostAddress;
string dt = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
string strConnection;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=D:\FlowMisWeb\WebApp\company\database.mdb";
OleDbConnection MyConnection = new OleDbConnection(strConnection);
string strSQLInsert = "insert into GuestInfo(IPAddress,[DateTime]) values('" + UserHostAddress + "','" + dt + "')";
string strSQLSelect = "select count(*) as num from GuestInfo";
OleDbCommand myCommand;
mycommand = new OleDbCommand(strSQLInsert, MyConnection);
MyConnection.Open();
MyCommand.ExecuteNonQuery();
myCommand = new OleDbCommand(strSQLSelect, MyConnection);
lblGuestCount.Text = ((int)myCommand.ExecuteScalar()).ToString();
MyConnection.Close();
}
insert根本就没有执行啊
MyCommand.ExecuteNonQuery();
我用上面完全的代码,都能进行写入,现在记录已经80多条了。但就是只能读取到77条!
先帮我解释一下为什么我的不行,你的就能吗?而且为什么我的到了第77行开始就不行了呢?