[microsoft:sql-server] Forum Topics

Hi! Thanks for trying to help me! I'm building a program that will allow me to have a different form for each person in my database. When the program first starts, I want it to cycle through the database and open a form for each row (each person). I'm generally …

I'm trying to set up performance dashboard in SQL Server Management Studio Express. I'm currently running SQL Server 2005 SP3 ('product level') and also have installed the Performance Dashboard add-on. A couple of forums I've seen said that I could access the reporting feature by updating the Management Studio Express …

I am trying to pull data from a table to fill a drop down list. Now, i got the fill part working, but am having an issue passing a variable value to my form post action. Code: $query ="SELECT UniqueIdentifier, LastName, FirstName FROM BrokerMain ORDER BY LastName"; $result = @mssql_query($query); …

Hi All, I am in a process of trying to concatenate related fields field in Access. eg: consider the following table Awarded to On Date Emp1 01/01/1990 Emp2 02/01/1990 Emp1 03/01/1990 Emp3 04/01/1990 Emp2 05/01/1990 I want my query to return something like: Awarded to On Date Emp1 01/01/1990, 03/01/1990 …

Hi, Im trying to retrieve some particular datas from SQL column into RichTextBox in WindowsForm. Im Getting only whole SQL column from SQL Table. If u know the answer, Kindly post. Thanks in advance

HI I have to create a small database that will be used by the clients, to get and be able to run their own reports. Can you think of any other Columns needed? You have to allow for a client to have one or more persons be the admin, that …

Hi. I want to ask about this code. I'm trying to upload csv file and import into sql. but this code doesnt working.[CODE]protected void LinkButton1_Click(object sender, EventArgs e) { Response.Redirect("login.aspx"); } protected void Button4_Click(object sender, EventArgs e) { string filePath = FileUpload1.PostedFile.FileName; string filename = Path.GetFileName(filePath); string ext = Path.GetExtension(filename); …

Here are the 2 procedures in question and the code that I use to call it. I will follow it all up with the error that is being produced. [code] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[usp_GetPropertyData]( @page int, @page_len int, @sortfield varchar(100), @desc bit ) as …

[B]hello..! required a help i want to store a date in sql server field...i set the field type is datetime..bt i jus want to save only Month and year ...kindly help me in it..! i m working with vb6 i set the date formate [/B] [COLOR="Green"]myDate = Format(cmbMonth1.Value, "MMMM-yy")[/COLOR] [B]bt …

Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column …

hi...... to all i have one problem in executing the ssrs reports.. i've developed one project for that project there are some SSRS reports which are deployed in path ( "http://localhost/reports/") it is working fine... when i run through the project and press F5 ( i.e execute) the reports are …

I am planning to create a webpage to collect simple information. Name, email, phone number, college name and also their markes in each subject Exam subject1 subject2 subject3 subject4 Result test1 85 77 90 90 pass test2 89 89 74 74 pass test3 88 91 98 98 pass Name: College …

I am trying to delete a row and update the database, i wrote the code, but it results in an error: Dynamic SQL generation for the updatecommand is not supported against a selectcommand that does not return and key column information. the SQL table contains a primary key, any idea …

I am beginner in vb.net, I have created a report in SQL Server Report Builder 3.0 and I want to call/run this report from vb.net form. Please tell me how can I do this, if you have any sample code will be highly appreciated.

I know this might have came up, but i have a login code and once logged in it would show u your information that u entered in the sql database just for that one person that logged in. Here is my problem when i login it shows another users information, …

I'm coding a project in C#, VS2010, using SQL Express 2008 as the data source. Whenever any other application connects to the database (such as Management Studio), the next time my C# application runs, it cannot access the database. The error is "Operating system error 32". Unable to open the …

Hi im working on views that can help me navigate through records in a table. i have managed to execute an sql string to select the table i.e "select * from Users" i however want to build a "Previous" and "Next" command on the view but im mixed up on …

ok i'm want to populate dropdown with fields from a table in database(sql). Please help!!!

hi.... The code is about place the comma's (,) i.e separator between numbers in this format (12,21,21,123) it works good.. but when there's a decimal point such as 12345.58 it will show as 12,346.. it will round up the values.. ( which i dont want that .. i want as …

Hi all, I have a page on which I've done several successful ExecuteNonQuery calls that added new rows to existing tables. But one, despite all the parameters being correct and receiving a positive return value and also a valid output parameter, seems to have no effect on the database. Several …

hi... to all.. i've developed one ssrs report in "sql server 2008 express with advance services"... The virtual folder is not there in IIS .. ok it works fine .. i.e [url]http://mysystemname:8080/reportserver_sqlexpress[/url] it works good... but the same thing i want to execute in another system .. with my system …

So I have a small database for managing stationery orders (internally with my company - I order from the stationery dept). In the orders forms i have a subform with the list of items being ordered. I have the Item_ID, description, UnitsOrdered,UnitPrice, TotalPrice. What a code that will lookup the …

hi.... to all.. i'm using sql server 2008 express with advance edition with BIDS... i've developed one report in that employee salary.. i want to print the salary in the format (12,34,56,78,91,01,11,233.89) and i want to print in words such as (" ninty nine crores fifty one lakhs fourty nine …

How can I create a blank space in sql server with null?:)

Okay.. Currently i already had this code for my registration form [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { …

hi... i'm using sql server 2008 with advance services the below error is of reporting services.. "The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)" when i'm trying to host appliction.. the above error is occured.. it works fine when i try to execute locally.. but …

Hi friends, I got vb.net 2008 express and sql server 2005 and 2008 express editions whic I downloaded from microsoft website.Now I just want to connect vb.net with sql server 20o5 or 2008.I am using a connection string as PubConnstring = "Data Source=RAMAN\SQLEXPRESS;Database=FirmTest11;Trusted_Connection=Yes" [code] 'Create your connection object Dim objconnection …

Hello, I want to check the username & password of the user with the already stored database and then login. Iam using asp.net(vb) with sql server as database. Please help ME [CODE] Imports System.Data.SqlClient Imports System.Data Partial Class MasterPage Inherits System.Web.UI.MasterPage Dim con As New SqlConnection("server=localhost;database=reg1;integrated security=yes;") Dim ds As …

how can be store image itself in sql server and retrive it ? plz not it's path [COLOR="Red"][B][I]Thanks[/I][/B][/COLOR] :)

How can one search for multiple items at once and display the result in a datagrid? for example, i want to search for multiple mobile numbers (in sql server database)at once and display the found numbers and their corresponding names.

Hey guys! Im working on a login form that connects to an SQL 2008 database. i have created records in the table for users who can login. i however want a code snippet that matches the username and password entered with the records in the database. i have a rough …

Hi, appreciate if you can spend few minutes to analyze the problem below and shed some lights. Thanks I would like to Sum up MTD Value and separate by employee ID. I've used SUM(MTD_Value) and Group By Employee_ID but is not work. Thanks [B][U]VB.NET Coding[/U][/B] [code] Dim connetionString As String …

Thank you very much for reading this. I've been programming for 15 years (VB, a lot of PHP, etc), but I've never considered myself a 'real' programmer. Mainly I'll build things that I need that are too specialized to be made by anyone else - simple programs and scripts to …

[ATTACH]17851[/ATTACH] Hi, Format my PC and installed SQL Server 2008. Setup hangs as shown in attached image. Installing on Win 7 64 bit OS. To install SQL Server SP1 is left to do due to this. FYI, the top text reads: Running post-Windows Installer configuration timing actions the bottom text …

I add connections in server explorors. Then, I use AdventureWorks Person.Contact to set up a query by searching peter and mary ,but how to add it on form 1 ? and I type part of their names and by the way how to link a "VB label of text" or …

i need help here(my school project- UNIVERSITY HOSTEL ALLOCATION PORTAL): i want to load table with data from database. the table will contain FullName,RegNumber,Sex,Level,Department,Faculty,Session from database(StudentData) where the RegNumber match. I use table.Load(Reader) ie "result2.Load(dr)". the problem is that it works atimes; other times it give error:> "THAT I SHOULD …

Dear Experts I have loaded a picture in PICTUREBOX1 by this command Me.PictureBox1.Image = Drawing.Image.FromFile("D:\C2007\BITMAPS\pict.jpg") How to store this picture SQL server 2005 table1's IMAGE column? I do not want to store image path in table. I want to store picture in image column in any format. Reason: If I …

I am currently working a registration project and here is my code.. [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.Sql; using System.Data.SqlClient; namespace Thesis { public partial class Registration : Form { Form formParent = null; public Registration(Form par) { …

Hi, I am using c# to update and view the student_Teacher simple database in sql. I used textboxes with binding navigator to view and update the teachers info and datagridview for the students, so 1 teacher per many students is the output. I have no problem for searching, editing and …

I have a query like: [code] select * from tableA where id in (1,2,3,..) [/code] List of ids ids very long about 200 000 ids. There is an clustered index on id colums. The same query on mysql rus fast but on MS it cant take about 20 minuts (on …

I am developing an application that based on when a user has last entered a payroll, my program tells them the next available Sunday that is available to them based on 1. The date that the last time payroll was entered 2. If payroll ran = "yes" or "no" I …

Need to retrieve a data row that having minimum sum of 4 [B][COLOR="Red"]red [/COLOR][/B]squared values. i Have done a SP ,but seems to be it was wrong. [CODE]select * select * from SMST as p where p.Source=@Source AND p.Destination=@Destination OR p.Destination2=@Destination AND [Count]=(Select MIN(sourceRoadCount+middleroadcount+destinationroadcount+x1destinationroad2count as [Count]) from SMST ) [/CODE] …

Please Help, I am creating a Simple Crystal report that views outstanding logs for our call centre,I have a stored procedure that retrieves all the Info I need.Here is where it gets interesting.The Report retrives all the relevant data and shows me page One.When i try to view the second …

Hi, I know that when you set a column in ms sql to auto-generate IDs you won't be able to change the values. i'm having a problem with that restriction, because i have a table called Requisition, and for each entry, the requisition has a revision number. I've set the …

Hi all, In my C# application I have a SQL database with a table called Customers. In this table I have several columns like Name, Street, ZipCode and City. I already managed to get data in and out the database with the use of datasets, tableadaptors and bindingsources and get …

Hi I installed visual studio 2008 64bit.and i need MS sql server express 2005/2008 64 bit. plzz help me.i tried one.but installation is not completed.Is there a special way to install it.

Hello all, Greetings! I have just found this site, as i was searching for how to read any file in binary mode, like when you open a word file in hex editor it will show the "D0 CF 11 E0 A1 B1 1A E1" as the first eight bytes. I …

Hi guys! I created a simple code to add records into an SQL database as shown below. It seemed to be working but then the next time i tried running it, i got no output. actually on clicking the button nothing happens at all. no warnings or error messages at …

Hi, could someone please show me how or direct me to a source where i can learn how to connect and manipulate SQL Server 2008 database with VB.NET. I have created a database in SQL Server 2008 and i've created forms for viewing data on VB.NET but i dont know …

Hi everyone, i got very good help from daniweb with regards to my project; online project allocation system in drawing up my erd but now i need serious help with the asp coding as that is what stands between me and my first class and time. I would need help …