Visual Basic

Transparent back color property of label

3-Jan-08 4:44

What's the question?? What part of this are you having problems with??

You can't save the table directly to Excel. You have to parse it out of the HTML data and put it into the cells you want, one cell at a time.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

nishkarsh_k2-Jan-08 20:52

nishkarsh_k

2-Jan-08 20:52

Hello every one

I have a Vb 2005 Express application.

I am using a label over a picture box (it has a scroll bar).

I want to have the background color of the label as transparent so that whenever the picture box is scrolled in the background of the label, every thing can be seen

But when I do this the back color of the label is of the color it first gets..

What should be done??

Re: Transparent back color property of label

Dave Kreskowiak3-Jan-08 1:58

3-Jan-08 1:58

A Transparent background is NOT transparent. You cannot see the other controls on a form through a transparent background. Transparent means that the label control will use the background color or image properties of the parent form. If the background of the parent form is yellow, you're label's background will be yellow.

You'll have to create your own version of the label control, providing the painting code to create the effect you want. You can find an example of such here[^], or here[^], or the entire list of Yahoo search results for ".net transparent label control[^]".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

sec urity issue

Tauseef A2-Jan-08 20:40

Tauseef A

2-Jan-08 20:40

hi guys

i have installed framework 2 on my system but there was framework 1 already installed,
now i am facing a problem that in control panel, admin tools, framework2 configuration icon is not seen , it is only previously installed framework 1 configuration, why is that ?
thanks in advance

hello

Re: sec urity issue

Dave Kreskowiak3-Jan-08 4:50

3-Jan-08 4:50

That's because, starting with .NET 2.0, the security tools have been moved to the .NET Framework SDK. They don't ship with the redistributable version.

Read here...[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: sec urity issue

Tauseef A3-Jan-08 16:17

Tauseef A

3-Jan-08 16:17

so how do we configure framework 2.0 security except using caspol ?

thanks in advance

hello

Re: sec urity issue

Dave Kreskowiak4-Jan-08 1:40

Com callable Wrapper Class

4-Jan-08 1:40

You didn't actually read the link I posted, did you? Perhaps followed the links on that page to the place where you can probably download the SDK version and grab the security tools from it, maybe...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

ramyasangeet2-Jan-08 20:37

ramyasangeet

2-Jan-08 20:37

Hi all,

I have created a COM wrapper component in c#.net. I generated .tlb file out of it. Also I added reference to tlb file in VB 6.0 application and can able to call functions of COM wrapper.

In C#, i have declared a stringcollection to collect all the errors.But while mapping,this String collection is converted to Unknown in VB 6.0 and becoz of that i got mismatch error.
so i changed the stringcollection to Arraylist in C#.
This Arraylist is converted to String in VB 6.0 while mapping.
and i got error while i tried to retrive the string.

Plz give me suggestions on how to call a Stringcollection/arraylist in VB 6.0.

Thanks in Advance,

cheers

sangeet

Re: Com callable Wrapper Class

Dave Kreskowiak3-Jan-08 1:47

Writing data from dataset to XML file [modified]

3-Jan-08 1:47

You cannot pass any System.Collection objects back to VB6. You'll have to convert this collection to an array of strings to send it back to VB6.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Usharva2-Jan-08 20:14

Usharva

2-Jan-08 20:14

I can abke to write data from Dataset to XML File but the problem now i am facing is... i am getting the XML file like this

- <NewDataSet>
- <PatientID>
<patientRegId>NH0000412006</patientRegId>
<pat_name>SNI dsen dev1</pat_name>
<DOB>1980-06-22T00:00:00+05:30</DOB>
<gender>Male</gender>
<MaritalStatus>Married</MaritalStatus>
<Religion>Christian</Religion>
<presentAddress />
<city>Chennai</city>
<presentPIN>500013</presentPIN>
<Nationaity>Indian</Nationaity>
<patientRegId1>NH0000412006</patientRegId1>
<episodeNo>1</episodeNo>
<visitNo>2</visitNo>
<consultantId>5</consultantId>
</PatientID>
</NewDataSet>

but i want the same data in this format

<NewDataSet>
- <PatientID>
<patientRegId>NH0000412006</patientRegId>
<pat_name>SNI dsen dev1</pat_name>
<DOB>1980-06-22T00:00:00+05:30</DOB>
<gender>Male</gender>
<MaritalStatus>Married</MaritalStatus>
<Religion>Christian</Religion>
<presentAddress />
<city>Chennai</city>
<presentPIN>500013</presentPIN>
<Nationaity>Indian</Nationaity>
<patientRegId1>NH0000412006</patientRegId1>

- <episodeNo No="1">

<visitNo>2</visitNo>
<consultantId>5</consultantId>

</episodeNo>
</PatientID>
</NewDataSet>

this is my code
Dim SqlDataAdapter2 As New SqlDataAdapter(qry, sqlCon)
Dim ds As New DataSet
SqlDataAdapter2.Fill(ds, "PatientID")
ds.WriteXml("E:\\ss.xml")

Thanks in Advance

modified on Thursday, January 03, 2008 2:29:20 AM

Michael Sync2-Jan-08 20:26

Michael Sync

2-Jan-08 20:26

What are the differences?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Usharva2-Jan-08 20:31

Usharva

2-Jan-08 20:31

I need to crete child Nodes

Volker Weichert3-Jan-08 9:14

Volker Weichert

3-Jan-08 9:14

I am guessing that you have more than one episode per patient and more than one visit per episode. You can always write your own filter to create the XmlDocument you need by iterating through the rows and adding the appropriate nodes to the XmlDocument. Then you can call the Write() method of the XmlDocument.

Volker Weichert

Usharva3-Jan-08 16:43

Usharva

3-Jan-08 16:43

Yes you are right... but i dont know how to write node by node using Dataset.. pelase can u help me

Volker Weichert4-Jan-08 0:08

Volker Weichert

4-Jan-08 0:08

Try something like this:

Dim doc As XmlDocument = New XmlDocument()
Dim tableName As String = "myTable"
Dim node, attrib As XmlNode
Dim parentNode As XmlNode = doc.DocumentElement
    For Each row As DataRow In ds.Tables(tableName).rows
        node = doc.CreateNode(XmlNodeType.Element, "myElement", myNameSpaceURI)
        attrib = doc.CreateAttribute("myAttribute")
        attrib.Value = row("myAttributeColumn").ToString()
        node.Attributes.Append(attrib)
        parentNode.AppendChild(node)
    Next

You just need to adjust this to fit your own table.

Volker Weichert

listview checkbox

lembayung2-Jan-08 17:26

lembayung

2-Jan-08 17:26

i just wanna ask about how to code listview checkbox..i have two tables, one is for courses and the other one is for student information...all the courses will be shown at the listview and the admin will click any courses that students have to attend..and my question are.

1. how to code the listview checkbox at the button save coding?

2. If one student is registered to many courses, where should put all the courses data that been registered to that particular student,do i have to create another table?

Michael Sync2-Jan-08 20:22

Michael Sync

2-Jan-08 20:22

lembayung wrote:
1. how to code the listview checkbox at the button save coding?

Why don't you use Gridview with checkedboxes?

lembayung wrote:
do i have to create another table?

Yeah.. there will be three tables like Students, StudentCourse, Courses.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

lembayung2-Jan-08 21:21

lembayung

2-Jan-08 21:21

im new in vb so i dont much....regarding to ur reply, are you referring to vb.net?do we have gridview in visual basic?

Christian Graus2-Jan-08 22:29

Christian Graus

2-Jan-08 22:29

Wow.

If you're that new to VB, you should be buying a book on winforms and reading it. Yes, VB.NET has a gridview control.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )