How to convert the data to array form in asp.net C#?

Question

I have the following code and the datatable only contain one row. I wish to keep the all the data(the one row) value in array. Below is my code:

            SqlCommand cmdp = new SqlCommand("SELECT [1],[2],[3],[4],[5],[6],[7].[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31],[32],[33],[34],[35],[36],[37],[38],[39],[40],[41],[42],[43],[44],[45],[46],[47],[48],[49],[50],[51],[52],[53],[54],[55],[56],[57],[58],[59],[60],[61],[62],[63],[64],[65],[66],[67],[68],[69],[70],[71],[72],[73],[74],[75],[76],[77],[78] from [Seatlist] where (([FlightNo] = @FN) AND ([Origin] = @Ori) AND ([Destination] = @Des) AND ([DepartureTimeDay] = @Dep) AND ( [DepartureTimeMonths] = @Dem) AND ( [DepartureTimeYears] = @Dey) AND ( [DepartureTime] = @Det))", con);
            cmdp.Parameters.AddWithValue("@Seatlist", SeatNo.Text);
            cmdp.Parameters.AddWithValue("@FN", FlightNo.Text);
            cmdp.Parameters.AddWithValue("@Ori", Origin.Text);
            cmdp.Parameters.AddWithValue("@Des", Destination.Text);
            cmdp.Parameters.AddWithValue("@Dep", DepartDay.Text);
            cmdp.Parameters.AddWithValue("@Dem", DepartMonth.Text);
            cmdp.Parameters.AddWithValue("@Dey", DepartureTimeYears.Text);
            cmdp.Parameters.AddWithValue("@Det", DepartureTime.Text);
            DataTable dtable = new DataTable();
            dtable.Load(cmdp.ExecuteReader());
            DataRow[] array = dtable.AsEnumerable().Take(1).ToArray();
            object[] array1 = array[0].ItemArray;
            int[] array2 = Array.ConvertAll(array1, (p => Convert.ToInt32(p)));

But I get the following error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The multi-part identifier "7.8" could not be bound.

The [7].[8] should probably be [7],[8]. The . in SQL is a multipart identifier - stackoverflow.com/questions/206558/… — Kami
– Kami, Commented Sep 9, 2019 at 11:00
Possible duplicate of What is a 'multi-part identifier' and why can't it be bound? — Kami
– Kami, Commented Sep 9, 2019 at 11:00

Neeraj Singh Chouhan · Accepted Answer · 2019-09-09 11:17:15Z

It should work fine now ...

 SqlCommand cmdp = new SqlCommand("SELECT [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31],[32],[33],[34],[35],[36],[37],[38],[39],[40],[41],[42],[43],[44],[45],[46],[47],[48],[49],[50],[51],[52],[53],[54],[55],[56],[57],[58],[59],[60],[61],[62],[63],[64],[65],[66],[67],[68],[69],[70],[71],[72],[73],[74],[75],[76],[77],[78] from [Seatlist] where (([FlightNo] = @FN) AND ([Origin] = @Ori) AND ([Destination] = @Des) AND ([DepartureTimeDay] = @Dep) AND ( [DepartureTimeMonths] = @Dem) AND ( [DepartureTimeYears] = @Dey) AND ( [DepartureTime] = @Det))", con);
                cmdp.Parameters.AddWithValue("@Seatlist", SeatNo.Text);
                cmdp.Parameters.AddWithValue("@FN", FlightNo.Text);
                cmdp.Parameters.AddWithValue("@Ori", Origin.Text);
                cmdp.Parameters.AddWithValue("@Des", Destination.Text);
                cmdp.Parameters.AddWithValue("@Dep", DepartDay.Text);
                cmdp.Parameters.AddWithValue("@Dem", DepartMonth.Text);
                cmdp.Parameters.AddWithValue("@Dey", DepartureTimeYears.Text);
                cmdp.Parameters.AddWithValue("@Det", DepartureTime.Text);
                DataTable dtable = new DataTable();
                dtable.Load(cmdp.ExecuteReader());
                DataRow[] array = dtable.AsEnumerable().Take(1).ToArray();
                object[] array1 = array[0].ItemArray;
                int[] array2 = Array.ConvertAll(array1, (p => Convert.ToInt32(p)));

Prophet Lamb · Accepted Answer · 2019-09-09 11:13:04Z

1

As @Kami pointed out your Code is pretty much fine, but you got a [7].[8] instead of [7],[8] at char 66-73

answered Sep 9, 2019 at 11:13

Prophet Lamb

6205 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to convert the data to array form in asp.net C#?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related