Click here to Skip to main content
15,886,137 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhow to get the dynamically created radiobutton checked values Pin
MalarGayu14-Dec-11 12:33
MalarGayu14-Dec-11 12:33 
AnswerRe: how to get the dynamically created radiobutton checked values Pin
Nitish Arora - Web Developer(Learner)15-Dec-11 8:33
Nitish Arora - Web Developer(Learner)15-Dec-11 8:33 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 9:21
MalarGayu15-Dec-11 9:21 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 15:01
MalarGayu15-Dec-11 15:01 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
MalarGayu15-Dec-11 17:35
MalarGayu15-Dec-11 17:35 
GeneralRe: how to get the dynamically created radiobutton checked values Pin
Ibrahim Hebish11-Jan-12 0:59
Ibrahim Hebish11-Jan-12 0:59 
Questionhow to pass selected value to subreport(crystal report) Pin
Ramkumar_S14-Dec-11 0:18
Ramkumar_S14-Dec-11 0:18 
Questionsearching in populated GridView using Select statements Pin
Taysseer Kadri13-Dec-11 22:15
Taysseer Kadri13-Dec-11 22:15 
have a gridview on my webpage that binds from an excel sheet using OleDb

Now I'm trying to set it up so that people can search just by typing a word in the textbox, and then after button click, it'd filter all the results that have the same word in any column

I was advised to use this code:

<pre lang="c#">
protected void Button1_Click(object sender, EventArgs e)
{
string search = TextBox1.Text;
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
grvCarProof.DataSource = dt.Select("CP number = ");
grvCarProof.DataBind();

}
</pre>


what I can't figure out is what kind of writing should go in my SelectCommand(). Am I even doing it right?

Any advice you can give me would be greatly appreciated. Thanks in advance.
QuestionEntity Framework Pin
indian14313-Dec-11 15:50
indian14313-Dec-11 15:50 
Questioncreate textbox dynamically Pin
en.Mahdi13-Dec-11 2:11
en.Mahdi13-Dec-11 2:11 
AnswerRe: create textbox dynamically Pin
R. Giskard Reventlov13-Dec-11 3:16
R. Giskard Reventlov13-Dec-11 3:16 
GeneralRe: create textbox dynamically Pin
Dennis E White13-Dec-11 6:32
professionalDennis E White13-Dec-11 6:32 
QuestionSession Timeout Pin
Priya Prk12-Dec-11 5:37
Priya Prk12-Dec-11 5:37 
AnswerRe: Session Timeout Pin
Dalek Dave13-Dec-11 12:49
professionalDalek Dave13-Dec-11 12:49 
QuestionHow to upload image and immediate open in ImageControl without database in asp.net C# ? Pin
Dharmesh11111-Dec-11 19:04
Dharmesh11111-Dec-11 19:04 
AnswerRe: How to upload image and immediate open in ImageControl without database in asp.net C# ? Pin
thatraja11-Dec-11 19:59
professionalthatraja11-Dec-11 19:59 
Questionset gridview cell text null Pin
uspatel11-Dec-11 19:03
professionaluspatel11-Dec-11 19:03 
AnswerRe: set gridview cell text null Pin
Karthik Harve11-Dec-11 21:39
professionalKarthik Harve11-Dec-11 21:39 
GeneralRe: set gridview cell text null Pin
uspatel11-Dec-11 23:19
professionaluspatel11-Dec-11 23:19 
AnswerRe: set gridview cell text null Pin
Jitendra Parida - Jeetu11-Dec-11 23:45
Jitendra Parida - Jeetu11-Dec-11 23:45 
GeneralRe: set gridview cell text null Pin
uspatel12-Dec-11 0:52
professionaluspatel12-Dec-11 0:52 
QuestionCache Problem Pin
Shyamjith Cherukara11-Dec-11 18:07
Shyamjith Cherukara11-Dec-11 18:07 
QuestionUsing wiki templates Pin
_AnsHUMAN_ 11-Dec-11 17:17
_AnsHUMAN_ 11-Dec-11 17:17 
QuestionMVC Areas - Home Controller naming conflict Pin
DaveAuld11-Dec-11 14:03
professionalDaveAuld11-Dec-11 14:03 
GeneralRe: MVC Areas - Home Controller naming conflict Pin
Richard MacCutchan11-Dec-11 22:26
mveRichard MacCutchan11-Dec-11 22:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.