Click here to Skip to main content
15,912,400 members
Please Sign up or sign in to vote.
3.40/5 (2 votes)
See more:
Hi i have an value like

BRICKFACE,1400,125.0,9,0.0,0.0,0.2777779,0.06296301,0.66666675,0.31111118,6.185185,7.3333335,7.6666665,3.5555556,3.4444444,4.4444447,-7.888889,7.7777777,0.5456349,-1.1218182
BRICKFACE,188.0,133.0,9,0.0,0.0,0.33333334,0.26666674,0.5,0.077777736,6.6666665,8.333334,7.7777777,3.8888888,5.0,3.3333333,-8.333333,8.444445,0.53858024,-0.92481726


Its in text file i nedd to insert these data in database here actually we have two columns to insert thats begin from
BRICKFACE to -1.1218182 
and
BRICKFACE to,-0.92481726 
is another column i tried wiyh my coding

C#
try
            {
                foreach (string f in Directory.GetFiles(foldername))
                {
                    s1 = File.ReadAllText(f);
                }
                ary = s1.Split('\n');
                j = 1;
                for (i = 0; i < 5000; i++)
                {
                    store_dataset(ary[i], j);
                    j++;
                }
                MessageBox.Show("Data Extracted Successfully");


            }
            catch (Exception error)
            {
            }

 void store_dataset(string str, int z)
        {
            try
            {
                string[] arr = str.Split('\n',',');

                string ss = "insert into Dataset(Sno,REGION-CENTROID-COL,REGION-CENTROID-ROW,REGION-PIXEL-COUNT,SHORT-LINE-DENSITY-5,SHORT-LINE-DENSITY-2,VEDGE-MEAN,VEDGE-SD,HEDGE-MEAN,HEDGE-SD,INTENSITY-MEAN,RAWRED-MEAN,RAWBLUE-MEAN,RAWGREEN-MEAN,EXRED-MEAN,EXBLUE-MEAN,EXGREEN-MEAN,VALUE-MEAN,SATURATION-MEAN,HUE-MEAN ) values(@16,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,@18,@19)";
                cmd = new SqlCommand(ss, cn.con);
                cmd.Parameters.AddWithValue("@19", z);
                cmd.Parameters.AddWithValue("@1", arr[0].Trim());
                cmd.Parameters.AddWithValue("@2", arr[1].Trim());
                cmd.Parameters.AddWithValue("@3", arr[2].Trim());
                cmd.Parameters.AddWithValue("@4", arr[3].Trim());
                cmd.Parameters.AddWithValue("@5", arr[4].Trim());
                cmd.Parameters.AddWithValue("@6", arr[5].Trim());
                cmd.Parameters.AddWithValue("@7", arr[6].Trim());
                cmd.Parameters.AddWithValue("@8", arr[7].Trim());
                cmd.Parameters.AddWithValue("@9", arr[8].Trim());
                cmd.Parameters.AddWithValue("@10", arr[9].Trim());
                cmd.Parameters.AddWithValue("@11", arr[10].Trim());
                cmd.Parameters.AddWithValue("@12", arr[11].Trim());
                cmd.Parameters.AddWithValue("@13", arr[12].Trim());
                cmd.Parameters.AddWithValue("@14", arr[13].Trim());
                cmd.Parameters.AddWithValue("@15", arr[14].Trim());
                cmd.Parameters.AddWithValue("@16", arr[15].Trim());
                cmd.Parameters.AddWithValue("@17", arr[16].Trim());
                cmd.Parameters.AddWithValue("@18", arr[17].Trim());
            
                
                cmd.ExecuteNonQuery();
                cmd.Dispose();
            }
            catch (Exception error)
            {
            }



Am getting error at this line cmd.Parameters.AddWithValue("@2", arr[1].Trim()); as Index was outside bound of array pls help me to solve dis issue
Posted

1 solution

Your input string (str) at this line:
C#
void store_dataset(string str, int z)


does not contain a comma, hence the arr array does not have a value at index 1 (which means the second element).

Debug and check you input string.

Cheers,
Edo
 
Share this answer
 
Comments
usha C 8-Aug-13 8:39am    
Thanks fr ur ans sir got my op

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900