Windows Forms

nt_virus wrote:

Can anyone of you guys please help me in this

nt_virus wrote:

and I m puzzled by seeing such codes and cant find a way to make it work..

nt_virus wrote:

I really need it ..

I are troll

namespace SqldataTable_to_Excel
{
    class Program
    {
        static void Main(string[] args)
        {
            string path = @"C:\db.xls";
            if (!File.Exists(path))
            {
                // Create a file to write to.
                using (StreamWriter sw = File.CreateText(path))
                {
                    //creating the file contents
                    SqlConnection cn = new SqlConnection("Data Source=NT_VIRUS;Initial Catalog=test;Integrated Security=True");
                    SqlCommand cmd = new SqlCommand("SELECT * FROM planets", cn);
                    try
                    {
                        cn.Open();
                        SqlDataReader dr = cmd.ExecuteReader();
                        while (dr.Read())
                        {
                            sw.WriteLine(dr["name"].ToString() + "\t" + dr["age"].ToString());
                        }

                        Console.WriteLine("Database has been exported.");
                    }
                    catch (Exception excpt)
                    {
                        Console.WriteLine(excpt.Message);
                    }
                }
            }
        }
    }

SELECT sysobjects.name AS TableName,
       syscolumns.name AS ColumnName,
       datatype=systypes.name,
       length=syscolumns.length
  FROM sysobjects 
  JOIN syscolumns ON sysobjects.id = syscolumns.id
  JOIN systypes ON syscolumns.xtype=systypes.xtype
 WHERE sysobjects.name = 'AfvinkCode'

I are troll