Click here to Skip to main content
14,239,168 members

Comments by ProEnggSoft (Top 200 by date)

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!