[microsoft:sql-server] Forum Topics

Join a table to itself with no specfic ID I have a table of customer records which has no ID column, a customer may appear in the table more than once with various of the columns populated. I have managed to build a column INIT_SURNAME which is fully poplated but …

i want to export all data in sql 2005 database to excel file but i don't know! Please help me! Thanks so much!

Im receiving the above msg even after using MultipleActiveResultSets=True to connection string public partial class registration : System.Web.UI.UserControl { string gender; SqlCommand cmd = null; SqlConnection con = null; protected void Page_Load(object sender, EventArgs e) { con = new SqlConnection("Server=.; database=nkm; user id=sa; pwd=karthavya"); con.Open(); cmd = new SqlCommand(); cmd.Connection …

I need help. I have a SQL Server database that will store information for events that will be taking place. The sql database looks like (see attached). I am fairly new to programming so I need a lot of help, please. I need a web page that will allow a …

Really Im getting very much confustion. I searched in net to get solution for the following msg. There is already an open DataReader associated with this Command which must be closed first. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace …

I am a trainee in a company as IT Analyst ,i would like to know more about IT field. Which is the main sector on which i should more concentrate as Servers, Web Designing OR Programming . I am much familiar with ASP, html ,Windows Server 2008 and Learning SQL …

I want to fill a Table quick. I have tried something but its not working. Here is my MSSQL-Script: [code] CREATE FUNCTION [dbo].[fillTable] ( @Amount INT ) RETURNS @Integers TABLE ( [IntValue] INT ) AS BEGIN DECLARE @Counter INT SET @Counter = 0 WHILE @Counter < @Amount BEGIN INSERT INTO …

[CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace DataClerk { public partial class Form3 : Form { public Form3() { InitializeComponent(); } private void btnClear_Click(object sender, EventArgs e) { txtPNo.Clear(); txtPName.Clear(); txtSiteName.Clear(); txtJCNo.Clear(); txtRequired.Clear(); } private void btnSave_Click(object sender, EventArgs e) …

Hello all...incoming newbie question. I'm new to building desktop apps after a couple of years using ASP.NET online. I'm using MS Visual C# 2010 Express to play around and learn with. In order to test something that would be of real use to our company I want to be able …

I am running a Query that throws "All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. " in my code, yet I can run the same query in my query browser directly on the server and it works …

I have 3 tables which hold PO's which have uniquie IDs I want to get the last ID in the list then add one to it (i can add one in my code if needed). My query thus far is [CODE] SELECT TOP 1 (SELECT 0 AS [PURCHASE_ORDER_ID] UNION SELECT …

TITLE: Connect to Server ------------------------------ Cannot connect to CHATHURA-PC. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: …

HI GUYS i want to get the entries in afield as you type for example in Gmail when u type alphabet 'a' in the send to field ,you get the contacts starting with 'a'and second alphabet 'b' you get contacts starting with ab and so on i would like to …

Guys...on my final year project i have to create traffic controlling system. actually my section is retrieving the current traffic details from users mobile phone. Let’s say a persona need to go from "A" junction to "B" junction. so the user will send a sms to system by including the …

hi all.. i have created a cube in bids..here i am stuck in a very bad way.i have a measure called as total and a dimension called as date..what i want is a measure which will calculate the difference of the total for the years..eg..for 2007 total is 5 and …

Hi, I know this sounds like a repeated question but the tips in other threads didnt quite help me, so thought of asking again. I have 2 tables 'tbl_AWB' abd 'tbl_flight'. Flight has the fields "FlgihtNo" (PK), "DepCityPort","DestCityPort", "DepTime", "ArrTime". tbl_AWB has fields 'FlightNo', 'DepCity' and 'DestCity'. The tbl_AWB is …

I'm currently converting an application that utilize sqldmo which has a feature .script that can just magically retrieve a script for a particular index for me. Is there a query I can write or a already built in stored procedure I can use to do similar things? Any help would …

I have the following code for part of an application I'm building and I need some instruction on how to store this value and carry it to the next part of the program. [CODE] Private Sub dateEntryTextbox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dateEntryTextbox.TextChanged Dim dateEntryTextBox As Date …

I have found a tutorial that will teach me how to set up my first Database, but the first thing it tells me to do is right-click on the Data Connections Icon within Database Explorer and choose "Create New SQL Server Database" ... unfortunately, this option is greyed out, so …

Look at this image: [URL="http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg"]http://www.roflsaurus.com/users/durexlw_QuickUL/SQL_join5Tables.jpg[/URL] I want to select everything of tblPersons where all taskorders are connected to that person and where tblSteps.done = 0 and where tblPersons.id = a certain ID... needless to say: my head hurts and I can't seem to figure this one out. Any help is …

I want to save image from Picture box to SQL Server DB. I am trying to do this using the following code but cannot able to do so. Please help. My Code Snippets are as following: Dim fs As FileStream = Nothing fs = New FileStream(picPhoto.ImageLocation, FileMode.Open) Dim fi As …

I have a form (Delphi 2010) that includes several data controls, including a DBImage. All these are hooked to a underlying MSSQL 2005 database and table. I'm using ADOConnection and ADO Table for ease of use. I need to include image data in this table, so I have set up …

helleo all i want to delete from 5 tables with inner join like that: Category=CategoryId,CategoryName,.. Item=ItemId,ItemName,pictureId,VideoId,AudioId,CategoryId Picture=pictureId,pictureName Video=VideoId,VideoName Audio=AudioId,AudioName the user will Enter category name in text box iwant to delete Category+Item+picture+audio+video help me please :)

Hello All, I am currently in the process of adapting an application that previously worked only with Microsoft Access to work with SQL server or Access. Previously, all database interaction was designed based upon using the XSD file to create queries (etc). I wasn't sure how to handle the new …

hello to all, i want to connect to mssql which is using windows authentication Can anybody help me with that... i know the server name

i wrote a software which would work perfectly fine on vb.net with connection string: SQLConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename='" & a & "';Initial Catalog='" & f & "';Integrated Security=True;User Instance=True" but if i try and run it on a pc with sql server 2005 installed it fails to run what changes …

I would like to know why sql query for month and year is working, and i[B]s not working for day[/B]: [CODE] string myQuery = "SELECT StudentName FROM Students WHERE " + "YEAR(Birth) BETWEEN @yearFrom AND @yearTo AND " + "MONTH(Birth) BETWEEN @monthFrom AND @monthTo AND " + "DAY(Birth) BETWEEN @dayFrom …

hi there, my project is a desktop application, i am trying to transfer(upload) a file(can be excel,doc,txt pdf) to another sql server in another computer in the same network how can i do this in C#.net desktop application, i am not using web service or asp.net how can i do …

I'm relatively new to using VB but I'm trying to design a small program that has a lot of SQL involved in it that someone else wrote. What I'm trying to do is to do a date selection of 7 days at a time, and pass that as a variable …

hi everyone i have a couple of issues i hope to find a solution. 1.i have a data grid view with a couple of columns.the second column is a combo box whose item are names in a database, sql server 2005.i need a code that enables that when an item …

I was created a web site using asp.net 2.0 with sql server 2005 data base.. That site home page url is [URL="http://foxads.lk/virtualTest/new/home.aspx"]http://foxads.lk/virtualTest/new/home.aspx[/URL] At the development time all code are executed well But at the run time Those error are occur [URL="http://foxads.lk/virtualTest/new/buyproperty.aspx"]http://foxads.lk/virtualTest/new/buyproperty.aspx[/URL] [URL="http://foxads.lk/virtualTest/new/createAd1.aspx"]http://foxads.lk/virtualTest/new/createAd1.aspx[/URL] ect... the connection string is in commen web …

hello i am working on this application where i need to import 60k+ user data and insert into different table. i have made a C# application which selects the database and inserts from a text file.like [CODE]insert into dbo.dbname ([user_name],[u_id]) values (a,b)[/CODE] but this apps hangs for 60K+ data so …

Hi Im still quite new when using MS SQL but I have a pretty good understanding of it. -I am using Crystal Reports to retrieve and manipulate data from my database. -I am creating small tables for certain data. -This data is selected from a constantly updating table. So i …

ive been able to succesfully link a mdf databse to a vb.net program.My program runs flawlessly but if i change the location of the database from e:\new\xyz.mdf to c:\new\xyz.mdf then it throws an exception : System.Data.SqlClient.SqlException' occurred in System.Data.dll [CODE] SQLConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename= e:\new\xyz.mdf;Initial Catalog=xyz;Integrated Security=True;User Instance=True" [/CODE] And …

i have in the Visual C# 3 options of database : 1. SQL SERVER (.sdf) 2. ACCESS (.mdf) 3. ADO.NET (.edmx) which database advisable to use??? *if you give me answer please give me tutorial\book\name of book. thanks.

I have a list of questions, each has its own category. I want to be able to select 5 random questions from each category and then display them ordered by category in something like a nested repeat region. I have the sql for obtaining the random 5 for each category …

Hi there, The program in hand must retrieve a bunch of data from an SQL Database (currently stored in a DataTable), fiddle around with the data, and then upload the changed data to the same SQL database. Everything works fine at the mo apart from the final bit, uploading to …

Hi guys, i have this SQL query. "SELECT SUM (TotalTaskCost) AS "CombinedTaskCost" FROM TaskCost;" I want to display the values vertically in a crystal report. How do i programmatically add a field for the artificial column "CombinedTaskCost" generated by the SQL query? Thanks.

I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this …

i dont know how to read from database SQL. i try this : [CODE] string sql = "Select * from Table1 "; DataSet ds = new DataSet(); string connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataAdapter adapter = new …

hi friends, I have problem... I use asp.net 2.0 with code behind file as C# and database as MS sql server 2005... I was created some web application...I connected it to the sql server database... now i want to publish in on internet... How i give to datatable[what i was …

Hi guys I want to join two tables and executive the sql statement.I mention what is code i wrote ,Once Complie the code it says Error1 The left-hand side of an assignment must be a variable, property or indexer [CODE]SqlConnection Con3 = new SqlConnection("Data Source=IT;Initial Catalog=Test;Integrated Security=True"); Con3.Open(); string str1 …

hi there, I need to upload files to the mdf file in visual studio 2008 standard edition. the database table which takes the file data in to varchar datatype. i convert the data to byte and then save it in a varchar type field. the code is below for uploading …

Is it possible to save execute stored proc command in a string variable and then execute string variable??? Does this logic fits into LINQ2SQL? Why I want to do this - INstead of passing user control references to server, I want to save user control values to string in client …

Hey Dani user! I am experimenting with the data generation function in Visual Studio 2010. It seems very powerful and useful. My problems is when I am generating new test data my tables gets re-seeded. Has anyone played with the new Data Generation in VS 2010? And if they did …

please help me on this making a payroll system using MSSQL.. i dont know how to start.. just a simple one.. please..

The code bellow is a sql querry, made in code. I would like to know how to do such stored procedure: [CODE] string[] NameSeperated = FullName.Split(' '); string querryName = @"SELECT StudentID FROM Students WHERE Name = @name"; if (NameSeperated.Length > 1) querryName += " AND LastName = @lastName"; using …

We use vb.NET windows form program to pass parameters to crystal report wich execute sql commands I use .NET 2003, crystal 9, windows server 2000 and SQL server 2000 at the above enviroment the reports application work very well when migrate to SQL server 2005 , and windows 2003 the …

please help me on this making a payroll system using MSSQL.. i dont know how to start.. just a simple one.. please..

I have an application that uses an *.accdb file as the back-end database. Connecting to and retrieving data from the access file is not an issue and is working quite well. However, as a precaution, I have the application first check to make sure the database file exists in the …