|
|
Then show the SQL statement and elaborate on the outcome
|
|
|
|
|
We have a SQL forum, you know.
The round function does obviously help you, because you can round off the number.
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 )
|
|
|
|
|
How can i put a name for the datagride for the first row and then i want to put a spacifec value in the same coloum
examlpe
i want to put in the first row "vodafone" and under the word vodafone i want to put "20"
and then i was asking if there is to many number and i want to add them in one row as "total"and the total of them will be under this word "total"
thanks you all
|
|
|
|
|
Hi all:
Is there any way to make a particular item of the datagird unediatble ( ie a cell) ?
I'm using VB.NET 2003.
I'd appreciate your help in advance.
|
|
|
|
|
Hi, I was wondering if anyone could help me out w/ this. Ive been searching for days now and cannot find any information or help w/ this. I want to run specific programs within my vb.net application/form. I dont want the apps to launch separately from my form. I know theres a way to run them within the space of your vb.net form, because Ive seen it done before, but Im not sure what code/declaration to use.
Heres my code so far if it helps, Im using notepad just as an example:
Public Class Form1<br />
<br />
Private Sub AboutToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AboutToolStripMenuItem.Click<br />
MsgBox("Created by.....")<br />
End Sub<br />
<br />
Private Sub NotepadToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NotepadToolStripMenuItem.Click<br />
Start.Process("Notepad.exe", AppWinStyle.NormalFocus)<br />
End Sub<br />
End Class
Any help or tips would be great. Thank you
|
|
|
|
|
y2ktheory wrote: I know theres a way to run them within the space of your vb.net form
There kind of isn't, what makes you think otherwise ? You may be able to embedd an app by making it a child window of your form, but it wouldn't be clean, or recommended.
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 )
|
|
|
|
|
Sorry...I guess im not exactly sure. Ive seen an app made w/ vb that could run notepad, paint, and a few other simple things within that space. Ive also been told it can be done by someone else he said
"Some Applications offer ActiveX Controls which can be used by other applications in their programs (Such as Windows Media Player, MS Word etc.)
I'm not aware of a Notepad ActiveX Control so you will have to use a large text-box in your form and write the menu yourself"
If I wanted to make a child window in my form, how would I tell the program to output/display in that window? Would I use something like txtGetText.... or showdialog..., im just now sure how to get it to stay within the form =/
|
|
|
|
|
y2ktheory wrote: Some Applications offer ActiveX Controls which can be used by other applications in their programs (Such as Windows Media Player, MS Word etc.)
I'm not aware of a Notepad ActiveX Control so you will have to use a large text-box in your form and write the menu yourself"
OK, what this guy said was - "some applications have special controls written, which allow you to create instances of applications within your app. However, Notepad does not do this, so you basically have to write the ( incredibly simple ) functionality yourself"
y2ktheory wrote: If I wanted to make a child window in my form, how would I tell the program to output/display in that window?
If you did this, the window would not be in any way under the control of your application. Following the other guys advice, is more sensible. I did say it's not a good thing to do.
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 )
|
|
|
|
|
alright, thanks for your help, I appreciate it
|
|
|
|
|
glad to help
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 )
|
|
|
|
|
On most controls there is a small black arrow in a white box that provides ways to quickly change properties of the control. How do I add additional properties to this tasks menu?
Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"
|
|
|
|
|
I am very new to vb. I am trying to write an program which searches through all the word docs. in a directory.
I have a list of 20 stirngs I am looking for. I am sure only 1 of the strings is found in each file.
I have tried to write this several diferent ways but none works. I think I need two arrays and to loop through both and output the found strings, file names, and dates of the files to a spreadsheet.
Any help would be greatly appreciated.
Public Class Form1
'Create a list of doctors as an array.
'Create a list of files in the remote folder as an array
'Loop thru the “files array” and look for each doctor
'Write the doctor name, filedate, sysdate, and file name to a spreadsheet
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' For Each strFile As String In My.Computer.FileSystem.Getectories("C:\batch")
'Add the item to the list
'ListBox1.Items.Add(strFile)
'If String.Compare(strDoc) Then
Dim doc1 As String = "ledford"
Dim list As System.Collections.ObjectModel.ReadOnlyCollection(Of String)
list = My.Computer.FileSystem.FindInFiles("C:\batch", doc1, True, FileIO.SearchOption.SearchTopLevelOnly)
For Each name As String In list
ListBox1.Items.Add(name)
Next
'End If
''''''Assign the files found in the list above as a variable and replace for file1.log
'Dim information As System.IO.FileInfo = My.Computer.FileSystem.GetFileInfo("C:\batch\file1.log")
'MsgBox("The file's full name is " & list.FullName & ".")
'MsgBox("Last access time is " & list.LastAccessTime & ".")
' Next
End Sub
'Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
' Dim arrayDocs (of string)
' arrayDocs(0) = "sexton"
' arrayDocs(1) = "wargo"
' arrayDocs(2) = "ledford"
' arrayDocs(3) = "koepke"
' For Each strDoc As String In arrayDocs
' ListBox2.Items.Add(strDoc)
' Next
'End Sub
End Class
-Kevin
|
|
|
|
|
This is how I might go about it. Hope it gives you the right idea.
Const directoryPath As String = "C:\test" ' The directory to look in
Dim desiredFiles As New List(Of String) ' List of files we're looking for
With desiredFiles ' Note I didn't use file extensions. Change that if you'd like.
.Add("File1") ' but you'll need to tweak the code below if you do.
.Add("File2")
End With
' METHOD 1
' Create a DirectoryInfo object for the desired directory
' to look in.
Dim info As New IO.DirectoryInfo(directoryPath)
' Get all the *.doc files in the directory
For Each file As IO.FileInfo In info.GetFiles("*.doc")
' The contains method is case sensitive. If you want a case-insentive
' search you can add the desired file names in all lower or uppercase and then use the
' ToLower or ToUpper methods on the file name
If desiredFiles.Contains(IO.Path.GetFileNameWithoutExtension(file.Name)) Then
' The file name was found in our list
MsgBox("Directory contained file: " & file.Name)
End If
Next
' METHOD 2
For Each file As String In desiredFiles
If IO.File.Exists(IO.Path.Combine(directoryPath, file & ".doc")) Then
MsgBox("Directory contained file: " & file)
End If
Next
|
|
|
|
|
how can i control the parallel port using visual basic??
coz' i would like to use my pc to be like a switch in a electronic door lock
but i don't know how to use the parallel port usnig the visual basic..
hope you can help guys.. thanks..
|
|
|
|
|
try {
search CodeProject articles
} catch {
search Google
}
or the Basic equivalent...
|
|
|
|
|
I'm trying to fetch mail from Outlook Exp using the MAPI components, but the mail is always fetched from the default Local folder which never gets updated with new mail. Am I doing something stupid here?
How can I do a Fetch from my newly created hotmail folder?
|
|
|
|
|
hi
i am trying to add a row to datagridview using datagridviw1.rows.add(dgv.rows(1))
i am getting "Row provided already belongs to a DataGridView control" this error
how i can overcome this problem .
how i can add a row of one datagridview to another datagridview
with regards
Balagurunathan.B
|
|
|
|
|
I need to know how to develop an application which is using SQL server 2005 .
I know that that the DB should DB placed in a server and the application should be placed in a client machine.
But i don't know that how to do it through code (C#).
Hope your support as soon as possible.
|
|
|
|
|
hi
to do the same install sql server 2005 on server then install client software on client machine then when you go for the database connection coding for the software use the connection string in the following manner
connectionString="Data Source=Computer2;Initial Catalog=TRS;User ID=sa"/
it will create a client server application
with regards
Yogesh Agarwal
|
|
|
|
|
Hello friends
i want to give my developed project to client but i want to give the CD keys option into it so that others can't use my software how could ido that.
plz reply
|
|
|
|
|
Generating CD keys is a generally tightly kept secret. I would probably go with some kind of strong hash function/registry key/etc. No real quick simple answer for you. You may want to look into GUIDs as well. More things you plug into your hash/CD key, possibly more difficult it is for someone to try and crack it.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
hello frnd,
i have a Excel file with data and i want to import that excel file in MSSqlServer using vb6.0,
how can i do that....please help
if any one have code then please give me...
any helpful link ????
thankx in advance
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
hi,
These is the routine I am using. It works fine..
I move the each cells to an specific field (str... = string or int... =
integer) and I use the fields to update the data base.
I hope it helps you
===================================================================================
Option Explicit
Dim xl As New Excel.Application
Dim xlw As Excel.Workbook
Private Sub Excel name_KeyPress(KeyAscii As Integer) ' the combo-box
has
the Excel name
If KeyAscii = 13 Then
Set xlw = xl.Workbooks.Open("C:\List\Excel\" _
& Excel name)
xlw.Sheets("Plan1").Select
' start in the second row because the first one it is the head
x = 2 '(Row)
Do While xlw.Application.Cells(x, 1).Value <> ""
strTratamento = xlw.Application.Cells(x, 1).Value
strNomeConvidado = xlw.Application.Cells(x, 2).Value
intQtde = xlw.Application.Cells(x,3).Value
strName01 = xlw.Application.Cells(x, 4).Value
strName02 = xlw.Application.Cells(x, 5).Value
strName03 = xlw.Application.Cells(x, 6).Value
strName04 = xlw.Application.Cells(x, 7).Value
strName05 = xlw.Application.Cells(x, 8).Value
strName06 = xlw.Application.Cells(x, 9).Value
strName07 = xlw.Application.Cells(x, 10).Value
strName08 = xlw.Application.Cells(x, 11).Value
intDDD01 = xlw.Application.Cells(x, 12).Value
strTelefone01 = xlw.Application.Cells(x, 13).Value
intDDD02 = xlw.Application.Cells(x, 14).Value
strTelefone02 = xlw.Application.Cells(x, 15).Value
intDDD03 = xlw.Application.Cells(x, 16).Value
strTelefone03 = xlw.Application.Cells(x, 17).Value
strOrign = xlw.Application.Cells(x, 18).Value
strObservers = xlw.Application.Cells(x, 19).Value
' Include here the routine to update the SQL Server data base
x = x + 1
Loop
xlw.Close False
Set xlw = Nothing
Set xl = Nothing
subLiberaForm
Screen.MousePointer = vbDefault
End If
End If
End Sub
Regards
IPS
|
|
|
|
|
hi my friends
my english is weak, so i use simple sentences
I emergency need some code of vb.net
i want to find my harddisk serial number
i want to find my mainboard serial number
i want to find my cpu serial number
serial number or id , not difrent.
if u have
please insert them here
or send to me Golab_omidreza@yahoo.com
thanks
|
|
|
|