Database

try
       {
           //Start the SSIS Here
           Application app = new Application();
           Package package = null;
           package = app.LoadPackage(@"D:\Program Files\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);
           //@"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);

           Variables vars = package.Variables;

           vars["Time1"].Value = time;

           vars["Time2"].Value = time;

           vars["Time3"].Value = time;

           vars["TTBLTYPE"].Value = THREAD_DATA[1].ToString();

           //package.Connections["SQLNCLI10.1"].ConnectionString = obj.GetConnectionString(THREAD_DATA[0].ToString());
           //Excute Package
           Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

           if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
           {
               foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors)
               {

                   Console.WriteLine("Package Execution results: {0}", local_DtsError.Description.ToString());
                   Console.WriteLine();
               }
           }

       }
       catch (DtsException ex)
       {
           Exception = ex.Message;
       }

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)

"SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available.  Source:\"Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E4D  Description:  "Login failed for user 'sa'

Imports Microsoft.SqlServer.Management.Smo.SmoApplication

Dim dtServer As DataTable = EnumAvailableSqlServers(False)

using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.OleDb ;<br />
<br />
namespace studentManagementSystem1<br />
{<br />
    public partial class StudentDetails : Form<br />
    {<br />
         public OleDbCommand cmd;<br />
         public OleDbConnection con;<br />
        <br />
        string connectionString, query;<br />
               public StudentDetails()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
<br />
        <br />
        private void StudentDetails_Load(object sender, EventArgs e)<br />
        {<br />
            <br />
            // TODO: This line of code loads data into the 'studmanageDataSet.master' table. You can move, or remove it, as needed.<br />
            this.masterTableAdapter.Fill(this.studmanageDataSet.master);<br />
<br />
                       connectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\studentManagementSystem1\studmanage.mdb";<br />
            <br />
          }<br />
        <br />
        private void btnAdd_Click(object sender, EventArgs e)<br />
        {<br />
             <br />
           <br />
            int rows;<br />
<br />
            <br />
            query = "INSERT INTO master(RegNo,Name)VALUES(@RegNo,@Name)";<br />
            <br />
            cmd = new OleDbCommand(query, con);<br />
            <br />
           cmd.Parameters.AddWithValue("@RegNo", txtRegNo.Text );<br />
            cmd.Parameters.AddWithValue("@Name", txtName.Text );<br />
<br />
<br />
           <br />
            try<br />
            {<br />
               <big>con.Open(); </big>                <br />
                rows = cmd.ExecuteNonQuery();<br />
                if (rows > 0)<br />
               {<br />
                   MessageBox.Show("records inserted successfully");<br />
                }<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                MessageBox.Show(ex.Message);<br />
            }<br />
            finally<br />
            {<br />
                con.Close();<br />
            }<br />
        }<br />
<br />
        private void btnEdit_Click(object sender, EventArgs e)<br />
        {<br />
<br />
        }<br />
<br />
       <br />
<br />
<br />
    }<br />
}