Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
738 Points
452 Posts
Apr 13, 2012 11:09 AM|LINK
you can read more here : http://www.asp.net/web-pages/tutorials/data/5-working-with-data and could use this code to enter news articles into the db :
@{ Layout = ""; Page.Title = ""; var db = Database.Open("dbname"); var Title = Request["Title"]; var Content = Request["Content"]; var Date = Request["Date"]; if (IsPost) { var insertQuery = "INSERT INTO newsarticles (Title, Content, Date) " + "VALUES (@0, @1, @2)"; db.Execute(insertQuery, Title, Content, Date); } } <h2>Add news Articles</h2> <form method="post" action=""> <div> <p>Date: <input name="Date" type="text" size="30" value="@Date" /> </p> <p>Title: <textarea name="Title" rows="3" cols="74">@Title</textarea> </p> <p> Content: <textarea name="Content" rows="14" cols="74">@Content</textarea> </p> <input type="submit" value="Add" /> </div> </form>
And use this new page to display :
@{ Layout = ""; Page.Title = ""; var pageSize = 10; var totalPages = 0; var count = 0; var page = UrlData[0].IsInt() ? UrlData[0].AsInt() : 1; var offset = (page -1) * pageSize; var db = Database.Open("dbname"); var sql = @"SELECT Count(*) FROM newsarticles "; count = (int)db.QueryValue(sql); totalPages = count/pageSize; if(count % pageSize > 0){ totalPages += 1; } sql = "SELECT Title, Content, Date FROM newsarticles" + "ORDER BY Id DESC OFFSET @0 ROWS FETCH NEXT @1 ROWS ONLY;"; var result = db.Query(sql, offset, pageSize); } <h2>News Articles</h2> @foreach(var row in result){ <p>@row.Date<br/> <strong>@row.Title</strong><br/> @Html.Raw(row.Content.Replace("\n", "<br />")) </p> } <p> @{ for (var i = 1; i < totalPages + 1; i++){ <a href="/informations/@i">@i</a> } } <span class="alignRight"> Page @page / @totalPages</span> </p>
You can keep line breaks by using
@Html.Raw(row.Content.Replace("\n", "<br />"))
dow7
Member
738 Points
452 Posts
Re: paste news article from word and save in db
Apr 13, 2012 11:09 AM|LINK
you can read more here : http://www.asp.net/web-pages/tutorials/data/5-working-with-data and could use this code to enter news articles into the db :
@{ Layout = ""; Page.Title = ""; var db = Database.Open("dbname"); var Title = Request["Title"]; var Content = Request["Content"]; var Date = Request["Date"]; if (IsPost) { var insertQuery = "INSERT INTO newsarticles (Title, Content, Date) " + "VALUES (@0, @1, @2)"; db.Execute(insertQuery, Title, Content, Date); } } <h2>Add news Articles</h2> <form method="post" action=""> <div> <p>Date: <input name="Date" type="text" size="30" value="@Date" /> </p> <p>Title: <textarea name="Title" rows="3" cols="74">@Title</textarea> </p> <p> Content: <textarea name="Content" rows="14" cols="74">@Content</textarea> </p> <input type="submit" value="Add" /> </div> </form>And use this new page to display :
@{ Layout = ""; Page.Title = ""; var pageSize = 10; var totalPages = 0; var count = 0; var page = UrlData[0].IsInt() ? UrlData[0].AsInt() : 1; var offset = (page -1) * pageSize; var db = Database.Open("dbname"); var sql = @"SELECT Count(*) FROM newsarticles "; count = (int)db.QueryValue(sql); totalPages = count/pageSize; if(count % pageSize > 0){ totalPages += 1; } sql = "SELECT Title, Content, Date FROM newsarticles" + "ORDER BY Id DESC OFFSET @0 ROWS FETCH NEXT @1 ROWS ONLY;"; var result = db.Query(sql, offset, pageSize); } <h2>News Articles</h2> @foreach(var row in result){ <p>@row.Date<br/> <strong>@row.Title</strong><br/> @Html.Raw(row.Content.Replace("\n", "<br />")) </p> } <p> @{ for (var i = 1; i < totalPages + 1; i++){ <a href="/informations/@i">@i</a> } } <span class="alignRight"> Page @page / @totalPages</span> </p>You can keep line breaks by using
@Html.Raw(row.Content.Replace("\n", "<br />"))