Click here to Skip to main content
15,867,453 members
Home / Discussions / C#
   

C#

 
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 
AnswerRe: How i pass the list view column value in stored procedure as a parameter in vb dot net. Pin
OriginalGriff18-Oct-16 19:40
mveOriginalGriff18-Oct-16 19:40 
QuestionWhy Interface? Pin
Member 973087818-Oct-16 2:17
Member 973087818-Oct-16 2:17 
AnswerRe: Why Interface? Pin
Kenneth Haugland18-Oct-16 2:58
mvaKenneth Haugland18-Oct-16 2:58 
AnswerRe: Why Interface? Pin
OriginalGriff18-Oct-16 4:03
mveOriginalGriff18-Oct-16 4:03 
SuggestionRe: Why Interface? Pin
Richard Deeming18-Oct-16 4:30
mveRichard Deeming18-Oct-16 4:30 
GeneralRe: Why Interface? Pin
OriginalGriff18-Oct-16 4:41
mveOriginalGriff18-Oct-16 4:41 
AnswerRe: Why Interface? Pin
Gerry Schmitz18-Oct-16 6:21
mveGerry Schmitz18-Oct-16 6:21 
JokeRe: Why Interface? Pin
Pete O'Hanlon18-Oct-16 9:20
subeditorPete O'Hanlon18-Oct-16 9:20 
GeneralRe: Why Interface? Pin
Gerry Schmitz18-Oct-16 20:36
mveGerry Schmitz18-Oct-16 20:36 
AnswerRe: Why Interface? Pin
Eddy Vluggen18-Oct-16 11:17
professionalEddy Vluggen18-Oct-16 11:17 
SuggestionRe: Why Interface? Pin
Richard Deeming18-Oct-16 12:21
mveRichard Deeming18-Oct-16 12:21 
GeneralRe: Why Interface? Pin
Eddy Vluggen18-Oct-16 12:36
professionalEddy Vluggen18-Oct-16 12:36 
QuestionCan't insert inkPicture into SQL Server database from C# Pin
Member 1178659318-Oct-16 0:17
Member 1178659318-Oct-16 0:17 
AnswerRe: Can't insert inkPicture into SQL Server database from C# Pin
OriginalGriff18-Oct-16 0:22
mveOriginalGriff18-Oct-16 0:22 
AnswerRe: Can't insert inkPicture into SQL Server database from C# Pin
Richard Deeming18-Oct-16 1:49
mveRichard Deeming18-Oct-16 1:49 
GeneralRe: Can't insert inkPicture into SQL Server database from C# Pin
Member 1178659318-Oct-16 18:33
Member 1178659318-Oct-16 18:33 

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.