I am working on a project. I need to allow user to comment on pictures - like a blog. For example, if you like a picture, you post your comment on the pictures and say why you like. When the user type a comment in the text box, how do I put it under the pictures? Also, if two people were to post comments, how do I know where the first comment ends and where to start posting the second comments? Also, how do I know when the page is full and start a new page?
I have a blog page that has 20 posts each page.I'm using Listview for displaying posts. If I want to display comments for each posts, what would be the best way? My database stracture is as follow
Since I have many comments for each posts, I don't think I can join table.Only thing I can think of is that I can use DataReader and loop through the results in Listview Databound events.What would be the best way to achieve this?
I am using Label to display comments so in Csharp coding to display Comments on web page where One Default Image should be display , Name , Date , Comments .
I'm in the process of creating a blog engine on my website. Nothing fancy. The user will register some basic information, including the comment itself that is the issue of this question.Inside the comment field, the user can write some text, but there are currently nothing stopping him from writing anything harmful there, that would mess up the page when rendering it with comments
I want to write a page where user's can write a blog post and publish it to the blog. I've downloaded blog engine .NET and looked at the code and I like the way they do it, but it's completely an overkill of what I need. What I need is only a title, author, date, and the blog post it self. I don't even want users to post comments or anything like that. My approach is to save all those blog post information into an xml and then when a page loads it loops around those xml files to show the blog post.
've got a slightly odd requirement that I'm not sure how to properly articulate.I essentially want to prioritise the most recent requests to an ASP.Net handler. I'm not sure if this should be client-side or server-side. I'm leaning towards server side to ensure it's enforced on all clients.So, as requests come in, they're essentially stacked according to some internally-defined time interval, per client. Then, the top of the stack (most recent) request is processed first.
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
I am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj; OdbcCommand cmdObj; OdbcDataAdapter daObj = new OdbcDataAdapter(); public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) { conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
I'm developing a Asp.Net website and I need to display the four most recent tweets from a group of users (around ten) that will be set in the admin area of the website. I know twitter has an API, but I don't know where to start.
In the stord procedure below. I am retreiving all the records for that 1 deal. What I want is to retrieve the most recent record hence the one with the most recent in the AddedDate field.
How can I accomplish this?
( @DealID int) AS SET NOCOUNT ON SELECT deals_Comments.CommentID, deals_Comments.AddedDate, deals_Comments.UserID, deals_Comments.AddedByEmail, deals_Comments.AddedByIP, deals_Comments.DealID, deals_Comments.Body, deals_Comments.SBody, ROW_NUMBER() OVER (ORDER BY deals_Comments.AddedDate DESC) AS RowNum FROM deals_Comments WHERE deals_Comments.DealID = @DealID
Last night I started working on an NHibernate provider. I'm creating a criteria that several records will match, however I only want to return the most recent record (the record with the largest Id). I thought UniqueResult() would do this it cannot be used if a list would be returned otherwise.
I could theoretically select the full list and then return the desired record, but I believe there is a better way.
I have a table which have different records in it, When user click on each record I save the primary key of the record to another table (recent viewed) with short date and time. It checks first if that record is already there so it just update the data and time but if record is not yet there then it will add it.
I want that the recent viewed table only store 15 records in it. Not more then 15 and most oldest added record should be overwrite. Is that possible in MS SQL server 2008?
how to display recent viewed product in gridview / listview,first one if any user click on any one product on listed all product then and redirect new page where user can view full details of single product ,its going fine but when user back to home then i want to show recent viewed product , recent view product should not save in db ,just save in temporary datatabee and view in gridview , if user see 10 product then it save in temporary datatable and bind into gridview all 10 product.
I want to do something similar to what priceline does. It saves the recent searches in a dropdown menu. When you pick one from the recent search. The form will be populated accordingly. (See screen shot [URL] This is what I am thinking. (1) Save the searches into an array in a cookie (2), when a recent search item is chosen, retrive the corresponding array element from the cookie and then populate the form. What do you think is the best way to implement this? I especially want to know how to save the form entries into the cookie and how to populate the form.
I have a dropdown list with sessions: Summer, fall, spring, summer Interim.
And also have a gridview to display hours of those sessions. When chose session from dropdown it displays the data related to gridview.
Gridview has the 'Edit' option to edit hours for each sessions:
[Code]....
When I edit let say spring and update the field it redirects me to main page but everytime it selects the data from summer).
What I want is? If choose Fall from dropdown and make edit(in editpage.aspx?id=..) and update the data, then it should redirect to main page but choose the Fall from the dropdown (Not summer)
I've recently started working in ASP.NET and RDBMS.I'm making a test form where I can do basic add,update,delete operations.I'm using OracleDataClient to do the DB operations.I was able to populate a listbox using OracleDataAdapter.
Now after clicking on update button,I intend to Update in DB.I've Dataadapter with it's update property.But the update query is not happening.The examples I saw over net all have Select command before Update.Is it actually like that or am I missing some point.
How does Oracle DataClient work with Insert,Update,Delete Commands.