Database

SELECT 
db1.dbo.table1.ID as ID, 
db1.dbo.table1.Field1 as Field1, 
db2.dbo.table2.Field2 as Field2, 
( SELECT Amount FROM db1.dbo.SP_Calculate(db1.dbo.table1.ID) ) As Amount

FROM db1.dbo.table1

INNER JOIN db2.dbo.table2
ON db1.dbo.table1.ID = db2.dbo.table2.ID

update JOB <br />
	set JOB_STEP = @nextStep<br />
	where<br />
	(<br />
		(@nextStep <> '20' AND @nextStep <> '100')<br />
		OR<br />
		(<br />
			(@nextStep = '20' OR @nextStep = '100')<br />
			AND<br />
			NOT EXISTS<br />
(<br />
			select * from LAUNCH_STATISTICS<br />
			where <br />
			(JOB_STEP = '20' OR JOB_STEP = '100')<br />
			and JOB_ID <> @jobId<br />
			)<br />
		)<br />
	)<br />
	and JOB_ID = @jobId;

configMap =
   new ExeConfigurationFileMap { ExeConfigFilename = "ToolHistoryServer.exe.config" };
myCfg =
   ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None);
dataSource = myCfg.AppSettings.Settings["DataSource"].Value;
cnStr = "Data Source='" + dataSource + "';" +
        "Trusted_Connection=true;" +
        "Database=ToolHistory";

<?xml version="1.0" encoding="utf-8"?>
<configuration>
   <appSettings>
      <add key="DataSource" value="NIGEL-PC\\SQLEXPRESS" />
   </appSettings>
   <system.runtime.remoting>
    <application>
      <channels>
        <channel ref="tcp" port="50050" />
      </channels>
    </application>
  </system.runtime.remoting>
</configuration>

<code>
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace EasyStorePro
{
    public partial class LoginForm : Form
    {
        public LoginForm()
        {
            InitializeComponent();
        }

        private void btnLogin_Click(object sender, EventArgs e)
        {
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();

            conn.ConnectionString = "Data Source=KADAEN-PC\\SQLEXPRESS;Initial Catalog=EasyStorePro;Persist Security Info=True;User ID=************;Password=**********";
            string str = ("SELECT username,password FROM dbo.Login WHERE username='"+ tbUsername + "' and password='"+ mtbPassword +"'");

            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(str, conn);

            conn.Open();

            DataTable dt = new DataTable();
            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);

            da.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                MessageBox.Show("Welcome");
            }
            else
            {
                MessageBox.Show("Invalid Entry");
            }

            conn.Close();
        }
    }
}

</code>