C# .NET - how to bind data into GridView + WPF

 Following Code is unable to bind data into Grid

<Button Height="23" Margin="0,12,35,0" Name="button1" VerticalAlignment="Top" HorizontalAlignment="Right" Width="46" Click="button1_Click">Go</Button>

<ListView Name="listView1" Margin="0,41,0,0">

<ListView.View>

<GridView>

<GridViewColumn Header="User_Name" Width="100" DisplayMemberBinding="{Binding Path=User_Name}"/>

<GridViewColumn Header="Project_Name" Width="100" DisplayMemberBinding="{Binding Path=Project_Name}" />

<GridViewColumn Header="CD_Name" Width="100" DisplayMemberBinding="{Binding Path=CD_Name}"/>

<GridViewColumn Header="IsOracle" Width="100" DisplayMemberBinding="{Binding Path=IsOracle}" />

</GridView>

</ListView.View>

</ListView>

</Grid>

</Window>

 

private void button1_Click(object sender, RoutedEventArgs e)

{

DataSet ds = new DataSet();

string sql = "select * from tblOTRecord order by Project_Name";

ds = ClsDBAccess.mGetOrcDataset(sql, ClsDBAccess.eConn.INTRANET); // Custom method, it is ok, getting rows

if(ds.Tables[0].Rows.Count > 0)

{

Binding bind = new Binding();

listView1.DataContext = ds.Tables[0];

listView1.SetBinding(ListView.ItemsSourceProperty, bind);

}

}

Hi

Just simple

Following Code is unable to bind data into Grid

<Button Height="23" Margin="0,12,35,0" Name="button1" VerticalAlignment="Top" HorizontalAlignment="Right" Width="46" Click="button1_Click">Go</Button>

<ListView Name="listView1" Margin="0,41,0,0">

<ListView.View>

<GridView>

<GridViewColumn Header="User_Name" Width="100" DisplayMemberBinding="{Binding Path=User_Name}"/>

<GridViewColumn Header="Project_Name" Width="100" DisplayMemberBinding="{Binding Path=Project_Name}" />

<GridViewColumn Header="CD_Name" Width="100" DisplayMemberBinding="{Binding Path=CD_Name}"/>

<GridViewColumn Header="IsOracle" Width="100" DisplayMemberBinding="{Binding Path=IsOracle}" />

</GridView>

</ListView.View>

</ListView>

</Grid>

</Window>

 

private void button1_Click(object sender, RoutedEventArgs e)

{

DataSet ds = new DataSet();

string sql = "select * from tblOTRecord order by Project_Name";

ds = ClsDBAccess.mGetOrcDataset(sql, ClsDBAccess.eConn.INTRANET); // Custom method, it is ok, getting rows

if(ds.Tables[0].Rows.Count > 0)

{

listView1.ItemSource= ds.Tables[0].DefaultView;


}

}

NOTE:Please add this property in your list view 

<ListView Name="listView1" Margin="0,41,0,0" ItemSource="{Binding}">
////
</ListView >


Thank you
http://www.codegain.com

After clicking the button, gridview is getting scrollbar but columns are not visible.

Please guide

end of post

Hi

Are you  check your query column and DataBindinfMember Name are same( even case sensitive also)

Please make sure.and try if you have any question, please email my email(becuase of not working email in eggheadcafe)

vrrave@gmail.com


thank you
http://www.codegain.com

I have textbox that is showing no. of rows load via dataset.

GridView is also getting vertical scroll after filling, but not the data.

THANKS ALOT RAVEEN - For solving my query

end of post