SELECT * FROM table1，table2如何 [英] SELECT * FROM table1,table2 how to

问题描述

这不起作用，但我没有收到任何错误？我想从两个表中选择？

This isnt working but i dont get any errors? i want to select from two tables?

using (var cmd = new SqlCommand("SELECT * FROM [FakturaDB].[dbo].[FakturaDB_Faktura];SELECT * FROM [FakturaDB].[dbo].[FakturaDB_Produkt];" , con))

更新

__________________________________

UPDATE
__________________________________

const string constring = @"Data Source = MARTIN; Initial Catalog = FakturaDB;Integrated Security = True";
           using (var con = new SqlConnection(constring))
           {
               con.Open();
               using (
                   var cmd =
                       new SqlCommand(
                           "SELECT * FROM [FakturaDB].[dbo].[FakturaDB_Faktura]; SELECT * FROM [FakturaDB].[dbo].[FakturaDB_Produkt];",
                           con))

               {
                   dataGridViewAllaFakturor.ColumnCount = 5;
                   cmd.CommandType = CommandType.Text;
                   using (var sda = new SqlDataAdapter(cmd))
                   {

                       dataGridViewAllaFakturor.AutoGenerateColumns = false;
                       dataGridViewAllaFakturor.ReadOnly = true;
                       dataGridViewAllaFakturor.Columns[0].DataPropertyName = "FakuturaNr";
                       dataGridViewAllaFakturor.Columns[0].Name = "FakturaNr";
                       dataGridViewAllaFakturor.Columns[0].HeaderText = @"FakturaNr";
                       dataGridViewAllaFakturor.Columns[1].DataPropertyName = "KundFaktura";
                       dataGridViewAllaFakturor.Columns[1].Name = "Kund";
                       dataGridViewAllaFakturor.Columns[1].HeaderText = @"Kund";
                       dataGridViewAllaFakturor.Columns[2].DataPropertyName = "FakturaDatumFran";
                       dataGridViewAllaFakturor.Columns[2].Name = "Skickad";
                       dataGridViewAllaFakturor.Columns[2].HeaderText = @"Skickad";
                       dataGridViewAllaFakturor.Columns[3].DataPropertyName = "Forfallodatum";
                       dataGridViewAllaFakturor.Columns[3].Name = "Förfaller";
                       dataGridViewAllaFakturor.Columns[3].HeaderText = @"Förfaller";

                       dataGridViewAllaFakturor.Columns[4].DataPropertyName = "PrisExklMoms";
                       dataGridViewAllaFakturor.Columns[4].Name = "Summa";
                       dataGridViewAllaFakturor.Columns[4].HeaderText = @"Summa";
                       var dt = new DataSet();
                       sda.Fill(dt);

                       dataGridViewAllaFakturor.DataSource = dt;

推荐答案

我强烈建议您阅读：

SELECT示例（Transact-SQL） [ ^ ]

SQL连接的可视化表示 [ ^ ]

I strongly recommend to read this:
SELECT Examples (Transact-SQL)[^]
Visual Representation of SQL Joins[^]

SELECT t1.*, t2.*
FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.Key = t2.ForeignKey

使用 DataAdapter [ ^ ]或数据集 [ ^ ] 。要绑定数据，请尝试：

Use DataAdapter[^] or DataSet[^]. To bound data, try:

DataGridView1.DataSource = DataSet.Tables(0)
DataGridView2.DataSource = DataSet.Tables(1)

[/ EDIT ]

[/EDIT]

查询字符串中存在两个不同的select。将它们分成两个不同的SqlCommand（至少，使用单个SqlCommand的不同时间），例如：

there exist two different 'select' in your query string. divide them into two different SqlCommand (at least, different times with a single SqlCommand) like:

using(cmd = new SqlCommand("query1")) {
 SqlDataReader reader = cmd.ExecuteReader();
 // do someting

 cmd.CommandText = "query2";
 reader = cmd.ExecuteReader();
 // do some other thing.
}

见这里： SqlCommand [ ^ ]

和这里：SqlDataReader [ ^ ]

这篇关于SELECT * FROM table1，table2如何的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！