Visual Basic

Christian Graus9-Apr-08 20:45

Re: help..urgent ..insert time to database [modified]

9-Apr-08 20:45

I'm sorry but you haven't made a simple error, you seem just to have no idea what you're doing. Are you being paid for this code ? I'm assuming you're working on code that someone else wrote. If my previous answer doesn't help ( replace that ddmyyy stuff with a function call in a stored proc to get the current date/time, I really don't know where to begin in unravelling this mess for you.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Member 44429169-Apr-08 21:15

Member 4442916

9-Apr-08 21:15

nop...this my assignment...coding i do myself..i get the query idea from update..i think is that similar..so i use update idea change to insert...actually how to function call in a stored proc to get the current date/time..can give some example..thanks

if i do another way it give me error also

Dim adpLogin As OleDbDataAdapter<br />
        Dim oleCommand As New OleDbCommand<br />
        Try<br />
            adpLogin = New OleDbDataAdapter<br />
            conDatabase.Open()<br />
            oleCommand.CommandText = "INSERT INTO [LOGIN] (Login_No, Login_Date, Login_Time, Staff_ID) " & _<br />
            "VALUES ('" & Format(Date.Today, "ddMMyyyy").ToString & Format(Date.Now, "HHmmss").ToString & _<br />
	    "', #" & Format(Date.Today, "dd/MM/yyyy") & "#, #" & Format(Date.Now, "H:mm:ss") & _<br />
	    "#, '" & txtUserID.Text.ToUpper() & "')"<br />
<br />
            oleCommand.Connection = conDatabase<br />
            adpLogin.InsertCommand = oleCommand<br />
            adpLogin.InsertCommand.ExecuteNonQuery()<br />
        Finally<br />
            conDatabase.Close()<br />
        End Try

the error is about condatabase.open

modified on Thursday, April 10, 2008 3:36 AM

Christian Graus9-Apr-08 22:19

Re: help..urgent ..insert time to database [modified]

9-Apr-08 22:19

You should store dates using hte date data type, not as a string.

That's not your core issue. Your core issue is that you're guessing, you should start with a book or online article that explains how this stuff works.

Member 44429169-Apr-08 22:36

Member 4442916

9-Apr-08 22:36

ok..i will do it as what you say...if were you..how do you write code..that can allow user once enter the password and ID..the time and date will automatically store in to database. give some format or ideas or coding me refer..i really appreciate it..

modified on Thursday, April 10, 2008 5:16 AM

Christian Graus10-Apr-08 0:05

10-Apr-08 0:05

I'd always use a stored proc, and when the username/password are passed in to check, if they match, I'd return a 1 to say login was successful and then use getdate() to store the current date and time.

Member 444291610-Apr-08 3:38

Member 4442916

10-Apr-08 3:38

can show the codes...bcs i just start my college...really lots of thing i donot know...if kinds can show codes let me refer...what is getdate() isit a function?thanks

Christian Graus10-Apr-08 12:54

Re: MessageBox stuck in loop

10-Apr-08 12:54

getdate() is a function inside SQL Server that returns the current date/time on the server.

MessageBox stuck in loop

Joe DiNatale9-Apr-08 16:05

Joe DiNatale

9-Apr-08 16:05

I have a search dialog form with a text box where the user enters the search terms and a button which executes the search. The text box traps the keyup event so that the user can just press enter and initiate the search instead of clicking on the button. When the search does not return any results, a message box pops up informing the user. The problem is that if the user clears the message box by pressing enter instead of clicking the OK button, the text box gets the keyup event again, performs the search again, puts up the message box... I was able to avoid this by disabling the textbox before showing the message box and then reenabling it after but this moves the focus to the next control. Moving the focus back to the text box (in code) causes the same behavior. Does anyone know of another way to fix this?

Joe

Johan Hakkesteegt9-Apr-08 20:09

Johan Hakkesteegt

9-Apr-08 20:09

Try to use the textbox's KeyPress event instead of KeyUp:

<br />
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.EventArgs) Handles TxtFileName_DEV.KeyPress<br />
If e.KeyChar = Chr(13) Then<br />
If TextBox1.Text = "" then<br />
'Just jump out of the sub so your code does not try to search for nothing<br />
exit sub<br />
End If<br />
'Reaction when the enter key gets pressed<br />
End If<br />
End Sub

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

Re: MessageBox stuck in loop

Joe DiNatale10-Apr-08 4:58

Joe DiNatale

10-Apr-08 4:58

Perfect! That did the trick.

Thank you very much,
Joe

Trying to transfer data with filters.

Dirtyd9-Apr-08 15:53

Dirtyd

9-Apr-08 15:53

I have a data logging program already set up that takes data from a serial connection and saves it to a excel file, but now what I need help with is taking the specific data from the one file and insert it into another while using calculations so the numbers will fill one column until a predifined number is reached then auto fill to the next column and so on and so on until it has to transfer to another sheet then continue the same process. Wow that does sound like alot to ask for so any little bit of that would be great in getting me started.

Dave Kreskowiak10-Apr-08 3:28

Dave Kreskowiak

10-Apr-08 3:28

Why are you using an Excel file for this?? This sounds like you should be using a database. Managing the column use and figuring out when to start a new sheet is going to be a pain that you don't need to put up with if you just used the appropriate data store. You can then export what you need from the data to an Excel sheet whenever you need.

A guide to posting questions on CodeProject[^]

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

Dirtyd21-Apr-08 2:34

Dirtyd

21-Apr-08 2:34

Let me start with a brief explanation of what this is for. My company builds concrete water tanks and in this process we prestress the tank with wire pulled to 3000lbs of tension we then put this info into an excel sheet that tells hows how much wire would be required in the next layer. It is critical that a certain number is obtained in prestress to achieve the strength required for our tanks. I am using this approach because the load cell that is taking the reading transmitts in ascii and I have found an excel program for communicating and retrieving the data. I have to then put it back into another excel sheet that takes those numbers and calculates the total number of wires needed in the next layer. I understand that this is a major undertaking and that is why I have turned to this site for help.

Dave Kreskowiak21-Apr-08 3:45

Dave Kreskowiak

21-Apr-08 3:45

OK. If you're not very familiar with Excel, learn - now. In order to pull this off, you're going to need knowledge of Excel's object model. You can get the overview of the objeect model here[^]. Microsoft's Developer Center for the Visual Studio Tools for Office is here[^].

A guide to posting questions on CodeProject[^]

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

Extending a class in Main.aspx.vb (inheritance) - newbie question.

Dirtyd23-Apr-08 13:06

Dirtyd

23-Apr-08 13:06

Thank you those are good links. Are there any other good links for code help. in explaining what code performs what function?

MadMaxToronto9-Apr-08 15:50

MadMaxToronto

9-Apr-08 15:50

Hi Everybody,

I'm new to .NET and having a hard time figuring out how to extend a class in Main.aspx.vb (code behind main page).

Here is what I have:

(Main.aspx.vb)

Partial Class Main<br />
    Inherits System.Web.UI.Page<br />
<br />
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        Label1.Text = "it works"<br />
    End Sub<br />
End Class

I've added a class called MainExtended.vb in the App_Code folder. I basically want to inherit "Partial Class Main" so I can write code in MainExtended class that can access the controls in Partial Class Main.

Can somebody guide me in the right directions? I've done lots of reading on inheritance... but I can't seem to get it to work - could not find an example that shows me how to get it working.

Thanks in advance.

Re: Extending a class in Main.aspx.vb (inheritance) - newbie question.

Mycroft Holmes9-Apr-08 16:55

Mycroft Holmes

9-Apr-08 16:55

Why are you creating an additional class?

Go to the designer, doubclick on the button, this should create the code in main.aspx.vb. Put your code in there.

Re: Extending a class in Main.aspx.vb (inheritance) - newbie question.

Dave Kreskowiak10-Apr-08 3:22

Dave Kreskowiak

10-Apr-08 3:22

I have no idea why you're doing this since this code should be in your Main class. Any code that manipluates the controls of a form should be in the form's class, not in a seperate class.

But, you can just create a standalone class with a method that takes a controls collection as a parameter. Or, create a class that inherits from Main. Neither of these is a good idea - use at your own risk.

Public Class MyOtherMainForm
    Inherits Main
        ...
End Class

A guide to posting questions on CodeProject[^]

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

Having a form in a VB.NET DLL file?

LloydA1119-Apr-08 12:38

LloydA111

9-Apr-08 12:38

Hiya,

I was just wondering if it was possible to have a form inside a VB.NET dll made in VB 2008??
I can click on Project|Add Windows form... but when I type something like "Form1.Show" it says:
"Reference to a non-shared member requires an object Reference".
So I'm guessing I would have to somehow make the Form "A shared member" but I dont know how to do this.

Any help will be greatly helpful,
Thanks Lloyd A.

P.S. I've honestly tried looking on the internet on this subject but I was unsuccesful in finding anything helpful.

Lloyd J. Atkinson

"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein

The most annoying thing about Microsoft is its obsession with change.

Re: Having a form in a VB.NET DLL file?

Mitch F.9-Apr-08 14:31

Mitch F.

9-Apr-08 14:31

I haven't actually tried to do that before, but you would normally use something similar to the code below to open up a new form.

Dim frmNew As New Form1<br />
frmNew.Show()

(I'm writing this from memory, I don't have VS open right now)

Re: Having a form in a VB.NET DLL file?

LloydA1119-Apr-08 14:37

LloydA111

9-Apr-08 14:37

Hiya,
This seems to work, thanks, I didnt know that it was as simple to use forms in DLL files! Thanks again! Smile | :)

Lloyd J. Atkinson

"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein

The most annoying thing about Microsoft is its obsession with change.

get the value of a textbox with only its name as string

robby19779-Apr-08 11:08

robby1977

9-Apr-08 11:08

Hello

i am trying to get a value from a textbox but i just have its name in a string varriable

like in php $$name

can somebody help me

thanks

kosmas

Re: get the value of a textbox with only its name as string

Christian Graus9-Apr-08 11:18