我想显示数据Datagirdview当我从Datetimepicker选择日期但它给我错误作为操作数类型冲突：日期与Int不兼容 [英] I Want To Display Data Datagirdview When I Select Date From Datetimepicker But It Is Giving Me Error As Operand Type Clash: Date Is Incompitable With Int

问题描述

Private Sub viewrptrs_Click(sender As System.Object, e As System.EventArgs) Handles viewrptrs.Click
       Dim str As String
       Dim datefrom = DateTimePicker1.Value.Date
       Dim endfrom = DateTimePicker2.Value.Date
       Dim con As New SqlConnection("Data Source=ASHUTOSH-PC\SQLEXPRESS;Initial Catalog=Art Station Management System;Integrated Security=True")
       str = "Select sstudentid, sname, smiddlename, ssurname, ccoursename from StudentRegister WHERE sdatereg BETWEEN " & datefrom & " AND " & endfrom & ""
       Dim com As New SqlCommand(str, con)
       Dim da As New SqlDataAdapter(com)
       Dim ds As New DataSet
       da.Fill(ds, "StudentRegister") 'ERROR ON THIS LINE
       DataGridView1.DataSource = ds.Tables(0)
       da.Dispose()
   End Sub

推荐答案

修复 SQL注入 [ ^ ]漏洞很可能也会解决错误信息：

Fixing the SQL Injection[^] vulnerability in your code will most likely solve the error message as well:

Private Sub viewrptrs_Click(sender As System.Object, e As System.EventArgs) Handles viewrptrs.Click
    Using con As New SqlConnection("Data Source=ASHUTOSH-PC\SQLEXPRESS;Initial Catalog=Art Station Management System;Integrated Security=True")
        Using com As New SqlCommand("Select sstudentid, sname, smiddlename, ssurname, ccoursename from StudentRegister WHERE sdatereg BETWEEN @datefrom AND @dateto", con)
            com.Parameters.AddWithValue("@datefrom", DateTimePicker1.Value.Date)
            com.Parameters.AddWithValue("@dateto", DateTimePicker2.Value.Date)
            
            Using da As New SqlDataAdapter(com)
                Dim ds As New DataSet()
                da.Fill(ds, "StudentRegister")
                DataGridView1.DataSource = ds.Tables(0)
            End Using
        End Using
    End Using
End Sub

当你在它的时候，帮自己一个忙，并给你的控件有意义的名字。你可能还记得 TextBox42 今天持有frood name ;但是当你在六个月内回到你的代码中时，你会挣扎。

While you're at it, do yourself a favour and give your controls meaningful names. You might remember that TextBox42 holds the "frood name" today; but when you come back to your code in six months, you'll be struggling.

这篇关于我想显示数据Datagirdview当我从Datetimepicker选择日期但它给我错误作为操作数类型冲突：日期与Int不兼容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！