public static void Random_Set(string number, string pass)
{
try
{
string cmd = string.Format("EXEC dbo.Random2015_Set N'{0}', N'{1}'", number, pass);
ConnectionClass obj = new ConnectionClass();
obj.fillDataset(cmd);
}
catch { }
}
public static string Random_Get()
{
string result = "";
try
{
ConnectionClass obj = new ConnectionClass();
DataSet ds = obj.fillDataset("EXEC dbo.Random2015_Get");
foreach (DataRow dr in ds.Tables[0].Rows)
{
result += dr[0].ToString() + ",";
}
}
catch { }
if (result.EndsWith(",")) result = result.Remove(result.Length - 1);
return result;
}