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

C#

 
AnswerRe: Interface structure Pin
puneetdhawan200020-Oct-16 0:25
puneetdhawan200020-Oct-16 0:25 
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

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.