9,022 Topics
Hey guys! I was wondering if anyone could help me. I am a student on my work placement year and I am developing a web based database. I have been asked to design it so users can if need be add a new table to the database or add a …
hi , i have problem when my application board (content http client) sending data to database SQL-font. i have try to run the query in PC, it can work, but if my remote httpclient(board) connect to InstantRails server to send data to SQL is not working well.. query: [code=sql]SELECT o1.* …
Hi, Have a quick couple of questions. I have been assigned a project that involves modifying a MS Excel 2003 VBA app so that it gets data from SQL Server 2005 instead of a MS Access database. I'm unfamiliar with Visual Basic in general, and will have to learn about …
Hi , Can any one tell me the Optimized & fastest way of taking backup & restoring my database that is in SQL Server through C# code. Currently I am using SQLExpress .Is there any Better approach of achiving the same? Regards IT_Techno
Hi I am hopeing someone can help me with extracting and formating the time from an sql server datetime field. I have tried a number of different methods, all of which have returned a runtime error of 800a000d. The following are two methods that I have tried, yet I think …
Please see my code : [CODE] using System; using System.Collection.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void cmdtam_Klik(object sender, EventArgs e) { string cstr; cstr = "data source=knight;initial …
Hi there, I am developing a simple application using C#, which perform simple function to the user, it must save some information about the user , the info needed to be permanently saved (but could be changed from time to time by the user) but the application cant work unless …
Hi, I have two datadase one one local system and another on web Both of them are on SQL 2005 .Now I want to make a link server to have connection from both database to transfer data . plz give me some link or code. thanks
Hi, I am fairly new to vb.net and seem to be having some probelms doing an SQL statement. I am selecting data from more than one table from my Access database. A surname held on a database is typed and it is supposed to display results, related on the MemberID. …
--Que-4)Create a Query to pull all emails that contains --characters +,^,*,&,! [code=sql]create table mail3(email varchar(50)) insert into mail3 values('mansi.sharma@yahoo.co.in') insert into mail3 values('mansi.sharma+yahoo.co.in') insert into mail3 values('mansi.sharma^yahoo.co.in') insert into mail3 values('mansi.sharma*yahoo.co.in') insert into mail3 values('mansi.sharma&yahoo.co.in') insert into mail3 values('mansi.sharma!yahoo.co.in') insert into mail3 values('mansi&sharma!yahoo.co.in') select * from mail3[/code] [icode]select * from …
I ran a query to find 1)the current distribution group and corresponding account id number and 2) the historical distribution group and corresponding account id number from checks written in contract year 2008. Here is the sql statement from my query: [code=sql]SELECT EMPLOYEE_MASTER.EMPLOYEE_NO, EMPLOYEE_DISTRIBUTIONS.DISTRIBUTION_GROUP, EMPLOYEE_DISTRIBUTIONS.ACCOUNT_ID, PAYS_HISTORY.DISTRIBUTION_GROUP, ACCOUNT_HISTORY.ACCOUNT_ID, ACCOUNT_HISTORY.CHECK_KEY FROM HRS.ACCOUNT_HISTORY …
Hi all, please help. I m trying to create an "empty" table from existing table for the audit trigger purpose. For now, i am trying to create an empty audit table for every table in a database named "pubs", and it's seem won't work. Please advise.. Thanks in advance. Here …
Hey guys! I was wondering if anyone could help me. I am a student on my work placement year and I am developing a web based database. I have been asked to design it so users can if need be add a new table to the database or add a …
Good morning, I'm facing dificulties to understand what i'm doing wrong! I'm trying to send the contents of a file... [TEX]SPI01 184-25-03-T-01-R.F.T.1.47e85ab1spicsv, 4609, 2008.03.25, 09:51:45 AM 184-25-03-T-01-R.F.T.1.47e8966dspicsv, 0, 2008.03.25, 14:06:38 PM 184-25-03-T-01-R.F.T.10.47e863easpicsv, 48, 2008.03.25, 10:31:06 AM 184-25-03-T-01-R.F.T.10.47e897f4spicsv, 0, 2008.03.25, 14:13:08 PM[/TEX] into a database "spimon" with a table LogSPI01 with …
Hi, I have a simple SQL query [CODE=sql]update testcourselog set grade='a' where statusid=4[/CODE] It updates 114 records I am trying to write a trigger that will change a flag to 1 for all record updated by the query. [CODE=sql]USE [online] GO /****** Object: Trigger [dbo].[gl_courselog_iscounted_update] Script Date: 12/10/2007 16:49:32 ******/ …
Hi, I have problem when trying to connect to databse and execute query. Here is the full code: Private Sub OpenDataReader() Dim strConn As String = "Server=localhost;Database=Northwind;" + _ "Integrated Security=SSPI" Dim cnnNwind As SqlConnection = New SqlConnection(strConn) cnnNwind.Open() Dim strSQL As String = "SELECT * FROM Shippers" strSQL += …
Hi I have created an application which displays Images on another page as thumbnails. It is giving me the following error; An attempt to attach an auto-named database for file `D:\Users\i-chaitanyau\My Documents\Visual Studio 2005\ThumbNailView\App_Data\aspnetdb.mdf` failed. A database with the same name exists, or specified file cannot be opened, or it …
I have a bunch of print statements in a SP that tell me exactly what went wrong in the SP (if anything), but I cannot figure out how to capture the text in the [code=sql]PRINT 'Receiver and Customer don''t match'[/code] statements... I pretty much want to get the info with …
I'm working on VB.net(2005 studio) application that stores values.i'm using SQL server 2005 express.I dont know how to connect both of them.Is there any tutorial on the web for that? I have tried but most of the result are points to the pages of SQL server configuration,manipulation related information. One …
[B]FIRST EXAMPLE--[/B]CREATE FUNCTION dbo.myFunction() RETURNS INT AS BEGIN DECLARE @myInt INT SET @myInt = 1 RETURN @myInt END select dbo.myFunction() as 'Simple Number' This Function is not returning any value,Error is coming [B]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.myFunction", or the name is ambiguous.[/B] [B][COLOR="Red"] …
I need to [U]create [/U]a data file called students.dat and [U]insert [/U]a few records into it. I need (3) fields: 1) student id no. 2) last name 3) first name I thought it would be pretty straight forward, but I get a compile error: Invalid Outside Procedure and "students.dat" is …
I am using Azman (Authorization manager) with Asp.net 2.0 I am trying to add a user to a role in the code: role.AddMember(user.ProviderUserKey.ToString(), null); but the following error comes up: [COLOR="Red"]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may …
HI I have this situation in excel i have many rows for import but some rows in last cell have many insert and in that situation i must have every insert in new row that look like this collumns 1 2 3 4 5 6 rows 465465 54654 645 46546 …
i have a database called [B]"BILLING_SYSTEM"[/B] in sql server 7.0 and I'm using sql server authentication mode to connect to the database with my [B]username[/B] [B]"BS"[/B] and [B]password "BS"[/B]. where my front-end is a VB6.0 application. [B]now I want to create this security login "BS/BS" from vb6.0 code without opening …
Hi guys, I'm looking for some help in designing a database schema. Im planning to build my own online clothing store selling t-shirts, jeans, sneakers, tops etc. Mainly clothing but also some other cool bits, for an idea of the sort of products I plan to sell check out [url]http://krudmart.com/[/url]. …
Hi all, i need help on asp-sql code. I have a form when I catch some infos and i want to create a new record into a database. I have tried many syntax but I can't pass the variables a,b,c,d,e,f to sql string. Please tell me how can i do …
Does anyone know of a tutorial/site that explains how to bind to a tdblist clearly? If anyone could explain it, I would also appreciate it. So far I have this and must be missing something. It has been way too long since I have done anything in VB6. :) Other …
Can I query a SQL Server 2000 mydatabase.mdf file directly via SQL? If so, how?
hai i am using the following code to apply the watermark and save in specific location and then upload the image to database [code=asp][ byte[] img1 = new byte[fileupload1.postedfile.contentlength]; Httppostedfile image = fileupload1.postedfile; image.Inputstream.read(img1,0,(int)fileupload1.postedfile.contentlength); Bitmap bm1 = new bitmap(new system.IO.Memorystream(imd1)); Graphics grp = Graphics.FromImage(bm1); grp.smoothingMode = smoothingMode.AntiAlise; grp.Drawstring("name" ,new font("Arial",20),systemBrushes.WindowText,250,250); …
Hi, I am hoping someone will kindly help me out. I am new to ASP and need to create a connection to an SQL server 2005 database. I have failed misserably at web so far and is my worst subject on the course that i am doing. I understand that …
A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …
A publishing firm that consists of twenty five employees utilizes a Microsoft Access database system to store and process requests related to their business transactions and operational data such as product sales and customer information. Over the last five years the firm has experienced tremendous growth; as a result, the …
i want to generate thumbnails retrieving images from data base for this purpose i m using sql server data base and the name of SQL Connection is SqlConn. i m using List View for Thumbnail purpose. i m using tree view for creating Albums and Photos in data base. i …
I need some advice concerning the hosting of an IIS web-based application that uses a back-end SQL 2005 database. This application will be rolled out to 200+ users and I don't have the bandwidth or the technical support staff to support the hardware on a 24/7 basis. I have contacted …
ASP & VB with MS Access. This recordset should spit out the results of a search from several select boxes on previous page. I keep getting: [QUOTE]Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /RP_Ref_Guide/RP_search_results.asp, line 25 IF fRPname <> "" THEN results1=results1 &" WHERE tbl_Partners.Partner_company = " & fRPname …
Can I query a SQL Server 2000 mydatabase.mdf file directly via SQL? If so, how?
Hi, I'm a newbie to this forum and I wanna ask a few questions:) How can I export using jsp, data that are store in sql database to word or excel or even pdf? Is it possible to be done? How can in jsp to provide into my webpage an …
i m working on a small application its main function is to create a album and then add photos in the album. i m using tree view for creating album and photos i m using tree root as album and nodes as photos. i have to also show thumbnail view …
I have been using VB.Net for a little while now, but I just started needing to write code to put information in a SQL Server database. I have two tables that I need to add information into. I know that I have to use an Insert statement, maybe I need …
I use ADO.net and SQL database . but cannot updata records into database . Who can do it ? help me please ! my database is sv.mdf , table is huycnt include fields : id , name . help me soon . Thanks
i m working on a small application its main function is to create a album and then add photos in the album. i m using tree view for creating album and photos i m using tree root as album and nodes as photos. i have to also show thumbnail view …
i m working on a small application its main function is to create a album and then add photos in the album. i m using tree view for creating album and photos i m using tree root as album and nodes as photos. i have to also show photos when …
hi everyone. I am doing a project in jsp where i need to check the duration of logins of a particular client. If the client doesnot login for 6 months(say) his account should expire. For this purpose i am taking system date and storing it in sql database. I have …
hye there..i need help here..im developing a smartphone device. i need to install a sql server ce but somehow i download it,but i cant run application.so my ques is how do i know wat the version of my sql server 2000 (version 8.0)competible wif which sql server ce? thanks in …
i m working on a small application its main function is to create a album and then add photos in the album. i m using tree view for creating album and photos i m using tree root as album and nodes as photos. i have to also show photos when …
Hi, I am using Northwind database and I am trying to delete the Products information from the Products table using SQL. However, when I tried to do that, it says that it can not be deleted because it is related to an another table. My problem is, when I deleted …
i m working on a small application its main function is to create a album and then add photos in the album. i m using tree view for creating album and photos i m using tree root as album and nodes as photos. i have to also show photos when …
I need my program to connect to a database, check if a table exists, and if not, create it. I intend to check the presence of a table by simply running a "select * from table" query via an SqlCommand. I am going to put this in a try block. …
hi all, I am working in a Carbon Application(MAC) using C++. I want to connect my application with SQL Database because i want to retrieve the values from the database and use in my application. How to connect SQL.?
Hi guys, Another Vista restart problem. This SQL writer restarts Vista atleast once a day. The even viewer has this to say: Product SQLWriter Problem Service Hang Report Date 26-03-2008 AM 10:53 Status Not Reported Description Service SQL Server VSS Writer hung on starting. Problem signature Problem Event Name: ServiceHang …
The End.