TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mittal Joshi
NA
34
0
word reporting...or dynamic reporting....
Oct 3 2009 1:40 AM
I have a code for word reporting in vb.net as below.but i want this code in c#.net.i have converted it through vb to c# converter,but it didnt work properly...can somebody help me out?
myword = CreateObject(
"word.application"
)
mydoc = myword.Documents.Add
myword.Selection.PageSetup.PaperSize = Word.WdPaperSize.wdPaperA4
myword.Selection.PageSetup.Orientation = Word.WdOrientation.wdOrientPortrait
myword.Selection.PageSetup.RightMargin = 10
myword.Selection.PageSetup.TopMargin = 50
myword.Selection.PageSetup.LeftMargin = 50
myword.Selection.PageSetup.BottomMargin = 50
myword.Visible =
True
myword.WindowState = Word.WdWindowState.wdWindowStateMaximize
myword.Activate()
myword.Selection.TypeText(newline + newline)
myword.Selection.Font.Bold =
True
myword.Selection.Font.Name =
"Arial"
myword.Selection.Font.AllCaps.ToString()
myword.Selection.Font.Size = 12
myword.Selection.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
myword.Selection.TypeText(
"Company Name"
+ newline + newline)
myword.Selection.Font.Size = 10
myword.Selection.TypeText(
" Available Stock "
+ newline + newline)
myword.Selection.Font.Underline = Word.WdUnderline.wdUnderlineNone
myword.Selection.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft
Try
query1 =
"select ItemId,Item_Name,Quantity,QtyType from ItemMaster "
If
con1.State = ConnectionState.Open
Then
con1.Close()
con1.Open()
cmd =
New
OleDbCommand(query1, con1)
adp =
New
OleDbDataAdapter(cmd)
ds =
New
DataSet
adp.Fill(ds)
Dim
s
As
Integer
= ds.Tables(0).Rows.Count + 1
Dim
t
As
Integer
= 2
dr1 = cmd.ExecuteReader()
myword.Selection.Font.Bold =
False
mytable = myword.Selection.Tables.Add(myword.Selection.Range, s, 3)
mycols = mytable.Columns
mytable.Borders.Enable =
True
mycell = mytable.Cell(1, 1) : mycell.Select()
myword.Selection.Font.Bold =
True
mycell.SetWidth(200, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
myword.Selection.TypeText(
"Item_Name"
)
mycell = mytable.Cell(1, 2) : mycell.Select()
myword.Selection.Font.Bold =
True
mycell.SetWidth(100, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
myword.Selection.TypeText(
"Quantity"
)
mycell = mytable.Cell(1, 3) : mycell.Select()
myword.Selection.Font.Bold =
True
mycell.SetWidth(100, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
myword.Selection.TypeText(
"Type"
)
While
dr1.Read
If
t <= s
Then
mycell = mytable.Cell(t, 1) : mycell.Select()
mycell.SetWidth(200, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.TypeText(IIf(IsDBNull(dr1.Item(1)),
"-"
, dr1.Item(1)))
mycell = mytable.Cell(t, 2) : mycell.Select()
mycell.SetWidth(100, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.TypeText(IIf(IsDBNull(dr1.Item(2)),
"-"
, dr1.Item(2)))
mycell = mytable.Cell(t, 3) : mycell.Select()
mycell.SetWidth(100, Word.WdRulerStyle.wdAdjustSameWidth)
myword.Selection.TypeText(IIf(IsDBNull(dr1.Item(3)),
"-"
, dr1.Item(3)))
t = t + 1
End
If
End
While
con1.Close()
Catch
e1
As
Exception
MsgBox(e1.Message, MsgBoxStyle.Critical,
"oledb Error"
)
End
Try
Reply
Answers (
3
)
Launch Application FROM PC1(located in Brazil), on Execute on PC2(located in USA).
How to get the value of a Enumeration Item?