转换数据以保存在数据库中 [英] convert data to save in database

问题描述

可以在SQL表列数据类型为nvarchar（MAX）时保存这些信息，但我需要将数据保存到。



i需要知道，如何保存到这个表，



这是我的数据库，我需要将数据保存到表中，但我不能使用我的代码做它，但我可以保存使用nvarchar（MAX）数据格式到数据库



数据库图像http://i.stack.imgur.com/8FLfH.jpg

can save those information when SQL table column data types is nvarchar(MAX) but i need to save data to the .

i need to know , how to save to this table ,

this is my database and i need to save data in to the table, but i cannot use my code do do it , but i can save in to the database using nvarchar(MAX) data format

database image http://i.stack.imgur.com/8FLfH.jpg

protected void btnSaave_Click(object sender, EventArgs e)
{
    int rowIndex = 0;
    StringCollection sc = new StringCollection();
    if (ViewState["CurrentData"] != null)
    {
        DataTable dtCurrentTable = (DataTable)ViewState["CurrentData"];
        DataRow drCurrentRow = null;
        if (dtCurrentTable.Rows.Count > 0)
        {
            for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
            {
                var dtDealerCode = txtIDealerCode.Text;
                var dtInvoiceNo = txtInvoiceNumber.Text;
                var dtInvoiceDate = txtInvoiceDate.Text;
                var dtItemIdentityCode = (Label)GridView1.Rows[rowIndex].Cells[1].FindControl("ItemCode");
                var dtPurchasingPrice = (Label)GridView1.Rows[rowIndex].Cells[3].FindControl("UnitPrice");
                var dtDiscountRate = txtDiscount.Text;
                var dtDiscount = txtProductDiscount.Text;
                var dtIssueMode = ddlIssueMode.SelectedValue;
                var dtQty = (Label)GridView1.Rows[rowIndex].Cells[6].FindControl("Quantity");
                var dtTotal = (Label)GridView1.FooterRow.FindControl("GetTotal");
                var dtExpireDate = (Label)GridView1.Rows[rowIndex].Cells[5].FindControl("ExpiaryDate");
                var dtBatchNumber = (Label)GridView1.Rows[rowIndex].Cells[4].FindControl("Batch");
                var dtUploadedStatus = txtInvoiceDate.Text;
                var dtInsertedDate = "1";
                var dtUploadedDate = txtInvoiceDate.Text;
                var dtForce = txtForce.Text;
                var dtPrinciple = txtPrinciple.Text;
                var NewTotal = (Label)GridView1.FooterRow.FindControl("GetQuantity");
                // (Label)GridView1.Rows[rowIndex].Cells[7].FindControl("Total");
                //(Label)GridView1.Rows[rowIndex].Cells[2].FindControl("Product")
                sc.Add(dtDealerCode + "," + dtInvoiceNo + "," + dtInvoiceDate + "," + dtItemIdentityCode.Text + "," + dtPurchasingPrice.Text + "," + dtDiscountRate + "," + dtDiscount + "," + dtIssueMode + "," + dtQty.Text + "," + dtTotal.Text + "," + dtExpireDate + "," + dtBatchNumber.Text + "," + dtUploadedStatus + "," + dtInsertedDate + "," + dtUploadedDate + "," + dtForce + "," + dtPrinciple + "," + dtPrinciple + "," + NewTotal.Text);
                rowIndex++;
            }

            InsertRec(sc);
        }
    }
}

即时使用此部分保存到数据库中。我需要将数据保存到表中，但我无法使用我的代码执行此操作，但我可以使用nvarchar（MAX）数据格式保存到数据库

im using this part to save in to databases. I need to save data in to the table, but i cannot use my code do do it , but i can save in to the database using nvarchar(MAX) data format

private void InsertRec(StringCollection sc)
    {
        var conn = new SqlConnection(GetConnectionString());
        var sb = new StringBuilder(string.Empty);
        var splitItems = (string[])null;
        foreach (string item in sc)
        {
            const string sqlStatement =
                "INSERT INTO DEL_PurchasesLines1 (DealerCode,InvoiceNo,InvoiceDate,ItemIdentityCode,PurchasingPrice,DiscountRate,Discount,IssueMode,Qty,Total,ExpireDate,BatchNumber,UploadedStatus,InsertedDate,UploadedDate,Force,Principle,NewTotal) VALUES";

            if (item.Contains(","))
            {
                splitItems = item.Split(",".ToCharArray());
                sb.AppendFormat("{0}('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}'); ", sqlStatement, splitItems[0], splitItems[1], splitItems[2], splitItems[3], splitItems[4], splitItems[5], splitItems[6], splitItems[7], splitItems[8], splitItems[9], splitItems[10], splitItems[11], splitItems[12], splitItems[13], splitItems[14], splitItems[15], splitItems[16], splitItems[17]);
            }
        }

        try
        {
            conn.Open();
            SqlCommand cmd = new SqlCommand(sb.ToString(), conn) { CommandType = CommandType.Text };
            cmd.ExecuteNonQuery();

            Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);

        }
        catch (System.Data.SqlClient.SqlException ex)
        {
            string msg = "Insert Error:";
            msg += ex.Message;
            throw new Exception(msg);
        }
        finally
        {
            conn.Close();
        }
    }

推荐答案

您是否收到任何错误或未显示任何错误？运行SQL事件探查器并查看它正在生成的插入语句，并尝试在查询窗口中运行该查询

Are you getting any errors or its not showing any error? Run the SQL Profiler and see what insert statement it is generating and try running that query in the query window

这篇关于转换数据以保存在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！