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; }