Hi, I write News Script:
Write news skript, but how maket that - Whent I push "Read Full News" show full news? Some like that: http://blogs.msdn.com/
Sorry, for bad English
My script
--------------------------------------------------------------------------------
Show News:
--------------------------------------------------------------------------------
----------------------------
Thanks
Write news skript, but how maket that - Whent I push "Read Full News" show full news? Some like that: http://blogs.msdn.com/
Sorry, for bad English
My script
Code:
protected void Button1_Click(object sender, EventArgs e)
{
if (NewsName.Text == "") { LaukasTuscias.Text = "Irasykit naujienos varda"; } //Please write News Name
if (ShortNews.Text == "") { LaukasTuscias.Text = "Irasykit trumpa naujienos versija"; } //Please write Short news
if (FullNews.Text == "") { LaukasTuscias.Text = "Irasykit pilna versija"; } //Please write Full news
if (NewsName.Text == "" || ShortNews.Text == "" || FullNews.Text == "") { dbKlaida.Text = "Klaida, palikot tusciu laukeliu"; } //Error, blank is empty
else
{
SqlConnection conn;
SqlCommand comm;
String connectionString =
ConfigurationManager.ConnectionStrings[
"Dorknozzle"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand(
"INSERT INTO News (NameNews, ShortNews, FullNews, Author) " +
"VALUES (@NameNews, @ShortNews, @FullNews, @Author)", conn);
comm.Parameters.Add("@Author",
System.Data.SqlDbType.NChar, 20);
comm.Parameters["@Author"].Value = "Dzimis";
comm.Parameters.Add("@NameNews",
System.Data.SqlDbType.Text);
comm.Parameters["@NameNews"].Value = NewsName.Text;
comm.Parameters.Add("@ShortNews",
System.Data.SqlDbType.Text);
comm.Parameters["@ShortNews"].Value = ShortNews.Text;
comm.Parameters.Add("@FullNews",
System.Data.SqlDbType.Text);
comm.Parameters["@FullNews"].Value = FullNews.Text;
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
dbKlaida.Text = "Neprisijunge prie duomenu bazes!<br />" + ex.Message; //Error, don't connect to DB
}
finally
{
conn.Close();
}
dbKlaida.Text = "Duomenys issiusti"; //All Ok
NewsName.Text = ""; //Clear TextBox
ShortNews.Text = "";
FullNews.Text = "";
}
}
Show News:
--------------------------------------------------------------------------------
Code:
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
String connectionString = ConfigurationManager.ConnectionStrings["Dorknozzle"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT Author, ShortNews, ID FROM News", conn);
try
{
conn.Open();
reader = comm.ExecuteReader();
NewsList.DataSource = reader;
NewsList.DataBind();
reader.Close();
}
catch (Exception ex)
{
dbKlaida.Text = "Klaida, Neprisijungė prie Duomenų bazės!<br />" + ex.Message; //Error
}
finally
{
conn.Close();
}
}
Code:
<body>
<form id="form1" runat="server">
<asp:DataList id="NewsList" runat="server">
<ItemTemplate>
Author: <strong><%#Eval("Author")%></strong><br />
Short News: <strong><%#Eval("ShortNews")%></strong><br />
<a><center>Read Full News</center></a>
</ItemTemplate>
<SeparatorTemplate>
<hr />
</SeparatorTemplate>
<SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#E3EAEB" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
</asp:DataList>
<asp:Label ID="dbKlaida" runat="server" Text=""></asp:Label>
</form>
</body>
Comment