|
Hi,
SELECT Comment.CommentID, Comment.DictationId, Comment.UserId,
Comment.CommentDate, Comment.Comment,
UserData.FirstName + ' ' + UserData.LastName AS 'UserName'
FROM Comment INNER JOIN
AuthRoleMember ON Comment.UserId = AuthRoleMember.UserID INNER JOIN
UserData ON Comment.UserId = UserData.UserID
WHERE (AuthRoleMember.RoleID IN (4, 3, 2)) AND (Comment.DictationId = 9)
This is the main query returning username. I am now using cache instead of using above query directly.
I am using 3 tables..Comment,UserData,AuthRoleMember
I am using 3 different cache for the above 3 tables.
I want to return username .
I am filtering the record from using userid,also last condition where comment.dictationid=9 where i am passing the value that is fine no problem with that..
But How can I compare or use IN query i.e. AuthRoleMember.RoleID IN(4,3,2)
Thanks
sjs
|
|
|
|
|
sjs4u wrote: I am now using cache instead of using above query directly.
Are you caching whole data from the 3 tables? What data structure are you using for cache?
|
|
|
|
|
Hi!
I have 2 Gridviews on an aspx page. These gridviews are populated by using a Object DataSource. How can I display information in Gridview 2 based on what the user clicked in Gridview 1?
Thank you!
Illegal Operation
|
|
|
|
|
So, you want to show the selected row of GridView 1 to GridView 2 ? If yes, On Selected Indexed change of Gridview1, Hold the selected row in GridViewRow Class and set the data source property to GridView 2.
One question, why do you want to show it on second Gridview ? Why not any other control ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
The First Thing you need to ask yourself is what is it that is unique in the row of the First Gridview. After you Find that, then you make sure that on SelectedIndexChanged Event you take the Value that is Unique to that Row and Bind the Second Grid based on that Value and you will get what you want.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
I found that in ASP.net databind and SQL database, I have met often the problem:
when the file contains some special signs such as C++,and C#, then it can not be found by databound control or wrongly
displayed.
anyone can give me one hint how to deal with this?
thanks!
|
|
|
|
|
Is it so....
I never checked this but if you are talking about data containing C++ and C# will error out, I dont think this would be a problem. Because basically every control is rendered in browser as html. And you can place any text inside InnerHTML.
|
|
|
|
|
You need to post some code and examples of how it displays wrong, because what you're saying, makes no sense.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Background:
I'm running an MVC app on Windows Server 2003 using Integrated Authentication. I have a page that is running into authentication problems only when it performs a large number of inserts. After a certain amount of time (~ 1-2 minutes) users are asked to enter their network username, password, and domain. This logon request appears three times, then an error page is displayed with a 401.1 error. The exact error message in the log is: 401 1 2148074248.
The user is not asked for their network password anywhere else in the application and not consistently on this page…only if processed a large inventory which means a lot of inserts. I have added “executionTimeout="3000"” in the the web.config file to prevent a previous error of “HttpException (0x80004005): Request timed out.”.
Sequence of Events observed with Fiddler
a)Press submit button at 10:07
b) 401 /InventoryImport/SaveDepartments
c) 401 /InventoryImport/SaveDepartments
d) 401 /InventoryImport/SaveDepartments
e) 10:08 Logon request
f) 401 /InventoryImport/SaveDepartments
g) 401 /InventoryImport/SaveDepartments
h) 10:09 Logon request
i) 401 /InventoryImport/SaveDepartments
j) 401 /InventoryImport/SaveDepartments
k) 10:10 Logon request
l) 401 /InventoryImport/SaveDepartments
m) 401.1 You are not authorized to view this page
n) It appears that I have lost my connection because if I change the url to
another valid url, I continue to receive 401 errors
Sample entry in log file:
2009-09-17 17:51:19 W3SVC1746257461 198.186.126.241 POST /InventoryImport/SaveDepartments - 80 - 192.168.200.90 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+3.0.04506.648;+InfoPath.2;+.NET+CLR+3.5.21022;+.NET+CLR+3.0.4506.2152;+.NET+CLR+3.5.30729) 401 1 2148074248
Httperr.log
No consistent error message.
Event viewer:
No errors.
SQL Server logs:
No errors.
IIS settings:
IIS is set to recycle worker process at 2:00am. Session is set to 20 minutes. Web app settings are: Connection timeout 120 sec, Enable HTTP Keep_Alives checked.
Web.config:
In my web.config I have set executionTimeout="3000".
I asked my admin to have the Web Site Connection Timeout and the App Pool Shutdown Timeout bumped up (per instructions below), however, he said that did not work.
Info from: http://www.arichards.com.au/iis62
o Always set the Web Site Connection Timeout to at least 120 seconds (2 minutes)
o Enable the Web Site Keep Alive setting
o Always set the Web Site ASP Scripting Timeout to a value that is ~30 seconds less than the Connection Timeout
Note: currently set to 3000 in web.config
o Always set the Application Pool Shutdown Timeout to a value that is ~30 seconds more than the Connection Timeout
o Always set the Application Pool Recycle Physical RAM Limit to at least 64Mb (the default is 192Mb)
FYI: the simplest Classic ASP page that you can think of uses ~4Mb when a single request is being processed
o Always set the Application Pool Recycle Virtual RAM Limit to at least 128Mb (the default is 500Mb)
FYI: the simplest Classic ASP page that you can think of uses ~67Mb when a single request is being processed
Any idea what is causing the 401 error? Thx.
|
|
|
|
|
|
Thank you for your response, however, I am not getting a 404 error, I am getting a 401 error. Also, I can access the page and do not have a problem unless I am inserting a large amount of rows. Any other ideas? Thx.
|
|
|
|
|
If my admin runs locally (on webserver) with admin login then he does not receive the 401 error.
|
|
|
|
|
|
First, read this[^]. "Popup" is not a very good subject line now is it?
Malik1122 wrote: a function in javascript and i'm calling it at server side
I think you are very confused. You cannot call a JavaScript function on the server.
A very cursory search will provide you numerous options, try it[^]
only two letters away from being an asset
|
|
|
|
|
But what is the problem in this. I think it would work fine.. Just opening a new widow when postback occurs.
Please let me know what exactly problem you are facing, so that I can check. 
|
|
|
|
|
Abhishek Sur wrote: But what is the problem in this.
 Seriously? 
It's a horrible waste, why cause a postback just display a popup?
only two letters away from being an asset
|
|
|
|
|
Yeah...
Some people do funny code. This might be one instance... Mark...
If I was in his place, I would obviously remove the unnecessary postback.. if I dont have to go through any logic before running the javascript.. 
And also.. Its really frustrating when the original post is deleted. 
|
|
|
|
|
Abhishek Sur wrote: If I was in his place, I would obviously remove the unnecessary postback
Why the hell did you say you didn't see a problem with it then?
only two letters away from being an asset
|
|
|
|
|
Actually I meant the code will run without errors ...
I agree... Its my bad.. not pointing him about the mistake... 
|
|
|
|
|
Hi,
In my case, i need to prompt user to restart system after rollback in dot net web setup project.
I am able to prompt user to restart system after install and uninstall, but no clue how to do it after rollback.
Please help me in this.
Pradeep Reddy
|
|
|
|
|
Make a master setup which will call your setup so that you can handle this easily.
|
|
|
|
|
Abhishek Sur wrote: Make a master setup which will call your setup so that you can handle this easily.
We have the hurlde at the first place itself.
You can not run more than two MSIs together. So, no point of calling one setup from another.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Have I ever mentioned calling MSI from another..
MSI and Setups are quite different..
Setups are invoked using Windows Installer.
The Best example is if you look into Any .NET installer. The Setup invokes at least 100 of msi within it.
|
|
|
|
|
|
Hi guys, im making a site which needs really really good security.
Normally I would just use sessions etc but Im presuming there are WAY more secure ways.
Could anyone give me some links which cover some nice topics relating to this?
Thanks
Strive to be humble enough to take advice, and confident enough to do something about it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)