[microsoft:sql-server] Forum Topics

hi all! Till now i have made simple applications in C# that dont make use of Database. But now i wanna make a simple projects that keep records of employee i.e. their name,ids,emails,addresses etc. For that purpose i need database connectivy code in C#. Another problem is this that i …

I had the following stored procedure calling from a .cfm page via the following cfquery command; this is the cfquery code on my cfm page: [code]<cfquery name="GetProduct" datasource="Allposters3" cachedwithin="#CreateTimeSpan(0,4,0,0)#"> {CALL spNavProducts (#NavID#)}</cfquery>[/code] below here is the actual sql from spNavProducts which is called: [code]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go …

Hello all. This is my first post. I'm a software engineer with a general knowledge of SQL, but am no where close to an expert, let alone an intermediate. My current issue is I'm working on a query which combines 2 tables: TableA UniqueID Auto Increment ProjectName String <Extra Data> …

I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + …

What ho Boys and Girls, I'm attempting to make a login page in a windows application in this loverly C# visual studio express 2008 and the problem is I'm a right dimbo,lol. Thus far I have created a SQL Database of 3 columns and a pretty form with username and …

Hello, I have a problem with a varchar(15) field. We export this record with a bcp command and I get an new line in the export file from the specific field. When I look at this field then I just see 12 numbers in it. When I do a len …

Hi, I created a program to process the files in a directory. It also connects to the SQL server for data processing. The program catches any exception encountered. But what I would want to do is to force it to stop from processing. say if an error is encountered while …

I have an application that was written for me by a programmer who represented VFP as the "best thing since sliced bread" and that would be robust for many years in the future and more importantly handle huge customer databases over a LAN instantly. Now, after two years the server …

Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank …

Hi, I have one question related to SQL Server. But there is not forum on this. so here is my Question. While accessing multiple columns value in a single alias column we right query as follows. [CODE] Select FNAME +' '+ MNAME +' '+ LNAME as NAME from Cust_Master [/CODE] …

Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program …

hi all I have a connection to a sql d/b that loads data into a gridview. now in this grid view I have edit buttons that process user onto the 'edit' page (a separate page). the data from the row that was selected for editing was sent to the next …

Hello All, I'm new to the computer world in the sense that I have a new interrest in programming and developing. I was asked a few questions by someone I was chatting with on a website , who's name I wont mention, but it involves avatars; I was sooo lost. …

hi there guys ,, im have just a idiot asking ,, i have sql server 2005 express but im confusing for data work , where can i install that , into server or client , or both>>.??? i know how to basic program in SQL but configuring its merely little …

I am trying to work on a database with 3 tables. To make it easier I have created a couple of temp tables to work out the syntax. CREATE TABLE #owner ( [NameId] tinyint IDENTITY(1,1) NOT NULL, [Name] varchar(50) NOT NULL ) INSERT INTO #owner VALUES ('Thanatoid'); INSERT INTO #owner …

hiii,,i m a new member of daniweb and new to programming also.. well i have a simple login page in my website,, currently i am using standard username and password,,,but i would like to have the username and password checked from a table in the database,, i am using asp.net …

Hi all. have just dragged a datagridview control onto a form. this loads up a sql d/b fine and appropriately. the grid is editable (new rows can be added/changed etc)Now i need those changes to be thrown back to the d/b - how do i do that ? many thanks …

hii,,i am using asp.net 2005 and sql server 2005.i hav a insert page thr which i can insert details to a table in the database,,thrs a column called sme_id in the table.....what i want is when a user inserts the sme_id from the webpage,it should check from the table whether …

hEY EVERYONE Some of the problems i am having includes sql error messages when i got to some websites. i.e(for example i will load a page while some part for the page will load normally one part might give an sql message, or the whole page i am trying to …

New guy here saying Hi. I'm VERY new to the world ASP.NET so will need a bit of hand-holding.. I've been writing software for many years though in many different technologies. My main area is MS SQL as a certified DBA/T-SQL Dev (including lots of 2005) so although I'm going …

Hi all I have a table in which I save a record each time when a user checks in and checks out the office through a time in/ time out device(this device takes thumb impression of user, thus inserts record) table definition is as follows: checkInOutID (PK,int,not null) employeeID (FK, …

dear all actually , m a new to .net, i want to know how to use database connection in .net in sql way using dsn, without using provider like what i m write in vb is dim con as new adodb.connection dim sql as string con.open("dsn=test") dim rs as new …

In my website, i want to accept photos from users(through HTML page) and save them to database(MS SQL) Can you please tell me, how can i do so? Also tell me how to retrieve those photos back from database to HTML page or JSP. Thank you.

Hi Folks, Just a quickie - can wildcards be used in CASE statements? I have inherited some code and wondered if this: [code] (case substring(anownedby,0,charindex('/',anownedby)) when '2361' then 'GOD' when '2361c' then 'GOD' when '2361d' then 'GOD' when '6206252' then 'BIL' when 'bil' then 'BIL' else 'XXX' end) as branch …

HI I am software tester and want some small project which made in MS-sql server 2000 for the testing even if you have some corrupted file (not virus infected)please provide me . THANK YOU

I have installed a VS 2005 that has a MSSQL Server. When i was about to try running the SQL Server i can't find anything except Configuration tools. I don't know if its express edition or not. Is SQL Server 2005 like this? how would i know that the SQL …

ecommerce website ASP coded using MS SQL: product page - display product with all atributes. |----> on product page display associated products. | |----> Optional products are pulled from the database via a table with two columns, one column for each linked product. So on the product page it looks …

using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Data.SqlTypes; public partial class Login : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Login1_Authenticate1(object sender, AuthenticateEventArgs e) { bool Authenticated = false; Authenticated = SiteLevelCustomAuthenticationMethod(Login1.UserName, Login1.Password); e.Authenticated = …

Hi, I have a DetailsView on my page that connects to a SQL server D/B and shows its data.However, It is not visible on my page when I launch my browser. Any ideas or past experience with this? Thanks for reading.

Hi, I'm sitting with a weird problem. I created an application in C# 2005 Express. It has 3 timer controls in it. The first timer runs as a clock (system clock) and once this timer reaches a specific time during the day it runs its procedure (this works fine) The …

I have a page that inserts information to multiple tables. This part is working fine. What I want to add is when a user adds a new company not only is it inserting to the db but it is also posting the results on a separate page. For instance it …

hiii, i am using asp.net 2005 and sql server 2005...i hav a page in which i have used gridview ant sql data source.. i have written the update command for the same..the problem is when i add the where clause in the query i get an error ,,,,here is the …

Hello, I've developed my project using C language on Linux platform. When I compiled my program, I got some linkage errors. I've read in some other C forum that the errors I'm getting is due to a linkage problem with the libraries. Can someone tell me the proper steps to …

Hi, I'm trying to display an image that's stored in a SQL Server database. The ContentType and binary data are being returned but the image is coming up as a broken image. To test that the data is being retrieved I tried outputting the content type. [code=C#] Response.Write(adm["Image_MIME_type"].ToString());[/code] It is …

hiii,,,i m using asp.net 2005 and sql server 2005 i m using gridview and sql datasource,,whn i debug the application i get ths error:::: ________________________________________ Format of the initialization string does not conform to specification starting at index 0. ___________________________________________________ can ne1 help me out with ths error,, thnks in …

Hi gurus, I got a pre-formated excel sheet as destination. The header is formatted with color. The requirement is to populate the excel sheet with different data type (name(string), no (int), sal(int), age(int)) from second row onwards. The source data is a SQL table and I am using SSIS to …

I have below query inside sp. select groupno,a from table1 where groupno <> 'Test' It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help thank you

Hi there, I am a new member of this site and I am not very much aware of T-sql's working. My question is what if I need to get one column's data to be the heading of another column. To be very exact I have a school's database. The table …

Hey guys, I am developing a web based database for a company for my year work placement from university. I was wondering if anyone knew a way of retrieving the user ID from the database through the web page? Each table in the SQL Server database has an automatic Identity …

Hey, all Java and JSP gurus, Please help! In my website (created using JSP and MS SQL), i'm accepting resume from users in .doc format. Can you please tell me- how to save it in my folder from web-page i.e. the "browse" and "upload" code. (mine is a mock site …

Hi All I would like some opionion from my IT colleagues around the world including in INdia for myself. To help you give better opinion let me first give you my background: - 26 yrs in IT - 11+ yrs in infrastructure - servers, networking.... - recent 15+ yrs in …

how would one go about loading up sql data into an asp.net (without using dataview, formview, detailsview etc)? any ideas? have my table marked up already and connection strings just need to know how to put the two together. Thanks for your time

Hello, I am new to SQL. I assume that this is very simple. I have had trouble understanding the relevant example in the BOL as my installation (Express edition) does not seem to have the adventureworks database that is so ubiquitous in the examples. Say I have two tables, Test1 …

Hi I've populates a DataGridView from the results of a SQL query programmatically, so I haven't had to define the number of columns, etc. Just before I display it, I'd like to change the columns with Yes/No in them with checkboxes. Any ideas how I can do this programmatically? Regards …

I have a highly specialized update operation which I must occasionally run against a table. I would like to just send the SQL directly to the database as an UPDATE command. I have a data adapter for the table which handles normal read/write operations but this is a special case. …

I want to upload a text file and get the data of that text file into a table of database . I m using Sql Server 2000 , and working in c#. kindly can you help me doing this and if possible can you give me the code for this

hi I am getting error for above mention exe in Title. here is log using Hijack. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 6:04:29 PM, on 2/23/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16608) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe …

Hi. I have just recently bought Microsoft Visual Studio Professional 2005. It came with 14 CD's, which are SQL server 2005 Developer Edition 64-bit (2 cd's) SQL server 2005 Developer Edition IA 64-bit (2 cd's) Microsoft Visual Studio 2005 Pro Ed Academic (2 cd's) MSDN library for Visual Studio System …

I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports . I wrote a sp like this:[code] ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails] ( @paramdate datetime ='02/01/2007' ) as -- select EmpID,EmpName,month(DateOfBirth) bmon,day(DateOFBirth) bday …

Hi I have 3 tables in my database. 1) [B]photo[/B] 2) [B]category[/B] 3) [B]subcategory[/B] in my photo table i save my subcategoryid which is tied to the category table. What i need to do is get the all the subcategoryname from subcategory table where photo.subcategoryid='1' and photoid='2'. I can actually …