Hi Dears! I am using crystal report 10 with C# 2005. I have an issue that i want to change the font of Group Header Text that is visible when we click on Toggle Group Tree button and a tree pane is visible towards the left side of report viewer. I have goggled a lot but unable to find any hint. Any idea or help would be highly appreciated . Thanks in advance.

Hello All! Well I am facing an odd issue in C# VS.Net 2005. I designing reports in CR 10. And my requirement is to programatically export the report in simple Text format maintaining its allignment. But the enum value CrystalDecisions.Shared.ExportFormatType.Text is missing and i am unable to export the report into text format. All other enum values are available like Word, Pdf, Excel , Html, Rtf etc but Text format not available. Please what may be the possible solution. Please help me in this regard . THANKX in ADVANCE

Hello All! I have been unable to receive a Byte[] in MC++. Whats the right syntax this is the C# dll method. public byte[] GetPictureBytes(Image _Pic) { byte[] _rtval = null; MemoryStream mstr = new MemoryStream(); _Pic.Save(mstr, ImageFormat.Jpeg); _rtval = mstr.GetBuffer(); return _rtval; } Now i have to call this C# dll method in VC++.NET 2005 the syntax that i m using to call and receive this byte array is as follows but its creating some error. " array^ myImage = gcnew array^(1); myImage = dllobj->GetPictureBytes(_myImage); " OR "array^ myImage = gcnew array^(1); myImage = dllobj->GetPictureBytes(_myImage);" // dllobj is of C# dll Class type that contains metod GetPictureBytes(Image _Pic); // _myImage is Image type i have used some other combinations also to receive the Byte array but cant having some errors. Plz guide me writing correct syntax to receive this Byte array in VC++.Net THNX in Advance -- modified at 5:55 Wednesday 16th August, 2006

Well Dears! I need some help to convert my Existing C# 2.0 (Database SQL EXPRESS) Application from English to Multilingual(Preferably THAI). I have got all labels and Strings Translation. And now ready to start working but unable to start as i am confused where to start. And wht about the database that i have already designed and developed written all procedures and functions etc. Would i need to modify my DB END too(table fields,procedures, functions etc). And i need some easy way to do it that is helpful in future also as i m supposed to convert it to some other language in the future. Any articles and suggestion would be highly appreciated THNX IN ADVANCE.

Well Dears! Which Port Xp uses when we Access a Shared Folder over a network. as i m working in a restricted enviornment where most of the windows port are blocked. i have to share a folder over network and access it on network. i want to know which port windows uises to browse shared folder over network so as i may be able to unblock that port thnx in advance

HI! I have a sql script file(myscript.sql size 60k) When i run this script in a query analyzer it runs fine but when i makes its a Stored procedure so as i may be able to call it from my C# application. But sql doesnt allow me to amke a sp of it as it raises a lot of errors. Whats the real problem. I want to make this script a Stored Procedure so as i may be able to call it from my Application. Whats he solution to it. Should i be to remove all go Statements or anything else in sql Script.Or is there any other way round to do this. Solution required THNX In Advance

Beolw is the tables Structure and dummy data used in Access database Employee ======== EmpId(Pk int) EName(Text) DeptId(Fk int) 1 Rashid 1 2 Kashif 2 3 Black 1 4 White 2 5 Brown 2 Department ========== DeptId(Pk int) DName(Text) 1 Labor 2 Secret 3 Production 4 Purchase Attendance ========== AttId(Pk Int) EmpId(Fk int) In/Out_Time(Datetime) Direction 1 2 2/5/2006 6:37:02 PM 1 // 1 for IN, 0 For OUT 2 2 2/5/2006 8:37:02 PM 0 3 2 2/5/2006 8:50:00 PM 1 4 1 2/5/2006 8:51:00 PM 1 5 1 2/5/2006 9:37:02 PM 0 6 2 2/5/2006 9:40:02 PM 0 7 3 2/5/2006 6:37:04 PM 1 8 4 2/5/2006 6:37:06 PM 1 9 5 2/5/2006 6:37:08 PM 1 10 5 2/5/2006 8:40:02 PM 0 11 4 2/5/2006 8:40:40 PM 0 12 3 2/5/2006 8:40:50 PM 0 13 2 3/5/2006 6:37:02 PM 1 14 2 3/5/2006 8:37:02 PM 0 15 2 3/5/2006 8:50:00 PM 1 16 1 3/5/2006 8:51:00 PM 1 17 1 3/5/2006 9:37:02 PM 0 18 2 3/5/2006 9:40:02 PM 0 19 3 3/5/2006 6:37:04 PM 1 20 4 3/5/2006 6:37:06 PM 1 21 5 3/5/2006 6:37:08 PM 1 22 5 3/5/2006 8:40:02 PM 0 23 4 3/5/2006 8:40:40 PM 0 24 3 3/5/2006 8:40:50 PM 0 And so on the attendance data for whole month. What i need is an optimized efficient query that takes a Start_date(DateTime) as an input parameter and returns me the Attendance data of all Employees for one week. Means starting from startdate and ending at startdate+6 days in the following format EName DName IstDay 2ndDay 3rdDay 4thDay 5thDay 6thDay 7thDay Where as IstDay to 7thDay Columns contains the value for total Working hrs at that day as IstDay = [{Value of In/Out_Time Column for Max(AttId) When Direction=0}- {Value of In/Out_Time Column for Min(AttId) When Direction=1} Where DatePart(d,In/Out_Time)=DatePart(d,@Start_Time) for any EMpId] 2ndDay = [{Value of In/Out_Time Column for Max(AttId) When Direction=0}- {Value of In/Out_Time Column for Min(AttId) When Direction=1} Where DatePart(d,In/Out_Time)=DatePart(d,@Start_Time+1 Day) for any EMpId] 3rdDay = [{Value of In/Out_Time Column for Max(AttId) When Direction=0}- {Value of In/Out_Time Column for Min(AttId) When Direction=1} Where DatePart(d,In/Out_Time)=DatePart(d,@Start_Time+2 Days) for any EMpId] 4thDay = [{Value of In/Out_Time Column for Max(AttId) When Direction=0}- {Value of In/Out_Time Column for Min(AttId) When Direction=1} Where DatePart(d,In/Out_Time)=Dat

Well! Dears. i have an mdi form in which i open differnet child forms . when both parent and child are maximized its ok but when i restore the MDI parent form it disturbs the layout of Child form that was Maximized in MDI. What i want is that when i restore MDI form it doesnt disturb the layout design of Child form instead it (MDI form) gets Horizantal and vertical scroll bar keeping the Child Form Maximized and undisturbed. How to do that. Thnx in Advance.

Thnx for reply! I m almost very near to my solution. Ok What i want is that two threads could have acess to static functions at one time but these function should be different. that means let thread t1,t2 may have acess to static function Componet.St_F4(--); Componet.St_F1(--,--,---); respectively. that is t1---->Componet.St_F4(--); t2--->Componet.St_F1(--,--,---); is it so as i did b4. or how to achieve this

Well! First of all thnx for Reply. Ok i m already calling these functions in the delegate MyDlg that is called whenevr Capture event occurs then how can i add an other event handler and call these functions. may i do this as below myobj.Capture+=new CaptureEventHandler(MyDlg); static object syncObject = new object(); private void MyDlg(---,--,---) { lock(syncobject); Componet.St_F4(--); lock(syncobject); Componet.St_F1(--,--,---); if(myobj.id==1) lock(syncobject); Componet.St_F3(---,--); if(myobj.id==2) lock(syncobject) Componet.St_F2(--,--); }

Actually i forgot to mention one more thing , The component class is only a sketch to understand , in real i m using these static function form a dll named Component. for which i dont have acess to implementation code of these Static function.i m just using the functionality. So if there is any other possibility plz let me know. Thnx

well here is the description of my problem I have a component in which all the methods are static let the skeleton is like below public Class Component { ............. ......... ....... public static void St_F1(--,--,--) { --- - --- -- } public static void St_F2(--,--,--) { --- - --- -- } public static void St_F3(--,--) { --- - --- -- } public static void St_F4(--) { --- - --- -- } } ////////////////// now these functions are called in other class MyClass in the delegate MyDlg that is called when the Capture event occurs public Class MyClass { ---- ---- private Scanner myobj=new Scanner(); myobj.Capture+=new CaptureEventHandler(MyDlg); private void MyDlg(---,--,---) { Componet.St_F4(--); Componet.St_F1(--,--,---); if(myobj.id==1) Componet.St_F3(---,--); if(myobj.id==2) Componet.St_F2(--,--); } } //////////////////////// Now i make 2 objects of MyClass each of them has a unique value of myobj.id MyClass ClassObj1=new MyClass(); MyClass ClassObj2=new MyClass(); Now both of these instances of the MyClass have to call event myobj.Capture+=new CaptureEventHandler(MyDlg); implicitly nad may be event occurs from both objects at a time i want to make the call to the each Static Function called in the body of MyDlg synchronized. So as Only one object may call the Static function at a time. How to achieve this. Plz help Me Thnx in Advance

DateTime Updating Problem in sql? below is the query that is a part of a sproc .All table fields and values are ok. When the mentioned Sproc. is called in query analyzer it executes well and update all fields of the table used in UPDATE statement . UPDATE Emp_Schedule SET IOS = 0, HoursWorked = @WorkTime, COA =getdate() WHERE (Emp_Id = @EmpID) AND (S_Id = @ShiftId) AND (DT =@DayTime) PROBLEM arises when i call this procedure from C# code all fields are updated Except the COA(DateTime) field.Whats the problem. SProc runs well both in debug mode and normal mode in query analyzer and do updates the values. But when i call in C# only datetime field COA is not Updated? Plz solve this. THNX IN Advance.

below is the function that compares only time .there are 3 datetime variables. @StartTime datetime @EndTime datetime @DayTime datetime @StartTime is always less than @EndTime regardless of its dates.and @DayTime may be any time. We have to calculate whether @DayTime lies between @StartTime and @EndTime or not. And on its behalf we return a value. if @DayTime lies between @StartTime and @EndTime return 1 else return 0.But tested with these values result is not ok. set @StartTime='12/1/2005 12:30:49 PM' set @EndTime='12/2/2005 4:30:49 AM' set @DayTime='2005-12-02 00:56:02.730' select dbo.udf_IsShiftValid(@StartTime,@EndTime,@DayTime ) it returns 0 where i think it should return 1. plz correct me where m i wrong. Actually i have to use this function on CheckInShfit event of the Employee. @StartTime and @EndTime are the time of the shifts that have already been defined in the database very ago. Now whenever Employee ChecksIn we have to confirm wheather he is entering Between his shift timing that have been Defined already in the database, if his CheckInTime (only time not date) @DayTime lies between his @StartTime and @EndTime then he is allowed to enter (i.e 1) else Not(0). Now keeing in view the baove Scenario, plz guide me plz modify this function so as it returns 1 if the @DayTime Lies Between @StartTime And @EndTime else one( BUt keep in Mind i m required to compare only time not the dates and @startTime value is always less than @EndTime value) CREATE FUNCTION dbo.udf_IsShiftValid(@StartTime datetime, @EndTime datetime,@DayTime datetime) RETURNS int AS BEGIN DECLARE @RtValue AS int IF convert(varchar,@DayTime,114)>= convertvarchar,@StartTime,114) AND convert(varchar,@DayTime,114)< (convert(varchar,@EndTime,114) BEGIN SET @RtValue=1 END ELSE BEGIN SET @RtValue=0 END RETURN @RtValue END -- modified at 21:40 Thursday 1st December, 2005

Comparing only Time in Sql? Hi Dears! I have two Different DateTime Values i want to Compare only their times independent of Dates How to do it? let DateTime @dt1='2004-10-30 19:30:00.917' DateTime @dt2='2005-11-29 15:00:00.917' accordint to my requirements @dt1>=@dt2 should be true as 19:30>=15:00 because i have to compare only the time not the Date how to achieve this in sql .Function required.

i have some confusion. Scenario is that for an Employee to start and end job the following fields are available; Field DataType ===== ======== Emp_Id Foreign Key} DateTime PrimaryKey }----> Composite Primary key CheckInTime DateTime CheckOutTime DateTime InOutStatus bit HoursWorked ?--------> What shoulud be DataType? When an Employee Checks in All fields are set and InOutStatus is set to 1 Except CheckOutTime and HoursWorked.When The Employee checks out InOutStatus is set to 0,CheckOutTime is set and then i have to calculate the HoursWorked (TimeDuaration). Constarins are CheckOutTime is always greater than CheckInTime.(There may be different dates for them as employee gets check in ,Nov 29,2005 on time 17:00 and checksout , Nov 30,2005 on time 03:30).Now according to calculation he worked for 10 hours and 30 minutes .How to calculate this hours worked(only time duration and to which datatype it should be saved in sql) as well as the Stored Procedure for this whole process.Whenever Employee comes his Emp_Id is only known. Thnx in Advance.

In sql database , I have two tables named Emp_Info and Emp_Experience the structure of table is like this; Emp_Info ======== Emp_Id PrimaryKey(Auto) Emp_Name Emp_Age Emp_Experience ============== Exp_Id PrimaryKey(Auto) Emp_Id ForeignKey Exp_Detail Exp_Year . . . . ... and so on Working on a single form, All these fields have to be enterd and are saved against one button click.The Problem is how can i get the Emp_Id for Emp_Experience table to save Experince and Emp_Info paralelly.The relationship btw Emp_Info and Emp_Experience is one to many. that is, Against one Employee there may be none or many Experiences. in the scenario, i have to add Experiences first and then save the Employee? What 2 do? any guide line, help .....>? i need its stored procedure for saving Experiences. Thnx in Advance

Image to to Stream of Byte[]? I have an image in the pictureBox captured from a device .Now i want to convert this PicBox.Image to stream of bytes to save it in the DataBase.Plz help me how to convert this image from pictureBox to stream of bytes.I pretty know how to save it in database but having some problem converting the image to stream of bytes from PictureBox. Thnx in Advance!

Hi Dears! I need ur help to tackle the following scenario. I have total two win forms. F1,F2 F1 contains control,Timer,DateTimePicker ,Some text lable and A pictureBox, all are private. F2 inherits F1 ( F2:F1) when i call show methed for F2 with its instance all the controls of form F1 are visible on F2 hat i want to keep some of the controls invisble(not inherted and not visble) in inherited form F2. For Example i want the pictureBox control in F1 to be (public/private)static and not inhertable ,non visble on form F2. How to do this? Thnx in Advance!

I want to display "Yes" if the field value is 0 and "No" if the field value is 1 and "None" if field value is anything else in DataGrid. Where the datatype of field value is int in sql server database. How to convert it in the desired way. Thnx in Advance