[sql] Forum Topics

Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to …

I don't recall ever having trouble using a similar procedure in the past but for some reason this one is giving me tons of trouble. Everytime it gets executed, it fires "Object doesn't support this property or method" error and I just can't understand why. Here is the snippet [CODE]SelectedEntry …

Hi, I'm trying to populate a tooltip with a list of users connected to a database when hovering over an row in a ListView. I'm using sysprocesses to show a list of databases and the connections, how do I tie this together? [CODE]select loginame, hostname, blocked, db_name(dbid) from master..sysprocesses where …

I thought I had the command correct, but I wanted to make sure since I fail to connect in my app. Here is the connection command I use: New SqlConnection("Server=TestServer;Database=MasterDB;Integrated Security=SSPI") I have verified the server name, DB name, and that the server is using windows authentication. Any help would …

Alright, let's try this again. I've started over from scratch and we have got the basic functions working. Everything so far has checked out, but I am still trying to get it to pull the right credentials. I can get it to pull one of the rows out of the …

Please someone can help me. I need a function which just returns the number of rows from known table. I tried it like: [CODE] CREATE FUNCTION getRows ( @id int ) RETURNS int AS BEGIN DECLARE @rownums int SELECT Count(*) FROM dbo.MainData where id=@id RETURN @rownums END [/CODE] But it …

Hi everyone! I am a junior database programmer. I need to know how can I save image in SQL SERVER 2000 by VB.NET? I made a table in SQL SERVER with two fields. One is Id[nvarchar] & another pic[nvarchar]. I got two forms there in VB.NET project. In the first …

I have to finish this project for tomorrow-so I'll Appreciate quick reply. I need to do reports in my projects. now I've created Data Environment and all that but in the SQL the only thing that work is if I select the entire table from the database. (like "select * …

hi! I hope this is the place for my my question: I work on a file tagging system. I write it in java and use MySQL as my DB. I have a table that contain only one field: file's path. when directory is renamed, it's path changes. and that's mean, …

I'm trying to restore previously backup text file into sql server on specified database. Could it be possible using VB.NET? if possible please help me..

i'm using VB.NET AND SQL SERVER AND HAD PROBLEM TO RESTORE PREVIOUSLY BACKUP TEXT FILE.

hai all, i am working on a project, my project have 3(bronze, silver, gold) types of payments, payments are done through the paypal the expiry date is one month. if user reach the expirydate we must send email to him, after expirydate is passed his payment type change to bronze(it …

Ok I am currently learning php through wordpress and I have a small project to create a running website which displays the results. CUrrently I can display the results for a certain race that I hard code: [code] <?php // Connects to your Database mysql_connect("XX.XX.XX.XX", "admin", "pwd") or die(mysql_error()); mysql_select_db("db") …

i want to display a selected record from my database to the data report in VB6. i used the foll. code, where cuno is the value of a textbox. i m passing the value of cuno through a module. SELECT * FROM Bill WHERE ID=cuno but when i run it, …

I hope you can help me. I'm working on a program that will open any Access database that might be on the system. The problem I'm having is that I cant get get the SQL statement to show all the tables within the database. The code im using is as …

HEy everyone. I've been workign on this for a few days now and it's due tomorrow, so I thought I would ask a developer community for any input. Here is what is supposed to be happening. The Server starts. The Client Starts. The user enters a table name into the …

Plz help me out to resolve a conflict. I have made untiring efforts to resolve but coudln't. I have showed my data in gridivew now in windows forms now i want that when i make chages on the gridview using it like an excel sheet. These changes should also be …

[code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" …

Allo all, I'm using a DataSet to collect a random comparison from a database, and then passing those values to Public Variables, then constructing two Insert Statements (which shows on screen, and is valid). With the [B]two Insert Statements[/B], I'm using two buttons (in an ASP.NET Page) that Call a …

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 …

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 …

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, 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, 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 …

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 …

Hi, I have [code] SessionData sdc = new SessionData(); [/code] And all the properties of sdc are stored in a table in sql server. I want to retrieve the properties of the sdc dynamically. And i know [code] sdc. reader1["xmlname"]= [/code] is a wrong way of doing it. So can …

Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 …

Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to …