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 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 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
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
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
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
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
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
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
abt database storage in vb.net2005
Answer Question | March 18, 2009 10:24 AM
Database programming, Oracle 10g, VB.NET 2005, Visual Basic .NET
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
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
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
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
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
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
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
: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
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
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