1 reply to this topic

[Endiss]

Hi can u help me with this part of code i wanna delete whole row when session end and its not working for me idk why;/ cant use any Session[""] cuz its homework for my university;p

protected void Session_End(object sender, EventArgs e)

        {

                MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

                int id = 2;

                try

                {

                    MyConnection.Open();

                    string deleteString = "delete from users1 where Id = '" + id + "';";

                    MyCommand.CommandText = deleteString;

                    MyCommand.Connection = MyConnection;

                    MyCommand.ExecuteNonQuery();

                }

                finally

                {

                    if (MyConnection != null)

                    {

                        MyConnection.Close();

                    }

                } 

        }

sry wrong subforum-.- can admin move to asp.net?

Edited by Endiss, 25 May 2011 - 02:04 PM.
wrong subforum xD

[WingedPanther]

Moved.