这些是登录页面运行数据应该显示在te数据库中 [英] These is login page runs data should display in te database

问题描述

执行非查询不工作 g ，应在数据库emailid中添加两个值，lasttime显示在数据库中



我尝试过：

 protected void btnlogin_Click（object sender，EventArgs e）
 {
 erroruserpage.Text =; 
 
 cn.ConnectionString = ConfigurationManager.ConnectionStrings [bs]。ToString（）; 
 cn.Open（）; 
 
 SqlCommand cmtest = new SqlCommand（insert into enquiryform（EmailAddr，last_login_time）values（@ EmailAddr，@ last_login_time），cn）; 
 cmtest.Parameters.AddWithValue（@ EmailAddr，txtusername.Text）; 
 cmtest.Parameters.AddWithValue（@ last_login_time，DateTime.Today.ToString（））; 
 cmtest.ExecuteNonQuery（）; 
 cn.Close（）; 
 
 SqlCommand cmtest1 = new SqlCommand（insert into tbl_admincreation_bs（tur_emailid，last_login_time）values（@ emailid，@ time），cn）; 
 cmtest1.Parameters.AddWithValue（@ emailid，txtusername.Text）; 
 cmtest1.Parameters.AddWithValue（@ last_login_time，DateTime.Today.ToString（））; 
 cmtest1.ExecuteNonQuery（）; 
 cn.Close（）; 
 
 
 SqlCommand cmmail = new SqlCommand（选择来自enquiryform的EmailAddr，其中EmailAddr = @ EmailAddr，cn）; 
 cmmail.Parameters.AddWithValue（@ EmailAddr，txtusername.Text）; 
 SqlDataReader dr5 = cmmail.ExecuteReader（）; 
 

解决方案

 SqlCommand cmtest1 = new SqlCommand（insert into tbl_admincreation_bs（tur_emailid，last_login_time）value （@ EMAILID，@时间），CN）; 
 cmtest1.Parameters.AddWithValue（@ emailid，txtusername.Text）; 
 cmtest1.Parameters.AddWithValue（ @last_login_time  @time，DateTime.Today.ToString（））; //它应该是@time 
 cmtest1.ExecuteNonQuery（）; 
 cn.Close（）;在$ $ $ $ $ br /> 
再次对于第二个语句，你使用相同的连接对象来执行第二个命令（cmtest1）。
 
 
 
所以删除con.Close（）方法在执行命令之间。最后关闭连接。
 
 
 
 protected void btnlogin_Click（object sender，EventArgs e）
 
 {
 
 erroruserpage .Text =; 
 
 
 
 cn.ConnectionString = ConfigurationManager.ConnectionStrings [bs]。ToString（）; 
 
 cn.Open （）; 
 
 
 
 SqlCommand cmtest = new SqlCommand（插入到enquiryform（EmailAddr，last_login_time）值（@ EmailAddr，@ last_login_time），cn）; 
 
 cmtest.Parameters.AddWithValue（@ EmailAddr，txtusername.Text）; 
 
 cmtest.Parameters.AddWithValue（@ last_login_time，DateTime.Today.ToString（））; 
 
 cmtest.ExecuteNonQuery（）; 
 
 //cn.Close（）; 
 
 
 
 SqlCommand cmtest1 = new SqlCommand （插入到tbl_admincreation_bs（tur_emailid，last_login_time）值（@ emailid，@ time），cn）; 
 
 cmtest1.Parameters.AddWithValue（@ emailid，txtusername.Text）; 
 
 cmtest1 .Parameters.AddWithValue（@ time，DateTime.Today.ToString（））; 
 
 cmtest1.ExecuteNonQuery（）; 
 
 //cn.Close（）; < br $> 
 
 
 
 
 SqlCommand cmmail = new SqlCommand（从enquiryform选择EmailAddr，其中EmailAddr = @ EmailAddr，cn）; 
 
 cmmail.Parameters.AddWithValue（@ EmailAddr，txtusername.Text）; 
 
 SqlDataReader dr5 = cmmail.ExecuteReader（）; 
 
 
 
在此声明后添加
 
 cn.Close（）; 
 
 
 
查看此声明可能会对您有所帮助。

execute non query is not working,two values should be added in the database emailid ,lasttime display in database

What I have tried:

protected void btnlogin_Click(object sender, EventArgs e)
 {
     erroruserpage.Text = "";

     cn.ConnectionString = ConfigurationManager.ConnectionStrings["bs"].ToString();
     cn.Open();

     SqlCommand cmtest = new SqlCommand("insert into enquiryform (EmailAddr,last_login_time)values(@EmailAddr,@last_login_time)", cn);
     cmtest.Parameters.AddWithValue("@EmailAddr", txtusername.Text);
     cmtest.Parameters.AddWithValue("@last_login_time", DateTime.Today.ToString());
      cmtest.ExecuteNonQuery();
      cn.Close();

     SqlCommand cmtest1 = new SqlCommand("insert into tbl_admincreation_bs(tur_emailid,last_login_time)values(@emailid,@time)",cn);
     cmtest1.Parameters.AddWithValue("@emailid", txtusername.Text);
     cmtest1.Parameters.AddWithValue("@last_login_time", DateTime.Today.ToString());
     cmtest1.ExecuteNonQuery();
     cn.Close();


     SqlCommand cmmail = new SqlCommand("select EmailAddr from enquiryform where EmailAddr=@EmailAddr", cn);
     cmmail.Parameters.AddWithValue("@EmailAddr", txtusername.Text);
     SqlDataReader dr5 = cmmail.ExecuteReader();

解决方案

SqlCommand cmtest1 = new SqlCommand("insert into tbl_admincreation_bs(tur_emailid,last_login_time)values(@emailid,@time)",cn);
       cmtest1.Parameters.AddWithValue("@emailid", txtusername.Text);
       cmtest1.Parameters.AddWithValue("@last_login_time @time", DateTime.Today.ToString()); // it should be @time
       cmtest1.ExecuteNonQuery();
       cn.Close();

Before executing the first command (cmtest) you open the connection then after you close the connection.

Again for 2nd statement you use same connection object to execute the 2nd command (cmtest1).

So Remove the con.Close() method in between execute commands. At last close the connection.

protected void btnlogin_Click(object sender, EventArgs e)
{
erroruserpage.Text = "";

cn.ConnectionString = ConfigurationManager.ConnectionStrings["bs"].ToString();
cn.Open();

SqlCommand cmtest = new SqlCommand("insert into enquiryform (EmailAddr,last_login_time)values(@EmailAddr,@last_login_time)", cn);
cmtest.Parameters.AddWithValue("@EmailAddr", txtusername.Text);
cmtest.Parameters.AddWithValue("@last_login_time", DateTime.Today.ToString());
cmtest.ExecuteNonQuery();
//cn.Close();

SqlCommand cmtest1 = new SqlCommand("insert into tbl_admincreation_bs(tur_emailid,last_login_time)values(@emailid,@time)",cn);
cmtest1.Parameters.AddWithValue("@emailid", txtusername.Text);
cmtest1.Parameters.AddWithValue("@time", DateTime.Today.ToString());
cmtest1.ExecuteNonQuery();
//cn.Close();


SqlCommand cmmail = new SqlCommand("select EmailAddr from enquiryform where EmailAddr=@EmailAddr", cn);
cmmail.Parameters.AddWithValue("@EmailAddr", txtusername.Text);
SqlDataReader dr5 = cmmail.ExecuteReader();

Add after this statement
cn.Close();

Check this statement it may help you.

这篇关于这些是登录页面运行数据应该显示在te数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！