9,022 Topics
I have searched the world over for answers to my dilemma and have learned a lot, but not what I need to know. My programmer compiled our website and pushed it to the server and sent me the source code. I cannot get the source to compile. I have a …
Hi all, i hope anyone of you can help me on the following matter: I have two tables: Recordingid Connection Sequenceno 1233036621 1 3 1233036621 1 4 1233036621 2 8 1233036621 2 9 And the second one: Recordingid Connection Sequenceno Code Cause 1233036621 1 1 21 9 1233036621 1 2 …
hello, i have a table having 4000 (four thousand) records and now i want to delete 3000 of them as i don't need them, these records have primary key as id which is ofcourse unique. can anyone tell me how can i delete these records with one query. if their …
right now i m working in netbeansIDE with web application i m trying to connect to sql server 2005 database using the preceding coding Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbcdbc:data"); Statement st=con.createStatement(); st.executeUpdate("insert into audio values(11)"); con.close(); st.close(); now no data are inserted int the audio table what is the solution for this.Its …
I have a problem with creating this database. I want to create the student record system. I have a table containing Individual information and using of ID as primary key. For registering grades I use another table for grades. But here is the problem. Here we have 6 or more …
Hey everyone, I'm working on something ridiculously convoluted right now and am so close to finishing, hopefully I can get some proper help here. I have my base table, as so: [CODE] -- Insert statements for procedure here CREATE TABLE #starter ( emplid char(6), acct_code char(128), div char(3), payroll_sect char(3), …
I have three textboxes a GridView with three columns Roll,name & marks, I want that when the user enter data in three textboxes & click on button,then the data added to GridvIew Columns. Foll code Add the Data to database. [code] using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { …
hey all, im sort of new on .net and i was hoping if u can help me again. i am to search a a student record on sql server 2005 database. my problem is, i can search for records but i failed to display their pictures in the picturebox. here …
Hii, i am working in Vb.net 2008 And Sql 2005. My problem is dat i have four columns. For eg: Name, Department, Address and Phone no. In DGV first column , name is dispalyed in DataGridViewTextBoxColumn second columns is , Department which is displayed in DataGridViewComboBoxColumn. which i have to …
Hi does anyone know how to update a datepart? update table set datepart(dd, tablename) = '30' where ?? What I want to do is udpate records date data but only the day so where all of the records > '2009-07-25 00:00:00.000' are updated to 30 i.e. 2009-07-30, I want to …
Hi all I would apreciate some generic help with the following problem as it's probably far too complex to document and solve on a forum but I need some more ideas on how to diagnose this problem. situation: PHP running on a Hiawatha server using an mssql 2000 database. all …
I am trying to get the seleted radioButton from a group of radio buttons. The program is supposed to check on the database for controls that match the selected radiobuttons. The radiobuttons are named High,Medium,Low. For example If a person selects High, the program must go through the database and …
hi every body i want to know the way to make the sql server avaliable on my network to share the data between many computers based on same network i need to know where i start to configure the setting from sql server ? or visual studio application ? if …
Hey everyone, I know there are literally thousands of questions and answers on the internet for getting the SCOPE_IDENTITY(), but I haven't found a single one that relates to my particular situation... So here we go... I've decided to use VS .NET's built in Data Components, which in my case …
I'm trying to INSERT a zip file into an MSSQL table. The table structure is such: [CODE]CREATE TABLE [dbo].[zips]( [id] [int] IDENTITY(1,1) NOT NULL, [timestamp] [varchar](50) NULL, [inserted] [varchar](50) NULL, [filename] [varchar](50) NULL, [raw_file] [varbinary](max) NULL ) ON [PRIMARY][/CODE]...nothing too fancy. When I insert a text file, everything is well …
Hi, I know the format is right, but what is my user ID and password. I get this error when I try to open the webpage on localhost: HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is …
I am using MS-SQL 2005 DB. One of the tables in the DB, that I inherited, has gotten upto 37000 records. And it will go up by another 50k records soon. Does that make too much data for one table? The table has about 25 columns, most of which contain …
I want to upload or import an excel file to the local SQL Server database. My problem is that I have an x64 computer and this connection/Provider, "Provider=Mocrosoft.jet.OLEDB.4.0;" & _ "data Source=" & Server.MapPath("ExcelImport.xls") & ";" & _"Extended Properties=Excel 8.0;" does not work simply because of OLE DB thing which …
Please Help me, I have 2 Table, A dan B. Table A : Sandar | jmlMuat --------------------------- Mirah | 20 Berlian | 10 Table B : Sandar | jmlBongkar ------------------------------- Mirah | 30 Nilam | 15 I want to join that table to get result like this : Sandar | …
hey everyone i need help with navigating images in a database, i was able to insert image to a database. btw, i am using sql server 2005 and visual studio 2008. i only converted a sample code of visual c to .net and i was able to do so, but …
The title to the thread pretty much describes what I am getting stuck at. I was able to create a procedure successfully, but everytime I try to execute it, I get an error:[QUOTE]The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.[/QUOTE] Logically speaking, if the DB …
I want to detect when connectivity with SQL Server fails, so i can fire an alert for the user. Does anyone know a bit of code that will help me detect when connectivity with the SQL Server fails (SQL Server goes down, network cable is unplugged etc). I try with: …
I am new to vb.net and I'm doing a small project from vb.net.I want to insert values to a sql server database table from a windows form.I have written a vb class called OrderedItem.vb to add a new data row and assign variable values to that table.In the Form, for …
Hi I am working in c# window application. I am inserting the data in SQL Server DB through webservice. When the no of rows increases I am getting an error message as "The operation has timed out." But after showing that error the data is inserting perfectly in DB. Please …
I'm a little confuse with regards to database and how it's used. I want to store my window application's data into microsoft access. Example. I have 3TB TBCurrentpassword TBNewpassword TBConfirmpassword how do i write a program: 1. Store data in Microsoft access. 2. Compare the data stored etc. and what …
hi, I am new to c# and SQL server. I am currently using SQL management tool to create tables and have added table to data gridview visually while I can enter the data the table as well as the data base is updated but I cannot delete rows from the …
Getting error for the simple code Please help me out. Thank you[code]I have a textbox and one table. Once the user enters data in the textbox & click save button, the data gets saved to database. I've written following code but I'm getting following error. Please help me out. Thank …
I'm using netbeans 6.7.1 and i'm trying to connect to the sql server 2000 database that i have created and i get this error message, SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host pc05801, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an …
how do i create a login dialog box in my database that does this, 1. there are two blank textboxes. one for username, and one for password. 2. when the user clicks the submit button, it will look for a match of the username in the table, then checks if …
Can Someone please help me create a search. I am new in ASP.NET and I am trying to create a search where the user can insert either the Last Name or ID-Number or the policy Number and many other criteria. The database is SQL SERVER 2005 Please direct me how …
Hi all, I have an SQL Datasource: [code=asp.net]<asp:SqlDataSource ID="shownMovie" runat="server" ConnectionString="<%$ ConnectionStrings:MovieTix %>" SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber AND session.movieID=movie.movieID AND ([movieID] = @movieID)"> <SelectParameters> <asp:ControlParameter ControlID="GridView1" Name="movieID" PropertyName="SelectedValue" Type="String" /> </SelectParameters> </asp:SqlDataSource>[/code] However, i get the following error message: Ambiguous column name 'movieID'. Basically I …
I want to create or export data from the database (SQL Server 2005) to a text file. the data I need is for THAT DAY ONLY. The text file is required by another system and therefore at the end of the day, I need a report on txt for the …
Hi Gyyz I am new in ASP.NET and i am trynig to make my interface dynamic. Is there someone that can help me do it? this is the scenario I have two sets of fields on the interface. One is STATIC while the other needs to be changed. I need …
I have a stored procedure in SQL Server 2008 that follows: USE [Numbers] GO /****** Object: StoredProcedure [dbo].[thenextnum] Script Date: 09/23/2009 15:35:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[thenextnum] @descrip varchar(50) as begin declare @t table (nextseq varchar(100)) update number_definition_table set Current_Number=Current_Number+1 output inserted.prefix_format +(Case …
Hi all, i had Web Page include [B][U]DataList [/U][/B]control , [B][U]TextBox [/U][/B]and [B][U]Button [/U][/B].. [B]DataList1 [/B]: Getting Data from SQLDB [B]TextBox [/B]: for Editing Selected Field in [B]DataList [/B] [B]Button [/B]: Submit Editing when i Click [B]Button [/B]it Editing Data Succefully in [I]SQLDB [/I], but in same Time [B]DataList [/B]Control[COLOR="Red"] …
I have installed visual studio 2008 I have installed sql server 2005 Now the problem is i want to make a application in which i enter the product id in text box and i shud get all other details such as cost quantity in cost textbox and quantity textbox respectively.. …
i created a form with 4 textbox tht user can insert their data and stored it in sql server 2000 databse..than i manage to display the data when user starting the program... i also create an update button for user to update their data... the problem is when i want …
Hii I Have Facing with Order problem i try to query From Table it go like this -> [code=sql]SELECT * FROM Client WHERE (ClientName LIKE 'X%') OR (ClientName LIKE '%[ ]X%')[/code] It mean give me all clients that start Whit X Letter And Included MiddleName If There is And Last …
Hi I have created a project using C# and SQL SERVER 2005. I want to deploy the project so that I can create .msi file. Can anyone help me with the steps I should follow to create the setup file? Also in which editor I should add then database and …
Hi, I am trying to complete an example from the book SQL for Microsoft Access. I have typed it into Access just as it appears in the book. When I run it, however, I get an error message telling me that there is a "Syntax error in Constraint clause." I …
Hi Everyone, I am trying to read a large table and populate another table. I need to read records in batches of 50 and send it to a table receiving it. I have the following code snippet and it works fine. But I also have another need to update the …
hi. I need to make one setup file .exe to install many programs. eg : i wanna to include the sql server in the setup of my application that i developed . so the user don't need to setup the two programs separatly . thansx
when i'm going to install any microsoft software like sql server, foxpro or sas software system is showing a message the message is c:\windows\system32\congin.nt the file is not supporting to run any ms-dos or microsoft windows appilication . choose close to terminate this process please help me to over come …
Hi All SQL Gurus, I am working on a project for a college. I have to generate a unique student Id for each student. I know I can use IDENTITY column to achieve this but I have rather complex situation here. My studentID field is string because they want it …
Hi, recently i needed to query a table , however i was denied "Select " permissions (because permissions had not yet been exported as the db was). Should my application enable for administrator to grant permissions , if that error occurs OR should permission granting be done through MS SQL …
Hey Guys, So I'm working on an ASP page and I am making use some select statement. Now, I need to specify a where clause and make the only condition in there optional, i.e.: [CODE=SQL] SELECT * from table where Upper(name) LIKE "SID" [/CODE] I want to make [CODE=SQL] where …
Hi, I have the following problem: I’m developing with Visual Studio 2008, C# in an English environment. I’m connecting to MS SQL Server 2008 and using the server Management Studio also in English. I am working on a joint project which has been written with the same software but in …
Hi In my Project I used to connect to sql server2000,which is not in local computer.I use visual studio 2005 to develop the windows application.Once I run the apllication it gave me error message ,below I mention the error meassage I got [COLOR="red"] A network-related or instance-specific error occurred while …
I wish to develop a tracking script for a courie company It wishes to show its customers the movement of the goods and its status in its website. How Should I make it. I am confused very much as the requirement says entering of tracking number will find out the …
Please help me in getting maximum sales in their own region by sql query
The End.