Hi, I need to execute a xoml workflow periodically using windows service. can anyone give me solution for this.

Hi, I have a view. i want to get the columns in a view along with its database and servername. For example, Employee table resides in CSCEmp server's Emp database. I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table. When i list view information, i want to display like view view'sserver Columnname column'sServer EMPView CSCDet EmpName CSCEmp Is there a way to do like this. Thanks.

Hi all, I've two Datagridview controls. Each grid has different datasources. Eg. Datasource of grid1 is Hastable. Datasource of Grid1 is datatable. i want to display all the columns in both gridcontrol in the same order. Eg if Grid1 has columns in the order like Name,Age,DOB,SAL and i want the same order in grid2 also. i'm trying to set displayindex. but it's not displaying in the same order.and also want to add Scrollbars if necessary. Everything has to be done programatically. can anyone help me? thanks in advance sri

Hi all I have to Create a DLL dynamically in C#. I dont know how Can i Create it dynamicaaly. Can anyone tell me the solution for this. Thanks in advance sri

Hi, I'm trying to create a trigger for a table which has a column of type TEXT. While executing Trigger Statement, It shows a message stating that " can't use text field in inserted/deleted table". Can anyone give me the solution for this problem? Thanks in advance sri

Hi I've a Table Table1.And it's structure is RoleID RoleDescription Department 1 Manager Accounts 2 Senior Manager Finance and I want to have a Table like Columnname Columnvalue Date RoleID 1 2/5/2008 RoleDescription Manager 2/5/2008 Department Accounts 2/5/2008 RoleID 2 2/5/2008 RoleDescription Senior Manager 2/5/2008 Department Finance 2/5/2008 Can anyone tell how? thanks in advance Sri

Hi, I have One SP in Sql Server 2005.In that SP i need to get the IP number of the Local System. Can anyone tell me How? thanks in Advance sri

Hi, I want to Refer two tables in fuzzy lookup component.I have to map incoming Columns with more than one reference table's column. can anyone tell how can i achieve this? Thanks in advance shsri

Hi I have a table with columns like Table1: 1.ID as int 2.TableID as int 3.ColumnName Varchar(50) 4.ColumnValue Varchar(50) Here TableID is not unique.I want to create a new table. Each ColumnName value of Table1 should become Column of New Table. Each ColumnValue should become the row value of corresponding column. Table1 values: ID TableID ColumnNAme ColumnValue 1 1 FirstNAme Javio 2 1 LastName Choprakhush 3 1 DateOfBirth 13/09/1986 4 1 Phone 6222226779 And i want to create a table like this FirstName LastNAme DateOfBirth Phone JAvio Choprashush 13/09/1986 6222226779 Can anyone Help ME? Thanks in advance sri

Hi I have developed an SSIS package in Business Intelligence Development studio. It Works in BI and returns result. When I attempt to execute the package programmatically from a .net Windows Form application the follow DtsError is returned: "The product level is insufficient for component \"Fuzzy Lookup\" (497).\r\n" Can anyone Help me? Thanks and regards Sri

Hi all, I've created a SSIS package and Loaded using C# windows application.I've imported configuration file also. but while exexute that loaded package it returns failure result. I dont know why? But it's working with BI and returns the result successfully. package.Execute() returns failure. Can anyone tell me how can i solve this issue? i have placed the code which i have used in my application. Application app = new Application(); Package package = app.LoadPackage("c:\\Example.dtsx", null); package.ImportConfigurationFile("c:\\Example.dtsConfig"); Variables vars = package.Variables; vars["Name"].Value = name.text.trim(); DTSExecResult result = package.Execute(); Console.WriteLine("Package Execution results: {0}",result.ToString());

Hi i have the situation to fetch similar values using fuzzy lookup. here i dont know how to pass variables which contains input values[comes from my application] to the fuzzy look up without using datasource. Can anyone tell how? thanks in advance sari

Hi I have created a Trigger Statement and assigned to CommandText property of sqlCommand.While Try to Execute using command.ExecuteNonQuery() it throws an exception like {"Incorrect syntax near the keyword 'TRIGGER'."} Created Trigger Statement: CREATE TRIGGER SampleTrigger ON dbo.sample AFTER INSERT AS begin SET NOCOUNT ON DECLARE @Name AS nvarchar(50) SELECT @Name= i.Name from inserted i DECLARE @Address AS nvarchar(50) SELECT @Address= i.Address from inserted i insert into triggertest(statusID,FieldName,FieldValue) values( 25,'Name',@Name) insert into triggertest(statusID,FieldName,FieldValue) values( 25,'Address',@Address) end Can anyone help me? Thanks in advance Sri

Hi I have created a Trigger Statement and assigned to CommandText property of sqlCommand.While Try to Execute using command.ExecuteNonQuery() it throws an exception like {"Incorrect syntax near the keyword 'TRIGGER'."} Created Trigger Statement: CREATE TRIGGER SampleTrigger ON dbo.sample AFTER INSERT AS begin SET NOCOUNT ON DECLARE @Name AS nvarchar(50) SELECT @Name= i.Name from inserted i DECLARE @Address AS nvarchar(50) SELECT @Address= i.Address from inserted i insert into triggertest(statusID,FieldName,FieldValue) values( 25,'Name',@Name) insert into triggertest(statusID,FieldName,FieldValue) values( 25,'Address',@Address) end Can anyone help me? Thanks in advance Sri

Hi folks, I want to create a trigger using C# and execute using ExecutenonQuery.I can have TableName on which i've to Create a trigger at Runtime. I need to Create a trigger for both insert and update.Can anyone help me? Appreciate any help. Thanks in advance sri

Hi, I Have two tables. Table1 has the following columns: TableID FieldID FieldName FieldValue DateAdded and Table2 has the following Columns FieldID TableID Dataadded And I want to display Each FieldName as a Column name for Dridview control and FieldValue as Value for each column. How can i form SELECT Statement To Achieve this ? Thanks in advance sri

Hi, I Have two tables. Table1 has the following columns: TableID FieldID FieldName FieldValue DateAdded and Table2 has the following Columns FieldID TableID Dataadded And I want to display Each FieldName as a Column name for Dridview control.How can i form SELECT Statement To Achieve this ? Thanks in advance sri

Hi, I want to disply each row of datasource as a column of gridview control in C# windows form. I'n new to this. can anyone help me? thanks in advance regards sri

Hi all, I want to validate a given mailAddress whether it exists in that domain or not.Can anyone help me to do this? thanks in advance sri

Hi i've a combobox in which i have to show all the available servers(sql,oracle,etc). if i use SQLDataSourceEnymerator it shows SQL server only.but i need to list oracle,oledb,etc. can anyone help me? thanks in advance shri