问题描述
嗨。
这是我的程序。
Hi.
This is my program.
try
{
con.open();
{
da=new oledbdataadapter("Select modelname from table where type='gate' and min<='"+textbox1.text+"' and max>='"+textbox1.text+"'",con);
ds.Fill(da,"main");
if(tables[0].rows.count>1)
{
datagridview1.datasource=ds;
datagridview1.datamember=main;
}
else
{
datagridview1.datasource=null;
}
这里我给出了每个型号的最小和最大范围。如果我给textbox1中的任何数字，它应该比较最小和最大范围之间的值并给出结果..
例如;
型号名称：zeta，
min = 200
max = 250
type = gate
如果我给210，它应该给出相应的型号名称。
但它显示所有的字段有2,1,0,21,20,210,10。
请帮我解决这个问题。
Here i given min and max range for every model.If i give any number in textbox1 , it should compare the values between min and max range and gives the result..
For example;
Model Name : zeta,
min=200
max=250
type=gate
If i give 210, it should give respective model name which have comes in that range.
but it displays all fields which have 2,1,0,21,20,210,10.
please help me for this issue.
推荐答案
Parameters [myVal] Integer
SELECT modelname
FROM [table]
WHERE [type]='gate' and [min]<=[myVal] and [max]>=[myVal]
但是，正如我上面提到的，我强烈建议你更改字段的名称！
如何调用以上查询？看看 [] property。
But, as i mentioned above, i would strongly recommend you to change the name of fields!
How to call above query? Have a look at OleDbCommand.Parameters[^] property.
这篇关于使用C＃和Ms Access的Oledb数据适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！