I have a BlogPost table by which i post blog on my website, this is the structure of BlogPost Table:
BlogPostID int Unchecked
LanguageID int Unchecked
BlogPostTitle nvarchar(200) Unchecked
BlogPostBody nvarchar(MAX) Unchecked
BlogPostAllowComments bit Unchecked
CreatedByID int Unchecked
CreatedOn datetime Unchecked
[code]...
I have a BlogPost table by which i post blog on my website, this is the structure of BlogPost Table:
BlogPostID int Unchecked
LanguageID int Unchecked
BlogPostTitle nvarchar(200) Unchecked
BlogPostBody nvarchar(MAX) Unchecked
BlogPostAllowComments bit Unchecked
CreatedByID int Unchecked
CreatedOn datetime Unchecked
[code]...
i have used this command in my gridview to display all the comments since last 2 days:
"SELECT BlogComment.CommentText FROM BlogComment INNER JOIN BlogPost ON BlogComment.BlogPostID = BlogPost.BlogPostID WHERE (BlogComment.CreatedOn >= DATEADD(dd, - 2, GETDATE()))"
I want to display guest comments on web page so here is my asp source page :
<form id="form1" runat="server">
<div>
<asp:TextBox ID="name" runat="server"></asp:TextBox>
<br />
<br />
<asp:TextBox ID="tb1" runat="server" Width="331px" Height="151px"></asp:TextBox>
[Code] ....
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 have a following requirement:
1. Create a blog with content and images.
2. Category for blogs
3. Comments on each blog
4. Monthly Archives, Recent Blogs and Recent comments.
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?
View 6 RepliesI 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
-blog (table)
-blogID, postContents (fields)
-blogComments (table)
-blogcommentID, blogID, comments (fields)
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'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
View 2 Replieshow can i make a simple user comments form using xml. comments entered by the user should be saved in xml.
format of the form:
name: email:comments:
i'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);
I have a website where people can send an email to a group of people and then choose to have that letter posted on our website.
The problem has now become that I get so many of them, I can't keep up with doing it manually. What I'd like to do is have it go to a database and then have it automatically update the site. So, one page will have "teasers" with the Author's name, etc and a few lines of the letter and then it links to another page that has the entire letter.
Can anyone tell me if:
a) that's possible
b) how to implement it
Doing it manually has gotten out of control!
How user post comment on my website using gmail ,fb,yahoo ,hotmail account ...
how to apply this.. [URL] ....
I have a Listview showing all articles. And i'd like to show the number of comments that... that article has.
Shall i call a method inside the listing ?
Then on my code behind i started implementing the following code:
[Code]....
Where on my listview shall i call this function ? SHould i return an int ?
I have developed a news blog . I would like to add a Comment section with spam prevention capabilities into my news.My Comment table is as followsComment - CommentID,Name,DateStamp,Comments and NewsItemID as a foreign keyI'm having problem in identifying a logic . I have some questions to ask1) I'm thinking to use Formview to create a comment section?..Is it okey?2) I'm thinking to capture the NewsItemID from querystring and trying to fill up the NewsItemID(foreign key) into comment table?..Can you please show me in coding, How can I do that in coding?...if it is not a good logic,,then advise me how to do this?.3) Getting the comment from formview to db is okey, but how can I show the user comments as soon as he clicked the submit button of the formview ?..It seems quite difficult for me to do handle two events when user click the submit button 1) sending the comment into db ,2) shows the users comment in webpageHow can I do that?..Can you please provide some coding show me how can i achieve my task?
View 4 Replieshow would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
I want to create a page on which the website's sponsors are displayed. The information about the sponsors is coming from the database via an ObjectDataSource, and I'm retrieving an Image (company logo), the name of the company, and a url to the company's website. Each Image (logo) is of the same height, but of varying width. I want each Item to be formatted so that the Image is on top, and underneath is a centered hyperlink with the name of the company.
This all seems pretty straightforward ... now for my problem: I want to display as many of these on the page as possible. Essentially, start off horizontally and fit as many as possible on each row. A DataList or Repeater with RepeatDirection=Horizontal doesn't quite do what I want as I don't want to have a fixed number of columns.
Is there an easy way to achieve this, or do I have to manually add up the width of each item on an ItemDataBound event, and then somehow move to the next row when the maximum width is reached? In addition I have to deal with the fact that the width of my Item is the maximum of the Image width and the text underneath.
I have a ListView InsertItemTemplate where there is field (Date) using the AJAX Library CalendarExtender. I want to add some validation to this field, whereby they can't add a date that is later than today. So I have added a RangeValidator and tried to set its MaximumValue to DateTime.Now on Page Load. Unfortuantely it isn't working.
View 5 RepliesI have a gridview, in which i placed checkbox as Itemtemplate. My need is to restrict the user from selecting more than 'N' number of selections.
Eg: Gridview contains 50 records, that means 50 check boxes.
Max permitted selections: 10.
After the 10th checkbox selection, user should be prompted that..
"No more selections.. blah blah... "
Should i go for looping through records.. or is there any better way..
i need to cut the text from a box to a shorter version. what i'm using right now is :
CAST(DescriereNoutate AS nchar(200)) AS Descriere from the SqlDataSource, but im having problems because this cuts the words.
how can i do this without leaving the words cut in half.
Let's say there are rows in DB. I have to display each row in a panel along with comments linkbutton for each row (data). Onclick of a partcular Comments linkbutton, a modalpopupextendar should show wherein I can enter comments to that particular data. How this can be achieved in ASP.NET C#
View 1 RepliesI 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.
View 1 RepliesI 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)?
View 2 RepliesThere is a Gridview in my web page in which data is coming from below Table 1:
Id. Name Value
1 aa 30
2 bb 80
3 cc 60
HTML:
<head id="Head1" runat="server">
<title></title>
<script type="text/javascript">
function RadioCheck(rb) {
var gv = document.getElementById("<%=GridView1.ClientID%>");
var rbs = gv.getElementsByTagName("input");
var row = rb.parentNode.parentNode;
[CODE]..
How to set the Gridview RadioButton ByDefault selected for a particular row whose "Value" (from above Table 1) is highest.
how i can perform Update Row in Gridview using Template Feild's
[Code]....
[Code]....
what will be next step as i know how to write update statement in databasejust want to know how i can catch the template feilds value and update on click of edit
[Code]....
I started a C# web project in Visual Web Developer. I dropped a grid view in with designer and connected to my remote SQL database with the designer dialog based wizard. All is well there. I have in my program also a textbox where a user enters a zip code and clicks a button 'search'. When the user clicks search I want to run the SQL command "select * from flat_list where zipcode='userszipcode'". In other words the userszipcode is dynamic and different every time. It is my understanding I should use a SQLDataSource object but I do not know how.
View 1 Replies