C#

//Create a new Table called tblImgData
DataTable dt = new DataTable("tblImgData");

//Adds a column called picture
dt.Columns.Add("Picture", typeof(Byte[]));

//Add a row to the table
dt.Rows.Add(GetImageData(s));

//Then add it to the DataSet
DataSet ds = new DataSet("NewDataSetName");
ds.Tables.Add(dt);

A_A wrote:

com1.CommandText = "SELECT * FROM user WHERE name=" + txt_username.Text + " ";

using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
namespace ConsoleApplication31
{
    class Program
    {
        static void Main(string[] args)
        {
            ManagementScope scope = new ManagementScope(@"\root\cimv2");
            ObjectQuery query = new ObjectQuery("select * from Win32_DiskPartition");
            ManagementObjectSearcher searcher = new
            ManagementObjectSearcher(scope, query);
            ManagementObjectCollection drives = searcher.Get();
            foreach (ManagementObject current in drives)
            {
                Console.WriteLine("device id = " + current["deviceid"]);
                ObjectQuery associators = new ObjectQuery("ASSOCIATORS OF {Win32_DiskPartition.DeviceID=\"" + current["deviceid"] + "\"} where assocclass=Win32_LogicalDiskToPartition");
                searcher = new ManagementObjectSearcher(scope, associators);
                ManagementObjectCollection disks = searcher.Get();
                foreach (ManagementObject disk in disks)
                {
                    Console.WriteLine("\tdevice id = " + disk["deviceid"]);
                }
            }
        }
    }
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
namespace ConsoleApplication31
{
    class Program
    {
        static void Main(string[] args)
        {

            ManagementScope scope = new ManagementScope(@"\root\cimv2");
            ObjectQuery query = new ObjectQuery("select * from Win32_DiskPartition");
            ManagementObjectSearcher searcher = new
            ManagementObjectSearcher(scope, query);
            ManagementObjectCollection drives = searcher.Get();
            int dindex= 0;
            foreach (ManagementObject current in drives)
            {
                dindex = int.Parse(current["DiskIndex"].ToString());
            }
            scope = new ManagementScope(@"\root\cimv2");
            query = new ObjectQuery("select * from Win32_DiskDrive WHERE Index = " + dindex.ToString());
            searcher = new
            ManagementObjectSearcher(scope, query);
            drives = searcher.Get();
            foreach (ManagementObject current in drives)
            {
                Console.WriteLine(current["Model"].ToString());
            }
        }
    }
}

string VolumeName = "C:";
     ManagementScope scope = new ManagementScope(@"\root\cimv2");
     ObjectQuery query = new ObjectQuery("ASSOCIATORS OF {Win32_LogicalDisk.DeviceID=\"" + VolumeName + "\"} where assocclass=Win32_LogicalDiskToPartition");
     ManagementObjectSearcher searcher = new ManagementObjectSearcher(scope, query);
     ManagementObjectCollection drives = searcher.Get();
     foreach (ManagementObject current in drives)
     {
         scope = new ManagementScope(@"\root\cimv2");
         query = new ObjectQuery("ASSOCIATORS OF {Win32_DiskPartition.DeviceID=\"" + current["DeviceID"].ToString() + "\"} where assocclass=Win32_DiskDriveToDiskPartition");
         searcher = new ManagementObjectSearcher(scope, query);
         drives = searcher.Get();
         foreach (ManagementObject current2 in drives)
         {
             MessageBox.Show(current2["model"].ToString());
         }
     }