首页 > 解决方案 > 获取“Form1”的“部分声明”不得指定不同的基类

问题描述

我知道还有其他解决方案,但我很新,只是试图制作一个简单的应用程序来从 SQL 返回一些数据以更好地理解事物。如果有人能告诉我声明中哪里出了问题以及我在 XAML 中可能做错了什么(这可能非常愚蠢!),我将不胜感激?

MainWindow.xaml.cs:

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace displaydmlquery
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //variable sql query
            var commandText = "SELECT * FROM dbo.x where xId= + @trid";
            //connection string
            var connectionString = "Server=dbClust\\dx;Database=dbX;Trusted_Connection=True;Integrated Security=True";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(commandText, connection);
                command.Parameters.Add("@trid", SqlDbType.Int).Value = textBox1.Text;

                try
                {
                    connection.Open();
                    var dataAdapter = new SqlDataAdapter(commandText, connectionString);
                    var commandBuilder = new SqlCommandBuilder(dataAdapter);
                    command.ExecuteReader();
                    DataTable dtRecord = new DataTable();
                    dataAdapter.Fill(dtRecord);
                    dataGrid1.ItemsSource = dtRecord.DefaultView;
                }
                catch
                {
                    // to come
                }
                finally
                {
                    connection.Close();
                }
            }
        }
    }
}

MainWindow.xaml:

<Window x:Class="displaydmlquery.Form1"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:displaydmlquery"
        mc:Ignorable="d"
        Title="OpenOrderCheck" Height="450" Width="800">
    <Grid>
        <TextBox x:Name="textBox1" HorizontalAlignment="Left" Height="20" Margin="87,37,0,0" TextWrapping="Wrap" Text="TextBox" VerticalAlignment="Top" Width="95"/>
        <Button x:Name="button1" HorizontalAlignment="Left" Height="20" Margin="217,37,0,0" VerticalAlignment="Top" Width="75" Click="button1_Click"/>
        <DataGrid x:Name="dataGrid1" HorizontalAlignment="Left" Height="155" Margin="87,158,0,0" VerticalAlignment="Top" Width="487"/>

    </Grid>
</Window>

标签: c#wpfdata-binding

解决方案


推荐阅读