Visual Basic

Re: datagrid manipulation

11-Oct-07 7:55

You don't have a choice. You either rework your strongly typed dataset or you add support code for going through each record in the table and doing the calculation and putting the result in a column in the table.

A guide to posting questions on CodeProject[^]

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

Abbhie11-Oct-07 15:17

Abbhie

11-Oct-07 15:17

Thanks. You gave me an idea for my work.

Exe to Exe communication

nlarson1111-Oct-07 5:49

nlarson11

11-Oct-07 5:49

I have a dotnet control that i load into a page in the browser. It uses tcp and system.diagnostics(for launching) to communicate with an exe on the PC. The exe can be started up via browser(hidden mode) or a shortcut(visible mode) on the user's pc. If the exe is already started in hidden mode and the user clicks on the shortcut (which would obviously try and start a new instance of the exe), I want the new exe to check if the first exe is running and if running tell the first one to change it's mode and then the new one will just shutdown.

What's the best course of action to get the exes to talk to each other (tcp/api/etc)?

Thanks,
Nathan

Re: Exe to Exe communication

Dave Kreskowiak11-Oct-07 6:59

Re: Exe to Exe communication

11-Oct-07 6:59

This was just covered a couple of days ago. You're looking for the Mutex class. Search the articles for "single instance" and you'll find examples.

A guide to posting questions on CodeProject[^]

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

nlarson1111-Oct-07 14:22

nlarson11

11-Oct-07 14:22

thanks dave...must of missed it.

databinding format event

sabr4911-Oct-07 5:47

sabr49

11-Oct-07 5:47

newbie to programming here... Smile | :)

I have an Access database that I am binding a TextBox text property to. I would like to have data that is coming in from the database post to the textbox in the (###) ###-#### phone format (in access it is saved as a text type without formatting). I created an event handler for the format and parse event to handle the binding (a copy of which is below). The data is now posting to the textbox as (###) ### - #### without the data (every phone record is filled with the pound sign).

Private Sub PhoneNumberFormat(ByVal sender As Object, ByVal cevent As ConvertEventArgs)
cevent.Value = Format(cevent.Value, "(###) ### - ####")

End Sub

Re: databinding format event

Dave Kreskowiak11-Oct-07 6:57

Re: databinding format event

11-Oct-07 6:57

sabr49 wrote:
The data is now posting to the textbox as (###) ### - #### without the data (every phone record is filled with the pound sign).

That's because the format string you've come up with only works with numbers. Since you're storing the phone number as a string, you've going to have to parse that string and insert the characters in the correct place to make a whole new formatted string.

A regular expression might help you in this case.

A guide to posting questions on CodeProject[^]

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

sabr4911-Oct-07 9:05

sabr49

11-Oct-07 9:05

Greatly appreciate. Had never used a regular expression b/4 and got it with this regular expression in a jiffy.. Powerful stuff!

Private Sub PhoneNumberFormat(ByVal sender As Object, ByVal cevent As ConvertEventArgs)
Dim strFormatted As String
strFormatted = Regex.Replace(cevent.Value, "(\d{3})(\d{3})(\d{4})", "($1) $2-$3")
cevent.Value = strFormatted

image editor

Aamir Mustafa11-Oct-07 4:43

Aamir Mustafa

11-Oct-07 4:43

I want to make a project which is called image editor in vb.net. Its functions are
1. File Menu:
Open an image
Save an image after work on that image
MDI-Multiple Document Interface Support
2. Edit Menu:
Where we can cut, copy and paste the image.
3. Windows Menu.
Where we can arrange multiple windows.
4. Other functions
5. Resize an image
6. Transforms an image
7. Rotate an image.
8. Lighting on images
9. Zooming of images
10. Texturing of images.

Aamir Mustafa

Re: image editor

Dave Kreskowiak11-Oct-07 5:19

11-Oct-07 5:19

Would mind terribly asking a question we could actually answer! Right now, the response would be "Permission granted!"

What part of this are you having a problem with??

A guide to posting questions on CodeProject[^]

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

Re: image editor

Ajay.k_Singh11-Oct-07 7:24

Ajay.k_Singh

11-Oct-07 7:24

If you are looking for help in implementing these features in your application, I would suggest you to search for each topic one by one using Google.

Such as if you search for string ‘Resize an Image+Vb.net” it will give you link to many tutorials, articles and newsgroup replies which explains us the process of resizing an image.

I hope in this way you will be able to get basic information about implementing these functionalities. However if you face any specific problem while creating this application, let us know.

-Dave.

Dave Traister,
ComponentOne LLC.
www.componentone.com

Coding issue

Sam Heller11-Oct-07 4:18

Sam Heller

11-Oct-07 4:18

I am currently trying to build some code which handles response times. I have a start time, an end time and a response time. Obviously enough the end time is the start time plus the response time. For example

Start time
12:00

Response time 6 hours

End time

18:00.

My issue is finding out if the two times went over no working hours. Mainly lunchtime 13:00 - 14:00. If I have the start time and end time whats the best way to find out if they ran over a single lunch time or in some cases several lunchtimes?

Any suggestions as to how to code this or any tools in .net that would make this easier to do would be appreciated. Thanks

Mbire11-Oct-07 5:18

Mbire

11-Oct-07 5:18

i think u should check to see if the timespan between the start time and the no work start time in question is positive, as in the start time is definitely before the no work start time. then if it is positive, check to see if the time span between the end time and the no work start time is also positive, depending on wat u subtracted from the other, then take it from there. if u dont understand this please say so and i can give u more structured pseudo code.

Sam Heller11-Oct-07 23:34

Sam Heller

11-Oct-07 23:34

I think what you have mentioned here is pretty much what I have described but consider the following. If the start time was 09:00. And the response time was 8 hours, the time to respond by would be 17:00.

The thing is this calculation would have gone over lunch time. At which point I need to add 1 additional hour as lunch time is not counted.

DO you understand my problem here?

Mbire12-Oct-07 0:13

Mbire

12-Oct-07 0:13

Hi Sam,

My confusion is wat the input is and wat the output should be. Could you please clarify wat you are inputting into the system (whether its start or end time, duration or lunch start and end time), also clarify wat the output u want is and we can take it from there.

Sheers

Sam Heller12-Oct-07 0:29

Sam Heller

12-Oct-07 0:29

I have a start time, created when the job is logged. I have a response time, taken from the contract that covers the job. Therefore I have a 'time to respond to by'. Which is the logged time plus the given time span.

Therefore this final time is what my calculations are aiming towards. My issue is how do I check if my two times have gone over a lunch time or not??

Mbire12-Oct-07 2:24

Mbire

12-Oct-07 2:24

public function getTimeWorked(ByVal StartTime as date, ByVal Duration as TimeSpan, _
ByVal EndTime as date, ByVal LunchStartTime as date, ByVal LunchDuration as TimeSpan) as TimeSpan

dim ActualTimeWorked as TimeSpan
dim TimeWorked as TimeDuration = StartTime - EndTime
if (StartTime < LunchStartTime) and (EndTime > (LunchStartTime + LunchDuration)) then
      ActualTimeWorked = TimeWorked - LunchDuration 
endif
return ActualTimeWorked
end if

Within the same if statement, u can modify the code to get if the guy finished work DURING lunch period and do the necessary calculations or if he started DURING the lunch period and calculate accordingly.

Updating the DataSet

kvs_240711-Oct-07 4:07

kvs_2407

11-Oct-07 4:07

I've written the following code..
for updating the dataset....
I don't know how to update the dataset...
Can u help me the correct code..

Here is the Code...

....First Time After Executing SELECT statement...

Dim mycmd As New OleDb.OleDbCommand
Dim da As New OleDb.OleDbDataAdapter
mycmd.CommandText = qry
mycmd.Connection = conn
da.SelectCommand = mycmd
da.Fill(ds_shifts)

....Now I wanted to Update data in the Dataset...

If ds_shifts.Tables(0).Rows(0).Item(0) = -1 Then
ds_shifts.Tables(0).Rows(0).Item(1) = empid
ds_shifts.Tables(0).Rows(0).Item(2) = "w"

da.Update(ds_shifts) .... this line is giving error.

End If

Happy Day!

Vimalsoft(Pty) Ltd11-Oct-07 4:21

Vimalsoft(Pty) Ltd

11-Oct-07 4:21

What is the Error ?

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

kvs_240711-Oct-07 21:32

kvs_2407

11-Oct-07 21:32

Sorry for not giving error details...

The error is...

"System.InvalidOperationException:Update requires a valid UpdateCommand when passed DataRow collection with modified rows."

Happy Day!

Vimalsoft(Pty) Ltd11-Oct-07 23:55

Vimalsoft(Pty) Ltd

11-Oct-07 23:55

Good morning

This means that you have no Update command specified. look at it this way. you cannot update without the UpdateCommand. for example, if you can try to create everything using a Wizard, just do the drag and drops. in your adapter's Properties there is a update Commnad. it tell the Adapter which column to update, when the update function is invoked as you Did.because you are not using a wizard of which is good, you have to write the updatecommand.
The Updatecommand will like like this.

UPDATE Employee SET Emp_ID = 0918, W = "w"

Hope it Helps