problem with insert statement in asp.net

[arial]

I have two problem.

1) My insert statement here is not working.

It is not inserting value into the database. I am not getting any error message but I can not figured out why it is not inserting the value into database.

Please help me it is very urgent.

Thank You,

int max = 0;
            sqidate = DateTime.Now.ToString("yyMM");
            Response.Write("Today's date is:" +sqidate);
            int qdate = Convert.ToInt32(sqidate);
            SqlCommand qicmd = new SqlCommand();
            //SqlDataReader qireader = new SqlDataReader();
            qicmd.Connection = sqlConnection1;
            qicmd.Connection.Open();
            qicmd.CommandText = " select QI_TRACK from gingercqi where QI_TRACK like '"+qdate+"%' ";
            qicmd.ExecuteNonQuery();
            SqlDataReader qireader = qicmd.ExecuteReader();
 
            int temp = -1;
 
            if(!qireader.Read())
            {
                txtqitrack.Text = sqidate + 01;    
                qicmd.CommandText = "insert into gingercqi(QI_TRACK) values ('"+txtqitrack.Text+"')";
            }
 
qireader.Close();
qicmd.Connection.Close();
 

(Problem 2)
can I write insert statement like this: using a where clause.
 
cmd.CommandText = "insert into gingercqi (QI_TRACK,DATE_RCV,INC_NUM,INC_DATE,INC_TIME,QANUM,BASE_HSP,ISSUE_IDENTIFY,MICN_INVOLVED,[1ST_RESP1],[1ST_RESP2],TRANSPORT1) VALUES ('"+txtqitrack.Text+"','"+Datercv.SelectedDate+"','"+ txtincnum.Text+"','"+ Dateinc.SelectedDate+"','"+txtinctime.Text+"','"+txtqanum.Text+"','"+ dpbasehsp.SelectedValue +"','"+dpissueidentify.SelectedValue+"','"+txtmicninvl.Text+"','"+txt1stresp1.Text+"','"+txt1stresp2.Text+"','"+txttransport1.Text+"') where QI_TRACk = '"+txtqitrack.Text+"'";
 

Thank You,

[nguyenlh]

I think that !!
you Open Sql and try query - with your query
if you can run in SQL - after you run in C#