mosadatta
سه شنبه 18 تیر 1392, 22:25 عصر
با سلام چطور یک متد برای اجرای پروسیجر پارامتر دار در کلاس data access تعریف کنیم؟؟؟؟؟؟
این هم کلاس data access
class DataAccess
{
//public string ServerName;
public string DBName = "DBletter.mdf";
//public string username;
//public string password;
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter da;
public DataAccess()
{
con = new SqlConnection();
cmd = new SqlCommand();
da = new SqlDataAdapter();
cmd.Connection = con;
da.SelectCommand = cmd;
}
public void connect()
{
string cs = "Data source=.\\SQLEXPRESS;Initial Catalog={0};Integrated security=true;user Instance=true";
cs = string.Format(cs, this.DBName);
con.ConnectionString = cs;
con.Open();
}
public void Disconnect()
{
con.Close();
}
public DataTable select(string sql)
{
DataTable dt = new DataTable();
cmd.CommandText = sql;
da.Fill(dt);
return dt;
}
public void docommand(string sql)
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
:::
این هم کلاس data access
class DataAccess
{
//public string ServerName;
public string DBName = "DBletter.mdf";
//public string username;
//public string password;
SqlConnection con;
SqlCommand cmd;
SqlDataAdapter da;
public DataAccess()
{
con = new SqlConnection();
cmd = new SqlCommand();
da = new SqlDataAdapter();
cmd.Connection = con;
da.SelectCommand = cmd;
}
public void connect()
{
string cs = "Data source=.\\SQLEXPRESS;Initial Catalog={0};Integrated security=true;user Instance=true";
cs = string.Format(cs, this.DBName);
con.ConnectionString = cs;
con.Open();
}
public void Disconnect()
{
con.Close();
}
public DataTable select(string sql)
{
DataTable dt = new DataTable();
cmd.CommandText = sql;
da.Fill(dt);
return dt;
}
public void docommand(string sql)
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
:::