无法将参数值从字符串生成器转换为字符串 [英] Failed to convert parameter value from string builder to string

问题描述

您好，先生，
我是uday satardekar，

我正在使用xml
插入12000行 我正在使用xml绑定数据；
我正在使用StringBuilder

但是当我将其传递给标准过程时，它会引发异常
无法将参数值从字符串生成器转换为字符串

Hi sir ,
I am uday satardekar,

I am inserting 12000 rows using xml
and i am binding data using xml;
i am binging using StringBuilder

but when i am passing it to storded procedure it throws exception
Failed to convert parameter value from string builder to string

StringBuilder XML_TRANSACTIONDETAILS = new StringBuilder();

                    long maxid = getMaxId();
                    
                    int status;

                    //XML_TRANSACTIONDETAILS = "<master>";
                    XML_TRANSACTIONDETAILS.Append("<master>");

                    for (int i = 0; i < excelRows; i++)
                    {
                             maxid = maxid + 1;

                           // XML_TRANSACTIONDETAILS = XML_TRANSACTIONDETAILS + "<TRANSACTION>";
                            //XML_TRANSACTIONDETAILS = XML_TRANSACTIONDETAILS + "<maxid>" + maxid + "</maxid>";
                             XML_TRANSACTIONDETAILS.Append("<TRANSACTION>");
                             XML_TRANSACTIONDETAILS.Append("<maxid>" + maxid + "</maxid>");

                            for (int j = 0; j < ExcelColumnCount; j++)
                            {
                                string xmlTag = cleanedEmailTbl.Columns[j].ToString();

                               
                                XML_TRANSACTIONDETAILS.Append("<" + xmlTag + ">" + cleanedEmailTbl.Rows[i][j].ToString() + "</" + xmlTag + ">");
                           }
                           
                            XML_TRANSACTIONDETAILS.Append("</TRANSACTION>");
                    }
                    
                    XML_TRANSACTIONDETAILS.Append("</master>");

                    SqlParameter prm = new SqlParameter("@XML_TRANSACTIONDETAILS", SqlDbType.NText);
                    SqlParameter prm1 = new SqlParameter("@status", cmbAllStatus.SelectedValue);
                    SqlParameter prm2 = new SqlParameter("@username", currentLoggedUserId);
                    SqlParameter prm3 = new SqlParameter("@urlorcatalog", tboxUrlCat.Text);
                    SqlParameter prm4 = new SqlParameter("@dataentrytype", cmbDataEntryType.Text);
                 

                 
                    prm.Value = XML_TRANSACTIONDETAILS;

                    try
                    {
                        command.Connection = conn;
                        command.CommandText = "InsertExcelUsingXml";
                        command.CommandType = CommandType.StoredProcedure;

                        command.Parameters.Add(prm);
                        command.Parameters.Add(prm1);
                        command.Parameters.Add(prm2);
                        command.Parameters.Add(prm3);
                        command.Parameters.Add(prm4);

                        adapter = new SqlDataAdapter(command);
                        adapter.Fill(ds1, "rowsinserted");
                       
                        //after this lines exception comes
                       

                        int rows1 = command.ExecuteNonQuery();
                        transaction.Commit();

推荐答案

您需要先将其转换为字符串

you need to convert it to a string first

prm.Value = XML_TRANSACTIONDETAILS.ToString();

这篇关于无法将参数值从字符串生成器转换为字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！