2,569 Topics
 | |
| | Dear all. I need help regarding on my error.. this is the sample code: [CODE] Private Sub GetDetails(ByVal id As String) Dim conString As String = (ConfigurationManager.ConnectionStrings.Item("ItemListing").ToString) Dim objConnection As New MySqlConnection(conString) objConnection.Open() Dim sdr As MySqlDataReader Dim sSQL As String = " SELECT i.SuppCode,s.SuppName,s.telno,s.Faxno,s.email,s.Salesman,s.Mobileno,s.add1," & _ " i.masterefno, i.invoicerefno,a.remarks, … |
| | |
| | Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation? |
| | Hi, I'm new to mySQL and I've got to run a bunch of queries on a database that I've been designing for a hypothetical record company. If anyone could check my queries, I would appreciate it greatly as they don't seem to be returning the correct results and I'm not … |
| | I am starting a new website.I want a best Login Logout Php mysql script with for get password fearutes.Where i can get it. Please help me  |
 | I want to search through an sql table called hardware for a partial serial numbers. I have the following code but there is something wrong with the way i am doing my sql query. hope someone out there can help me. [CODE] Public Function GetDatabysn() As DataView Dim SelectQry = … |
| | I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but … |
| | Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …  |
| | Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL … |
| | Hi, everyone this is my first post here and let me tell you my problem I have a C# application, i have SQLServer 2005 installed on my computer my database is there and the program works fine the problem I'm facing is that i need to make an installer for …  |
| | Hi, i am using c# window application I have create one Login Form. I want that when user put its username and password first it should check in the database and then it should give the out put. i have even create on signup form first it should be register …  |
| | Hey everyone, New to the forums, as this will be my first post. Im having a problem with a tableadapter/tableadapter query. My query is: [CODE]SELECT * FROM subject_assessments WHERE (sa_id = @sa_id)[/CODE] sa_id is a varchar, if that is relevant in any way. My table adapters then look like this: … |
 | Hello, I would ask if there is a possible method that would return a String in JAVA that I can retrieve the SQL code of any table on my embedded JAVA DB in my application. It is like the function of the phpmyadmin where in you can import a certain … |
| | Hi all, As you will be able to tell i am very new at VB.net. i have the following code that adds three text fields to my sql table. it works if i input numbers i.e the number 1 in all three feilds but as soon as i in input … |
| | Morning all, Hope you can help. I normally use VB6 for my projects but thought i would look at Visual studio 2010. I have a windows form with a connection to my sql database which is working fine. i want to be to select data and input that data into … |
| | the problem is that its an undifined varible ($last) intill i type the second word, i [code=php] if($_POST) { $q=$_POST['searchword']; $q = explode(' ', $q); $first = $q[0]; $last = $q[1]; $sql_res=mysqli_query($mysqli, "select * from dogs where firstname like '%$first%' and lastname like '%$last%' order by id LIMIT 5"); while($row=mysqli_fetch_array($sql_res)) … |
| | I cannot get this mysql update query to work. Please help. I am new at this.:) <?PHP session_start(); ?> <?php //it's getting the data from the post fine. I know this part is working. $ud_id=$_POST['ud_id']; $ud_fname=$_POST['ud_fname']; $ud_lname=$_POST['ud_lname']; $ud_type=$_POST['ud_type']; $ud_used=$_POST['ud_used']; $ud_sdate=$_POST['ud_sdate']; $ud_edate=$_POST['ud_edate']; if ($ud_id == "") echo " No record ID … |
| | Hi guys, My group is having a software development project for our academics at a university. The software we want to develop is an inventory system which will be installed in a Local Area Network. We have decided to use Visual Studio C# (2005 or higher) as the front-end while … |
| | Hi there, How can I write a stored procedure to select a value from a table and return that value?? I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number) I … |
| | Hi All, In my development of an online application, I have to generage the serial no for the available number from the serial number table in sql server. Multiple users will hit the table to generate the serial numbers. So the serial number should not be repeated. I have to … |
| | hi... to all.. i've written the code in expression field... =format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00") the code is for printing the number in this format(12,23,23,34,123.00) now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas are printed.. i dont want to print the extra commas.. … |
 | Hello, I am looking for a means of database interaction in which the database will be stored on a user's machine but with no actual server software running. I have read there is some way to create databases in SQL express and then take the files for use in your … |
| | hi everyone i need your help i want to write a code that gets for me the latest 5 out puts here is my code [CODE] <?php $con = mysql_connect("localhost","awah","pass"); if(!$con) { echo "cant connect to db".mysql_error(); } $select = mysql_select_db("awah_admin"); if(!$select) { echo "cant select db ".mysql_error(); } $query … |
| | 'A way to connect to SQL with VB.Net using Classes 'This must be a class on its own Imports System Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Web Public Class frmConn Public Shared Function ConnSQL() As SqlConnection Dim connectionString As String Dim cnn As SqlConnection connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\test_db.mdf;Integrated Security=True;Connect …  |
| | Hello, I am new to Access and VB, but I have used C# and C++. I am trying to update a whole bunch of records in a table, only one field. For example [CODE] [Employees] [ EmpCode ] [ FirstN ] [ LastN ] [ 019871 ] [ John ] … |
 | I have a web app that when run locally runs as intended. Once published to my server it does not. The issue is related to sql's integrated security. The webservice/sql call is using "domain/machinename" as the login, instead of my active directory credentials. There is no sql security login for …  |
| | I've looked at this from every angle, but can see nothing wrong. The MS Access table "LocationLinks" contains only 6 fields. LocationLinkKey - autonumber, primary key. LocationKey - long integer, required, indexed, duplicates OK LocationType - string length 4, not required, not indexed RelatedLocationKey - long integer, required, indexed, duplicates … |
| | Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select … |
| | Hi all! I have a program that runs as a large form (Form1) with smaller forms that open inside of it (PeopleBox). It's for friends/contacts - each person gets their own row in the database (PeopleDB). At runtime I'd like it to open a PeopleBox for each person already existing … |
| | PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search … |
The End.