473,466 Members | 1,336 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

hOW TO SELECT dbgrid

2 New Member
Dear Friends,

I have two similar .dbf files(FOxPro 3.0)
1st one is filled "Trans.dbf" the next is a blank similar "current.dbf"
I have two DBGRIDS in the form.
I can see the contents of the Trans.dbf in the text boxes & on the DBGRID1 control.

What I need is ,If I click on a particular record on DBGRID1 it should get selected & must be transferred to DBGRID2 so that I can update the blank "Current.dbf" with the selected record from DBGRID1.
How is this possible?

Another query is if I need to convert String to Date how can it be done?

Rahul
Mar 27 '07 #1
2 1467
ansumansahu
149 New Member
Dear Friends,

I have two similar .dbf files(FOxPro 3.0)
1st one is filled "Trans.dbf" the next is a blank similar "current.dbf"
I have two DBGRIDS in the form.
I can see the contents of the Trans.dbf in the text boxes & on the DBGRID1 control.

What I need is ,If I click on a particular record on DBGRID1 it should get selected & must be transferred to DBGRID2 so that I can update the blank "Current.dbf" with the selected record from DBGRID1.
How is this possible?

Another query is if I need to convert String to Date how can it be done?

Rahul
Hi ,
>>Another query is if I need to convert String to Date how can it be done?

You can use the DateValue function in VB.

Public Function DateValue(ByVal StringDate As String) As DateTime

Dim myDate As Date
myDate = DateValue("February 2, 1975")

thanks
ansuman sahu
Mar 27 '07 #2
dsrahul
2 New Member
Hi ,
>>Another query is if I need to convert String to Date how can it be done?

You can use the DateValue function in VB.

Public Function DateValue(ByVal StringDate As String) As DateTime

Dim myDate As Date
myDate = DateValue("February 2, 1975")

thanks
ansuman sahu
Thank you Ansuman,

But I can not go ahead with date function until I get the 1st problem sorted out,
Can you help?
Rahul
Mar 27 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Paolo | last post by:
Hi to all, could you please help me with this issue? I'd like to have the rows of a VB6 ADO grid bound to a db painted with an alternate background and foreground colors. I'd like to have the odd...
1
by: mehafi | last post by:
hello how could I get value showing in DBGrid table to a variable? For egzamle: I'd like to get value from 3'rd collumn and 2'nd row and put it into a variable "int z". How coul I do it? - what...
4
by: Ramtin | last post by:
Hi I have a DBGrid which returns some Arabic data .The charset of web page is utf-8 and anything on page is OK except DBGrid header titles . I set these titles through DBGrid Property Builder ,...
0
by: Ramtin | last post by:
Hi I have a DBGrid which returns some Arabic data .The charset of web page is utf-8 and anything on page is OK except DBGrid header titles . I set these titles through DBGrid Property Builder ,...
1
by: Wilfried Mestdagh | last post by:
Hi, If you doubleclick on a dbgrid title separator the column automticly resize to his minumum width. How to do this in code ? -- rgds, Wilfried http://www.mestdagh.biz
1
by: Bill | last post by:
I need help!!! I have a form that is populated with a dbgrid from a Access database. When I open the form, it has 17 records. When i click on a record, I need a different form to open and go to...
3
by: nano9 | last post by:
Hola gente quisiera que alguien me pudiera ayudar con un problemilla que tengo, resulta que estoy programando en ASP con C# y estoy usando un cadbgrid que se comporta parecido a un datagrid o...
2
by: nano9 | last post by:
Hi. Maybe someone can help me with a small problem. I am programming in ASP using C# and I am using a cadbgrid which acts similar to a datagrid or dbgrid but it has some peculiarities that make for...
0
by: Quadran | last post by:
Hello everybody, I am new here and therefore hope nothing doing wrong, I have a DBGrid in C++ Builder 6.0 containing 26 cells and 12 rows In each cell there is a number stored and this...
1
by: stv972 | last post by:
Im a newbie in vb programming. i got to learn the loops thru books and surfing the net. Nwys im making a program now and m using dbgrid where i want to add data directly to the grid. I have already...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.