چگونه به بهترین نحو برنامه تحت وبمو بنویسم

[ehsan2007]

سلام به همه دوستان برنامه نویس عزیز
کد زیریک کلاسه که اطلاعاتو از دو جدول بانک میخونه و مثل قالب یک وبلاگ جایگزاری میکنه مطالبو
لطفا بگید اینجوری کد سمت سرور نوشتن مشکلی که نداره
و ایراد اگه داره چه کارایی باید بکنم که مشکلاتش برطرف بشه


using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
///<summary>
/// Summary description for Class1
///</summary>
publicclassClass1
{
privateint tedadpost = 0;
publicstring backhomecod()
{
string code = String.Empty;
SqlConnection Cnn = newSqlConnection(System.Configuration.Configuratio nManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand Cmd = newSqlCommand("SELECT id, cod, tedadpost FROM reqestcod WHERE(id = N'khabar')", Cnn);
SqlDataReader DR = null;
try
{
Cmd.Connection.Open();
DR = Cmd.ExecuteReader();
DR.Read();
code = DR["cod"].ToString();
tedadpost = int.Parse(DR["tedadpost"].ToString());
}
catch (SqlException)
{
}
catch (Exception)
{
}
finally
{
if (DR != null) DR.Close();
Cnn.Close();
}
return code;
}

publicint endidofpost()
{
int k = 0;
SqlConnection Cnn = newSqlConnection(System.Configuration.Configuratio nManager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand Cmd = newSqlCommand("SELECT TOP 1 id FROM postkhabar ORDER BY id DESC", Cnn);
SqlDataReader DR = null;
try
{
Cmd.Connection.Open();
DR = Cmd.ExecuteReader();
DR.Read();
k = int.Parse(DR["id"].ToString());
}
catch (SqlException)
{
}
catch (Exception)
{
}
finally
{
if (DR != null) DR.Close();
Cnn.Close();
}
return k;
}




publicstring insertcod(int safe)
{
int safe2 = safe;
safe -= 1;
string ghaleb = backhomecod();
string khabarcod = String.Empty;
int a = endidofpost();
SqlConnection Cnn = newSqlConnection(System.Configuration.Configuratio nManager.ConnectionStrings["ConnectionString"].ConnectionString);
safe *= tedadpost; safe = a - safe;
SqlCommand Cmd = newSqlCommand("SELECT id, mozo, khabar, frestande, data, edamekhabar, nazarat FROM postkhabar WHERE (id > " + (safe - tedadpost).ToString() + " AND id < = " + safe.ToString() + ") ORDER BY id DESC", Cnn);
SqlDataReader DR = null;
try
{
Cmd.Connection.Open();
DR = Cmd.ExecuteReader();
while (DR.Read())
{
khabarcod += ghaleb;
khabarcod = khabarcod.Replace("[mozo]", DR["mozo"].ToString());
khabarcod = khabarcod.Replace("[khabar]", DR["khabar"].ToString());
if (DR["edamekhabar"].ToString() == "y") { khabarcod = khabarcod.Replace("[edamekhabar]", "<a href='#' onclick='backedame(" + DR["id"] + ",0,1);'>ں§ںêى êلé </a>"); }
if (DR["edamekhabar"].ToString() == "n") { khabarcod = khabarcod.Replace("[edamekhabar]", "&nbsp;"); }
khabarcod = khabarcod.Replace("[frestande]", DR["frestande"].ToString());
khabarcod = khabarcod.Replace("[data]", DR["data"].ToString());
khabarcod = khabarcod.Replace("[nazarat]", DR["nazarat"].ToString());
}
string k = null;
if (safe2 == 1 || a > tedadpost) { k = "<div id='div16'></div><div id='div17'><a href='#' onclick='page(" + (safe2 + 1).ToString() + ")'> م§ی>></a></div>"; }
if (safe2 > 1 ) {
if ((safe2-1) == (a / tedadpost)) { k = "<div id='div16'><a href='#' onclick='page(" + (safe2 - 1).ToString() + ")'><<ç éی</a></div><div id='div17'></div>"; }
else
{
k = "<div id='div16'><a href='#' onclick='page(" + (safe2 - 1).ToString() + ")'><<ç éی</a></div><div id='div17'><a href='#' onclick='page(" + (safe2 + 1).ToString() + ")'> م§ی>></a></div>";
}
}
khabarcod += "<div class='safe'>[page]</div>";
khabarcod = khabarcod.Replace("[page]", k);
}
catch (SqlException)
{
}
catch (Exception)
{
}
finally
{
if (DR != null) DR.Close();
Cnn.Close();
}
return khabarcod;
}
}