Browse by Tags

Change type of field

In mysql i used ALTER TABLE `te` CHANGE `4` `ga` VARCHAR ( 2 ) NOT NULL what the sql lite equaliant

Posted to How To (Forum) by thomaxz on 01-31-2008
Re: using a dataset to create a new sqlite db

Yes you can do it programatically. You would basically just have to loop through the tables in the dataset, read out the schema, and build your create table and insert statements. I've done this in a fairly generic sense for some software I worked on recently where I receive datasets from a webservice...

Posted to How To (Forum) by Nazguy on 12-18-2007
Select year data from a DateTime field

Hello, I have a datetime field (mydate) in my table (mytable), and I want to get all different year from this table. Here is the query which works in MySQL : string queryString = "Select distinct year(mydate) as year from mytable" I want to make the same query using SQLite I have try this ...

Posted to How To (Forum) by Anguenot on 09-06-2007

Page 1 of 1 (3 items)

System.Data.SQLite