Visual Basic

mpisha18-Oct-07 8:24

18-Oct-07 8:24

Ok,what amount should it cost me?Make it fair and try me this time.I will help you one day.Its just that i was held-up abit.

Vimalsoft(Pty) Ltd16-Oct-07 3:34

16-Oct-07 3:34

Sure, i can do that for $3000

Next time dont tell us what to do, you dont pay us

Vuyiswa Maseko,

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

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

mpisha18-Oct-07 8:33

18-Oct-07 8:33

Why you complaining,i kind of requested and i used please!!!

Vimalsoft(Pty) Ltd18-Oct-07 20:04

18-Oct-07 20:04

you should not come here, and say "KIND OF AGENT"

Hesbon Ongira16-Oct-07 3:37

Hesbon Ongira

16-Oct-07 3:37

Lemme think about it. ehhhh....NO! This forum is for getting help, not doing projects for people! Get to work!

---------------------------
Both optimists and pessimists are important in technology. The optimist invented the aeroplane; the pessimist invented the parachute.

Regards,
Hesbon Ongira
Nairobi, Kenya.

Vimalsoft(Pty) Ltd16-Oct-07 3:56

16-Oct-07 3:56

i can never do it for him , am just annoyed when he comes here and ask us to do a Project for him "Urgently".

mpisha18-Oct-07 8:11

18-Oct-07 8:11

Come on Hesbon,u kenyan like me,you know what it entails to work on multiple projects.I just needed help urgently.....

Patrick Etc.16-Oct-07 7:50

Patrick Etc.

16-Oct-07 7:50

No, sorry, you DIDN'T MAKE YOUR REQUEST LOUDLY ENOUGH SO TRY ASKING LOUDER AND MAYBE ONE OF US WILL SAY YES!

Mad | :mad:

"If you think of yourselves as helpless and ineffectual, it is certain that you will create a despotic government to be your master. The wise despot, therefore, maintains among his subjects a popular sense that they are helpless and ineffectual."
- Frank Herbert

mpisha18-Oct-07 8:14

Re: Business Object Error

18-Oct-07 8:14

I wish i could just hit the CAPS-LOCK and express how am really interested in that project.Am really requsting i didnt mean to be vulgar.HELP ME OUT PLEASE!!!!!!Thanks.

Come on people....

Christian Graus16-Oct-07 10:14

Christian Graus

16-Oct-07 10:14

I know it gets bad sometimes, but surely I'm not the only one able to spot a troll here ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Come on people....

Patrick Etc.16-Oct-07 10:33

Patrick Etc.

16-Oct-07 10:33

Hehe I figured it probably was. So I thought I'd use the chance to post something using big red letters (been wanting to do that for awhile.. just to be silly..) when I wouldn't actually insult someone asking a real question Smile | :)

Business Object Error

nicetohaveyou16-Oct-07 1:30

nicetohaveyou

16-Oct-07 1:30

i am working in a VB Access application where a Business Object is used.

whenever i launch the appllication it gives me error on Business Object.
Is it that i dont have the Busines Object in my machine?
How does it actually works?
Do i need to download the business object from somewhere?

Dave Kreskowiak16-Oct-07 2:15

Dave Kreskowiak

16-Oct-07 2:15

nicetohaveyou wrote:
i am working in a VB Access application where a Business Object is used.

You're going to have to explain this a bit more to get an answer. What's a "Business Object"?? Is this a VB6 or VB.NET app with an Access database as a backend?? Or is this an app written in Access with VBA code??

nicetohaveyou wrote:
whenever i launch the appllication it gives me error on Business Object.

Standard question #1: "What is the error message"?

nicetohaveyou wrote:
How does it actually works?
Do i need to download the business object from somewhere?

You haven't told us what "Business Object" is, so how can we tell you how it works?? Got a link to this library or control you're using?? Searching for "Business Object" is a little pointless considering how generic the name is.

A guide to posting questions on CodeProject[^]

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

How to Use ? [modified]

Satish_S16-Oct-07 0:42

Satish_S

16-Oct-07 0:42

i have tried to use 3 layers
Presentation Layer,business Logic Layer, Data Access Layer
Just i Have tried,tell whether this is correct or not?

In My Presentation Layer
i have two textbox one for UserName and other for password

Private Sub btnSubmit_ServerClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.ServerClick
Try
Dim cus As New UserBLL
cus.UserName = txtuser.Value.ToString
cus.UserPass = txtPass.Value.ToString
cus.Verify()

Catch ex As Exception
Response.Write(ex.Message.ToString())
End Try
End Sub

In My business Logic Layer

Public Property UserName()
Get
Return user
End Get
Set(ByVal Value)
Try
Me.user = Value
If (Me.user = "") Then
Throw New Exception("Please Provide The User Name")
End If
Catch ex As Exception
Throw New Exception(ex.Message.ToString)
End Try
End Set

End Property
Public Property UserPass()

Get
Return pass
End Get
Set(ByVal Value)
Try
Me.pass = Value
If (Me.pass = "") Then
Throw New Exception("Please Provide The Pasword")
End If
Catch ex As Exception
Throw New Exception(ex.Message.ToString)
End Try
End Set
End Property

Public Sub Verify()

strReturnfromDAL = UsrData.Verify2("user", "pass")
End Sub

In Data Access Layer i Have

Public Function Verify2(ByVal str As String, ByVal str2 As String) As String
If str = "user" And str2 = "pass" Then
Return str + "" + str2
End If

End Function

In above i have tried to get a concept but i think i am not in correct way and
i need a result like verfying the user name and password and return back to BLL
i am not getting any error but i am not able to get the value of verify function to prsentation layer.

sathimailin

-- modified at 7:21 Tuesday 16th October, 2007

Re: How to Use ?

Christian Graus16-Oct-07 1:14

Christian Graus

16-Oct-07 1:14

You obviously don't have a data layer here at all.

Your 'business layer' is using exceptions to pass information that should exist in the presentation layer.
You plainly don't need to call ToString on a Text property, it's a strng already
Having the username and password as members makes no sense at all, you want to pass them in and get a result, you don't want to store them

sathimailin1 wrote:
Try
Me.user = Value
If (Me.user = "") Then
Throw New Exception("Please Provide The User Name")
End If
Catch ex As Exception
Throw New Exception(ex.Message.ToString)
End Try

What is this in aid of ? Make sure you catch the only exception that can be thrown, and rethrow it ?

This is all a mess, throw it away and start again. Get a database and write a proc which returns true is a username/password combination is valid. Return true or false from the BL, whch just calls the proc. Do all your rendering/generating of messages in the PL

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: How to Use ?

Satish_S16-Oct-07 1:28

Satish_S

16-Oct-07 1:28

Thanks Christian Graus
I will try with procs and i will post again to get the answer whether correct or not

sathimailin

Re: How to Use ?

Satish_S16-Oct-07 20:05

Satish_S

16-Oct-07 20:05

Hi Christian Graus,
i Have reposted my doubt after making modifications again today .

sathimailin

Is it possible to write data in an opened excel file ?

rpimpley16-Oct-07 0:23

rpimpley

16-Oct-07 0:23

Hi experts,
I m basically fighting wid a prb for writing data in a physically opened excel file. Is it possible to write in cells of the excel which is physically open ?

If so, pls guide me how can i implement it ?

Thanks. Smile | :)

Re: Is it possible to write data in an opened excel file ?

Dave Kreskowiak16-Oct-07 2:10

Dave Kreskowiak

16-Oct-07 2:10

No, it's not. You have two problems. First, the file is already open, so any changes you make will be destroyed when Excel save the file.

Second, the Excel file format is binary and VERY complex, up to Excel 2003. You cannot just open a file for binary access, write to it, and call it a cell in Excel.

In Excel 2007, the file format changed to an open-spec XML format, which is basically a text file. But, you still can't write to a file opened as ShareDeny by another application.

A guide to posting questions on CodeProject[^]

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

Deployment in VS 2003(User interface) Question

Vimalsoft(Pty) Ltd16-Oct-07 0:19