public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}
public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(@"server=(localdb)\v11.0;database=Northwind;Integrated Security=true", SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}
public void DSDBWrapperTransSqlNoCommitTestBug1857()
{
Database db = new GenericDatabase(String.Format(@"server={0};database=Northwind;Integrated Security=true", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), SqlClientFactory.Instance);
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlCommand = "select * from [Order Details]";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
DataSet dsActualResult = db.ExecuteDataSet(dbCommand, transaction);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
newsid.Attributes["ref"] = Request.QueryString["id"];
string newsitem = "<div class='subitem top10 newsitem'><div class='delete-item'>DELETE</div><div class='top10 itemtitle'>~name~</div><div class='formitem top10'><label for='newstitle'>News Title</label><input name='' class='newstitle' value='~title~' /></div><div class='formitem top10'><label for='newstitle'>News Source</label><input name='' class='newssource' value='~source~' /></div><div class='formitem top10'><label for='newstitle'>News Date</label><input name='' class='newsdate' value='~date~' /></div><div class='top10'>Story Content</div><textarea class='leadin rtf top10' id='~newsid~'>~content~</textarea></div>";
string highlightitem = "<div class='subitem top10 highlightitem'><div class='delete-item'>DELETE</div><div class='top10 itemtitle'>~name~</div><div class='formitem top10'><label for='highlighttitle'>Highlight Title</label><input name='' class='highlighttitle' value='~title~' /></div><div class='formitem top10'><label for='highlightlink'>Highlight Link: Please put the full URL in this field including the 'http://'</label><input name='' class='highlightlink' value='~source~' /></div></div>";
Entry item = new Entry();
DataTable dtFB = null;
GenericDatabase db = new GenericDatabase(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, DbProviderFactories.GetFactory("MySql.Data.MySqlClient"));
DbCommand cmd = db.GetSqlStringCommand("Select * from media where id ='" + Request.QueryString["id"] + "'");
dtFB = db.ExecuteDataSet(cmd).Tables[0];
cmd.Dispose();
foreach (DataRow row in dtFB.Rows)
{
item.LeadIn = row["leadin"].ToString();
item.Count = row["newscount"].ToString();
item.NewItems = row["newsitem"].ToString();
item.HighlightItems = row["highlightitem"].ToString();
newsid.InnerText = row["name"].ToString();
}
leadin.Value = item.LeadIn;
List <News> newitems = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize <List <News> >(item.NewItems);
string tmp = "";
Int32 ctr = 1;
foreach (News x in newitems)
{
tmp += newsitem.Replace("~name~", "News " + ctr.ToString()).Replace("~title~", x.Title).Replace("~source~", x.Source).Replace("~date~", x.Date).Replace("~newsid~", "news" + ctr.ToString()).Replace("~content~", x.Content);
ctr++;
}
news.InnerHtml = tmp;
tmp = "";
List <Highlight> highitems = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize <List <Highlight> >(item.HighlightItems);
ctr = 1;
foreach (Highlight x in highitems)
{
tmp += highlightitem.Replace("~name~", "Highlight " + ctr.ToString()).Replace("~title~", x.Title).Replace("~source~", x.Source);
ctr++;
}
highlights.InnerHtml = tmp;
//leadin.Value = item.LeadIn;
storycount.Value = item.Count;
}
DataTable dtFBa = null;
GenericDatabase dba = new GenericDatabase(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, DbProviderFactories.GetFactory("MySql.Data.MySqlClient"));
DbCommand cmda = dba.GetSqlStringCommand("Select id, name from media order by id desc");
dtFBa = dba.ExecuteDataSet(cmda).Tables[0];
cmda.Dispose();
ListItem mn = new ListItem();
mn.Text = "Select Saved Email Template";
mn.Value = "0";
ddmenu.Items.Add(mn);
foreach (DataRow row in dtFBa.Rows)
{
mn = new ListItem();
mn.Text = row["name"].ToString();
mn.Value = row["id"].ToString();
ddmenu.Items.Add(mn);
}
}