2,569 Topics
 | |
| | |
 | 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 a table in which m storing some data like in the following: table => uploads string_file and file_name and m trying to select the string_file. the data for this column is like in the following; ab323892,416a75f4, e732ced3 and blah blah. and following is the query that m … |
| | hi i have deattach the database from the SSMS. and a new database i have created in visual studio 2010. and i want to attach it to the SSMS. but my attach process is failed. any body is there to help me to attach the database into SSMS... |
| | Hi I have the two queries below, they run far too slow around the 20 second mark , I have around 18,000 rows on the videos table and 2,000 on the other. Any thoughts? Thanks $query="SELECT videos.VIDEOID, videos.title, (select video_thumb_chosen.thumb from video_thumb_chosen where video_thumb_chosen.videoid = videos.VIDEOID group by video_thumb_chosen.thumb order … |
 | I have a sproc that pulls six years of records for a report. The person who set it up years ago set it up using statically defined years which ended in 2009. I am rewriting this sproc to pull the current year and five years previous. In the process of …  |
| | I am building a new website and migrating all users off a CMS (ExpressionEngine) that uses MYSql. I have all of the users imported into a MS SQL staging table (except passwords). I am trying to create members in asp.net membership by looping through the users in the staging table. … |
| | hi i have a table like this for attendence: table name attendence. id std_rolNum std_fname date std_bkfast std_lunch std_dinner i want to make search on the base of `date`, `std_rolnum`, `std_lunch`, `std_bkfast` and `std_dinner`. so that if on the same date if student have already taken breakfast, lunch or dinner … |
| | hi m getting the following exception: `System.Data.SqlClient.SqlException: Incorrect syntax near '4'.` the following is what i was trying: public void hostel_cpacity(ManageHostelRoomsBE hmr) { string str; string conString = System.Configuration.ConfigurationManager.ConnectionStrings["Hosteluog"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); DataTable dt = new DataTable(); DataTable dt1 … |
| | 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 …  |
| | 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 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 …  |
| | 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 … |
 | 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 … |
 | 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 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 =) |
| | 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 …  |
| | 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 …  |
| | 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'm working on a database project. I avve to build a DB for medical record (hospital) but I'm not too familiar with hospital stuff. I have to come up with entity sets with their attributes, build an ER diagram and then do a Query with GUI included. What I need … |
| | 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 …  |
| | Hi i am having problems designing a solution for this problem : I have a form where you can choose the items you wish and type the quantity and then add them to a listview item. The itema are already saved in a database ( i am using sqlite ) …  |
 | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …  |
The End.