如何将数值插入数据库 [英] How to insert numeric value into database

问题描述

大家好，



Iam尝试使用datagridview将数值插入数据库但是没有插入另外两个插入成功的字段但是当我试图插入它时数字值插入0



我尝试过：

  private   void  dataGridView1_RowLeave（ object  sender，DataGridViewCellEventArgs e）
 {
  if （dataGridView1.IsCurrentRowDirty）
 {
  string  connectionString =  null ; 
 connectionString = ConfigurationManager.ConnectionStrings [  AccessConnectionString]。ConnectionString; 
 con.ConnectionString = connectionString; 
 
  string  cmd1 =  插入Medicine_Available_Detail（[Medicine_Name]，[Dealer_name]，[total_available]）值（？，？，？）; 
 OleDbCommand cmd =  new  OleDbCommand（cmd1，con）; 
 
 cmd.CommandType = CommandType.Text; 
 
  string  Medicine_Name = dataGridView1.Rows [e.RowIndex] .Cells [  Medicine_Name]。Value.ToString（）; 
 cmd.Parameters.AddWithValue（  @ Medicine_Name，Medicine_Name）; 
 
  string  Dealer_name = dataGridView1.Rows [e.RowIndex] .Cells [  Dealer_name]。Value.ToString（）; 
 cmd.Parameters.AddWithValue（  @ Dealer_name，Dealer_name）; 
 
  int 可用性; 
  bool  total_availableHasValue =  Int32  .TryParse（dataGridView1.Rows [e.RowIndex] .Cells [   total_available]。Value.ToString（）， out 可用性）; 
 cmd.Parameters.AddWithValue（  @ total_available，total_availableHasValue）; 
 con.Open（）; 
  int  n = cmd.ExecuteNonQuery（）; 
 con.Close（）; 
} 

解决方案

您正在尝试使用布尔值 total_availableHasValue 作为数据库参数，而不是解析后的整数可用性（应拼写可选我 ty ）。

Hi all,

Iam trying to insert numeric value into database using datagridview but it not inserted another two fields inserted successfully but numeric value when im trying to insert it inserted as 0

What I have tried:

  private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e)
        {
  if (dataGridView1.IsCurrentRowDirty)
            {
                string connectionString = null;
                connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;
                con.ConnectionString = connectionString;

                string cmd1 = "insert into Medicine_Available_Detail([Medicine_Name],[Dealer_name],[total_available])values(?,?,?)";
                OleDbCommand cmd = new OleDbCommand(cmd1, con);

                cmd.CommandType = CommandType.Text;

                string Medicine_Name = dataGridView1.Rows[e.RowIndex].Cells["Medicine_Name"].Value.ToString();
                cmd.Parameters.AddWithValue("@Medicine_Name", Medicine_Name);

                string Dealer_name = dataGridView1.Rows[e.RowIndex].Cells["Dealer_name"].Value.ToString();
                cmd.Parameters.AddWithValue("@Dealer_name", Dealer_name);

 int Availabilty;
                bool total_availableHasValue = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["total_available"].Value.ToString(), out Availabilty);
                cmd.Parameters.AddWithValue("@total_available", total_availableHasValue);
 con.Open();
                int n = cmd.ExecuteNonQuery();
                con.Close();
}

解决方案

You are trying to use the boolean value total_availableHasValue as the database parameter, rather than the parsed integer Availabilty (which should be spelled Availability).

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