|
Hello.
I finished a bullentin board with Repeater on my pages .
I would like to make a seaching box(?) to show up a result on the list of Repeater, when someone searchs something by inputting on textbox.
So, I put Dropdownlist, Textbox and imagebutton through tool box on the page.
I mean I would like to make something like "Search" on top of this page.
Search [ Text Box ] [Dropdownlist] [button]
And I'm coding like the following code.
protected void Select_Btn1_Click(object sender, ImageClickEventArgs e)
{
string title;
title = Search_Txt1.Text;
if (DropDownList1.SelectedValue== "Title")
{
SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["aspnetdbConnectionString"].ConnectionString);
string sql = "Select * From t_Pds where Title = '"+ Title +"' ";
}
}
But I don't know how to show up the result on the list of Repeater.
|
|
|
|
|
Well, you have bigger issues than that. The obvious solution to your immediate problem ( apart from the general poor coding style ), is to run your SQL and bind your repeater to the result. Your bigger issue, is that I can erase your bullitin board simply by typing in the right search term. Do some research on SQL injection attacks.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hey,
Just you can do like this :
SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["aspnetdbConnectionString"].ConnectionString);
string sql = "Select * From t_Pds where Title = @p_search ";
SqlCommand cmd = new SqlCommand(sql,cn);
cmd.Parameters.add("@p_search",SqlDbType.VarChar,100);
SqlDataAdapter sAdpt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sAdpt.Fill(ds, "t_Pds");
Now you bind the sql to the Repeater:
yourrepeater.DataSource = ds.Tables["t_Pds"];
yourrepeater.DataBind();
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I create a stored procedure and call that the procedure through on linq.
databasecontext db=new databasecontext();
var results=db.sp_insert_logindetails();
Now i want to convert the results into dataset or datatable. Anybody help me
sp_insert_logindetails is a procedure name
it executes this query: - select * from logindetails
damodharan
|
|
|
|
|
i want the answer for the same question .. can anyone help..
i am using stored procedure with linq, i want the result of that stored procedure to come in dataset.. anybody please...??
|
|
|
|
|
Hi,
What happen when a music player is created and play the file from server, will the music file is downloaded to the client system or it play from server?
If it download to the client system, where it save?
Thankyou
YPKI
|
|
|
|
|
The music player is probably going to cache it internally, but I guess it depends on which player you use.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I created player using Object tag and Embed tag.
for eg:
<object id="" classid="" type="" url="" voume="" .......="" <="" object="">
i load and play a music file from server, what happening in the backend? will it dounload or cache it internally?
if it cache, any file will created in client system?
|
|
|
|
|
Hi
I am creating my first ASP.net Project(C#)....
my project is Student Project Allocation using Genetic Algorithm...... I have no idea in Genetic Algorithm..... can Any one explain what is Genetic Algorithm and how to implement in ASP.
Thanks In Advance
|
|
|
|
|
You need to talk to your teacher about what a genetic algorithm is, and/or refer to your textbooks. You could also try google. While one could be used in an ASP.NET application, it has nothing to do with ASP.NET, or even ASP, which is not the same thing.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
hai guys,
sagnik mukherjee has posted an article which does pagination based tablepagination but i want numeric pagination using jquery pagination plugin.. Can we implement it
|
|
|
|
|
Who is sagnik mukherjee ?!
Search inside CP forum and you will find.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Perhaps you should ask the author of the article you're trying to use.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
whenever i am converting a video file through ffmpeg while converting it is showing the process in .exe file. want i need is to hidden that .exe file while converting any video.
that .exe file should not displayed or process should be done hidden mode
|
|
|
|
|
Why are you asking this again ? What's wrong with the answers you got ? Who cares if the exe is visible, if you're running it on a server ?
vidya-2009 wrote: that .exe file should not displayed or process should be done hidden mode
you want the process hidden in the task manager, too ? What on earth for ?
you didn't even answer the people who responded before. Are you some sort of moron ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
HI,Vidya
No need to worry about exe. It is show only in local. When you are setup project on live than from client site this exe is not show. You have to just show only process that file conversion is going on.
Regard,
umesh soni
|
|
|
|
|
I'm not sure if you just said exactly what I've told him twice, or not....
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi,
I had read your last post.What you told was right but i thing she was not understand what u want to said.
|
|
|
|
|
It's a she ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi,
From name it's she. It is Indian name
|
|
|
|
|
Fair enough. I don't care that it's a she. I DO care that she's rude enough to ignore responses and then ask the same (clueless) question again. But, thanks for rewording my reply, perhaps she'll understand it from you.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
You beat my question 
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Seems he recognises the name. I thought for a moment they may be in the same building 
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
 Everyting is possible.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
