Protected Sub ShowBYSQButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ShowBYSQButton.Click
Dim con As New SqlConnection()
con.ConnectionString = "Data Source=UPC-DING;Initial Catalog=bysj;User ID=sa ;"
con.Open()
Dim sql As String
sql = "SELECT * FROM [保养申请] where 申请日期 between '@xh' and '@xb'"
Dim ds As New DataSet()
Dim adp As New SqlDataAdapter()
Dim cmd As New SqlCommand()
cmd.Parameters.Clear() cmd.Connection = con
cmd.CommandType = CommandType.Text cmd.CommandText = sql
cmd.Parameters.Add("@xh", SqlDbType.DateTime)
cmd.Parameters.Add("@xb", SqlDbType.DateTime) cmd.Parameters("@xh").Value = Convert.ToDateTime(StartListBox.SelectedItem.Text)
cmd.Parameters("@xb").Value = Convert.ToDateTime(EndListBox.SelectedItem.Text)
adp.SelectCommand = cmd
adp.Fill(ds, "by")
GridView1.DataSource = ds.Tables("by").DefaultView
GridView1.DataBind()
con.Close()
具体出错信息:
从字符串转换为 datetime 时发生语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 从字符串转换为 datetime 时发生语法错误。源错误:
行 37: adp.SelectCommand = cmd
行 38: ds.Clear()
行 39: adp.Fill(ds, "by")
行 40: GridView1.DataSource = ds.Tables("by").DefaultView
行 41: GridView1.DataBind()
源文件: E:\毕业设计作业\保养设备管理\保养申请单.aspx.vb 行: 39 堆栈跟踪:
[SqlException (0x80131904): 从字符串转换为 datetime 时发生语法错误。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.HasMoreRows() +194
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +262
System.Data.SqlClient.SqlDataReader.Read() +29
System.Data.ProviderBase.DataReaderContainer.Read() +26
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +241
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +257
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +383
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +251
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
保养设备管理_保养申请单.ShowBYSQButton_Click(Object sender, EventArgs e) in E:\保养设备管理\保养申请单.aspx.vb:39
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3838
Dim con As New SqlConnection()
con.ConnectionString = "Data Source=UPC-DING;Initial Catalog=bysj;User ID=sa ;"
con.Open()
Dim sql As String
sql = "SELECT * FROM [保养申请] where 申请日期 between '@xh' and '@xb'"
Dim ds As New DataSet()
Dim adp As New SqlDataAdapter()
Dim cmd As New SqlCommand()
cmd.Parameters.Clear() cmd.Connection = con
cmd.CommandType = CommandType.Text cmd.CommandText = sql
cmd.Parameters.Add("@xh", SqlDbType.DateTime)
cmd.Parameters.Add("@xb", SqlDbType.DateTime) cmd.Parameters("@xh").Value = Convert.ToDateTime(StartListBox.SelectedItem.Text)
cmd.Parameters("@xb").Value = Convert.ToDateTime(EndListBox.SelectedItem.Text)
adp.SelectCommand = cmd
adp.Fill(ds, "by")
GridView1.DataSource = ds.Tables("by").DefaultView
GridView1.DataBind()
con.Close()
具体出错信息:
从字符串转换为 datetime 时发生语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 从字符串转换为 datetime 时发生语法错误。源错误:
行 37: adp.SelectCommand = cmd
行 38: ds.Clear()
行 39: adp.Fill(ds, "by")
行 40: GridView1.DataSource = ds.Tables("by").DefaultView
行 41: GridView1.DataBind()
源文件: E:\毕业设计作业\保养设备管理\保养申请单.aspx.vb 行: 39 堆栈跟踪:
[SqlException (0x80131904): 从字符串转换为 datetime 时发生语法错误。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.HasMoreRows() +194
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +262
System.Data.SqlClient.SqlDataReader.Read() +29
System.Data.ProviderBase.DataReaderContainer.Read() +26
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +241
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +257
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +383
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +251
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
保养设备管理_保养申请单.ShowBYSQButton_Click(Object sender, EventArgs e) in E:\保养设备管理\保养申请单.aspx.vb:39
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +96
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +116
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3838
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货