Comments by Faran Saleem (Top 57 by date)

Okay thanks I will explore it

No, I dont want to find the handle of the button, I just want to know if the button has been clicked or not

It doesn't work

No sir, you are wrong the issue here is not with = operator but the subquery. Subquery is returning more than one row that is why it is giving me an error. I have used the In operator aswell but it is giving the same error

Thanks it worked and can you please tell me how can i calculate the tax based on gross income?
lets say if the income entered is 50000 then it should select the nearest start row with 50000 which is 75000 and then will calculate the income based on below formula,
tax_income =(((res[0].GINCOME * 12) - start) * rate + v_tfx / 12);

Thanks

I am not repositng the same question, this one is a different question.

Can you give an example? how should i access the value 700001

What i want to know is how can i access the values.
Like if i want to access 700001 then how should i get it in a javaScript variable.
I am doing markers[0] but not working

There are around 12 rows in the database table but based on the gross income entered in the text box, the code should check on runtime the closest income in the database table and will select that row, then the formula to calculate tax will use the rate,fixed_tax columns of the same row to calculate the tax and display on text box

How should i do this

The above code is working fine but i want to calculate on real time with the values of database table and display on frontend.
Whant javaScript code should i write to calculate?

I want to copy data from one excel and paste it to another in text format

I want it to do using C# code.

I have tried this but it is giving me syntax error near CASE ending bracket

Thanks for your reply.
I am trying to do that, i have constructed the following query

MERGE od_test2 T --tareget
USING OD_TEST S --source
ON (S.ref = T.REF)
WHEN MATCHED
THEN UPDATE
SET T.LOGIN_DATE =
(CASE
WHEN s.stepname IN ('BUREAUPULL') THEN CONVERT(VARCHAR,s.[ENDDATE])
ELSE CONVERT(VARCHAR,s.[LOGIN_DATE])
END S.LOGIN_DATE),
(CASE
WHEN s.stepname IN ('l2','l3') THEN CONVERT(VARCHAR,s.[ENDDATE])
ELSE CONVERT(VARCHAR,s.[DECISION_DATE])
END S.DECISION_DATE)

WHEN NOT MATCHED BY TARGET
THEN INSERT (Target_Column_Names)
VALUES (Source_Column_Names)

WHEN NOT MATCHED BY SOURCE
THEN DELETE;


But the above query bis giving me syntax error. Can you help me resolve it?
i am trying to use case with UPDATE. When the stepname is BureauPull the EndDate should be inserted in Login_Date and when stepname is L2 or L3, EndDate should get inserted in Decision_Date

Thanks a ton, it worked..

I highly recommend you to learn some manners.. and that is not what i am looking for to, if you READ my post carefully then you can see.. Anyways thanks for your help..

You can ask the same politely and i will post the code, do not need to be harsh..

select count(ID_NO) as TotalCount from table1
where currentstepname in ('EV','IV')
group by ID_NO having count(ID_NO)>1

The above gives me the duplicate count of ID_NO but i want to display the CurrentStepName values as well.

And IDs are generated uniquely so i do not even know which IDs to put in where clause if i go by your suggestion,

There many records i can not use where clause and put all the IDs in there my friend.
I believe a subquery should be used here. I have tried using it but no luck

Thanks for your reply..but the thing is i am running a match on one single column.. i am not inputting any word.. like there is a table and it has a column hotel_names, so what i need is to run a match on that column and it should display similar results.. and the data is being uploaded on daily basis in that table.

I have checked it but their website says that it is not for organization.
I want to have a proper documentation, i can write it myself but it would be much easier for me if i can get a sample from somewhere which can help me in understanding of how a technical document should look like.

Thank you. With just a little addition the code worked.
Thanks a ton for your help..:)

I have already checked that. But it does not use BoundField. Can you please help me in that?

I have not written any code behind for the update button

With some tweaking to the code you provided i was able to get the desired results.

Thanks

Thanks for the reply but i am getting error here.. it says 'No overload for method 'RegisterStartupScript' takes 1 arguments

Leave out date.. that is not ao important. I just want to fetch the results with different cards on same merchant.
For example--> if i have 3 cards and they are swiped on 2 different merchants i-e 123 card swiped on abc merchant,345 on abc and 645 on xyz .
So in above scenario i would like to fetch results which have different cards on same merchants. Which would be 123 on abc and 345 on abc

I know wha t these keywords do.. but the question is how can i select different cards on same merchants..?

But i am already using CTE..Using them because i had to compare each row with the previous value.

So how can i do it?

And in above example we are subtracting from the max date.. what if i want results only with 7 days difference. Like for suppose if we have 4 following dates
2016-03-02
2016-03-04
2016-03-06
2016-06-08

In above case 2016-06-08 is the max date but the difference between other 3 dates is in between 7 days.
So i want to display only those 3 dates and not 2016-06-08

Thanks a ton for your help.. i ran your query and it worked great just a couple of issues.

1. The difference between dates is coming in negetive.
2. And how can I select the records with difference between date < 7

Looking forward to your reply

Sorry my bad there were some values whose length were less then 13 and therefore it was throwing that error..but i just tested it on date column where there is only date and not the time.. like 1160119.. and it is returning values like 20.1-60-12

And also i have just ran your query.. i have replaced @test with my column name that is local_time.. but it is giving an error "Invalid length parameter passed to the right function"

Yes sure that would be ally helpful..:) and also if you can tell me the syntax of how can i cast it after converting in the correct format..:)

Thanks for your reply..:)

But a question this will only convert a specific date from that column. What i want is to perform this thing on every record of that column so i can not use parameters and set value each time.

Hello Animesh,

Thanks a ton for your reply.
That is really helpful but just one issue here when i click on generate email button the bool value will get saved to the same tablee and the table has also got a primary key that is TransactionID so i would need to add the TransactionID with that bool value aswell because primary key cannot be null.
But the page has got another button which is save details and after generating email and filling out rest of the information the user will save the details.. so how can i do that.. as another record with same details will be added also i do not want to keep updating the same record after every button click that means my transactionID will keep on updating itself. I want the transactio nID to be saved inly once.
Also please note that transactionID is being generated at button click i have generated a uniqueNumber in save details which is being added in the database.. and to add generate email records in the database i would need to generate the transactionID there aswell.

I hope i have explained correctly..if you find any query please let me know. I will try and clear it.



Thanks

Hello suvendu

Thanks a ton for your reply.
That is really helpful but just one issue here when i click on generate email button the bool value will get saved to the same tablee and the table has also got a primary key that is TransactionID so i would need to add the TransactionID with that bool value aswell because primary key cannot be null.
But the page has got another button which is save details and after generating email and filling out rest of the information the user will save the details.. so how can i do that.. as another record with same details will be added also i do not want to keep updating the same record after every button click that means my transactionID will keep on updating itself. I want the transactio nID to be saved inly once.
Also please note that transactionID is being generated at button click i have generated a uniqueNumber in save details which is being added in the database.. and to add generate email records in the database i would need to generate the transactionID there aswell.

I hope i have explained correctly..if you find any query please let me know. I will try and clear it.



Thanks

Hello John,

I believe the Url is correct as if you look in their side this is how it is written. And also if the Url that you mentioned was the problem even then it should return the first page results. Of this Url http://www.realtor.com/realestateagents/New-York_NY/photo-1/ but it is returning null.

It only returned results once when i ran it in the morning today and i do not know how..i have not made any changes to my code. But can't seem to find the problem.

Can you please guide how? the attached xpath in the code is the name of each retailer.

That is what i am saying.. i am able to calculate the difference between two dates but i am not able to create the logic of how can i keep the Agein field getting increased with each passing day.
Thats where i need some help. Once the user submits the form, the agein field will be 0 for the first day but it should get increased to 1 automatically for the next day and then 2 and so on

Yes that is exactly what is happening.. how can i solve this? can you please guide?

I have figured out why it is not behaving as the way it should be, the reason is because the ageing on the basis of current date and the form submission date is getting calculated on the button submit event. So whenever the user hits the submit button the Ageing is calculated as 0 because at that moment the current date and form submitted date is same. But it will never get incremented, user will see ageing as 0 even if he visits the page after 10 days as ageing is getting calculated only when the button submit is pressed.
I am unable to create a logic where a user submits the form and the ageing will get increased with each passing day.
That is why i need help.

I am storing it in SQL Database.

No, I think i did not explain correctly.
What i am trying to do is calculate Ageing on the basis of the date when the form was submitted minus the current date.
Now lets assume the form was submitted on 2nd Oct 2016, so when the User submits the form on 2nd Oct 2016, he/she should view ageing as 0 because the form submission date and the current date is same so the result is 0.
But when the user visits the page the next day i-e on 3rd Oct 2016 and he/she sees the submitted forms then the ageing should be 1, because the form was submitted on 2nd Oct 2016 and the user is seeing the form on 3rd oct2016, so the difference is 1 day and Ageing in this case should be 1. And similarly when the user views the form on 4th Oct 2016 the Ageing should be 2, and likewise for 5th Oct 2016 the ageing should be 3, because the form was submitted on 2nd oct 2016 and current date is 5th Oct 2016 so it should calculate the difference between the two dates.
I hope i have cleared your confusion, if there is still any query please ask

80 columns*.. my mistake.

I just need to display the results againt relevant labels. Like i want to display Name against name, age against age.. And this table is in different database

Thank you..that was extremely helpful. Please be kind enough to solve another query.. i also want to fetch the remaining 80 rows according to the passed query string values against each label.
I would be very thankful and will appreciate your efforts

Thank you..that was extremely helpful. Please be kind enough to solve another query.. i also want to fetch the remaining 80 rows according to the passed query string values against each label.
I would be very thankful and will appreciate your efforts

Thanks for replying.
Can you share some code please..that would really help

Thanks

I would like to fetch the row that is being clicked and display it in second page. I need some code, if you can provide any help i would really appreciate it.

Thank you Vincent. your guidance here helped me a lot. Thanks a ton.. :)

Hey Vincent..The gridvew approach is working fine for me.. But just another query.. i have 2 fixed columns as well 'School Name' and 'City' and user will fill and submit those fields aswell along with the dynamic gridview..
Like if a School name is ABC and City is London. So i want to store this and dynamically generated columns in gridview in the same table in sql database..can you help me with that please..?

And user will not be entering 100,000 records.. just wanted it to be dynamic to add text boxes without any limit