“从对象类型System.Web.UI.WebControls.TextBox到已知的托管提供程序本机类型不存在映射。”} [英] "No mapping exists from object type System.Web.UI.WebControls.TextBox to a known managed provider native type."}

问题描述

ublic partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        int[] nos = new int[Convert.ToInt32(txtNo.Text)];
        for (int i = 0; i < nos.Length; i++)
            nos[i] = i + 1;
        GridView1.DataSource = nos;
        GridView1.DataBind();
    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {

        foreach (GridViewRow gvRow in GridView1.Rows)
        {
            TextBox txtBranch = (TextBox)gvRow.FindControl("txtBranch");
            TextBox txtDate = (TextBox)gvRow.FindControl("txtDate");
            TextBox txtSrNo = (TextBox)gvRow.FindControl("txtSrNo");
            TextBox txtDocketNo = (TextBox)gvRow.FindControl("txtDocketNo");
            TextBox txtPinCode = (TextBox)gvRow.FindControl("txtPinCode");
            TextBox txtBasis = (TextBox)gvRow.FindControl("txtBasis");
            TextBox txtTo = (TextBox)gvRow.FindControl("txtTo");
            TextBox txtConsignorCode = (TextBox)gvRow.FindControl("txtConsignorCode");
            TextBox txtConsignee = (TextBox)gvRow.FindControl("txtConsignee");
            TextBox txtPKTS = (TextBox)gvRow.FindControl("txtPKTS");
            TextBox txtActWt = (TextBox)gvRow.FindControl("txtActWt");
            TextBox txtChargeWt = (TextBox)gvRow.FindControl("txtChargeWt");
            TextBox txtTotalFreight = (TextBox)gvRow.FindControl("txtTotalFreight");
            TextBox txtGoodsType = (TextBox)gvRow.FindControl("txtGoodsType");
            TextBox txtCODamount = (TextBox)gvRow.FindControl("txtCODamount");

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("insert into CreateDocket values (@Branch,@Date,@SrNo,@DocketNo,@PinCode,@Basis,@To,@ConsignorCode,@Consignee,@PKTS,@ActWt,@ChargeWt,@TotalFreight,@GoodsType,CODamount)", con);
            cmd.Parameters.Clear();
            cmd.Parameters.Add("@Branch", txtBranch.Text);
            cmd.Parameters.Add("@Date", txtDate.Text);
            cmd.Parameters.Add("@SrNo", txtSrNo);
            cmd.Parameters.Add("@DocketNo", txtDocketNo.Text);
            cmd.Parameters.Add("@PinCode", txtPinCode.Text);
            cmd.Parameters.Add("@Basis", txtBasis.Text);
            cmd.Parameters.Add("@To", txtTo.Text);
            cmd.Parameters.Add("@ConsignorCode", txtConsignorCode.Text);
            cmd.Parameters.Add("@Consignee", txtConsignee.Text);
            cmd.Parameters.Add("@PKTS", txtPKTS.Text);
            cmd.Parameters.Add("@ActWt", txtActWt.Text);
            cmd.Parameters.Add("@ChargeWt", txtChargeWt.Text);
            cmd.Parameters.Add("@TotalFreight", txtTotalFreight.Text);
            cmd.Parameters.Add("@GoodsType", txtGoodsType.Text);
            cmd.Parameters.Add("@CODamount", txtCODamount.Text);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}

当我删除webform时它向我显示了行上的错误cmd.ExecuteNonQuery（）;

我不明白这个问题。请帮帮我。

When I dedug the webform It shows me the error on line cmd.ExecuteNonQuery();
I am not Understanding the problem.Please help me.

推荐答案

你忘记了.Text：

You forgot the ".Text":

cmd.Parameters.Add("@SrNo", txtSrNo);

成为：

Becomes:

cmd.Parameters.Add("@SrNo", txtSrNo.Text);

这篇关于“从对象类型System.Web.UI.WebControls.TextBox到已知的托管提供程序本机类型不存在映射。”}的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！