咋样看自己这小破程序连上数据库了没?

[shiter]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient; 
using System.Data; 



 


namespace WpfApplication1
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {


     
 
        SqlDataAdapter sda;
        DataTable dt;
 
        void getData()
        {
            //init sqlconnection
            SqlConnectionStringBuilder connbuilder = new SqlConnectionStringBuilder();
            connbuilder.DataSource = "(local)";
            connbuilder.IntegratedSecurity = true;
            connbuilder.InitialCatalog = "season";
 
            //start to make sql query
            SqlConnection conn = new SqlConnection(connbuilder.ConnectionString);
            sda = new SqlDataAdapter("select  Number,name,grade,sex from season.students;", conn);
            SqlCommandBuilder commbuilder = new SqlCommandBuilder(sda);
            sda.UpdateCommand = commbuilder.GetUpdateCommand();
            dt = new DataTable();
            sda.AcceptChangesDuringUpdate = true;
            sda.Fill(dt);
             listView1.ItemsSource = dt.DefaultView;
        }
 
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            getData();
        }
        public MainWindow()
        {
            InitializeComponent();
        }


        private void Window_Loaded(object sender, RoutedEventArgs e)
        {

        }
    }
}

<Window x:Class="WpfApplication1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" mc:Ignorable="d" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" Height="328" Width="551" Loaded="Window_Loaded">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="*" />
            <RowDefinition Height="Auto" />
            <RowDefinition Height="22" />
        </Grid.RowDefinitions>
        <ListView Name="listView1" MinWidth="280" >
            <ListView.View>
                <GridView x:Name="gridView1">
                    <GridViewColumn Header="ContactID" DisplayMemberBinding="{Binding Path=Number}"></GridViewColumn>
                    <GridViewColumn Header="FirstName" DisplayMemberBinding="{Binding Path=name}"></GridViewColumn>
                    <GridViewColumn Header="LastName" DisplayMemberBinding="{Binding Path=grade}"></GridViewColumn>
                    <GridViewColumn Header="EmailAddress" DisplayMemberBinding="{Binding Path=sex}"></GridViewColumn>

                </GridView>
            </ListView.View>
        </ListView>
        <WrapPanel Grid.Row="1" Orientation="Horizontal"></WrapPanel>
        <Button Grid.Row="2" HorizontalAlignment="Right" Click="button1_Click" Name="button1">Refresh</Button>
        <WrapPanel Grid.Row="1" Orientation="Horizontal">
            <StackPanel Orientation="Horizontal" Margin="5,2,5,2">
                <TextBlock Name="textBlock_ContactID" Text="ContactID:" />
                <TextBox Name="textBox_ContactID" MinWidth="100" />
            </StackPanel>
            <StackPanel Orientation="Horizontal" Margin="5,2,5,2">
                <TextBlock Name="textBlock_FirstName" Text="FirstName:" />
                <TextBox Name="textBox_FirstName" MinWidth="100" />
            </StackPanel>
            <StackPanel Orientation="Horizontal" Margin="5,2,5,2">
                <TextBlock Name="textBlock_LastName" Text="LastName:" />
                <TextBox Name="textBox_LastName" MinWidth="100" />
            </StackPanel>
            <StackPanel Orientation="Horizontal" Margin="5,2,5,2">
                <TextBlock Name="textBlock_EmailAddress" Text="EmailAddress:" />
                <TextBox Name="textBox_EmailAddress" MinWidth="100" />
            </StackPanel>
        </WrapPanel>
        
    </Grid>
</Window>

这个小程序怎么跑起来啊,第一天搞.net,求指导

[shiter]

就是连接数据库,读几个值,读到界面里面就ok
用wpf

[bdmh]

建议你别问了，先查查资料，看看书，自己动手谢谢，拿来主义不要玩的太好

[shiter]

[Quote=引用 2 楼 的回复:]

建议你别问了，先查查资料，看看书，自己动手谢谢，拿来主义不要玩的太好
[/Quote]
好的.我先搞着

[wy811007]

你这是wpf 貌似发错地方了 童鞋

[mizuho_2006]

WPF也只能发C#区了，要么就发SilverLight区。其实应该给WPF专门建一个讨论区的。。

[EnForGrass]

[Quote=引用 2 楼 的回复:]

建议你别问了，先查查资料，看看书，自己动手谢谢，拿来主义不要玩的太好
[/Quote]
首先保证连接字符串对了
你直接看 sda.Fill(dt);

dt.Rows.Count得值就行了，Count>0取到了值。反之则反。

[shiter]

[Quote=引用 5 楼 的回复:]

WPF也只能发C#区了，要么就发SilverLight区。其实应该给WPF专门建一个讨论区的。。
[/Quote]
易,wpf不是c#?
我没找着专区

[色拉油]

能读取数据就连上了

[shiter]

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

 sda = new SqlDataAdapter("select  Number,name,grade,sex from students;", conn);

上面这句写的不对么..???

[EnForGrass]

[Quote=引用 9 楼 的回复:]

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.


C# code
sda = new SqlDataAdapter("select Number,name,gra……
[/Quote]
请看字段对不对？

[shiter]

[Quote=引用 10 楼 的回复:]

引用 9 楼 的回复:

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.


C# code
sda = new SqlDataAdapter("select ……
[/Quote]
对着,扔到数据库中可以执行

[shiter]

connbuilder.InitialCatalog
怎么写?

[shiter]

就是这句的问题

sda.UpdateCommand = commbuilder.GetUpdateCommand();