加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

c#database选择然后插入.但是值为0

发布时间:2020-12-16 07:23:39 所属栏目:百科 来源:网络整理
导读:我试图选择然后从表1插入日期时间到表2.我已成功插入数据.但是,表2中显示的日期时间为00:00:00. Idk哪里出错.有人请帮我解决这个问题.我正在努力解决这个问题.这是SELECT然后插入的正确方法吗? (从表1中选择然后插入表2) try { string myConnectionString;
我试图选择然后从表1插入日期时间到表2.我已成功插入数据.但是,表2中显示的日期时间为00:00:00. Idk哪里出错.有人请帮我解决这个问题.我正在努力解决这个问题.这是SELECT然后插入的正确方法吗? (从表1中选择然后插入表2)

try
    {
        string myConnectionString;
        myConnectionString= "server=localhost;uid=root;pwd=root;database=medicloud;SslMode=None;charset=utf8";

        MySqlConnection connection = new MySqlConnection(myConnectionString);
        MySqlCommand cmd = new MySqlCommand();

        cmd.CommandType = CommandType.Text;

        EncodingProvider ppp;
        ppp = CodePagesEncodingProvider.Instance;
        Encoding.RegisterProvider(ppp);

        connection.Open();   

        string select = "Select time from assign where userId=@name";
        cmd.Parameters.AddWithValue("@name",txtValue.Text);                           
        cmd.CommandText = select;
        cmd.Connection = connection;


        MySqlDataReader selectAssign = cmd.ExecuteReader();
        selectAssign.Read();
        string assign = (selectAssign["time"].ToString());
        selectAssign.Close();


        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "INSERT into bluetooth (userId,arm,armNumberDone,armNumber,comDate,assignDate,status) VALUES (@name,@stupid0,@stupid1,@stupid2,@stupid3,@stupid4,@stupid5)";
        cmd.Parameters.AddWithValue("@stupid0",databaseLine);
        cmd.Parameters.AddWithValue("@stupid1",counter);
        cmd.Parameters.AddWithValue("@stupid2",databaseValue);
        cmd.Parameters.AddWithValue("@stupid3",DateTime.Now);
        cmd.Parameters.AddWithValue("@stupid4",assign);
        cmd.Parameters.AddWithValue("@stupid5",complete);
        cmd.Connection = connection;


        cmd.ExecuteNonQuery();
        connection.Close();

    }

    catch (MySqlException ex)
    {
        txtExercise.Text = ex.ToString();
    }

解决方法

请试试这个

try
{
      string myConnectionString;
      myConnectionString = "server=localhost;uid=root;pwd=root;database=medicloud;SslMode=None;charset=utf8";

      MySqlConnection connection = new 
           MySqlConnection(myConnectionString);
      MySqlCommand cmd = new MySqlCommand();

      cmd.CommandType = CommandType.Text;

      EncodingProvider ppp;
      ppp = CodePagesEncodingProvider.Instance;
      Encoding.RegisterProvider(ppp);

      connection.Open();

      string select = "Select time from assign where userId=@name";
      cmd.Parameters.AddWithValue("@name",txtValue.Text);
      cmd.CommandText = select;
      cmd.Connection = connection;

      MySqlDataReader selectAssign = cmd.ExecuteReader();
      selectAssign.Read();
      string assign = (selectAssign["time"].ToString());
      selectAssign.Close();

      DateTime assignDate = DateTime.Now;
      DateTime.TryParseExact(assign,out assignDate);

      cmd.CommandType = CommandType.Text;
      cmd.CommandText = "INSERT into bluetooth 
(userId,@stupid5)";
      cmd.Parameters.AddWithValue("@stupid0",databaseLine);
      cmd.Parameters.AddWithValue("@stupid1",counter);
      cmd.Parameters.AddWithValue("@stupid2",databaseValue);
      cmd.Parameters.AddWithValue("@stupid3",DateTime.Now);
      cmd.Parameters.AddWithValue("@stupid4",assignDate);
      cmd.Parameters.AddWithValue("@stupid5",complete);
      cmd.Connection = connection;

      cmd.ExecuteNonQuery();
      connection.Close();
   }
  catch (MySqlException ex)
  {
      txtExercise.Text = ex.ToString();
  }
}

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读