16,022,752 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 C++ questions
View Visual Basic questions
View Javascript questions
View .NET 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 Shivangi Rawat (Top 19 by date)
Shivangi Rawat
10-Oct-18 3:07am
View
@Gerry ok..ThankYou
Shivangi Rawat
24-Sep-18 6:56am
View
@Richard- Thank You, I will try to look into Windows Hooks
Shivangi Rawat
6-Jun-17 11:02am
View
Yes, I have already used it for validating some other input field.:-)
Shivangi Rawat
5-Jun-17 9:17am
View
Its working now..Thanks
Shivangi Rawat
3-Jun-17 10:33am
View
Ok I have a button to submit the data. But I m not having a onclick event for that..Is that needed ?
Shivangi Rawat
3-Jun-17 10:08am
View
Neither the function in onservervalidate nor in ClientValidationFunction
Shivangi Rawat
3-Jun-17 9:48am
View
The code is not getting hit.
Shivangi Rawat
6-Oct-15 3:03am
View
i want that on mouseoout if the user hasn't clicked on any of the circles it should retain the green color for the previous selected circles. thereby in my code on click () i have used index to get the value of the selected circles but i am not getting how to use that in mouseout() so that i can again apply the 'rating-chosen' class(green color). this is where i am stuck..
Shivangi Rawat
21-Jul-13 13:06pm
View
Thank You :-)
Shivangi Rawat
19-Jul-13 15:49pm
View
Thank you very much...my question is that I have a datagrid which shows data for the columns named Name,Wc,NC,Edate.I want to add a delete button to every row in datagrid so that when it is clicked only that entry gets deleted from database.Kindly help..please...
Shivangi Rawat
18-Jul-13 16:58pm
View
Thank you very much..:-)
Shivangi Rawat
18-Jul-13 16:08pm
View
void Page_Load(Object a, EventArgs b)
{
// SqlConnection s = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\grdproject.mdf;
//Integrated Security=True;Connect Timeout=30;User Instance=True");
// int f=0;
// s.Open();
DECLARE @dt VARCHAR(2000)
DECLARE @pt VARCHAR(MAX)
string x,x1;
SET @dt= "SELECT AppNo, WorkCenter, [Sent_Received]from dataentry";
SET @pt = "SELECT AppNo,WorCenter,' + @dt + 'FROM (' + @dt + ') AS DT PIVOT (COUNT([status]) FOR [status] IN (' + @cols + ')) AS PT";
EXEC(@pt);
SET @cols = STUFF((SELECT DISTINCT '],[' + [wc] FROM #tmp ORDER BY '],[' + [wc] FOR XML PATH('')),1,2,'') + ']'
}
it is giving an error.please check it..
Shivangi Rawat
18-Jul-13 11:07am
View
to use pivot do i have to import any namespace.Sorry to ask this but i have not used pivot before.
Shivangi Rawat
18-Jul-13 5:06am
View
that will bring together all the data on the basis of rows i specify..
I have to "count" how many Applications came from Delhi,Dehradun,...how many were send to HR,Finance...,How many were received from HR,Finance.
I have to display it in following format:-
WC Received From Sent To
HR Finance HR Finance
Delhi 2 4 5 10
Dehradun 4 0 10 0
Shivangi Rawat
18-Jul-13 4:04am
View
yes,now i have to count the number of all such applications denoted by AppNo that are going to different places(say Delhi,Dehradun....)and to whom(HR,Wc) and received from (HR,Dehradun...) so that i can prepare a report based on that.
so how should i do it?
Shivangi Rawat
18-Jul-13 3:05am
View
Thank you...sorry to trouble you again.I have one more query.
is there any way in asp.net to count multiple values at the same time but of different types..
The eg which i gave before in that i want to count how mant applications came from chennai,dehradun....,how many were sent to finance,workcenter...,amd received too...
Shivangi Rawat
16-Jul-13 16:00pm
View
eg:-
AppNo Name Workcenter Sent_Recvd Action Remarks Edate NatureOfClaim Modno
100 Jyoti Ahmedabad From WorkCenter Return after Correction corrections done 7/16/2013 11:51:44 AM 10-D 1
100 Jyoti Ahmedabad To WorkCenter RIO for Correction photo missing 7/16/2013 11:42:03 AM 10-D 2
100 Jyoti Ahmedabad 7/16/2013 11:39:05 AM 10-D 3
101 Divya Chennai From Finance Form8 done passed through finance 7/16/2013 12:00:00 AM 10-C(Withdrawl) 1
101 Divya Chennai 7/16/2013 12:00:00 AM 10-C(Withdrawl) 2
101 Divya Chennai To Finance For Form8 make form8 7/16/2013 12:00:00 AM 10-C(Withdrawl) 3
102 Shewta Dehradun 7/16/2013 12:31:00 PM 10-D
now,"when sorted for each AppNo the data that comes at the top will be the latest status of that application.So i want to retrieve only that latest data"....
Shivangi Rawat
16-Jul-13 15:25pm
View
Thank you very much it worked..
but If i want to select only the topmost data of every particular AppNo when sorted in descending order then what query i should execute?
Shivangi Rawat
16-Jul-13 14:08pm
View
Sorry....and Thank You
Maciej Los
I tried it as follows but its giving an error that code near AppNo is incorrect.Kindly Help me..
SqlConnection s = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\grdproject.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True");
s.Open();
int f = 0;
string x = "select * from dataentry orderby AppNo,Edate desc";
SqlCommand s1 = new SqlCommand(x, s);
SqlDataReader s2 = s1.ExecuteReader();
while (s2.Read())
{
f = 1;
s.Close();
break;
}
if (f == 1)
{
s.Open();
SqlDataAdapter s11 = new SqlDataAdapter(x, s);
DataSet d = new DataSet();
s11.Fill(d);
yy.DataSource = d.Tables[0];
yy.DataBind();
s.Close();
}
}
Show More