Comments by JayantaChatterjee (Top 200 by date)

you are most welcome....

please set the TimeOut property of your command object then you will get the proper error.
myCommand.CommandTimeout = 20;

more info:- https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.commandtimeout(v=vs.110).aspx

are all table's structure same?
because you are collecting data from different tables and then fill it in a single DataSet. if all tables structure are not same then it will not add to the dataSet object.
please debug and print the total Row count of DataSet.

Please post your code and also your database structure, so we can understand where this error come from.

right now I don't have mongoDB setup,so I can't test it. but this is the way you can join multiple collections of mongoDB.
did you get any error?

Sorry,
please change Queryable() to AsQueryable()..
see my updated solution.

you follow this links:-
https://docs.oracle.com/cd/E19226-01/820-7627/giqaa/

https://docs.microsoft.com/en-us/aspnet/web-api/overview/older-versions/build-restful-apis-with-aspnet-web-api

if you think this solution works for you, please click on Accept Solution button

please see, I update my solution.

same, no result..
is there anything I missed?

I also tried that, but no result.. :-(

You are Welcome..

check your TextBox1 & textBox2 value, the value should be number.
or you can try TryParse method as @Peter said..

What are the errors?

Please click on "Accept Solution" Green Button..
this will help others to find there answer...

Can you post your full code, so we can find out what are the logic and the problems..

check out this link:-
https://support.microsoft.com/en-in/kb/306666

you can use "FolderBrowserDialog" control to choose the folder from the system..
more info click this link:-
https://msdn.microsoft.com/en-us/library/system.windows.forms.folderbrowserdialog(v=vs.110).aspx

Your question is not clear to me.
please add your code in the question by clicking on the "Improve Question" link..

Reason for my vote of 5 \n I'm searching this example and now I find it..
thanks a lotttttttt..

I'm glad to hear that..
@Atul you are welcome..

As per your code, if Unique_No is found in the Table then it will Increment the Sales_count value with one..
if your query doesn't increment the Sales_count value in the table, that means the Unique_No(which you provided through the txtInput textbox) doesn't exist in the table.
Debug your program and see the txtinput.Text value, and find out is it exist in the table or not...

that's means your method doesn't exit, after invalid Unique_no entry on Form1??

Its works for me..
did you get any error?
what is "not working"(please explain)??

Its works for me....
did you follow the steps and change the "product name", copyright etc??
after changed press-F6 to build solution...

Please see I updated my Solution..

to get the "Setup Project" properties:-
select setup project and press F4, then the properties windows will appeared..
in the properties windows you can find all the properties like Product name,version etc..

What happen after changing the properties of "Setup Project"?

I think you missing some external file links...

provide designer code, and Error details...

please post your code. link is not working....

you can use more conditions with logical operator like:
&& (and) , || (or)..
not like (,)comma separator, which you used in "initializer" and "iterator"(increments or Decrements) part

You can not add more than one condition in the For Loop..
You need to specify inner loop for that, with the different logic...

check your question tags....
ASP with Console... :-)
ASP is Server Pages, which doesn't have the Console Application...
What are the errors??
where are you stuck ?

Yeah!! that's right..
btw, enjoy your hard work.. :-)

Simple and efficient approach..
My 5ed...

You can get there IDs like this:
var selectedStatus=document.getElementById("<%=ddlStatus.ClientID%>");

You try Google Baba-Ji, who can give you some Doubt clearing results..

My problem is solved after installing the "MS Access 2007 DB Engine"..
some key points are:-
Restart your computer. if you already did that,
then you can try installing the "MS office 32-bit version"...
Else
Sorry I'm out of Points. :-)

My 5ed..
Best Answer of the Month.. :-D

Home work not done here....
sorry... :-)

Not the "Access Database Engine 2010 Redistributable", only install "MS Access 2007 Database Engine", from provided link..
I had this problem also...

You need to post that in a separate question, because it will help others to find there problems Solution...

Codeproject doesn't support the Screenshot in question..
you have to add the code block, which you have tried....

First of all, on the web credentials are used "Post" method other then "Get" method.
Credentials are suppose to be secret.
no web site are accept the Credentials through the QueryString..
Can you be more clear?
like, which web site do you want to login?
is that web site created by you or others?

you're welcome...
Please accept the the Solution..

what have you tried ??
did you create the function with the above code, and then drag and drop the function into your crystal report from the "Field Explorer"?

right now I'm not having the Crystal report..
the code will be like this:-
if IsNull({reportFieldName}) then
0
else
{reportFieldName}

after this code added to function, you have to add this function to the report, then add a summery fields and select this function Name with sum function in the report..

sorry, code, I didn't see the C++ tag...
this is not in C++ code,its in C#.net...
you can get the help click this link:-

https://www.google.co.in/?gfe_rd=cr&ei=ctZwV-zoGtDk8Aey85MY&gws_rd=ssl#q=dockpanel+suite+documentation

"st.ToString("yyyy-MM-dd");" would be "dt.ToString("yyyy-MM-dd");"... :-)
otherwise its simple and clear..

did you get any error on converting the date?
if you get errors then, what are the errors?

Yes, you are right..
I think OP show us the static value to render the chart, but he may be dealing with the dynamic values.. that's why I'm post this solution..

thank You....

Exactly what I am trying to say..
thanks for Explanation Sir....

I think its the wrong process to save the RichTextBox content on TextChanged event, because it will fire every time when you change(typeing or deleteing) the text in the RichTextBox..
You can try to create a timer or Button to save the Content..
What are IOException error Message?

You can use JavaScript to replace browser History of your web page..
Using ClientScriptManager...
https://msdn.microsoft.com/en-us/library/system.web.ui.clientscriptmanager(v=vs.110).aspx

Okay. thank you..

if I use invDate in GROUP BY then it group records with single day wise not for month wise..

You got me right, but I already tried this. This doesn't work because invDate is not in Group by clause, so its give me an error...

thanks for the help..

Can you provide more info, code block which you have tried....
It would be helpful to know what is your problem and what would the solutions..

Reason for my vote of 5 \n Thanks for CSS UI Frameworks, they are amazing....

Thank You Sir...

Thank for Suggestion..
PrintDocument support the Unicode Characters. now I'm finding the IC as a subscript character from the unicode character list....
thanks a lotttt...

HTML Renderer is good. but Sir, I already developed my "Final year" project with PrintDocument control. I'm stuck in this part. if I change the printDocument, then I need to change approx. three PrintDocument controls code.
So, is there any way to do this with PrintDocument?

Thanks for the suggestion..

Reason for my vote of 5 \n My vote of 5ed.
thanks for disposed the IDisposable and Disposed nightmare...
Really it's concept clearing article...

Reason for my vote of 5 \n My vote 5ed.
I like your all approaches about "Number to Words"..
thank you for sharing this article..

Reason for my vote of 5 \n My Vote of 5ed.
Small and Effective ..
Thanks..

Reason for my vote of 5 \n My vote of 5
thanks for sharing this sample..
Its pretty helpful..

thanks ....

thank you sir..

Sorry I don't understand..
actually in the cast field have values like:
List <string > cast=new List < string > ();
cast.Add( Marc Silverstein);
cast.Add(Abby Kohn);
cast.Add(Jason Katims);

this is for one movie, and there is more than one movie which have the multiple cast in it. I want to get all the cast name from all the movies name..

How to do that?

thanks for suggestion..
I know this process(which I did) is not good for performance..
here I am making this application to doing some test with worker thread, so that's why I'm making this type of concept with Winforms controls..
most importantly I'm not include it with my habit.. :-)

Okay..

Thank You all..
I solve my problem by sending the thread to sleep for 50 millisecond in DoWork event, and it worked like animation... :-)
Thanks a Lottt @F-ES....

Yes you are right hanging the UI on Complete Event of BackgroundWorker.
I change my code:
private void button1_Click(object sender, EventArgs e)
{
flowLayoutPanel1.SuspendLayout();
backgroundWorker1.RunWorkerAsync();
}

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
List<Label> lblList = new List<Label>();
for (int i = 1; i <= 1000; i++)
{
Label lbl = new Label();
lbl.Name = "lbl" + i;
lbl.Text = i.ToString();
lbl.BorderStyle = BorderStyle.FixedSingle;
lbl.AutoSize = true;
lbl.BackColor = Color.LightSalmon;
lbl.ForeColor = Color.DarkViolet;
lblList.Add(lbl);
backgroundWorker1.ReportProgress(i,lbl);
}
e.Result = lblList;
}

private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
int percentage = ((e.ProgressPercentage * 100) / 1000);
progressBar1.Value = percentage;
Label lbl =(Label) e.UserState;
flowLayoutPanel1.Controls.Add(lbl);
}

private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
//List<Label> CreatedLbl = (List<Label>)e.Result;
//flowLayoutPanel1.SuspendLayout();
//flowLayoutPanel1.Controls.AddRange(CreatedLbl.ToArray());
flowLayoutPanel1.ResumeLayout();

}

but it also hanging my UI...
so I want to give the option to cancel the process to the user..
how it is possible(in this scenario )?

I don't want to show the creation process to the user, Only I want to give the option to cancel the process. In this scenario the UI is freezed so user can not have that(Cancel) option..

My question is :
how to provide the cancel option to the user??

I know that is big process, but that is in BackgroundWork class DoWork,
it suppose to not freeze the UI?

Reason for my vote of 5 \n My vote of 5ed....

It's works for me....
Finally I get rid of this error..
Thanks a Lotttttttttttttttt....

Reason for my vote of 5 \n My vote of 5'd..
Nice and Clear Tips..
thank You Sir...

Sorry I'm not getting you..
what do you means "other fields result"?
how do you get the "userid" variable value?
and what is the problem?

I update my Solution, please check..

I think you need to check the length of Pin number in textBox1_TextChanged event, if the length is match the length of Pin number length then search and show the address according to that pin number..

Sorry for late reply..
thank you sir, I will keep it in mind..

No, I didn't use DataGridView..
I trying to get all the records from the table for display in "Crystal Report"..

thanks a lotttttt..

I used try catch, but the exception doesn't caught by the catch statement.. :-(
so what is the solution for this "rows count" ??
what you did?

@member11242856 you can try this link:
http://www.codeproject.com/Articles/660478/Csharp-Create-and-Manipulate-Word-Documents-Progra

Reason for my vote of 5 \n This is Awesome.....
Thanks for making this Notification in windows.... :-)

Thank you Sir, I appreciate Your suggestion..

Its help me lots.. :-)

Thank you it's worked..
but I am using Struc instead of class because of performance(the collection can be upto 50 or more items).
is there any other way to do this???

Thank you Sir.

Put your code in time_tick event..

No.
I want to create Settings Variable in VS2010, which describe in this link -: http://www.codeproject.com/Articles/15013/Windows-Forms-User-Settings-in-C

Sir,
is there any other way to do this(I mean, to stored array of data)??

actually I want to create a setting that is Queue data type, but in the list of all namespaces but I couldn't find System.collections namespace in that list..
so How to bring System.Collections Namespace in that list??

I don't understand..

I tried Message.Show("") before the openFileDialog object creation , its okay(showing the message box), but after that OpenFileDialog.ShowDialog line gives same error.. :-(

I ReInstantiate the OpenFileDialog but its same error..:-(
I am not using any dll, Com or DirectX controls, only windows common controls...

I dispose all the objects one after one and at last the connection object.:-(
When I dispose the Adapter object, is that still uses the connection object reference?
I am using only private object in that class..

I debugging my whole project from beginning, but couldn't find any outside code which used the connection object directly or indirectly.<br>
 <br>
Actually I create Data_con class object when it needed and after worked done Dispose the Data_con object with dispose method(Its happened on every block in which the Data_con object created like open and close).<br>
Is there any way to close the connection object??

Now I think I got the Error root.
If I dispose or Close the connection object in the Dispose method then it gives that error, if I comment that two lines then its okay..
So My question is if I only send that class(Data_Con) to garbage Collection without dispose or close the connection object , is the connection still open??

I used only .NET classes(I think .NET is used Managed memory)..
How to find out unmanaged object in my Application??

Sir I crossed checked but there is no error in catch block(which is in Dispose method), and change the formation of the object disposing in that method as you say connection object dispose goes last ..
but its still gives same error.... :-(
Is there any other way to do this(I mean Disposing or memory management) to remove this error??

Thanks for Remind me about SQL Injection, I will Use Parametrized Query..

After making comments on those lines its work properly, that's why I posted that lines of codes.
In Data_Con class dispose method code is :
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
protected virtual void Dispose(bool disposing)
{
try
{
if (disposing)
{
conn.Close();
conn.Dispose();
cmd.Dispose();
adpt.Dispose();
dataSet.Dispose();
}
}
catch { }
}
Is this wrong ?

My vote of 5...

Thank You Sir..
I got the error generator code in my application, which is :
Data_Con Modi = new Data_Con();
if (paraVal != null)
{
Modi.SelectSta("select * from custDetails where custName='" + textBox1.Text + "'", "custDetails");
if (Modi.dataSet.Tables["custDetails"].Rows.Count > 0)
{
textBox2.Text = Modi.dataSet.Tables["custDetails"].Rows[0][2].ToString();
textBox3.Text = Modi.dataSet.Tables["custDetails"].Rows[0][3].ToString();
textBox4.Text = Modi.dataSet.Tables["custDetails"].Rows[0][4].ToString();
textBox5.Text = Modi.dataSet.Tables["custDetails"].Rows[0][0].ToString();
}
}
Modi.Dispose();
This code is in TextBox_leave event..
I create Dispose method in that class(Data_Con). close and dispose all the object in that class..
so now what i need to do??

OpenFileDialog is Build in Class(which .NET provide).
I checked OpenFileDialog in different project it worked fine.
The InitialDirectory property of OpenFileDialog is empty...

this is the first line of button_click event in my project.
I also add break point to that line and debugging my project I found nothing suspicious , but same error occurred. :-(

I have 3 Classes and 8 forms in my Project..
all project running good except this ... :-(

Sorry I don't understand...

Sir, I have a problem.
How to focus both controls(ListView and TextBox)??
I mean when the combobox is Expand the items then if we use the keyboard down arrow key to select the item, at that time textbox text and combobox item is selected like system comboBox (with blue backColor),
I set HideSelection property to False, but after this the selection is visible as a light_gray color not like system color(which is blue background color)..
How do I do that ??

Thank You Sir.... :-)

I'm not able to give quick reply for my Internet connection.
Sorry for that... :-(
Thanks for giving custom Events code, and I already made the expand / Collapse behavior for my userControl...
I'm trying to make that control.

Yes!
That's works...
thanks... :-)

Yes it is Winform project.
I'm familiar with ListView control and also with groups items, but I'm not familiar with custom EventArgs....

Sir, I have lots of time,
I'm pretty excited to do it..
can you post your rough code sketch.

thanks @ BELGIUMsky !!
I tried GroupedComboBox custom control, but I couldn't add group wise items in that control...

My vote of 5++

Thank you Sir...
Thanks a Lottttttttttttttttt...
its perfect .... :-)

Sir,
i want to do:- I have two controls one is CheckedListBox1 and another is CheckBox1.

CheckedListBox1 List Items are :
"A" unchecked
"B" Checked
"C" Checked
"D" Unchecked

if Checkbox is checked then shows only checked items from CheckedListbox1 to CheckedListbox1 . Here the items are :
"B" and "C"
if checkbox is unchecked then shows all items which were in CheckdeListBox1. Here the items are :
"A" unchecked
"B" Checked
"C" Checked
"D" Unchecked

I saw it in VB6 Add component dialog Box, where all the component are in one checkedlistbox, and there was a checkbox(which text is "Selected Items only").if we checked that checkbox then it will shows only checked items in checkedlistbox.

show in same CheckedListBox1.

Sir, Sorry for My English language..

I want to show only checked Items from checkedListBox, means when checkBox is checked then show which items were checked in CheckedListBox, and if checkbox is unchecked then show all items(which checked before and rest of all)...

I need custom function in Crystal Reports to calculate sum of "total amount" with condition, not the sql query...

My vote of 5..

this code gives same error in "Class1" methods..
Please run your code before post..

My Vote of 5+..
Thank you Sir, its works fine...
Thanks again....

I clearly understand what you said , thanks for the Help..

I tried Your Last Example :-
private void button1_Click(object sender, EventArgs e)
{
Thread t = new Thread(() => doWork(tableLayoutPanel1));
t.IsBackground = true;
t.Start();

}
public void doWork(TableLayoutPanel TLP)
{
for (int i = 0; i < 30; i++)
{
Button btn = new Button();
btn.Text = (i + 1).ToString();
btn.AutoSize = true;
TLP.Controls.Add(btn);//same error here
}
}

and I also tried to send tableLayoutPanel1 as an argument in backgroundWorker1.
like :- backgroundWorker1.RunWorkerAsync(tableLayoutPanel1);
the event is :-
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
TableLayoutPanel tlp = (TableLayoutPanel)e.Argument;
for (int i = 0; i < 30; i++)
{
Button btn = new Button();
btn.Text = (i + 1).ToString();
btn.AutoSize = true;
tlp.Controls.Add(btn);//Cross-thread operation not valid
}
}
same error here..
nothing improved .....

Thanks a lottttttttt Sir its works perfectly more faster then previous..... :-)

Sir, sorry for the missing info..
I tested this all methods loops with 30 (means Noq=30).
If I do it with 100 then it will be getting longer time(more then 4 min.) to execute ...
then the problem will arise .... :-(
How to solve this???

Sir,
I get all the Execution details in Milliseconds.
createBtn() == 1280 (Milliseconds).
getQues() == 121 (Milliseconds)
generateRnd() == 2 (Milliseconds).

Solution ?? :-)

1. generateRnd();
2. getQues();
3. createBtn();
above all functions are making slow my "form load"(which are Important functions also). :-(
and "Noq" maximum value will be "100"(I think this not the very high Number)....
is there any way to do this(I mean, that when the functions are executing meantime a messageBox appear.)??

okay.
if i create a thread class and access all the controls(UI) which are needed to manipulate then it will be complicated..
how I accessed tableLayoutPanel1 Controls from another thread??

Yes sir, I'm having a problem with speed on my Form(main thread)....
the functions are slowing my form load....
I'm not good in thread(UI thread).

Sir, create a method for that code, and called that method from BackgroundWorker DoWork event, but still its gives same error... :-(

can you please give me example of
how to move the code into the UI thread via the BackgroundWorker.ReportProgress method???

Sir,
Its Works fine,This is I need...
Hats Off to You Sir(You did Just In 15-Mins).. WOW
Thank You Very muchhhhhhhhhhhhhhhhhhhhhhhh Sir........ :-)

Sir,
I want to create a option button which have the scroll bar to display its overflow text..
So first I create a custom textbox(which doesn't show the cursor) and a ratio button, and combine them in a user control.
I need two property: 1) Text property, 2) Checked Property and both are set and get type,also this user control behave like an system radio button...

Yes I have only one radio button in my User control...

Sir, Its works fine ...
But only one problem is there: when I set IsChecked Property of user control is false then the last control's IsChecked is true(among four control the last is MyCustRadio4)...
My form code is :-
private void Form2_Load(object sender, EventArgs e)
{
myCustRadio1.Text = "1";
myCustRadio2.Text = "2";
myCustRadio3.Text = "3";
myCustRadio4.Text = "4";
unCheck();
}
private void unCheck()
{
myCustRadio1.IsChecked = false;
myCustRadio2.IsChecked = false;
myCustRadio3.IsChecked = false;
myCustRadio4.IsChecked = false;
}
How to resolved this ???

Thanks Sir... :-)
now I create a userControl for that...

Reason for my vote of 5 \n My vote of 5.

when i run your code it couldn't stop(its generating the numerous printing documents pages), if I canceled the the generating then its shows the print pages other wise its continue to generating the pages..
please help me...

No, 'AxRichTextLib' is not in VB6 code, after I converted the code to C#, then the converter convert some code to this "AxRichTextLib" in .CS file.

I download code from here : http://support.microsoft.com/kb/146022 (which you mention above).

Sir, I download "ILSpy version 2.1.0.1603", but i couldn't understand how to convert the VB6 project into C#..
when I want to open my VB project its file types is ".NET Assembly" only..
can you be more elaborate please???

Sir, Thanks for help..
I converted the whole project into C# application.
the VB6 to C# converter doesn't convert this and so many, I solve some of them but I stuck here...
I got an error: couldn't convert "AxRichTextLib.AxRichTextBox" to "RichTextBox1" in C# application.
How to convert it??

Sir, I can't convert this VB6 code into C#.net, there is lots of complexity.... :-(
can you provide it in C# or VB.NET ??
Please....

Thanks.....

Sir, I told in a previous comments that i need smaller size of my setup files,so that's why I don't want to add any prerequisite. The user have .NET 3.5 in his machine and my program classes are for .NET 2.0 or 3.0. So Why should I use .NET 4.0(which increase the size)???
can You please suggest me how to change .NET Framework of a setup Project???

Sir, I know that .NET Framework 4.0 is new and 2.0 is obsoleted. But in this situation I need small size of a setup file. so I need it to 2.0 or 3.5 .NET Framework(user have win7 OS)...

Oooo.. I got the Mistakes...
Now I create and dispose the object after using,its working fine..
Thanks Sir, Thanks a Lottttttttttttttttt....
Thanks Sir... :-)

Sir, I updated my Question. Please See....

Sir, I solve that problem with some addition..
I made changed with bill No. before is '13-14/1' now it's '13-14/01' it returns the right value(maximum bill No.)..
thanks you so much for helping me Sir.... :-)

But Sir, I have bill no from '13-14/1' to '13-14/10' in my "BillDetails" table...

if I have bill No. like 'BI/13-14/000001' to 'BI/13-14/000010' then its return maximum bill no.('BI/13-14/000010'), and query is
"select max(bill_no) from BillDetails where left(bill_no,9)='BI/13-14/'"..
so where I did wrong???

Sir,Its doesn't return any billNo..
I also use "SELECT BillNo FROM BillDetails WHERE BillNo LIKE '13-14/%'" , but same result(blank). :-(
Sir, I'm using MSAccess as a Database..

Can you please tell me how to use DevExpress Rich Text Editor in VB2010(C#) applications???

Sir,sorry for late reply.
I get an error that "the type or namespace name 'unoidl' could not be found(are you missing a using directive or an assembly reference?)" on this line : "using unoidl.com.sun.star.lang;".. :-(
I have installed "LibreOffice 4.1" and "OpenOffice 4.0.0" on my pc. I read about dlls,but I couldn't find DLLs(which start with cli in reference)..
Please Help .....

Thanks for your help...
Sir I found the Solution...
Here : http://www.codeproject.com/Articles/31840/Move-controls-on-a-form-at-runtime

Your links program is in VB.NET(which I didn't know)...and I also download the source File which gives an error("Type 'DskResearch.RuntimeMovableControls.MovableLabel' is not defined").

My Vote of 5(for nice Advice)..

my vote of 5+

Sorry Sir,Its my mistake. I just read only documentations not the Examples...
now I got the Idea for implementation..
thanks ...
and My apology.....

Sir,Can you give the code to embed openoffice text document in C# winform??
I read Your last updates and links also, but there's only the theory parts,they are telling which DLL files are required, but not telling how to implements... :-(

Sir, I didn't understand there code. Can you please elaborate..
How I use Libreoffice in C#(which reference to be add), and how i embed the Openoffice text document in winform(On edit and printable mode)??????

Sir, can I embedded OpenOffice in my Winform application??

Thanks again I solve it with our suggestion(Graphics.MeasureString()).... :-)

thanks..
I will try it with Graphics..MeasureString()...

Okay Sir.. :-(

Sir I have MS Office installed on my computer...
is there any way to embed the MS word in winform ???

no..

Reason for my vote of 5 \n My vote of 5..
thanks It very helpful....

I mean it cannot smaller than Initial size(first time drawing size)....

Reason for my vote of 5 \n My vote of 5.
Total Its awesome..
thanks for this article .... :-)

thanks for quick reply..
I passing null value to my parameter that's why I'm getting error(as said @jokler.007)....

Thanks a lottttt..
Its workssssssss..

My vote of 5+...

@Mahesh I tried crystal report with direct database connection,Its fine shows all the records.
but when i tried with dynamic data which i posted, then it happened same result(No data on crystal reports)... :-(

TopSalesmanReport(TSR) is a crystal report,and report_show() is form name in which crystal report viewer exist...
so here I assign crystal_report to crystalReportViewer by ReportSource property...

My 5+..
thanks you Sir... :-)

Reason for my vote of 5 \n My vote of 5.
thanks Sir....
This is amazing .NET 4.0 ...

Thanks a Lotttttttttttttt..
Its works....
Thanks again...

My vote 5, for new technique..... :-)

yes!!
if there were another way to do that, then give that also..

My vote of 5!!!

But its ask "TotalAmount" value, when the query run..

Thanks a lottttttttt its works ..
Thank You..

I changed dates 2012 to 2013 but same result(all rows are display) nothing grouped ...

Its returns all rows from the tables ... :-(

Okay...
here is my test data, I give you only one row.
BI/12-13/000001
Jay Mukherjee
3/30/2013
Raj Roy
6.4
153.6
160
checked (last one is Yes/No type)..

after I putted parenthesis around 10 :-
"The select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect"
its shows error is here "slsmName"...

same error shows .. :-(