Dynamically pass Array values to generate Insert statement in ASP.Net

meetsree...

SOLVED CLOSED ACTIVE ANSWERED
User: meetsree83
Posted: on Sep 18, 2018 04:24 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2073

Hi,

I have an array of strings in the variable

I need to insert each values into DB.

Issue is sometimes the array will contain 3 values ,but i need to pass the remaining values as empty and store it.

Query for storing like that

But i am facing the error Index Outside bound if the array will not contain minimum of 10 records.

Please assist.

Dim ResponseArray As String() = responses.Split(" ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries)
"INSERT INTO FEEDBACKQUESTIONS_SERVICE (DISPLAY_ORDER,CHANNEL,SERVICE,QUESTION,OPTION1,OPTION2,OPTION3,OPTION4,OPTION5,OPTION6,OPTION7,OPTION8,OPTION9,OPTION10,QUESTION_ID) " +
               "VALUES('13','general','general','" + QuestionArray(0).ToString().Trim + "','" + IIf(IsDBNull(ResponseArray(0).ToString().Trim), "", ResponseArray(0).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(1).ToString().Trim), "", ResponseArray(1).ToString().Trim) + "' " +
               ",'" + IIf(IsDBNull(ResponseArray(2).ToString().Trim), "", ResponseArray(2).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(3).ToString().Trim), "", ResponseArray(3).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(4).ToString().Trim), "", ResponseArray(4).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(5).ToString().Trim), "", ResponseArray(5).ToString().Trim) + "' " +
               ",'" + IIf(IsDBNull(ResponseArray(6).ToString().Trim), "", ResponseArray(6).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(7).ToString().Trim), "", ResponseArray(7).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(8).ToString().Trim), "", ResponseArray(8).ToString().Trim) + "','" + IIf(IsDBNull(ResponseArray(9).ToString().Trim), "", ResponseArray(9).ToString().Trim) + "' " +
               ",'" + QuestionId + "')"

meetsree...

0 4

Reply
ANSWER
User: meetsree83
Replied: on Sep 18, 2018 06:18 AM
Report

Hi,

Create a method to dynamically pass the values as Array and generate the sql statement.

Regards

Sreejith A

    Protected Function Insert_Question(ByVal OptionArray As String(), ByVal QID As Integer, ByVal Question As String) As String
        Dim Insert_Query = ""
        Dim QuestionId = "Q" & QID

        Insert_Query = "INSERT INTO FEEDBACKQUESTIONS_SERVICE (DISPLAY_ORDER,CHANNEL,SERVICE,QUESTION "
        For k As Integer = 0 To OptionArray.Count - 1
            Insert_Query += ",OPTION" & k + 1
        Next
        Insert_Query += ",QUESTION_ID) VALUES('13','general','general','" + Question + "'"
        For j As Integer = 0 To OptionArray.Count - 1
            Insert_Query += ",'" + OptionArray(j).ToString().Trim + "'"
        Next
        Insert_Query += ",'" + QuestionId + "')"

        Return Insert_Query
    End Function

Dynamically pass Array values to generate Insert statement in ASP.Net

Company

Explore

Follow us

Contact Us