Hi Resource based application is one of the best solution for Multilingual Applications. Don’t bother about back-end, just convert the field types Char to Nchar and Varchar to Nvarchar, then it supports any type of languages. Chandru

Try this one : 445 (microsoft-ds) 139 (netbios-ssn)

majidbhutta wrote: I want to make this script a Stored Procedure so as i may be able to call it from my Application You don't have to make a SQL Script a Stored procedure in order to run if from a C# application. Any SQL can be put in the CommandText propery of a SqlCommand. majidbhutta wrote: Should i be to remove all go Statements or anything else in sql Script. The GO is not SQL. It is a pre-processor command to Query Analyzer to tell it where to split the script into batches. When Query Analyzer encounters a GO while processing CREATE PROCEDURE statment it treats it as the end of the stored procedure. Everything after the GO will be in a new batch and not the stored procedure - That is likely to be the cause of the error. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

If you're asking how to automatically get scrollbars to some control, look at System.Windows.Forms.ScrollableControl. When some control added to a ScrollableControl extends beyond the visible portion of the ScrollableControl, scrollbars will automatically appear. Tech, life, family, faith: Give me a visit. I'm currently blogging about: Connor's Christmas Spectacular! Judah Himango

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

Is it possible that this is a permissions problem? The user that executes the C# code, do they have execute permissions on the function? Chris Meech I am Canadian. [heard in a local bar] Remember that in Texas, Gun Control is hitting what you aim at. [Richard Stringer] Nice sig! [Tim Deveaux on Matt Newman's sig with a quote from me]

Eg : CREATE FUNCTION dbo.udf_IsShiftValid(@StartTime datetime, @EndTime datetime,@DayTime datetime) RETURNS INT AS BEGIN DECLARE @RET AS INT IF (convert(varchar,@EndTime,114) < convert(varchar,@DayTime,114) ) AND (convert(varchar,@DayTime,114) > convert(varchar,@StartTime,114) ) SET @RET=1 ELSE SET @RET=0 RETURN @RET END Please have a look at this URL also. http://www.databasejournal.com/features/mssql/article.php/3348181[^] -- modified at 12:47 Friday 2nd December, 2005

You can change your times to milliseconds since midnight and compare those. CREATE FUNCTION MillisecondsSinceMidnight ( @in DATETIME ) RETURNS INTEGER AS BEGIN DECLARE @retval INTEGER SET @retval = DATEPART(ms,@in) + DATEPART(ss,@in) * 1000 + DATEPART(mi,@in) * 60000 + DATEPART(hh,@in) * 3600000 RETURN @retval END

If minute level precision is fine then save the number of minutes and use int as datatype. Declare @dt1 datetime, @dt2 datetime Set @dt1 = GetDate() Set @dt2 = DateAdd(yyyy, 1, @dt1) select DATEDIFF(mi, @dt1, @dt2) Farhan Noor Qureshi if (this == this) thow this;

Use something like, 1. Insert Into Emp_Info............ 2. Store newly created auto generated id in a local variable as, Select @newId = @@IDENTITY 3. Insert Into Emp_Experience....... and use @newId as fk here Farhan Noor Qureshi if (this == this) thow this;

Just use the Save method of the Image class. PicBox.Image.Save(stream, ImageFormat.Jpeg); --- b { font-weight: normal; }

When you inherit a class all your base private members ar hidden. You can not inherit only certain memberber... Here are some possible resolutions for your problem : 1) make a base constuctor that allows you to specify the hiding of certain controls. Let's say you have a form (F1) with a button. The form which inherits F1 can call a base constuctor to specify this : // The base class public class F1 : ... { ... System.Windows.Forms.Button button1 = new System.Windows.Form.Button(); ... // Here is your standar .ctor public F1() { ... // Initialize the form in what ever wy you desire ... } // Here is the .ctor that hides the button public F1(bool hideButton) : this() { button1.Visible = hideButton; } ... } // The derived class public class F2 : F1 { ... public F2 : base(true) { // initialize the form normaly } ... } Build in the base class an accesor that let's you change the state of certain controls (ie. the visible property of a button as in the previous example) // The base class public class F1 : ... { ... System.Windows.Forms.Button button1 = new System.Windows.Form.Button(); ... public SetButtonVisibility { get { return button1.Visible; } set { button1.Visile = value; } } // Here is your standar .ctor public F1() { ... // Initialize the form in what ever wy you desire ... } ... } // The derived class public class F2 : F1 { ... public F2 : base(true) { SetButtonVisibility = false; // same as base.SetButtonVisibility = false; // initialize the form normaly } ... } I hope you understand...because is a rough world out there...

use the bit datatype. The only values for bit are 1 and 0. To convert case when bitfield = 1 then 'yes' else 'no end "People who never make mistakes, never do anything." My Blog

In the DataGrid? An ASP.NET DataGrid? o a Windows Forms DataGrid? In any case, you can set a Format or FormatExpression property for the column (in your app, not in the database). Set the format to "D" to use the long date pattern. See here[^] -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog! The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Every Control that you add to a container such as a TabPage has a Name property.

string\[\] names = new string\[this.Controls.Count\]; int i = 0; foreach (Control c in this.Controls) { names\[i\] = c.Name; i++; } ------------------------------ "The Soapbox has been so ..."