大家好，请帮助我。 [英] hello every one,plz help me.

问题描述

SQL表中有4列（A，B，C，D）和3个不同变量@abc，@ bcd和@cda中的3个字符串，存储在3个文本框中。

和sql语句是

there are 4 columns(A,B,C,D) in SQL Table and 3 string in 3 different variable @abc, @bcd and @cda, stored from 3 textboxes.
and the sql statement is

SqlDataAdapter da = new SqlDataAdapter("select * from Table where (A=@abc OR A=@bcd OR A=@cda) AND (B=@abc OR B=@bcd OR B=@cda) AND (C=@abc OR A=@bcd OR A=@cda) AND (C=@abc OR C=@bcd OR C=@cda) AND (D=@abc OR D=@bcd OR D=@cda)", cn);
DataSet ds = new DataSet();
da.Fill(ds, "stk");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "stk";

问题是，如果B列中没有相关字符串（@ abc，@ bcd，@ cda）数据（例如），则不会在gridview中显示数据。

i想要在gridview中显示数据的SQL语句，如果任何一列中都没有数据。

The problem is that if there No related string(@abc,@bcd,@cda) data is present in Column B(for Ex.), its not show the data in gridview.
i want the SQL statement which show data in gridview, if there No data present in any one column.

推荐答案

试试这个

Try this

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%' OR
D LIKE 'ATM%' OR
D LIKE 'BHILAI%' OR
D LIKE 'G.E.%') or(W LIKE 'S.B.I.%' OR
W LIKE 'ATM%' OR
W LIKE 'BHILAI%' OR
W LIKE 'G.E.%') or(X LIKE 'S.B.I.%' OR
X LIKE 'ATM%' OR
X LIKE 'BHILAI%' OR
X LIKE 'G.E.%') or(Z LIKE 'S.B.I.%' OR
Z LIKE 'ATM%' OR
Z LIKE 'BHILAI%' OR
Z LIKE 'G.E.%') or (AC LIKE 'S.B.I.%' OR
AC LIKE 'ATM%' OR
AC LIKE 'BHILAI%' OR
AC LIKE 'G.E.%')

或者如果您知道这些文本框将包含哪些内容，请查看您的列值，然后相应地将它们置于条件中，例如第一个文本框将包含要在D列中搜索的值，第二个文本框值将具有要搜索列W的值，依此类推

Or looking at your column values if you know what those textboxes are going to contain then accordingly put them in condition, e.g. 1st textbox will have values to be searched in column D , 2nd text box value will have values to be searched for column W and so on

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%') AND (
W LIKE 'BHILAI%') 

依此类推

SqlDataAdapter da = new SqlDataAdapter（@select * from Table where（A = @ abc OR A = @ bcd OR A = @ cda）AND（B = @ abc OR B = @ bcd OR B = @cda）AND（C = @ abc OR A = @ bcd OR A = @ cda）AND（C = @ abc OR C = @ bcd OR C = @ cda）AND（D = @ abc OR D = @ bcd OR D = @ cda），cn）;

DataSet ds = new DataSet（）;

da.Fill（ds，stk）;

dataGridView1.DataSource = ds;

dataGridView1.DataMember =stk;

SqlDataAdapter da = new SqlDataAdapter(@"select * from Table where (A=@abc OR A=@bcd OR A=@cda) AND (B=@abc OR B=@bcd OR B=@cda) AND (C=@abc OR A=@bcd OR A=@cda) AND (C=@abc OR C=@bcd OR C=@cda) AND (D=@abc OR D=@bcd OR D=@cda)", cn);
DataSet ds = new DataSet();
da.Fill(ds, "stk");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "stk";

使用左外连接和fK表示。

use left outer join and fK for your tables.

这篇关于大家好，请帮助我。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！