ASP.NET

saravanan05 wrote:

how to change the code in asp to asp.net

<br />
using System;<br />
using System.Data;<br />
using System.Web;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
<br />
public partial class _Default : System.Web.UI.Page <br />
{<br />
    Cls_DBtier Cls_DBtierobj = new Cls_DBtier();<br />
    int i = 0;<br />
    DataTable dt;<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        <br />
        Cls_DBtierobj.mvar_DBConnectionstring = Application["Connection_String"].ToString();<br />
        Cls_DBtierobj.OpenConnection();<br />
        dt = Cls_DBtierobj.getNames();<br />
        i = dt.Rows.Count;<br />
        Cls_DBtierobj.CloseConnection();<br />
        LblNames.Text = dt.Rows[0][0].ToString();<br />
        <br />
    }<br />
    protected void BtnNxt_Click(object sender, EventArgs e)<br />
    {<br />
        int index = Convert.ToInt32(HidIndex.Value);<br />
        if (index < i-1)<br />
        {<br />
            index = index + 1;<br />
            HidIndex.Value = index.ToString();<br />
            LblNames.Text = dt.Rows[index][0].ToString();<br />
        }<br />
    }<br />
}<br />

<br />
using System;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
using System.Web;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
<br />
public class Cls_DBtier<br />
{<br />
    public string mvar_DBConnectionstring;<br />
    SqlConnection conn;<br />
    public void OpenConnection()<br />
    {<br />
        conn = new SqlConnection(mvar_DBConnectionstring);<br />
    }<br />
    public void CloseConnection()<br />
    {<br />
        conn.Close();<br />
    }<br />
    public SqlCommand ReturnSqlCommand(string sqlStmt)<br />
    {<br />
        SqlCommand Cmd;<br />
        try<br />
        {<br />
            Cmd = new SqlCommand();<br />
            Cmd.Connection = conn;<br />
            Cmd.CommandType = CommandType.Text;<br />
            Cmd.CommandText = sqlStmt;<br />
            return Cmd;<br />
        }<br />
        finally<br />
        {<br />
            Cmd = null;<br />
        }<br />
    }<br />
    public DataTable getNames()<br />
    {<br />
        string stt = "SELECT ename FROM employee";<br />
        SqlDataAdapter SAdaptor;<br />
        SqlCommand Cmd;<br />
        DataSet ds=new DataSet();<br />
        DataTable dt;<br />
        try<br />
        {<br />
            Cmd=ReturnSqlCommand(stt);<br />
            SAdaptor = new SqlDataAdapter(Cmd);<br />
            SAdaptor.Fill(ds);<br />
            dt = ds.Tables[0];<br />
            return dt;<br />
        }<br />
        finally<br />
        {<br />
            stt = null;<br />
            SAdaptor = null;<br />
            Cmd = null;<br />
            ds = null;<br />
            dt = null;<br />
        }<br />
    }<br />
}<br />

DataSet result = null;<br />
<br />
						//Kommune<br />
<br />
						result = userBll.GetKommunes();<br />
<br />
						cbKommune.Items.Clear();<br />
						cbKommune.DataSource = result;<br />
						cbKommune.DataTextField = "KOMMUNE_NAVN";<br />
						cbKommune.DataValueField = "KOMMUNE_NR";<br />
						cbKommune.DataBind();<br />
						cbKommune.Items.Insert(0,new ListItem(captions.GetString("PleaseSelectKommune"),"0"));