thnx,but if ay one plz do it in sql

Hello can any one please tell me how can i perform the following actin in SQL if ((sizee == "") && (sidee == "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + orgnShortName; } else if ((sizee == "") && (sidee == "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + color + "-" + orgnShortName; } else if ((sizee == "") && (sidee != "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sidee + "-" + orgnShortName; } else if ((sizee == "") && (sidee != "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sidee + "*" + color + "-" + orgnShortName; } else if ((sizee != "") && (sidee == "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "-" + orgnShortName + "*"; } else if ((sizee != "") && (sidee == "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + color + "-" + orgnShortName; } else if ((sizee != "") && (sidee != "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + sidee + "-" + orgnShortName; } else { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + sidee + "*" + color + "-" + orgnShortName; } return ItemComputerCode; thnx in advance Regards

because without zeroes its not sorting in ascending like i have data 1 2 3 10 11 21 31 without zeroes its sorting like this 1 11 21 31 2 3

Thnx its working perfect kindly tell me is this good approach or theres any other method to do this? second how can show message as i m usng sqldatasource(GridView) to update and delete

yes they mean same but when we try to sort its meaning will change thats y for sorting we need this

thnx i will try this

Helllo I have a problem while updating data in Sql table, i have a table named City it contains CityID,CityName,CityShortName i have created a stored procedure PROCEDURE [dbo].[UpdateCity] @CityID int,@CityName nvarchar(50),@CityShortName nvarchar(50) AS BEGIN Declare @ReturnVal nvarchar(20) SET NOCOUNT ON; SET XACT_ABORT ON Begin Try IF EXISTS (SELECT CityName From City WHERE CityName =@CityName) BEGIN SET @ReturnVal ='Already Exists!' --Return @ReturnVal END ELSE BEGIN Update City Set CityName=@CityName,CityShortName=@CityShortName where CityID=@CityID Set @ReturnVal ='Updated SuccessFully' --Return @ReturnVal End end try but when i m just editing Shortname its not updating , but its working perfect when i m editing either cityname or cityname and shortname,, i know that i m doing mistake but where i can't found second thng how can i show message updated successfully or already exist as i m using asp gridview Please help me Thanx

thnx alot

Hello Kindly tell me is it necessary to use SET XACT_ABORT ON in sql transaction or not? Regards

Dear friends i have developed a windows application the thing i want to do i want to make its demo setup so that i can give it to my clients for a period of time after that application fails to open or reinstallation i have tried many things but i am fail to make demo any ideas thanx in advance

i have developed a simple c# desktop windows app when i take it to another pc its color automatically changed to black or another , can any one help that how can i prevent from this prob

hello dear friends i have a problem that i have added checkbox in datagrid view its working properly but i want to select all checkboxes at a time can anyone tell me how can i do that i have added checkbox in gridvew from gridview collection poperty

i know how to break up message after 159 char but when i break it in to mutiple messages and send it to any number the reciever recieve it in multiple messages the thing i want is that when i send it the reciever got it in a single message.

can you plz guide me how can i break up message and send it when i breakup message will reciever get it in one message or in multiple messages?

Hello i need some help i have developed a sms software on c# ,i have used gsmcommm and pduconverter its working but its just sending 160 char message and i need to send long messsages can any one help me plzzzz Regards