User Profile

Collapse

Profile Sidebar

Collapse
DanielT
DanielT
Last Activity: Mar 16 '09, 09:18 AM
Joined: Jan 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DanielT
    replied to Bar code printing with page break after each bar code
    in Visual Basic .NET
    hi all, the problem solved with output the computed barcode to xml file and bind it to crystal report.
    See more | Go to post

      Leave a comment:

    • DanielT
      started a topic Bar code printing with page break after each bar code
      in Visual Basic .NET

      Bar code printing with page break after each bar code

      i'd like to print bar codes with page break after each bar code, below is my current codes.

      Code:
       Protected Sub cmdGenerate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdGenerate.Click
        Dim connActive As New SqlConnection(Session("db_conn_str"))

        Dim arParam(1) As SqlParameter
        arParam(0) = New SqlParameter("@param_type", Me.txtType.Text)
      ...
      See more | Go to post
      • DanielT
        replied to if else in select Statement
        in SQL Server
        thx for ur reply guys, I solved the problem by joining all those tables, and query as below

        Code:
        SELECT 	'location_name' = CASE
					WHEN t.task_is_trunk = 1 THEN
						dbo.tblbranch.branch_name
					ELSE
						dbo.tblCSLocation.location_id
					END
        See more | Go to post

          Leave a comment:

        • DanielT
          started a topic if else in select Statement
          in SQL Server

          if else in select Statement

          Hi guys, I am new here. I need to put the below if else condition in select statement, is it possible?

          if task_is_trunk = 1
          (select branch_name from dbo.tblBranch where task_location_g uid = dbo.tblBranch.b ranch_guid) as location_name
          else
          (select location_id from dbo.tblCSLocati on where location_guid = dbo.tblCSTask.t ask_location_gu id) as location_name

          Thanks!
          See more | Go to post
          No activity results to display
          Show More
          Working...