Hi, I fixed an after update trigger with a table in Sql server 2005 and i want to get the last Identity updated in the this table to inserted in another table. How can i get the last updated Identity in a table? Please help Thank you Sms

Hi, I have table with 5 column I need to group the duplicate recorde and sum the quantity. And this my table column Product Quantity price description How can i do that? Thank you sms

Hello All, I have two tables First one has PK auto increment column and the second table Has FK I select the last inserted PK in the First table and insert it into the second table as FK. is there is any more professional way to do so or this is the correct way? Sms

Thank you for you reply. I have customer table and Customer order and there is a PK in the customer table and FK in the order table i need to get all coustomer has no record in the order tables Thank you

I have two customer and order table how can i return all customer has no orders. Thank you hoho

Hello All, I have in my database two columne number colume and varchar and i need to add this columne in one columne i try cast but it gives me invaled express. please help hoho

thanks for your reply... It is some of textboxs control i need the user to move from frist textbox to the next when he press enter. Best Regards, Hoho

Hello , I need to move the focus on the next control when the user press on the Enter key.like he press the tab key. Please help. hoho,

Hello All, I made a Com+ component and i used it in the client server way but my server in subnet and the clients in another subnet and there is a firewall in the network. after i search on the internet i found that the Com+ and DTC use the Netbios. the problem is the microsoft still use Netbios to comunicate to the server and client. this is the problem. Please can any one help me to solve this problem. thanks for your time. Best regards, Hoho

Thanks for your reply I need to count how many numbers after the decimal point for instance if 3.44 or 3.4 i need to count how many number after the decimal point it is now two number in the frist number and one number in the frist number. Thanks for your time Best regards, Hoho

Hello all, How can i count the nuber after the decimal point. Please Help Thanks Hoho

Thanks for your reply I am trying to do some operations on the Sql database with this com+ like insert, update and delete but this operations works with transactions Thanks Hoho

Hello there, I did Com+ component has many class all classes marked with autocomplet , Guid and some required and other requiredNew when i am trying to call methods from one of these classes it prombet me with this message "The transaction has already been implicitly or explicitly committed or aborted " Please i need to know what dose it means this message. Thanks for your time and help Best regards, Hoho

Hello , I made a programes that use com+ componect to do stuff in the database server and i used crystall report to print my reports but i have a exceptions when i am trying to retrive database with com+ component and disply it with the crystall report. "The transaction has already been implicitly or explicitly committed or aborted" and this exception when i try to display the crystall report. "The table 'Client_report' could not be found. Error in File D:\DOCUME~1\ADMINI~1.000\LOCALS~1\Temp\{A6BF13A2-994F-4A36-9312-40488E7885C3}.rpt: The table could not be found. ---> System.Runtime.InteropServices.COMException (0x800002C5): The table 'Payroll_Report' could not be found. Error in File D:\DOCUME~1\ADMINI~1.000\LOCALS~1\Temp\{A6BF13A2-994F-4A36-9312-40488E7885C3}.rpt: The table could not be found." -- modified at 7:16 Friday 16th December, 2005 Please help Thanks Hoho

Thanks so much about your help but i need to know the ID of this current record to select the related details with this ID. thank hoho

Hello all, i am using Datagrid to dispay row directly from my database but i need to click on one row to open details for this row from another table in the database where i can hang the value for the row with specifc row like in the combobox ValueMember Thanks for help Hoho

hello all, i got this message when i try added anther calss to my com+ component Could not load type DataAccess.Payroll from assembly DataAccess, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3033fe621d172f88. pls can any one know how can i solve this thank hoho

Hello all, I develped an application it suppose to access SQL server Via internet i need to know if there is a special ports to use and what is the String connection to use. Please help. Hoho

Hello All, I developed a Com+ Application it will work in the clients machin and do some work in the SQL Server. this SQL server inside a DMZ. the problem is the component in the clients can reach the SQL Server to do the work. how can i solve this problem Please help Hoho

Hello All, I made a Com+ component connect over network to insert , update and delete from the Sql serve in the same network. but i got error means that no connectivity between the server and client. I need to know what is the default ports and portocols that the Com+ user it over the network? Thanks Hay