6,934 Topics
 | |
| | Hi EveryOne, I have some problem in validating duplicate values while saving & updating my records to SQL database. I have following codes: [B]1. Decalaration Code[/B] [CODE] #Region "Declarations" 'Declaration for Navigation Dim inc As Integer Dim maxRows As Integer Dim ds As DataSet = New DataSet Dim dvEmpDesignation As … |
| | How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that? |
| | Hi all, Anyone know how to create a dynamic gridview with the following specs: 1. Fixed datasouce (sqldatasource) with a fixed string connection (and database name) 2. Fixed select statement: "SELECT * FROM " + <table name> 3. <table name> came from textbox input and there is a button available … |
| | Hello, folks. Well, I can't get my head around that particular function. I want to calculate and then return the total amount of hours assigned for a given stage_no. I got confused. Do I have to use COUNT(*)? [CODE]CREATE OR REPLACE FUNCTION total_numbers_hours(hours NUMBER, stage_no NUMBER) RETURN NUMBER IS return_val … |
| | need to check an SQL Server database (not asp.net membership) to see if an email is already in use before allowing the user to register. I have tried using the information in this website but it does not seem to work. Your help will be much appreciated  |
| | I created a stored procedure as below: [CODE] DELIMITER$$ CREATE PROCEDURE updateCorporateDetails(IN companyName VARCHAR(30), IN rocNo VARCHAR(20), IN address VARCHAR(30), IN postalCode INT, IN state VARCHAR(20), IN country VARCHAR(20), IN contactNo VARCHAR(20), IN email VARCHAR(20), IN fax VARCHAR(20), IN lastUpdate DATETIME, OUT total INT) BEGIN DECLARE var1 INT; SET @var1 … |
| | Alright, let me start by saying that I know zero PHP or SQL code, myself. I have a SQL guy creating tables, and I've been using what I've found on W3C Schools. So far it's been ok, but I have a problem I need solved. I have created an HTML … |
| | Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and …  |
| | I'm create a program using java and MySql (jdbc) my problem where I'm start up the program in my customer computer , i must set up MySql program or not  |
| | Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using … |
| | What I am trying to do is have a user enter a word into a text box and retrieve the information from a SQL database where the 'entered word' eqauls that a column. I have this working perfectly but now I would like the user to be able to enter … |
| | I'm trying to store a data from the checkbox. when i checked on NSO Birth Certificate it has to be stored into my mssql server. here is my code If nso.Checked = True Then strsql = "insert into student info(Requirements) values ('" & nso.Checked & "')" Dim sqlcmd As New …  |
| | Hey guys, only new to Daniweb, so pardon me, if i seem too "nooby" for you guys. I am building a website, and currently am working on the "members area" i have a database named "users" with fields "name", "username", "email", and "password". i am running a php script, and …  |
 | i have one list and one database. The list is made after i've decided a number in a numbericUpDown. So for an example i can get the list fj1Section: 1 34 33 32 31 20 19 18 17 16 each of this sections exists in the database in the 2. … |
| | Hello everyone, I'm working on a little project that use c#, Oracle ODT and asp.net, so, my problem is that i dont know how to convert or store the data retrieved from a sql that is a sequential and then use in other query in the same project. This is … |
| | Hello Everyone, I'm quiet new to PHP, and I'm making a news portal practicing the language. I have an index page where the news are posted in an order-> [url]www.fundis.hu/index.php[/url] I have a results page, where is a search engine -> [url]www.fundis.hu/results.php[/url] In the index page I used dynamic links … |
| | I have installed MySql here already, now i need to connec it because I am going to make a project which it needs a Database, but my problem is that I don't know how to set the connector/j/ I don't know how to install it/I don't know how to put …  |
| | HI.. I have been able to save images into MYSQL database using php but I am having problems with retrieving images from mySQL ...Can anyone help thks  |
| | HELP!! I try to bind a textbox to a datatable but i cant.. I checked if the datatable is filled (it includes the results of a sql query)and it s ok.. i can depict the result in a combo box but not in textbox. I wait for only one result …  |
| | NEED HELP~! I want to create a openfiledialog and allow user to choose which exel file to be imported into the server but this error keep coming "ODBC--connection to '{SQL Server}'TGT102 failed". Thank you so much~~ PS. I am just a beginner of vb.net. So would u pls tell me … |
| | Hi There; I have a MS-SQL 2005 in my computer. There is a [I]person [/I] table, and this person table have three columns; [I]name[/I], [I]surname [/I]and [I]address[/I].They are nvarchar(50). I hold the data of my company on it. User can make some queries over it via HTML. PHP code does … |
| | I have created a table into my database which has a coloumn with datatype defined as DATETIME. The normal SQL date order is MM-DD-YYYY, however I need to enter it in format DD-MM-YYYY. Is it possible to insert into SQL SERVER database where field is formatted as DATETIME , a … |
| | Hi, I[B] have a problem with the following query select tbl_employee.E_Name,sum(tbl_Salary.Amt),tbl_Dpt.DeptName from tbl_employee inner join tbl_Salary on tbl_employee.eid = tbl_Salary.eid inner join tbl_Dpt on tbl_Salary.eid = tbl_Dpt.eid where tbl_employee.eid ='E101' When the query is executed,the following error is displayed "Column ' tbl_employee.E_Name' is invalid in the select list because it … |
| | Hello Everyone, I wrote a function that allows me to retrieve data from a single SQL table and place it into 3 datagridviews. The problem i am having is as follows: * Whenever a user types something in anyone of the datagridviews that information is recorded in all three of … |
| | Hi Guys, I wrote a function that returns the number in a particular field, my issue at the moment is how to update that field before i return the previous value i collected from the field. i am seeking any guidance available. Enclosed is the function i wrote. [CODE] Function … |
| | Dear, I have a code of c# who simply insert data into database i have code that contains abyte data but runtime it insert query display the system.byte[] instead of byte data [CODE] private void showData_Click(object sender, EventArgs e) { String FileType; String PictureName; for (int i = 0; i …  |
| | [CODE]select * from Table where data=2.6[/CODE] After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data=2.6 criterion. Here the type of 'data' column is FLOAT. If changing the value to an integer like 'where data=2', the matched result sets … |
| | Hi guys, Im writing a windows c# form at the moment and after all the headaches of gettin my stored procedure to combine 2 tables from 2 databases from 2 servers that had different collations(.....yeh MASSIVE headache)ive hit another snag! here's my form1 code, no where near completed, missing my … |
| | Hi everyone, I am new in LINQ. Please let me help to convert the following SQL Query into LINQ query. The Query is : [CODE]SELECT PRS.Product_Code, PRS.Purchase_Code, PRS.Purchase_Details_Code, PRS.Lot_No, PRS.Lot_Amount, PRS.Sold_Amount, SS.Supplier_Code, SS.Name, ISNULL(SSS.Sales_Lot, 0) AS Sales_Lot FROM Supplier_String AS SS INNER JOIN ( SELECT PD.Product_Code, PP.Purchase_Code, PP.Supplier_Code, PPD.Purchase_Details_Code, PPD.Lot_No, …  |
| | Hi, well im working on a project for school but I can't seem to get it to work. Its an app that is connected to a DB with 3 tables, this is my sql syntax of the db: [CODE] Table structure for table `income` CREATE TABLE `income` ( `idincome` int(11) …  |
| | Hi all, im doing a program using java and sql, and im trying to set a textbox with a value stored in a database. thing is: i have a combo with airlines, and each airline has a cost for each seat. so what im trying to do is get this … |
| | I have a drop down menu on a page where the user can select between, All, House, Unit and Rural which send the selection to a stored procedure which access' the database and returns the information with the selection eg. House from the category column. It all works great when … |
| | Anyone help me as soon as possible : Sir/Mam I want to pass more than 1 value through Query String I use the Code but it not working : [CODE] <tr> <td><a href="patmedrcd.jsp?id=<%=patid%> & q123=<%=qid%>"> View Patient's Medical Record</a></td> <td></td> </tr> [/CODE] and i get the value by this code …  |
 | Context: I am trying to Query a MS SQL CE database for the properties of table columns. I can get a list of tables from the Schema and from that, the column names. Issue: I can retrieve properties for some column elements but some do not return a correct value. … |
| | Hi all, this is maybe a big stupid question, but cant get this to work thing is that i have 5 tables: airlines - hotels - costs - projects and payments being costs my main table. In this costs table I need to have in the 'total' column the sum … |
| | I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it … |
| | Hi There; I have a MS-SQL server and I have Turkish names in my table. User enters names and I send it to SQL server, print result to output. However, my PHP code process and prints text as a UTF-8, and send it to MS-SQL and print it to output.However … |
 | Hi guys I'm trying to place a user input into a database(mysql) [CODE]newplayer=raw_input('Please enter a new player name: ")[/CODE] the sql commands to insert data is [CODE]sql="""INSERT INTO PLAYERS(NAME) VALUES('newplayer')"""[/CODE] When i check the database it shows newplayer instead of what the user has entered. any ideas of how i …  |
| | Hai , I have a table Student_transport_Details having columns : UserId DesignatonId StartDate Enddate I need to get records for a particular month. Can i retrieve records by passing MonthId [between 1 -12]. Thanks in advance |
| | Hi All I am writing an import program to import data from an access database to a SQL database. The table structure in the SQL and Access are the exact same with the same field names. I was wondering if there was a quick way to get the data into … |
| | I am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the …  |
| | hi When i try to run a program in java to connect sqlserver 2005. Igetting the following error. java.sql.SQLException: No suitable drivers found for jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=name I added the classpath properly for sqljdbc.jar file in envirnomental variable. But still i getting an error. If anyone knows the solution for this … |
| | We use Macola Progression as our ERP at my company. Currently, it runs on the Pervasive.SQL database backend, also known as Btrieve. However, we are converting to MS SQL Server. I am (trying) to perform the conversion. With Pervasive, there is a client installed on each workstation before Macola is … |
| | I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros please take … |
| | Hi all, I'm a java programmer but currently have a task to compare different list and output their common element in PL/SQL. In java this is very simple but i'm not sure how i would handle this in sql since I'm fairly new to it. ex l1='A,B,C,D' l2='B,C,D' l3 ='A' … |
| | I successfully installed SQL server compact edition to my computer. But i can not use [I]Imports System.Data.SqlServerCe[/I] with VB.Net. It's shown an error. Please help me.... |
| | Sorry to post this here How do I write a query to double the `buyprice` of every item that costs less than 20US. Can someone help me with this please. I had UPDATE Account SET buyprice This is where i got stuck been searching google but couldnt find it  |
| | Hi, I'm currently learning C# and I'm currently learning how to do C# and Database's. Does anyone know why it isn't adding the data in the text boxes to the db. Cheers Sam [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using … |
| | I've developed a software using VB.net and SQL server 2005. This is the connection string that used. [CODE]Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True[/CODE] But now i want to use SQL server compact edition. So what should i change in this connection string? |
| | I couldnt find a forum for sql so Im going to post here. If Im in the wrong forum then please move me. I have a table with following data Fields: OID, Product, Condition, QTY DATA: 1, Product A, NEW, 60 2, Product A, B, 60 3, Product A, C, … |
The End.