[C#]Listbox e Database

[dwb]

Ecco a te:

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


namespace MyProject.UserHub
{
    public partial class EditActivityAccount : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
          
                if (Session["ActiveUserId"] == null)
                {
                    Response.Redirect("../Login.aspx");
                }
            
            else
            {
                string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
                string ActiveUserId = Session["ActiveUserId"].ToString();


                using (SqlConnection conn = new SqlConnection(connString))
                {
                    using (SqlCommand cmd = new SqlCommand("SELECT * FROM Locale WHERE UserId= @ActiveUserId", conn))
                    {
                        cmd.Parameters.AddWithValue("@ActiveUserId", ActiveUserId);
                        conn.Open();
                        SqlDataReader reader = cmd.ExecuteReader();




                        while (reader.Read())
                        {
                            r_Name.Text = reader["RefererName"].ToString();
                            r_Surname.Text = reader["RefererSurname"].ToString();
                            r_Mail.Text = reader["RefererMail"].ToString();
                            r_Phone.Text = reader["RefererPhone"].ToString();
                            r_Mobile.Text = reader["RefererMobilePhone"].ToString();
                            a_ActivityName.Text = reader["ActivityName"].ToString();
                            a_Website.Text = reader["Website"].ToString();
                            a_Paese.Text = reader["Paese"].ToString();
                            a_Cap.Text = reader["Cap"].ToString();
                            a_Description.Text = reader["Description"].ToString();
                            a_SmallDescription.Text = reader["SmallDescription"].ToString();
                            a_Phone.Text = reader["Phone"].ToString();
                            lblChiusura.Text = reader["Chiusura"].ToString();
                            Session["GiornoChiusura"] = reader["Chiusura"].ToString();
                        }


                    }


                }


                string ConnString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;


                using (SqlConnection chiusura = new SqlConnection(ConnString))
                {
                    using (SqlCommand cmdChiusura = new SqlCommand("SELECT * FROM Locale WHERE UserId=@ActiveUserId", chiusura))
                    {
                        string giornoChiusura ="-->" +  Session["GiornoChiusura"].ToString();
                        string ReplaceGiornoChiusura = giornoChiusura.Replace("-->", "");
                        
                        lstChiusura.DataBind();
                        cmdChiusura.Parameters.AddWithValue("@ActiveUserId", ActiveUserId);
                        chiusura.Open();
                       // lstChiusura.DataSource = cmdChiusura.ExecuteReader();
                       // lstChiusura.DataTextField = "Chiusura";
                       // lstChiusura.DataValueField = "Chiusura";
                       // lstChiusura.DataBind();
                        lstChiusura.Items.Insert(0,new ListItem(giornoChiusura, ReplaceGiornoChiusura,true));
                        if (giornoChiusura != "-->Lunedì")
                        {
                            lstChiusura.Items.Add(new ListItem("Lunedì", "Lunedì"));
                        }
                        if (giornoChiusura != "-->Martedì")
                        {
                            lstChiusura.Items.Add(new ListItem("Martedì", "Martedì"));
                        }
                        if (giornoChiusura != "-->Mercoledì")
                        {
                            lstChiusura.Items.Add(new ListItem("Mercoledì", "Mercoledì"));
                        }
                        if (giornoChiusura != "-->Giovedì")
                        {
                            lstChiusura.Items.Add(new ListItem("Giovedì", "Giovedì"));
                        }
                        if (giornoChiusura != "-->Venerdì")
                        {
                            lstChiusura.Items.Add(new ListItem("Venerdì", "Venerdì"));
                        }
                        if (giornoChiusura != "-->Sabato")
                        {
                            lstChiusura.Items.Add(new ListItem("Sabato", "Sabato"));
                        }
                        if (giornoChiusura != "-->Domenica")
                        {
                            lstChiusura.Items.Add(new ListItem("Domenica", "Domenica"));
                        }
                        if (giornoChiusura != "-->Sempre aperto")
                        {
                            lstChiusura.Items.Add(new ListItem("Sempre aperto", "Sempre aperto"));
                        }


                        //lstChiusura.Items.Insert(1, new ListItem("Lunedì", "Lunedì"));
                        //lstChiusura.Items.Insert(2, new ListItem("Martedì", "Martedì"));
                        //lstChiusura.Items.Insert(3, new ListItem("Mercoledì", "Mercoledì"));
                        //lstChiusura.Items.Insert(4, new ListItem("Giovedì", "Giovedì"));
                        //lstChiusura.Items.Insert(5, new ListItem("Venerdì", "Venerdì"));
                        //lstChiusura.Items.Insert(6, new ListItem("Sabato", "Sabato"));
                        //lstChiusura.Items.Insert(7, new ListItem("Domenica", "Domenica"));
                        //lstChiusura.Items.Insert(8, new ListItem("Sempre aperto", "Sempre aperto"));


                    }
                }
            }
        }


        protected void btn_Update_Click(object sender, EventArgs e)
        {
            string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            string ActiveUserId = Session["ActiveUserId"].ToString();
            string LastUpdate = DateTime.Now.ToShortTimeString();
            try
            {
                using (SqlConnection conn = new SqlConnection(connString))
                {
                    using (SqlCommand cmd = new SqlCommand("UPDATE Locale SET RefererName=@RefererName, RefererSurname=@RefererSurname, RefererMail=@RefererMail, LastUpdate=@LastUpdate WHERE UserId=@ActiveUser", conn))
                    {
                        cmd.Parameters.AddWithValue("@ActiveUser", ActiveUserId);
                        cmd.Parameters.AddWithValue("@LastUpdate", LastUpdate);
                        cmd.Parameters.AddWithValue("@RefererName", r_Name.Text.ToString());
                        cmd.Parameters.AddWithValue("@RefererSurname", r_Surname.Text.ToString());
                        cmd.Parameters.AddWithValue("@RefererMail", r_Mail.Text.ToString());
                        conn.Open();
                        int updateStatus = cmd.ExecuteNonQuery();
                        if (updateStatus != 0)
                        {
                            Response.Write("Dati correttamente aggiornati!");
                        }
                
                    }
                }
            }
            catch(Exception errCode)
            {
                Response.Write("Qualcosa è andato storto: " + errCode.ToString());
            }
        }
    }
}