6,934 Topics
 | |
| | i am working on a POS as a school project. im having a problem in getting the stocks, which is a record in my database. this is what i need to do, i need to populate the combobox with drug names with suggests. when i choose a certain drug, its … |
| | I have created a csv file, and display data from database into that file, how can I add a pie chart to that file, this is the code which I made: File file = new File("C:/Users/MY TOSHIBA/Desktop/chart.CSV"); Writer output =null; output = new BufferedWriter(new FileWriter(file)); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@ 127.0.0.1:1521:XE","username","password"); … |
| | Hi First of all i would like to say is, i am a fresher to this vb.net.. having one project in hand. But as i dont know the code for using a datagridview i am asking your help. In my sqlserver table "EmployeeDetails" we have so many columns. In that … |
| | I did the coding to create a pie chart file in png format file, the pie chart shows the percentage but in the bottom of the file, I want the percentage to appear in the chart itself, This is the codes I have used, String query = "SELECT name,flag from …  |
 | Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) …  |
| | Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format: Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES ------------------------------------------------------------------------------- case_1 1 John 15 84 case_1 1 Jeff 10 80 case_2 2 John 20 90 case_2 2 Jeff …  |
 | Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose … |
| | Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select … |
| | Controlled Lookup Data is when data is tightly coupled to the application. If the data is not there, you have problems. So how do we check to see if data is still there? The simplest way is to add a procValidate (Stored Procedure) to check that all the lookup data … |
| | Hello, Hii friends, I want to know how to connect sql server 2005 to vb.net windows application 1)is there any connection string ? 2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and password to enter in sql server …  |
| | using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using MySql.Data.MySqlClient; using System.Windows.Forms; using DPUruNet; using System.Drawing.Imaging; using System.Drawing; namespace UareUBiometrics { class HelperFunctions { private static Fmd[] fmds; private static Fmd[] allDBFmds; public static Fmd[] GetAllFmds { get { return allDBFmds; } } private static string[] allUserNames; public … |
| | i have this query: $item_query = mysql_query("SELECT * FROM item"); this will always get the data from 1st row to bottom row. how can i get random data? SELECT * FROM item ORDER BY RAND() or SELECT * FROM item ORDER BY NEWID() i want the best way to get … |
| | Hi guys, I'm still new to .NET and your answers to my questions have been so helpful. I have another question yet again, however. This time my question has to do with sql server and handling it with code behind. I am creating a stored procedure which is supposed to … |
 | Hi; I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this: Alter table my_table Modify startdate DATE DEFAULT CURRENT_TIMESTAMP; with this error: Error Code: 1067. Invalid default …  |
| | Hi I am very new php propgramming. But I have done classic asp. I have a string request, eg www.xyz.com?test=1 In my php page, I would like to read test value. On my index.php, I have this code. <? $y=$_GET["test"]; ?> But I am getting error, Undefined index: test in …  |
| | For whatever reason beyond my understanding did my DB start this problem. I got 2 tables in my database. 1 dealing with personal info 1 with dates and time To keep my startup form empty I have the first row empty in both tables. But for some reason after I …  |
| | hi there. anybody knows how to display conntents of (SQL)database in vb.net using label?  |
| | Please could someone check this code for me as it is giving me You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near line . Although this type of question has been ask by someone … |
| | Hello, I'm a complete noob when it comes to .Net. I'm working on my college project. In my application there's a combobox/drop-down list. My requirement is as soon as user starts typing inside it, i.e. when text_changed is triggered it should retrieve values starting from that letter from a column … |
 | i kept reading on sql injections after answering a guy on the subject and end up on this page: http://php.net/manual/en/pdo.prepared-statements.php which i think is great for optimisation and i will probably apply on this portal im working on, but ... what do you guys think about this prebuild template like … |
 | I'm trying to select rows from a table that meet a bunch of criteria, but one of the criteria is that a row doesn't already exist with two matching columns both being true at the same time. For example, suppose table t1 has columns: a, b, c and d Here's …  |
| | Hi All Experts, I am a newbie to C#, my development environment is: Visual Studio 2010 Ultimate Edition Sql Server 2005 Programming Language C# I've a form with Unbound Datagridview, from which data is save to Sql Server 2005 by looping through For..Each and pass SQL INSERT Statement when user …  |
| | Hello everybody you will excuse my poor englsih I am french, since two month I began to develop an application using Vb.Net . This application must use a database . I chose MS SQL Server for the database, but I dont know how to connect my application to MS SQLSERVER. … |
 | Good day, I'am having a problem regading the computation in sql. I been using C# and am creating a web application. All i want is to multipy the value of the record from one table and multipled it with the other table. s oi caome up with this idea. @MARKUP … |
| | Hai everybody, I need help in making chat room similar to facebook chat. store in database userid based. anybody plz help me. |
| | Basically I want to develop a Address lookup(part of my project) using C# (and I can use SQL if necessary). I have a very large text file which have all the UK address and postcodes. Addresses needs to be looked up from this text file. For example, as soon as …  |
 | Hello programmers! I made two programms. One is for my marks in school and second is for library for my school. One man who work in the library in my school has error with this my software. Software can't load database anymore. When I start program I got error message: … |
 | Hello buddies, I have question about pagination am using this code $tbl_name="items"; //your table name // How many adjacent pages should be shown on each side? $adjacents = 2; /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure … |
| | Hello there I have question about how to update multi row in MySQL database, I used while function but this do the job with more time and no indecator when to finish the work, is there any efficient way to update like 1000 row with one button and make indecator … |
| | Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are … |
| | Hi guys, im kind of curious, is there a query or some way to fuse two colums like `select a.col1,b.col1 from table1 a left join table2 b on a.id=b.table_a_id` then as a result i want to display only one column containing a.col1,b.col1 thanks =) |
| | OK so I have two classes in the first class is where the database is handled, in the second class is where I want the output from my database select statment in be displayed on a label. How do I get the result to a label on Invoice.aspx? DBdatabase.cs public … |
| | Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are … |
| | Hi everyone, I have many executable files which I developed using java language(netbeans platform), which all run at the same time 24 hrs, the problem is that I can't know which one is for which program in the task manager, process tab, because they all have the name of javaw, … |
| | Ok so I have a class called DBdatabase.cs which stored all my sql queryies, what I am trying to do is execute an update statement that updates the users password through the session however when I execute the statement nothing occurs what am I doing wrong? Also Please note that … |
| | OK so what I want to do is filter my sql query for people from ages: 14-16,11-13,and 6-10. How do I do this? Also is it possible to be achieved from a dropdownlist or radiobutton |
| | hey guys, i created payroll system for my thesis project, i want to generate three reports using crystal report from visual studio 2008, but when i try to create connection using > OLE DB (ADO) > Microsoft OLE DB Provider for SQL server > Server = "Servername" > it has … |
| | Hello! I've got a question here that has me scratching my head - I've got a table of IP addresses. Each octet has its own field (OCT1,OCT2,OCT3,OCT4). The first two octets are fixed, and will never change (so, the IP addresses on my table are between X.Y.0.0 and X.Y.255.255). As … |
 | i am having problem see, in gridview , i am displaying username, email and shortlist(checkbox), when i click on UPDATE button , then if checkbox has been ticked (selected) then it send email to person , (email address picked from same row) but i want to send interview time/date to …  |
| | i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ? |
| | I am not able to restore sql file from linux command prompt. I have used the below command. Here is the message.No table is restored. I am running this in my local machine adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$ mysqldump -u root -p replication_test </home/adminuser/Downloads/rp.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu … |
| | Hi, I have 3 tables Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are in Item and …  |
| | Hello buddies , I have no Idea what is subquery, every time I tried to link two tables in one sql query I failed here is the scenario I want: in this pic I have posts with "**user_id**" only I need to show the username which stored on another tables …  |
| | good day, i have a table named information i created a stored procedure that will search for thier name, "firstname","middlename" and "lastname" that 3 field is concatenated and named it fullname My problem is that i want to count the result of my query that count the total number of … |
| | CREATE PROC [dbo].[INRv2_GetAllSavedJobs] AS SELECT plm.jobcode [Job No],si.seminartitle [Seminar Title] FROM (SELECT DISTINCT pm.jobNo jobcode FROM inr_mailinglist pm) plm INNER JOIN (SELECT js.jobno, sm.seminartitle FROM inr_seminarmaster sm INNER JOIN inr_jobshedule js ON sm.seminarid =js.seminarid) si ON plm.jobcode =si.jobno ORDER BY plm.jobcode RETURN GO > This SP retruns [Job No] rows … |
| | Sub filllist() strsql = "select * from tabletest" ListView1.Items.Clear() sqlcmd.CommandText = strsql sqlcmd.Connection = sqlconn sqldr = sqlcmd.ExecuteReader() [B] sqlda.SelectCommand = sqlcmd -- the error is pointing here and it say NullReferenceException was handled then Object reference not set to an instance of an object. How do i solve this? … |
| | Hi, I am experiencing irritating error (undiscriptive rather), when I want to insert a single statement into my db. Following is the code: protected void Button1_Click(object sender, EventArgs e) { SqlConnection dataConnection = new SqlConnection(); dataConnection.ConnectionString =@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlCommand dataCommand = new SqlCommand(); dataCommand.CommandText=("INSERT INTO citylist(city_id,city_name,latitude,longitude,state) VALUES ((1, … |
| | Hello dear T-SQL community, I am working on some exciting project but my problem is not exciting and I have not been able to find a valid solution... (all related fix are arround BCP or BULK INSERT). The server where the DB is located is not allowing BCP / Bulk … |
 | Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this … |
| | Please everyone share a query for all as SQL Exercises 1. nested SQL statements  |
The End.