Results 1 to 3 of 3

Thread: [RESOLVED] Grabbing Data Type of each column

Threaded View

  1. Nov 2nd, 2005, 09:30 AM #1
    IgnoramusLLJK
    IgnoramusLLJK is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2005
    Posts
    21

    Resolved [RESOLVED] Grabbing Data Type of each column

    Hello, Im using a datagrid to find/replace certain dates, strings, words etc. The database can contain any type of field created by a user in another application, all I need to know is how to find out what types of variables are stored in each column before I can filter things out. Right now Im using something like this:

    VB Code:
    1. aFilter = "[Summary] Like '" & txtfilter.Text & "*'"

    2. DS1.Tables("tblDoc").DefaultView.RowFilter = aFilter

    Of course this works fine for strings but not on dates or any integers. So my plan is to have a case structure to format my sql query correctly depending on data type.

    Im not the best coder (kinda part time) so please forgive any idiocy included in the above text.
    Last edited by IgnoramusLLJK; Nov 2nd, 2005 at 10:10 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width