6,934 Topics
 | |
| | Hi all. I am using Microsoft Visual Web Developer C# and am working with a database. I am using 2 tables: CONTINENT table with fields: CONTINENT_CODE and CONTINENT_NAME The other table is COUNTRIES with fields: COUNTRY_CODE and COUNTRY_NAME The 1 dropdownlist is bound to the CONTINENT table and displays the …  |
| | Hi all. I have run into a problem with inserting values into table. I have 2 tables: PUBLISHER with fields: PUBLISHER_CODE (Primary Key) and PUBLISHER_NAME. BOOK table fields: PUBLISHER_CODE (Primary Key and Foreign key to PUBLISHER table) and TITLE. The user enters bookCode and publisherName into 2 textboxes Here is … |
 | I want to uninstall Microsoft SQL Server 2008 R2. But i get this error message whenever i try doing that.... TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: The given key was not present in the dictionary.. ------------------------------ BUTTONS: OK ------------------------------ Can someone help …  |
 | I am getting this error when inserting a query into the SQL tab of a database, it only adds 2 tables when it is supposed to add more, but the error is stopping it? Screenshot: http://gyazo.com/b62b31137708228beb791ed6c8ad01ea Query im inserting: http://pastebin.com/rMJeA0Xb Software: MySQL Software version: 5.1.68-cll - MySQL Community Server (GPL) …  |
| | Hi, I am currently working on joining 2 tables, however those tables have different number of columns thats why I have difficulty on joining them. I tried to use FULL OUTER JOIN, close result but still not my expected output. You can kindly see my attachment to see the scenario. … |
 | Hi Group! I've created a stored SQL procedure that will need to be modified to lock the table, run the commands and then unlock the table. I need to do this because I want any other users/programs that will need access to "wait in line" until the procedure is finished. … |
| | Hi..! I am having a list of members in my database, which i want to display in my website. I am using php GET method, and the sample url is http://www.mywebsite.com/display.php?id=564 Can anyone please help me in getting url like http://www.mywebsite.com/munna_bharadwaj_564 I may not describe my question properly, but, hope …  |
 | Greeting, Can somebody help me with this code i don't know what is the problem here Dim str As String = "SELECT DISTINCT FirstName,LastName FROM SessionMembers ORDER by FirstName, LastName asc" Dim cmdStr As New SqlCommand(str, con) Dim dtreader As SqlDataReader = cmdStr.ExecuteReader() While dtreader.Read stringCols.AddRange(New String() {dtreader(0).ToString}) stringCols2.AddRange(New String() …  |
 | Hai All, I have made a desktop application in Visual studio 2010( vb.net) with sql server 2008 as backend.I have made the setup of the project ,with sql database to be created using installer class and its all working well and fine. but i want to make my application in …  |
 | Hi, i am making an asp application and in code behind file i am trying to bound drop down list from tbl_teacher in which i concatenate the first and last name by this query `string sqlStatement = "SELECT teacher_id, fname + lname AS Name FROM tbl_teacher";' and it is working … |
 | Hello Everybody, I’m currently working on my end of year project and I got stuck on a very trivial thing. When I’m trying to add a new user to a database (local) I keep getting “Syntax error in INSERT INTO statement" I don’t really see where is the problem so … |
 | hey all please help me about my graduation project i use this code to insert data on the table and i have no error,but nothing will save on the table..so please help me know why !! thank on advance.. -------------------------------- Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As …  |
 | hello guys.. my problem is im gonna use my program into another computer but the sql server is on my laptop.. then i copy my program into another computer then I start debugging but there some of error.. this is my coonection string... conn.ConnectionString = "Data Source=192.168.1.34,1433;Initial Catalog=MyDatabase;Integrated Security=True" in …  |
| | Hi group, If you've seen my posts before on SQL Server stuff you know I'm a "raw rookie" with this. Again, I need some help. I'm going to need SQL to create an order number for me. I've created a datatable with two fields: OrderNoID (key) and OrderNumber. I've already … |
| | Have a database table with various tasks and each has a time against it that it should take, some tasks have the same time. I now need to display these times in a drop down list but only want to display each time once, how can I do this?  |
 | I want to update a colume using results from an select query but its not working :( my code: UPDATE goods SET goods.wagons_needed = (SELECT (goods.QUANTITY * WEIGHT) / max_payload as wneed FROM GOODS INNER JOIN wagon_type ON goods.wagon_type_id = wagon_type.wagon_type_id order by goods.goods_id) where goods.goods_id = goods.goods_id; Thanks for …  |
 | this is the problem code : import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.io.IOException; public class Prepared { public static void main(String[] args) { try { readerHelper r = readerHelper.GET_INSTANCE; System.out.print("enter username: "); String user = r.is().readLine(); System.out.print("enter password: "); String pass = r.is().readLine(); Connection con … |
| | Hi , I am using C# to do my projects and I have connected to a MS SQL database file and I am using MS visual studio 2008 standard edition. I need to get all the users first name and the last name and display in a combo box when … |
| | hi, i have a drop down list populated with column names of tbl_student and a text box for searching specific value coresponding to the value selected in drop down list i do not have much knowlewdge about qureies might b m lacking there error is Incorrect syntax near '=' my … |
| | Hi I'm doing a search function in PHP from an sql database. It was working before and i have no idea what happend but when i search now no results are found, but before the search it shows all the records, so there is a connection with the database. I … |
 | Hi all i have this code that will search a record from the database <?php define ('DB_NAME', 'try1'); define ('DB_USER', 'root'); define ('DB_PASSWORD', ''); define ('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Can't …  |
 | Hi Im working with a project, simple IM for our office... I have a Table in sql with column Status, if a user opens this application, the status column changes from 0 to 1, if it closes this app, the status turn back to 0. On my form load event, … |
| | Help Need Vb Emplyee Record Program With My sql Connection example employee record database program add button ,editbutton,delete button all work will bhe done thru sql table connections |
 | hi, i m new to programming and i m trying to create a setup and deployment package for database application. after sucessfully creating setup, when i install it on my system, i m getting a error. i changed the permissions of the installed application folder, and it workd fine. is … |
 | I am moving from database from Microsoft Access to MS SQL and I have not worked with MSSQL before, can you recommend a good place to get some initial and then follow on training in SQL and MS SQL? |
 | |
| | hey hai eveybody help me in sql..i have three fields namely passengerGender1,passengerGender2,passengerGender3 in single table..now i want to take count for female and male separately from the three fields..it is posssible friends?can anyone help me???thanks in advance...!! |
| | I was able to store the PDF. Now the issue is retreving the correct version of the PDF. I am storing it with the data fields filled in;however, upon retrevial the fields are blank. Dim reader As System.Data.SqlClient.SqlDataReader = Local_Command.ExecuteReader() Dim buffer(100000) As Byte Dim data As Byte() While reader.Read …  |
| | Can any one guide me as I what a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name |
| | Hey everyone, Sorry if these files seem familar. I have an issue with a certain date that won't change along with the rest. For example: "Sun., Sep 16th, 2012 6: 26 PM" that's the way the code is supposed to read but there is one section that won't change and … |
| | Hi, I am currently migrating access programs into vb.net with t-sql database backend. I am having 400000 rows of data that I have to pass into recordset and display it on the grid. In the good old access, the data appears almost immediately. Because access does not wait to load …  |
| | Group, I'm trying to write the commands to update a row within a SQL table. I've written the following: USE DATADESIGNSOLUTIONS SET IDENTITY_INSERT LocationID ON INSERT INTO LOCATIONS_SETUP(LocationID, LocationNumber, LocationName, LocationAddress1, LocationAddress2, LocationAddress3, LocationCity, LocationState, LocationZipCode, LocationZipCodeExt, PhoneNumber, FaxNumber, BillToAnswer, BillToLocation) VALUES(10, 1, 'Traditions in Tile / Buford RDC', '4325 … |
| | Hello! I have PHP and mySQL set up on a server, and everything works fine. I am able to connect to the SQL database successfully, etc. However, I want to set it up so that a user enters their "ID" in an input box. Then, the php script will return … |
 | Hi iam using sql server 2008 to deal with my DB, i have a column with 'int' data type when i insert number inside that column like "0025648" it return it to me "25648" without zeros why ? and how to solve this problem ? Best Regard IT_Techno |
| | Hi all - use the curdate() or current date to look at newly added awards in the last 3 months The SQL table used to store the created date when an award was added is **tbl_net_centre.reg_date** and keeps throwing up an error on the <= If anyone can advise the … |
 | hello friend, can someone help me, i want to learn how to connect my app database from another computer using code, i already try to change connection string = "Data Source=-SERVERNAME-\SQLEXPRESS;Initial Catalog=SmartHome;Integrated Security=True" but its still same, someone please help me, im using win8, microsoft sql server 2008, Visual studio … |
| | I am running analyses on a quiz and am trying to manipulate querys in order to produce bar charts. I am trying to display a graph which shows the percentages of candidates passing a particular quiz. The query I am trying to run is as follows: SELECT QuizName, (100*(COUNT(PassFail))/(COUNT(XXXXXX))) AS … |
 | hi im newbie for using sql in vb.net and we have a project to create a registration form where the datas will be saved on sql. for e.g how the textbox1.text will save, edit, delete, or update its value or text to sql? also how to get the datas from … |
 | Hi, Can anyone tell me why datareader is no reading user_id from this code? I debugged and the user_id_select remains 0 and I am getting no errors. Protected Sub btnAddUser_Click(sender As Object, e As EventArgs) Handles btnAddUser.Click Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True") Dim searchComm As String = …  |
| | |
| | how to import the sql file in an exist database connection.. Regards |
| | Hey Guys, So I was doin a tutorial and I incorporated it into my code and it works for the most part. The program gives you a list of town names you pick one and hit search. All good so far then the program goes into the database and pulls … |
| | Hi, I have the following tables **tbl_user** - id, username, password **tbl_userprofile** - id, userid, name, surname, gender, nationality,address, mobile, department, email, question, answer. userid is a foreign key in **tbl_userprofile** referencing id in **tbl_user** I'm trying insert a new user into **tbl_userprofile**. But i'm not sure how to go … |
 | I have developed delhpi software sql database invlove now want to convert it into web application hwo plz help me iam new in this .  |
| | while ( select AVG(Rate)+2 From HumanResources.EmployeePayHistory) <20 begin update HumanResources.EmployeePayHistory set rate=rate+2 From HumanResources.EmployeePayHistory if(select MAX(Rate)+2 From HumanResources.EmployeePayHistory)>127 break else continue end **I have Execueted this query but I am Not able to know what is this query working ? what is the use of this query ?? it will …  |
| | What is the procedure can be used in MS-SQL server 2012 in order to create a workflow as in dynamics CRM? Is there a way. Or what is the alternative? Thnakx in advance. |
| | Hi, My problem is, the Update query process is painfully slow. Every time user updates a value to a column, it is taking more than 1 min ! I have to update a cerain field Yes/No based on some other field values from the same table. Below is my code: … |
| | Hi, I want to copy records of a table say employee into the same table. For Example Table Employee contains 5 records. So i want to insert the same 5 records again into the same table Employee 20 times. I have tried the following Query (which is inserting records in …  |
| | Hi group, I've been playing with a ListView and I'm struggling to get it to populated with info in a database. I'm hoping you may see something in my code that is creating the error. Dim con As New SqlConnection Dim cmd As New SqlCommand Dim rdr As SqlDataReader = … |
| | Hi.. I am trying to create question paper generator application in C# windows application with sql server as back end. Now I need your help to select the questions from database. Ex: User Selection like: Chapter selection from listbox then select 1 mark – 5 question 2 mark -3 questions … |
The End.