using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; using ParameterPasser; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["Localhost"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ucitajNovosti(); } } private void ucitajNovosti() { //string novostId = null; //string datum = null; //string slika = null; //string naslov = null; //string sazetak = null; // ArrayList news_arr = new ArrayList(); // //OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//premfs16/sites/premium16/tstefan/database/news.mdb"); OleDbConnection aConnection = new OleDbConnection(connStr); OleDbCommand aCommand = new OleDbCommand("SELECT TOP 4 * FROM HA_UcitajNovosti", aConnection); aConnection.Open(); OleDbDataReader aReader = aCommand.ExecuteReader(); while (aReader.Read()) { news_arr.Add(new NewsData( aReader["NovostId"].ToString(), Server.UrlDecode(aReader["Datum"].ToString()), Server.UrlDecode( aReader["Slika"].ToString()), Server.UrlDecode( aReader["Naslov"].ToString()), Server.UrlDecode( aReader["Sazetak"].ToString()) )); // } // // aConnection.Close(); Repeater1.DataSource = news_arr; Repeater1.DataBind(); // } public class NewsData { private string novostId; private string datum; private string slika; private string naslov; private string sazetak; public NewsData(string novostId, string datum, string slika, string naslov, string sazetak) { this.novostId = novostId; this.datum = formatDatum(datum); this.slika = slika; this.naslov = naslov; this.sazetak = sazetak; } private string formatDatum(string datum) { string datumFormat = null; // datumFormat = datum.Remove(datum.Length - 8, 8); // return datumFormat; } public string NovostId { get { return novostId; } } public string Datum { get { return datum; } } public string Slika { get { return slika; } } public string Naslov { get { return naslov; } } public string Sazetak { get { return sazetak; } } } protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { } protected void Repeater2_ItemCommand(object source, RepeaterCommandEventArgs e) { } public void RaisePostBackEvent(string eventArgument) { SessionParameterPasser sessionWrapper = new SessionParameterPasser("novosti.aspx"); sessionWrapper["novostiId"] = eventArgument; sessionWrapper.PassParameters(); } }