Comments by Shivangi Rawat (Top 19 by date)

Neither the function in onservervalidate nor in ClientValidationFunction

The code is not getting hit.

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..

Thank You :-)

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...

Thank you very much..:-)

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..

to use pivot do i have to import any namespace.Sorry to ask this but i have not used pivot before.

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

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?

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...

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"....

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?

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();
}

}