salmah
پنج شنبه 20 آذر 1393, 12:00 عصر
من یه دستور سرچ نوشتم ولی لین خطا را داره علتش چی هست
lConnection cnc = new SqlConnection();
cnc.ConnectionString = ConfigurationManager.ConnectionStrings["saatConnectionString"].ToString();
cnc.Open();
SqlCommand cmd = new SqlCommand("select count (*) from tsabtedoreh where oid=@oid and nid=@nid and mid=@mid and shomare=@shomare and dtamojavez=@dtamojavez and codepersoneli=@cp and bid=@bid and rid=@rid and eid=@eid and shomarehg=@shomarehg and dtag=@dtag and datastart=@ds and dataend=@de", cnc);
cmd.Parameters.AddWithValue("oid", dd_oid.SelectedValue);//1
cmd.Parameters.AddWithValue("nid", dd_nid.SelectedValue);//2
cmd.Parameters.AddWithValue("mid", dd_mid.SelectedValue);//5
cmd.Parameters.AddWithValue("shomarez", ct_shmojavez.Text);//6
cmd.Parameters.AddWithValue("dtamojavez", DT_mojavez);//7
cmd.Parameters.AddWithValue("cp", Request.QueryString["cp"]);//8
cmd.Parameters.AddWithValue("rid", dd_rsht.SelectedValue);//4
cmd.Parameters.AddWithValue("bid", dd_bid.SelectedValue);//9
cmd.Parameters.AddWithValue("eid", dd_eid.SelectedValue);//4
cmd.Parameters.AddWithValue("shomarehg", ct_shomarehg);//10
cmd.Parameters.AddWithValue("dtag", DT_gv);//11
cmd.Parameters.AddWithValue("ds", DT_start);
cmd.Parameters.AddWithValue("de", DT_end);
string at = cmd.ExecuteScalar().ToString();
if (at != "0")
{
ct_err.Text = "مشخصات دوره تکراری است.";
}
lConnection cnc = new SqlConnection();
cnc.ConnectionString = ConfigurationManager.ConnectionStrings["saatConnectionString"].ToString();
cnc.Open();
SqlCommand cmd = new SqlCommand("select count (*) from tsabtedoreh where oid=@oid and nid=@nid and mid=@mid and shomare=@shomare and dtamojavez=@dtamojavez and codepersoneli=@cp and bid=@bid and rid=@rid and eid=@eid and shomarehg=@shomarehg and dtag=@dtag and datastart=@ds and dataend=@de", cnc);
cmd.Parameters.AddWithValue("oid", dd_oid.SelectedValue);//1
cmd.Parameters.AddWithValue("nid", dd_nid.SelectedValue);//2
cmd.Parameters.AddWithValue("mid", dd_mid.SelectedValue);//5
cmd.Parameters.AddWithValue("shomarez", ct_shmojavez.Text);//6
cmd.Parameters.AddWithValue("dtamojavez", DT_mojavez);//7
cmd.Parameters.AddWithValue("cp", Request.QueryString["cp"]);//8
cmd.Parameters.AddWithValue("rid", dd_rsht.SelectedValue);//4
cmd.Parameters.AddWithValue("bid", dd_bid.SelectedValue);//9
cmd.Parameters.AddWithValue("eid", dd_eid.SelectedValue);//4
cmd.Parameters.AddWithValue("shomarehg", ct_shomarehg);//10
cmd.Parameters.AddWithValue("dtag", DT_gv);//11
cmd.Parameters.AddWithValue("ds", DT_start);
cmd.Parameters.AddWithValue("de", DT_end);
string at = cmd.ExecuteScalar().ToString();
if (at != "0")
{
ct_err.Text = "مشخصات دوره تکراری است.";
}