Combobox data connetivity [modified] - Visual Basic Discussion Boards

srinivassam12-Jun-07 2:15

12-Jun-07 2:15

Hi,my problem is my project was developed in asp.net with c# but my visual source safe schedular is working on windows.In vss i have all the document files,pdf files,excel files.It's starts working on everyday night 12.00am.so while schedular running time doc files,pdf files,excel files phisical path is converted to html path(/).So sometimes if any document file has any problem the is stopped upto that document afterthat it doesn't continue.So what i want is if any document file has problem then schedular ignores that document and it goes to next document.iam sending some classes in my vss.
<pre>
public function get vss connection()
Public Function PopulateProject() As Boolean
Private Function PopulateSubProject(ByVal sParent As String, ByVal ItemIsDeleted As Boolean) As Boolean
Private Function Traverse(ByVal sProjectPath As String, ByVal SWFPath As String)
Private Function PopulateFiles(ByVal sParentID As Long, ByVal sProjectPath As String, ByVal sFolderPath As String) As Boolean
Private Sub InsertMenuRights()
Private Sub InsertDocNames()
Private Sub CreateFolder(ByVal Path As String)
Private Function GetNWExt(ByVal FileName As String) As String
Public Sub Conversion()
Private Function GetHTMLPath(ByVal FilePath As String)
Private Sub DocToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub PptToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub PDFToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub ExcelToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Function GetTPath(ByVal DocPath As String)
Private Function GetTruncPath(ByVal HTMPath As String)
</pre>

samrama

windows based schedular not working

srinivassam12-Jun-07 2:15

srinivassam

12-Jun-07 2:15

Re: windows based schedular not working

Tarakeshwar Reddy12-Jun-07 2:54

Tarakeshwar Reddy

12-Jun-07 2:54

You had already asked the same question 6 hours back and when someone knows the answer to it, they will answer. Delete your duplicate posts.

Path

Brendan Vogt12-Jun-07 1:18

Brendan Vogt

12-Jun-07 1:18

Hi,

I need to create a path for where my XML needs to be saved, but I need to get the path where the web files are saved on the server. In classic ASP I think I used Server.MapPath or something like that. The reason why I don't want to hard code is because certain hosting companies save the website on the C: drive, or f: Drive, etc.

Please can someone help? I'm using VB.NET 1.1.

Regards
ma se

Re: Path

PandemoniumPasha12-Jun-07 1:42

PandemoniumPasha

12-Jun-07 1:42

hi,
the same works in asp.net as well Cool | :cool:

if it is a windows application use: "Application.StartupPath"

regards

Re: Path

Brendan Vogt12-Jun-07 1:58

Brendan Vogt

12-Jun-07 1:58

It's a web application, how would I do it now??

Re: Path

Steven J Jowett12-Jun-07 2:01

Steven J Jowett

12-Jun-07 2:01

System.AppDomain.CurrentDomain.BaseDirectory.ToString

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

Combobox data connetivity [modified]

Aman.Jen12-Jun-07 0:35

Aman.Jen

12-Jun-07 0:35

Hi,

If I take a combobox on form, what I want is I want to store data selected from combobox to database. Take for example.

Combobox has 3 options-->>1)Mr. 2)Mrs. 3)Miss

Now what I want is if i select any one option from this it should
be stored in my data base(Access).

How to write a query for this, which event i should take on combobox.
Do I need 2 tables for this. I mean one for their details and one for Mr.,Mrs,Miss

Please solve my query

-- modified at 7:45 Tuesday 12th June, 2007

Nitin Jenwal

Re: Combobox data connetivity

Christian Graus12-Jun-07 2:04

Christian Graus

12-Jun-07 2:04

You can handle a selected index changed event. How you handle it depends on if you want to write your record again for every field that changes, or if you want a save button.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )

create chart by vb.net

xuyuan11-Jun-07 23:26

xuyuan

11-Jun-07 23:26

i'm using vb.net to develop a system, and need to create chart(histogram/graph). Value should get from my database. But i dun have any idea on how to call out the value from the database to the chart..

anybody an idea on this?

thousand thanks for your help..

Re: create chart by vb.net

Christian Graus12-Jun-07 1:43

Christian Graus

12-Jun-07 1:43

What's generating the chart ?

windows schedular is not running

srinivassam11-Jun-07 20:45

srinivassam

11-Jun-07 20:45

in my project is asp.net with c# project but my vss schedular is asp.net with vb.net.
Every this schedular is running on night 12.00am .
In that schedular i have somany doc files and excel files,.pdf files.
So while schedular running time html paths and actual document paths but some times it automatically stopped then i want do if any document contains problem then schedular ignore's that document and goes to next document.For this i want code. Iam sending some of the classes of the my project.
<pre>
public function get vss connection()
Public Function PopulateProject() As Boolean
Private Function PopulateSubProject(ByVal sParent As String, ByVal ItemIsDeleted As Boolean) As Boolean
Private Function Traverse(ByVal sProjectPath As String, ByVal SWFPath As String)
Private Function PopulateFiles(ByVal sParentID As Long, ByVal sProjectPath As String, ByVal sFolderPath As String) As Boolean
Private Sub InsertMenuRights()
Private Sub InsertDocNames()
Private Sub CreateFolder(ByVal Path As String)
Private Function GetNWExt(ByVal FileName As String) As String
Public Sub Conversion()
Private Function GetHTMLPath(ByVal FilePath As String)
Private Sub DocToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub PptToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub PDFToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Sub ExcelToHTML(ByVal FilePath As String, ByVal HTMLPath As String)
Private Function GetTPath(ByVal DocPath As String)
Private Function GetTruncPath(ByVal HTMPath As String)
where i will mention code in this classes.Please help me.
</pre>

samrama

execute a command to TURN ON THE PC ON A SPECIFIC TIME

koolprasad200311-Jun-07 19:35

koolprasad2003

11-Jun-07 19:35

hello all,

IS IT posible in vb.net to create a program that execute a command to TURN ON THE PC ON A SPECIFIC TIME??

i am using vb.net 2.0

hope anyone could help me!

any Code ???? Link ???

THANKS!
koolprasad2003 Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: execute a command to TURN ON THE PC ON A SPECIFIC TIME

Christian Graus11-Jun-07 19:48

Christian Graus

11-Jun-07 19:48

Yes, it's possible, but only if the mother board supports it. Unless the mother board is willing to turn itself on, it's not really possible. Doing it via VB.NET will only work if the code is running on another machine, and the machine being switched on has mother board features that your code can access.

Unless your code drives a robot that pushes the power button.

Re: execute a command to TURN ON THE PC ON A SPECIFIC TIME

koolprasad200311-Jun-07 20:31

koolprasad2003

11-Jun-07 20:31

Thankx Christian ,
Thankx a lot,

can u give me code sample or any useful links ???

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: execute a command to TURN ON THE PC ON A SPECIFIC TIME

Christian Graus11-Jun-07 21:14

Christian Graus

11-Jun-07 21:14

Some motherboards have wake on LAN, I'd expect those can be started with LAN activity. No, I have no code, I think it's a wild goose chase in most cases.

Resolution Problem Pls Help

kankeyan11-Jun-07 17:56

kankeyan

11-Jun-07 17:56

We developed a VB project in 1024 by 768 pixels its good .When we want to view this in 800 by 600 pixels format. So many things are hidden how to view it or rectify it.Pls give me a solution

Kankeyan

Re: Resolution Problem Pls Help

MatrixCoder11-Jun-07 18:06

MatrixCoder

11-Jun-07 18:06

Try docking your controls so that they maintain equal amount of form space.

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Re: Resolution Problem Pls Help

Christian Graus11-Jun-07 19:50

Christian Graus

11-Jun-07 19:50

You need to set the anchor property on your controls, so they size themselves automatically.

Date

Socheat.Net11-Jun-07 17:24

Socheat.Net

11-Jun-07 17:24

HI, I have problem don't know what to do? I want to substract date, example.

Date July/07/07
Date Today June/12/07
Result "Date - Date Today" , What do i do?
I want to get result of the day "Left 25 days"

Socheat

................

Re: Date

MatrixCoder11-Jun-07 17:29

MatrixCoder

11-Jun-07 17:29

You would use the DateTime.Subtract method.

Dim StartDate As New System.DateTime(2007, 6, 11, 12, 0, 0)
Dim EndDate As New System.DateTime(2007, 7, 12, 12, 0, 0)

Dim TotalDate As System.TimeSpan
TotalDate = EndDate.Subtract(StartDate)
MsgBox(TotalDate.TotalDays & "Days Left")

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Re: Date

Socheat.Net11-Jun-07 17:37

Socheat.Net

11-Jun-07 17:37

I get an error.
Type "System.TimeSpanTotalDate" is not defined.

So what can i do?

Socheat

................

Re: Date

MatrixCoder11-Jun-07 17:39

MatrixCoder

11-Jun-07 17:39

It should work. Could you please post your code?

Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.

Re: Date

Socheat.Net11-Jun-07 17:51

Socheat.Net

11-Jun-07 17:51

It work now.

Dim StartDate As New System.DateTime(2007, 6, 11, 12, 0, 0)
Dim EndDate As New System.DateTime(2007, 7, 7, 12, 0, 0)
Dim TotalDate As System.TimeSpan = EndDate.Subtract(StartDate)
response.Write(TotalDate.TotalDays & " days left")

By the way I want to get day and time left like N7W "24 days nad 2hours left"

Socheat

Re: Date

Sathesh Sakthivel11-Jun-07 18:08

Sathesh Sakthivel

11-Jun-07 18:08

substituting minutes, seconds, days, or whatever interval you are looking for in the place of 'hours'. Well, in Visual Basic .NET there are two main ways to achieve this result; the DateDiff function or through the TimeSpan structure.

Both of these methods are equally valid, where they overlap in functionality, but each of them has a couple of unique features. Despite their similar functions, the core difference between the two is that DateDiff is a function, so you need to call it every time you need to retrieve a value, whereas TimeSpan is a structure that is created once and then you just work with its various members as needed.

Using DateDiff, you call it with different date interval parameters to retrieve the appropriate value:

Dim D1, D2 As Date
D1 = Date.Now
D2 = 11/9/2007 'DateDiff
Console.WriteLine("DateDiff")
Console.WriteLine()
Console.WriteLine("{0} Days", _DateDiff(DateInterval.Day, D1, D2))
Console.WriteLine("{0} Hours", _DateDiff(DateInterval.Hour, D1, D2))
Console.WriteLine("{0} Minutes", _DateDiff(DateInterval.Minute, D1, D2))
Console.WriteLine("{0} Seconds", _DateDiff(DateInterval.Second, D1, D2))
Console.WriteLine()

Hope this code will Help you.

Regards,

Satips. Rose | [Rose]

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