Loading image into MySQL database from Excel file
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

Answer Question   |  December 19, 2011  11:57 AM
Database programming, Microsoft Excel, MySQL

Data Entry in Microsoft Access using ASP
Data from the form not able to add into the database although using Internet sample source code.

Answer Question   |  March 30, 2009  8:08 AM
Active Server Pages, ASP, Database connectivity, Database programming, Microsoft Access, Web development

How to connect my application using Visual Studio 2005 to a SQL Server database?
how to connect my application using visual studio 2005 to a database using sql server?

Answer Question   |  May 30, 2009  12:27 AM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005

SQL query to list databases that have a given table
Hi all I need your help for creating some SQL query that returns the names of all databases that have a given table name. Ex. I’d like to run this query against the master database and search for all databases that have a table called “customers”. Is it possible to do this, if yes how? [...]

Answer Question   |  March 20, 2009  5:38 AM
Database programming, SQL, SQL queries

Delete duplicate values in Microsoft Access
there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

Answer Question   |  March 25, 2009  5:15 AM
Database programming, Delete duplicates, Duplicate records, Microsoft Access

How to save ListBox values to the database with Visual Basic 2008
i m doing a pharmacy system by using visual basic 2008. but i hv a problem when storing a data in table i nid to save a medical list that contain of medical name and medical quantity but how i save it into the table because 1 patient can hv many of the medical. should [...]

Answer Question   |  March 19, 2009  2:47 AM
Database programming, ListBox, Visual Basic, Visual Basic 2008

Error while referencing external assembly in SQL Server 2005.
Sir, I created a dll (SqlWcfServiceLibrary1.dll) using .net frammework 2008. My code has a reference of another assemble (WcfServiceLibrary1.dll) also. I want to create assemble in sql and use that assemble in a procedure. I am getting error that “Error while referencing external assembly“. I am pasting all code that I used…. .cs page code [...]

Answer Question   |  March 22, 2009  9:47 AM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary

ER Model
what will be the E-R model for online railway reservation?

Answer Question   |  March 13, 2009  11:25 AM
Database programming, Entity-Relationship Model, ER Model

ActiveX control for Webcam
I’m creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..

Answer Question   |  March 12, 2009  3:38 AM
ActiveX, Crystal Reports, Crystal Reports 10, Database programming, Microsoft Access, Webcam

How to store Form values in Oracle 10g with VB.NET
abt database storage in vb.net2005

Answer Question   |  March 18, 2009  10:24 AM
Database programming, Oracle 10g, VB.NET 2005, Visual Basic .NET

Database connectivity between Microsoft Access and C++
how can i give database connectivity in code of c++, and my database is stored in ms-access?

Answer Question   |  March 4, 2009  6:24 AM
C, database connnectivity, Database programming, Microsoft Access

DataGrid in Visual Basic 6
I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating [...]

Answer Question   |  March 3, 2009  12:48 AM
Database programming, DataGrid, VB 6, Visual Basic 6

Microsoft Access linking
Hi, I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key). I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form. I would [...]

Answer Question   |  February 26, 2009  10:40 PM
Database programming, Microsoft Access, Microsoft Access forms, Primary keys

Microsoft Access AutoNumber
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to [...]

Answer Question   |  February 25, 2009  12:01 PM
AutoNumber, Database programming, Microsoft Access, Microsoft Access auto increment, VBA

Switch between two options in Microsoft Access 2000 text field
I am an access programmer, not much used to with the VB codes. I am using the wizards instead. I have a new project where in I want the secondary level users to check the data fed by the primary users. The findings of the primary user will be available in the new screen for [...]

Answer Question   |  February 25, 2009  9:52 AM
Access 2000, Database programming, Microsoft Access 2000, Text field

How can I compare fields on two databases
I want to list all fields on a database and use a forall loop to check list of fields on two forms in two seperate databases…can this be done

Answer Question   |  February 24, 2009  12:18 PM
Database programming, FORALL loop, FORALL statement

Update one database from another database with ASP.NET
I want to update my database from another database when it change.Thank for your answers

Answer Question   |  February 20, 2009  9:13 AM
ASP.NET, Database programming, Multiple databases, Web development

Microsoft Access 2007 – Code for connecting two related forms, bringing up same record?
:sigh: My database suddenly requires me to have my forms appear as read-only’s (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I’ve created a second form, mirroring the original, to be my edit form. My problem [...]

Answer Question   |  June 8, 2012  3:44 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 permissions

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  February 18, 2009  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures

VB.NET code to search if a record already exists or not
Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I’m sending you the code. Please [...]

Answer Question   |  April 19, 2013  9:49 AM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005