Images stored on a dll -
This is kind of hard to explain, In my app I skin a form using images and usercontrols, what I want to know is if there is any way to store these images on a dll for each skin so they don't have to be exposed in the root directory?
I need to be able to select a skin (dll) from a list box, all you have to show me is how to get a picture from a dll loading it to an image. Is that possible?
Creating Stored Procedures -
Could you please teach me how to create and edit a Stored Procedure? Please give me some examples of Stored Procedure with VB/Access code (i.e., SELECT Stored Procedure, UPDATE Stored Procedure, DELETE Stored Procedure, INSERT Stored Procedure, Output Parameters)
Multi Stored Procedure -
Hi there,
I'm new about Stored Procedure.
Does any one know that is Stored Procedure able to use like multi Stored Procedure in one Stored Procedure?
Let's say i create 1 Stored Procedure to select some of data
then pass a values to another Stored Procedure to complete
both of
Basic stored procedure -
Hi all,
I have created some stored procedure on SQL Server 2K.
How can i call those stored procedure from client (VB app.) ?
i know how to create a simple stored procedure but i dont know how to create stored procedure that able to excute using a variable from client (VB app.)?
CrystalR. get source from stored proc -
Hi all,
i have stored procedure on SQLServer 2K, can i make a report (Crystal) by using stored proc?
thanks
When to use stored procedures -
Hi! I'm developing an app in VB6 and while preparing the SQL Server database, I'm stuck because it's not really clear to me when and when not to use stored procedures. I've googled some articles about it and a Microsoft KB stated that stored procedures should be used when parameters ar
Database with images on Internet -
Thanks to Mr. Beacon I now know how to manipulate images stored in a Access database using VB.
My next step is how to display these images stored in an Access Database on a web page using ASP. I know how to do it with basic fields (text, numbers etc) but not with images.
Does s
Database with images on Internet using ASP -
Thanks to Mr. Beacon I now know how to manipulate images stored in a Access database using VB.
My next step is how to display these images stored in an Access Database on a web page using ASP. I know how to do it with basic fields (text, numbers etc) but not with images.
Does som
Stored procedure - Wizard -
I want to create my first stored procedure (I know,...) !
I saw there was a Wizard for it, but... there you can chose all kinds of stored procedures (INSERT - UPDATE - DELETE), except the SELECT one ?
Are is there another method to this ?
Executing Stored Procedures on SQL Server -
I am trying to execute a stored procedure on an MSSQL Server. I
have set my CommandTimeout value equal to zero but it the stored
procedure only handles a few records and then the
ExecuteComplete event occurs.
Does anyone know why my stored procedure will not fully complete
it's
stored procedures on sql server -
does anyone know how to call a stored procedure from another stored procedure. the first stored procedure passes parameters to the second stored procedure.
Any help is greatly appreciated.
Thanks!
Problem in Calling Stored procedure -
I am calling a stored procedure from my VB application
after i execute stored procedure from command object
i am getting error
The precision is invalid
Can anyone help me?????????
Where to find stored procedures tutorials (resolved) -
do have any idea where to find usefull site that have stored procedures sample code? I would like to learn insert, update, delete, select stored procedures for sql server 2000 with vb6 as front end. I would like to learn the proper way (best practice) of executing stored proc using vb6
raise events from stored procs -
i currently have some code in VB to update some stuff in a table (sql server 7), and it takes quite a while to execute, so i've got a progress bar on the form to give the user something to look at.
i'd like to put this in to a stored procedure to get it to run a bit faster, but it's
where does the data of my.settings stored -
i was playing with my.settings, and its a cool way to store settings like fonts, window size etc.
i just want to know where is these settings is stored, is it stored in the .exe or is it in the registry?
i just want to make sure that when I overwrite the .exe file, the settings i
calling stored procedure inside while loop -
Hi,
I noticed that in Sql server 2000 it is not possible to call a stored procedure
inside the while loop. I have a while loop similar to the following inside a stored procedure which in turn calls a stored procedure. However an error is thrown.
while (intNumber < 10)
Begin
Image viewer -
Hi All,
I have been developing an image viewer that shows thumbnail images stored in an access database. I have a form with a listview set to Icons. I have approx 200 images stored in the database. I find, that when I start the program it takes ages to load all the images in to the li
how to create views using stored proc (Resolved) -
hello,
i'm trying to learn how to create views programatically using stored procedureds and vb 6 anybody?
my problem is.
i have a combo box that stores the customers id's. i would like to to have a stored proc that can process the id's stored in the combo box as a parameter fo
Quick Questions - When to use a stored procedure -
I'm not an SQL guru. (Yet. )
What dictates when your dataAdapter should suck data in from a stored procedure or if it should just use Text and configure it manually on your form.
I guess a better way of asking this is when is it proper to create a stored procedure? Does it depen
Using stored procedures. -
hey.
lets say i have a stored procedure in sql server.. (to backup a database)
how do i send a value to that stored procedure? and how do i call that stored procedure?
Print stored procedures -
Hello
how to a print a stored procedure that accepts parameters in vb 6.0
the stored procedure works fine, i just want to print what the stored procedure returns.
thank you
Recursive stored procedure in SQL server -
Hi all,
How does one create recursive stored procedures in SQL Server. I have a stored procedure CHECKER which calls itself recursively. When I compile the stored procedure I get an error message 'Cannot add rows to sysdepends for the current stored procedure because it depends on t
Stored Procedures vs In-Line SQL -
I'm someone who has written a lot of SQL, but always in-line SQL and I'd like to get more involved with the use of stored procedures. I some general questions:
What is the advantage of using stored procedures over in-line SQL?
Are there any disadvantages of using stored procedure
Resetting Stored Procedures -
I have a stored procedure that I execute through VB hundreds of times. I need to reset the values of the stored procedure each time before I assign values to them and execute the stored proc because some parameters may be EMPTY(the default value).
Is there a quicker way than settin
Change SQL Stored Procedure at runtime -
I need to know if there is a way to do this as a stored procdure without writing a seperate stored procedure for every possible combination of parameters.
I have a database of tools. I need a stored procedure that will search for tooltype and location based on input from VB. In VB I
how to call oracle stored procedure -
Can Anyone tell me how do i call oracle stored procedure using data environment.
for e.g i have a dataenvironment object
& created a command login which is a stored procedure which takes in two parameters name & passwd.
now hoe do i call this procedure
Saving Bitmap files with a solution -
I am developing an application which uses a large number of bitmap images. The files for these images are stored on my "C" drive. Can I store the files as part of the solution? if so, can they be stored and accessed in design mode.
Display an image in Image Control -
i have <asp:Image ...... on webfrom and want to dispaly the image .i m getting all the data in dataset form .and images are phsyically stored in folder
I used GUID to stored in sql server .and in images folder .
[2005] - SQL 2005 Images -
Hey All,
I currently have some images stored as binary in SQL 2005. I currently have a datagrid which calls an external page to convert the binary into GIF. The datagrid then resizes the images. At the moment, for each image a new row is created.
What I would like to do is say cr
CLR stored procedures -
Dear Friend,
1.Whais is the difference between t-sql stored procedures nad clr stored procedures?
2.Pros and cons of the t-sql procedures over CLR stored procedures?
please share me with the information about above please
Problem with running stored procs called from winservice -
A big problem,
I have built a winForm and a win service in vb.net, both run a store procedure in SQL Server.
In win form to run the stored proc a button is pressed, when pressed it a process start and call a vb.net file.exe (a progressbar) which run the stored proc. The stored pr
Returning error raised by stored procedure in VB6 -
I am calling SQL stored procedures in my VB application. I am successful in connecting and executing the stored procedure. But I still need to get the errors raised by my stored procedures. Can anybody help me on how to do this? Any sample code? Thanks.
Single stored procedure -
Hi all
can we do all work with a single stored procedure
I want to inset update and delete and read the data from a table using a single stored procedure.
is it good way
please provide me an example if you have
Thanks
I am using C# in code behind
[2.0] Stored Procedures -
How could I return a RecordSet from (system) stored procedure in C# application. I try to use it in VB before and I failed. Or even how could I run or ececute a (system) stored procedure returning recordset in a cursor within another stored procedure?
I mean that I want to execute a s
Stored queries in access -
a few things:
a) How to do you use a stored query in access using ado?
b) Can you give any values to a stored query? So you can have a select with a where statement and get the value from vb code?
c) Is there any advantage to using stored queries?
Cheers for any help
And
Microsoft Access - Stored Procedure -
I think I know the answer to this question but still have to ask to make sure. Can Microsoft Access have real stored procedures? I know they can use ADO and JET to create stored procedure but can these stored procs contain DECLARE keyword?
(RESOLVED) Help using Stored Procedures in SQL Server 2005 -
Hi i want to add a new Stored Procedure. In the object explorer of the Management Studio i go to
MyDatabase
----+Programmability
----------+Stored Procedures
I do a right click in Stored Procedures and select "New stored procedure..."
I write the Store Procedure an
Calling DB2 Stored Procedure From SQL Server Stored Procedure -
I'm a commerical software developer. My company has received a request from one of our larger clients asking for something which I consider a little bizarre, but a lot of the requests we get from clients fall into that category.
Anyway, this client wants to know if we can write an
Executing a stored procedure WITH errors in vb.Net 2003 -
Hi all,
Im having a problem executing a stored procedure that will probably contain errors within itself. These errors consist of deleting temporary tables that may not exist. Within SQL Server 2000, you can execute these stored procedures fine, it just logs the error, and continues
Creating And Using Stored Procedures -
Hi,
Lately I've been hearing all these talks about Stored Procedures for database. I'm using VB6, can someone explain to me how to create and use Stored Procedures.
Thanks
Printing Images from JPG file (link in the database) -
I am using VB6+CR7. I have an application in which
record contains images. The images are stored in JPG files
(One JPG per record). and the name of that JPG is stored
in a field. (e.g. field 'photoname' contains the name of
the image file).
Can anybody guide me how to create re