namespace SampleConnectDB
{
/// <summary>
/// ConnectDatabase の概要の説明です。
/// </summary>
public class ConnectDatabase
{
private string strConn ;
private string strUserID = string.Empty;
private string strPassWord = string.Empty;
private string strDataBase = string.Empty;
private string strServerAddress = string.Empty;
private int strTimeOut = 0;
private string strError = null;
private SqlConnection myConnection;
private SqlCommand myCmd;
private SqlDataAdapter da;
private DataTable dt;
public ConnectDatabase()
{
//
// TODO: コンストラクタ ロジックをここに追加してください。
//
}
/// <summary>
/// Template
/// </summary>
public void hoge()
{
}
/// <summary>
/// ログインユーザ
/// </summary>
public string UserID
{
set { strUserID = value;}
}
/// <summary>
/// パスワード
/// </summary>
public string PassWord
{
set { strPassWord = value;}
}
/// <summary>
/// 接続データベース名
/// </summary>
public string DataBase
{
set { strDataBase = value;}
}
/// <summary>
/// サーバアドレス
/// </summary>
public string ServerAddress
{
set { strServerAddress = value;}
}
/// <summary>
/// 接続待ち時間
/// </summary>
public int TimeOut
{
set { strTimeOut = value;}
}
/// <summary>
/// DBを開く
/// </summary>
public DataTable ExecSearchSQL(string strSQL)
{
try
{
strConn = "user id=" + strUserID + ";"
+ "password=" + strPassWord + ";"
+ "initial catalog=" + strDataBase + ";"
+ "data source=" + strServerAddress + ";"
+ "Connect Timeout=" + strTimeOut.ToString() + ";"
;
myConnection = new SqlConnection(strConn);
myConnection.Open();
myCmd = new SqlCommand(strSQL,myConnection);
da = new SqlDataAdapter();
da.SelectCommand = myCmd;
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0];
myConnection.Close();
}
catch(ArgumentException e)
{
strError = e.ToString();
}
catch(Exception e2)
{
strError = e2.ToString();
}
return dt;
}
}
}
|