mosadatta
سه شنبه 18 تیر 1392, 14:05 عصر
با سلام چطور یک متد برای اجرای پروسیجر پارامتر دار در کلاس data access تعریف کنیم؟؟؟؟؟؟
این هم کلاس data access:::
class DataAccess
{ public string DBName = "DBletter.mdf";
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 DBName = "DBletter.mdf";
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();
}
}