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,
Thank You,
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+"'";
Comment