Friends i need code to search the datas... I'm doing INVENTORY project... i'm using ACCESS databse with vb.net... i'm having purchase, sales tables... THIS IS MY PURCHASE TABLE: Code Price Category Type Dat SP Brnd 11 222 cde bgf 9/10/2025 356 asd 12 255 MEN Shirt 5/10/2010 355 Vanhesun 55 322 bb bb 9/10/2025 456 asd 66 422 bb bb 9/10/2025 556 fdd when i select CODE in SALES form, corresponding values have to shown in respective fields... I.e if i select 55, corresponding values have to be retrieved and showed in respective fields... Plz help me to finish the …

Member Avatar
Member Avatar
+0 forum 12

help please.. guys this is just the only problem in my program i cant print my data from sql..i need my thesis to finish soon..help please.. heres my code <?php require('fpdf.php'); $fullname = ""; echo $contractno = $_REQUEST['contractno']; echo $sname = $_REQUEST['sname']; echo $fname = $_REQUEST['fname']; echo $mi = $_REQUEST['mi']; echo $dob = $_REQUEST['dob']; echo $cpprefix = $_REQUEST['cpprefix']; echo $cpnum = $_REQUEST['cpnum']; echo $eadd = $_REQUEST['eadd']; include ('connect.php'); $str = "SELECT contractno,sname,fname,mi,dob,applno,cpnum,eadd WHERE ((contractno='".$contractno."')AND (sname='".$sname."') AND (fname='".$fname."') AND (mi='".$mi."') AND (dob='".$dob."') AND (applno='".$applno.'")); echo $result = mysql_query($str,$db); class PDF extends FPDF { function Header() { $this->Image('lifehead.jpg',25,10,150); $this->SetFont('Arial','B',12); $this->Cell(80); $this->Ln(20); } …

Member Avatar
Member Avatar
+2 forum 27

Hi Dw. I have a MS Access database that has 9 columns what I want to do is to retrieve all data from a database only on 5 columns. I think I have to use the `select * from data` but I don't know how to select the columns I want to retrieve because I can't use the `WHERE test = '"` because I want to retrieve all database records but only selected columns. A very good example of what I want to achieve is this` select all usernames, birthdates, last_seen_status` now this is just an example where a database …

Member Avatar
Member Avatar
+1 forum 7

hey, i have stored a few images in mySQL database as BLOB.Now i want to retrieve and display the images on frame as a gallery/grid view.I have displayed one image in a frame but when i tried to add more images it fails...Can anyone help with sample code,coz im new to the language.... I've tried the following code,bt it didnt worked:- [CODE]public class ImageShow extends JFrame{ Image image; public int x = 30,y=30; ResultSet r; public ImageShow(){ setTitle("Image Retrieved"); setSize(1000,1000); addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent we){ setVisible(false); } }); setVisible(true); } public void paint(Graphics g){ try { r = ImageRetrieve.rs; …

Member Avatar
Member Avatar
+0 forum 7

I was trying to find an answer for my issue over the net, but it was hard to find any relevant information. I'm in the middle of my school project and I got stuck in a dead point! I have a form which looks like this: http://i60.tinypic.com/24zjfpl.jpg I don't know how or even if it is possible to retrieve customer details from my database using customer ID. Logic of this process is simple. I need to put a unique customer ID, press retrieve button, then it will go to my database in access, search for customer with given ID ,retrieve …

Member Avatar
Member Avatar
+0 forum 1

iam new in C#, am creating a website using asp.net but i am facing some problem. the problem is this i want to a web application that can retrieve data from mysql database and display the data in textboxes. the concept is this i want a client type his/her username inside a textbox and click send button the client will be redirected to another webpage where he can see the scores he has in all his subjects in those textboxes. i dont want to use gridview please any ideal on how to write the codes thanks

Member Avatar
Member Avatar
+0 forum 2

My form has a 'save' button and 'select from previous month' button. what 'save' button does is insert all the values into my database. save button code: if(isset($_POST['jansave'])) { $basic = $_POST['basic']; $allowance = $_POST['allowance']; if($basic&&$allowance) { require "connect.php"; $total=($basic + $allowance); $query=("INSERT INTO january (basic,allowance) VALUES ('$basic','$allowance')"); $janresult=mysql_query($query); } else { echo ("<b>Please fill out the entire form.</b>"); } } and also when the user clicks on the save button the values that they have already inserted in the text boxes are still in the text box via the value attribute : <input type="text" name="allowance" size="11" placeholder="0" value="<?php if(isset($_POST['allowance'])){echo …

Member Avatar
Member Avatar
+0 forum 6

hello everybody.. I have a table which contains all the info about a file i.e its id, name, size, createddt and modifieddt. now i need to copy all the files(file content) to a local drive. Gotta do this in c# console application. Can anybody help me?

Member Avatar
Member Avatar
+0 forum 3

Hello Community, I was wondering if there is a way to send an email to a database? Example: So when the user sends an email to my websites email address the email will be broken up in to parts (Subject, From, Body etc...) and added to the database. FYI: I'm using [GoDaddy](http://godaddy.com) and a normal website hosting account that is using Linux.

Member Avatar
Member Avatar
+0 forum 7

Hi I'm working on a JSP project and i need to retrieve saved images. The images are save on my computer(C:\Users\myuser\Documents\NetBeansProjects\Nomadi\web\Images) I saved the link to a MYsql database.. this is the link i saved(\web\Images\W101.jpg) Nomadi is the project name. When i run my app, the image doesn't show. What i'm i doing wrong? I'm using netbeans and glassfish.

Member Avatar
Member Avatar
+0 forum 1

Hi guys I need some help again.I am designing a web site for a small hotel.The site is done I have a form to check room availability.When I click on a small calendar img the calendar pops up and I can insert dates of arrival and departure.I also have some input boxes where I manually insert other data. I have created a database and I have tables like guests,rooms,bookings etc. What I cannot figure out is 1)How can I retrieve which rooms are available by clicking the submit button(must be some php code involved).I have searched Internet exstensively but could …

Member Avatar
Member Avatar
+0 forum 1

Hello, I have been making an employee timeclock and have run into a bump in the road. Here's what my setup is like when an employee (who is not an Admin) loggs on they get a simple screen telling them the current time current date and two button that allow them to Clock In or Clock out. Their time punches are saved in my MySQL database. So in order to figure the hours/minutes they worked I have to pull their clockin time from the Database and store it in a variable. I am unsure of how to go about this. …

Member Avatar
Member Avatar
+0 forum 2

Hi I am trying to make a bike shop for my project and i need to pull out a product details with image from sql databse. I have made a table with products and i have stored the images url but i have no idea how to pull it out on to php. All i get is the url in text. Can any one help?

Member Avatar
Member Avatar
+0 forum 23

Hello, I have made an Employee Time clock application. I have been working on connecting my application to a MySQL database, I have a textbox wich is used to add an employee name to my database (this is working perfectly.), but I also a combobox where I want the list of Employee names retrieved from the database (this is where my problem is.) I have looked at a few different forum posts, and I still can't seem to get it to work. With this method it won't connect to my Database, but when I take out this code out everything …

Member Avatar
Member Avatar
+0 forum 3

I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access?

Member Avatar
Member Avatar
+0 forum 1

Does anyone know COBOL and how to retrieve data from a txt file? I have a list of words (1 word per line) and i want to retrieve them one by one randomly using cobol. thanks.

Member Avatar
Member Avatar
+0 forum 5

Hello Everyone, ASP.NET (C#) I have problem in retrieving the images from Table created in SQL Server Management Studio. Actually I had uploaded the images into folder in the Application Server on Visual Studio and the path of the images is given in the Table Attribute. Thus I have table with the id, ImageName, ImagePath and the images corresponding to the paths are stored in the folder. Please help and tell me how to retrieve the images from that folder by using the path given in the attribute of the Table. Note: Table does not have the attribute of image …

Member Avatar
Member Avatar
+0 forum 1

I need to update my Microsoft Access database 2003 from my server automatically. but i don't have any idea how to do it. Please help i really need this for my thesis. Thanks!

Member Avatar
Member Avatar
+0 forum 2

I have one table as movie. In that i have one field as 'image' in which i want to store the images. In my mca project, I m trying to make admin panel. For this when administrater is going to add movie details, at that time i want to store the image of movies then how can i do this? and i also want to disply that images in other pages. for example: when administrator want to view data of movie table then at that time that movie image shold also be displayed. Plz help me. as soon as possible. …

Member Avatar
Member Avatar
+0 forum 4

Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to store some resumes into a MS SQL Server 2008 DB. I just want to create a windows form application which will have some buttons to upload the resumes into the DB and safe them, and retrive the specific resume from the DB when the name of the person is selected …

Member Avatar
Member Avatar
+0 forum 1

Please help me for my problem in adding and retrieving video from mysql to vb 2008. I don't know the codes for it.

Member Avatar
+0 forum 0

Hello, a noob in web programming here. Doing some course related database, would appreciate any help :), I want to ask whether any of you can help me on how to retrieve get data from mysql using php function, but separate each data from mysql one by one, cause i want the query done by my php function be a draggable object, my function look like this: <?php $q=$_GET["q"]; $sql_fundamental_g= "SELECT mf_mname, mfg_group_name, credits FROM major_fundamental_g, major_fundamental, course, course_group WHERE mf_mname = '".$q."' AND mfname = mfg_mfname AND course_group_name = mfg_group_name AND course_group_name = code"; $result = mysql_query($sql_fundamental_g); echo "<b>Major …

Member Avatar
Member Avatar
+0 forum 5

Hi All, I am using vs2005 with access database. Developing a new application. I am the new one to the application development. This is what my situation which takes my time towards searching a reference but no where it is found: ***There is 2 tables named tblbill(contains VendorID & TruckID) and tblvendor(contains VendorID & VendorName) Where my user wants to display the vendorname against what he selected the TruckID*** I know how to catch the VendorID in selection of the TruckID But doesn't know how to retrieve the Vendorname based on the vendorID. Please show me a sample to solve …

Member Avatar
Member Avatar
+0 forum 3

good evening everyone, uhmm can someone here please help me how to get the internet history of a browser(gchrome, ffox, ie) using java.... thank you! ;)

Member Avatar
Member Avatar
+0 forum 1

i need help with my code in retrieving the image stored in the database.. what is the problem of this code? it only displays a blank page.. this is the code : [CODE]<%@page import = "java.sql.*"%> <%@page import = "java.io.*"%> <% Connection connection = null; //login is the name of the database String connectionURL = "jdbc:mysql://localhost:3306/login"; ResultSet rs = null; PreparedStatement psmnt = null; InputStream sImage; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, "root", "root"); //Student is the table name psmnt = connection.prepareStatement("SELECT file_data FROM file WHERE id = ?"); //In id "6" i have the image. psmnt.setString(1, "6"); rs = …

Member Avatar
Member Avatar
+0 forum 1

Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of but I don't seem to be able retrieve it. I'd like to retrieve the image and load it into a picture box. By the way, if you guys can also give me some sort of good references that explains briefly how do you store and retrieve files in MS Access, …

Member Avatar
Member Avatar
+0 forum 5

So I've looked for an answer to this question on the web but couldn't find anything that covers this specifically. Our database stores the project version in the format #.#.# (Rev_#) so there is both text and numbers in the string. I have no control over the data so I am stuck with this format. Our users have the need to retrieve a range of these projects and the specific problem has to do with the rev portion. If they want to retrieve something like 10.1.100 (Rev_2) to 10.1.100 (Rev_11) they will get no results as 1 is less than …

Member Avatar
Member Avatar
+0 forum 3

I was just wondering if I can retrieve two tables from my database to one form? because i'm trying it but it doesn't seem to be working. just the first table i'm trying to retrieve is working.

Member Avatar
Member Avatar
+0 forum 7

Hello friends, I am new to Jsp Here am facing a problem while trying to retrieve the data from ms access db using student no(number) form.jps ========= [CODE]<html><head> <BODY style="background-color:SteelBlue"> <center> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <form method="post" action="search.jsp"><h3> Enter Ur Number: </h3><input type="text" size="3" name="no"><br /> <p><input type="submit" value="Submit"> </form> </center> </body> </html>[/CODE] ============ search.jsp ================================ [CODE]<%@ page import="java.sql.*" %> <html> <BODY style="background-color:SteelBlue"> <form> <table border="1"> <tr><th>No</th><th>Name</th><th>qual</th></tr> <% int num=Integer.parseInt(request.getParameter("no")); // no is student id taken from form.jsp eg no=1 //String num=request.getParameter("no"); //int x= Integer.parseInt(num); %> <% Connection con=null; Statement stmt=null; ResultSet rs=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("Jdbc:Odbc:student"); //out.println("connection ok"); String …

Member Avatar
Member Avatar
+0 forum 4

Hello again! So now i can save the picture in the database, now i have to retrieve it. this is my code for the saving of the picture, [CODE]Dim ms As New MemoryStream() studentpic.Image.Save(ms, studentpic.Image.RawFormat) Dim arrImage() As Byte = ms.GetBuffer ms.Close() Dim strFilename As String = lblfilePath.Text.Substring(lblfilePath.Text.LastIndexOf("\")) Dim cnn As New SqlConnection(connectionString:="data source=.\sqlexpress; integrated security=true; attachdbfilename=|datadirectory|\WAIS.mdf; user instance=true;") Dim strSQL As String = "INSERT INTO ImagesStore (OriginalPath, ImageData)" & "VALUES (@OriginalPath, @ImageData)" Dim cmd As New SqlCommand(strSQL, cnn) With cmd .Parameters.Add(New SqlParameter("@OriginalPath", SqlDbType.NVarChar, 50)).Value = strFilename .Parameters.Add(New SqlParameter("@ImageData", SqlDbType.Image)).Value = arrImage End With cnn.Open() cmd.ExecuteNonQuery() cnn.Close()[/CODE] i saw on …

Member Avatar
Member Avatar
+0 forum 10

The End.