INSERTING data into specific fields of a table

Question

what abt if i wanna insert data to only fldLength and fldSize (fields) of the table, Table1, how do i choose to insert into the specific fields? Table1: fldID fldName fldLength fldSize fldExt ps: do i need to .update() or acceptchanges() for the above codes? my current codes are: cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;") cn.Open() For each filename In filelist str = "insert into table1 values('" & filename.name & "','" & "99" & "')" cmd = New OleDbCommand(str, cn) cmd.ExecuteNonQuery() Next For each filename In filelist str = "insert into table2 values('" & filename.Extension & "','" & filename.Length & "')" cmd = New OleDbCommand(str, cn) cmd.ExecuteNonQuery() Next cn.Close()

Answer 1

Thanks you for your code and also I found useful Net.NetworkInformation namespace and its classes for my application. Thanks!

Answer 2

hello


you can try it

 Uri URL = new Uri("http://sixhoej.net/speedtest/1024kb.txt");

        WebClient wc = new WebClient();

        double starttime = Environment.TickCount;

        // download file from the specified URL, and save it to C:\speedtest.txt

        wc.DownloadFile(URL, @"C:\speedtest.txt");

        // get current tickcount

        double endtime = Environment.TickCount;

        // how many seconds did it take?

        // we are calculating this by subtracting starttime from endtime

        // and dividing by 1000 (since the tickcount is in miliseconds.. 1000 ms = 1 sec)

        double secs = Math.Floor(endtime - starttime) / 1000;

        // round the number of secs and remove the decimal point

        double secs2 = Math.Round(secs, 0);

        // calculate download rate in kb per sec.

        // this is done by dividing 1024 by the number of seconds it

        // took to download the file (1024 bytes = 1 kilobyte)

        double kbsec = Math.Round(1024 / secs);

        Label1.Text = "Download rate: " + kbsec + " kb/sec";

        try

        {

            // delete downloaded file

            System.IO.File.Delete(@"C:\speedtest.txt");

            Console.WriteLine("Done.");

        }

        catch

        {

            Console.WriteLine("Couldn't delete download file.");

            Console.WriteLine("To delete the file yourself, go to your C-drive and look for the file 'speedtest.txt'.");

            Console.ReadKey();

        }