6,934 Topics
 | |
| | I want to calculate somebody date using his/her Date of Birth which is located on the database column name(DOB)..which sql function do i use and how do i use it on the Sqlquery..please help |
| | Hey guys, I have a homework assignment to which this form connects to a database via a gridview and the windows form at the bottom has a place at the bottom to enter a last name to which it should do a LINQ to SQL query based on the last … |
| | Hi... I have two tables without primary keys and with a common field meterid... I can't add a primary key to any of these tables... Now i need to join both tables.. Can anyone write the query for this...plss... select * from table1,table2 where table1.meterid=table2.meterid; isn't working... The result of … |
| | hi, is it possible to populate a sql server ce database from a rss feed using visual studio 2008? and if so could you show me an example? Many Thanks  |
| | Exception Error: [code] private void Form1_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=LINLINPC\\SQLEXPRESS;Initial Catalog=POS;Integrated Security=True"; conn.Open(); MessageBox.Show("Connection"); conn.Close(); } [/code] I got this error(The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.) |
| | [code] Statement statement = connection.createStatement(); String frmdate = request.getParameter("date1"); String todate = request.getParameter("date2"); SimpleDateFormat df = new SimpleDateFormat("DD/MM/YYYY"); //Date frmdate = df.parse("strdate1"); //Date todate = df.parse("strdate2"); try { // java.util.Date date3 = df.parse(frmdate); // java.util.Date date4 = df.parse(todate); java.util.Date ufdate1 = df.parse(frmdate); java.util.Date utdate2 = df.parse(todate); java.sql.Date fs1 = new …  |
| | I need help with using a DATEDIFF() function in sql query cn i get an example of hw 2 do it...pls help..thnx in advance |
| | Hi I've been trying to solve the following problem for a few days but everytime I get the error msg even when the entered value doesn't conflict with the statement. Plz I need an urgent help I have the following tables: [B]booking[/B] bookingId (PK) subjectId (FK) [B]Subject[/B] subjectId (PK) termId … |
| | hey, i have a problem in adding data from MS SQL(mdf file) database to datagrid view: the code is below please can someone help me with this. C# Syntax [CODE] db.openConnection(); String query4 = @"Select TActionDes,TAssignedTo,TDueDate,TStatus,TDateComplete,TComment From TopicAction Where TopicNo = @topicNo and Phase = @phase"; SqlCommand command4 = new … |
| | [B]Hello everybody, hello Dani:icon_cool:![/B] I'm doing my homework of 'Data Base', exactly in the chapter: Relational Algebra, here I am, I can't find a specific relation (or the SQL corresponding query) :icon_confused:! Here the schema: [COLOR="Green"]MEAL(guest,date); MENU(dish,date); PREFERENCE(person,dish);[/COLOR] I wanna find the SQL query (or the relation in Relational Algebra):[COLOR="Green"]"the … |
| | I have almost finished a site that I've been working on but have one last thing that I don't know where to add. I have a bulk insert sql query that I want to insert into the .vb code behind and have no idea where to put it. Basically, the … |
| | Hi, i've tried several times, but haven't succed in making this: Classroom2 Name: | Date: Oliver | 12-10-10 Homer | 12-10-10 [COLOR="red"]Peter | 11-11-10[/COLOR] Classroom1 Name: | Date: James | 20-10-10 Lars | 20-10-10 [COLOR="red"]John | 11-11-10[/COLOR] How do i make a SQL statement that ONLY selects the lastest dates … |
| | hi, i am using VS standard 2008 and a sqlclient file, i want to get two fields from the database(same table) and merge it (as firstname lastname) and display in the datagridview combo column in the datagrid view, how can i do this, please can someone help me thanxx |
| | hey guys. I have two MySQL tables. I'll try to keep it short :-/ Basically I'd like to join these tables, and get the data from the database. Not here's the detailed info. I usually use the JOIN function, but this time, no join statement does the job. Neither LEFT, …  |
| | Hey all ! I want to create a new data-type called 'Phone' so that I can use it when create a new Attribute, with its form is : xxx-xxx-xxxx For example : 123-543-8978 And when users want to UPDATE my table, they must enter a string with the same form … |
| | Hey team, I want to know how I should go about re-ordering records sent from a db table - but I want to order the data in a custom manner, i.e. allowing a user to change the position of the records. I have a table (for example sakes lets call … |
| | Ok, so I'm done with my "Code Break" and I'm back in "action". A couple months ago I completely dropped programming to pay attention to other things in my life. I was only on the forums a brief period of time anyway, so most people probably don't remember me at … |
| | I'm just going to post my pages here if someone will take a look and let me know where to go from here...sorry, I could have attached files if you would prefer. I am not sure what needs to be in my VB page if anything more is required nor … |
| | Well I am interested in fetching 3 records because i need to show them on one screen as the program starts, and reason for showing 3 recording is to maintain next , now and previous button. Whenever i click next button so it should increment by +1 everytime and show … |
 | i want to insert textbox's content into money column in sql.but i don't know how to do it. Please help me Thank u! |
| | Some of my tables have no key since auto-number won't ensure no duplicates are entered. Other tables have multiple fields as key because this is the only way to uniquely identify. Migration did not like certain tables or queries due to this, are keys required? Also my Forms and queries … |
| | Hello, I'm using Windows 7 Ultimate 64bit, Visual Web Developer 2010 and Microsoft SQL 2008 Express SP1(local). SQL server is set to windows authentication, I'm on admins account but the problem is that I can't work with database. It keeps doing errors with connection etc. (I have to use VirtualBox … |
 | Thanks to you guys I have been able to get my first application halfway going. But I have a question about data integrity. The application that I am developing utilizes a single sql server and multiple work stations accessing that sql server. What is the best way to maintain data … |
| | Hi this is the code i have [CODE]NewCustomerTable.Clear() NewCustomerconnection.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=G:\Shop.mdb" NewCustomerconnection.Open() NewCustomerAdapter = New OleDb.OleDbDataAdapter("INSERT INTO Customers VALUES ('" & txtNewID.Text & "','" & txtNewFirstName.Text & "','" & txtNewLastName.Text & "','" & txtNewAddress1.Text & "','" & txtNewAddress2.Text & "','" & txtNewPostcode.Text & "','" & txtNewPhoneNumber.Text & …  |
| | Im writing a table for points earned in terms of the result that a competitor has been placed. In which case if a competitor comes first and 1 is entered into the database how would it work out the points earned automatically? can i define the points allowed for each … |
| | I have a combobox that is populated by a SQL querry. Problem is the first item of the comboBox where normally the comboBox.text go is blank. You have to drop down the menu item for the items to appear. I want to comboBox to populated with the first item in … |
| | Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results … |
| | hi - i have coded a seacrch box and its results are displayed in a tabular form. i have also a print button which when pressed shud create a pdf based on that table that is displayed. for this i have a separate page called pdf.php. i am using ezpdf … |
| | hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …  |
| | Hi, Does anyone know how i can AutiFix (ie check that all tables and primary keys are setup) an SQL database? A company i was working for a few years ago had this facility on their software and i was really handy. Daniel. |
| | Hi Folks can any one give me simple file upload then retrieve code?? and is there any solution to SQL injection????? |
| | Hi, Hello all. I installed SQL Server 2005 on Windows 7 together with SP3. I set the surface area configuration to allow TCP/IP and named pipes. When i try to connect the machines running SQL, i fail, i cant access it. Neither can i change any settings in the surface … |
| | Hi, i'm not sure this is in the right place but here goes: I'm currently using ADO in VBScript to access a SQL Server database and one of my current issues is returning the full error message that a stored procedure generates. I can get a brief error description and … |
| | How do I prompt the user to enter an 8 character code that I will use in an MS SQL query script? |
 | Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the … |
| | Looks like I can't stop having problems with SQL haha I'm trying to delete a value from a database using the following code, and I have no idea where it's going wrong. It gives the messageboxes saying the operation goes through ok, but doesn't actually delete the data. Here's my … |
| | Hey I am trying to run this in php: [code]// Retrieve data from table where row that match this passkey $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'"; $result1=mysql_query($sql1) or die(mysql_error())[/code] and I get this error: [code]You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Hi All, can anyone please tell me what's wrong in this code I'm trying to get some data from an access database and show them in a CheckedListBox The sql quary includes a variable('sport') and it's values is passed by the user when I run the following code an exception … |
| | Hi all... I got a stored procedure to compare dates and if the date is not valid it returns an error in sql server. I need to know how i carry that across to vb. Thanks.. |
| | Hi there, I am making (more like, have already made) an IRC bot in Java. I would like to be able to query a shoutcast server with my bot and return basic information (such as now playing, bitrate, etc). I have scoured google and only found php code which i … |
| | I Have Created Following tables 1.Test_Student(Master) table which will contain StudentId(primary key), StudentName and StudentAddress as columns. 2. Test_Subject(Master) table which will contain SubjectId(primary key) and SubjectName as columns. 3. Test_StudentSubjectTrans (Transaction) table. This will be a transaction table between Test_Student and Test_Subject. This table will contain StudentId and SubjectId … |
| | Heya guys, this is my first post - this forum has been loads of help in the past :) Anyway, I am currently coding a program that requests a user's Log In name and password, and then (via a SQL query) checks it against a record in the database, and … |
| | Beginner here with VB 2008 Express. Thanks to this forum, I have one problem solved, properly converting text to numbers. Now I want to use that conversion as a selection parameter in a FillBy statement. Here's what I'm trying to do: I have two comboboxes linked to an Access 2007 … |
| | hi, how to i get the data i the dategrid view and save it in the SQL database in C#. and also how to aloow the user to enter details from the grid view. thankxxxx |
| | Hello friends, I have a membership site where members will submit their data and choose a template to display their information. On this site, I want each member to have his own subdomain (eg membername.mysite.com) whereby anybody that enter the subdomain into the address bar will be directed to the … |
| | Code to Execute an SQL Script in JDBC. The SQL Script should have comments starting with - or -- only on new lines and each command should end with a ; . Reading a sql file and putting all of it in a string variable and feeding to the execute … |
| | Question: Write commands to declare character variables named faculty_last_name, faculty_first_name, and faculty_phone. Assign the value ‘COX’ to faculty_last_name, ‘KIM’ to faculty_first_name, and 7155551234 to faculty_phone. Write program commands so that the program displays the output exactly as follows: Kim Cox’s phone number is (715) 555-1234. everyone can teach me??? |
| | Hi, In C#, i got sql Exception which consists of 2 lines. I need only the 2nd line of that Exception only. Ex: The transaction ended in the trigger. Table Validation failed - Name: x; Condition: m!=0 i need "Table Validation failed - Name: x; Condition: m!=0" only. I have … |
| | hi, Question 1 i am developing a project in C#.Net, and when a form loads data from the SQL client database is added to four combo boxes in the form, i need to change the data in the combo box when the check box is ticked. I wrote a code …  |
| | hi, i am doing a project in C#.NET desktop application. how can I make a upload, retrieve functionality in C#.NET desktop application for pdf documents, I am using a sql client for the moment, so i need to upload the file(file path, content, title in to the database) how can … |
The End.