无法获取数据库表值... [英] Trouble obtaining database table values...

查看:77
本文介绍了无法获取数据库表值...的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我需要一些建议...


我在visual studio 2005中创建了一个表单,用户可以在两个日期之间选择。我放了两个dateTimePickers和一个View Button。当用户单击视图按钮时,我有一个sql命令,该命令应该从sql server 2005中的表''Guest''和table''Sales''中检索所有值。

我的代码看起来像这样:

(c-sharp)

Hi, I need some suggestions...

I have created a form in visual studio 2005 in which a user chooses between two dates. I placed two dateTimePickers and a View Button. When the user clicks the view button, I have a sql command that is supposed to retrieve all values from both table ''Guest'' and table ''Sales'' in sql server 2005.
My code looks like this:
(c-sharp)

展开 | 选择 | Wrap | 行号

推荐答案

有没有办法从两个表中检索所有信息到textBox?有没有人试过这样的东西?....
Is there any way to retrieve all the info from two tables into a textBox? has anyone ever tried something like it?....



我需要一些建议......


我在visual studio 2005中创建了一个表单,用户可以在两个日期之间选择。我放了两个dateTimePickers和一个View Button。当用户单击视图按钮时,我有一个sql命令,该命令应该从sql server 2005中的表''Guest''和table''Sales''中检索所有值。

我的代码看起来像这样:

(c-sharp)
Hi, I need some suggestions...

I have created a form in visual studio 2005 in which a user chooses between two dates. I placed two dateTimePickers and a View Button. When the user clicks the view button, I have a sql command that is supposed to retrieve all values from both table ''Guest'' and table ''Sales'' in sql server 2005.
My code looks like this:
(c-sharp)
展开 | 选择 | Wrap | 行号



您可以发布这两个表的结构吗?


- CK
is it ok for you to post the structure of these two tables?

-- CK



当然......这是在下面,对不起大小......这件事没有不允许任何更大的。





Sure...Here it is below, sorry for the size...this thing doesn''t allow any bigger.

附图像
GuestNSales.JPG (12.9 KB,128 views)
Attached Images
GuestNSales.JPG (12.9 KB, 128 views)


这篇关于无法获取数据库表值...的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆