You searched for the word(s): userid:804971

More Search Options

RSS Available

• Re: how to loop through two key words

  hi saurabh4it, am here again, so sorry for troubling you. is it possible for the above code to check for the keyword in Database instead of the label. for example the code will take the first two keyword from the textbox and loop through database. once it found , then break the loop and display the alret(keywordfound) else loop again, if no keyword is found then display the alret(no keyword found). below is the code that am using but is not working SqlConnection conn = new SqlConnection("server

  Posted to C# (Forum) by ibcent2003 on 7/18/2009

• problem with session

  i have a session that is coming from another page, the name of the session is Session["keyword"] and the value of the session is (i don't). am using a select statement to retreive information from a table. my query is shown below select distinct keyword_answer from sentence where keyword like 'i don''t%' the above query works well in sql server query window.... but am trying to incooporate it in my codign so that the value of the session can be anything apart from (i

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ibcent2003 on 7/17/2009

• Re: problem with session

  thanks haku..its workin now..

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ibcent2003 on 7/17/2009

• Re: problem with session

  hi haku, am i going to replace the above code with my sql query. as instead of instead of select distinct keyword_answer from sentence where keyword ='"+Session[""].Tostring()+"' i replace with SQL_SEARCH_VALUE = Session["keyword"].ToString().TrimEnd().TrimStart(); SQL_SEARCH_VALUE = SQL_SEARCH_VALUE.Replace("'","''") ; SQL_SEARCH_VALUE = SQL_SEARCH_VALUE.Replace("%","[%]") + "%" ; SQL_REQUEST = "select

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ibcent2003 on 7/17/2009

• how to write select statement.

  hi everyone, am uisng select state to retrive a record from a table uisng where clause. i want to retrive all the record where value is example (i don't). if i use (i dont), is working well but if i use (i don't) is giving me an error saying Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 't'. Msg 105, Level 15, State 1, Line 1 Unclosed quotation mark after the character string ''. and i dont want to use to word (i dont) intead, i want to use (i don't). please

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ibcent2003 on 7/16/2009

• Re: how to loop through two key words

  i already mark it...........

  Posted to C# (Forum) by ibcent2003 on 7/15/2009

• Re: how to loop through two key words

  thanks saurabh4it, i solve the problem. i thanks again..

  Posted to C# (Forum) by ibcent2003 on 7/15/2009

• Re: how to loop through two key words

  hi aurabh4it, sorry for troubling you again. but is it possible to get the remaining value and display, for example if the value of the textbox is (i don't know you). since the keyword (i don't) is found in the label, then how can i display the remaining word(know you). right after the alert Response.Write("<SCRIPT>alert('"+keywordFound+"')</SCRIPT>"); Response.Write("<SCRIPT>alert('"+remaining keyword here+"')</SCRIPT>"

  Posted to C# (Forum) by ibcent2003 on 7/15/2009

• Re: how to loop through two key words

  hi saurabh4it, thanks for you reply. your code work perfectly, can get the keyword and display it in a label or using Response.Write("<SCRIPT>alert('display keyword here')</SCRIPT>");?

  Posted to C# (Forum) by ibcent2003 on 7/14/2009

• need help with Sql Query

  hi every one, i have a colunm that contain the values "this is a boy". how can i query my table to ingore "this is" and just retrive "a boy" instead of the whole values. thank you all.........

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ibcent2003 on 7/12/2009