Search Results

Search found 21 results on 1 pages for 'bhejafry'.

Page 1/1 | 1 

  • CrystalReports.NET - varbinary blob

    - by BhejaFry
    Hi folks, what's the proper way to display an image stored in sqlserver database as an varbinary(max) datatype in CrystalReports for .NET? I have added a 'blobfieldobject' item in crystal reports & it is bound to a datatable with the column of type 'varbinary(max)' but the image won't show up instead a dark background is diplayed. TIA

    Read the article

  • sql - update only when values are different

    - by BhejaFry
    Hi folks, In SQL Server 2008, how do i update fields in a table only if their values differ with the values in the update statement ? For ex: I have TableA with column FirstName whose value is 'Roger Moore' with an unique id of '007'. Now, i am calling an update statement but it should update the 'FirstName' field only if value is something else other than 'Roger Moore'. TIA

    Read the article

  • sql - datetime variable versus string representation of datetime variable

    - by BhejaFry
    Hi folks, I have a query that takes too long to respond when the search parameter happens to be a varchar datatype with date. However, if i convert varchar to datetime variable, the query runs fine. For ex: This takes too long. select count(id) from names where updateddate '1/5/2010' This runs fine. declare @dateparam datetime set @dateparam = convert(datetime, '1/5/2010',102) select count(id) from names where updateddate @dateparam What's the reason one runs fine but the other doesn't? TIA

    Read the article

  • Crystal Reports - export to pdf in MVC

    - by BhejaFry
    Hi folks, I have integrated the below code in my application to generate a 'pdf' file using crystal reports in MVC project. However, after the request is processed, i get to see only 2 pages in the pdf file while my 'data' returns more than 2 records. Also, the pdf isn't rendered as soon as the page is processed but instead i have to refresh atleast once, then the pdf is rendered on the browser. using CrystalDecisions.CrystalReports.Engine; public FileStreamResult Report() { ReportClass rptH = new ReportClass(); List<sampledataset> data = objdb.getdataset(); rptH.FileName = Server.MapPath("[reportName].rpt"); rptH.Load(); rptH.SetDatabaseLogon("un", "pwd", "server", "db"); rptH.SetDataSource(data); Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, System.IO.SeekOrigin.Begin); return new FileStreamResult(stream, "application/pdf"); } I took the code from here in SO but modified it like above. TIA.

    Read the article

  • winform - login form template

    - by BhejaFry
    Hi folks, new to winform development. I am trying to add a 'login form' to my project in vs2008 but the template is missing. When i do 'add new item', i don't see 'login form'. However i do see mainform, aboutbox form templates. TIA

    Read the article

  • jQuery - what's jQuery plugin

    - by BhejaFry
    Hello folks, can somebody tell me what is jQuery plugin? I have used the jQuery library to build some small UI enhancements but i have no idea how to implement a plugin. Any suggestions on how to get started? TIA

    Read the article

  • jQuery - error updating JScript Intellisense

    - by BhejaFry
    Hello folks, i have searched similar posts on google & stackoverflow to no use. Basically, what i have is a new aspx page. I have the following files referenced in the head section. jquery-ui-1.7.2.custom.css jquery-1.3.2.min.js jquery-ui-1.7.2.custom.min.js Theme:smoothness UI Version: 1.7.2 for jQuery 1.3.2 I have nothing else going on in the page but still get the error 'error updating JScript Intellisense. I am using VS2008 SP1. Any ideas? TIA ps: VS shows intellisense if i refer to 1.4.1.js & 1.4.1-vsdoc.js

    Read the article

  • Sql - tablename as variable

    - by BhejaFry
    Hi folks, i am trying to execute this query: declare @tablename varchar(50) set @tablename = 'test' select * from @tablename This produces the following error: Msg 1087, Level 16, State 1, Line 5 Must declare the table variable "@tablename". What's the right way to have table name populated dynamically? TIA

    Read the article

  • VSS - Solution file between multiple users

    - by BhejaFry
    Hi folks, we have a solution with multiple projects that is being developed by a team of developers. Project paths in the solution file checked in initially contains the path that are specific to that developer. Now when another dev gets latest of the solution, some of the projects won't load as the path differs. What's a better way to manage this ? TIA

    Read the article

  • asp.net - pdf printing status

    - by BhejaFry
    Hi folks, I need to print PDF's generated in an asp.net application using crystal reports. Upon printing, a database table gets updated with the status 'printed'. How do we handle situation where let's say, the printer runs out of paper? I know this is on client-side, so what's the right way to handle issues like this? TIA

    Read the article

  • c# - pull records from database without timeout

    - by BhejaFry
    Hi folks, i have a sql query with multiple joins & it pulls data from a database for processing. This is supposed to be running on some scheduled basis. So day 1, it might pull 500, day 2 say 400. Now, if the service is stopped for some reason & the data not processed, then on day3 there could be as much as 1000 records to process. This is causing timeout on the sql query. How best to handle this situation without causing timeout & gradually reducing workload to process? TIA

    Read the article

1