|
You can pass them with no problem. You just ned to format them correctly for example, if the value is an integer you pass it like this:
"select * from table where colID = " & IntVar & ""
if it is a string
"select * from table where Colval = '" & StringVar & "'"
There are more but i cant remember them all. If you google you should be able to find more.
Jon
|
|
|
|
|
Hi Arshaad,
Plz specify the database ur querying.
I think u'll need to check the datatype of the variable STD and the field stdID in the table ICTConcepts, and also ur connection that it is pointing to the correct database.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
I m using csMovieLabraryPro class in VB.NET
i want to capture the frame or to store the particular frame as a bmp image.what class or library is used for capture the frame from existing video.plz help me it is urgent.thanks
Please help me
|
|
|
|
|
I'd like some advice on how to print reports in vb.net - I'm using the printdocument's e.graphics.drawstring method with tabs as shown in the Quickstarts, but need some help to keep the strings within the tab stops
eg.
dim line as string
line = item1 & vbtab
line &= item2 & vbtab
line &=item3 & vbtab
e.graphics.drawstring(line, etc...
this works great until one of the items exceeds the width of the tabstop and throws the rest of the line out of alignment. Any ideas please?
I would also appreciate any info on how to use the vsflexgrid in Visual Studio 2003, links to documentation or helpful sites. I am developing an add-on for an accounting package and need to simulate invoice item lines with ellipsis buttons to look up codes etc - what is the best/easiest control or approach to use in this case
Thanks
Dave Curtiss
|
|
|
|
|
Hi Frns,
I am working on a project where i am supposed to make a replica of yahoo messenger, not all the features but messaging like we have in yahoo messenger and list of online users. Any ideas or any startup point will be a great help and also if i an get some references to articles, i will be greatfull.
Thanks in Advance
Amit Trehan
|
|
|
|
|
Hi there,
I want to create checkbox during runtime.
User will give the number of boxes that has to be created..
Thanks in advance.
bharath.s
|
|
|
|
|
if ur control should contain more than one checkbox that is checkboxlist and code should me like this
Dim CheckedListBox ch As CheckedListBox
Dim i As Integer
For i = 0 To 10 'instead number 10 u give items how u want to add
ch.items.add(i.Tostring())
Next ch
me.controls.add(ch)
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
private void Button1_Click(object sender, System.EventArgs e)
{
int n= Convert.ToInt32(DropDownList1.SelectedItem.Text);
for(int i=0;i
|
|
|
|
|
good job but you posted in vb.net forum
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Thank U
As I 'm a C# developer I just tried it in C# and got the solution ,just posted it
Any way language is not a constraint, logic is important!
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Yes, you have right "logic is important" but most important is to give exact solution by exact languge.
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Ok Thanks for the Update
Good job and good observation by U
---Proud to be an Indian
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Never Mind and you are Welcome 
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
I am using Crystal Report in a VB.NET application. The report size that I have used is A4. The report is getting printed properly on a A4 size paper. But some users they want to print the same report on paper size smaller than A4 size (because the printer is a small printer). The problem is that when they want to print it in a small size paper, a part of the report is getting printed. I want the report/printing area to be adjusted based on Printer Selected.
Is there any way to do so. Please help.
|
|
|
|
|
Dear Friends,
I am using in my VB6 Project so many times SQL Query 'Like' Operator. But really I am confused about the use of % and *. some time when I uses like '%Str%' it works fine and sometime it doesn't. It means I have to check every like operator query twice. once with % and once with *.
My database is Access and front end is VB6.
Your quick response will be highly appreciated.
Thanks
Murtuza Patel
|
|
|
|
|
These are called wild card characters in Sqlserver
When u use * it fetches all the attributes from the table
when u use % it selects the fields that contains the data inside %'test'%
But don't use * in ur select statements even u are retrieving all the columns from the table
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
But he's not useing SQL Server, he is using Access.
---
b { font-weight: normal; }
|
|
|
|
|
Other databases, like SQL Server and MySQL, uses % for wildcard. Access uses either * or %, at least in most cases, and at least some versions of Access.
It sounds a bit strange if the same version of Access handles this differently in certain queries, but strange is not really surprising when it comes to Access... Have you noticed any patterns in the behaviour, like a difference between using Text and Memo fields?
---
b { font-weight: normal; }
|
|
|
|
|
Are you mixing DAO and ADO code?
Normally access uses * as a wildcard but if you use ADO to access it you need to use %.
So a query in the Query designer in access will always be * but 'normally' (you should be using ADO really) in code it will be %. The exception is DAO which is an older access method is closely tied to jet and is in some case much faster and better for dealing with access databases will use * as it is so closely linked to the Jet engine.
Jon
|
|
|
|
|
hellow to all ..
i wanna know what items are selected when i do a group selection in a datagrid like to mark more than item , i wanna know what items are marked .
thxx
|
|
|
|
|
pls help on
1. reading and writing on textfiles using vb6
2. previewing report on vb6 using msword
3.reading and displaying acces database structure and has
a. ability to add, drop, truncate table
b. ability to add, drop, truncate field
adikkaymonic
|
|
|
|
|
You'll find help in these places:
1. Visual Studio help files (that's what the F1 key and the Help menu are for).
2. MSDN[^]
3. Google[^]
Learn to use them - thay are your friends.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
How could I forget - there is a fourth!
4. The Code Project[^]
Just use the Search facility (at the top of the web page).
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
Hi all,
i want to load forms dynamically in the project window at run time...
how can i do tht..
thx
Plzz help me.... 
Arshaad
-- modified at 7:14 Wednesday 22nd March, 2006
|
|
|
|
|
Populating a treeview with infomation from 3 tables in a sqlserver express DB needing
catagory 1 as parent
catagory 2 as child
and list as grandchild
I cant seen to declare anything as a node my its me but I cant grasp a way to to this ant help would I be gratefull
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
