public ActionResult Product3()
{
string sql = "select top 30 * from Product";
var db = new CoreHelper.SqlHelper(System.Configuration.ConfigurationManager.ConnectionStrings["default"].ConnectionString);
var dt = db.ExecDataTable(sql);
dt = null;
return(Content("ok"));
}
public static CoreHelper.SqlHelper CreateDbHelper(string name)
{
//默认在网站根目录/DBConnection,如果没有,则在D盘找
string connString = CoreHelper.CustomSetting.GetConnectionString(name);
var m = System.Text.RegularExpressions.Regex.Match(connString, @"Source\s*\=(.+?);", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
string server = m.Groups[1].ToString().ToLower();
if (!CoreHelper.RequestHelper.IsRemote)
{
if (server.IndexOf("192.168.") == -1 && server.IndexOf("127.0.") == -1 && server.IndexOf("localhost") == -1)
{
throw new Exception("本地程序不能调用网上数据库:" + server);
}
}
var help = new CoreHelper.SqlHelper(connString);
return help;
}
public static CoreHelper.SqlHelper CreateDbHelper(string name)
{
//默认在网站根目录/DBConnection,如果没有,则在D盘找
string connString = CoreHelper.CustomSetting.GetConnectionString(name);
var m = System.Text.RegularExpressions.Regex.Match(connString, @"Source\s*\=(.+?);", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
string server = m.Groups[1].ToString().ToLower();
if (!CoreHelper.RequestHelper.IsRemote)
{
if (server.IndexOf("192.168.") == -1 && server.IndexOf("127.0.") == -1 && server.IndexOf("localhost") == -1)
{
throw new Exception("本地程序不能调用网上数据库:" + server);
}
}
var help = new CoreHelper.SqlHelper(connString);
return(help);
}
