目前日期文章:201005 (3)

瀏覽方式: 標題列表 簡短摘要

加入null值 => System.DBNull.Value

SqlParameter para=new SqlParameter("@param",(object)DBNull.Value);


goodlucky 發表在 痞客邦 PIXNET 留言(0) 人氣()

        Dim strSql As String = "SELECT * FROM TableName"
        Dim filename As String = Server.MapPath("GetExcel.xls")
        Dim constring As String = System.Web.Configuration.WebConfigurationManager.ConnectionStrings("DatabaseOleDBConnectionString").ToString
        Dim connect As New Data.OleDb.OleDbConnection(constring)

        Try

goodlucky 發表在 痞客邦 PIXNET 留言(0) 人氣()

    Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
        If Char.IsDigit(e.KeyChar) Or e.KeyChar = "." Or e.KeyChar = Chr(8) Then
            If e.KeyChar = "." And InStr(TextBox1.Text, ".") > 0 Then
                e.Handled = True
            Else

goodlucky 發表在 痞客邦 PIXNET 留言(0) 人氣()