1) Select the Word file that you want to covert.
2) Open Office Infopath and select “Import a Form…” link.
3) Select “InfoPath importer for Word documents”.
4) Browse the Word file that you want to import. To set the Import options click Options button.
5) In Import Options dialog box, select appropriate Layout as per you requirement.
6) After successfully Importing Office Word file, Import Wizard displays the message.
7) Now your Office Word is successfully imported to Office Infopath.
To import an Office Excel, follow same steps, except select “InfoPath importer for Word documents” instead of “InfoPath importer for Word documents”.
SQL Script to enable/disable foreign key constraints:
ReplyDeletedeclare @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
ReplyDeleteprivate string ReplaceNumbersInString(string strSource)
{
string result = System.Text.RegularExpressions.Regex.Replace(strSource, @"[0-9]", "");
return result;
}
Function to return all numbers from a string
ReplyDeleteprivate string ReturnNumbersFromString(string strSource)
{
string result = System.Text.RegularExpressions.Regex.Replace(strSource, @"[^\d]*", "");
return result;
}
To enable the constraints replace "nocheck" with "check"
ReplyDelete