naveed_786's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
Active Members
Active Posts:
299 (0.23 per day)
Joined:
13-October 09
Profile Views:
8,320
Last Active:
User is offline Mar 08 2012 11:35 PM
Currently:
Offline

Previous Fields

Country:
PA
OS Preference:
Windows
Favorite Browser:
Internet Explorer
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
0

Latest Visitors

Icon   naveed_786 has not set their status

Posts I've Made

  1. In Topic: Stop Services

    Posted 7 Jan 2012

    No body has any idea??????????????????????
  2. In Topic: Stop Services

    Posted 31 Dec 2011

    1. My OS is Server 2003 on computer1 and Windows XP on Computer,
    i want to stop services on Computer2 from Computer1.
    2. Yes i have remote permissions
    3. Yes i have access on Server 2003 Computer.
  3. In Topic: SQL Server Setting

    Posted 12 Dec 2011

    Please Follow the link below

    http://www.sqlserver...6712-149-1.aspx
  4. In Topic: Design Custom Reports in VB.NET

    Posted 12 Dec 2011

    Now i am able to get the result as i required.



    But now the problem is this i have created check box in list view in this way

    With ListView1
    .View = View.Details : .CheckBoxes = True : .FullRowSelect = True
    End With

    Now how can i perform conditional checks???

    For Example

    Check Box WO

    Check Box Item

    Check Box EMP

    now the requirement is this when i click in check box which is in front of WO then should list the detail of wo.

    And when i click on the check box in front of Item it should list the detail of ITEM.

    How to achieve this please help me.

    Just advise me how to evaluate

    .checked property of the check box in this Context.
  5. In Topic: Design Custom Reports in VB.NET

    Posted 10 Dec 2011

    Here is my code which displays all the table from a Table space in Oracle

    With ListView1
                .View = View.Details : .CheckBoxes = True : .FullRowSelect = True
            End With
            con.ConnectionString = ConnectionString
            Try
                dsOle.Clear()
                dtOle.Clear()
                cmdOle = con.CreateCommand
                cmdOle.CommandText = "SELECT * FROM TAB"
                da.SelectCommand = cmdOle
                da.Fill(dsOle, "TAB")
                Dim i As Integer = 0
                Dim j As Integer = 0
                For i = 0 To dsOle.Tables(0).Columns.Count - 1
                    Me.ListView1.Columns.Add(dsOle.Tables(0).Columns(i).ColumnName.ToString())
                Next
                For i = 0 To dsOle.Tables(0).Rows.Count - 1
    
                    For j = 0 To dsOle.Tables(0).Columns.Count - 1
    
                        itemcoll(j) = dsOle.Tables(0).Rows(i)(j).ToString()
                    Next
    
                    Dim lvi As New ListViewItem(itemcoll)
                    Me.ListView1.Items.Add(lvi)
                    Me.ListView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent)
    
                Next
            Catch ex As Exception
                If ConnectionState.Open Then
                    con.Close()
                End If
                MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "NO DATA FOUND !!")
            End Try
    



    It works fine now i am using "ListView1_ItemCheck" event when this event fires it should list table column names.

    But the problem is this when i load the form it shows all the Tables

    1. when i click on check box it didn't list all the columns

    2. When i click on a checkbox against WO it should list all the columns of Wo table and when i click on checkbox against KEY_MAKING_REC it should display the columns of KEY_MAKING_REC table

    How to achieve this please guide me.

    Private Sub ListView1_ItemCheck(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles ListView1.ItemCheck
            If e.NewValue = CheckState.Checked Then
                With ListView1
                    .View = View.Details : .CheckBoxes = True : .FullRowSelect = True
                End With
                con.ConnectionString = ConnectionString
                Try
                    dsOle.Clear()
                    dtOle.Clear()
                    cmdOle = con.CreateCommand
                    cmdOle.CommandText = "DESCRIBE WO"
                    da.SelectCommand = cmdOle
                    da.Fill(dsOle, "WO")
                    Dim i As Integer = 0
                    Dim j As Integer = 0
                    For i = 0 To dsOle.Tables(0).Columns.Count - 1
                        Me.ListView1.Columns.Add(dsOle.Tables(0).Columns(i).ColumnName.ToString())
                    Next
                    For i = 0 To dsOle.Tables(0).Rows.Count - 1
    
                        For j = 0 To dsOle.Tables(0).Columns.Count - 1
    
                            itemcoll(j) = dsOle.Tables(0).Rows(i)(j).ToString()
                        Next
    
                        Dim lvi As New ListViewItem(itemcoll)
                        Me.ListView1.Items.Add(lvi)
                        Me.ListView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent)
    
                    Next
                Catch ex As Exception
                    If ConnectionState.Open Then
                        con.Close()
                    End If
                    MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "NO DATA FOUND !!")
                End Try
            End If
        End Sub
    

My Information

Member Title:
D.I.C Regular
Age:
26 years old
Birthday:
February 4, 1987
Gender:
Location:
PK
Interests:
Client Server Applications
Full Name:
Naveed Akhter
Years Programming:
3
Programming Languages:
C++,C,C#,VB.NET,Deleveloper Forms 6i

Contact Information

E-mail:
Private
MSN:
MSN  mrakhter_786@hotmail.com
Yahoo:
Yahoo  mrakhter_786@Yahoo.com

Friends

Comments

naveed_786 has no profile comments yet. Why not say hello?