C＃检查数据库并插入 [英] C# checking database and inserting

问题描述

  protected   void  Submit_Click（对象发​​件人，EventArgs e）
 {
  //   string strCon =Server = yourServer; Database = BuspassDb; User Id = Sa; Password = india;;  
 SqlConnection sqlConn =  new  SqlConnection（strCon ）; 
 SqlCommand cmd =  new  SqlCommand（  select *来自Console，其中Text = @TextTmp，sqlConn）; 
  //   cmd.CommandText =CheckIfStringExists;  
 cmd.Parameters。 AddWithValue（  @ TextTmp，txtString.Text）; 
  //   SqlParameter param = new SqlParameter（）;  
  //   param.ParameterName =@ TextTmp;  
  / /   param.Value = txtString.Text;  
  //   cmd.Parameters.Add（param）;  
  try  
 {
 sqlConn。打开（）; 
 SqlDataReader reader = cmd.ExecuteReader（）; 
  //   reader = cmd.ExecuteReader（）;  
  if （reader.HasRows）
 {
 reader.Read（）; 
 txtString.Text =（reader [  Text]。ToString（））; 
 lblMessage.Text = txtString.Text +   ....已经存在; 
} 
  else  
 
 lblMessage.Text = txtString.Text +    ...不存在; 
 txtString.Text =  ; 
 sqlConn.Close（）; 
 
 
  //   SqlConnection sqlCon = new SqlConnection（strCon）;  
  //   SqlCommand cmdd = new SqlCommand（）;  
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.CommandText =   InsertConsole2; 
 cmd.Connection = sqlConn; 
  //   cmd.Parameters.AddWithValue（@ TextTmp，txtString.Text）;  
 sqlConn.Open（）; 
 cmd.ExecuteScalar（）; 
 lblMessage.Text = txtString.Text +   ....已插入; 
} 
  catch （例外情况）
 {
 lblMessage.Text = ex.Message; 
} 

正在检查数据库，但是没有插入。

请你解释一下我做错了什么。

解决方案

代替此声明



cmd.ExecuteScalar（）;



试试这个：



cmd.ExecuteNonQuery（）;

sqlconn.Close（）;

protected void Submit_Click(object sender, EventArgs e)
        {
            //string strCon = "Server=yourServer;Database=BuspassDb;User Id=Sa;Password=india;";
            SqlConnection sqlConn = new SqlConnection(strCon);
            SqlCommand cmd = new SqlCommand("select * from Console where Text = @TextTmp", sqlConn);
            //cmd.CommandText = "CheckIfStringExists";
            cmd.Parameters.AddWithValue("@TextTmp", txtString.Text);
            //SqlParameter param = new SqlParameter();
            //param.ParameterName = "@TextTmp";
            //param.Value = txtString.Text;
            //cmd.Parameters.Add(param);
            try
            {
                sqlConn.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                //reader = cmd.ExecuteReader();
                if (reader.HasRows)
                {
                    reader.Read();
                    txtString.Text = (reader["Text"].ToString());
                    lblMessage.Text = txtString.Text + ".... is already exists";
                }
                else 
            
                    lblMessage.Text = txtString.Text + "... is not exists";
                    txtString.Text = "";
                    sqlConn.Close();


                    //SqlConnection sqlCon = new SqlConnection(strCon);
                    //SqlCommand cmdd = new SqlCommand();
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText = "InsertConsole2";
                    cmd.Connection = sqlConn;
                    //cmd.Parameters.AddWithValue("@TextTmp", txtString.Text);
                    sqlConn.Open();
                    cmd.ExecuteScalar();
                    lblMessage.Text = txtString.Text + "....is Inserted";
                    }
                    catch (Exception ex)
            {
                lblMessage.Text = ex.Message;
            }

It is checking with the database, but it is not inserting.
Please could you explain what I am doing wrong.

解决方案

instead of this statement

cmd.ExecuteScalar();

try this one :

cmd.ExecuteNonQuery();
sqlconn.Close();

这篇关于C＃检查数据库并插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！