Click here to Skip to main content
12,077,357 members (48,910 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB VB.NET
I am Using below CODE DGV HeaderText Purpose..
Dim strSQL7 As String = "SELECT STUFF((SELECT DISTINCT '],['+ [FeesType] FROM FeeMaster WHERE Class='" & cboClass.Text & "' ORDER BY '],[' + [FeesType]  For XML Path('')), 1, 2,'') + ']' "
      Dim DaAp7 As New SqlDataAdapter(strSQL7, con)
        Dim Dset7 As New DataTable
        DaAp7.Fill(Dset7)
       
        With Me.DataGridView2
            .Columns.Add("Regno", "RegNo")
            .Columns.Add("Sname", "Name")
            .Columns.Add(0, Dset7.Rows(0).Item("Column1"))
           .Columns.Add("", "Total")
        End With

Wht is my Error : Team1 and Team-2 Show to Column3

Regno Name [Team-1],[Team-2] Total

i Need Seperate Team1 and Team2 Like

Regno Name Team-1 Team-2 Total

Please Tell me how can i do for Seperate
Posted 14-Feb-13 8:46am
Edited 14-Feb-13 8:59am
RyanDev193.6K
v2
Comments
richcb 14-Feb-13 14:13pm
   
What do you mean "What is my error"? That is what you are supposed to tell us. Are you getting an error message? Are you getting results you do not expect? Are you not getting any results at all? Does your code compile? Have you debugged it?
Navas Khanj 14-Feb-13 14:15pm
   
DGV headertext want to display colum3 seperate
Ashok19r91d 15-Feb-13 7:39am
   
Try This...
With Me.DataGridView2
.Columns.Add("Regno", "RegNo")
.Columns.Add("Sname", "Name")
.Columns.Add("Col1", Dset7.Rows(0).Item("Column1"))
.Columns.Add("", "Total")
End With
Navas Khanj 15-Feb-13 9:39am
   
It's not Work For Seperate

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160212.1 | Last Updated 14 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100