The Source Code - Multilevel Security for Relational Databases - page 187

SqlCommand SqlCmd = new SqlCommand(SqlStr,
SqlConn);
SqlDataAdapter Adpt = new SqlDataAdapter(SqlCmd);
Adpt.Fill(DS, DT);
SqlConn.Close();
}
public static string DateFormate(string Date)
{
string [] dateMDY = Date.Split('/');
string DateDMY = dateMDY[1] + '/' + dateMDY[0]
+ '/' + dateMDY[2];
return DateDMY;
}
//
//Date:7/7/2009
//purpose:to convert from string to nullable int.
public static int? StringToNullableInt32(string s)
{int i;
if (Int32.TryParse(s, out i)) return i;
return null;
}
//
//Date:25/10/2008
//purpose:to Set data from database by excuting SQL
satment.
public static void SetData(string SqlStr)
{
string SqlConnStr = globals.ServerConnStr;
SqlConnection SqlConn = new
SqlConnection(SqlConnStr);
SqlConn.Open();
SqlCommand SqlCmd = new SqlCommand(SqlStr,
SqlConn);
SqlCmd.ExecuteNonQuery();
SqlConn.Close();
}
}
}
• Globals class
using System;
using System.Configuration ;
using System.Collections ;