VB6 SQL和Datagrid [英] VB6 SQL and Datagrid

问题描述

我有一个表字段FirstName，Spouse Name，DateOfBirth，SpouseDateOfBirth和周年纪念日。我想创建一个具有两个网格和两个微调按钮的表单。从微调按钮我想选择天数我的意思是1到3天。当我更改按钮的值时，必须更新两个网格，一个用于生日，第二个用于周年纪念。如果在任何情况下没有输入配偶名称，我想选择添加''*''的名字。配偶A是名字B是他的配偶，配偶名称未提及但在选定日期没有A的生日但由于没有配偶名称网格必须显示A **这样。如果可能的话，plz引导我将网格数据插入表中，以便我可以创建报告。



非常感谢提前。希望得到更早的帮助。

I am having a table fields FirstName, Spouse Name, DateOfBirth, SpouseDateOfBirth and anniversary date. I want to create a form having two grid and two spinners buttons. From spinner buttons I want to select days I mean 1 to 3 days. When I change the value of buttons both grids one for birthdays and second for anniversary had to be updated. If in any case spouse name is not entered I want to pick firstname with addition of ''*''. Spouse A is first name B is his spouse, spouse name not mentioned but on selected date there is not birthday of A but due to un presence of spouse name grid had to be show A** like this. If possible plz guide me to insert the grid data into table so that I can create reports.

Thanks a lot in advance. Hoping for an earlier favour.

推荐答案

阅读本文： http://www.dreamincode.net/forums/topic/24677-connecting-to-a-sql-server-database-using-adodb/ [ ^ ]并尝试做你需要的事情。



要建立到ms访问数据库的连接字符串，请看：http://www.connectionstrings.com/access [ ^ ]

Read this: http://www.dreamincode.net/forums/topic/24677-connecting-to-a-sql-server-database-using-adodb/[^] and try to do what you need.

To build connectionstring to ms access database, see this: http://www.connectionstrings.com/access[^]

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