problem with insert statement in asp.net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arial
    New Member
    • Sep 2007
    • 109

    #1

    problem with insert statement in asp.net

    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,



    Code:
    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();

    Code:
    (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
    New Member
    • Mar 2007
    • 25

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

    Comment

    Working...