Forgot your password?
Sign in with
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Python questions
View Java questions
All Message Boards...
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Design and Architecture
Internet of Things
C / C++ / MFC
ATL / WTL / STL
Objective-C and Swift
Hardware & Devices
Hosting and Servers
.NET (Core and Framework)
Site Bugs / Suggestions
Spam and Abuse Watch
The Insider Newsletter
The Daily Build Newsletter
Most Valuable Professionals
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
What is 'CodeProject'?
Ask a Question
Bugs and Suggestions
Article Help Forum
Comments by V Mohan (Top 40 by date)
Manually also i cannot delete. But the same code is in local machine it is working fine.
Thanks for your help. But i am using VC#.net 2008. Its not wotking for me. Please help me.
Thank you so much. Its working fine
Can you please help with this
Thanks. I want Each maximum value in each category.
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
Yes i am using stored procedure
I am using .Net 3.5 and SQL Server 2008
Thanks peter, With above query its converting all the single record into min
RID CID Name Value
1 1 Test 175
1 1 Test 200
I need the Result as below
RID CID Name Value
1 1 Test 375
Some of value field of similar rows
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
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
Sorry, I got the Sum of all values in a table , But my requirement is need some of Unique record values. Please help me
Thanks. it is working fine
Because value is nvarchar type
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.
Because the Data type for Value is nvarchar. So its shows error as below
Operand data type time is invalid for sum operator.
Thanks for your reply. I tried but it shows error as below
Operand data type nvarchar is invalid for sum operator.
I tried, But it shows error. Please help me to get sum of all int and sum of all time value in a query
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 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
I need Max version based on Each Product. I will give Persion_Id as input . But i need result for each product max version
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
<SESSIONSTATE timeout="150"> </SESSIONSTATE>
i need session timeout as 150 min. So can i set like below in web.config.
<sessionstate timeout="150"> .
Thanks in Advance
Thanks. But Already button inside the update panel
Thanks.but my code is in update panel only
its only for one project.
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
in master page
<div id="content" class="shell">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">
in Aspx page :
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:UpdatePanel ID="RegUpdatePanel" runat="server">
<asp:FileUpload ID="flUpload" runat="server" Width="148px" />
<asp:Button ID="btSubmit" Text="Upload" runat="server" OnClick="btn_UploadClick" />
<asp:PostBackTrigger ControlID="lnkTemplate" />
<asp:AsyncPostBackTrigger ControlID="btSubmit" />
Thanks for your answer.
I use web form (ASP.Net with C#)
Yes. I changed the permission in IIS. its working fine. Thanks
Sorry for confusion .please validate above table structure. Can i use the same table structure for storing and display nearly 100 employee .
Hi Aarti , Thanks for your advice, can you give the table design that the above inputs stored in Database
As well as i need separate table for each team
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.
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);
Already i did change the values of ObjectDatasource using the Smart Tag of the Report Viewer. But Same Error is Display
Thank you so much
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
Last Updated 1 Jan 1900
All Rights Reserved.