Data Gridview colume hiding - Visual Basic Discussion Boards

jacobjordan4-Jul-08 9:23

4-Jul-08 9:23

I am working on a macro app. I need to know how to show the desktop from my application. I already have functions from the user32 and kernel32 that will do things like minimize windows, close windows, ect. Is there a function inside a windows dll that will show the desktop, or is there another way to do it? I have already tried to do something simple like

Shell("Show Desktop.scf")

And that failed miserably.

Re: How to show desktop from an application

Christian Graus4-Jul-08 9:46

Christian Graus

4-Jul-08 9:46

The desktop is shown by minimising all the windows, enumerating and minimising seems the best way to me.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Re: How to show desktop from an application

jzonthemtn4-Jul-08 9:46

jzonthemtn

4-Jul-08 9:46

Maybe something like this[^] would do the trick...?

Re: How to show desktop from an application

DaveyM694-Jul-08 10:34

DaveyM69

4-Jul-08 10:34

This is C# code but it should be easy to convert.

Shell32.ShellClass shell = new Shell32.ShellClass();
//IShellDispatch4 has the ToggleDesktop() method. http://msdn.microsoft.com/en-us/library/bb774122(VS.85).aspx
((Shell32.IShellDispatch4) shell).ToggleDesktop();

//Do your stuff here
System.Threading.Thread.Sleep(5000);

//Restore desktop
((Shell32.IShellDispatch4) shell).ToggleDesktop();

You'll need to add a reference to shell32.dll which is in the System32 folder in XP.

Dave

How to draw on an image

asteriskgr4-Jul-08 8:29

asteriskgr

4-Jul-08 8:29

Hello, I am beginner vb.net programmer from Greece. I would appriciate if someone could help where to search to find how can i draw on an immage on a form. For example to draw dots or simple lines on a specific image on a picture that is placed on a picture box and then save it in a database as an image. The only thing that i know is the database part.

Thx a lot for your time

Re: How to draw on an image

Christian Graus4-Jul-08 9:45

Christian Graus

4-Jul-08 9:45

You use the paint event to draw on your form, draw the bitmap first then draw on it. The Graphics object is what you need to research.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Re: How to draw on an image

sa_runner7-Jul-08 4:14

sa_runner

7-Jul-08 4:14

Take a look at this link. It helped me alot with a graphics project that I'm working on.

http://www.informit.com/articles/printerfriendly.aspx?p=29477[^]

Data Gridview colume hiding

rajesh_ncc4-Jul-08 3:53

rajesh_ncc

4-Jul-08 3:53

Dear Friends,

I have developing a small project in vb.net. i used data gridview control to show the many employer detail row by row also i have done. data gridview it contain nearly more than 15 column.

Here i have to make a split up column like below
1. While using the vertical scroll my first column should be show remaining column go to behind of first column or hide. i have the employee id in first column at the same time i have the employee address in 10th column when use vertical scroll the first column will gone then i can't able to identify the employee address.

Can you tell me it is possible to do.
If it it is possible kindly provide the code.

Thanking You

K. Rajesh Kumar

i am a fresher in software development i have so many doubts in .net so i need to ca

Re: Data Gridview colume hiding

Rupesh Kumar Swami4-Jul-08 4:04

Rupesh Kumar Swami

4-Jul-08 4:04

use following statement
DataGridView1.Columns(0).Frozen = True

hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

vb6 adodc delete

Amit Battan Ror4-Jul-08 3:04

Amit Battan Ror

4-Jul-08 3:04

i am using following code in vb6

Private Sub cmdDelete_Click()
On Error GoTo DeleteErr
With datPrimaryRS.Recordset
.Delete
.MoveNext
If .EOF Then .MoveLast
End With
Exit Sub
DeleteErr:
MsgBox Err.Description
End Sub

but it give error:
Insufficient key column information for updating or refreshing.

it remove the data from datagrid but not from ms access database

please help me

battan20@gmail.com

Re: vb6 adodc delete

Vimalsoft(Pty) Ltd4-Jul-08 4:23

Vimalsoft(Pty) Ltd

4-Jul-08 4:23

hi Amit Battan Ror

Have you initiated a Development in vb6?

If so,VB6 its Dead incase you dont know. Try to learn C# or vb.net.If your Company is Still Planning to keep vb6 apps and you have to maintain them, start sending out your resume because you are going to kill your skills. Now lets get back to your error.To update a Database record.. the Server has to know exactly which record it is that you want to change.. ie. it needs a UNIQUE key of some kind to process the record. IF in your DataBase table you do NOT define a field as being unique, ADO will look at the data and then try to build a (temporary)UNIQUE key.. which then can be used to perform the update. Sometimes ADO
is successful in doing this.. and sometimes it is NOT (as witnessed by your present dilemna).The first thing you should do is go and check the Tables you are using to make sure that each of them has at least ONE unique field defined.. and if there is none.. add a Unique identifyling field (such as an Autonumber) to it.

Hope it helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: vb6 adodc delete

Vimalsoft(Pty) Ltd9-Jul-08 4:54

Vimalsoft(Pty) Ltd

9-Jul-08 4:54

Go to the table that you want to Update and make sure that there is a Primary_key, What database are you using?, Send me a Structure and will help you.

Get value from Mutiple fom

Sarfaraj Ahmed4-Jul-08 2:33

Sarfaraj Ahmed

4-Jul-08 2:33

Hello Everybody

I have 3 form on my project

1. frmNewOrder (have a button called btnPayment also have orderID)
2. frmExistingOrder (have a button called btnPayment also have orderID)
3. frmPayment

when you click btnPayment from frmNewOrder or frmExistingOrder then how can I send orderID value to frmPayment

I have done something

Public Shared OrderID As Integer (on frmNewOrder)
I put code on frmOrder page load events
orderID = frmNewOrder.OrderID

I know its really a wrong concept.

Any idea or example will be really helpful

Thanks in Advance

Sarfarj Ahmed

Re: Get value from Mutiple fom

nlarson114-Jul-08 3:07

nlarson11

4-Jul-08 3:07

how are you creating a new instance of frmPayment? in the click event of btnPayment correct? Pass the value into frmPayment after creating the instance.

dim frmPay as new frmPayment
frmPay.OrderID = me.OrderID
frmPay.showdialog

'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous

'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous

Re: Get value from Mutiple fom

Sarfaraj Ahmed4-Jul-08 3:51

Sarfaraj Ahmed

4-Jul-08 3:51

thnks for ur reply
i have already solved my problem form google help
thank u very much

Sarfarj Ahmed

Re: Get value from Mutiple fom

Jay Royall4-Jul-08 3:54

Jay Royall

4-Jul-08 3:54

Hi,

If frmPayment isn't equal to nothing then you can set a variable in frmPayment through a public property.

e.g.

in frmPayment:

dim intOrderId as integer

Public WriteOnly Property OrderID() as Integer
   Set(byval value as Integer)
      intOrderId = value
   End Set
end property

and in frmNewOrder:

frmMyPayment.OrderID = orderID

However, if frmPayment is not yet initialised, you can call the new constructor passing the orderid as a parameter.

e.g.

in frmPayments:

public sub new(byval orderID as integer)
   me.intOrderID = orderID
end sub

and in and in frmNewOrder:

Dim frmMyPayment as new frmPayment(orderid)

Is this OK?

How to read EDI files like 835, 837

K Suresh Reddy4-Jul-08 1:22

K Suresh Reddy

4-Jul-08 1:22

Can some body help in reading the EDI files using VB.net or C#

Re: How to read EDI files like 835, 837

Dave Kreskowiak4-Jul-08 6:32

Dave Kreskowiak

4-Jul-08 6:32

Your question is pretty much unanswerable considering you haven't said anything about what your doing with the file. Reading an EDI file is just like any other text file. Parsing it and getting data out is another story. You may want to make your life a bit easier by Googling for "edi tools for programmers".

A guide to posting questions on CodeProject[^]

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

Re: How to read EDI files like 835, 837

K Suresh Reddy7-Jul-08 19:03

K Suresh Reddy

7-Jul-08 19:03

Thank your for the suggestion. We are having a Practice Management product in which we generate EDI 837 and parse 835, 276, 277 and etc and take the data out. The current system is very slow(i.e. for parsing 835 file which has 3000 transactions takes about 3hrs). we have designed the product using VB & SQL Server. So I am looking for the better approach.

Re: How to read EDI files like 835, 837

Dave Kreskowiak8-Jul-08 9:29

Dave Kreskowiak

8-Jul-08 9:29

K Suresh Reddy wrote:
for parsing 835 file which has 3000 transactions takes about 3hrs

If it's going that slow, you've got some serious design issues in your app. You're going to have to find out what part(s) of your code is taking so long to execute, then look at methods of speeding those sections up. This is probably going to require you redesigning your application. There's three glaring possibilities.

The parser may be slow. The easiest thing to do is to use a third-party library designed specifically to parse the files and return the data to you.

There may be a data processing problem. What are you doing with the data once you get it out of the parser?

Your SQL code may be inefficient. You may be doing a bunch of sutff using SQL in your VB.NET code instead of using stored procedures or some other more efficient use of the SQL processing power.

A guide to posting questions on CodeProject[^]

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

Edit the data in a detail view at run time

Rock Star.3-Jul-08 23:59

Rock Star.

3-Jul-08 23:59

Hi,
I am binding a data in a detail view at run time. But I also want to edit it at the run time. I have tried the following code.

Protected Sub Detailsview1_ItemUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdateEventArgs) Handles Detailsview1.ItemUpdating

Dim index As Integer = Generic_DG.SelectedIndex

Dim con As New SqlConnection(ConfigurationManager.AppSettings("connectionString"))
Dim cmd As New SqlCommand()
cmd.CommandText = "UPDATE Products SET ProdName=@ProdName where ProdId=@ProdId"

cmd.Connection = con
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()

End Sub

How can I replace @ProdName with data in a detail view?
OR
Which property of the detailview I have to use for it?

Rock Star

Re: Edit the data in a detail view at run time

Vimalsoft(Pty) Ltd4-Jul-08 4:45

Vimalsoft(Pty) Ltd

4-Jul-08 4:45

hi

I see what you are trying to do , but your question says something else, now from what i see from your code, you have parameters that are not declared.

restrict project to run only 20 times

vijaylumar3-Jul-08 23:20

vijaylumar

3-Jul-08 23:20

hai friends
i developed a software thru vb.net windows application
now i will give it to clients for trial
but it should run only for 20 times
if the software is loaded into another system then it should not run
if the count is 20

plz help me
thanks in advance
vijay

Re: restrict project to run only 20 times

Rupesh Kumar Swami3-Jul-08 23:29

Rupesh Kumar Swami

3-Jul-08 23:29

you can store the number of run in database.
on project startup , check whether count is 20,if yes then close the application otherwise increment the number of run by 1.
hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company

Re: restrict project to run only 20 times

vijaylumar3-Jul-08 23:46

vijaylumar

3-Jul-08 23:46

hai rupesh

is there any other option other than "storing count in database"

thanks for u r reply
vijay

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.