[microsoft:sql-server] Forum Topics

For example, my query is something like: [CODE] SELECT fullName = firstName + ' ' + middleName + ' ' + lastName, streetAddress = address1 FROM Person [/CODE] How would I be able to reference fullName directly without having to type out first+middle+last again? If I just added "WHERE fullName …

Hi there, I was really hoping I could find a person which could help me with my server setup to get it fully working for ASP.NET web applications under Win 7 Untimate (32bit). I'm trying hard to setup but I still can't get into the database file. I want to …

I want to use a progressbar to show that I'm retrieving the records from the database so that the user wont be confuse if the program is still running or not. Here's my code. Please help me.. [CODE]Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load cs …

I have a table with roughly 50,000 records. Each record has 25 or so columns. One of which is a phone number column. Some of these records, while most not not the same in any other way (a few are identical), have the same phone number. Id like to delte …

Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it …

I make a small project on student but i don't know about file handling for database; can any one tell me the simple way to connect my project to SQL database;

Hello to all. First of all, I would like to say that Im jst a newbie to ASP.NET development and Im just trying to explore the VWD IDE. So here's what happened: 1. Tried to add SQL DATABASE under App_Data Folder. (good) 2. Tried to add table. Created table definition. …

Hi, I am using asp.net with SQL2008 facing a concurrent user issue, if 2 users launches the application and clicks save then it is allowing to save the record twice. I need to avoid saving duplicate record. How can i acheive this? 1 thing i thought of taking Modifiedat value …

Hi there I'm looking for a way to add filters in my windows form application. I have a menu strip with item called 'Filters'. Under that items there are items called 'Jobs Pending, Jobs Outstanding, Etc.....' Take for example 'Jobs Pending'. How do I filter from my database in sql …

Hi, I have a c# form in which I retrieve data from Access DB. I have Two DateTimePickers so I could choose data between dates. My problems is when I try to retreive data between 19/10/2010 and 12/12/2010 it gives me me data beyond 12/12/2010 but when I try to …

How Can crate A Slide Show in asp.net page using java script and image is inside the sql database

Afternoon All, I have ran into a problem that i cant get my head around, I have the following code(see below) this all works fine if there is a imgID ='5' but if there isn't a record in the sql table with the imgID 5 then i get the following …

I have a datagrid that I use to display data from a SQL 2000 table. I am trying to write back any changes the user makes to the datagrid data back to the original table but don't know the proper method to do this. Can anyone help? Here is the …

Hi I have the following coding whereby I am trying to show Properties that have their price within the from and to drop down menus. However it only works well when the from price is set to 0. when I do price from 1000 to 800000, properties within that range …

i have this insert code and its giving errors because there is something wrong with the connection string. [CODE] Dim MyConnection As SqlConnection Dim SqlString As String = "INSERT INTO items_table (item) VALUES ('" & Me.txtItem.Text & "')" 'Dim data_base As String = " Data Source=.\SQLEXPRESS;AttachDbFilename="C:\vb2008\Visual Studio 2008\Projects\morevariables\morevariables\App_Data\test_db.mdf";Integrated Security=True;User Instance=True" …

Hey everyone, im currently designing a database. i usually design my tables with "LastUpdate" field with a smalldatetime data type for tracking purpose. which is whenever user insert or update a row. there's a trigger that updates that specific field. now, i was thinking to split the information of "created …

Hi All, I think of creating a table(TeamMember) which has the following columns: (Table1) TeamMemberId TeamId MemberId StartDate 1 TeamA MemberA 1-Jan-2010 2 TeamA MemberB 2-Jan-2010 3 TeamB MemberA 3-Jan-2010 4 TeamA MemberA 4-Jan-2010 . . . (TeamMemberId is an autoid field) This table is to record whenever there is …

hi , i have a field in a table with the datatype as datetime. i wrote a query to get that feild but the thing is i want only the date to be displayed, how can i do that, currently the date and the time is being is displayed, how …

Hi All, I am new to sql and also this is my first post in this THREAD, Inline with this I am going to improve knowledge on sql, so below is my query which i desperately needed and don't know it is possible or not? I've Two table Table1: ProblemGroup …

How to connect sql data base on asp.net page

Good afternoon, I have a problem... Else I wouldn't be posting here, right? My quandary is thus: I have an empty table in a database that I want a user to be able to fill. This will occur when employees are replaced for sick leaves, etc. I'd like to be …

I was wondering if anyone could tell me why my code is not displaying anything. My connection is correct because I did copy it from a program that already works properly. *Beginner Student* [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { class Program { static void Main(string[] …

I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT …

Ok, i need help making two list boxes. One is dynamically filled with results from an sql query ( i think i can do that). The second is then empty. The user will double click a value in the first box and it will be moved to the empty box. …

can someone help me with why this code is not inserting into the database [CODE] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT INTO Workers (FName, LName, FullName) VALUES ('" & Me.txtName.Text & "', '" & Me.txtSurname.Text & "', '" & Me.txtFullName.Text & "')" 'Dim data_base As String …

Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID …

Hi, I am working on a project in that I am using C# and SQL as front & back End. I want to copy my all old data in my new project. and now I dont have SQL in my system. How can I copy my data please help me …

Hi everyone... I am developing this student management system which has one form that saves student data( including student image). Now w.r.t saving student image I want that the user should insert image from the folder where he has saved student images. On the save button the image path of …

Hi I have a windows form application connecting to a sql compact 3.5 database. I can add and delete records via buttons I have created. When I add a record I update the combo box and it works fine. But if I delete a record, I first have to close …

Hi All, Im trying to Insert a new row into a database and refresh the dataset. This is what I have so far: [CODE]void ButtonInsert(object s, EventArgs e) { string connectionString = null; OleDbConnection connection; OleDbCommand cmd = new OleDbCommand(); string sql = null; connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;data source=Book.mdb"; connection = …

Hi all.. I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM. I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the …

Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which …

Hello all... I'm trying to populate a Flexgrid using an SQL query that involves values external to the database being queried. The database contains latitudes and longitudes of points of interest on Earth. Ie. Point A, -43.5644,-79.5432 Point B, -89.5433, 76.3343 Point C, 54.6433 , 65.4432 What I want to …

is there any code that is the same as the distinct function of mysql to mssql? thanks in advance..^^

Hello Is there a querry to convert a whole column into MD5 but i only need the first 19 characters of the MD5 thanks

Hy guys as mentioned before on my threads I'm a self teaching person learning VB. I' sucessfully created a project fully functional using access database. I've read about SQL connection on VB .net. But I'd apprecite a help to have some one guiding me step by step on how to …

Hello Dani Webbers, So I've been given this old-as-hell database, it was designed in 1993 under pick, and it isn't at all normalized, in a good effort I've migrated all the data into MSSQL 2008 server and I have some several to several relations between tables, on of these relations …

hello my first thread to as for something here but i like daniweb a lot i'm trying to save data from listview to sql server [CODE] Dim iCount As Integer Dim iLoop As Integer Dim query3 As New SqlCommand Dim lvitem query3.Connection = New SqlConnection("Password=sasa;Persist Security Info=True;User ID=sa;Initial Catalog=Tel;Data Source=HA-PC") …

As the title goes how can i transfer a table from one DB to another but first i need to delete the table1 from DB1 coz table2 from DB2 has the same name as table1...

i have this insert code that is refusing to work it is giving me error 26: something to do with the network or connection. i am using sql express 2005 and vb.net 2008 any help will be greatly appreciated [CODE]] Dim MyConnection As SqlConnection Dim sqlstring As String = "INSERT …

hi there, i have a question in giving access to separate table to users. i have a database call Admin and in that there are some tables that the one user should not aloowed in viewing, how can i restric that user in avoing looking at that table i am …

Hi Please help me out in providing connection string for the SQL datasource at runtime...i need to connect to different database based on the login option....i removed the connection string in the web.config file and tried to select the connection string during page load but it shows an error...can this …

Hello all, I have an app that I've developed that has a vb.net front end and a SQL Server 2000 database backend. I currently have it running fine on my machine and it also installs fine on all the users that are inside the domain that the app was written …

[code] Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.Data.SqlClient.SqlConnection Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Inherits System.Windows.Forms.Form Dim myConnection As New SqlConnection Dim myCommand As New SqlCommand Dim ds As New DataSet Dim cmdtext As Integer Dim action As String Dim view As DataView Dim dr …

[ICODE][COLOR="Red"]Please send any Example for [B][U]DataBinding of WPF with SQL Server[/U][/B][/COLOR][/ICODE]:):):)

Hi, I want to make enter Textbox value in multiplication of 2,the value in the textbox is retrieved from database. This is my code: [code] int a = int.Parse(textBox3.Text); int b = int.Parse(textBox3.Text); int c = a + b; textBox3.Text = c.ToString(); [/code] I had retrieved value from the database …

When I set the VisibleWhenLoggedIn property of my Login control to false, my Login control automatically becomes invisible even if I'm not logged in. I've already set the Authenticate event to use my own SQL database, but this problem is still persisting. How do I fix this? Here is the …

I need to make UI in C# that works with an SQL DB. I thought piece of cake! I imported my DB files to the Visual Studio (add->existing item ->browes and add) I dragged the tables to my Forms & there were automaticly buttons like New, Delete, Save, next record,previous …

Hi i'm using a table adapter.insert() method to add new data to my table and i need to get hold of the id of the inserted row. I've read around and seen that the most popular way to do this is with SELECT @@IDENTITY as Value but im not sure …

HI im new to asp.net and i want help when click insert button same record is inserted instead of new record. Pls reply asap as my project is based on this [code] using System; using System.Data; using System.Configuration; 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; …