Database Reference
In-Depth Information
namespace GlobalClasses
{
public class DBOperations
{
public DBOperations()
{
}
//
//Date:6/4/2008
//purpose:to Check user name and password of user
public static void SqlConn(string Server, string
User, string Pass) {globals.ServerConnStr
= “Data Source = “ + Server + “;Initial
Catalog = MLSDB;User Id = “ + User +
“;Password = “ + Pass + “;”;}
//
//Date:25/10/2008
//purpose:to get data from database by excuting SQL
satment.
public static DataSet GetData(string SqlStr)
{
DataSet ds = new DataSet();
string SqlConnStr = globals.ServerConnStr;
SqlConnection SqlConn = new
SqlConnection(SqlConnStr);
SqlConn.Open();
SqlCommand SqlCmd = new SqlCommand(SqlStr,
SqlConn);
SqlDataAdapter Adpt = new SqlDataAdapter(SqlCmd);
Adpt.Fill(ds);
SqlConn.Close();
return ds;
}
//
//Date:21/7/2009
//purpose:to fill data table in dataset by excuting
SQL statement.
public static void FillDataSet(ref DataSet DS,
string DT, string SqlStr)
{
string SqlConnStr = globals.ServerConnStr;
SqlConnection SqlConn = new
SqlConnection(SqlConnStr);
SqlConn.Open();
Search WWH ::




Custom Search