Time stamp insert into database - Visual Basic Discussion Boards

aspnet2312-Mar-08 11:45

12-Mar-08 11:45

I need help creating a login form using VB.NET that will access our Unix system and issue some type of command or run a script once logged in to the system. Can someone help me on this? Thanks in advance. Confused | :confused:

Image Resizing - Webserver Effect

cbjroms12-Mar-08 9:40

cbjroms

12-Mar-08 9:40

I have an application (VB.Net2) which takes an image (JPEG) file and resizes it.

I have tested this application by putting it into a local version of my website (which also contains local copy of my image library) hosted on my PC. The images shown on the web pages are crisp and clear.

But when I put this same version of the website (including image library) onto my remote webserver, the images shown on the served web pages are markedly pixallated (even in areas that are normally flat colour). I have downloaed the images from the image library to check them on my PC and they are fine.

Why should the website produce crsip/clear images when hosted locally yet grainy/pixallated images when hosted on a remote web server?

Thanks in anticipation.

Chris

DLL Problems

parth.p12-Mar-08 8:27

parth.p

12-Mar-08 8:27

Hi, I am just trying to create a DLL in VB.NET and use it in my console application, I know its not worth doing that, but I did.

Here's the code for Dll:

Imports System<br />
Imports System.Threading<br />
Imports Microsoft.VisualBasic<br />
Imports System.Runtime.InteropServices<br />
<classinterface(classinterfacetype.autodual)> _<br />
Public Class Class1<br />
    Public Shared Function Main(ByVal iBigNum As Integer) As Integer<br />
        Dim iRndNum As Random<br />
<br />
        Main = iRndNum.Next()<br />
<br />
        Return Main<br />
    End Function<br />
End Class</classinterface(classinterfacetype.autodual)>

And here's the code for console application:

Module Module1<br />
    Public Declare Unicode Function iRandom Lib "C:\Users\Parth\Documents\Visual Studio 2005\Projects\vbRndDll\vbRndDll\bin\Debug\vbRndDll.dll" Alias "Main" (ByVal iBugNum As Integer) As Integer()<br />
    Sub Main()<br />
        Dim i As Integer<br />
        For i = 0 To 10<br />
            Console.WriteLine(iRandom(3000).ToString)<br />
        Next<br />
    End Sub<br />
<br />
End Module<br />

When I run this Vista gives me error message saying program crashed. But the DOS window is still open and this is the message I get in DOS

Unhandled Exception: System.Runtime.InteropServices.MarshalDirectiveException: Cannot marshal 'retur
n value': Invalid managed/unmanaged type combination.
   at Console_db_VB.Module1.iRandom(Int32 iBugNum)
   at Console_db_VB.Module1.Main() in C:\Users\Parth\Documents\Visual Studio 2005\Projects\Console_d
b_VB\Console_db_VB\Module1.vb:line 7
Press any key to continue . . .

Can anyone tell me what I'm doing wrong??! I'm thinking of using VB.NET in C++ 6.0 and I need .NET code for some of the stuff I want to do. Confused | :confused:

Thanks in Advance. Smile | :)

- Stop thinking in terms of limitations and start thinking in terms of possibilities -

Re: DLL Problems

Nilesh Hapse12-Mar-08 21:17

Nilesh Hapse

12-Mar-08 21:17

I think the problem is with:

Main = iRndNum.Next()<br />
Return Main

Instead you can directly use:

Return iRndNum.Next()

"Legacy code" often differs from its suggested alternative by actually working and scaling.

—Bjarne Stroustrup

How to protect from past onto textbox?

phowarso12-Mar-08 6:32

phowarso

12-Mar-08 6:32

I don't want to permit by using " Ctrl + V " keys onto textbox.
I wanna protect the textbox by using Past function.
How to protect above metter?
Please give me some suggesion... Confused | :confused:

Re: How to protect from past onto textbox?

Xmen Real 12-Mar-08 6:54

Xmen Real

12-Mar-08 6:54

use KeyPress event, and if the pressed button is Control then set Handled = true

hope this will help

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

DataGridView , Expression and Calculation Problem [modified]

fearless stallion12-Mar-08 5:02

fearless stallion

12-Mar-08 5:02

Hi,

I have a Datatable which has a couple of Columns with "Expression" property set.
I have set that Datatable as a DataSource to a DataGridview. Now when I am trying to set a value into one of the column for all the Rows in a loop, it is not calulating the values as set in "Expression" on a single row.

if there are 10 rows then for 9 rows it shows correct value but 1 row it doesn't calulate at all

I checked the loop index but everything is fine.

I am also doing some custom calculations on the "CellValueChangedEvent". Is this because of the event handled separately ??

Can anyone help me on this ? please

thanks in advance

KSS

modified on Wednesday, March 12, 2008 11:10 AM

Time stamp insert into database

Cory Kimble12-Mar-08 4:24

Cory Kimble

12-Mar-08 4:24

I don't know why I am having so much trouble with this. It is only a simple insert into a database. Can someone help me with this. I am so frustrated and the answer is probably staring me in the face.

I want to get the current date in my VB.net desktop program. I then want to insert the date along with an ID and the location. I have tried doing this a number of different ways. But it is not formatting the date correct in the database.

Breakdown:
Code:

Dim shipTo As String = "Test" Dim dateInv As Date Dim ID As String = "11111" Dim command As New OleDbCommand dateInv = Today command.CommandText = "Insert INTO [Physical_Inventory] VALUES(" + shipTo + ", " + ID + "," + dateInv.toShortDate() + ")" command.Connection = connection command.Parameters.Add("ShipTo", OleDbType.VarChar, 20, shipTo) command.Parameters.Add("ID", OleDbType.VarChar, 20, ID) command.Parameters.Add("DateInv", OleDbType.DBDate, 20, dateInv.toShortDate) command.Parameters("ShipTo").Value = shipTo command.Parameters("ID").Value = ID command.Parameters("DateInv").Value = dateInv connection.Open() command.ExecuteNonQuery() connection.Close()

I am trying to update a Access Database and I get 12/30/1899 in the date field.

Can someone help me.

Re: Time stamp insert into database

Parwej Ahamad12-Mar-08 6:25

Parwej Ahamad

12-Mar-08 6:25

Always remember while you are doing perform any operation on Date field with access database always use DateValue() function.

Either Insertion or Updation or Fetching data.

If still your problem persist then let me know.

Parwej Ahamad
g.parwez@gmail.com

Re: Time stamp insert into database [modified]

Cory Kimble12-Mar-08 9:21

Cory Kimble

12-Mar-08 9:21

Do I put the DateValue() in Access? I already have the date in my code. I am trying to send it to Access. How can I do that?

Never mind, found the problem. I needed single quotes on each end of my date variable in my sql statement. Thank you for your help.

modified on Wednesday, March 12, 2008 4:50 PM

Re: Time stamp insert into database

Parwej Ahamad12-Mar-08 17:28

Parwej Ahamad

12-Mar-08 17:28

Put the DateValue() function in your SQL Statement.

This might be create a proble while fetching the records in search criteria on Date field.

Parwej Ahamad
g.parwez@gmail.com

Re: Time stamp insert into database

Cory Kimble24-Mar-08 4:39

Cory Kimble

24-Mar-08 4:39

My issue was I didn't have single quotes in the SQL statement. Thank you.

Janus Control GridEx - Performance Issue

manowj12-Mar-08 3:04

manowj

12-Mar-08 3:04

Hi Everyone,

I have used GridEX control in the application.while expanding the grid, it will take time to load the huge records It`s getting hanged for 30 seconds. scrolling up and down also is hanging for some time. Can anyone help me in this regard.

Regards,
Manowj

Re: Janus Control GridEx - Performance Issue

nlarson1112-Mar-08 9:55

nlarson11

12-Mar-08 9:55

are you doing these around the filling of the grid?

grdNotes.SuspendLayout()
'fill grid here
grdNotes.ResumeLayout(True)

'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

Reading text from Middle of the txt file

Syed Ali Raza12-Mar-08 2:16

Syed Ali Raza

12-Mar-08 2:16

Hi all;
I m reading a txt file from line to line using StreamReader from Begin to End.
Now I want that it should read the file where It left it before. from any line which i want.

Regards,

Ali

Re: Reading text from Middle of the txt file

Xmen Real 12-Mar-08 2:48

Xmen Real

12-Mar-08 2:48

set position of StreamReader by this :

sr.BaseStream.Position

Re: Reading text from Middle of the txt file

Syed Ali Raza12-Mar-08 2:55

Syed Ali Raza

12-Mar-08 2:55

You mean I should do this.
sr.BaseStream.position=10;

//where 10 is line No
or something else.

This is my procedure.

using (StreamReader sr = new StreamReader("C:\\Windows\\System32\\Logfiles\\ex080312.log"))
{
String line;
string [] fieldcontent = null;

while ((line = sr.ReadLine()) != null)
{
Response.Write(" "+ line);

}
}

Re: Reading text from Middle of the txt file

Xmen Real 12-Mar-08 3:02

Xmen Real

12-Mar-08 3:02

no, position is for no. of bytes or characters

hehe, its VB forum and you are asking bout VC# Roll eyes | :rolleyes:

Re: Reading text from Middle of the txt file

AndrewVos12-Mar-08 3:06

AndrewVos

12-Mar-08 3:06

So for each line you read, store the position.

www.wickedorange.com
www.andrewvos.com

Re: Reading text from Middle of the txt file

Syed Ali Raza12-Mar-08 3:14

Syed Ali Raza

12-Mar-08 3:14

Yes I m storing the Line no with each Line. but I want that when I again read this file it should start from where It left.e.g line 10. explain more.

Re: Reading text from Middle of the txt file

AndrewVos12-Mar-08 3:19

AndrewVos

12-Mar-08 3:19

Just store the StreamReader.Position at the same place you're storing the line number, and when you want to read again just set StreamReader.Position = storedposition and you should be able to read the same line again.

www.wickedorange.com
www.andrewvos.com

Blocking specific URLs

Gjm12-Mar-08 1:11

Gjm

12-Mar-08 1:11

How can i block specific URLs using vb.Net.
I do not consider editing the hosts file. Any other way?
Please answer me..

Re: Blocking specific URLs

parth.p12-Mar-08 8:30

parth.p

12-Mar-08 8:30

What do you mean by BLOCKING URL? Do you mean for a computer or something else???

- Stop thinking in terms of limitations and start thinking in terms of possibilities -

Re: Blocking specific URLs

ESTAN13-Mar-08 2:26

ESTAN

13-Mar-08 2:26

If you created a browser function into your program, you can keep up a black list whereto you will validate first the url which the user has given before you go on with it.
Is this what you are looking for?

Textbox Multiple line Problem

Vimalsoft(Pty) Ltd12-Mar-08 0:09

Vimalsoft(Pty) Ltd

12-Mar-08 0:09

Good Morning All

I have a Textbox, where i want my use to enter his Address, So i have set the Multiple propety to True, so that when a user Presses Enter, it should take the Cursor to the Nex line. what is Wrong

Thanks

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

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