Seemant

> I have a one textbox on the form and combo1 in datagridview > when form is load combo1 is empty > if value of text1.text is 'A' > then combo1 should have below items. combo1.Items.Clear(); combo1.Items.Add("Director"); combo1.Items.Add("MD"); combo1.Items.Add("President"); combo1.Items.Add("Chairman"); combo1.Items.Add("FullTimeDir"); > and > if value of text1.text is 'B' …

[QUOTE=MJV;821086]I have a stored procedure which returns a parameter @quotenum when run in sql but I'm having trouble getting a return value in my C# form. I'm trying to get the message box to show the @quoteno parameter but im failing misserably. The connection is working an the parameter @estnum …

You need to declare the variable. [code]Declare @localized_string_AddRole_Failed Nvarchar(4000) set @localized_string_AddRole_Failed = N'Failed adding the ''state_persistence_users'' role' DECLARE @ret int, @Error int IF NOT EXISTS( SELECT 1 FROM [dbo].[sysusers] WHERE name=N'state_persistence_users' and issqlrole=1 ) BEGIN EXEC @ret = sp_addrole N'state_persistence_users' SELECT @Error = @@ERROR IF @ret <> 0 or @Error …

As you give the information in the table you can find it by:- [code=sql]select * from Test as t1 where 0=(select count(*) from Test as t2 where t1.Year<t2.Year)[/code]