如何从两个不同的表中获取数据 [英] How to fetch data from two different table

问题描述

我的代码在下面

{

my code is below
{

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\New_Project\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
        SqlCommand cmd = new SqlCommand("select * from Purchase_Raw_Material where Item_Code = '" + txticode.Text + "' ", con);
        SqlCommand cmd1 = new SqlCommand("select * from Sales where Item_Code = '" + txticode.Text + "' ", con);
        con.Open();
        SqlDataReader DR1 = cmd.ExecuteReader();
        if (DR1.Read())
        {

            TextBox1.Text = DR1.GetValue(2).ToString();
            TextBox2.Text = DR1.GetValue(2).ToString();
            GridView1.DataBind();
            con.Close();
        }
        
        
        
    }

推荐答案

根据您的代码，为第二个表结果集创建另一个SqlDataReader。或者您也可以使用DataAdapter和DataSet。

Based on your code, Create another SqlDataReader for 2nd table resultset. Or you could use DataAdapter & DataSet too.

您可以编写单个查询以使用join从这两个不同的表中获取记录，并尝试执行该单个查询。

You can write single query for fetching records from these two different tables using join, and try to execute that single query.

选择Purchase_Raw_Material。*

来自Purchase_Raw_Material r内部联接销售

on Purchase_Raw_Material.Item_Code = Sales.Item_Code

其中Item_Code = '+ txticode.Text +'



你可以从任何表中选择那些列中的select语句，因为我选择了Purchase_Raw_Materialable中的所有列

select Purchase_Raw_Material.*
from Purchase_Raw_Material r inner join Sales
on Purchase_Raw_Material.Item_Code = Sales.Item_Code
where Item_Code = '" + txticode.Text + "'

you can select those column from any table with select statement from any table as i select all columns from Purchase_Raw_Materialable

这篇关于如何从两个不同的表中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！