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