.NET (Core and Framework)

Re: Export to MS Word form MS access database or Datagridview

29-Jan-09 1:28

How Export to MS Word form MS access database or Datagridview

Eddy Vluggen29-Jan-09 1:57

Eddy Vluggen

29-Jan-09 1:57

Create a report in MSAccess, open it, and export it as RTF Cool | :cool:

I are troll Smile | :)

Re: Export to MS Word form MS access database or Datagridview

ivo7529-Jan-09 2:04

Re: Export to MS Word form MS access database or Datagridview

29-Jan-09 2:04

But I want to make this in VB.NET 2008 and when click button

EliottA29-Jan-09 5:20

EliottA

29-Jan-09 5:20

put the code in the button_click event Smile | :)

Re: Export to MS Word form MS access database or Datagridview

ivo7529-Jan-09 7:59

Re: Export to MS Word form MS access database or Datagridview

29-Jan-09 7:59

What's the code I know that put the code Laugh | :laugh:

ivo7529-Jan-09 8:03

Harddisk Serial Number using VB.net

29-Jan-09 8:03

OK I put the code, code is
Private Sub Export_Word()
Dim oWord As Word.Application
Dim oDoc As Word.Document
oWord = New Word.Application
oDoc = New Word.Document

oWord = CreateObject("Word.Application")
oWord.Visible = True
oDoc = oWord.Documents.Add
oDoc.ActiveWindow.Selection.Tables.Add(Range:=oDoc.ActiveWindow.Selection.Range, NumRows:=DataGridView1.RowCount, NumColumns:=3)
'numcolumns:= has to be customized

'Create headers
oDoc.Tables(1).Columns(1).Cells(1).Range.Text = "Име на работник"
oDoc.Tables(1).Columns(1).Cells(1).Range.Font.Bold = True
oDoc.Tables(1).Columns(1).Cells(1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
oDoc.Tables(1).Columns(1).Width = 220
oDoc.Tables(1).Columns(2).Cells(1).Range.Text = "Обект"
oDoc.Tables(1).Columns(2).Cells(1).Range.Font.Bold = True
oDoc.Tables(1).Columns(2).Cells(1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
oDoc.Tables(1).Columns(3).Cells(1).Range.Text = "Дата на работа"
oDoc.Tables(1).Columns(3).Cells(1).Range.Font.Bold = True
oDoc.Tables(1).Columns(3).Cells(1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter
oDoc.Tables(1).Columns(3).Width = 80

'etc.
Dim i As Integer
'Export data
i = 2
oDoc.Tables(1).Columns(1).Cells.Add()
For Each row In DataGridView1.Rows
oDoc.Tables(1).Columns(1).Cells(i).Range.Text = row.Cells(0).Value
oDoc.Tables(1).Columns(2).Cells(i).Range.Text = row.Cells(1).Value
oDoc.Tables(1).Columns(3).Cells(i).Range.Text = row.Cells(2).Value
'etc.
i = i + 1
Next
End Sub

VikashGohil28-Jan-09 21:51

VikashGohil

28-Jan-09 21:51

Hello,

I want to find the harddisk serial number,(not volume serial) using VB.net

CAn anyone guide me or give some link for help,

Any help would be appreciated.

Thank You.

«_Superman_»28-Jan-09 22:23

«_Superman_»

28-Jan-09 22:23

Check out these 2 links.

http://www.codeproject.com/KB/cs/hard_disk_serialno.aspx[^]
http://www.vbgold.com/vb-projects/disk-serial-number.shtml[^]

«_Superman_»

VikashGohil29-Jan-09 1:09

VikashGohil

29-Jan-09 1:09

Thanks For your reply,

I have found a code in VB which when run in Administrator Login works perfectly and gives me the Serial No.

But when i run the same code under normal or Limited User, The code does not give the Serial No.

I have gone through the code to find the difference, this is where i found the difference,

SmartOpen = CreateFile("\\.\PhysicalDrive" & CStr(drvNumber), _
GENERIC_READ Or GENERIC_WRITE, _
FILE_SHARE_READ Or FILE_SHARE_WRITE, _
ByVal 0&, _
OPEN_EXISTING, _
0&, _
0&)

The CreateFile function returns a value >0 in Admin Mode but in User Mode it returns -1.

Can any one please tell me what exactly is happening in the above code and what does this CreateFile Function do.

Please , it's Urgent.

Thanks in Advance,

«_Superman_»29-Jan-09 1:43

«_Superman_»

29-Jan-09 1:43

CreateFile is a Windows API that is used to open several kinds of devices like files, folders, COM ports, pipes, mailslots etc.

It can also open a physical disk drive or volume like in the example you have posted.
The MSDN documentation for CreateFile clearly states that opening a physical disk is dangerous and will require administrative privileges.

Check the Physical Disks and Volumes section in the following link
http://msdn.microsoft.com/en-us/library/aa363858(VS.85).aspx[^]

«_Superman_»

Suggestions on using XmlTextReader to parse xml into an object tree.

Luc Pattyn29-Jan-09 5:38

Luc Pattyn

29-Jan-09 5:38

Hi,

I discovered the same stuff a year ago when I started using Vista.
In short:
- in order to get the drive serial number you need low-level access to it, i.e. a CreateFile
- although reading some properties is all you need, Vista will not allow you to do so when not running
as administrator. (Try dropping the GENERIC_WRITE).

IMO there is no way around it, disk serial numbers are no longer available to regular users!

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

VB Compile problem

Member 152314228-Jan-09 20:20

Member 1523142

28-Jan-09 20:20

We have a VS 2003 solution containing 1 vb project and several c# projects. The problem is when i try to build the vb project either VS exits or stuck at "performing main compilation". Please help

chechk box

kulandaivel_mca200728-Jan-09 19:25

kulandaivel_mca2007

28-Jan-09 19:25

i want to validate the check box present inside the datagrid...
checked or not...

asp.net using c#

foreach (DataGridItem i in DataGrid1 .Items )
{
CheckBox chk = (CheckBox)i.FindControl ("chkbox");
if (chk.Checked )
{

}
}

// i use this to code to add checkbox in data grid

<asp:templatecolumn headertext="Approve" xmlns:asp="#unknown">
<itemtemplate>
<asp:checkbox id="chkbox" runat="server">

if u not able to understand my question plz ask me i will explain..

it is not working properly..

[Message Deleted]

Sam McKay28-Jan-09 14:15

Sam McKay

28-Jan-09 14:15

[Message Deleted]

wout de zeeuw28-Jan-09 7:39

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

28-Jan-09 7:39

I'm looking for decent article/tutorial demonstrating how to use XmlTextReader to read XML into a (large) object tree. So far the articles are only showing a simple while (reader.Read()) { bla; } loop.

Anyone ever used XmlTextReader to do some serious parsing? Otherwise I'll just go with the XmlDocument thing, that seems to be a lot easier, but I'm curious if anyone has a nice real world usage pattern for XmlTextReader.

Wout

led mike28-Jan-09 9:06

led mike

28-Jan-09 9:06

wout de zeeuw wrote:
demonstrating how to use XmlTextReader to read XML into a (large) object tree

wout de zeeuw wrote:
Otherwise I'll just go with the XmlDocument thing

The XmlDocument thing is an object tree so why wouldn't you just use it anyway?

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

wout de zeeuw28-Jan-09 13:53

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

28-Jan-09 13:53

Well, XmlDocument is the easier choice I agree. But if one were to use XmlTextReader to do it, how would that be done typically. I'm just curious if there's a standard way of handling this. I've experimented a bit with XmlTextReader, and I can get things working, but the end result of how I do it feels a bit kludgy.

Wout

N a v a n e e t h28-Jan-09 14:56

N a v a n e e t h

28-Jan-09 14:56

XMLDocument is using a reader internally. You can use reflector to see how reader is used inside that. I think that will help you to understand the usage.

Navaneeth

How to use google | Ask smart questions

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

wout de zeeuw28-Jan-09 23:39

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

28-Jan-09 23:39

Nah, XmlDocument builds something generic, but the idea is to parse into a type safe tree of classes. But thanks for the suggestion anyway.

Wout

led mike29-Jan-09 4:58

led mike

29-Jan-09 4:58

wout de zeeuw wrote:
but the idea is to parse into a type safe tree of classes

Um, wouldn't that be Serialization?

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

wout de zeeuw29-Jan-09 5:10

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

29-Jan-09 5:10

Yeah, sort of, except that I want to deserialize an object graph (i.e. objects are sometimes referenced, rather than owned) using my custom xml format (I need tight control over the xml format). I'm now doing a custom implementation, just to see how it ends up... it's a bit involved (but not terrible), see e.g. typical code snippet below:

public static DbTable Read(DbProjectBuilder projectBuilder, XmlTextReader r) {
    DbTable table = new DbTable();
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Table");
    while (r.IsStartElement()) {
        switch (r.Name) {
            case "Name":
                table.Name = r.ReadElementString();
                break;
            case "Notes":
                table.Notes = r.ReadElementString();
                break;
            case "PrimaryKeyType":
                table.PrimaryKeyType =
                    (DbPrimaryKeyType)Enum.Parse(typeof(DbPrimaryKeyType), r.ReadElementString());
                break;
            case "PrimaryKeyName":
                table.PrimaryKeyName =
                    r.ReadElementString();
                break;
            case "Columns":
                ReadColumns(projectBuilder, table, r);
                break;
            case "Indexes":
                ReadIndexes(projectBuilder, table, r);
                break;
            default:
                r.ReadInnerXml();
                break;
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
    return table;
}

private static void ReadIndexes(DbProjectBuilder projectBuilder, DbTable table, XmlTextReader r) {
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Indexes");
    while (r.IsStartElement()) {
        if (r.Name == "TableIndex") {
            DbTableIndex tableIndex = DbTableIndex.Read(projectBuilder, table, r);
            table.Indexes.Add(tableIndex);
        } else {
            r.ReadInnerXml();
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
}

private static void ReadColumns(DbProjectBuilder projectBuilder, DbTable table, XmlTextReader r) {
    bool isEmptyElement = XmlUtil.ReadStartElement(r, "Columns");
    while (r.IsStartElement()) {
        if (r.Name == "Column") {
            DbColumn column = DbColumn.Read(projectBuilder, r);
            table.Columns.Add(column);
        } else {
            r.ReadInnerXml();
        }
    }
    if (!isEmptyElement) {
        r.ReadEndElement();
    }
}

Wout

led mike29-Jan-09 5:20

led mike

29-Jan-09 5:20

wout de zeeuw wrote:
see e.g. typical code snippet below:

Ok, um after seeing your code I guess I should warn you that you appear to be reinventing the wheel only yours is shaped like a square.

Re: Suggestions on using XmlTextReader to parse xml into an object tree.

wout de zeeuw29-Jan-09 5:25