Change Entity framework code to C# for retrieving data from Database in ASP.Net

---

Hi nedash,

The provided code is already in C# with entity. So how can we convert a C# code to C#.

---

sorry that was my fault it is ADO.net I want change it to sql mode like: using (SqlConnection conn = General.GetConnection()) { using (SqlCommand _cmd = General.GetCommand("Downloadurl_insert", conn)) { conn.Open(); _cmd.Parameters.AddWithValue("@downloadTitle", LblName.Text); _cmd.Parameters.AddWithValue("@url", "~/downloads/"+ LblName.Text+".rar"); //_cmd.Parameters.AddWithValue("@ExpiryDate","2017-5-16"); _cmd.Parameters.AddWithValue("@DownloadToken", GetDownloadToken(10)); //_cmd.Parameters.AddWithValue("@ExpireAfterDownload", Chk1.Checked); _cmd.Parameters.AddWithValue("@Hits", "0"); _cmd.Parameters.AddWithValue("@Downloaded", "false"); _cmd.ExecuteNonQuery(); }

---

Hi nedash,

I have modified in your code.So please refer the below code.

C#

private string constring = ConfigurationManager.ConnectionStrings["constring"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
    this.GetRecord();
}

private void GetRecord()
{
    string downloadtoken = Page.RouteData.Values["downloadtoken"].ToString();
    SqlConnection con = new SqlConnection(constring);
    SqlCommand cmd = new SqlCommand("SELECT * FROM download WHERE DownloadToken='" + downloadtoken + "'", con);
    DataTable dt = new DataTable();
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    sda.Fill(dt);
    if (dt.Rows.Count > 0)
    {
        if (dt.Rows[0]["ExpireAfterDownload"].ToString().ToUpper() == "TRUE")
        {
            if (dt.Rows[0]["Downloaded"].ToString().ToUpper() == "TRUE")
            {
                Response.Redirect("~/DownloadError.aspx");
            }
        }
        else
        {
            if (Convert.ToDateTime(dt.Rows[0]["ExpiryDate"].ToString()) < DateTime.Now)
            {
                Response.Redirect("~/DownloadError.aspx");
            }
        }
        string path = Server.MapPath(dt.Rows[0]["Url"].ToString());
        FileStream fs = File.OpenRead(path);
        byte[] fileData = new byte[fs.Length];
        fs.Read(fileData, 0, (int)fs.Length);
        Response.Clear();
        Response.AddHeader("Content-Type", "application/zip");
        Response.AddHeader("Content-Disposition", "inline;filename=" + Path.GetFileName(path));
        Response.BinaryWrite(fileData);
        Response.Flush();
        Response.Close();
        if (dt.Rows[0]["ExpireAfterDownload"].ToString().ToUpper() == "TRUE")
        {
            dt.Rows[0]["Downloaded"] = "true";
            dt.Rows[0]["Hits"] = Convert.ToInt32(dt.Rows[0]["Hits"]) + 1;
            dt.AcceptChanges();
        }
    }
}