Yes, me too Agree to all. First to have basic knowledge of SQL then also
must go with Sqlite Documentation which has provided as per last response
before posting here, so that atleast will have some genuine question and
answer to know and add advantage to information / knowledge sharing.
On 2
Don't know which connection provider you are going to use, but ADO.net
guideline is here:
1. Download Sqlite for windows, install it.
2. Download ADO.NET 2.0 Provider for SQLite from here and install it :
http://sourceforge.net/projects/sqlite-dotnet2/
3. Added a reference to the
= T2.docid and T1.docid = T3.docid and
T1.docid = T4.docid"
myparam.Value = Z + 1
mycommand.ExecuteNonQuery()
tx.Commit()
Next
cons.close()
its same speed and slow...not working, please guide
On 21 July 2011 19:02, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 21 Jul 2011
Hi Sqlite Team,
I am trying to Insert values into New Table "Ticket" from
Table1,Table2,Table3 and Table4 with the following Query but its taking alot
of time to insert values in new table.
VB.NET + SQLITE using ADO.net connection ( Its having 25k+ rows)
*Option 1:*
Hi Sqlite Team,
my project at its last stage.
*can you help me on :*
how to Export sqlite table in textpad/notepad using VB.NET application ?
Any direct command which can help me.
or
shall i use select command and write into textpad/notepad line by line ?
which one will be best way, or
*here are summary code :inserting 100k in 5-7 sec*
*
*
//Reading text file 1 in
yarray2= filetext.Split(Environment.NewLine)
//Reading text file 1 in
yarray1 = filetext1.Split(Environment.NewLine)
insert:
Dim tx = cons.BeginTransaction()
For y = j To x
Dim
()
Next
tx.Commit()
End If
Thanks you again guys, many thanks...
Regards,
Alok
On 6 January 2011 21:21, Olaf Schmidt <s...@online.de> wrote:
>
> "Alok Singh" <aaloksing...@gmail.com> schrieb
> im Newsbeitrag
> news:aan
7 matches
Mail list logo