[sql] Forum Topics

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"); …

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 …

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 …

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 …

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 …

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 there. anybody knows how to display conntents of (SQL)database in vb.net using label?

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 …

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 …

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 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, 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, …

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 ?

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 …

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, …

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 …

I'm currently building a website for my friends and me, and I've decided to have the homepage use a news system. I have the page working with PHP to load articles from my MySQL Database, and that's working fine. My real issue is with the page that adds items to …

I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms. Here is my question: I have TableA that has the following columns: ID(PK), location, departA, departB. I would like …

I want to perform an UPDATE query but i'm getting this error:  This is my Sub in vb.net: Public Sub changeStatus() Dim Sqlstr As String Dim connectionString As String = "server=xxxx;uid=xxxx;pwd=xxxx;database=xxxx" Dim strtTime As String Dim endTime As String strtTime = DateTime.Today.ToString("yyyy/MM/dd") & " " & "06:15:00" endTime …

I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job …