C# Discussion Boards - CodeProject

Apart from resetting searchValue variable to null, I think you also should break out if for loop as soon as you found the matching value in array.

Any answers are appreciated.

Thanks....

What Operating System?

With Windows (7) I have been using NET USE to create a mapped drive, COPYing to it, and then using NET USE to /delete the mapped drive.

f:\>net use ?
The syntax of this command is:

NET USE
[devicename | *] [\\computername\sharename[\volume] [password | *]]
        [/USER:[domainname\]username]
        [/USER:[dotted domain name\]username]
        [/USER:[username@dotted domain name]
        [/SMARTCARD]
        [/SAVECRED]
        [[/DELETE] | [/PERSISTENT:{YES | NO}]]

Hi,

I would like to ask why I am getting the following error on the below code please?

The error is: invalid length for a base-64 char array or string

and this is the code:

C#

string server = cipher_utility.Decrypt<RijndaelManaged>(xmlClass.read_registry("Softnames", "ServerHost"), "{1234567-1234-1234-1234-123456789012}", "{12345678-1234-1234-1234-123456789012}");

Thanks,
Jassim

Technology News @ www.JassimRahma.com

Probably because the encrypted data has not been stored (or encrypted) correctly. And you would find debugging your code much easier if you did not write compound statements. It is just as efficient, and so much easier to debug, and to read, to write it as:

C#

string encryptedData = xmlClass.read_registry("Softnames", "ServerHost");
string server = cipher_utility.Decrypt<RijndaelManaged>(encryptedData, "{1234567-1234-1234-1234-123456789012}", "{12345678-1234-1234-1234-123456789012}");

so how to go with the fix?

Technology News @ www.JassimRahma.com

What fix? Your encrypted data is either incomplete or has been corrupted. You need to diagnose the issue to find out how that happened.

I can't explain it properly in the subject section, it's not as simple as that.

Here is the code snippet in question.

UserPass = reader["Password"].ToString();

So UserPass is my string variable and reader is an SqlReader object.

Here is it being instantiated:

SqlDataReader reader = myCommand.ExecuteReader();

(myCommand is an SqlCommand obj)

reader["Password"]

Password is a column name in my Sql DB. Basically I've just told the reader to go look within that column and used a query to specify where abouts.

I want to set the reader["Password"] equal to an empty string to compare against user input. Now there aren't any errors when I do this but it does throw an exception:

An exception of type 'System.InvalidOperationException' occurred in System.Data.dll but was not handled in user code

It doesn't give much more detail other than that and I'm not entirely sure what's wrong.

Nothing you provided looks obviously wrong. Which statement throws the Exception? We may need to see the query.
And provide the code in proper order.

modified 3-Dec-14 14:47pm.

did you debug to identify on which line you had the issue?

Mark the answer as accepted if that worked for you Smile | :)

.

And for down-voters please specify the reason to improve the solution Smile | :)

.

HI...
I am beginner in WPF and I have a problem with saving data from DataGrid to text file (text file is usedby other program). I check on google, bing and find nothing. Please help.

I'd suggest you post your code and show where you are stuck.

There are only 10 types of people in the world, those who understand binary and those who don't.

Member 10024517 wrote:
I have a problem

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

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).

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?

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 | :)

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

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."

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.

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.

«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."

modified 3-Dec-14 19:10pm.

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?

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.

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 [^].

«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."

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#[^]

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