.Net

Get Stored Procedure name by using table name in Sql Server

2011-12-26T01:54:00.000-08:00

Hello Friends,

Find the below two query for get Stored Procedure list by using table name.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Nameoftable%'
AND ROUTINE_TYPE='PROCEDURE'

SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE xtype = 'P' and c.TEXT LIKE '%Nameoftable%'

WCF hosting types

2011-08-05T04:39:00.000-07:00

Hello Friends,

Find the below link for different ways to host the WCF Service.

Click here

follow the all the step u will get it done.....

Enjoy wih WCF.

Create Windows Service

2011-07-08T06:18:00.000-07:00

Hello Friends,

Find the below link for create the windows service by using simple step.

Click here

happy coding...

Scheduling and Event Logging Windows Service

2011-06-16T06:22:00.000-07:00

Hello Guys,

Now u can create windows service with some easy step.
Also u create can "Scheduling Windows Service with Timer Control".

http://www.aspnetajaxtutorials.com/2008/01/create-windows-service-with-cnet-part-2.html

Create CSV file in Asp.Net

2011-06-16T06:09:00.000-07:00

Hello Friends,

U can create CSV file using below code.
Call below GetRecord() function in your button click event or wherver u need.
Folder name and file name will be get from .config file.

Sub GetRecord()
Dim dt As DataTable
Dim Id As Integer
Id = Convert.ToInt32(ConfigurationSettings.AppSettings("Id").ToString())
Dim ds As DataSet = SqlHelper.ExecuteDataset(sConnString, "Get_Record", Id)
Dim headers(ds.Tables(0).Columns.Count) As String
Dim cnt As Integer = 0
For Each column As DataColumn In ds.Tables(0).Columns
headers(cnt) = column.ColumnName
cnt = cnt + 1
Next
ExportCSV(ds, 0, headers)
End Sub

Sub ExportCSV(ByRef ds As DataSet, ByVal tableIndex As Int32, ByRef headers As String())
'Write out column headers
Dim headerOut As String = ""
If Not headers Is Nothing Then

For i As Integer = 0 To headers.Length - 2 'Don't do the last item yet
headerOut += headers(i)
headerOut += ","
Next
headerOut += headers(headers.Length - 1) 'Now do the last item, so you don't have a trailing comma.
'CSVWriter.WriteLine(headerOut)
End If
headerOut += Environment.NewLine

'Write out data
Dim CSVOut As String = ""
For Each r As DataRow In ds.Tables(tableIndex).Rows
For i As Integer = 0 To (ds.Tables(tableIndex).Columns.Count - 2) 'Don't do the last item yet
If Not IsDBNull(r(i)) Then
CSVOut += Chr(34)
CSVOut += CStr(r(i))
CSVOut += Chr(34)
End If
CSVOut += ","
Next
If Not IsDBNull(r(ds.Tables(tableIndex).Columns.Count - 1)) Then
CSVOut += CStr(r(ds.Tables(tableIndex).Columns.Count - 1)) 'Now do the last item, so you don't have a trailing comma.
End If
CSVOut += Environment.NewLine
'CSVWriter.WriteLine(CSVOut)
Next

Dim sFileName As String = ConfigurationSettings.AppSettings("FileName").ToString()
Dim dtTime As DateTime
dtTime = DateTime.Now()
Dim swOut As New StreamWriter(sADPOut + "\" + sFileName & "_" & dtTime.ToString.Replace("/", "").Replace(":", "") + ".csv")
swOut.Write(headerOut.ToString())
swOut.Write(CSVOut.ToString())
swOut.Flush()
swOut.Close()

End Sub

.CSV file will be save in specified folder.

Open div tag layer in Javascript

2009-12-06T23:12:00.000-08:00

Hello Friends

Please find the below javascript script for open the div base layer on the screen.

/*function showBox()
{
var width = document.documentElement.clientWidth + document.documentElement.scrollLeft;

var layer = document.createElement('div');
layer.style.zIndex = 2;
layer.id = 'layer';
layer.style.position = 'absolute';
layer.style.top = '0px';
layer.style.left = '0px';
if(document.documentElement.scrollHeight < 800 )
{
layer.style.height = 835 + 'px';
}
else
{
layer.style.height = document.documentElement.scrollHeight + 'px';
}

layer.style.width = width + 'px';
layer.style.backgroundColor = 'black';
layer.style.opacity = '.6';
layer.style.filter += ("progid:DXImageTransform.Microsoft.Alpha(opacity=60)");
document.body.appendChild(layer);

var div = document.createElement('div');
div.style.zIndex = 3;
div.id = 'box';
div.style.position = (navigator.userAgent.indexOf('MSIE 6') > -1) ? 'absolute' : 'fixed';
div.style.top = '200px';
div.style.left = (width / 2) - (400 / 2) + 'px';
div.style.height = '150px';
div.style.width = '500px';
div.style.backgroundColor = 'white';
div.style.border = '2px solid silver';
div.style.padding = '20px';
document.body.appendChild(div);

var a = document.createElement('div');
a.innerHTML = '';

div.appendChild(a);
var divSub = document.createElement('div');
divSub.innerHTML = '

Under Construction

';
div.appendChild(divSub);

}
function removelayer()
{
document.body.removeChild(document.getElementById('layer'));
document.body.removeChild(document.getElementById('box'));
};

Call the above script using
opendivlayer */

Add close.jpg image in your root directory.

Thanks & Regards
Jignesh Patel

Application folder in Asp.Net

2009-12-02T01:37:00.000-08:00

Hello Friends

Go through the below link for get good knowledge of application folder in Asp.Net.

http://www.codeproject.com/KB/aspnet/AspNetAppFolder.aspx

User Creation and Role Assignment in Dotnetnuke

2009-10-13T04:57:00.000-07:00

Hello Friends

Go through the below link for create user and role assignment in Dotnetnuke(DNN)

http://www.codeproject.com/KB/aspnet/DNNRolesnUser.aspx

Login in dotnetnuke

2009-10-08T04:35:00.000-07:00

Hello friends

You r in trouble with login in dotnetnuke web site.

So login in your DNN web site just add the "?ctl=login" in any page.

suppose your web site name is "http://www.test.com"

than u can login in that using "http://www.test.com/Default.aspx?ctl=login"

Increase dotnetnuke website performance

2009-10-01T06:03:00.000-07:00

Hello Guys

Go through below way for increase dotnetnuke web site performance

(1)If your DotnetNuke website is running slow. You can increase it’s performance by deleting it’s logs. To do that, please login to your dotnetnuke site as HOST. Then go to "Admin" --> "Log Viewer". Then in the log viewer page , "Delete all selected exceptions" and "Clear log" link at the bottom of page Clear all your logs will increase your dotnetnuke performance. Another faster way would be connecting to your Dotnetnuke db directly and run the following SQL command:

delete from eventlog;

(2)Extra caching (Not in the menu)

Although the above caching options let you decide if you want Dotnetnuke to offer caching there is something extra you can do. This will require you to edit your ascx skin files. Open your skinfile and add the following script:

Open popup in button click event

2009-09-22T20:35:00.000-07:00

Hello guys

Add below C# code in button click event.

StringBuilder sb = new StringBuilder();
sb.Append("");
System.Web.UI.ScriptManager.RegisterStartupScript(this.upnlStd, this.GetType(), "sb", sb.ToString(), false);

Add thumbnail in skin

2009-09-07T04:42:00.000-07:00

Hello Friends

Follow the below step for add thumbnail to skin and container in DNN.

Step 1: Suppose your project name is TestThumbnail.
Step 2: You have create skin in your project at the location TestThumbnail\Portals\_default\Skins\TitleBlue.ascx.
Step3 : Your skin name is TitleBlue.ascx. Now you need to add thumbnail at same location with same name.
means TestThumbnail\Portals\_default\Skins\TitleBlue.jpg.

After follow the step you can see the thumbnail in manage skin after login.

Change FCKeditor Default Font

2009-08-12T02:39:00.000-07:00

Hello Friends

If u want to change the default font in fck editory than change in below .css file.

File Location: fck\editor\css\fck_editorarea.css

Open up the fck_editorarea.css and look for:
below is the default setting.
body, td
{
font-family: Arial, Verdana, sans-serif;
font-size: 12px;
}

change in this and u will get the default setting according to that

Get Sql Server table structure and Data

2009-08-01T02:15:00.000-07:00

Hello friends

Download Microsoft SQL Server Database Publishing Wizard 1.1 using the below link and install it.
Go through it and u will get the script of Sql Server table and its data.

http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Thanks & Regards
Jignesh Patel

Remove default paragraph in FckEditor

2009-07-16T23:21:00.000-07:00

Hello Friends

When we work with Editor than it shows default text like "Here it shows blank space" in source...

Also when we press Enter than it will take Paragraph in place of break..

So find the solution using below step.
Step 1 : open the fckeditor/fckconfig.js file
Step 2 : Change in that

FCKConfig.EnterMode = 'br' ; // p | div | br
FCKConfig.ShiftEnterMode = 'p' ; // p | div | br

Step 3 : Save it and remove the cache,cookie,history and check...

Also this solution is work in Dotnetnuke...

Thanks & Regards
Jignesh Patel

Working with Math Equation Editor

2009-07-16T21:50:00.000-07:00

Hello friends

Please download the Editor using below link.

Click here to Download

Register fck editor in your page by using

<%@ Register Assembly="FredCK.FCKeditorV2" Namespace="FredCK.FCKeditorV2" TagPrefix="FCKeditorV2" %>

And use it by

Add downloded editor dll in Bin folder and paste FckEditor in your application.

For more detail click here

Enjoy with math equation editor....

Thanks & Regards
Jignesh Patel

Backup using Query in Sql Server

2009-07-13T22:05:00.000-07:00

Hello Guys

Execute the below query for create backup file.

EXEC sp_addumpdevice 'disk', 'MyBackupDevice', 'D:\Shared\MyBackup.bak'
BACKUP DATABASE Test TO MyBackupDevice

Here "D:\Shared\MyBackup.bak" is the path of the back up file.
"Test" is the name of database.

Execute it u will get the back up file at "D:\Shared\MyBackup.bak" location.

Thanks & Regards
Jignesh Patel

HTML Codes - Characters and symbols

2009-07-06T03:53:00.000-07:00

Hello Friends

You need a html codes for Characters and symbols.

Please go through to below link.

http://www.ascii.cl/htmlcodes.htm

Thanks & Regards
Jignesh Patel

Working with DotNetNuke

2009-06-18T02:26:00.000-07:00

Hello Friends

Below link is useful to work with Dotnetnuke.

Go through it step by step.

http://www.codeproject.com/KB/MCMS/DotNetNuke.aspx

Thanks & Regards
Jignesh Patel

Create module in Dotnetnuke

2009-06-18T02:21:00.000-07:00

Hello guys

Dotnetnuke is useful for CMS application.

Below link is useful to create module in Dotnetnuke application.

http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryId/1410/DotNetNuke-4-5-and-ASP-NET-AJAX.aspx

Thanks & Regards
Jignesh Patel

Control the Page Numbering in word document

2009-06-02T20:34:00.000-07:00

Hello friends

Here is the sample code using that u can set the page number starting from 5.

Microsoft.Office.Interop.Word._Application oWord oWord = new Microsoft.Office.Interop.Word.Application(); oWord.ActiveWindow.Selection.Sections[1].Headers[WdHeaderFooterIndex.wdHeaderFooterPrimary].PageNumbers.RestartNumberingAtSection = true;

oWord.ActiveWindow.Selection.Sections[1].Headers[WdHeaderFooterIndex.wdHeaderFooterPrimary].PageNumbers.StartingNumber = 5;

Thanks & Regards
Jignesh Patel

Create word document using FileStream

2009-06-01T00:39:00.000-07:00

Hello guys

U can create word document using FileStrem in C#.Net.

using System.IO;
using System.Text;

Public void CreateWordDoc()
{
string strFileName;
strFileName = Guid.NewGuid().ToString() + ".doc";
string strFilePath = Server.MapPath("NewFile/") + strFileName;
FileStream f = new FileStream(strFilePath, FileMode.Create);
StreamWriter s = new StreamWriter(f);

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "";

HttpContext.Current.Response.ContentType = "application/msword";

HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);

StringBuilder strHTMLContent = new StringBuilder();

HttpContext.Current.Response.ContentType = "application/msword";

HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + strFileName);
HttpContext.Current.Response.Charset = "";

System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

tbmMain.RenderControl(hw); //Where dv is div holding img with run at server
HttpContext.Current.Response.Write(tw.ToString());

// create a write stream

// write to the stream
string str=tw.ToString();
s.WriteLine(str);
s.Close();
f.Close();

}
Thanks & Regards
Jignesh Patel

Add blank page in word document using C#.Net

2009-05-22T00:11:00.000-07:00

Hello Friends

U can add blank page at particular page number in word document using below code.

object missing = System.Reflection.Missing.Value;
object fileName = @"D:\TestFile.docx";
object readOnly = false;
object isVisible = true;

//Start Word and open a document.
_Application oWord;
_Document oDoc;
oWord = new Application();
oWord.Visible = true;

oDoc = oWord.Documents.Open(ref fileName, ref missing, ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref isVisible, ref missing,
ref missing, ref missing, ref missing);

//Goto some specific page and insert a blank page or page break
object gotoPage = WdGoToItem.wdGoToPage;
object gotoNext = WdGoToDirection.wdGoToNext;
object gotoCount = null;
//Page Numer
object gotoName = "4";

oWord.Selection.GoTo(ref gotoPage, ref gotoNext, ref gotoCount, ref gotoName);

//Insert a blank page
oWord.Selection.InsertNewPage();

//Insert a page break
object breakPage = WdBreakType.wdPageBreak;
oWord.Selection.InsertBreak(ref breakPage);

Thanks & Regards
Jignesh Patel

Create Web Service in .Net

2009-05-19T22:45:00.000-07:00

Hello Friends

Here sample code for how to create web service and consume int in C#.Net.

Step 1 : Add new Web Service(.asmx) file using add New Item
Step 2 : Suppose i have add Operation.asmx file
Step 3 :Add namespace of web service
///

/// Summary description for Operation
///

[WebService(Namespace = "http://localhost:3870/ConnectMySql/Operation.asmx")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
Step 4 : Create Function using [WebMethod]
//[WebMethod]
public int Addition(int a,int b)
{
int c;
c = a + b;
return c;
}
Step 5: Now build the web site and web service is created.

Now for Consume Web Service Step

Step 6: Add web service referance to another site using right click on project and add web referance.
Enter web service url http://localhost:3870/ConnectMySql/Operation.asmx and add namespace name for exa. "localhost".
Step 7 : Now add Namespace in page by
using localhost
Step 8 : Create object of Operation Class
Operation obj = new Operation();
int a = obj.Addition(5,2)
Response.Write(a.ToString());

Thanks & Regards

Jignesh Patel

Create Random number in .Net

2009-05-15T02:34:00.000-07:00

You guys can create random number using below code up to 6 digit if u want to more than change in for loop.

public string CreateRandomCode()
{
string allChar = "0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z";
string[] allCharArray = allChar.Split(',');
string randomCode = "";
int temp = -1;

Random rand = new Random();
for (int i = 0; i < 6; i++)
{
if (temp != -1)
{
rand = new Random(i * temp * ((int)DateTime.Now.Ticks));
}
int t = rand.Next(36);
if (temp != -1 && temp == t)
{
return CreateRandomCode(codeCount);
}
temp = t;
randomCode += allCharArray[t];
}
return randomCode;
}

Thanks & Regards
Jignesh Patel

Bind Treeview in .Net

2009-05-15T00:39:00.001-07:00

Hello friends

Here the code for bind treeview up to four level.In this example i have bind Subject-->SubSubject-->Chapter-->Topic.

#region BIND TREE VIEW NODE

#region BIND Subject
private void BindMaterial()
{

strQuery = "SELECT Subject,SubjectId FROM V_GetStudentMaterial GROUP BY Subject,SubjectId ";

DataTable dtMaterial;
dtMaterial = ObjB.SelectMaterial(strQuery);
if(dtMaterial.Rows.Count>0)
{
tvMaterail.Nodes.Clear();
for (int iTreeSubject = 0; iTreeSubject < dtMaterial.Rows.Count; iTreeSubject++)
{
TreeNode SubjectNode = new TreeNode();
SubjectNode.Text = FormatStrDecode(dtMaterial.Rows[iTreeSubject]["Subject"].ToString());
SubjectNode.Value = dtMaterial.Rows[iTreeSubject]["SubjectId"].ToString();
SubjectNode.ToolTip = FormatStrDecode(dtMaterial.Rows[iTreeSubject]["Subject"].ToString());
SubjectNode.Expand();
//Bind Subject
tvMaterail.Nodes.Add(SubjectNode);
int intTreeSubjectId = int.Parse(SubjectNode.Value.ToString());
BindSubSubjectNodes(SubjectNode, intTreeSubjectId);
}
trMaterial.Visible = true;
lblMessage.Text = "";
}
else
{
lblMessage.Text = ReadXMLFile_Admin(FormName.Topic, Task.Materialnotfound);
trMaterial.Visible = false;
}

}
#endregion

#region BIND SUB SUBJECT NODE
private void BindSubSubjectNodes(TreeNode ParentSubjectNode, int intTreeSubjectId)
{
try
{
strQuery = "";
strQuery = "SELECT Subject,SubjectId,SubSubject,SubSubjectId FROM V_GetStudentMaterial WHERE SubjectId=" + intTreeSubjectId + " GROUP BY Subject,SubjectId,SubSubject,SubSubjectId";
DataTable dtSubSubject;
dtSubSubject = ObjB.SelectMaterial(strQuery);
if (dtSubSubject.Rows.Count > 0)
{
for (int intiSubSubject = 0; intiSubSubject < dtSubSubject.Rows.Count; intiSubSubject++)
{
TreeNode SubSubjectNode = new TreeNode();
SubSubjectNode.Text = dtSubSubject.Rows[intiSubSubject]["SubSubject"].ToString();
SubSubjectNode.Value = dtSubSubject.Rows[intiSubSubject]["SubSubjectId"].ToString();
SubSubjectNode.ToolTip = FormatStrDecode(dtSubSubject.Rows[intiSubSubject]["SubSubject"].ToString());
//Bind Sub Subject
ParentSubjectNode.ChildNodes.Add(SubSubjectNode);
int intSubSubjectId = int.Parse(SubSubjectNode.Value.ToString());
BindChildChapter(SubSubjectNode, intSubSubjectId);
ParentSubjectNode.Collapse();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

#region BIND SUB SUBJECT CHAPTER NODE
private void BindChildChapter(TreeNode ParentSubSubjectNode, int intTreeSubSubjectId)
{
try
{
strQuery = "";
strQuery = "SELECT Subject,SubjectId,SubSubject,SubSubjectId,ChapterId,ChapterName FROM V_GetStudentMaterial WHERE SubSubjectId=" + intTreeSubSubjectId + " GROUP BY Subject,SubjectId,SubSubject,SubSubjectId,ChapterId,ChapterName";
DataTable dtChapter;
dtChapter = ObjB.SelectMaterial(strQuery);
if (dtChapter.Rows.Count > 0)
{
for (int intiChapter = 0; intiChapter < dtChapter.Rows.Count; intiChapter++)
{
TreeNode ChapterNode = new TreeNode();
ChapterNode.Text = dtChapter.Rows[intiChapter]["ChapterName"].ToString();
ChapterNode.Value = dtChapter.Rows[intiChapter]["ChapterId"].ToString();
ChapterNode.ToolTip = FormatStrDecode(dtChapter.Rows[intiChapter]["ChapterName"].ToString());
//Bind Chapter
ParentSubSubjectNode.ChildNodes.Add(ChapterNode);
int intChapterId = int.Parse(ChapterNode.Value.ToString());
BindChildChapterTopic(ChapterNode, intChapterId);
ParentSubSubjectNode.Collapse();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

#region BIND CHAPTER TOPIC NODE
private void BindChildChapterTopic(TreeNode ParentChapterNode, int intTreeChapterId)
{
try
{
strQuery = "";
strQuery = "SELECT Subject,SubjectId,SubSubject,SubSubjectId,ChapterId,ChapterName,TopicId,Topic FROM V_GetStudentMaterial WHERE ChapterId=" + intTreeChapterId + " GROUP BY Subject,SubjectId,SubSubject,SubSubjectId,ChapterId,ChapterName,TopicId,Topic";
DataTable dtTopic;
dtTopic = ObjB.SelectMaterial(strQuery);
if (dtTopic.Rows.Count > 0)
{
for (int intiTopic = 0; intiTopic < dtTopic.Rows.Count; intiTopic++)
{
TreeNode ChapterNode = new TreeNode();
ChapterNode.Text = dtTopic.Rows[intiTopic]["Topic"].ToString();
ChapterNode.Value = dtTopic.Rows[intiTopic]["TopicId"].ToString();
ChapterNode.ToolTip = "Click here to view " + FormatStrDecode(dtTopic.Rows[intiTopic]["Topic"].ToString());
ChapterNode.NavigateUrl = "ContentDetail.aspx?TopicId=" + dtTopic.Rows[intiTopic]["TopicId"].ToString();
//Bind Topic
ParentChapterNode.ChildNodes.Add(ChapterNode);
ParentChapterNode.Collapse();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

#endregion

Thanks & Regards
Jignesh Patel

Add an Image in Word Document using .Net

2009-05-14T05:03:00.000-07:00

Hello friends

Using the sample code u can add image in word document.

//Insert Image
string strSiteURL ="www.url.com"
object oRngHeader;
Microsoft.Office.Interop.Word.Paragraph oParaHeader;

oRngHeader = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
oParaHeader = oDoc.Content.Paragraphs.Add(ref oRngHeader);

wrdSelection = oWord.Selection;
wrdSelection.TypeText(oParaHeader.Range.Text);

string strObjHeaderFile = strSiteURL + "images/Logo.jpg";
Object oAnsHeader = oParaHeader.Range;

//oParaHeader.Format.SpaceAfter = 1;

oParaHeader.Format.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;
oParaHeader.Application.Selection.InlineShapes.AddPicture(strObjHeaderFile, ref o_missvalue, ref o_missvalue, ref oRngHeader);

Thanks & Regards
Jignesh Patel

Create Word Document in .Net

2009-05-14T04:51:00.000-07:00

Hello

You can create word document with page number in footer
using below code.

using System.Reflection;
using Microsoft.Office.Interop.Word;
private void CreateDocument()
{

object oMissing = System.Reflection.Missing.Value;
object oEndOfDoc = "\\endofdoc"; /* \endofdoc is a predefined bookmark */

//Start Word and create a new document.
Microsoft.Office.Interop.Word._Application oWord;

Microsoft.Office.Interop.Word._Document oDoc;

oWord = new Microsoft.Office.Interop.Word.Application();

oWord.Visible = false;

oDoc = oWord.Documents.Add(ref oMissing, ref oMissing, ref oMissing, ref oMissing);

//Add Border
oDoc.ActiveWindow.Selection.Borders[WdBorderType.wdBorderBottom].LineStyle = WdLineStyle.wdLineStyleDot;
oDoc.ActiveWindow.Selection.Borders[WdBorderType.wdBorderLeft].LineStyle = WdLineStyle.wdLineStyleDot;
oDoc.ActiveWindow.Selection.Borders[WdBorderType.wdBorderRight].LineStyle = WdLineStyle.wdLineStyleDot;
oDoc.ActiveWindow.Selection.Borders[WdBorderType.wdBorderTop].LineStyle = WdLineStyle.wdLineStyleDot;

oDoc.PageSetup.PaperSize = Microsoft.Office.Interop.Word.WdPaperSize.wdPaperA4;
oDoc.PageSetup.LayoutMode = WdLayoutMode.wdLayoutModeLineGrid;
oDoc.PageSetup.PageWidth = oWord.InchesToPoints(7F);
oDoc.PageSetup.PageHeight = oWord.InchesToPoints(14F);

//Insert a paragraph at the beginning of the document.
Microsoft.Office.Interop.Word.Paragraph oPara1;
object oRngHed;
oRngHed = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
oPara1 = oDoc.Content.Paragraphs.Add(ref oMissing);
//Assign text
oPara1.Range.Text = "This is test for create word document";
oPara1.Format.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;
oPara1.Range.Font.Bold = 10;
oPara1.Range.Font.Size = 18;
//oPara1.Format.SpaceAfter = 2; //24 pt spacing after paragraph.
oPara1.Range.InsertParagraphAfter();

string strFileName;
strFileName = Guid.NewGuid().ToString() + ".doc";
object o_filename = Server.MapPath("NewFile/") + strFileName;
object o_format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatEncodedText;
object o_endings = Microsoft.Office.Interop.Word.WdLineEndingType.wdCRLF;
object o_null = Missing.Value;

oDoc.PageSetup.TopMargin = oWord.MillimetersToPoints(14.17F);
oDoc.PageSetup.BottomMargin = oWord.MillimetersToPoints(14.17F);
oDoc.PageSetup.RightMargin = oWord.MillimetersToPoints(14.17F);
oDoc.PageSetup.LeftMargin = oWord.MillimetersToPoints(14.17F);

oWord.ActiveWindow.ActivePane.View.SeekView = WdSeekView.wdSeekCurrentPageFooter;

//ENTERING A PARAGRAPH BREAK "ENTER"

oWord.Selection.TypeParagraph();

//INSERTING THE PAGE NUMBERS CENTRALLY ALIGNED IN THE PAGE FOOTER

//string docNumber = "1";

//string revisionNumber = "0";

oWord.Selection.Paragraphs.Alignment = WdParagraphAlignment.wdAlignParagraphLeft;

oWord.ActiveWindow.Selection.Font.Name = "Arial";

oWord.ActiveWindow.Selection.Font.Size = 8;

// oWord.ActiveWindow.Selection.TypeText("Document #: " + docNumber + " " + revisionNumber);

//INSERTING TAB CHARACTERS

oWord.ActiveWindow.Selection.TypeText("");

oWord.ActiveWindow.Selection.TypeText("");

oWord.ActiveWindow.Selection.TypeText("Page ");

object CurrentPage = WdFieldType.wdFieldPage;

string str;
str = oWord.Selection.HeaderFooter.PageNumbers.Count.ToString();
oWord.ActiveWindow.Selection.Fields.Add(oWord.Selection.Range, ref CurrentPage, ref oMissing, ref oMissing);

oWord.ActiveWindow.Selection.TypeText(" of ");

object TotalPages = WdFieldType.wdFieldNumPages;

// oWord.ActiveWindow.Selection.Fields.Add(oWord.Selection.Range, ref TotalPages, ref oMissing, ref oMissing);

//SETTING FOCUES BACK TO DOCUMENT

oWord.ActiveWindow.ActivePane.View.SeekView = WdSeekView.wdSeekMainDocument;
oWord.Selection.TypeParagraph();

oWord.Selection.Font.Bold = 1;

oWord.Selection.Font.Color = WdColor.wdColorAqua;

oWord.Selection.Font.Italic = 1;

oWord.Selection.Font.Underline = WdUnderline.wdUnderlineDashHeavy;
oWord.Selection.ClearFormatting();

oDoc.SaveAs(ref o_filename, ref o_format, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_null, ref o_endings, ref o_null);

//Assign null value to created object
oDoc = null;
oWord.Quit(ref o_null, ref o_null, ref o_null);
//For Open file
Response.Redirect("NewFile/" + strFileName);
}

if u have any query than send it.

Thanks & Regards
Jignesh Patel