Delete All Rows in SQL Table on Page Load

Asked Feb 05 '15 at 15:52

Active Feb 05 '15 at 15:58

Viewed 223 times

I am loading data from an excel sheet into a SQL table and then joining that data to another table with a script. On Page Load of my program I would like to delete all rows from my "temp" table. I am currently doing this, but it is not working at all. By not working I mean nothing happens. No errors, but also it does not delete anything from my table. I set a breakpoint on the if and it doesnt even hit the break point.

 protected void Page_Load(object sender, EventArgs e)
    {
      if (!IsPostBack)
        {
            SqlConnection sqlConn1;
            String strConnString1 = ConfigurationManager.ConnectionStrings["MyConnection"].ToString();
            sqlConn1 = new SqlConnection(strConnString1);

            string cleartQuery = "Truncate Table [My Table]";
            SqlCommand sqlCmdSelect = new SqlCommand(cleartQuery, sqlConn1);
            sqlCmdSelect.Connection.Open();
            sqlCmdSelect.ExecuteNonQuery();
            sqlCmdSelect.Connection.Close();
        }
     }

edited Feb 05 '15 at 15:58

asked Feb 05 '15 at 15:52

codeFinatic

1

Why doesn't it work? What happens when you run it? Do you see any error messages? – Simon Farshid Feb 05 '15 at 15:55
Please describe what "not working at all" means in much greater detail. That can mean anything between and including compilation errors to unexpected behavior. – tnw Feb 05 '15 at 15:55
By not working, nothing happen. No errors, but also it does not delete anything from my table. I set a breakpoint on the "if" and it doesnt even hit the break point. – codeFinatic Feb 05 '15 at 15:57
Could you show your connectionstring? Do you use the |DataDirectory| substitution string and AttachDbFileName? – Steve Feb 05 '15 at 16:00
You should drop and recreate your table is faster – R Quijano Feb 05 '15 at 16:36
When you set the breakpoint, does it stay a solid red circle, or does it become an outline? – Keith Payne Feb 05 '15 at 16:46
It stays a solid red circle – codeFinatic Feb 05 '15 at 21:20

Delete All Rows in SQL Table on Page Load

0 Answers0