入门代码,为什么会有use
分类:高并发

在C#中应用DTS

一、从控制台读取东西代码片断: using System;

为什么会有use of unassigned local variable 'result'
internal void check(string name,ref string result) { object pass; SqlConnection con = new SqlConnection("Data Source=SAMSUNG;Initial Catalog=AL_Nayesh_Kids_Castle;Persist Security Info=True;User ID=sa;Password=259695"); con.Open(); SqlCommand cmd = new SqlCommand("select * from register", con); SqlDataReader dr = cmd.ExecuteReader(); while ) { if (name == dr[0].ToString { pass = dr[1]; result = Convert.ToString; break; } } dr.Close(); con.Close(); } static void Main(string[] args) { string result, password; register obj = new register(); obj.student(); Console.WriteLine; string name = Console.ReadLine(); Console.WriteLine("password"); password = Console.ReadLine(); obj.check(name,ref result); if(password==result) Console.WriteLine("welcome"); }

本文将关注列出、执行DTS包和改变DTS包的属性或者全局变量。

class TestReadConsole
{
    public static void Main()
    {
        Console.Write(Enter your name:);
        string strName = Console.ReadLine();
        Console.WriteLine( Hi + strName);
    }
}
二、读文件代码片断: using System;
using System.IO;

首先我们看看如何列出保存在本地(local or (local)NetSDK)服务器为本地包。在DOTNET中处理DTS包的关键是增加对“Microsoft DTSPackage Object Library”的引用(dts.dll)。

public class TestReadFile
{
    public static void Main(String[] args)
    {
        // Read text file C:/temp/test.txt
        FileStream fs = new FileStream(@c:/temp/test.txt , FileMode.Open, FileAccess.Read);
        StreamReader sr = new StreamReader(fs);  
        
        String line=sr.ReadLine();
        while (line!=null)
        {
            Console.WriteLine(line);
            line=sr.ReadLine();
        }   
        
        sr.Close();
        fs.Close();
    }
}
三、写文件代码:
using System;
using System.IO;

以下代码可以列出服务器上的本地包。

public class TestWriteFile
{
    public static void Main(String[] args)
    {
        // Create a text file C:/temp/test.txt
        FileStream fs = new FileStream(@c:/temp/test.txt , FileMode.OpenOrCreate, FileAccess.Write);
        StreamWriter sw = new StreamWriter(fs);
        // Write to the file using StreamWriter class
        sw.BaseStream.Seek(0, SeekOrigin.End);
        sw.WriteLine( First Line );
        sw.WriteLine( Second Line);
        sw.Flush();
    }
}
四、拷贝文件: using System;
using System.IO;

static void Main(string[] args)

class TestCopyFile
{
    public static void Main()
    {
        File.Copy(c://temp//source.txt, C://temp//dest.txt );  
    }
}
五、移动文件:
using System;
using System.IO;

{

class TestMoveFile
{
    public static void Main()
    {
        File.Move(c://temp//abc.txt, C://temp//def.txt );  
    }
}
六、使用计时器: using System;
using System.Timers;

DTS.Application App=new DTS.Application();

class TestTimer
{
    public static void Main()
    {
        Timer timer = new Timer();
        timer.Elapsed += new ElapsedEventHandler( DisplayTimeEvent );
        timer.Interval = 1000;
        timer.Start();
        timer.Enabled = true;

DTS.PackageSQLServer package= App.GetPackageSQLServer("(local)\NetSDK", "sa", "",

        while ( Console.Read() != 'q' )
        {

DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default);

        }
    }

DTS.PackageInfos Infos;

    public static void DisplayTimeEvent( object source, ElapsedEventArgs e )
    {
        Console.Write(/r{0}, DateTime.Now);
    }
}
七、调用外部程序: class Test
{
    static void Main(string[] args)
    {
        System.Diagnostics.Process.Start(notepad.exe);
    }
}

Infos = package.EnumPackageInfos("", false, "");

ADO.NET方面的:
八、连接Access数据库:
using System;
using System.Data;
using System.Data.OleDb;

foreach(DTS.PackageInfo Info in Infos)

class TestADO
{
    static void Main(string[] args)
    {
        string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c://test.mdb;
        string strSQL = SELECT * FROM employees ;

{

        OleDbConnection conn = new OleDbConnection(strDSN);
        OleDbCommand cmd = new OleDbCommand( strSQL, conn );
        OleDbDataReader reader = null;
        try
        {
            conn.Open();
            reader = cmd.ExecuteReader();
            while (reader.Read() )
            {
                Console.WriteLine(First Name:{0}, Last Name:{1}, reader[FirstName], reader[LastName]);
            }
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
        }
        finally
        {
            conn.Close();
        }
    }
}
九、连接SQL Server数据库: using System;
using System.Data.SqlClient;

Console.WriteLine("Name : {0}tVersionID : {1}",Info.Name,Info.VersionID);

public class TestADO
{
    public static void Main()
    {
        SqlConnection conn = new SqlConnection(Data Source=localhost; Integrated Security=SSPI; Initial Catalog=pubs);
        SqlCommand  cmd = new SqlCommand(SELECT * FROM employees, conn);
        try
        {        
            conn.Open();

}

            SqlDataReader reader = cmd.ExecuteReader();            
            while (reader.Read())
            {
                Console.WriteLine(First Name: {0}, Last Name: {1}, reader.GetString(0), reader.GetString(1));
            }
        
            reader.Close();
            conn.Close();
        }
        catch(Exception e)
        {
            Console.WriteLine(Exception Occured -->> {0},e);
        }        
    }
}
十、从SQL内读数据到XML: using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;
using System.IO;

Console.Read();

public class TestWriteXML
{
    public static void Main()
    {

}

        String strFileName=c:/temp/output.xml;

取保存在格式化存储文件中的dts包属性代码如下:

        SqlConnection conn = new SqlConnection(server=localhost;uid=sa;pwd=;database=db);

static void Main(string[] args)

        String strSql = SELECT FirstName, LastName FROM employees;

{

        SqlDataAdapter adapter = new SqlDataAdapter();

DTS.Package2Class package=new DTS.Package2Class();

        adapter.SelectCommand = new SqlCommand(strSql,conn);

DTS.SavedPackageInfos Infos =

        // Build the DataSet
        DataSet ds = new DataSet();

package.GetSavedPackageInfos("C:\Pubs2Pubs2Package.dts");

        adapter.Fill(ds, employees);

foreach(DTS.SavedPackageInfo Info in Infos)

        // Get a FileStream object
        FileStream fs = new FileStream(strFileName,FileMode.OpenOrCreate,FileAccess.Write);

{

        // Apply the WriteXml method to write an XML document
        ds.WriteXml(fs);

Console.WriteLine("Name : {0}tVersionID : {1}",

        fs.Close();

Info.PackageName,Info.VersionID);

    }
}
十一、用ADO添加数据到数据库中:
using System;
using System.Data;   
using System.Data.OleDb;   

}

class TestADO
{  
    static void Main(string[] args)  
    {  
        string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:/test.mdb;  
        string strSQL = INSERT INTO Employee(FirstName, LastName) VALUES('FirstName', 'LastName') ;  
                  
        // create Objects of ADOConnection and ADOCommand   
        OleDbConnection conn = new OleDbConnection(strDSN);  
        OleDbCommand cmd = new OleDbCommand( strSQL, conn );  
        try  
        {  
            conn.Open();  
            cmd.ExecuteNonQuery();  
        }  
        catch (Exception e)  
        {  
            Console.WriteLine(Oooops. I did it again:/n{0}, e.Message);  
        }  
        finally  
        {  
            conn.Close();  
        }         
    }
}  
十二、使用OLEConn连接数据库: using System;
using System.Data;   
using System.Data.OleDb;   

package.UnInitialize();

class TestADO
{  
    static void Main(string[] args)  
    {  
        string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:/test.mdb;  
        string strSQL = SELECT * FROM employee ;  

Console.Read();

        OleDbConnection conn = new OleDbConnection(strDSN);
        OleDbDataAdapter cmd = new OleDbDataAdapter( strSQL, conn );

}

        conn.Open();
        DataSet ds = new DataSet();
        cmd.Fill( ds, employee );
        DataTable dt = ds.Tables[0];

通过Package2Class对象可以执行dts包,或者操作dts包的属性。代码如下:

        foreach( DataRow dr in dt.Rows )
        {
            Console.WriteLine(First name: + dr[FirstName].ToString() + Last name: + dr[LastName].ToString());
        }
        conn.Close();  
    }
}  
十三、读取表的属性: using System;
using System.Data;   
using System.Data.OleDb;   

static void Main(string[] args)

class TestADO
{  
    static void Main(string[] args)  
    {  
        string strDSN = Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:/test.mdb;  
        string strSQL = SELECT * FROM employee ;  

{

        OleDbConnection conn = new OleDbConnection(strDSN);
        OleDbDataAdapter cmd = new OleDbDataAdapter( strSQL, conn );

DTS.Package2Class package=new DTS.Package2Class();

        conn.Open();
        DataSet ds = new DataSet();
        cmd.Fill( ds, employee );
        DataTable dt = ds.Tables[0];

try

        Console.WriteLine(Field Name DataType Unique AutoIncrement AllowNull);
        Console.WriteLine(==================================================================);
        foreach( DataColumn dc in dt.Columns )
        {
            Console.WriteLine(dc.ColumnName+ , +dc.DataType + ,+dc.Unique + ,+dc.AutoIncrement+ ,+dc.AllowDBNull );
        }
        conn.Close();  
    }
}

{

ASP.NET方面的
十四、一个ASP.NET程序:
<%@ Page Language=C# %>
<script runat=server>
   
    void Button1_Click(Object sender, EventArgs e)
    {
        Label1.Text=TextBox1.Text;
    }

Object MIA=System.Reflection.Missing.Value;

</script>
<html>
<head>
</head>
<body>
    <form runat=server>
        <p>
            <br />
            Enter your name: <asp:TextBox id=TextBox1 runat=server></asp:TextBox>
        </p>
        <p>
            <b><asp:Label id=Label1 runat=server Width=247px></asp:Label></b>
        </p>
        <p>
            <asp:Button id=Button1 onclick=Button1_Click runat=server Text=Submit></asp:Button>
        </p>
    </form>
</body>
</html>

package.LoadFromSQLServer("(local)\NetSDK",

WinForm开发:
十五、一个简单的WinForm程序: using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

"sa", "", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "",

public class SimpleForm : System.Windows.Forms.Form
{

"{F580DFC4-1F6A-4D70-B6A1-1C200B0D7890}", "CustomTaskPKG",ref MIA);

    private System.ComponentModel.Container components = null;
    private System.Windows.Forms.Button button1;
    private System.Windows.Forms.TextBox textBox1;
    public SimpleForm()
    {
        InitializeComponent();
    }

Console.WriteLine(package.Description);

    protected override void Dispose( bool disposing )
    {
        if( disposing )
        {
            if (components != null)
            {
                components.Dispose();
            }
        }
        base.Dispose( disposing );
    }

package.Description="My description";

    #region Windows Form Designer generated code
    private void InitializeComponent()
    {

Console.WriteLine(package.Description);

        this.components = new System.ComponentModel.Container();
        this.Size = new System.Drawing.Size(300,300);
        this.Text = Form1;

}

        this.button1 = new System.Windows.Forms.Button();
        this.textBox1 = new System.Windows.Forms.TextBox();
        this.SuspendLayout();
    //
    // button1
    //

catch(Exception ex)

    this.button1.Location = new System.Drawing.Point(8, 16);
    this.button1.Name = button1;
    this.button1.Size = new System.Drawing.Size(80, 24);
    this.button1.TabIndex = 0;
    this.button1.Text = button1;

{

    //
    // textBox1
    //
    this.textBox1.Location = new System.Drawing.Point(112, 16);
    this.textBox1.Name = textBox1;
    this.textBox1.Size = new System.Drawing.Size(160, 20);
    this.textBox1.TabIndex = 1;
    this.textBox1.Text = textBox1;
    //
    // Form1
    //

Console.WriteLine(ex.Message);

    this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
    this.ClientSize = new System.Drawing.Size(292, 273);
    this.Controls.AddRange(new System.Windows.Forms.Control[] {
    this.textBox1,
    this.button1});
    this.Name = Form1;
    this.Text = Form1;
    this.ResumeLayout(false);

}

    }
    #endregion

finally

    [STAThread]
    static void Main()
    {
        Application.Run(new SimpleForm());
    }
}
十六、运行时显示自己定义的图标:
//load icon and set to form
System.Drawing.Icon ico = new System.Drawing.Icon(@c:/temp/app.ico);
this.Icon = ico;
十七、添加组件到ListBox中: private void Form1_Load(object sender, System.EventArgs e)
{
    string str = First item;
    int i = 23;
    float flt = 34.98f;
    listBox1.Items.Add(str);
    listBox1.Items.Add(i.ToString());
    listBox1.Items.Add(flt.ToString());
    listBox1.Items.Add(Last Item in the List Box);
}

{

网络方面的:
十八、取得IP地址:
using System;
using System.Net;

package.UnInitialize();

class GetIP
{
     public static void Main()
     {
         IPHostEntry ipEntry = Dns.GetHostByName (localhost);
         IPAddress [] IpAddr = ipEntry.AddressList;
         for (int i = 0; i < IpAddr.Length; i++)
         {
             Console.WriteLine (IP Address {0}: {1} , i, IpAddr.ToString ());
         }
    }
}
十九、取得机器名称: using System;
using System.Net;

package=null;

class GetIP
{
    public static void Main()
    {
          Console.WriteLine (Host name : {0}, Dns.GetHostName());
    }
}
二十、发送邮件:
using System;
using System.Web;
using System.Web.Mail;

}

public class TestSendMail
{
    public static void Main()
    {
        try
        {
            // Construct a new mail message
            MailMessage message = new MailMessage();
            message.From = from@domain.com;
            message.To   =  pengyun@cobainsoft.com;
            message.Cc   = ;
            message.Bcc  = ;
            message.Subject = Subject;
            message.Body = Content of message;
            
            //if you want attach file with this mail, add the line below
            message.Attachments.Add(new MailAttachment(c://attach.txt, MailEncoding.Base64));
  
            // Send the message
            SmtpMail.Send(message);  
            System.Console.WriteLine(Message has been sent);
        }

Console.Read();

        catch(Exception ex)
        {
            System.Console.WriteLine(ex.Message.ToString());
        }

}

    }
}
二十一、根据IP地址得出机器名称:
using System;
using System.Net;

如果要使用最新的版本信息,则不填写版本id信息,代码如下:

class ResolveIP
{
     public static void Main()
     {
         IPHostEntry ipEntry = Dns.Resolve(172.29.9.9);
         Console.WriteLine (Host name : {0}, ipEntry.HostName);         
     }
}

package.SaveToSQLServer("(local)\NetSDK", "sa", "",

GDI+方面的:
二十二、GDI+入门介绍:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "","",ref MIA,false);

public class Form1 : System.Windows.Forms.Form
{
    private System.ComponentModel.Container components = null;

以下是设置dts包全局变量的过程:

    public Form1()
    {
        InitializeComponent();
    }

static void Main(string[] args)

    protected override void Dispose( bool disposing )
    {
        if( disposing )
        {
            if (components != null)
            {
                components.Dispose();
            }
        }
        base.Dispose( disposing );
    }

{

    #region Windows Form Designer generated code
    private void InitializeComponent()
    {
        this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
        this.ClientSize = new System.Drawing.Size(292, 273);
        this.Name = Form1;
        this.Text = Form1;
        this.Paint += new System.Windows.Forms.PaintEventHandler(this.Form1_Paint);
    }
    #endregion

DTS.Package2Class package = new DTS.Package2Class();

    [STAThread]
    static void Main()
    {
        Application.Run(new Form1());
    }

try

    private void Form1_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
    {
        Graphics g=e.Graphics;
        g.DrawLine(new Pen(Color.Blue),10,10,210,110);
        g.DrawRectangle(new Pen(Color.Red),10,10,200,100);
        g.DrawEllipse(new Pen(Color.Yellow),10,150,200,100);
    }
}

{

XML方面的:
二十三、读取XML文件:
using System;
using System.Xml;  

Object MIA=System.Reflection.Missing.Value;

class TestReadXML
{
    public static void Main()
    {
        
        XmlTextReader reader  = new XmlTextReader(C://test.xml);
        reader.Read();
        
        while (reader.Read())
        {            
            reader.MoveToElement();
            Console.WriteLine(XmlTextReader Properties Test);
            Console.WriteLine(===================);  

package.LoadFromStorageFile("C:\Pubs2Pubs2Package.dts","","","",

            // Read this properties of element and display them on console
            Console.WriteLine(Name: + reader.Name);
            Console.WriteLine(Base URI: + reader.BaseURI);
            Console.WriteLine(Local Name: + reader.LocalName);
            Console.WriteLine(Attribute Count: + reader.AttributeCount.ToString());
            Console.WriteLine(Depth: + reader.Depth.ToString());
            Console.WriteLine(Line Number: + reader.LineNumber.ToString());
            Console.WriteLine(Node Type: + reader.NodeType.ToString());
            Console.WriteLine(Attribute Count: + reader.Value.ToString());
        }        
    }               
}
二十四、写XML文件: using System;
using System.Xml;

"Pubs2Pubs2Package",ref MIA);

public class TestWriteXMLFile
{
    public static int Main(string[] args)
    {
        try
        {  
            // Creates an XML file is not exist
            XmlTextWriter writer = new XmlTextWriter(C://temp//xmltest.xml, null);
            // Starts a new document
            writer.WriteStartDocument();
            //Write comments
            writer.WriteComment(Commentss: XmlWriter Test Program);
            writer.WriteProcessingInstruction(Instruction,Person Record);
            // Add elements to the file
            writer.WriteStartElement(p, person, urn:person);
            writer.WriteStartElement(LastName,);
            writer.WriteString(Chand);
            writer.WriteEndElement();
            writer.WriteStartElement(FirstName,);
            writer.WriteString(Mahesh);
            writer.WriteEndElement();
            writer.WriteElementInt16(age,, 25);
            // Ends the document
            writer.WriteEndDocument();
        }
        catch (Exception e)
        {  
            Console.WriteLine (Exception: {0}, e.ToString());
        }
        return 0;
    }
}

package.GlobalVariables.AddGlobalVariable("MyVariable","MyValue");

Web Service方面的:
二十五、一个Web Service的小例子: <% @WebService Language=C# Class=TestWS %>

foreach(DTS.GlobalVariable GVar in package.GlobalVariables)

using System.Web.Services;

Console.WriteLine("Name : {0}tValue : {1}",GVar.Name,GVar.Value);

public class TestWS : System.Web.Services.WebService
{
    [WebMethod()]
    public string StringFromWebService()
    {
        return This is a string from web service.;
    }
}

}

catch(Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

package.UnInitialize();

}

Console.Read();

}

修改全局变量值语句:

package.GlobalVariables.Item("MyVariable").let_Value("Hello from C#");

以下语句将改动保存到dts包中。

package.SaveToStorageFile("C:\Pubs2Pubs2Package.dts","","",ref MIA,false);

执行包:

package.Execute();

本文由10bet手机官网发布于高并发,转载请注明出处:入门代码,为什么会有use

上一篇:没有了 下一篇:没有了
猜你喜欢
热门排行
精彩图文