من برای اتصال به بانک یه کلاس دارم که کل کد اون کلاس رو براتون می ذارم
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Xml;
namespace NobatMatab
{
class Data_Access
{
#region Connection
SqlConnection Con = new SqlConnection(@"Data Source= Taha-PC\Sqlexpress;initial catalog =DataBase;Uid =nobat;pwd =dell;");
#endregion
#region Connect
public void Connect()
{
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
}
#endregion
#region Dissconnect
public void Dissconnect()
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
#endregion
#region Command
public void Command(SqlCommand Com)
{
Com.Connection = Con;
Com.CommandType = CommandType.StoredProcedure;
Com.ExecuteNonQuery();
}
#endregion
#region Docommand
public DataTable Docommand(SqlCommand Com)
{
Com.Connection = Con;
Com.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(Com);
da.Fill(dt);
return dt;
}
#endregion
}
}