|
|
I need help in displaying personnel photos stored in a SQL 2000 table either in a field with datatype image or a field with datatype nvarchar which has the path to the photo. Which is better to use?
I have a vb6 project with a Picture box, but when I set the DataField property to the field name, the photo does not display. I have a DataGrid that lists each personnel name, so I want to be able to select a record and the person's picture displays in the Picture box. The DataGrid's DataSource property is set to an ADODC data control.
I can do this easily with the table being in Access using the OLE control and setting the DataField property to the field name in the Access table. But the user wants to move the tables to SQL 2000 and wants to update the VB6 project to use ADODC data controls instead of the intrinsic data control.
Any help would be greatly appreciated.
And I thought this would be an easy task.
|
|
|
|
|
Need some help. Can someone advise how I can transpose columns and rows - with datagrid from a database. Or is there a different approach. I'm trying to develop a Corporate Finance module which requires financial statements to be presented as columns even though the information is stored as rows in Access.
Some background: I used to be an excellent Pascal programmer, after 10 years of programming I left IT in 1992. I bought Visual Basic .NET about 2 weeks ago - it is a culture shock even though I have picked up VB 6.0 and Access.
Vision is everything
|
|
|
|
|
In vb.net I found installer class so I want to know what is the utility of installer class and how cani use it and also please tell me from where I could know about installer class in detail.
tbhattacharjee
|
|
|
|
|
|
They're there for a reason, you know.
|
|
|
|
|
In Visual basic there is api viewer which provide functions and constant etc which can be called from vb but in vb.net I could not find utility like api viewer so that is why how could I know which api functions can be called from vb.net and from where I could know
Which api functions can be called from vb.net .please tell me.
tbhattacharjee
|
|
|
|
|
Pretty much all the API calls can be called from VB.NET - but because the framework provides about 90% of the functionality of the API it is prefereable to look therein first.
Do a search in the help on <DLLImport()> attribute and look at the System.Interop namespace
'--8<------------------------
Ex Datis:
Duncan Jones
<a href="http://www.merrioncomputing.com">Merrion Computing Ltd</a>
|
|
|
|
|
a) I have some question about .Net Data Grid Control like how could I assign ‘n’ of empty rows to datagrid when I will click on a button.
b) How could I get Row and Column position when I will click on a specific cell?
c) How could I get the value when I will click on a specific cell?
d) How could I assign value to a specific cell when I will click on button?
e) How could I get Cell top, Cell left, Cell width, Cell height when I will click on a specific cell?
f) How could I assign 0 to a specific column width?
All the properties are available for flexgrid. So please tell me answers of all my question of .Net Data Grid and also provide sample class.
tbhattacharjee
|
|
|
|
|
|
I often use FlexGrid in Visual Basic to take multiple input from user.let me give you a example say suppose at the time of form load form will have 100 rows and two column
When I will click on any cell of first column then on that column textbox will appear
And When I will click on any cell of second column then on that column combo box will appear in this way I will take multiple input from user and save those input in table.
In vb.net I tried to work with FlexGrid which is com control all the property of FlexGrid
Is working well but when I try to design same thing which works fine in vb but I got problem in vb.net. Let me tell you what I designed in vb.net. In vb.net project I have one form and I took FlexGrid which is com control and a textbox and a combo box which is
.net control and I apply the same logic which work very well .the logic is when I will click on any cell of the first column of FlexGrid then text box will appear in that cell and when I will click on any cell of the second column of FlexGrid then combo box will appear in that cell. In vb.net textbox and combo box moving perfectly but does not appear on any cell of FlexGrid that is my problem. If any body can solve the problem then please let me know every thing in detail step by step and sample code also I will be highly obliged. My doubt is in my vb.net project .I have taken a FlexGrid com control and other two textbox and combo box is .Net control it could be reason that why textbox and combo box is moving to the right place but does not appear on cell of FlexGrid. Please help me some one to achieve my output.
tbhattacharjee
|
|
|
|
|
I can't use API Function SearchPath in VB.Net. Help me.
|
|
|
|
|
I'm writing a console app that when the user types in a number it gets stored into an arraylist. When they type in certain commands it does misc. things, therefore the input is set to string. However if they type an invalid string that is not one of the preset commands or an integer I want to give them an error message. The issue I'm running into is checking wether the string is an integer or not. If someone can point me into the right direction I would appreciate it.
Thanks in advance. :>
To see one's self from another's point of view is an opportunity not to be passed up.
|
|
|
|
|
Try using Int32.Parse()
This function converts a string into a Int32 type.
You can find more info in Help
Free your mind...
|
|
|
|
|
I need extract audio in mp3 format from video files (avi or mpeg).
How can i do this ?
Thanks
|
|
|
|
|
Can anyone help.
I am trying to create an SQL statment and in the WHERE clause the text being searched for has a ' in.
For example
"SELECT * FROM [computer list table] WHERE [Computer Owner] = Damian's computer"
The problem i am having is with the Damian's Computer. It seems to get upset with the '
Any help would be much appreciated
|
|
|
|
|
Use 2 '' instead...
"SELECT * FROM [computer list table] WHERE [Computer Owner] = Damian''s computer"
Free your mind...
|
|
|
|
|
I usually creates a function PadApostrophe(strText as string) which will replace every single instance of ' with '' (two single quotes).
But recently I read this is not a very good way to do it, so if you're using SQL command object you can pass parameters instead and you don't need to replace the '.
Hope this helps!
|
|
|
|
|
|
Here is what I do.
I create a constant called QUOTES as below.
Const QUOTES = """"
I then create a function called SQLstring as below.
Public Function SQLstring(StringIn as String)as String
SQLstring = QUOTES & StringIn & QUOTES
End Function
So now if I want write an SQL statement that needs a string within a string, I do the following:
Dim SQL as String
Dim State as String
State = "CA"
SQL = "SELECT * FROM Table WHERE State = " & SQLstring(State)
The resulting SQL will be as follows:
SELECT * FROM Table WHERE State = "CA"
Is this what you are looking for?
|
|
|
|
|
I'm working on a vb app that I would like to connect to an ftp server and execute a few predefined commands. Basically what I'm looking to do is connect daily and d/l a file. I couldn't find anything in the codebank for vb.net, so I'm asking here.
Also, I'll be adding a feature that connects to a telnet server and executes a set a predefined commands as well, I would think the solution to the first problem will also solve this one.
I've read through my books but can't seem to figure out what to use to do what I want. Any help is appreciated.
Thanks.
|
|
|
|
|
For the FTP portion - check out the article and code by Alex Kwok
I reference his C# component in my VB app and use it regularly. I've had to make a few changes to account for odd directory listings but even though I'm not a C# programmer I had no problems with it.
|
|
|
|
|
Hi,
Im trying to write an app to do this but im not sure were to start. I need some pointer on:
Opening and reading binary file
moveing to specific part in the file so i can extract the data.
Cheers
Lukey
|
|
|
|
|
|
Hi,
I want to create an application, which constantly listen to the traffic on a Windows 2000 server. The purpose is to monitor 8 of the computers on the network to control the time users spend on the network via these machines.
The purpose is that the students (it is on a school) can use these 8 machines very much like computers in an Internet cafe. The students should be granted 15 minutes each within a 2 hour period. After the 2 hours they get another 15 minutes available. The 15 minutes time slot should be flexible, as the user should be able to choose when or whether he/she wants to use it.
I have never created such an application before, or even touched the subject, as my programming experience is quite limited.
Can someone please give me some hints on how this can be done. Or even better, submit some source code, which can perform such a task.
My initial idea is that I can create an application that constantly monitor the traffic from these 8 computers using their IP or MAC address to identify them, and make a simple log using Access. If a user tries to log on and their given time slot has been used, the application just blocks any traffic to that computer until a legitimate user logs on.
Is this the way to go?
I'll be happy for any comments...!!!
Thanks in advance,
N.
|
|
|
|