本文介绍了转换数据以保存在数据库中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

可以在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();
        }
    }

推荐答案


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

07-23 03:06
查看更多