|
A simple table in a database and an incrementing update statement will do nicely then.
|
|
|
|
|
|
hello,
I want code in asp.net using c# for web application searching in the database for articles.
for example: the sql server database contain columns for (Title, SubTitle, Author, Category, Date, Lead, Body, ImageURL,...) for the articles...
and I want to make web form which can search in this database with more option where user can search by Title, SubTitle, Author, Category, Date, and so on....
can I get help, pls...
I use linq technique
I made these files
Searhc.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Admin/Templates/Level_Two.master"
AutoEventWireup="true" CodeFile="Search.aspx.cs" Inherits="Admin_CMS_Article_Search" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
<style type="text/css">
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td height="15">
</td>
</tr>
<tr>
<td class="Searchby" height="50">
Search by Article Name:
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" class="style1">
<tr>
<td width="100">
</td>
<td>
<asp:TextBox ID="txtSearch" runat="server" Width="396px"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="30">
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" class="style1">
<tr>
<td width="250">
</td>
<td>
<asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<asp:GridView ID="grdResults" runat="server" AutoGenerateColumns="False" EnableModelValidation="True"
GridLines="None" ShowFooter="True" OnRowDataBound="grdResults_RowDataBound">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<ul class="Titlelist">
<li>
<asp:HyperLink ID="lnkTitle" runat="server">Title</asp:HyperLink>
</li>
</ul>
</td>
</tr>
<tr>
<td class="Leadtxt">
<asp:Literal ID="ltrlLead" runat="server"></asp:Literal>
</td>
</tr>
<tr>
<td>
<hr style="width: 90%; height: 2px;" />
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td align="center">
<asp:Label ID="lblResults" runat="server" CssClass="Leadtxt"></asp:Label>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</asp:Content>
Search.aspx.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Admin_CMS_Article_Search : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSearch_Click(object sender, EventArgs e)
{
thedb.islamonlineDataClassesDataContext db = new thedb.islamonlineDataClassesDataContext();
List<thedb.Article> articles = (from art in db.Articles where art.Title.Contains(txtSearch.Text.Trim()) select art).ToList();
grdResults.DataSource = articles;
grdResults.DataBind();
if (articles.Count == 0)
{
lblResults.Text = "Sorry, No Article Found for " + txtSearch.Text.Trim();
lblResults.Visible = true;
}
else
{
lblResults.Visible = false;
}
}
protected void grdResults_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink lnkTitle = (HyperLink)e.Row.Cells[0].FindControl("lnkTitle");
Literal ltrlLead = (Literal)e.Row.Cells[0].FindControl("ltrlLead");
lnkTitle.Text = DataBinder.Eval(e.Row.DataItem, "Title").ToString();
lnkTitle.NavigateUrl = "~/Admin/CMS/Article/Show.aspx?id=" + DataBinder.Eval(e.Row.DataItem, "id").ToString();
ltrlLead.Text = DataBinder.Eval(e.Row.DataItem, "Lead").ToString();
}
}
}
so, user can search by Title only... now I want to give user search option by title, date, author, subtitle, body contain...
modified on Saturday, January 1, 2011 9:41 AM
|
|
|
|
|
Please Use "pre" tag to wrapped your code to make it readability.
|
|
|
|
|
thanks RaviRanjankr..
I did it..
|
|
|
|
|
hassanmorsy wrote: I want code in asp.net using c#
It is extremely ride to start demanding code to solve your problem. I doubt you get many responses.
Format your code snippets. Again, you will get few responses if no one can read your question.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
thanks Mark, I finished formating the code.. now it appear more readable...
|
|
|
|
|
it's not possible to write whole code for you but you can focus on given ideas
I suggest you to customize your code by adding functionality to user to select their option as you mention title,date,author,subtitle,body. for this goal you can use various control Checkbox,Combobox or even Radiobutton with assigning corresponding value.
when use select any one option then Value should fire and passed it into parameter where you are using "Title" [Right now].
Please navigate the given link to know more Link[^]
modified on Tuesday, January 4, 2011 11:55 AM
|
|
|
|
|
Can't you use Full text search capability of SQLServer? Check Blog post at this[^] URL for possible solution
|
|
|
|
|
in my page , Showing a gridview which has four coloums all four coloums have combobox. At begining of page defaultly showing single row And if want more than one row clicka a button for adding new row ... for these scnario , what are the asp components used ... And How can acheive these ..
.
Thans
|
|
|
|
|
Use templated columns in teh grid to display the comboboxes. When adding a row add an emprty, or default, row to the datasource bound to the grid and rebind it.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
You will find lots of solution around the .net if you try to find it.
Here's my search work for you. change Your program accordingly.
First[^]
Second[^]
Third[^].
|
|
|
|
|
In my asp .net web application,I have to use all languages.How it will be done..Help me..
|
|
|
|
|
|
|
Hi to all,
I'm having a problem that I hope someone can help me with.
I'm trying to export data from an asp.net page to an Excel file and I'm basically just outputting HTML to the XLS file and let Excel interprets it, by using this type of coding:
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252");
HttpContext.Current.Response.AddHeader("content-disposition", String.Format("attachment; filename={0}", "\"File.xls\""));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
gridview.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
}
However, although this is doing fine for exporting raw text, I now have to export to the same Excel file an image. However, the same kind of method I'm using right now only seems to insert a "linked" image, I mean, the image appears in the file, however, the user viewing the file has to be online since it's a direct link to the file in the server. I would like to able to "embeded" the image in the file, just like how it's made when you insert manually an image using Excel.
However, after some online research I can't seem to find any solution for this. Can anybody help me out here and point me to what a possible solution would be?
I can't use Microsoft.Office.Interop.Excel library, and a third party software isn't advisable also, that's what made me try out the HTML output solution, which worked ok for the text. But now, for inserting an image, what can I do? Is it possible to achieve what I pretend?
Thanks in advance.
|
|
|
|
|
hello
I work on a intranet site of management review, to insert the markes I have files for each module I want only the professor of module has the right
access to his file.How ?
Thanks
|
|
|
|
|
Can you elaborate your requirement? Then It will better to answer your question.
Parwej Ahamad
ahamad.parwej@gmail.com
|
|
|
|
|
Hi ;
1-files visible to the people of Registration Service
2-files for teachers:
semester 1
file visible to teachers of Module 1
file visible to teachers of Module2
file visible to teachers of Module 3
semester 2
file visible to teachers of Module 4
file visible to teachers of modules 5
file visible to teachers of Module 6
3- the other file are visible to all users
Thanks
|
|
|
|
|
You can use Roles. Have a look at this[^].
|
|
|
|
|
i have a requirement same like our codeproject Forum.(Gridview)
Plz suggest some idea in c#.
Thanks in advance
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
|
|
|
public static void Main(object args[])
{
switch(args[0])
{
case 1:
Console.WriteLine("Ask a specific question about what you don't understand");
break;
case 2:
Console.WriteLine("Hire someone");
break;
default:
Console.WriteLine("Google");
break
}
}
OK, here is some ideas in C#
I know the language. I've read a book. - _Madmatt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
