如何将数值插入数据库

本文介绍了如何将数值插入数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 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).