15,740,620 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View Javascript questions
View C++ questions
View Python questions
View Java questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by V Mohan (Top 40 by date)
V Mohan
16-Oct-14 7:13am
View
Manually also i cannot delete. But the same code is in local machine it is working fine.
V Mohan
15-Sep-14 6:33am
View
Hi,
Thanks for your help. But i am using VC#.net 2008. Its not wotking for me. Please help me.
Thanks
Mohan
V Mohan
28-Jul-14 6:36am
View
Thank you so much. Its working fine
V Mohan
28-Jul-14 6:19am
View
Can you please help with this
V Mohan
28-Jul-14 5:53am
View
Thanks. I want Each maximum value in each category.
Flow is
1.first need to take distinct value of Refno
2.Check the Prefix for those rows and take maximum value of Prefix
3 Then in that i need to get max as seq
For above example
1.55, 56,59 is the output of first step
2 in these A is max of 55 and 56,59
3 for a 55 Seq 3 is the maximum, for 56 a 3 seq is maximum
4 for 59 a is the max value
so the output is
ID RefNo Prefix Seq
183 55 A 3
188 56 A 3
190 59 A 1
Thanks in advance
V Mohan
17-Jul-14 8:22am
View
Yes i am using stored procedure
V Mohan
17-Jul-14 8:22am
View
Thanks rob.
I am using .Net 3.5 and SQL Server 2008
Thanks
Mohan
V Mohan
13-May-14 7:50am
View
Thanks peter, With above query its converting all the single record into min
like below
RID CID Name Value
1 1 Test 175
1 1 Test 200
But
I need the Result as below
RID CID Name Value
1 1 Test 375
Some of value field of similar rows
V Mohan
13-May-14 7:19am
View
Thanks, But it displays the seperate records as result like below
1 1 Test 2:15
1 1 Test 4:15
But i need result as follow
1 1 test 6:30
Please help
V Mohan
13-May-14 7:07am
View
Thanks. But its working for me if the value is integer. My problem is the value field is can be time also so i use the below conversion to set sum of time
Convert(time,dateadd(s,SUM(( DATEPART(hh, td.value) * 3600 ) + ( DATEPART(mi, td.value) * 60 ) + DATEPART(ss, td.value)),0)) as Total
But it show the same values not the sum of the values. Please help me to resolve this
V Mohan
13-May-14 6:54am
View
Sorry, I got the Sum of all values in a table , But my requirement is need some of Unique record values. Please help me
V Mohan
13-May-14 6:51am
View
No
V Mohan
7-May-14 2:25am
View
Thanks. it is working fine
V Mohan
7-May-14 2:19am
View
Because value is nvarchar type
V Mohan
7-May-14 2:19am
View
Thanks for yor reply. Second query is working fine. But the first query is showing error as follows
Conversion failed when converting the nvarchar value '4.3' to data type int.
V Mohan
7-May-14 2:11am
View
Because the Data type for Value is nvarchar. So its shows error as below
Operand data type time is invalid for sum operator.
V Mohan
7-May-14 2:09am
View
Thanks for your reply. I tried but it shows error as below
Operand data type nvarchar is invalid for sum operator.
V Mohan
7-May-14 1:50am
View
I tried, But it shows error. Please help me to get sum of all int and sum of all time value in a query
V Mohan
7-May-14 1:22am
View
I want two outputs one is sum of all integer values as integer and another one is sum of all time in time format.
Thanks
V Mohan
3-Apr-14 1:50am
View
Thanks Raul. I tried this but it return all the records in the table i need max version of each product.Please help me to achive this
V Mohan
3-Apr-14 1:35am
View
Thanks.
I need Max version based on Each Product. I will give Persion_Id as input . But i need result for each product max version
Please help
V Mohan
10-Feb-14 3:30am
View
Thanks, But i need generalized query to achive this task.
I want only month as a result when i gave start date and end date.
But main objective is month to be rounded of to down that is
if result is 1.9 then result need to change as 1
Please help me to resolve this
V Mohan
13-Sep-13 0:26am
View
<SESSIONSTATE timeout="150"> </SESSIONSTATE>
V Mohan
13-Sep-13 0:26am
View
Thanks Prasad.
i need session timeout as 150 min. So can i set like below in web.config.
<sessionstate timeout="150"> .
Thanks in Advance
Mohan
V Mohan
6-Aug-13 0:29am
View
Thanks. But Already button inside the update panel
V Mohan
5-Aug-13 23:49pm
View
Thanks.but my code is in update panel only
V Mohan
3-Jul-13 0:20am
View
its only for one project.
V Mohan
5-Jun-13 8:56am
View
Thanks Suna,
I have bulk data in my excel sheet.From that excel sheet only i need to be copy data and store in SQL table. How i can read data from Excel to sql server
V Mohan
24-Apr-13 2:55am
View
in master page
<div id="content" class="shell">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<contenttemplate>
<asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">
</div>
in Aspx page :
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:UpdatePanel ID="RegUpdatePanel" runat="server">
<contenttemplate>
<asp:FileUpload ID="flUpload" runat="server" Width="148px" />
<asp:Button ID="btSubmit" Text="Upload" runat="server" OnClick="btn_UploadClick" />
<Triggers>
<asp:PostBackTrigger ControlID="lnkTemplate" />
<asp:AsyncPostBackTrigger ControlID="btSubmit" />
</Triggers>
V Mohan
3-Apr-13 5:18am
View
Hi FOX,
Thanks for your answer.
I use web form (ASP.Net with C#)
V Mohan
12-Feb-13 23:56pm
View
Yes. I changed the permission in IIS. its working fine. Thanks
V Mohan
8-Oct-12 5:53am
View
Thanks Aarti
V Mohan
8-Oct-12 5:14am
View
Sorry for confusion .please validate above table structure. Can i use the same table structure for storing and display nearly 100 employee .
V Mohan
8-Oct-12 3:55am
View
Hi Aarti , Thanks for your advice, can you give the table design that the above inputs stored in Database
V Mohan
3-Oct-12 0:06am
View
As well as i need separate table for each team
V Mohan
3-Oct-12 0:06am
View
Thanks Sandeep.
I share some sample questions
Team Question Answer
A Question1 Answer1
A Question2 Answer2
B Question 1 Answer1
B Question 2 Answer2
C Question1 Answer1
C Question2 Answer2
In this way i have to display the grid. Pls suggest the best method to display this content.
V Mohan
14-Sep-12 0:23am
View
I am using Update panel . But outside the update panel same code is working fine. Problem is with the update panel.
Simply i use to download the file from server in my link button click event
Please help me to solve the problem .
Code is as below
Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName);
Response.TransmitFile(FilePath);
Response.End();
V Mohan
3-Sep-12 1:54am
View
Already i did change the values of ObjectDatasource using the Smart Tag of the Report Viewer. But Same Error is Display
V Mohan
23-Aug-12 5:06am
View
Thank you so much
V Mohan
23-Aug-12 4:25am
View
No, In different scenario i join different tables but i select common fields from all. For that only i need a LINQ query for var Lqry as a general
Show More