Sign in
 
Visual C# Developer Center > Visual C# Forums > Visual C# General > hoe to creat dataset in C# and access it ?? hw can i do connesction with datagridview in WPF ??
Ask a questionAsk a question
Search Forums:
 

Answerhoe to creat dataset in C# and access it ?? hw can i do connesction with datagridview in WPF ??

  • Wednesday, November 04, 2009 5:46 AManiruddha84 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    hi all ,

    i wann to knw tat .. suppose i hav keyvaluepaire and i wann to store it in to my dataset or database and againg i wann to access this database or dataset in to my datagridview in WPF ??

    hw can i do it ? any help out thr pls

    thx in advance
     

Answers

  • Wednesday, November 04, 2009 11:00 AMNagarjunaDilip Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     AnswerHas Code
    Sign In to Vote
    0
    Sign In to Vote
    Hi,<br/>
<br/>
<ListView Margin="42,25,74,73" Name="listView1" ItemsSource="{Binding}"    >
            <ListView.ItemContainerStyle>
                <Style TargetType="{x:Type ListViewItem}">
                    <Setter Property="HorizontalContentAlignment" Value="Left" />                    
                    <Setter Property="BorderBrush" Value="Red" />
                    <Setter Property="BorderThickness" Value="1" />
                    <Setter Property="Foreground" Value="Black" />
                  <Setter Property="Background" Value="DarkGray" />
                    <Style.Triggers>
                        <Trigger Property="IsMouseOver" Value="true">
                            <Setter Property="Foreground" Value="White" />
                            <Setter Property="Background">
                                <Setter.Value>
                                    <LinearGradientBrush EndPoint="0.5,1" StartPoint="0.5,0">
                                        <GradientStop Color="LightGray" Offset="0.986" />
                                        <GradientStop Color="LightGray" Offset="0.5" />
                                        <GradientStop Color="LightGray" Offset="0.51" />
                                    </LinearGradientBrush>
                                </Setter.Value>
                            </Setter>
                        </Trigger>
                    </Style.Triggers>
                </Style>
              
            </ListView.ItemContainerStyle>
            <ListView.View>
                <GridView x:Name="grdDisp">
                    <GridView.ColumnHeaderContainerStyle>
                        <Style  TargetType="{x:Type GridViewColumnHeader}">                            
                            <Setter Property="BorderBrush" Value="Red" />                            
                            <Setter Property="BorderThickness" Value="1" />                            
                        </Style>
                    </GridView.ColumnHeaderContainerStyle>
                    
                    <GridViewColumn Header="ID"  Width="100"  DisplayMemberBinding="{Binding Path=ID}"  ></GridViewColumn>
                    <GridViewColumn Header="Name"  Width="100" DisplayMemberBinding="{Binding Path=Name}"></GridViewColumn>
                    <GridViewColumn Header="Desig"  Width="100" DisplayMemberBinding="{Binding Path=Desig}"></GridViewColumn>                
                </GridView>
            </ListView.View>
        </ListView>




System.Data.DataTable dt;
        private void btnGenerate_Click(object sender, RoutedEventArgs e)
        {
            if (dt == null)
            {
                dt = new System.Data.DataTable();
                dt.Columns.Add("ID");
                dt.Columns.Add("Name");
                dt.Columns.Add("Desig");               
            }
          
           
            for (int i = 0; i < 10; i++)
            {
                System.Data.DataRow dr = dt.NewRow();
                dr[0] = i.ToString();
                dr[1] = "TestName"; 
                dr[2] = "TestDesig";                
                dt.Rows.Add(dr);
            }
            dt.DefaultView.Sort = "Name";
            listView1.ItemsSource = dt.DefaultView;            
           
        }


Hope This Helps...........
    Nagarjuna Dilip
     

All Replies