|
check this out:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
|
|
|
|
|
Actually , i am making a car website like cars.com, and i have seen in cars.com they allow search on keywords, I too want to implement that feature but how can i, bcoz i have normalized the features of car into 5-6 tables and i want to search it in that 5-6 tables.
|
|
|
|
|
Better option would be to keep an index table. This index table should be updated by taking all values that need to be searched. Index table should be filled when new records are added to the original table. Now you can easily do searching in this index table.
|
|
|
|
|
Means , i have to create another table which store all the features say 50
in a column seperated by (comma) .
|
|
|
|
|
Yes. That will be an easy solution. This table should contain a key to which you can use to retrieve the real information from respective table.
|
|
|
|
|
I think the index table would be the better idea and easier to implement.
Check this out if you want to find out more:
http://www.the-art-of-web.com/sql/lookup/
|
|
|
|
|
|
|
|
|
sorrrrryyyyyyyyyyyyy
Leckey
Be
|
|
|
|
|
Hi..
I want to build following effect in my application
I want to show how member are spred all over world.
Page should contain country/world map.
On clicking perticular region its expanded (ex. when india click its expanded and member count are listed in small popup.
then on clicking any region in it it also expanded.
It might be same as google map effect.
Any advice will greatly help.
Thanks in Advance.
|
|
|
|
|
girishdonde wrote: It might be same as google map effect.
good luck with that then, it would take one person a long time to re-create google maps 
Why not create a picture of the world (image map)
Then using co-ordinates mark on the map the general area of where these people are from
Heres an example of image map:
http://www.codeproject.com/KB/aspnet/ImageMap.aspx
|
|
|
|
|
Hi Everyone,
I wanted to open a new page with data for(Crystal report purpose), so i set PostBackUrl as my Target page in my Button, and in my Form tag i set as a Target as "_blank",and also i have 2 DropDown for data loading first dropdown i set AutoPostBack as "True", first time its working fine new page open with data, but if i want to view again with diffent selectedIndex in dropdown without button click its open a Blank page, so i can i solve this problem and is there any different machanism to do this pls help me to do that.
Thanks.
|
|
|
|
|
Can you post some of your code so we can see what is happening?
It sounds like its not using your most updated value because of the postback
|
|
|
|
|
This is my Form Tag
and this is Button Event,
<asp:button id="Button1" runat="server" text="Generate Report" validationgroup="AllSubmit" width="133px" onclick="Button1_Click" postbackurl="~/i/repo_view/tran_view/fpage.aspx">
|
|
|
|
|
Why dont you put the url in the onclick instead
|
|
|
|
|
I have given some code behind coding in onClick event, so i can't use that.
|
|
|
|
|
But you could use an if statement and then put the url in that
Can you psot your code behind so I can try and suggest another solution
|
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
ArrayList courseList = new Biz.CourseBO().GetAllCourses();
DropDownListCourse.DataSource = courseList;
DropDownListCourse.DataValueField = "ID";
DropDownListCourse.DataTextField = "AsString";
DropDownListCourse.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownListCourse.SelectedIndex != 0 && DropDownListBatch.SelectedIndex != 0)
{
CrBiz.DataTransferComponent co = new CrBiz.BatchFileBO().GetBatchFile(int.Parse(DropDownListBatch.SelectedValue));
this.ReportDoc = co.Document;
this.ReportData = co.DataSet;
}
}
protected void DropDownListCourse_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownListBatch.Items.Clear();
DropDownListBatch.Items.Add(new ListItem("-Select-", " "));
if (DropDownListCourse.SelectedIndex != 0)
{
Ins.ICourse _course = new Biz.CourseBO().CreateCourse(int.Parse(DropDownListCourse.SelectedValue));
ArrayList batchList = new Biz.BatchBO().GetBatch(_course);
DropDownListBatch.DataSource = batchList;
DropDownListBatch.DataValueField = "ID";
DropDownListBatch.DataTextField = "DisplayNumber";
DropDownListBatch.DataBind();
}
}
|
|
|
|
|
I want to delete 14 days old records from table automatic not manually.
how can I run automatic AutoDelete.aspx page at every 14 days interval so I can delete. at the same time I want to pass 14 days(No of days) to AutoDelete.aspx.cs page and I will use this value for procedure parameter.
so please tell me how can I cofigure web.config file.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
trilokharry wrote: how can I run automatic AutoDelete.aspx page at every 14 days interval s
This is not a good idea. Consider using jobs on the database server. Write a job and schedule it to run in the required interval.
|
|
|
|
|
ok fine
then how to handle this situation with database only.
at the same time I have to delete some specific date from table2 also.
thanks for your response
You get the best out of others when you give the best of yourself.
|
|
|
|
|
You can write any query in the job. It will be executed. So form your query, test it and put it in the job.
|
|
|
|
|
job means what
I dont know about this actually.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
