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

Refer the below codestring date 3434 type 3434 cardno 3434 authid 3434 amount 3434 entityid 3434 txntype 3434 CardType 3434 RRN 3434 Reffno 3434 typecard 3434string line 34452015 051715 AM VISA 4704560544052255 032571 76000 000000023890137 DOM Visa Platinum 000080752769 74662425098150981147100 D34Array linearray lineSplit3939if linearrayLength 11 date linearrayGetValue0ToStringTrim type linearrayGetValue1ToStringTrim cardno linearrayGetValue2ToStringTrim authid linearrayGetValue3ToStringTrim amount linearrayGetValue4ToStringTrim entityid linearrayGetValue5ToStringTrim txntype linearrayGetValue6ToStringTrim CardType linearrayGetValue7ToStringTrim RRN linearrayGetValue8ToStringTrim Reffno linearra

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: 6564
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

dharmend...

0 1

Reply
User: dharmendr
Replied: on Jun 16, 2016 02:02 AM
Report

Hi josmi,

Please explain in more details and share the input and expected output.

josmi

0 2

Reply
User: josmi
Replied: on Jun 16, 2016 02:50 AM
Report

it is the result obtained from a file

   line = sr.ReadLine().Trim();
                count = count + 1;

                Array linearray = line.Split('|');
              
                string date = "", type = "", card_no = "", auth_id = "", amount = "", entity_id = "", txn_type = "", Card_Type = "", RRN = "", Reff_no = "",type_card="";
                if ((linearray.Length == 11))
                {
}

if the line array length equals 11 it will exceutes the code in question

.so i need the the insert as stored procedure.

linearray contains values below

4/7/2015 11:06:57 AM MDS 5049937008800117015 609181 95687 0000024259746E9 DOM Maestro Card 000081343847 '' D

so i have change above code to stored procedure

dharmend...

0 3

Reply
User: dharmendr
Replied: on Jun 16, 2016 03:55 AM
Report

As per the linearray you are splitting with '|' but your string does not contain '|' char. So how you can you split the string. From the given string there is only ' '(space) to split in array. So let me know how you would proceed with the data.

josmi

0 4

Reply
User: josmi
Replied: on Jun 16, 2016 04:51 AM
Report

The below given are the screenschot of values obtained by break point

dharmend...

0 5

Reply
User: dharmendr
Replied: on Jun 16, 2016 05:41 AM
Report

Is your array format is same for every linearray or it will different in any case?

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