Visual Basic

DidiKunz8-Jun-09 1:18

DidiKunz

8-Jun-09 1:18

why would you want to remove it? I rather hide it YourDomainUpDown.Visible = False

Regards: Didi

tiagu8-Jun-09 3:10

tiagu

8-Jun-09 3:10

Didi, Thanks for the falsifying visible code. I want to remove it because a few domainupdown controls may not be filled with values at runtime. I want to do away with these controls alone which do not contain any values. Can they be removed ?

DidiKunz8-Jun-09 4:17

DidiKunz

8-Jun-09 4:17

...you have got your answer, see post of Johan Hakkesteegt below.

Good luck: Didi

Unnecessarily opening of excel file vb.net

Johan Hakkesteegt8-Jun-09 3:15

Johan Hakkesteegt

8-Jun-09 3:15

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            For Each c As Control In Me.Controls
                If TypeOf c Is TextBox Then
                    If c.Text.Length = 0 Then c.Dispose()
                End If
            Next
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub

Instead of checking for checkboxes you can also check for domainupdown, and any control.

In this example code, you can check what other options you can find behind c, if you want to apply some other logic.

My advice is free, and you may get what you paid for.

Pankaj Garg8-Jun-09 0:41

8-Jun-09 0:41

Hi,

In my code, after execution of the following code.

dim d as new Excel.Application

create an excel instance.
and opening an excel file by using the following code.

d.Workbooks.Open(ExsTemplate & "sheet.xls")

Now i try to open an excel file by double clicking it, which is lying in my hard drive.
this open sheet.xls file also , in the taskbar.

Can you tell me why sheet.xls should open?

Thanks

Anoop Brijmohun8-Jun-09 1:06

Anoop Brijmohun

8-Jun-09 1:06

hi,

you need to close the excel book in your program.

workbooks.close

thanks

Pankaj Garg8-Jun-09 1:13

8-Jun-09 1:13

i HAVE 35-40 LINES OF CODE, before i closes the workbook.
and meanwhile user tries to open an excel file, which results in opening the file (Sheet.xls).
Any idea?

Dave Kreskowiak8-Jun-09 1:28

8-Jun-09 1:28

Yep, when you use Excel in your application, this is the rick you take. A use can launch external .xls files by double clicking on them and they will show up in the Excel that you launched in your code. You can't prevent it.

So what's the question?

A guide to posting questions on CodeProject[^]

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

Pankaj Garg8-Jun-09 1:43

8-Jun-09 1:43

Should the file get opened in compatibility mode?
Which ever file is opening , the compatibility mode text get appending with the file name, until the instance is killed.

Dave Kreskowiak8-Jun-09 3:06

8-Jun-09 3:06

That depends on the file. I have no idea what you're users are opening, so yes, it's possible.

A guide to posting questions on CodeProject[^]

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

Pankaj Garg8-Jun-09 1:18

8-Jun-09 1:18

do u have any idea for the below link
http://www.codeproject.com/Messages/3071168/files-names-under-a-process-vb-net-2008.aspx[^]

Anoop Brijmohun8-Jun-09 1:23

Anoop Brijmohun

8-Jun-09 1:23

no idea!

Problem in Crystal report using password?

EliottA8-Jun-09 5:31

EliottA

8-Jun-09 5:31

Set IgnoreRemoteRequets to True to force excel to open a new instance of excel.exe for each workbook, this may cause undesired behavior and may cause links to not work. Save your sheet when you set ignoreremoterequests to true.

This will prevent all worksheets opened programtically when a user opens a workbook from his desktop.

Check out the CodeProject forum Guidelines[^]

JC.KaNNaN7-Jun-09 23:07

JC.KaNNaN

7-Jun-09 23:07

hi,
initially i connect crystal report with ms access.
its work perfectly.
but now im secure my access Db(using set password)
its cant able to connect with crystal report...

some window will appear.
its showing servername,database,userid and password..

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Re: Problem in Crystal report using password?

Skymir8-Jun-09 4:32

Skymir

8-Jun-09 4:32

Either add the login info to the connect string you're sending to the report, or open the report in crystal designer, update the connection info and resave the report.

Even when you hand crystal a connection to the database, it still authenticates itself to retrieve the data.

The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.

Re: Problem in Crystal report using password?

calvenyow12-Jun-09 17:01

calvenyow

12-Jun-09 17:01

Hello,

I also faced this problem. What I do is add a new system DSN at ODCB. After that, open the crystal report file and change the connection to the ODBC.Hope this can help you.

Thank You !

yutu

files names under a process - vb.net 2008

Pankaj Garg7-Jun-09 21:30

7-Jun-09 21:30

Hi,

I opened ten excel files, and all files are coming under one process in the task manager.
Is there any option to find all the excel file names which are lying in this excel process?

Thanks

Christian Graus7-Jun-09 21:34

Christian Graus

7-Jun-09 21:34

Perhaps if you use the interop stuff to interact with Excel directly.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Dave Kreskowiak8-Jun-09 1:26

8-Jun-09 1:26

You're going to have to use Office Interop to get the list of opened workbooks from Excel.

A guide to posting questions on CodeProject[^]

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

Pankaj Garg8-Jun-09 1:43

8-Jun-09 1:43

can u provide some sample code to process it?

DataGridView UnCompleted Last Row values & It's Datatable Last Row Problem !!!

EliottA8-Jun-09 5:31

EliottA

8-Jun-09 5:31

Check out the CodeProject forum Guidelines[^]

Paramu19737-Jun-09 21:26

Paramu1973

7-Jun-09 21:26

I have a DatagridView with 10-columns and Allow user to add new row is True.
But the problem is when the user entering the data's in new row's from the last row, when they
entered the data in 4th cell, they like to save the data.

But it's not saving, the uncompleted last row.
Iam using the following for save.

-----------------------------------------------------------

Dim DAD31 As SqlDataAdapter,DS31 As New DataSet,DTB31 As New DataTable

Dim Save_4 As String = "insert into itemmst (itm_description) values (&itm_description)"

DAD31.InsertCommand = New SqlCommand(Save_4, con)
con.Open()

Dim Trans As SqlTransaction
Trans = con.BeginTransaction
DAD31.InsertCommand.Transaction = Trans

Try
DAD31.Update(DS31.Tables(0))
Trans.Commit()

Catch ex As Exception
If Not Trans Is Nothing Then
Trans.Rollback()
End If
MsgBox(ex.Message)
End Try

con.Close()
----------------------------------------------------------------

THANK YOU ! For Your Valuable Minutes !!! Suspicious | :suss:

Re: DataGridView UnCompleted Last Row values & It's Datatable Last Row Problem !!!

Dave Kreskowiak8-Jun-09 1:25