Re: Create Hotel Room Booking Calendar - C# Discussion Boards

Re: How to send cell value from DataGrid to text file?

3-Dec-14 6:31

Member 10024517 wrote:
I have a problem

You need to explain clearly what that problem is if you want assistance.

Member 100245173-Dec-14 7:41

Member 10024517

3-Dec-14 7:41

I will paste my code later, but what I want is to save (export) data from data grid to text file. For example we have few columns number|data|description|date|img with few rows. Then I want to save that to text file in format
number///data///description///date//img (one row for one line in text file).

Create Hotel Room Booking Calendar

KissGnv2-Dec-14 23:44

2-Dec-14 23:44

Could you recommend me a method how to create a hotel room booking calendar like this?
http://www.daypilot.org/tutorial/hotel/[^]

I have two ideas and I tried to create the calendar, but I have problems with it.

1. idea: Create a DataGridView. It is good because there are cells and header cells in it, it is scrollable, but I can't insert controls in the cells (button or panel) which would show the reservations through days (like in the example) because column span is not supported by the datagridview.

2. idea: Use a TableLayoutPanel. It supports column spanning and I can insert any type of Control in its cells, so I can insert controls which shows the interval, name, etc.. of the room reservation and it can overlap many cells. The only problem is that I have to create row headers and column headers. I created another tablelayoutpanel over the table, it would be the column header. The header would horizontally scroll simultaneously with the main table, but if I turn autoscroll on, the scollbar is visible and it is not good. If I turn off autoscroll, I can't scroll the panel from code. It would be good if I could create an independent hscrollbar and in it's scroll event I could set the header and main tablelayoutpanels scroll position simultaneously.

Have you any ideas?

ixilom3-Dec-14 1:35

ixilom

3-Dec-14 1:35

If you only need to display data I would still go for the DataGridView.
You can inherit DataGridViewCell and DataGridViewColumn to display pretty much anything you want by drawing things with the provided Graphics object in a overridden Paint (and PaintBorder) method.
Even if you need to edit some small things like, checkboxes it should be quite trivial to implement by drawing it yourself (lookup ControlPaint class) and handle mouse input.

For the how-to, I would suggest reading Robert Kanasz article: How to Create ProgressBar Column in DataGridView[^]
Also, look at Microsoft's documentation:
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell%28v=vs.110%29.aspx
[^]
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcolumn%28v=vs.110%29.aspx[^]

If you need to have some sort of Control in a cell, you can still use the DataGridView, but it gets a bit more complex:
http://msdn.microsoft.com/en-us/library/7tas5c80.aspx?PHPSESSID=o1fb21liejulfgrptbmi9dec92[^]
The approach is almost the same, but you need to, in addition to the cell and column, create a control that implements IDataGridViewEditingControl.

Hope this was helpful Smile | :)

KissGnv3-Dec-14 3:05

3-Dec-14 3:05

Thank You! These articles are goood. Unfortunately, column spanning is still a problem. Frown | :(

BillWoodruff3-Dec-14 1:36

3-Dec-14 1:36

Are you doing this as an on-line project hooked up to a DataBase in ASP.NET ... your use of 'TableLayouPanel suggests this is a WinForms project, while 'DayPilot is meant to be used on-line ?

Do Note that DayPilot has an open-source ASP.NET "lite" version, and a MonthPicker version available for download: [^]. You might get some good ideas studying their source code ?

My experiments with the WinForm TableLayoutPanel a few years ago found it got really slow in scrolling when trying to implement lots of Controls in lots of rows, and columns. But, maybe that was related to my using slow hardware.

Why couldn't you use Row #0 to hold Column Names, and Column #0 to hold Row Names ?

«OOP to me means only messaging, local retention and protection and hiding of state-process, and extreme late-binding of all things. » Alan Kay's clarification on what he meant by the term "Object" in "Object-Oriented Programming."

KissGnv3-Dec-14 3:11

3-Dec-14 3:11

Thanks for answering! I am making a windows forms application. I haven't studied the daypilot's source code because it is an ASP.NET control. After your suggestion, I think tablelayoutpanel is not a good solution. So I should add a control (button or panel) to a datagridview, but that control should overlap many cells if the reservations are longer then one day.

BillWoodruff3-Dec-14 12:47

3-Dec-14 12:47

KissGnv wrote:
After your suggestion, I think tablelayoutpanel is not a good solution

Please, note that I did not directly advise you to avoid using a TableLayoutPanel; I simply told you about my experience a few years ago with it.

I strongly advise you to check out Jing Lu's open-source ReoGrid Control which has an article on CodeProject here: [^], and a web-site here: [^]. ReoGrid does everything but walk your dog, and is very, very fast. Note that the license model for ReoGrid may have changed, on the article on CP it's LPGL; I have written Jing asking him to clarify the current license model.

Why not create a prototype to test, on the type of hardware you'll run your app on, that loads a TableLayoutPanel with as many Controls with synthesized sample data as you think you might need a maximum of, and then observe the speed of response.

Here's some code I used a few years ago: [^]. I suggest you increase the integer Constants that control the number of Rows, and Column, and observe the performance as you scroll.

To use the code in the linked to archive: 'unRar it, and copy-paste the code in Form1.cs, and LabelEx.cs into:

0. create a new WinForms project, set the Main Form, 'Form1 'DoubleBuffered property to 'true. Size the Main Form to taste. Replace its code with the code in the archive for 'Form1.cs.

1. add a Component named 'LabelEx to your Project: replace its code in the file from the archive 'LabelEx.cs.

2. On the main Form: put a TableLayoutPanel named 'testTbl: size it and set its various properties appropriately. Put a Button on the Form named 'btnCreateLayoutPanel, and set its 'Click EventHandler to use the code in 'Form1.cs.

modified 3-Dec-14 19:10pm.

PIEBALDconsult3-Dec-14 9:25

PIEBALDconsult

3-Dec-14 9:25

Grids are generally a Very Bad Idea as a user interface. They can be OK in some limited instances with small amounts of data that aren't being changed often -- and with knowledgable users.
One application I tried to use a Grid for I found it completely unmanageable -- so I used a TreeView instead and suddenly everything was suddenly simple.

In either case, I prefer having the primary form display only the highest level data for each entry, then allow the user to select an entry and open a separate editing form with the details of that one item. Don't try to show everything in one place, and don't try to allow editing of everything with one giant Grid.

If you had to use the system eight hours a day with calls and guests coming in constantly, which would you prefer?
How about go to some local hotels and see what they use, what it looks like, what the users like and dislike?

KissGnv3-Dec-14 20:23

3-Dec-14 20:23

There are 3 examples of programs, that are used in hotels.
Example 1 (A small local hotel that I visited is using this program.)
Example 2
Example 3

This model is good, beecause you see all rooms and all reservations at the same time on the screen.

BillWoodruff4-Dec-14 4:33

4-Dec-14 4:33

PIEBALDconsult wrote:
Grids are generally a Very Bad Idea as a user interface. They can be OK in some limited instances with small amounts of data that aren't being changed often -- and with knowledgable users.

I know you are a very intelligent senior developer with strong theoretical interests, and deep expertise with data and databases, but I can't understand why you make this very broad assertion, given the almost universal prevalence of grids of one form of another (I include things like Spreadsheets, Gantt Tools, along with Data-Gridviews in the category of "grids") in every type of industry where scheduling and reservations must be modeled/implemented.

If you make that assertion, I'd appreciate ... and I'm sure other people would too ... a little more detail other than the fact you had a bad experience with using a grid. Surely, in the vast variety of grid-like software components, there must be some implementations you think are well-done ?

By the way, I share (what I believe is) your view that the MS DataGridView sucks; and, I happen to be a real enthusiast for using a TreeView (or multiple TreeViews) as a preferred UI element(s). I use a third-party commercial TreeView that just "walks the dog" ... having "switched" after years of frustration trying to bend the MS TreeView to my will.

I favor a "one data: multiple appropriate views" model; in the case of a Hotel System, I'd like the employee (who may have little formal knowledge of computer software, but adequate practical skill) to be able to quickly switch views depending on the task at hand: from checking on room availability by date ... to entering a booking ... to calculating a net cost ... to creating a summary report of day's activities, etc.

"How about go to some local hotels and see what they use, what it looks like, what the users like and dislike?" Now that's what I call "good advice:" learn from the end-user.

And, examining, closely, the most popular hotel-management systems available today, is the second piece of research I'd recommend [^].

syed shanu3-Dec-14 19:10

syed shanu

3-Dec-14 19:10

Hi,
Check my article at code project.
This is similar to your requirement.
Project Scheduling Using ASP.Net GridView[^]

The above sample is for ASP.NET GridView.
This same logic you can used to create for DataGridView for Winform.

For DataGridView i have created Helperclass look at this also.If this helps you iam very glad for that.
DataGridView Helper Class[^]

Nested DataGridView in windows forms c#[^]

Create Empty Node (Containing Child Node)

SledgeHammer013-Dec-14 19:30

SledgeHammer01

3-Dec-14 19:30

That is called a gantt chart. I'd just find a freeware / open source gantt chart control online. These are tough to make.

AmbiguousName2-Dec-14 23:35

AmbiguousName

2-Dec-14 23:35

Hello. I want to create a new node which has child node. This is not just an element. I am doing it liek this but get System.ArgumentException

XmlDocument doc = new XmlDocument();
string sNodeString = "<School>" +
                     "<Name></Name>" +
                     "<Address></Address>" +
                     "<Phone></Phone>" +
                     "<Courses>" +
                     "<Course></Course>" +
                     "<Course></Course>" +
                     "<Course></Course>" +
                     "</Courses>" +
                     "</School>";
XmlNode node = doc.CreateNode(sNode, "NewNode", "");
return node;

How could I do something like this? Thanks for anything.

This world is going to explode due to international politics, SOON.

Re: Create Empty Node (Containing Child Node)

Richard MacCutchan3-Dec-14 0:27

Populate specifc Registry keys in Combobox

3-Dec-14 0:27

What type is sNode, and do your parameters match one of these[^]?

Jassim Rahma2-Dec-14 18:43

Jassim Rahma

2-Dec-14 18:43

Hi,

I have my registry key HKEY_LOCAL_MACHINE\Software\Jassim

Under Jassim key, I have list of keys, e.g. system1, system2, options, etc

System1 and System2 wil have SystemGUID value where options key will not have.

I want to loop through all keys under Jassim key and found every key which has a SystemGUID key in it to list it in a Combobox?

How can I do this please?

Thanks,
Jassim

Technology News @ www.JassimRahma.com

BillWoodruff2-Dec-14 18:48

2-Dec-14 18:48

With one minute of searching within CodeProject (or using Google) you can find C# code for enumerating the contents of a Registry Key. So, why aren't you doing that ?

If you created the Key and sub-Keys using C#, isn't it pretty obvious how to use the same Classes to read them, and parse them as required ?

OriginalGriff2-Dec-14 21:38

OriginalGriff

2-Dec-14 21:38

Please, don't use the registry - particularly not for new projects!
Access to the registry is now restricted, and is likely to become more restricted in future - because it was abused so much in the early days.

There are much better ways and places to store data now: have a look at this and it might help.
Where should I store my data?[^]

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Richard MacCutchan2-Dec-14 21:47

2-Dec-14 21:47

Save your breath; he's been told this innumerable times, and even had a demonstration of why it won't work.

Richard MacCutchan2-Dec-14 21:49