6,934 Topics
 | |
| | Hi i m new user in vb.net so i want plz u people help mee, i just want to conect my project to sql server database.  |
| | Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record … |
| | hi all, i am currently writing a program as my school homework. it used to work and when i changed the column name in my database, it won't save data to the database. i am currently using sql server 2005 and visual studio 2008 and c# language. here is my … |
| | hi i am Raghavendra. I dont know anything abt how to connect to oracle (sql) from VB 6 . could u plz let me know d steps n d code for executing the queries. its very urgent plz let me know |
 | this is not a web design question, i'm actually using it in vb.net but they don't have a database forum in the software development section. what i am doing: i have two tables. customer and customer_phones my visual basic program has a search for customer option, which returns the customers … |
| | Hi, I'm new member I saw this site and it is really interesting , I have new project I worked on it with html and php it is a web site for songs I built the whole site and now start programming the database for singers and songs what I …  |
| | i have two values in a table and instead of returning the values it returns the word "array" twice. [code] $mysql = new sqlConnection(); $query = "SELECT DISTINCT status FROM status ORDER BY status"; $result = mysql_query($query) or die('Error, query failed'); while ($row = mysql_fetch_array($result)) { echo "$row<br>"; } $mysql->close(); … |
| |  |
| | Please Help me, We had a Software application Developed using VB6 with MSSQL SERVER2005 as Database(Remote) in [url]www.znetindia.com[/url] our web space provider , the application was working properly until they upgraded the Server configuration, Now we are not able to connect with the database using the normal OLEDB connection String … |
| | this is my code [code] MSFlexGrid1.Clear On Error Resume Next Set rs = cn.Execute("SELECT count(*) FROM ENTRY_GAJI_BAGIAN") If Err.Number <> 0 Then MsgBox "Cannot open recordset due to this error: " & Err.Description MousePointer = vbDefault Exit Sub End If If rs(0) > 0 Then MSFlexGrid1.Rows = rs(0) + 1 … |
| | Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the … |
| | Hi I'm doing a project which requires a registration/login page. I have created both registration and login html pages and have done the validation servlet for the login page. I've also attempted the validation servlet for the registration page, but this is where I am struggling because I can't get …  |
| | Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead … |
| | hey, im wondering what is the best way to go about creating queries... my program.. i am creating a staff search program, i have craeted my databse and have included queries in access. but imnot sure how to call them in vb.net wondering if anyone can help me on that... … |
| | Hey. I'm new to php and I have been looking everywhere for info on how to take information from my sql table field and put it into a html form list. |
| | |
| | hi im trying to retrieve data from a foxpro database in a date range selected by the user from 2 datetimepicker boxes dim date1, date2 as date date1=datetimepicker1.value.date date2=datetimepicker2.value.date i used this command oSql="select * from customer where between(customer.date,{^date1},{^date2})" an empty table comes up.....can any one help pleas |
 | [B]Simple ASP.NET Login Page using C# (ASP.NET 1.0 & 1.1 ONLY!!! [COLOR=Red]NOT 2.0[/COLOR])[/B] This is just a small demonstration to show how easy one can "port" the code from my previous tutorials ( [URL="http://www.daniweb.com/tutorials/tutorial19303.html"]Updated: Simple ASP.Net Login Page[/URL] & [URL="http://www.daniweb.com/techtalkforums/thread19303.html"]ASP.Net Login Page with SQL [/URL] & [URL="http://www.daniweb.com/tutorials/tutorial23605.html"]ASP.Net Registration Page[/URL]) over … |
| | Hello, I have a big web-site(ASP.NET) with a huge data-base(MS-SQL) and i searched for a good way to use paging in my web-site. I found two good way's to do it but i have a little problem to decide which paging way to use, [U]The first way to is to … |
| | I have 2 tables 1st INVHD 2nd INVDT In INVHD I have following fields InvNo, InvDate,CustCd, CustName, TotalDisc (Discount on total Invoice), GrandTotal In INVDT I have following fields InvNo, RowNo,ItemCode, Qty, Rate, BaseVal, etc…. Now I need a query to be generated for The customer CustCd, CustName, Sum(totalDisc), Sum(GrandTotal) …  |
| | hi.. Im using Sql server 2005 SP3 edition & i want to store my database on the live Database server..As i try to connect to the server normally, it gives me error, so i asked the server administrator, he asked me to connect to the server using Query editor. As … |
| | Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), … |
| | I'm having problems trying to fill in the DataSet using SQL Server 2005. Basically I have a table in SQL Server and I want to retrieve those information and be able to display it in a web browser using DataSet. Whenever I run my code I always get error message: … |
| | Hi everyone, I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables. [Code] SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business FROM Receipt … |
| | this is my code: [code] $user = "sa"; $pass = ""; $host = "192.168.1.246"; $db ="payroll_hti"; $dbhandle = mssql_connect($host, $user, $pass) or die("Couldn't connect to SQL Server on $myServer"); [/code] i access from my computer with ip 192.168.1.100 this is my error report: Unable to connect to your database server … |
 | I think I may have my problem corrected, but it occured to me that this might be a bigger problem than I originally thought. I am working on an application that is going to use a .sdf database file to store data. I noticed that while I was at work … |
| | When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is … |
| | i am a student...i am zero knowloedge about sql neither c#.my job is to build a database.i dont really know how i can do it and how to do it?i had tried a tutorial for c# from other website but the tutorial using sql 2005.but i had download sql 2008.i … |
| | So near and yet so far. I introduced myself to session control and made a decision to only use session files (not cookies) I am submitting: session_start( ); $_SESSION['uid'] = $iduse; The session file is created and correctly reads the following where the value of $iduse is 1H: barney|s:2:"1H"; In … |
| | I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, … |
| | Hi, I have the query below with the data and query below. I want to select dates from Intable that are with a one month range of the Outtable dates and group them. That works fine But I also want to select values within these data ranges where valuein=valueout. The … |
| | How to connect queries from SQL Server 2005 to VB.Net Windows application  |
| | |
 | Before I begin i'm sorry if this is a noobish question. Basically I'm trying to import a 'forum.sql' file into mysql so that I can access and manipulate it through a Java servlet. The path to the sql dump file is /home/floyd/Desktop/forum/forum.sql so i open a terminal window, cd into … |
| | Hello All :pretty: i m new in this forum and i want to ask if there is examples about sql bcz i have lab exam on sunday and i don't know the type of questions so i m friad from that :S i use Oracle Sql*plus and thanx alot 4 … |
| | Hello I have tow queries on my website. A first query that extracts a number of records from my "Tutors" database based on the criteria "Location". This query works fine and returns "Id", "Name" and "HourlyRate". I want my user to be able to see an extended profile for each … |
| | |
 | Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be … |
| | This is my database it executes with no error. [CODE]--Kudler Fine Food Database Create Database [VALMKudler_Fine_Foods] On Primary (NAME=VALM_KudlerDB, FileName="C:\POS410\VALM_KudlerDB_dat.mdf", SIZE=10MB, MAXSIZE=100MB, FILEGROWTH=10%) --Kudler Fine Foods LOG ON (NAME="VALM_KudlerDB_log", FILENAME="C:\POS410\VALM_KudlerDB_log.Idf", SIZE=5MB, MAXSIZE=100MB, FILEGROWTH=20%)[/CODE] This is my table it executes with no problems [CODE]--Job Tittle Table CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle ( jobID … |
| | I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep … |
| | I am trying to read data from remote SQL base. I have written the function that works great if you need to get 1 Value , but when I want to read 2 or more value at from one query it doesn't work how can I fix it? [CODE]Imports System.Data.SqlClient … |
 | Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER … |
| | products applications:in jsp, i executed entry products and i executed modify products. but How to retrive later all productshistory? for example:productshistory  |
| | I am trying to produce a query using a java server page which will go through all the elements in an arraylist to see if there are any matches, can anyone help? Thanks |
 | I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I … |
| | hai all i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table its returning wrong results. my table contains, dable datas table_1 is table name number1 text1 1 notify us the day you roll check over. 2 notify us theday you roll check . 3 notify … |
 | i was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox. [CODE]Imports System.Data.SqlClient Public Class FrmMain Private Sub FrmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sqlconnection As New SqlConnection … |
| | Hi I have a column named 'ExtRefNo' which of varchar datatype. The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3) My requirement is if the user search for ExtRefNo between 100 & 105, it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105. Need not include … |
| | I don't know which category this problem falls: I cannot make a connection in my SQL Developer when I was trying to access my Oracle XE installed in my Ubuntu. I am getting this error: java.sql.SQLException ORA-00604: error occured at recursive SQL level 1 ORA-12705: Cannot access NLS data files … |
| | Pleeeeeaaaase help. If you have the answer please email me on <<mail removed>> Thanks Hi I have a VB6 system that interacts with a SQL Server database and GET's records with the following code If I_Syscont.State = adStateOpen Then I_Syscont.Close End If szSQL = "select * from syscont" szSQL = … |
The End.