6,934 Topics
 | |
| | here are the files guys all I need is to connect my C# app to my sql in server management studio, please help and if possible, please include the step by step on how to do it. Thank you very very much!  |
| | I have a problem to update my sql <?php $host="localhost"; // Host name $username="matanc_cmd"; // Mysql username $password="123123"; // Mysql password $db_name="matanc_cms"; // Database name $tbl_name="content"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id …  |
| | I try to create dropdown list with informations from title column in sql table, but never succeeds. My connection and query is good. Can somebody to help me with this? mysql_connect(***); mysql_select_db(***); $query = mysql_query("SELECT title FROM test"); Thanks! |
| | Ok i think i'm getting closer to what I need.. Here's the error msg i'm getting. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table WHERE id = Stef Longo' at line … |
| | hey there, Here's my complete code for a delete button that deletes a record in a Heirachical Flex Grid. Dim rsTour As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & App.Path & "\Luckshan Tours & Travels.mdb;" & _ "Persist … |
| | Hi! I have table of records of my database. I have too many rows, so i decidet to add feature what i dont know how to call english, but mybe it's call page numbering. So i need split my table after some 10rows and its will make after table Paga …  |
| | Suppose I want retrieve values froma table that are greater than 10, should I first store all the values in a list and then check condition of ">10" using any language or should I just just retrieve all values directly from databse using query : `Select id from table where …  |
| | Hi, I'm new to PHP and I want to know how to prevent SQL injection? Any php features can prevent the SQL injection?  |
| | Hello Everybody please help me out i am in big problem the problem is my organization people gave me the WEB Application to edit it (the application was written in the C# language and it is web application so it is designed in ASP.NET MVC3 ) and i have to … |
| | Hello! I have few problems. I hope you will understand me and can help me :) 1st - I have large input form, so if i press sumbit button then it makes large query thats slows down my page and database is overload, in form is somewhere about 180 colums. … |
| | Hi, I am in urgent need for converting sql procedure to postgre sql procedure.Please help me ASAP. CREATE FUNCTION sp_get_id_des (IN cellid INT, IN mcc VARCHAR(3), IN mnc VARCHAR(3), IN nwtype INT, IN mlac INT , IN mrac INT ) returns SETOF record AS' declare pscnt int ; declare cscnt … |
| | Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to … |
| | So, I'm going to make an app for my convenience and probably some others, and here's what makes me wonder: I have no prior knowledge in databases, so I really don't know the most efficient practice in making a database. Here's the problem: let's say I want to make three … |
| | Hi all, I need some help in how to achieve this functionality....the problem is ... I have some data in my database.On clicking 'generate invoice' , It should gather the data from the sql server and publish it to a document which the user can send it to a company.Basically … |
| | Hello,... i usually used win7 x32 bit and i use sql server 2008 r2 enterprice in it and there is no problem , but i change my windos and installed win7 x64 on my labtop after that i try install the same sql server which i used in this system … |
| | Hello, sirs! I have got a SQL Database on one computer and there is another computer in a local network. I want the other computer have access to SQL-Database by real time, but not able to modify it. And one more thing, is there any possibility to convert SQL-Database to … |
| | I've been doing some research about multilingual and recursive database design for few days. I found interesting the following article: http://www.gsdesign.ro/blog/multilanguage-database-design-approach/ and liked the 4th solution Coupled Translation Table Approach. But I'm seriously confused since I don't understand the case; I see there is only one column id on pages … |
| | I am developing an sql query to use to grab information from a postgres db. The scenario is as follows: the database I am grabbing information is the backend postgres database of an application (Tableau). My objective is to pull all of the workbooks, views, and datasources (considered objects) that … |
| | this is our insertion logic. but the problem is that after inserting one record we reset the textfields to clear them.and after that if we again press the insert button it duplicate the previous record into our database.we want to tackle with this??????so that no duplicate entry should be inserted …  |
 | <?php mysql_connect("localhost","root",""); mysql_select_db("Users"); $mysql_query =("SELECT uid,`Name`,Department,Problem,Ext_no,Ip_Add,Remark,Email FROM entryform ORDER BY entryform.uid DESC limit 1 "); $result = mysql_query($mysql_query); while($data = mysql_fetch_row($result)){ echo(" <td > <tr> <td> Complaint NO. :- $data[0]</br></br></td> <td> NAME :- $data[1]</br></br> </td> <td> DEPARTMENT :- $data[2] </br></br> </td> <td> PROBLEM :-$data[3] </br></br> </td> <td> EXT. NO.. : … |
 | i am having real issues trying to build a sql string Dim SelectQry = "SELECT * FROM TblSupplierQuotes where TenderNo='" & Me.txtTenderRef.Text & "' AND KMBPartNo=" & " " & Me.lbKMBPartNo.Text & " " in SQL the TenderNo is varchar(50) = L003141T75-2012JANTEN KMBPartNO is text = 442 019 115 1 …  |
| | hi i am getting error plz error SqlConnection conn = new SqlConnection("Data Source=RAVI-PC\\SQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); DataSet ds = new DataSet(); da.Fill(ds, "table_1"); conn.Open(); SqlCommand SQLINSERT =new SqlCommand(); command.Parameters = "insert into table_1(ID,name,address,phone,city)values('@id','@name','@address','@phone','@city')" ; SQLINSERT.Parameters.Add(("@ID",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@name",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@address",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@phone",Textbox1.Text.ToLower) SQLINSERT.Parameters.Add(("@city",Textbox1.Text.ToLower) SQLINSERT.ExecuteNonQuery()  |
| | Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database?? |
| | I am doing system using window phone 7 and sql server as database. I am using below coding to get shopping cart list at listbox. public List<Order> FindOrder(string custemail, string orderstatus) { var findorder = from r in order.Orders where (r.CustEmail == custemail && r.OrderStatus == orderstatus ) select r; … |
| | Hello (again) I have a problem with my SQL, all the other statements i have written work so I can't understand why this one isn't!! the sql is... sql = "Select * From Skills Where StampNo = " & Stamno & " Cell = " & cell & " And … |
| | Here is the poblem Class file I am not sure if it reading the id and saving it Java file (Error: After end of result set) when trying to display SQL, (Error: in the id) package homework1; import java.text.FieldPosition; import java.text.SimpleDateFormat; import java.util.Date; import java.sql.Connection; public class RegisterEntry { //Registration …  |
| | hi i need to show the last post thumbnail only i had the code but im now looking for code to get image i need to place the image on the top <ul> <?php $recent = new WP_Query("cat=1&showposts=10"); while($recent->have_posts()) : $recent->the_post();?> <li><a href="<?php the_permalink() ?>" rel="bookmark"> <?php the_title(); ?> </a></li> … |
| | Hi all, I am updating the position og pages, which I get dynimacally from the DB. It is d possible via the backend, for the admin of the site, to decide which position a page should have, when updating or creating a new page for the site. I let the … |
| | Hi everyone, In a nutshell...I have developed a site in ASP.Net and VB.Net which allows a user to create an order and submit it to a SQL Server backend database. When the order is placed...an xml file is also produced, showing the items that have been ordered...which is then loaded … |
| | Hello guys, I'm trying to learn asp.net mvc 3, but am having real nightmare with database queries :( I added a new sql server database in my project under app _data folder and created this little table where account_id is primary key and identity column. I added new ADO.net entity … |
 | Sorry, I don't know where to post this one. I would like to try executing an SQL Injection on a site (offline) i created with wamp. Just like to test the security of my site and try sql injection at the same time. If this kind of post isn't allowed, …  |
| | Hello, can you please help me to see what's wrong? INSERT INTO jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"  |
| | Hi guys I've been trying to connect my c# file to my database file(in .mdf format created in SQL Server Management Studio 2008). So basically I used visual studio 2008 for my C# file and SQL Server Management Studio 2008 for my database file. Now I'm sure that the naming …  |
| | Good day to you all, am currently working on a windows application. I used sql compact edition for the database. But the first problem i got was that it kept giving me errors i copied and pasted to error code on google and I got an article that says I … |
| | I cannot connect to SQL server heres the code Dim conn As New SqlClient.SqlConnection conn.ConnectionString = "Data Source=|DataDirectory|\Books.sdf" conn.Open() '\\ Error Comes here Dim sqlcomm As SqlCommand = New SqlCommand(("SELECT MAX(ID) FROM Books"), conn) maxid = sqlcomm.ExecuteNonQuery() Error Prompts me as > A network-related or instance-specific error occurred while establishing … |
| | Hi guys I've been trying to connect my c# file to my database file(in .mdf format created in SQL Server Management Studio 2008). So basically I used visual studio 2008 for my C# file and SQL Server Management Studio 2008 for my database file. Now I'm sure that the naming … |
| | Hi Guys, My project is in Java and i am using sql server 2005 database and my requirement is as follows for database ----- sql sever is in windows authentication mode ---- suppose my database name is db1 then **can I create password for my databse db1 in windows authentication … |
| | I have the following code Dim adoCN As ADODB.Connection Dim sConnString As String Dim sSQL As String Dim lRow As Long, lCol As Long sConnString = "Provider=sqloledb;Server=MonsterSQ1;Database=AmiCatSQL;User Id=SA;Password=123456" Set adoCN = CreateObject("ADODB.Connection") adoCN.Open sConnString 'Assumes that you have Field1, Field2 and Field3 in columns A, B and C 'For this …  |
| | Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT … |
| | Can someone please help me on this problem. I am trying to send the updated changes to the sql database when I remove a row. I use the delete method to delete the numbered row through a dataview and then use the upate command to update the changes to the … |
| | i havae problem java connection with sql server 2005 in windows authentication mode my code is as follows Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection connection = DriverManager .getConnection("jdbc:sqlserver://localhost:1433;database=dbName;integratedSecurity=true;"); |
| | hi, SELECT Sum(acpt_qty),mat_code1 FROM view_mrir_esd GROUP BY mat_code1 SELECT Sum(net_qty),mat_code1 FROM view_bom_total GROUP BY mat_code1 these 2 queries are giving the actual report, but when combining these queries like SELECT DISTINCT view_bom_total.mat_code1,Sum(net_qty),Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_id=view_mrir_esd.mat_id GROUP BY view_bom_total.mat_code1 giving the wrong acpt_qty and net_qty. Please advise …  |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
| | hello ! I'm working on a Registry page for my webSite in ASP and I'm trying to get results of a prcedure from my database which is checking if there is any duplicates of loginNames or emails when there is inserting to Dbase. The problem is I can't finde any … |
| | How to update all chekbox value SQL in VB.NET [Dataadapter] |
| | Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); … |
| | i am getting "Unhandled Null referenceException "--object reference not set to an instance of an object at below mentioned code in bracket (return System.Configuration.ConfigurationManager.ConnectionStrings["unitmoduleconnectionstring"].ConnectionString) and below is the total code help me to get out of this bug.... namespace TIMS { public partial class Form1: Form { public Form1() { … |
| | I'm trying to make a search by different option say A, B . what i need is if user provide value of A only then it does the searching using parameter A only , if user provide A and B then it needs to do searching using condition A=value1 AND … |
| | I'm extending a website built in ASP.NET to display Spiceworks reports - basic SQL queries. The easist way (with my knowledge) is to connect to the Spiceworks db through both Management Studio and Visual Studio. I have therefore followed this '[how to](http://community.spiceworks.com/how_to/show/2271http://www.)' in this forum, plus a few others, to … |
| | I have 2 queries I have to create but they sound the same. Note: I am just learning the theory behind SQL and not actually working on a DB at this time Directions: 1. Show all the categories for each book with the book number, title, category number, and category … |
The End.