|
hi,
i am having a problem in a SQLquery.
actually i am developing a project in asp.net with C# i. e. "MESSAGE BOARD". in this all the topics are displayed in gridview. but here sorting should be as per the last modified topic as well as if any user has replied more than 10 posts , then these messages should be displayed first.
i mean sticky posts should have highest priority to display first in the gridview as well as last modified topic.
the two tables from which i am accessing datas are:
Table1: "create_topic" :
Table Fields : Description
topic_id# : Topic id
group_id# : Group id
cat_id# : subgroup id/category id
username# : user name
topic_title : title of topic
topic_msg : original message
topic_create_date : date when topic is created
no_of_views : total no. of views
no_of_reply : total no. of replies to this topic
Is_sticky : If more than 10 posts by a single user then it is set to Y else N
Is_closed : ban the reply if satisfied.
Table 2: "reply_topic" :
group_id# : group id
cat_id# : category id
reply_id # :reply id
topic_id # :topic id
Username # :username
reply_msg : reply
rply_date : date when reply
can anyone tell me the query which can fulfill the purpose.
I have tried the query but not successfull:
SELECT a.topic_id, a.group_id, a.cat_id, a.username, a.topic_title, a.topic_msg, a.topic_create_date, a.no_of_views, a.no_of_reply, a.is_sticky,
a.is_closed
FROM create_topic AS a INNER JOIN
reply_topic AS b ON a.group_id = b.group_id AND a.cat_id = b.cat_id AND a.topic_create_date = b.rply_date
ORDER BY b.rply_date, a.topic_create_date
UNION
SELECT topic_id, group_id, cat_id, username, topic_title, topic_msg, topic_create_date, no_of_views, no_of_reply, is_sticky, is_closed
FROM create_topic
ORDER BY is_sticky==Y
what is wrong in it or how can i solve the problem.
also uniqueness should be maintained.
please help me.
|
|
|
|
|
I've not tried it, but something like this should do it:
SELECT a.topic_id, a.group_id, a.cat_id, a.username, a.topic_title, a.topic_msg, a.topic_create_date, a.no_of_views, a.no_of_reply, a.is_sticky,
a.is_closed, case when a.is_sticky = 'Y' then getdate() else coalesce(b.rply_date,a.topic_create_date) end as SortDate
FROM create_topic AS a Outer JOIN
reply_topic AS b ON a.group_id = b.group_id AND a.cat_id = b.cat_id AND a.topic_create_date = b.rply_date
Order by SortDate desc
The idea is, when the topis is sticky then use getdate, else use the reply date (if there is one, else topic create date) and order by sort date desc.
This should give you all the topics , sticky first followed by the most recent replies/postings
As I said, I have not tested it, but it should be somewhere on the lines you need.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Thanks for your reply.As per you said i have tried the query:
"SELECT a.topic_id, a.group_id, a.cat_id, a.username, a.topic_title, a.topic_msg, a.topic_create_date, a.no_of_views, a.no_of_reply, a.is_sticky, a.is_closed,
CASE WHEN a.is_sticky = 'Y' THEN getdate() ELSE COALESCE (b.rply_date, a.topic_create_date) END AS SortDate
FROM create_topic AS a FULL OUTER JOIN
reply_topic AS b ON a.group_id = b.group_id AND a.cat_id = b.cat_id AND a.topic_create_date = b.rply_date
WHERE (a.cat_id = @cat_id)
ORDER BY SortDate DESC"
Although the query is resulting the sticky post to be displayed first and rest others to be displayed next.Only as per the date of creating post sorting is maintained ,but when any body replied then this does not reflect the order. Also when there are more than one sticky posts then as per the last modified (either made post or replied ) sorting should be maintained and even same should be applied for the non sticky posts. This is not actually happening.
What changes should i make ,so that it may give the result what actually i want.
Please help me.
|
|
|
|
|
Just change the case statement to set the SortDate to whatever you like, i.e. last modified or whatever. I have given you the basics, its up to you to do any tweaks.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hello friends.
I want to show the same grid view in another page from first page.
I use the following code in text box case. it work properly. but for grid view what will I change in following code.
In first page:
I take text box and button.
on button click I write
Server.Transfer("page2.aspx");
<u>In Secong page:</u>
On page_load event
{
if(Page.PreviousPage != null)
{
TextBox txt =(TextBox) Page.PreviousPage.FindControl("txtFirstPage");
if(txt != null)
{
Response.Write("<font color='teal' > " + txt.Text + "</font>");}
}
thanx
|
|
|
|
|
You should really avoid the use of Server.Transfor for such simple scenarios like this. ASP.NET allows you to cross-post from one page to another. Just set the PostbackURL property on the button to page2.aspx, and access the value for txtFirstPage directly from the form: Request.Form["txtFirstPage"]
|
|
|
|
|
can any one guide me how can i do it i have added a dll reference in toolbox and now i want to remove it complete from my visual studio.
any suggesion would be appriciated..
umerumerumer
|
|
|
|
|
mr_muskurahat wrote: i want to remove it complete from my visual studio.
Right Click on toolbox and Click Reset Tool Box
Or
Right Click on Toolbox > Choose ToolBox Item > Unchecked the components that you have add > Ok
BTW : Does it any thing related with ASP.Net 
|
|
|
|
|
i want to merge two pdf files... the thing is that the content of tha file should not be lost ... i just want to append the data in file..
|
|
|
|
|
Hi,
there are a lot of tools out there that can merge pdfs. For example PDF Split and Merge (http://www.pdfsam.org/[^]). This app can be controled by console. So all you have to do is to start a process within your app using this tool by console.
Does this help you?
Regards
Sebastian
|
|
|
|
|
|
You need to learn how to put your code in the proper tags.
"Well, we're getting "F"'d at work. WPF, WCF, and WWF... WTF?" --John Simmons
|
|
|
|
|
Hello,
I am trying to implement the code provided at this link:
http://www.danielsoper.com/programming/DataGridViewDragDropRowsColumns.aspx
I have populated the datagrid from oracle table; but it is returning error when i close/end the application. "No symbols are loaded for any call stack frame. The source code cannot be displayed" and then another message box appears which title is "LoaderLock was detected".
Please try at your end and let me know to correct the error.
Regards
Girish
|
|
|
|
|
Have you tried running in debug? Have you tried asking the code author? Those should be your first steps.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi to all,
I have a datagrid and a checkbox in it.In my datagrid I have a template column of "QTY" which is having a textbox.
Suppose user selects an item then it will be displayed in the datagrid.
But if user wants to change the quantity then he has to check the the checkbox and click the update button below datagrid.
for this I did:
<br />
<asp:DataGrid ID="DataGrid2" runat="server" CellPadding="4" ForeColor="#333333" <br />
GridLines="Horizontal" EnableViewState="False" Font-Bold="True" <br />
Font-Names="Verdana" Font-Size="Small" AutoGenerateColumns="False" ><br />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /><br />
<EditItemStyle BackColor="#999999" /><br />
<SelectedItemStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /><br />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /><br />
<AlternatingItemStyle BackColor="White" ForeColor="#284775" /><br />
<ItemStyle BackColor="#F7F6F3" ForeColor="#333333" /><br />
<Columns><br />
<asp:TemplateColumn HeaderText="Select" HeaderStyle-Width="50px"><br />
<ItemTemplate><br />
<asp:CheckBox ID="chkSelection" runat="server" ToolTip='<%# Eval("QTY") %>' /><br />
</ItemTemplate><br />
<HeaderStyle Width="50px"></HeaderStyle><br />
</asp:TemplateColumn><br />
<asp:BoundColumn DataField="REF" HeaderStyle-Width="70px" HeaderText="REF"></asp:BoundColumn><br />
<asp:TemplateColumn HeaderText="product_id" Visible="False"><br />
<ItemTemplate><br />
<asp:Label ID="lblProduct_Id" runat="server" Text='<%# Eval("REF") %>'></asp:Label><br />
</ItemTemplate><br />
</asp:TemplateColumn><br />
<asp:BoundColumn DataField="Description" HeaderStyle-Width="330px" HeaderText="Description"></asp:BoundColumn><br />
<asp:TemplateColumn HeaderText="QTY" HeaderStyle-Width="30px"><br />
<ItemTemplate><br />
<asp:TextBox ID="TxtQTY" runat="server" Width="30px" Text='<%# Eval("QTY") %>' /><br />
</ItemTemplate> <br />
</asp:TemplateColumn><br />
<asp:BoundColumn DataField="Price" HeaderStyle-Width="50px" HeaderText="Price"></asp:BoundColumn><br />
<asp:BoundColumn DataField="Cost" HeaderStyle-Width="70px" HeaderText="Cost"></asp:BoundColumn><br />
</Columns><br />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /><br />
</asp:DataGrid><br />
protected void BtnUpdate_Click(object sender, EventArgs e)
{
CheckBox chkSelected = new CheckBox();
foreach (DataGridItem dgItem in DataGrid2.Items)
{
chkSelected = (CheckBox)dgItem.FindControl("chkSelection");
if (chkSelected.Checked == true)
{
qty3 = Convert.ToInt32(chkSelected.ToolTip);
}
}
}
But the problem is that in the code behind file datagrid2.Items has the count=0.So the foreach loop is not working.
Please guide me that where I am making mistake.
Thanks in advance!
cheers,
sneha
|
|
|
|
|
I'd suggest that you need to look at where your databinding occurs and if viewstate is turned on. If you databind in your page load every time, that runs first and causes viewstate to be lost.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
your foreach statement should be put in the GridView OnRowDataBound-method.
In the btnUpdate_click you should determine in whicht line the click was made. With that information you could do an sqlquery and then bind that data to the gridview. The OnRowDataBound -method is then fired after each placed row in the griview.
|
|
|
|
|
I have one report which consist subreport also. now i just want to display subreport of that report... so if any 1 of u knw pls reply me..
|
|
|
|
|
I'm currently looking into using the MVP pattern for creating web applications and have some questions:
- If state needs to be recorded I presume its done in the model, if the model classes are in an assembly separate from the actual pages do you still use session or some other form of state management?
- How is UI logic such as "disable this button unless condition is met" handled? is the logic embedded in the view ( or the page code behind), presenter or model.
Can any body can provide some detail/thoughts in relation to these areas?
|
|
|
|
|
Lowest of the Low wrote: MVP pattern for creating web applications
IMO, MVP is most suitable for stand-alone applications and MVC is more suitable for web applications.
Lowest of the Low wrote: If state needs to be recorded I presume its done in the model, if the model classes are in an assembly separate from the actual pages do you still use session or some other form of state management?
If the model is in separate assembly and to use session, you need a reference to System.Web assembly and hence making it strongly coupled. To avoid this, you can wrap the state management in well defined interfaces and inject to the model using dependency injection. So that your model will be isolated.
Lowest of the Low wrote: How is UI logic such as "disable this button unless condition is met" handled? is the logic embedded in the view ( or the page code behind), presenter or model.
Passive View approach will be obvious for this.
Here are few links which will help
1 - Passive view - A .NET approach[^]
2 - MVP in ASP.NET[^]
Hope this helps 
|
|
|
|
|
Thanks for the response.
MVC is not currently an option for us (new technology...risk...etc, etc) but changing our existing webforms development to use MVP is something that could be done.
I looked at Phil Haack's ASP.NET Supervising Controller (Model View Presenter) From Schematic To Unit Tests to Code[^] which looks good.
I still have other questions like where is validation done? And in relation to your comment on injecting state via interface I'm being a bit thick today but how? Surely if I use session I'd still need a reference to System.Web? or are you suggesting that I could provide access to session through another object?
|
|
|
|
|
Lowest of the Low wrote: MVC is not currently an option for us (new technology...risk...etc, etc)
Well, I was not talking about the ASP.NET MVC framework. I was talking about the MVC concept.
Lowest of the Low wrote: I still have other questions like where is validation done?
For trivial validations, view is the appropriate place. But if you have very complex business validations, you probably need put it outside of the view.
Lowest of the Low wrote: And in relation to your comment on injecting state via interface I'm being a bit thick today but how?
You define an interface with the necessary properties and methods. Implement this interface in the same project where you have access to session. Then inject this interface instance to model(or whatever area). Read about dependency injection[^].
|
|
|
|
|
Query for you on the Dependency injection, does that not violate the OOP "Dependency Inversion Principle"?
|
|
|
|
|
The general goal behind MVP is to isolate as much logic from the "view" as possible, just like with MVC. The benefits of MVP over MVC are primarily realized when a complete rewrite of an existing WebForms app into an MVC framework can't be done (which sounds like your situation).
I've implemented MVP a couple times for existing ASP.NET WebForms sites, and its been quite successful. In terms of managing state, etc. There are a lot of different kinds of state, and it depends on what state your talking about. ASP.NET WebForms state should probably be keept in the same locations it would have been keept before for basic stuff. If you had a ViewState property on a Page that held a CustomerID, for example, you should probably keep it in the Page ViewState.
As for logic...put as much as humanly possible in the Presenter. The presenter is like the controller from MVC, and one of the main reasons for having it is to allow you to maintain SoC, separation of concerns. A view is just a representation of data, and it really shouldn't contain logic. In the case of WebForms, it will probably need to contain a little bit to handler data set on it by the presenter and render it, but keep it minimal. The presenter should handle all the logic of processing your page, it should contain event handlers to handle events on the view (including events inherited from Page and Control), it should validate input, and decide when to enable/disable controls.
The view should be a standard WebForms .aspx page with codebehind. However, in addition, you will need to create and implement an interface that represents your view. This interface is the access point for the presenter. The proper form of either Passive View or Supervising Controller MVP is that the presenter does not maintain any direct references to the view, only to an interface that represents the view. This allows the presenter to be used for multiple similar views. The view itself should handle the process of creating the presenter, and passing itself to the presenter (thats how the presenter gets a reference to the views interface). This view interface should contain all properties and events on the view, as well as exposing common stuff from the Page class as well, such as the standard page events (OnInit, OnLoad, OnPreRender, etc.)
If you need any more help, I'd be glad to offer it. I have a small MVP framework that I've written that is very lightweight and easy to integrate into existing apps a view at a time, with little configuration. I have considered writing an article about it for a while, maybe the time is right. Most people don't fully realize the benefit of MVP for ASP.NET when you don't have the option of rewriting the whole site as an MVC app (using any MVC framework). MVP is a great way to improve SoC and increase unit testability without requiring a massive rewrite of an existing application.
|
|
|
|
|
You've hit my situation on the head, said I was being a bit thick earlier today couldn't even explain the situation I'm in very well.
In work we have moved to an agile way of working involving a lot of TDD and that is one of the main drivers for looking to try and move to a MVP style of development.
The state issue is a concern because we do use session for storing some info and currently we have to reference System.Web in our existing equivilant of the model and this is one of the main issues I need to try and overcome before being able to implement MVP.
Any thoughts you've got would be appreciated.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
