C#

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());
         }
     }

[StructLayout(LayoutKind.Explicit)]
struct unie {
    [FieldOffset(0)]
    public float f;
    [FieldOffset(0)]
    public byte b;
}

CREATE TABLE [dbo].[billsbody] (
	[guid] [uniqueidentifier] NULL ,
	[parentguid] [uniqueidentifier] NULL ,
	[yarnguid] [uniqueidentifier] NULL ,
	[qty] [float] NULL 
) ON [PRIMARY]


CREATE TABLE [dbo].[billsheader] (
	[number] [int] NULL ,
	[billguid] [uniqueidentifier] NULL ,
	[typeguid] [uniqueidentifier] NULL ,
	[date] [datetime] NULL ,
	[customer] [uniqueidentifier] NULL ,
	[total] [float] NULL ,
	[note] [varchar] (255) COLLATE Arabic_CI_AS NULL 
) ON [PRIMARY]

public static void CreateNew()
        {

            SqlCmd = new SqlCommand();
            SqlCmd.CommandText = "USE MASTER";
            SqlCmd.Connection = clsConnect.SqlCon;
            SqlCmd.ExecuteNonQuery();

            SqlCmd = new SqlCommand();
            SqlCmd.CommandText = "DROP DATABASE [jaloud-tex]";
            SqlCmd.Connection = clsConnect.SqlCon;
            SqlCmd.ExecuteNonQuery();
            
            SqlCmd = new SqlCommand();
            SqlCmd.CommandText = "CREATE DATABASE [jaloud-tex]";
            SqlCmd.Connection = clsConnect.SqlCon;
            SqlCmd.ExecuteNonQuery();

            SqlCmd = new SqlCommand();
            SqlCmd.CommandText = "USE [Stark-DB]";  // This is my database Name ( Not include in script )
            SqlCmd.Connection = clsConnect.SqlCon;
            SqlCmd.ExecuteNonQuery();


            SqlCmd = new SqlCommand();
            // Here I call the script ... from resource ... 
            SqlCmd.CommandText = global::StarkProject.Properties.Resources.NewDB.ToString();
            SqlCmd.Connection = clsConnect.SqlCon;
            SqlCmd.ExecuteNonQuery();

        }