The line array contains the valuesAnd i have to insert the details to database as below how i change below code to stored procedureArray linearray lineSplit3939string str 34insert into clearingtxn values34 for int col 0 col lt linearrayLength col if col 1 if linearrayGetValuecolToStringTrimToUpperEquals34VISA34

Import text file data and save into Database using C# in ASP.Net

josmi

SOLVED CLOSED ACTIVE ANSWERED
User: josmi
Posted: on Jun 16, 2016 01:56 AM
Forum: Data Controls
Answer: 1
Views: 6626
Sample Code: Download

The line array contains the values.And i have to insert the details to database as below, how i change below code to stored procedure

Array linearray = line.Split('|')
string str = "insert into clearing_txn values(";
                    for (int col = 0; col < linearray.Length; col++)
                    {
                        if (col == 1)
                        {
                            if (linearray.GetValue(col).ToString().Trim().ToUpper().Equals("VISA"))
                            {
                                type = "V";
                            }
                            else
                            {
                                type = "M";
                            }
                            str = str + "'" + type + "',";

                        }
                        else if (col == 4)
                        {
                            amount = linearray.GetValue(col).ToString().Trim();
                            amount = amount.Replace(".", "");
                            if (amount.Length > 2)
                            {
                                amount = amount.Substring(0, amount.Length - 2) + "." + amount.Substring(amount.Length - 2, 2);
                            }
                            else if (amount.Length == 2)
                            {
                                amount = "." + amount;
                            }
                            else
                            {
                                amount = ".0" + amount;
                            }
                            str = str + "'" + amount + "',";

                        }
                        else if (col == 5)
                        {
                            entity_id = linearray.GetValue(col).ToString().Trim();
                            for (int i = 0; i < entity_id.Length; i++)
                            {
                                if (!entity_id.Substring(i, 1).Equals("0"))
                                {
                                    entity_id = entity_id.Substring(i, entity_id.Length - i);
                                    i = entity_id.Length;
                                }
                            }
                            str = str + "'" + entity_id + "',";

                        }
                        else if (col == 6)
                        {
                            if (linearray.GetValue(col).ToString().Trim().ToUpper().Equals("DOM"))
                            {
                                txn_type = "D";
                            }
                            else
                            {
                                txn_type = "I";
                            }
                            str = str + "'" + txn_type + "',";
                        }
                        else if(col==10)
                        {
                            type_card = linearray.GetValue(col).ToString().Trim();
                        }
                        else
                        {
                            str = str + "'" + linearray.GetValue(col).ToString().Trim() + "',";
                        }
                    }
                    str = str + "'" + outfile + "','" + username + "','N',getdate(),'" + type_card + "')";

Download FREE API for Word, Excel and PDF in ASP.Net

josmi

0 6

Reply
User: josmi
Replied: on Jun 16, 2016 06:32 AM
Report

same for every line array

dharmend...

0 7

Reply
User: dharmendr
Replied: on Jun 16, 2016 07:04 AM
Modified: on Jun 16, 2016 07:09 AM
Report

That means if input is

string line = "4/5/2015 05:17:15 AM| VISA| 4704560544052255| 032571| 76000| 000000023890137| DOM| Visa Platinum| 000080752769| 74662425098150981147100| D";

then you want out put as

INSERT INTO clearing_txn VALUES('4/5/2015 05:17:15 AM','V','4704560544052255','032571','760.00','000000023890137','D','Visa Platinum','000080752769','74662425098150981147100','D')

josmi

0 8

Reply
User: josmi
Replied: on Jun 16, 2016 10:13 PM
Modified: on Jun 16, 2016 10:19 PM
Report

yes,the same way the insertion happens

dharmend...

0 9

Reply
ANSWER
User: dharmendr
Replied: on Jun 17, 2016 03:15 AM
Report

Refer the below code.

string date = "", type = "", card_no = "", auth_id = "", amount = "", entity_id = "", txn_type = "", Card_Type = "", RRN = "", Reff_no = "", type_card = "";
string line = "4/5/2015 05:17:15 AM| VISA| 4704560544052255| 032571| 76000| 000000023890137| DOM| Visa Platinum| 000080752769| 74662425098150981147100| D";
Array linearray = line.Split('|');
if (linearray.Length == 11)
{
    date = linearray.GetValue(0).ToString().Trim();
    type = linearray.GetValue(1).ToString().Trim();
    card_no = linearray.GetValue(2).ToString().Trim();
    auth_id = linearray.GetValue(3).ToString().Trim();
    amount = linearray.GetValue(4).ToString().Trim();
    entity_id = linearray.GetValue(5).ToString().Trim();
    txn_type = linearray.GetValue(6).ToString().Trim();
    Card_Type = linearray.GetValue(7).ToString().Trim();
    RRN = linearray.GetValue(8).ToString().Trim();
    Reff_no = linearray.GetValue(9).ToString().Trim();
    type_card = linearray.GetValue(10).ToString().Trim();
    //Cheking card type.
    if (type.ToUpper() == "VISA")
    {
        type = "V";
    }
    else
    {
        type = "M";
    }
    //Cheking amount.
    amount = amount.Replace(".", "");
    if (amount.Length > 2)
    {
        amount = amount.Substring(0, amount.Length - 2) + "." + amount.Substring(amount.Length - 2, 2);
    }
    else if (amount.Length == 2)
    {
        amount = "." + amount;
    }
    else
    {
        amount = ".0" + amount;
    }
    //Cheking entity_id.
    for (int i = 0; i < entity_id.Length; i++)
    {
        if (!entity_id.Substring(i, 1).Equals("0"))
        {
            entity_id = entity_id.Substring(i, entity_id.Length - i);
            i = entity_id.Length;
        }
    }
    //Cheking DOM.
    if (txn_type.ToUpper().Equals("DOM"))
    {
        txn_type = "D";
    }
    else
    {
        txn_type = "I";
    }
    string str = "INSERT INTO clearing_txn VALUES('" + date + "','" + type + "','" + card_no + "','" + auth_id + "','" + amount + "','" + entity_id + "','" + txn_type + "','" + Card_Type + "','" + RRN + "','" + Reff_no + "','" + type_card + "')";
}

Output of str

INSERT INTO clearing_txn VALUES('4/5/2015 05:17:15 AM','V','4704560544052255','032571','760.00','23890137','D','Visa Platinum','000080752769','74662425098150981147100','D')

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Import text file data and save into Database using C# in ASP.Net

Company

Explore

Follow us

Contact Us