welbert wrote: on my database i have 5 different record but they have same Venue field name... Do you mean that in a table you have 5 rows with the same Venue column value? I'm trying to clarify because SQL Server 2000 will not permit you to have the same column name 5 times in one table. welbert wrote: i need to get the first record that was inputed to the database and display on the screen. Do you have any columns that indicate the order that the row was inserted into the table? e.g. a column representing an incrementing id, or a datetime column that represents when the data was inserted? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

welbert wrote: Need help on how to display one record with same data to the other record but different reference id... using sql 2000 You are going to have to explain better because I don't know what you mean. Do you mean you want to know what rows in a table contain duplicate data but where the primary keys are different? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

welbert wrote: how to display the day of the week using a variable that has a datatype of intger Dim DayOfTheWeek As Integer DayOfTheWeek = Now.DayOfWeek Or you want to get it from the DateTimePicker Dim DayOfTheWeek As Integer DayOfTheWeek = cdDateTimePicker.Value.DayOfWeek chatura

See my reply here[^]. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

See my reply here[^]. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Well, out of the 18 posts you have on CP, 1/3rd of them have asked this very question. And you specifically asked for the "full version", for which there is no free legal download. If all you wanted was the free trial version, a simple Google search for "Flex Cell 2.0" would have given you the answer in under 10 seconds. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

You can use Now.DayOfWeek.ToString 'OR Now.ToString("dddd") !alien!

You can download a free trial[^]. Tech, life, family, faith: Give me a visit. I'm currently blogging about: Connor's Christmas Spectacular! Judah Himango

Google[^] is your friend. Get to know it. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

msflexgrid1.row=3 msflexgrid1.col=5 msflexgrid1.text="Hello" This code is to display "hello" in the location 3,5

Hello welbert, There was a Microsoft FlexGrid for VB 6, but it should still be available in .NET, although it will probably not . Is this what you are using. It was based on an old version of our VSFlexGrid. We, ComponentOne, also have an updated FlexGrid for .NET 1.x and 2.0. I am not sure which one you are using, but each version has the rows indexed from 0, so you are right to start intCount at 0. Keep in mind that 0 to 10 is 11 rows, not 10 rows. If you want to add "Hello" to all rows, it would be better to use For intCount = 0 to Grid1.Rows.Count -1 Grid1.Cell(0, intCount).Text = "Hello" Next This way you know that the index will always be in range, even if rows are added or deleted later. If you still have trouble, please let me know exactly which grid you are using, and which build, then I can provide better assistance. Suelinda W Customer Engagement, ComponentOne LLC

You are the best man.... Thanks many times.... :-D

For what? You haven't asked a question anyone can answer. Quite literaly, your asking "how can I customize my car?". I'm asking you what you want to customize. Paint job? Engine? Exhaust? Body work? Interior? Sound system? The quality of answer you get is directly related to the quality of the question. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Do you want to specify HOW you want to customize the DataGrid, or are we just supposed to guess at the couple hundred things you could do to it? Not to mention, you didn't say WHICH DataGrid - Windows Forms DataGrid, Web Forms DataGrid? VB.NET 2002, 2003, or 2005? At this point, the only thing we can do is direct you to a search for "Customize DataGrid[^]". RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

welbert wrote: How do i get the maximum number of days in a month Date.DaysInMonth(theYear, theMonth) welbert wrote: how to display the current Time with a format (ex. 10:00 am) Set the following DateTimePicker properties in the designer... Format = Custom CustomFormat = h:mm tt See MSDN for more formatting codes. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp[^] welbert wrote: how to get the number of days from the first date that i picked until to the last date Get the selected date and time from the picker like this... Dim myDate As Date = myDateTimePicker.Value Get the number of days like this... myDate1.Subtract(myDate2).TotalDays

Yes, a DataGrid would be fine, and the web is full of samples, just google. Christian Graus - Microsoft MVP - C++