Converting Office Word and Office Excel Forms to Office InfoPath
Ways to convert an Office Word to Office Infopath---
1) Select the Word file that you want to covert.
4) Browse the Word file that you want to import. To set the Import options click Options button.
6) After successfully Importing Office Word file, Import Wizard displays the message.
7) Now your Office Word is successfully imported to Office Infopath.
4 comments:
SQL Script to enable/disable foreign key constraints:
declare @i int, @rc int, @sql varchar(250)
create table #temp (id int identity, table_name nvarchar(128), constraint_name nvarchar(128))
insert into #temp
select object_name(fkeyid) , object_name(constid)
from sysreferences where rkeyid = object_id('YourTableNameHere')
set @rc = @@rowcount
set @i = 1
while @i <= @rc
begin
select @sql = 'alter table ' + table_name + ' nocheck constraint all ' from #temp where id = @i
exec (@sql)
set @i = @i + 1
end
drop table #temp
Function to replace all numbers from a string
private string ReplaceNumbersInString(string strSource)
{
string result = System.Text.RegularExpressions.Regex.Replace(strSource, @"[0-9]", "");
return result;
}
Function to return all numbers from a string
private string ReturnNumbersFromString(string strSource)
{
string result = System.Text.RegularExpressions.Regex.Replace(strSource, @"[^\d]*", "");
return result;
}
To enable the constraints replace "nocheck" with "check"
Post a Comment