Comments by Tech Code Freak

Tech Code Freak 6-Sep-17 13:02pm View

Oh thanks a lot!!!
You are my saviour

Tech Code Freak 8-May-13 7:07am View

It's Okay!

Tech Code Freak 7-May-13 4:22am View

Thank You so much!
This is exactly what I wanted!

Tech Code Freak 6-May-13 0:57am View

Hello! Thanks for the reply!

I want to ask:
I have an AdDetail.aspx page which will take querystring parameter: "id" and then fetch data of that particular ad from the database. And also add meta description, keywords, etc tags at runtime (dynamically).
This url "mysite.com/ads/adDetail.aspx?id=501" will nowhere be mentioned on the website. But this link will be generated dynamically in the Repeater control when ads are searched for.
So, will this link in any way be indexed by the search engines?

Tech Code Freak 28-Jan-13 8:48am View

solved or not? if yes, accept the answer that helped!

Tech Code Freak 14-Dec-12 1:47am View

Excellent links! 5up!

Tech Code Freak 10-Nov-12 10:41am View

Your answer helped a lot!
Perfect one for Asp.net through PHP.

But as the hosts don't give access to gac to add assembly file, PHP was hard to get going.

PowerShell too was out of reach.

So, I used vbscript for the same and guess what?
It's working!

The resolution to the problem is no doubt different from your answer but still, it was very helpful in the research.

Thanks again!

Tech Code Freak 10-Nov-12 10:30am View

Accepted + 5up

Tech Code Freak 9-Nov-12 8:42am View

Sorry, Not familiar with Powershell.
Would try to learn something about Powershell now.
Can we call ASP.Net methods directly from powershell without GAC entry?

Tech Code Freak 9-Nov-12 8:35am View

Saw the 1st link. Good one. It is what I wanted. But now, I dont know:
1. How to create a Key File on my web Host's server.
2. How to add the assembly file to my web host's GAC.
How do you do it??

Or is there any other way out?

Tech Code Freak 13-Oct-12 5:01am View

5up!

Tech Code Freak 30-May-12 12:12pm View

5up

Tech Code Freak 9-Mar-12 1:28am View

5up!

Tech Code Freak 9-Mar-12 1:22am View

5up!

Tech Code Freak 8-Mar-12 4:04am View

5up!

Tech Code Freak 8-Mar-12 3:57am View

5up!

Tech Code Freak 8-Mar-12 3:53am View

5up!

Tech Code Freak 8-Mar-12 3:53am View

5up!

Tech Code Freak 8-Mar-12 3:48am View

Good suggestion! 5up!

Tech Code Freak 8-Mar-12 3:48am View

5up!

Tech Code Freak 8-Mar-12 3:46am View

5up!

Tech Code Freak 5-Mar-12 0:40am View

Try adding this below if() block:
else
{
//throw some Exception.
}

Insert some breakpoints and debug your program to know what is happening actually.

Tech Code Freak 29-Feb-12 3:55am View

5up!

Tech Code Freak 29-Feb-12 3:55am View

5up!

Tech Code Freak 29-Feb-12 3:53am View

up!

Tech Code Freak 29-Feb-12 3:53am View

5up!

Tech Code Freak 29-Feb-12 3:53am View

5up!

Tech Code Freak 28-Feb-12 5:33am View

5up!

Tech Code Freak 28-Feb-12 5:30am View

5up!

Tech Code Freak 28-Feb-12 5:29am View

5up!

Tech Code Freak 27-Feb-12 4:14am View

Added pre tags

Tech Code Freak 27-Feb-12 4:05am View

Corrected some tags.

Tech Code Freak 27-Feb-12 4:03am View

Added a " which was missed by mistake.

Tech Code Freak 25-Feb-12 8:04am View

5up!

Tech Code Freak 25-Feb-12 4:32am View

5up! Good link!

Tech Code Freak 25-Feb-12 4:24am View

5up!

Tech Code Freak 24-Feb-12 1:51am View

Corrected pre tags

Tech Code Freak 24-Feb-12 1:46am View

5up!

Tech Code Freak 24-Feb-12 1:46am View

5up!

Tech Code Freak 23-Feb-12 4:12am View

5up!

Tech Code Freak 23-Feb-12 4:12am View

5up!

Tech Code Freak 23-Feb-12 4:12am View

5up!

Tech Code Freak 18-Feb-12 3:29am View

5up!

Tech Code Freak 18-Feb-12 2:43am View

5up!

Tech Code Freak 18-Feb-12 2:43am View

5up!

Tech Code Freak 14-Feb-12 4:27am View

5up!

Tech Code Freak 14-Feb-12 4:26am View

5up!

Tech Code Freak 14-Feb-12 4:26am View

5up!

Tech Code Freak 14-Feb-12 4:15am View

5up!

Tech Code Freak 14-Feb-12 4:15am View

5up!

Tech Code Freak 14-Feb-12 4:14am View

5up!

Tech Code Freak 13-Feb-12 3:33am View

Thank You so much!

Tech Code Freak 13-Feb-12 3:30am View

5up!

Tech Code Freak 13-Feb-12 3:30am View

5up!

Tech Code Freak 13-Feb-12 3:27am View

5up!

Tech Code Freak 13-Feb-12 3:26am View

5up!

Tech Code Freak 13-Feb-12 3:21am View

5up!

Tech Code Freak 13-Feb-12 3:20am View

Pls reply.

Tech Code Freak 13-Feb-12 3:18am View

5up!

Tech Code Freak 13-Feb-12 2:08am View

For that, try assigning value of the ddlTesterName.SelectedItem.Text or ddlTesterName.SelectedValue to some variable before entering in the database. Then add that variable in the database. Give it a try.

Entire Solution is edited. Replace existing with this new one.

Tech Code Freak 13-Feb-12 1:17am View

Have you done this:
SqlCommand cmd=new SqlCommand("Select top 1 WID from tblWorkAllocation order by WID desc", SqlConnection1);
before object obj= cmd.ExecuteScalar(); ?
Here, tblWorkAllocation should be your table name, SqlConnection1 is your SqlConnection object to which you should have already allocated a connection string.

Tech Code Freak 13-Feb-12 0:47am View

Solution Updated! This will surely work.
Now click on Accept Solution and vote for it!

Tech Code Freak 13-Feb-12 0:29am View

For the primary key, you must first retrieve the last entered WID in the table. then increment it in the loop. And then enter in the database. I am updating my Solution further as per your requirement.

Tech Code Freak 13-Feb-12 0:06am View

Thanks again for the reply!
While updating, the no. will just be incremented/decremented from the existing no. in that column. The updating is all done by coded Stored Procedures so there's no chance of forgetting to update it.
I have made a mistake in describing it. Instead of adding the 5 columns to the 5 tables, they must be added to the User table so that each time he adds/removes an item, then that column will be incremented/decremented. And also, there will be no chance to count the records every now and then. I'll just have to read one particular cell each time(select NoItem1 from User where Id=@id).
Sorry for that mistake!

Tech Code Freak 12-Feb-12 11:43am View

Not one row. The table will contain a list of different users and the specifications that they provide with that type of their item.
eg: TableItem1
ItemId UserId Spec1 Spec2 Spec3 .....
1 1 sp83 sp54 sp54 .....
2 1 sp76 ......................
3 2 .... .........

and so on..

Tech Code Freak 12-Feb-12 8:32am View

Thanks for the reply!
I have 5 tables for the items which individually contain 8-10 columns each. Maybe my description was a little vague..
Please reply.
I think that select count(*) will take more time for execution. Also, I will have to use output parameters for the procedure which lengthens the code too. Instead, saving count in the table will take comparatively lesser time to run select itemCount from tab1 where id=@id.

Tech Code Freak 12-Feb-12 1:02am View

5up!

Tech Code Freak 12-Feb-12 1:02am View

5up!

Tech Code Freak 12-Feb-12 1:01am View

5up!

Tech Code Freak 12-Feb-12 1:00am View

5up!

Tech Code Freak 12-Feb-12 1:00am View

5up!

Tech Code Freak 12-Feb-12 1:00am View

5up!

Tech Code Freak 12-Feb-12 1:00am View

5up!

Tech Code Freak 12-Feb-12 0:56am View

5up!

Tech Code Freak 12-Feb-12 0:36am View

Thanks.

Tech Code Freak 12-Feb-12 0:36am View

Thanks!

Tech Code Freak 11-Feb-12 8:51am View

5up!

Tech Code Freak 11-Feb-12 8:51am View

5up!

Tech Code Freak 11-Feb-12 8:48am View

Now checkout my ready to use solution--Solution 3
Add click on Accept Solution for all working Solutions.
Don't forget to vote!

Tech Code Freak 11-Feb-12 7:10am View

Reply to my comment above. It's below your question, so that I can help you.

Tech Code Freak 11-Feb-12 7:01am View

5up!

Tech Code Freak 11-Feb-12 6:56am View

added pre tags

Tech Code Freak 11-Feb-12 6:29am View

5up!

Tech Code Freak 11-Feb-12 6:29am View

5up!

Tech Code Freak 11-Feb-12 6:28am View

5up!

Tech Code Freak 11-Feb-12 6:28am View

5up!

Tech Code Freak 11-Feb-12 6:20am View

How do you want these entries inserted in the database?
If you want to select multiple items from the listbox, then those items will be saved in one cell in the database, or as different entries?
eg:
Id TesterName BuildNo AddedItems
1 Alex 1 abc,xyz,pqr
2 Roger 2 mno,def
3 Sarah 3 ghi,wxy

OR

Id TesterName BuildNo AddedItems
1 Alex 1 abc
2 Alex 1 xyz
3 Alex 1 pqr
4 Roger 2 mno
5 Roger 2 def
6 Sarah 3 ghi
7 Sarah 3 wxy

Select the way you want the entries to be inserted and I will guide you further.

Tech Code Freak 9-Feb-12 0:46am View

5up!

Tech Code Freak 9-Feb-12 0:43am View

5up!

Tech Code Freak 9-Feb-12 0:40am View

5up!

Tech Code Freak 9-Feb-12 0:40am View

5up!

Tech Code Freak 9-Feb-12 0:40am View

5up!

Tech Code Freak 9-Feb-12 0:38am View

5up!

Tech Code Freak 9-Feb-12 0:36am View

5up!

Tech Code Freak 9-Feb-12 0:36am View

5up!

Tech Code Freak 9-Feb-12 0:36am View

5up!

Tech Code Freak 8-Feb-12 12:48pm View

5up!

Tech Code Freak 8-Feb-12 12:48pm View

added pre tags

5up!

Tech Code Freak 8-Feb-12 12:45pm View

5up!

Tech Code Freak 8-Feb-12 12:45pm View

5up!

Tech Code Freak 8-Feb-12 12:42pm View

5up!

Tech Code Freak 8-Feb-12 12:41pm View

5up!

Tech Code Freak 8-Feb-12 12:41pm View

5up!

Tech Code Freak 8-Feb-12 12:41pm View

5up!

Tech Code Freak 8-Feb-12 12:38pm View

5up!

Tech Code Freak 8-Feb-12 12:38pm View

5up!

Tech Code Freak 8-Feb-12 12:38pm View

5up!

Tech Code Freak 8-Feb-12 12:36pm View

5up!

Tech Code Freak 8-Feb-12 12:36pm View

5up!

Tech Code Freak 8-Feb-12 12:34pm View

5up!

Tech Code Freak 8-Feb-12 12:33pm View

5up!

Tech Code Freak 8-Feb-12 12:29pm View

5up!

Tech Code Freak 8-Feb-12 12:27pm View

5up!

Tech Code Freak 8-Feb-12 12:27pm View

5up!

Tech Code Freak 8-Feb-12 12:26pm View

5up!

Tech Code Freak 8-Feb-12 12:21pm View

5up!

Tech Code Freak 8-Feb-12 12:11pm View

5up!

Tech Code Freak 8-Feb-12 12:10pm View

Corrected pre tags

Tech Code Freak 8-Feb-12 12:07pm View

5up!

Tech Code Freak 8-Feb-12 12:07pm View

5up!

Tech Code Freak 8-Feb-12 11:58am View

Yes, that's it! How did I ever forget that?
Thank you so much!
5up!

Tech Code Freak 8-Feb-12 8:51am View

Post your answer in the Solution form and not as a comment. Type it in Add a Solution below.

Tech Code Freak 8-Feb-12 8:49am View

Corrected pre tags

Tech Code Freak 8-Feb-12 8:49am View

Corrected pre tags

Tech Code Freak 8-Feb-12 8:42am View

5up!

Tech Code Freak 8-Feb-12 8:42am View

5up!

Tech Code Freak 8-Feb-12 8:42am View

5up!

Tech Code Freak 8-Feb-12 8:42am View

5up!

Tech Code Freak 6-Feb-12 6:42am View

5up!

Tech Code Freak 6-Feb-12 6:38am View

5up!

Tech Code Freak 6-Feb-12 6:38am View

5up! Correct!

Tech Code Freak 6-Feb-12 6:37am View

5up!

Tech Code Freak 6-Feb-12 6:37am View

5up!

Tech Code Freak 6-Feb-12 6:37am View

5up!

Tech Code Freak 6-Feb-12 6:35am View

5up!

Tech Code Freak 6-Feb-12 6:32am View

5up!

Tech Code Freak 6-Feb-12 6:30am View

5up!

Tech Code Freak 6-Feb-12 6:29am View

5up!

Tech Code Freak 6-Feb-12 6:29am View

5up!

Tech Code Freak 6-Feb-12 6:27am View

5up!

Tech Code Freak 6-Feb-12 6:27am View

5up!

Tech Code Freak 6-Feb-12 6:27am View

5up!

Tech Code Freak 6-Feb-12 6:27am View

5up!

Tech Code Freak 6-Feb-12 6:18am View

5up!

Tech Code Freak 6-Feb-12 6:18am View

5up!

Tech Code Freak 2-Feb-12 5:58am View

5up!

Tech Code Freak 2-Feb-12 5:55am View

5up!

Tech Code Freak 2-Feb-12 5:52am View

replaced &-quot-; to with "

Tech Code Freak 2-Feb-12 5:48am View

Correct! 5up!

Tech Code Freak 2-Feb-12 5:45am View

5up!

Tech Code Freak 2-Feb-12 5:45am View

5up!

Tech Code Freak 2-Feb-12 5:45am View

5up!

Tech Code Freak 2-Feb-12 5:38am View

Edited to remove xmlns:.....
Changed "..." to '...'

Tech Code Freak 2-Feb-12 5:37am View

Got the answer...then just accept your Solution!
Always great solving yourself!
5up!

Tech Code Freak 2-Feb-12 5:06am View

5up!

Tech Code Freak 2-Feb-12 5:06am View

5up!

Tech Code Freak 2-Feb-12 0:56am View

Now I have edited it. Check my solution(Solution 1) again.

Tech Code Freak 1-Feb-12 8:07am View

Yes, I was wrong.
This link is very helpful!
Thanks!
Now I have got the solution viewing the link in Amir's Answer. That was exactly what I wanted.
Thanks to you too for this link!

And now I will delete all the wrong things and statements said by me in the question as well as comments for others.

Tech Code Freak 1-Feb-12 8:01am View

Thanks a lot!
This is exactly what I wanted!

Viewing the link provided by You and that in Rajeev's comment, I have got my Question Solved!

Tech Code Freak 1-Feb-12 7:58am View

Okay, after reading through the link provided in your comment below, I have got some answer!
Thanks again for that!

Tech Code Freak 1-Feb-12 6:51am View

5up for the conversation!

Tech Code Freak 1-Feb-12 6:40am View

Okay!
Now I have come to know that if I want to get the number of rows affected by a stored procedure in the front end, I have to compulsorily SET NOCOUNT OFF.
And that I can't get any idea of the affected rows if I SET NOCOUNT ON. As I have tried to RETURN @@ROWCOUNT after setting NOCOUNT ON; still nothing is returned. So, the Solution is that if you want to know the number of rows affected by a stored procedure in the Front end, you have to SET NOCOUNT OFF.

Thanks!

Tech Code Freak 1-Feb-12 6:13am View

Okay, I have already read that article.
I just want to know how to use it in the front end. i.e. How will the front end come to know the number of rows affected by the stored procedure with NOCOUNT ON using @@ROWCOUNT?

Tech Code Freak 1-Feb-12 5:45am View

Why aren't you trying my solution?
If you have tried it, then give me some reply!

Tech Code Freak 1-Feb-12 3:41am View

Good Solution! 5up!

Tech Code Freak 1-Feb-12 3:39am View

5up!

Tech Code Freak 1-Feb-12 3:35am View

5up!!

Tech Code Freak 1-Feb-12 3:29am View

5up!

Tech Code Freak 1-Feb-12 3:29am View

5up!

Tech Code Freak 1-Feb-12 3:28am View

5up!

Tech Code Freak 1-Feb-12 2:58am View

And maximum, how long can your string be?

Tech Code Freak 1-Feb-12 2:55am View

5up!

Tech Code Freak 1-Feb-12 2:30am View

Correct. 5up!

Tech Code Freak 1-Feb-12 2:26am View

Why? Genuinely I don't know the reason. Plz explain. By the way, 5up for bringing that to my notice!

Tech Code Freak 1-Feb-12 2:23am View

5up!

Tech Code Freak 31-Jan-12 0:53am View

5up!

Tech Code Freak 31-Jan-12 0:51am View

5up!

Tech Code Freak 31-Jan-12 0:51am View

A 5!

Tech Code Freak 31-Jan-12 0:30am View

5up!

Tech Code Freak 27-Jan-12 1:11am View

Nicely explained! 5up

Tech Code Freak 27-Jan-12 1:10am View

5!

Tech Code Freak 27-Jan-12 1:10am View

5!

Tech Code Freak 25-Jan-12 2:32am View

5'ed!

Tech Code Freak 25-Jan-12 2:32am View

5up!

Tech Code Freak 25-Jan-12 2:30am View

5up!

Tech Code Freak 25-Jan-12 2:30am View

5!

Tech Code Freak 24-Jan-12 1:02am View

Question not clear.

Tech Code Freak 24-Jan-12 0:56am View

5up!

Tech Code Freak 24-Jan-12 0:55am View

5up!
Good links!

Tech Code Freak 23-Jan-12 3:19am View

5up!

Tech Code Freak 23-Jan-12 3:13am View

my 5

Tech Code Freak 23-Jan-12 3:05am View

Good links! 5up!

Tech Code Freak 23-Jan-12 3:02am View

5up!
Great sharing the solution!

Tech Code Freak 23-Jan-12 2:59am View

Correctly spotted! 5up!

Tech Code Freak 23-Jan-12 2:55am View

Good question! 5up!

Tech Code Freak 23-Jan-12 2:55am View

Good link! 5up!

Tech Code Freak 20-Jan-12 6:48am View

5up for the class!

Tech Code Freak 20-Jan-12 6:46am View

5up!
Very Correct!

Tech Code Freak 20-Jan-12 6:44am View

5up! Correct!

Tech Code Freak 20-Jan-12 6:39am View

Edited question to remove ----> xmlns="#unknown"

Comments by Tech Code Freak (Top 200 by date)