你insert的次数太多了,你的时间是放到变量里存着了吧,不是随取虽用
解决方案 »
- 写了个递归调用展示分类层次 怎样更好的展示层次啊?就是缩进的空格数量
- 如何实现类似于Discus论坛中的短消息通知?
- 求救~怎门样实现像这样的显示方式,先谢拉~
- 弱弱的问一个问题,我可以用Atlas和ajax.net pro一起使用吗?
- TextBox手工输入 + DropDownList选择 有什么好的实现方法?
- asp.net如何调用.jar文件???
- DataReader能否快速定位?
- 关于Text字段类型的数据修改的Sql语句.
- Winform exe
- DataSet数据前放置的按钮只能拿到第一行的数据
- 一个DropDownList控件,想在它被选择后执行一个前台JS程序,应该怎么办呀
- 急急急!!怎么获得datagrid的item的绑定的数据?
' 在会话启动时激发
Dim myConnection As System.Data.OleDb.OleDbConnection
Dim myCommand As System.Data.OleDb.OleDbCommand
Dim ConnStr, ConnStr_location As String
Dim SQL As String Dim apppath As String
apppath = Request.PhysicalApplicationPath
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + apppath + "wangzhantongji.mdb;"
myConnection = New System.Data.OleDb.OleDbConnection(ConnStr) Dim s_user_ip, s_location As String
Dim dt_visit_time As DateTime
ConnStr_location = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + apppath + "IpAddressofWorld.mdb;" Dim IpLookUp As New GeneralTools.IpLookUp(ConnStr_location) s_user_ip = Request.ServerVariables("REMOTE_ADDR") s_location = IpLookUp.IptoLocation(s_user_ip)
dt_visit_time = DateTime.Now If Trim(s_user_ip) = "" Then
Return
End If If Trim(s_user_ip) = "127.0.0.1" Then
Return
End If SQL = "insert into visit_info(user_ip,visit_time,location) values('" + s_user_ip + "','" + dt_visit_time + "','" + s_location + "')" myCommand = New System.Data.OleDb.OleDbCommand(SQL, myConnection)
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
End Sub谢谢!!!其中GeneralTools是我写的程序集。
Dim myCommand As System.Data.OleDb.OleDbCommand
Dim ConnStr, ConnStr_location As String
Dim SQL As String Dim apppath As String
apppath = Request.PhysicalApplicationPath
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + apppath + "wangzhantongji.mdb;"
myConnection = New System.Data.OleDb.OleDbConnection(ConnStr) Dim s_user_ip, s_location As String
Dim dt_visit_time As DateTime
ConnStr_location = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + apppath + "IpAddressofWorld.mdb;" Dim IpLookUp As New GeneralTools.IpLookUp(ConnStr_location) s_user_ip = Request.ServerVariables("REMOTE_ADDR") s_location = IpLookUp.IptoLocation(s_user_ip)
dt_visit_time = DateTime.Now If Trim(s_user_ip) = "" Then
Return
End If If Trim(s_user_ip) = "127.0.0.1" Then
Return
End If SQL = "insert into visit_info(user_ip,visit_time,location) values('" + s_user_ip + "','" + dt_visit_time + "','" + s_location + "')" myCommand = New System.Data.OleDb.OleDbCommand(SQL, myConnection)
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()试试将上面的代码放到
protected void Application_Start(Object sender, EventArgs e)
{}
中间去。