Comments by ProEnggSoft

ProEnggSoft 18-Apr-12 22:51pm View

5+

ProEnggSoft 18-Apr-12 22:51pm View

Good answer. 5!

ProEnggSoft 17-Apr-12 22:54pm View

Good point. 5!

ProEnggSoft 17-Apr-12 22:51pm View

5+

ProEnggSoft 17-Apr-12 22:51pm View

Good answer. +5

ProEnggSoft 16-Apr-12 6:48am View

If the solution works, I think you can vote.

ProEnggSoft 16-Apr-12 6:48am View

Good answer. 5!

ProEnggSoft 16-Apr-12 6:46am View

Good answer. 5!

ProEnggSoft 14-Apr-12 12:44pm View

Good link. +5

ProEnggSoft 14-Apr-12 12:43pm View

Nice explanation. 5!

ProEnggSoft 13-Apr-12 13:29pm View

Nice answer. 5!

ProEnggSoft 11-Apr-12 12:44pm View

Good advice. 5ed

ProEnggSoft 11-Apr-12 12:42pm View

Good link. 5ed

ProEnggSoft 11-Apr-12 12:41pm View

Nicely explained. +5

ProEnggSoft 10-Apr-12 19:51pm View

It means that there are no rows returned by the NewOrder3.GetDataByOrderBasket3(GridView3.SelectedValue.ToString()) method. Check the reason for non return of rows from the above method. Since, NewOrder3 is declared as Dim NewOrder3 As New DataSet1TableAdapters.basket3TableAdapter. Check whether the connection properties are given correctly, whether connection is opened etc. Once, order3.Rows.Count > 0, that means some rows are turned by NewOrder3.GetDataByOrderBasket3, then the values from rows can be displayed in the labels. Please check the above details in the Visual Studio, as it is not possible to see all those details here. Hope this will help you. Thank you.

ProEnggSoft 10-Apr-12 11:24am View

Good answer. 5!

ProEnggSoft 8-Apr-12 12:57pm View

Good link. +5

ProEnggSoft 8-Apr-12 12:54pm View

Good links. +5

ProEnggSoft 8-Apr-12 12:53pm View

Well explained. +5

ProEnggSoft 8-Apr-12 12:53pm View

Several useful links. +5

ProEnggSoft 5-Apr-12 9:56am View

Thank you

ProEnggSoft 5-Apr-12 9:45am View

Good links. +5

ProEnggSoft 5-Apr-12 9:43am View

Good answer. +5

ProEnggSoft 5-Apr-12 9:41am View

Good advice. +5

ProEnggSoft 5-Apr-12 9:31am View

Edit: pre tag for C# code added - PES

ProEnggSoft 5-Apr-12 8:48am View

In Visual Studio, when code execution is stopped at the break point, if the cursor is hovered over the order3, a tooltip with a magnifier is displayed. Click on the magnifier as shown here http://www.simple-talk.com/dotnet/visual-studio/debugger-visualizers/

ProEnggSoft 5-Apr-12 7:28am View

Now it's good answer. +5

ProEnggSoft 5-Apr-12 7:09am View

Here array.ToString() gives System.Char[]. The constructor of string class can be used to obtain string from array of characters. Please see my solution (4).

ProEnggSoft 5-Apr-12 6:19am View

Edit: pre tag for VB.NET code added - PES

ProEnggSoft 5-Apr-12 0:15am View

Nice explanation of cause of errors. +5.

ProEnggSoft 5-Apr-12 0:04am View

Good link. +5

ProEnggSoft 3-Apr-12 13:39pm View

Good answer. +5

ProEnggSoft 3-Apr-12 13:38pm View

Good link. +5

ProEnggSoft 2-Apr-12 8:33am View

Good links. +5

ProEnggSoft 2-Apr-12 8:29am View

You're welcome.

ProEnggSoft 2-Apr-12 3:49am View

Yes it is. Thank you.

ProEnggSoft 1-Apr-12 21:35pm View

Thank you very much. It seems your vote is not updated in the server.

ProEnggSoft 1-Apr-12 13:02pm View

+5. Appropriate link.

ProEnggSoft 1-Apr-12 11:39am View

Thank you.

ProEnggSoft 1-Apr-12 9:00am View

Comprehensive answer. +5

ProEnggSoft 30-Mar-12 19:45pm View

Nice explanation. +5

ProEnggSoft 30-Mar-12 19:43pm View

+5

ProEnggSoft 30-Mar-12 13:25pm View

No problem.

ProEnggSoft 30-Mar-12 13:21pm View

Thank you.

ProEnggSoft 30-Mar-12 12:47pm View

Good. +5

ProEnggSoft 30-Mar-12 10:59am View

You are correct. Please see my comment below, where I have mentioned other possible cases.

ProEnggSoft 30-Mar-12 10:54am View

What Shahin said is correct.
I want to add the following to make it more clear.

As per Framework Design Guidelines

PascalCasing is used for static public and protected fields.
Internal and private fields are not covered by those guide lines. But if used camelCasing can be used.
Public and protected instance fields are not allowed by the member design guidelines.
i.e. We cannot generilize camelCasing for all fields.

Fields are also variables. So to be specific
camelCasing is used for parameters and local variables.

Regarding control, it depends on the access (visibility) level of the control.
In Visual Studio, in form designer (C#), when a control is dropped on a form, the control is given private access and the naming is camelCasing.
When the control is given public or protected access, then PascalCasing can be used.

ProEnggSoft 30-Mar-12 9:09am View

Thanks.

ProEnggSoft 30-Mar-12 8:57am View

Deleted

hi,
My string may be contains the string expression like: "abc==abc" etc..so this will not be helpfull me..

ProEnggSoft 30-Mar-12 8:56am View

Deleted

Please post your comments using "Have a Question or Comment?" the link at the bottom of a solution. Do not post your comments as a solution.

ProEnggSoft 30-Mar-12 8:53am View

Please see my solution (1). I have modified it with a link to another article, which can handle string expressions also

ProEnggSoft 30-Mar-12 7:12am View

From the code it seems that you are using the ComboBox control. But for displaying the ComboBox within the DataGridView, DataGridViewComboBoxColumn control is to be used as given in the example at the link shown in Solution 1. Further after setting the DisplayMember and ValueMember properties of DataGridViewComboBoxColumn the values will be automatically set. The values need not be set manually.

ProEnggSoft 30-Mar-12 7:08am View

+5

ProEnggSoft 30-Mar-12 6:06am View

5!

ProEnggSoft 30-Mar-12 6:04am View

Good link. 5!

ProEnggSoft 30-Mar-12 6:03am View

+5

ProEnggSoft 30-Mar-12 5:51am View

Thank you.

ProEnggSoft 30-Mar-12 2:02am View

Good pointer. +5

ProEnggSoft 30-Mar-12 2:00am View

To the point. +5

ProEnggSoft 30-Mar-12 1:59am View

Nice explanation. +5

ProEnggSoft 30-Mar-12 1:57am View

Thank you.

ProEnggSoft 30-Mar-12 0:34am View

Edit: Removed tags not necessary - PES

ProEnggSoft 30-Mar-12 0:14am View

If you want to filter the DataTable, use the DefaulView property of DataTable to set the DataSource and then set the RowFilter property of the DataView.
If your problem is solved, you may consider to vote and accept the solution. Thank you.

ProEnggSoft 29-Mar-12 23:46pm View

Good advice. +5

ProEnggSoft 29-Mar-12 12:59pm View

To the point. +5

ProEnggSoft 29-Mar-12 5:20am View

Good advice. 5!

ProEnggSoft 29-Mar-12 4:11am View

Good question. +5

ProEnggSoft 29-Mar-12 4:10am View

Please see my solution (3). It may be helpful.

ProEnggSoft 29-Mar-12 1:31am View

5!

ProEnggSoft 29-Mar-12 1:31am View

+5

ProEnggSoft 29-Mar-12 1:30am View

5!

ProEnggSoft 29-Mar-12 1:30am View

Nice. +5

ProEnggSoft 29-Mar-12 1:29am View

+5

ProEnggSoft 29-Mar-12 1:29am View

+5

ProEnggSoft 29-Mar-12 1:28am View

Nice answer. +5

ProEnggSoft 29-Mar-12 1:27am View

+5

ProEnggSoft 28-Mar-12 9:20am View

To the point. 5!

ProEnggSoft 28-Mar-12 9:14am View

Edit: pre tag for SQL added. Indentation adjusted for readability - PES.

ProEnggSoft 28-Mar-12 9:12am View

Edit: Indentation adjusted for readability - PES.

ProEnggSoft 28-Mar-12 7:50am View

Good advice. 5!

ProEnggSoft 28-Mar-12 7:22am View

An answer to your earlier question was given here.
http://www.codeproject.com/Answers/355930/hello-how-space-between-words-or-terms-in-paragrap#answer1
It may be helpful to you.

ProEnggSoft 28-Mar-12 6:03am View

If your question is answered, you may consider to accept the solution.

ProEnggSoft 28-Mar-12 5:49am View

Good link. +5

ProEnggSoft 28-Mar-12 5:49am View

Good link. +5

ProEnggSoft 28-Mar-12 5:41am View

To the point. +5

ProEnggSoft 28-Mar-12 3:40am View

Please see my solution (2). I think this may also be helpful to you.

ProEnggSoft 28-Mar-12 3:14am View

Please see my solution (2). It may also be helpful to you - PES.

ProEnggSoft 28-Mar-12 3:07am View

Good links. +5

ProEnggSoft 28-Mar-12 3:02am View

Very good answer and advice. +5

ProEnggSoft 28-Mar-12 2:26am View

Can you please elaborate what you want. Which type of tag is to be ignored?

ProEnggSoft 27-Mar-12 12:12pm View

Thank you.

ProEnggSoft 27-Mar-12 12:11pm View

Thank you very much.

ProEnggSoft 27-Mar-12 12:11pm View

Thank you.

ProEnggSoft 27-Mar-12 12:10pm View

Happy to know that it helped you.

ProEnggSoft 27-Mar-12 12:09pm View

Thank you.

ProEnggSoft 27-Mar-12 12:08pm View

Thanks a lot.

ProEnggSoft 27-Mar-12 9:15am View

Good links. +5

ProEnggSoft 27-Mar-12 9:14am View

+5

ProEnggSoft 27-Mar-12 9:14am View

+5

ProEnggSoft 27-Mar-12 9:14am View

+5

ProEnggSoft 27-Mar-12 9:13am View

Good advice. +5

ProEnggSoft 27-Mar-12 7:51am View

Please see my solution (2)to check whether it meets your requirement.

ProEnggSoft 27-Mar-12 7:42am View

+5

ProEnggSoft 27-Mar-12 7:25am View

Deleted

Thanks for consideration.

ProEnggSoft 27-Mar-12 7:24am View

Extremely sorry. I noticed later and modified my comment.

ProEnggSoft 27-Mar-12 7:22am View

+5 for a thought provoking question.

ProEnggSoft 27-Mar-12 7:20am View

Thank you.

ProEnggSoft 27-Mar-12 7:16am View

You have to put @ in front of pattern, as @"(?......

ProEnggSoft 27-Mar-12 7:12am View

Can you provide some test string to test for.

ProEnggSoft 27-Mar-12 7:06am View

Thank you.

ProEnggSoft 27-Mar-12 7:06am View

I have checked it. It is working. Please give your test string. So that I will also test. Thank you.

ProEnggSoft 27-Mar-12 6:52am View

Please see my solution (2), whether it works for you.

ProEnggSoft 27-Mar-12 6:51am View

It can be implemented. Please see my solution (2)

ProEnggSoft 27-Mar-12 5:43am View

Thank you very much.

ProEnggSoft 27-Mar-12 3:36am View

Happy to know that the solution worked for you :)

ProEnggSoft 27-Mar-12 3:24am View

Set
bRDATABindingSource1.DataSource = dt;
then it will work

ProEnggSoft 26-Mar-12 22:38pm View

Thank you.

ProEnggSoft 26-Mar-12 22:37pm View

Thank you very much.

ProEnggSoft 26-Mar-12 21:19pm View

Thank you very much.

ProEnggSoft 26-Mar-12 21:02pm View

Good pointers. +5

ProEnggSoft 26-Mar-12 21:00pm View

Nice info. +5

ProEnggSoft 26-Mar-12 21:00pm View

Good pointer. +5

ProEnggSoft 26-Mar-12 20:46pm View

Very good advice. +5

ProEnggSoft 26-Mar-12 20:39pm View

Nice additional info. +5

ProEnggSoft 26-Mar-12 20:37pm View

Succinct and to the point. +5

ProEnggSoft 26-Mar-12 20:36pm View

Nice explanation. +5

ProEnggSoft 26-Mar-12 12:03pm View

Thank you Clifford Nelson for up voting.

ProEnggSoft 26-Mar-12 11:58am View

Thank you for voting and accepting the answers.

ProEnggSoft 26-Mar-12 11:13am View

Please see my solution 3

ProEnggSoft 26-Mar-12 9:39am View

Nice answer. 5!

ProEnggSoft 26-Mar-12 7:15am View

If the answer is helpful to you then you may consider to vote and accept the solution. Thank you

ProEnggSoft 26-Mar-12 5:49am View

Good link. +5

ProEnggSoft 26-Mar-12 5:32am View

Thank you. Happy coding.

ProEnggSoft 26-Mar-12 4:13am View

+5

ProEnggSoft 26-Mar-12 4:06am View

The regular expression \s*,\s* matches a comma surrounded by none or more spaces say 1,2 1 ,2 1 , 2 except the numbers 1 and 2, and then it is replaced by
' OR cmpsno='
For \n use \s*\n\s* instead \s*,\s* in the above statement.
If your problem is solved you may vote and accept the solution.
Thank you.

ProEnggSoft 26-Mar-12 3:13am View

Please check the following
1. Whether the cmpsno given in the textbox say 1, 5, 10 are actually there in the database.
2. Whether there is any space given before or after the cmpsno in the database because cmpsno='1' will not match cmpsno of ' 1' in the database.
3. Using debugger in Visual Studio, put a break point on
SqlCeDataAdapter adap = new SqlCeDataAdapter(com); and check whether command text is properly formed say SELECT .... WHERE cmpsno='1' OR cmpsno = '5' OR cmpsno = '10' for the example given above
4. You have said that first id is displayed but second and other are not displayed. Check by giving second or other id as the first id.

ProEnggSoft 26-Mar-12 0:59am View

Another option is to use a Formula, with a global variable for SlNo. Each time a record is printed, the variable is incremented. The link http://stackoverflow.com/questions/7673897/global-variable-in-crystal-reports may be helpful.

ProEnggSoft 26-Mar-12 0:59am View

Deleted

Another option is to use a Formula, with a global variable for SlNo. Each time a record is printed, the variable is incremented. The link http://stackoverflow.com/questions/7673897/global-variable-in-crystal-reports may be helpful.

ProEnggSoft 26-Mar-12 0:20am View

use @ before "\s*,\s*" and NVARCHAR is the data type then the first statement enclosing within ' ' is to be used.
If the cmpsno is not exact match of input ID then we have to use replacement with '%IDvalue%'

ProEnggSoft 26-Mar-12 0:09am View

Thank you parametrized query suggestion.
As an alternative if all the data is read in to the DataTable, binding the data to BindingSource, then binding it to the data control and for displaying particular records, the filter property of BindingSource is used. Will it be OK.

ProEnggSoft 25-Mar-12 23:59pm View

The problem may be either the data type of cmpsno is numeric type or there may be spaces around , . Please see I have updated my solution.

ProEnggSoft 25-Mar-12 21:15pm View

I think this discussion is going too far. Let us close. Thank you very much for the debate.

ProEnggSoft 25-Mar-12 21:01pm View

Thank you for your reply.
I have clearly stated in my answer when the null will be returned. So the designer already kept informed that there is a possibility of null. Further the second statement in my answer is only for completeness and does not require the user to only return 0. He can choose any other option, since it is already clearly stated that null will be returned.
If we go by your version, then the user should not look up in an empty list as it is a design problem, then Find method is more appropriate, but you have given FirstOrDefault method.

ProEnggSoft 25-Mar-12 20:53pm View

I think the better alternative will be to create a temporary DataTable as per your requirement, separating the comma separated values into each row and then use this DataTable for generation of report in Crystal Report, as I am doubtful and not sure whether we can achieve Sl.No. for each of the comma separated values in Separate row in Crystal Report directly. If my answer is useful then you may accept and vote the solution, otherwise please post your queries.
Thank you

ProEnggSoft 25-Mar-12 20:41pm View

Please see my comment to your response above. Thank you.

ProEnggSoft 25-Mar-12 20:39pm View

What you have given is another alternative. In programming several possibilities are there. If we write a statement in a short way does not mean that the other way is wrong and justify for a down vote. Regarding, the product not found, the designer can raise an exception. It is also a preferred approach, when we surely know that what is the output of a statement, we can deal with it without throwing an exception, as throwing an exception is an overhead in program. I have read that the TryParse method of Int, Double etc. was introduced to deal with failure of conversion without using try catch block. Thank you

ProEnggSoft 25-Mar-12 20:26pm View

I have seen the modification done in my answer. But, please indicate what you have modified, if you have edited others answer.
Further, I have up voted your answer. Whereas it seems you have down voted my answers. Thank you.

ProEnggSoft 25-Mar-12 13:10pm View

You are correct. Earlier I used VB2005 express edition. Some how I was under wrong impression. May be setup project was not possible I think.
Thank you for correcting.
I incorporated the correction in the answer.

ProEnggSoft 25-Mar-12 12:45pm View

Edit: pre tag for C# code added - PES

ProEnggSoft 25-Mar-12 12:38pm View

Good links. +5

ProEnggSoft 25-Mar-12 12:35pm View

+5

ProEnggSoft 25-Mar-12 12:00pm View

Thank you.

ProEnggSoft 25-Mar-12 8:48am View

This also worked for me in a similar situation. +5

ProEnggSoft 25-Mar-12 8:00am View

Good answer. +5

ProEnggSoft 25-Mar-12 7:38am View

Thank you.

ProEnggSoft 25-Mar-12 7:23am View

Thank you.

ProEnggSoft 25-Mar-12 7:19am View

+5

ProEnggSoft 25-Mar-12 6:56am View

Very nice explanation. +5

ProEnggSoft 25-Mar-12 6:25am View

Thank you

ProEnggSoft 25-Mar-12 6:25am View

Deleted

Thank you

ProEnggSoft 25-Mar-12 5:37am View

Thank you.

ProEnggSoft 25-Mar-12 1:12am View

+5

ProEnggSoft 25-Mar-12 0:56am View

It's good. +5 for the idea.
I have some comments please my see solution (5)

ProEnggSoft 24-Mar-12 23:31pm View

Edit: pre tag for C# code added - PEs

ProEnggSoft 24-Mar-12 23:20pm View

You can use my solution (2) given below

ProEnggSoft 24-Mar-12 20:17pm View

Sorry I could not under stand from your question. Now I understood what is required exactly. Please see my Solution (4).

ProEnggSoft 24-Mar-12 12:16pm View

Nice answer. +5

ProEnggSoft 24-Mar-12 2:12am View

Thank you

ProEnggSoft 24-Mar-12 0:43am View

Very good answer and advice. +5

ProEnggSoft 23-Mar-12 23:37pm View

Please post your queries as comments under your question or modify the question using improve question wizard, so that one can easily see further additions to your question.
Regarding picking a date from the DateTimePicker, you have already stated in your question that the user picks a date from DateTimePicker. I could not get want you want from the above info.

ProEnggSoft 23-Mar-12 21:50pm View

Thank you.

ProEnggSoft 23-Mar-12 21:38pm View

Thank you

ProEnggSoft 23-Mar-12 20:57pm View

To the point. +5

ProEnggSoft 23-Mar-12 13:10pm View

Thank you.

ProEnggSoft 23-Mar-12 12:48pm View

Yes, I noticed it. I also stated same thing. Thank you.

ProEnggSoft 23-Mar-12 12:39pm View

+5. You are absolutely correct. I have modified my answer based on your solution.

ProEnggSoft 23-Mar-12 12:29pm View

Edit: Indentation adjusted - PEs

ProEnggSoft 23-Mar-12 12:26pm View

My 5 for instant reply to the point.

ProEnggSoft 23-Mar-12 12:26pm View

Thank you

ProEnggSoft 23-Mar-12 7:57am View

Thank you

ProEnggSoft 23-Mar-12 5:36am View

Edit: pre tag for C# code added and question tagged sith ASP.NET and C# - PES

ProEnggSoft 23-Mar-12 2:45am View

That's it. 5!

ProEnggSoft 23-Mar-12 2:35am View

Good explanation and link to article. 5!

ProEnggSoft 23-Mar-12 1:26am View

Thank you. I understood. You are correct.

ProEnggSoft 23-Mar-12 1:07am View

Good info. 5!

ProEnggSoft 23-Mar-12 0:58am View

Do you mean from Excel application? I could not get the point. Can you please elaborate. I was thinking that the OP wants to generate combined excel file from within C# program. Thank you

ProEnggSoft 22-Mar-12 22:38pm View

Thank you for suggestion.

ProEnggSoft 22-Mar-12 21:15pm View

www.codeplex.com is an excellent site. 5!

ProEnggSoft 22-Mar-12 21:14pm View

Good link to comprehensive list of free controls. 5!

ProEnggSoft 22-Mar-12 20:59pm View

Good links. Particularly link 1 of www.asp.net is excellent. +5

ProEnggSoft 22-Mar-12 20:55pm View

Good links. 5!

ProEnggSoft 22-Mar-12 20:15pm View

Thank you.

ProEnggSoft 22-Mar-12 20:14pm View

Thank you very much.

ProEnggSoft 22-Mar-12 20:12pm View

Thank you very much.

ProEnggSoft 22-Mar-12 15:01pm View

Edit: Spelling corrected - PES

ProEnggSoft 22-Mar-12 14:39pm View

Good answer. 5!

ProEnggSoft 22-Mar-12 14:20pm View

Good explanation and links. 5!

ProEnggSoft 22-Mar-12 11:50am View

Deleted

Thank you very much.

ProEnggSoft 22-Mar-12 11:46am View

Edit: pre tag for C# code added - PES

ProEnggSoft 22-Mar-12 11:43am View

Good link to an excellent article. 5!

Comments by ProEnggSoft (Top 200 by date)