6,934 Topics
 | |
| | When I press the save button it wont update the row if i make some changes. whats wrong with my code can you please help mee. What is lacking or what do i need to put . Thanks for who will answer I will really appreciate it. include("connect.php"); $code =$_GET['Code']; …  |
| | So I am trying to write data to a SQL directory the code is suppose to take a finger print and store it in a directory and for some reason the data in the DataRow myRow is always null I have tried everything. sqlCommandText = "select * from xluser where … |
| | Dear All, I have a small probelm with updating my database. Here are my codes ~~~ vb Module AphidSimVar Dim myCon As SqlCeConnection = New SqlCeConnection("Data Source=|DataDirectory|\AphidModel.sdf") Dim myCmd As SqlCeCommand Dim myAdap As SqlCeDataAdapter Dim myDataSet As DataSet Dim myTable As DataTable Dim myBuilder As SqlCeCommandBuilder Public Sub ShowData() … |
| | I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I …  |
 | I can't seem to wrap my brain around this one and would really appreciate it if someone has some suggestions! :) I have two tables, one contains a list of locations (AccountLocations), another a list of contacts that belong to those locations (AccountContacts). What I would like to do is … |
| | Can anyone help me with importing text file to sql server using vb.net here is my code ~~~ vb Dim ImportedFile As String Dim ImportedLines() As String Dim OneLine() As String Dim strSQL As String Dim i As Integer If My.Computer.FileSystem.FileExists("D:\PPOS\Sales_report\inventory_255503221452_Cake102.CSV") Then ' Read the whole text file ImportedFile = … |
| | Hello, I am working on a C# application where i have to store values of article in sql server as i have 3 products (stone, diamonds, jewellery). Now during the initial process when i enter the product details let say i have to store value for a diamonds i put … |
| | Hi Guys Im kind of new to this and i hope you will be able to understand my question. I have a little dynamic news website. I have a form (called add_post.php)i use to insert my articles (blog_enrty). Unfortunately i get an error saying "you do not have permission to …  |
| | Hi All, I have two different files which I want to compare with each other. Now each file have 10 colums but i only want to compare 5 colums with other file. for example, some colums names are (invoice num, time, date, amount) so what i want is I want … |
| | I have my web application up and running on my production server. It uses a form for logging in. But there is a little problem with some usernames that we working fine previously and suddenly stoped working. When these users try to log in the server reports that the user … |
| | For a lack of words, I'm confused with my server at the moment. I moved an old site on ASP/Access over to ASP/SQL Server 2008 Express, and now some data appears, while other data does not. This one is an odd ball to me. I have data cells of the … |
| | Hi, On executing CROSS APPLY Clause using UDF: create function Reg(@pc int,@pp varchar(15)) Returns Table As Return select cr from crt where piod=@pc and cr=@pp Go select distinct a.cr from cdet AS a CROSS APPLY Reg(a.cr,a.piod) AS a where a.piod='208'** Am getting this following errors: Incorrect Syntax near '-'. Thanks.  |
| | Ahoy, I'm having a bit of trouble executing a stored procedure using PHP's SQLSRV package thing. It's pretty much just a simple select query, with the parameters being passed through a php (it's from a property search). SqlSrv is a tough nut to crack as docuemtnation is either non existent, … |
| | Hi i was just wondering if anyone knew how to generate a drop down menu with sql. The section of code i have that has to be changed is <div> <span class="bold">Choose a lecturer:</span><br> <?php // note how the keyword "distinct" in the following query prevents duplicate values from being … |
| | hi everyone , write now i have a with data which i want show the in tabular format like my query gives output like Name Location Rate AA A1 56 AA A2 27 AA A3 67 AB A1 56 AB A2 27 AB A3 67 BB A1 45 BB A2 …  |
 | Hi All, How i can restrict the numbers of customer from database? I use adodb with access. I know how to retrieve customers from database but i don't know how to restrict it to spesific numbers. Best Regards. Sturdy |
| | Alright everybody! Here's a whopper for you. I've looked over this for the longest time and just can't figure it out. I want to update my database with the user's information when they save the html form. I'm guessing there's like a quotation mark or comma misplaced or something, and … |
| | I wana know how can i use a value from a sql table that i added from another form? It basically supposed to validate that whatever was the last recorded added in the other form(eg formA) , i must then use those same values from the sql , into another …  |
| | Hello again, I am trying to set a filter button into my application and I need a little bit of help.. Acually I want the user enter the city of the customers (etc:Brampton-Ontario ) and the program prints out the customers of the ontario. If there aren't any records to … |
| | Hi, I have created the following code to get connection object to Database(MySql in my case) using a static method. I wanna know whether it is a good practice or not? Will there be any problem like concurrent access? Any information will be helpful. public static Connection connection(){ Connection conn …  |
| | Hi everyone. I am making an application that you need to sign up and login to. I want to use an online SQL database to store the login information. I know how to use a local SQL database, but I want to use an online database. Please help :) BTW, … |
 | Hi there I have a few lines of code that I would like to ammend but have been unsuccessful in doing so. I have posted in a few other forums with no luck, hopefully somebody here can help me out. I have a delete statement which I have been asked … |
| | This are my tables: tblData **numIndex** | **num** | **cost** tblPrize **numIndex** | **num** | **Prize** and the result I want is : tblData.num=tblPrize.num then sum the cost in tblData example of the table view i want: **tblData.Num** | **SUM(tblData.cost)** | **tblPrize.prize** |
 | Could you guys show me how to create a progess bar which discribes the process of a SQL procedure?  |
| | I been working on this login page for months, and to no avail can have the program working. I am using the MSAccess Database and using VB.Net. This is a windows application creating a login page. The following is the code that I been working on: Dim mypath = Application.StartupPath … |
| | What I tried was using `My.Computer.Network.DownloadFile()`, and created a shared folder in the other computer to do downloading stuff. But, in fact I didn't know how to fill the path to the other computer, the error was: *"...path not supported..."* How about this: ServerName1 = cmbServerName1.Text.Trim() database = cmbDataBase1.Text If … |
 | I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,Timeout I want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them. here is my code so far, but it aint working Public … |
| | Please I am currently working on a web application project that works on both the desktop and mobile devices also. The web application is to be for all and sundry and therefore I need it to work on all forms of mobile devices (old and new). The web application uses …  |
| | **How to Table Create in SQL Server 2000 Edition by OS: Windows 7** ============================================================ (1) Run Enterprise Manager as administrator preveliage. (2) Navigate (select) to a DataBase that you are working on. (3) Right click on any table in right side that already created in the system by default (Not … |
| | In my datagrid my sql statement uses a have clause to get set information and i am having countless errors My code is as shown below, were am i going wrong ` con.Open() cmd.Connection = con Dim da As New SqlDataAdapter("SELECT MONTH(Head.SalesDate) AS Month, Detail.ProductID, Detail.Qty, SUM (Detail.Qty) AS TotalSold, …  |
| | It just occured to me that when I go to create a new SQL query using VS's query builder, it pre-fills in a query based on the datatable I am building the query with. Normally I just delete the standard query (unless it's sufficient) and write my own, but this … |
| | Hi, so ive various number of files and database tables including artist, album and tracks. On the webpage user's can choose and artist, an album then songs or the album to buy. However ive to write code so that when the user selects to buy the album all the tracks … |
| | Hello, I'm pretty new to SQL and I have only worked with one-two table(s) at time. I got an assignment now against multiple tables, and the queries it wants me to solve is really hard. I was just wondering if you could help me to solve and understand these questions? …  |
 | I am trying to learn how to make a mobile phone communicate with a server and a database. So far, I have made a web-service on my PC using this tutorial: http://msdn.microsoft.com/en-us/library/ms733069.aspx The above tutorial makes a sortof WCF service. What would be the best Database system for me? Simplicity …  |
| | Hi! Im kinda new to c# devt I used to do a php project and Im wondering if theres anyway sql commands in php have comparable commands in c# for example if I wanna read a data in php I use $query = "SELECT * FROM table"; then execute that … |
| | Hello, I'm having a problem using the jTable plugin. I'm fairly new to using jquery. Here is my problem: I have an database name reg and has fields (fname, lname.....avatar). What i want is to show the contents of the database using jTable. Now, I don't know how to display … |
| | package com.batch; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; import DBConnection.DBConnect; public class Batch { @SuppressWarnings({ "unchecked", "rawtypes" }) public ArrayList BatchAction(String ik) { Connection conn = null; Statement st1 = null; Statement st2 = null; ResultSet rs1 = null; ResultSet rs2 = null; ArrayList al = new ArrayList(); conn = … |
 | Hi I am using vb.net with access database I am using sql How can i update database with the value 40'6"(Feet and inches values)  |
| | Hey below is a table i created ProductId ----- Qty ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- Wat i am trying to do is get my sql statement select and display my …  |
| | I am newbie in sql server i'm using sql server 2005 and the northwind database i wanted to join order and order details tables and calculate the total purchase made by each customer by using group by clause. When i used select orders.orderid,orders.customerid,orders.orderdate,orders.shipcity,orders.shipcountry, orderdetails.unitprice,orderdetails.quantity,(orderdetails.unitprice*orderdetails.quantity )as total from orders inner join … |
| | I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- `select * from Asset where contains(AssetDescription,'flower')` It returns nothing. … |
| | Hi, I am vishnu kumar. I knew the basics of Java but this is the first time i am building a project based on java (Java Swing actually). This is my final semester project and for last two months, i am doing my project. I initially thought the database(along with … |
 | Heres what i want to do. I want to check the two fields in my table | I use Ms Access the fields are EmployeeID | StartingDayWork Sql = "Select * from Employees where EmployeeId = '" & txtID.text & "'" 'This is running but whenever i add StartingDayWork it …  |
| | what are requirements for sql server 2005 installation? how to connect it with netbeans> can we make no. of instances?how and why?  |
| | Why i am getting this error ERROR at line 5: PL/SQL: SQL Statement ignored Here is my code CREATE OR REPLACE PROCEDURE SELECT_VEHICLE_VEHICLE_TYPE (vehicletype IN VARCHAR2, vname OUT VARCHAR2, vtype OUT VARCHAR2, efirstname OUT VARCHAR2) AS BEGIN SELECT v.V_NAME INTO vname,v.V_TYPE INTO vtype,e.E_FIRST_NAME INTO efirstname FROM VEHICLE_TABLE v INNER JOIN … |
| | Currently i am working and using a filter function for my search however i not sure how to do it using a query the sql statement is [CODE]cmd.CommandText = select * from tblcustomer where customerName like "'& textbox1.text &'"[/CODE] I no there is some bits missing but i am not … |
| | Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..[CODE]SET NOCOUNT ON; Select … |
| | Hi, Trying this Query, [CODE][B]DECLARE @SR VARCHAR(8),@SC CHAR(15),@ST CHAR(15),@SNO int; SELECT * FROM (SELECT DISTINCT ROW_NUMBER() OVER (ORDER BY a.rno) AS rowid, @SR=a.rno,@SC=a.kat, @ST=a.type FROM SMas a, SDet b WHERE b.id='X' AND a.rno=b.rno) AS C WHERE C.rowid=4 [/B][/CODE] but getting this following error: [CODE][B][I][U]Msg 102, Level 15, State 1, Line … |
| | Good day vb.net programmers!. I have here a combobox1 named choosename in form1. then i have a 10 textboxes named answers in form2. I want that if i choose from the combobox1 the textboxes answers of form2 to will link to it. and it save into my sql database. can … |
| | hello! i have shifted my application from mssql server 2000 to mssql server 2005 , now the prob is the command object is not returning the recordset if command text is stored procedure , here is my code please check it and guide me through errors . [ICODE] dim cmdsp … |
The End.