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

More Search Options

RSS Available

• SSRS Report Parameters - need to check current record

  hey guys, I have run into some issues, I have one main query in which is selectin different fields from other tables, however one field i would like to obtain ('comments') is from two tables. First ONE table CLAIM_NATURE have a claim_no which is linking with the polic_claims table so pullin out the comment in this table is find however some claim have many comments or NO comments in the such of more than one comment or no comment i want to pull from another table CLAIM_Loss which just have

  Posted to SQL Server Reporting Services (Forum) by Trini_NAtwaroo on 7/14/2009

• Re: connect sql datasource to excel in .net

  hey thanks I actually used something similar as it and worked, however I am wondering if I can format the excel spreadsheet before it exports eg I want a title and subject of the excel before the gridview appears, do you have any idea by chance how to do this? Thanks

  Posted to Data Access and ObjectDataSource Control (Forum) by Trini_NAtwaroo on 7/6/2009

• Re: connect sql datasource to excel in .net

  hey thanks for all your help, i used the code below to add the text before exporting to excel. protected void Page_Load(object sender, EventArgs e) { VerifyRenderingInServerForm(form1); gvToExport.GridLines = GridLines.Both; } protected void btnExport_Click(object sender, EventArgs e) { Panel p = new Panel(); Panel p2 = new Panel(); Panel p3 = new Panel(); Panel p4 = new Panel(); Label lb = new Label(); Label lb2 = new Label(); Label lb3 = new Label(); Label lb4 = new Label(); lb.Text = "Company

  Posted to Data Access and ObjectDataSource Control (Forum) by Trini_NAtwaroo on 7/6/2009

• Using Textbox value with the CONTAINS operator

  hey guys, I am trying to search through a pdf using a keyword from a textbox i tried this sql but doesn't work SELECT * FROM tb_article WHERE CONTAINS ( [file_name] , '"*' + @key + '*"' ); I am doing this in an sqldatasource to display in a gridview where in the next step to define parameters i would set key to TextBox1.Text but i an not even getting to the next step to do this since i am getting an error near '+' Please Please help someone. Thanks

  Posted to Getting Started (Forum) by Trini_NAtwaroo on 6/10/2009

• Re: searching pdf with sql server

  hey i actually got through i needed the Adobe IFilter and recreated the unique index and full text index. This site actually help http://www.pdfstore.de/datenblatt/FoxitPDFIFilter1.0forSQLServer2005_manual.pdf http://stackoverflow.com/questions/272694/using-full-text-search-with-pdf-files-in-sql-server-2005 Thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Trini_NAtwaroo on 6/8/2009

• CONTAINS operator get value from a TextBox

  Hey Guys, I am using the Contains opertor to search through a pdf but i want the word/text that is being used to search through to come from a textbox eh textbox1. my current sql is SELECT article_title, author, publish_by, publish_date, [file] FROM tb_article WHERE CONTAINS(file, '"*a*"' ) AND (category = @cat) AND (publish_by = @pub) AND (publish_date >= @SDate) AND (publish_date <= @EDate) where it is return all the articles with words containing a this is just a test btw

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Trini_NAtwaroo on 6/8/2009

• Re: Searching through pdf with SQL query

  hey i actually got through i needed the Adobe IFilter and recreated the unique index and full text index. This site actually help http://www.pdfstore.de/datenblatt/FoxitPDFIFilter1.0forSQLServer2005_manual.pdf http://stackoverflow.com/questions/272694/using-full-text-search-with-pdf-files-in-sql-server-2005 Thanks

  Posted to Getting Started (Forum) by Trini_NAtwaroo on 6/8/2009

• searching pdf with sql server

  Hey Guys, When i thought i reach the final stage i'm stuck. Ok I have a table article that have fields title, author date,file_name (data type is image) i uploaded my pdf in my table in the field file_name using the code below public void OnUpload( Object sender, EventArgs e) { // Create a byte[] from the input file String datef = DropDownList4.SelectedValue + "/" + DropDownList5.SelectedIndex + "/" + DropDownList6.SelectedValue; DateTime myDateFrom = DateTime .Parse(datef

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Trini_NAtwaroo on 6/5/2009

• Searching through pdf with SQL query

  Hey Guys, I need some help. So I have a pdf file and I stored the name of the file eg nadine_grow.pdf in a field in a table. However while researching I realise inorder to search through a pdf for keywords you need to save the pdf in a binary form. 1. How do I convert or save the file name into a binary form? Also what would be the dataType 'binary'? 2.If i have this file name stored in binary format for each file I can search through the pdf using this sql query I saw : SELECT * FROM [ClientKnowledgeManagement

  Posted to Getting Started (Forum) by Trini_NAtwaroo on 6/4/2009

• Re: DateTime function

  ok great thanks!

  Posted to Getting Started (Forum) by Trini_NAtwaroo on 6/4/2009