Click here to Skip to main content
15,897,187 members
Home / Discussions / C#
   

C#

 
AnswerRe: Interface structure Pin
Nathan Minier20-Oct-16 1:11
professionalNathan Minier20-Oct-16 1:11 
GeneralRe: Interface structure Pin
Mycroft Holmes20-Oct-16 12:53
professionalMycroft Holmes20-Oct-16 12:53 
GeneralRe: Interface structure Pin
Eddy Vluggen21-Oct-16 0:37
professionalEddy Vluggen21-Oct-16 0:37 
GeneralRe: Interface structure Pin
Nathan Minier21-Oct-16 1:09
professionalNathan Minier21-Oct-16 1:09 
GeneralCan we use Azure Table as database in CRM application? Pin
amit singhniet18-Oct-16 23:11
amit singhniet18-Oct-16 23:11 
GeneralRe: Can we use Azure Table as database in CRM application? Pin
dan!sh 18-Oct-16 23:58
professional dan!sh 18-Oct-16 23:58 
GeneralRe: Can we use Azure Table as database in CRM application? Pin
amit singhniet19-Oct-16 1:35
amit singhniet19-Oct-16 1:35 
GeneralRe: Can we use Azure Table as database in CRM application? Pin
Dave Kreskowiak19-Oct-16 6:15
mveDave Kreskowiak19-Oct-16 6:15 
QuestionCode to move window not working. Pin
Member 1280196718-Oct-16 22:47
Member 1280196718-Oct-16 22:47 
AnswerRe: Code to move window not working. Pin
OriginalGriff18-Oct-16 23:03
mveOriginalGriff18-Oct-16 23:03 
GeneralRe: Code to move window not working. Pin
Member 1280196718-Oct-16 23:15
Member 1280196718-Oct-16 23:15 
GeneralRe: Code to move window not working. Pin
OriginalGriff18-Oct-16 23:19
mveOriginalGriff18-Oct-16 23:19 
GeneralRe: Code to move window not working. Pin
Member 1280196718-Oct-16 23:49
Member 1280196718-Oct-16 23:49 
GeneralRe: Code to move window not working. Pin
OriginalGriff18-Oct-16 23:59
mveOriginalGriff18-Oct-16 23:59 
GeneralRe: Code to move window not working. Pin
Member 1280196719-Oct-16 0:26
Member 1280196719-Oct-16 0:26 
GeneralRe: Code to move window not working. Pin
OriginalGriff19-Oct-16 0:31
mveOriginalGriff19-Oct-16 0:31 
GeneralRe: Code to move window not working. Pin
Member 1280196719-Oct-16 0:36
Member 1280196719-Oct-16 0:36 
GeneralRe: Code to move window not working. Pin
OriginalGriff19-Oct-16 0:47
mveOriginalGriff19-Oct-16 0:47 
GeneralRe: Code to move window not working. Pin
Member 1280196719-Oct-16 0:59
Member 1280196719-Oct-16 0:59 
GeneralRe: Code to move window not working. Pin
OriginalGriff19-Oct-16 1:17
mveOriginalGriff19-Oct-16 1:17 
GeneralRe: Code to move window not working. Pin
Member 1280196719-Oct-16 1:59
Member 1280196719-Oct-16 1:59 
GeneralRe: Code to move window not working. Pin
OriginalGriff19-Oct-16 2:07
mveOriginalGriff19-Oct-16 2:07 
GeneralRe: Code to move window not working. Pin
Rahul VB19-Oct-16 9:06
professionalRahul VB19-Oct-16 9:06 
QuestionHow i pass the list view column value in stored procedure as a parameter in vb dot net. Pin
Member 1280150118-Oct-16 19:28
Member 1280150118-Oct-16 19:28 
C#


C#
For i = 1 To ListView1.Items.Count
             ' Dim Cm1 As New SqlCommand
             'Dim dr1 As New SqlDataReader
             'Dim da1 As New SqlDataAdapter
 
             Try
 
                 Dim Cm1 As New SqlCommand
                 '  Dim dr1 As New SqlDataReader
 
                 Cm1.Connection = con
                 Cm1.CommandType = CommandType.StoredProcedure
                 Cm1.CommandText = "sp_ins_tbl_GE_Det"
 
                 Cm1.Parameters.AddWithValue("@GE_HDR_TRAN_ID", TRN_ID)
                 Cm1.Parameters.AddWithValue("@val_GE_HDR_ID", Transaction_No_hdr_ID)
 
                 If con.State = ConnectionState.Closed Then
                     con.Open()
                 End If
 
                 If rbPurchase.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "PURCH")
                 ElseIf rbSales.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "SALES")
                 ElseIf RBSTOCKTRANSFEROUT.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "STKTROUT")
                 ElseIf rbInterDept.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "INTRDEPT")
                 ElseIf rbCONTRACTORITEM.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "CONTITEM")
                 ElseIf rbSalesReturn.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "SALESRET")
                 ElseIf rbPurchaseReturn.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "PURCHRET")
                 ElseIf rbGatePass.Checked = True Then
                     Cm1.Parameters.AddWithValue("@val_Type_Of_Vehicle", "GATEPASS")
 If (rbSales.Checked = True Or RBSTOCKTRANSFEROUT.Checked = True Or rbSalesReturn.Checked = True) Then
                        '            ' Cm1.Parameters.AddWithValue("@val_Customer_Code", lvi.SubItems.Add(CStr(dr("Customer_Code"))))
                        Cm1.Parameters.AddWithValue("@val_Customer_Code", lvi.SubItems.Add(CStr(dr("Customer_Code"))))
                    Else
                        Cm1.Parameters.AddWithValue("@val_Customer_Code", "")
                    End If
  If con.State = ConnectionState.Closed Then
                        con.Open()
                    End If

                    dr = Cm1.ExecuteReader()
                    ' Cm1.ExecuteNonQuery()
                    Cm1.Dispose()
                Catch ex As Exception
                    MessageBox.Show(ex.Message)
                End Try

            Next
                 End If

AnswerRe: How i pass the list view column value in stored procedure as a parameter in vb dot net. Pin
OriginalGriff18-Oct-16 19:39
mveOriginalGriff18-Oct-16 19:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.