[microsoft:sql-server] Forum Topics

hi can anyone please help me with the codes in search stored procedure.. for example.. i have combobox which lists lastname, firstname, pt_id, (the choices if i want to search for a particular record) i forgot the code for search T.T

Hi all! I am working on making a dashboard for the inventory of our trucks. I'm having some problems with figuring out how to calculate the percentage of the total SUM of trucks per MAKE without running two different queries. You can see below what I have working this far, …

this is the error message... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Admission_Record_PT_Chart". The conflict occurred in database "HospitalManagementSystem", table "dbo.PT_Chart", column 'Chart_ID'. The statement has been terminated. my code is [CODE]Imports System.Data.SqlClient Public Class Admission Private cs As New SqlConnection("Data Source=SAbio;Initial Catalog=HospitalManagementSystem;User ID=sa;Password=TRACERT123") Private da As New …

hey friends i have one query regarding project ... while creating project on our local computer we give path of our sql server in our code which contains our database, but when we transfer our project to some other computer than we need to make changes in our code again …

How to create xml from MSSQL database.Could any one help me to find out this . It would be much helpful and appreciated if any provide me an example also.

hi i designed my database in vs 2008 and then I want to use this file as odbc database. is there any way to configure it and is odbc support mdf files?

Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?

I am using Enterprise Library 4.1(October 2008) and I am trying to use DBCommandWrapper but I can't find it I had added the following references: [code=asp.net]Imports System.Data Imports Microsoft.Practices.EnterpriseLibrary.Data Imports Microsoft.Practices.EnterpriseLibrary.Data.Sql[/code] I wrote the following code: [code=asp.net]Dim db As Database = DatabaseFactory.CreateDatabase() Dim objDBCommandWrapper As DBCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand)[/code] but when …

I'm relatively new with VB.net, so please bear with me... I have a tabpage with 28 textboxes in it. These textboxes will be loaded with data and maybe changed. There is a Save button on the form that will take the data from these textboxes and save them in a …

i have problem guys about overload resolution Overload resolution failed because no Public 'Add' can be called with these arguments: 'Public Function Add(text As String) As System.Windows.Forms.ListViewItem.ListViewSubItem': Argument matching parameter 'text' cannot convert from 'DBNull' to 'String'. 'Public Function Add(item As System.Windows.Forms.ListViewItem.ListViewSubItem) As System.Windows.Forms.ListViewItem.ListViewSubItem': Argument matching parameter 'item' cannot convert …

I am developing an application wherein I have a JSP page with clickable links to all the 26 alphabets. In my database, I have data starting with all the alphabets. The way, I have(want to) structure the application is something like this. I click a alphabetical link, say A, it …

I am using update query statment but is not working for this code [CODE]Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../lms/DBLMS.mdb") Dim item As Integer myConn.Open() myComm = New OleDbCommand("UPDATE tblVehicles SET Vehicle_Type = " & cboVehicle_Type.Text & ", Vehicle_Model = " & txtVehicle_Model.Text & ", Plate_No = " & …

I have a program for students in my school uses asp with mssql database with a small server in the school, and I want to make a website with php and mysql database, can I always update the queries by exporting the mssql to mysql? and how I can do …

Hi everyone, I have developed a desktop application. I have created a menu item to click for backup database from MS SQL Server 2005. This is why I have created a method to perform the operation. But the method is not working well. There’s something wrong in the code which …

Hi............ How can i pass and access the array variable in Stored Procedures

hello guys, i have the following question/problem: -what i need to do is to get some data from sqlserver and send it to a dataset(no problem there) after i get the dataset filled i need to send the columns and rows to a textfile but i have to separate the …

Hey all, A quick question, i've been picking my brain and browsing the net for a few hours now and still can't get any further. I have a simple C# windows form which acts as a login, but also has a form to change the password of a user. When …

Hi All, Just a quick question to see what others think is the best preactise... You have an Windows application that connects to a SQL Server DB. You use a dataset to represent the database locally. Is it better to write queries locally in your dataset, or in SQL Server …

am designig softwear with vb.net 2008 and mssql server 2005 express that can print on id card. i have the query written correctly that can retrive employee info. including the picture on a report.my question is how to set the report to automatically pick the size of the small id …

Hi, I need a little help importing an XML file into sqlserver 2008. I followed this example [url]http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx[/url] (make sure you goto the rest of the pages in the article!) , generated the schema etc., but I can't get the import to do what I need. I was able to …

SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and …

Hi guys pls help me with my problem this is for my update code [CODE]Private Sub BtnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnUpdate.Click Dim StrSQL As String = "updatePatient" classLibrary = New ConnectionLibrary classLibrary.openConnection(strConnection) 'label1.text = databasestatus If Not classLibrary.isConnectionOpen() Then Exit Sub End If classLibrary.initializeCommand(StrSQL) classLibrary.addParameter("@IPD_ID", …

I want to get the list of items from a database as a Java resultset. When I use the following SQL statement it works perfectly fine [CODE]SELECT First_Name FROM dbo.Names where First_Name LIKE 'A%';[/CODE] However when I pass it as a parameter, it does not work I have tried a …

Hi All, I really need some help. I have been asked to write a search screen for a rooms booking application. I have kept the design nice and simple so all the user has to do is enter the dates they want to book a room for and the results …

[CODE]select PREMISEADDRESS1 from PREMISE PREM inner join STATUS ST on PREM.LOCATIONID = ST.LOCATIONID inner join SUPPLIES SUP on ST.STOPID = SUP.STOPID where SUP.ITEMID [COLOR="Red"]=[/COLOR] (select count(ITEMID)[COLOR="Red"] > [/COLOR]10) from SUPPLIES) [/CODE] Hello, I do not use SQL all that often but I would like to view all of the premisesaddresses …

Hi, I am using VS 2010, SQL 2008 express and doing windows applicaion programming in vb.net.I want to write a select query(or Stored Procedure) such that the conditions mentioned under WHERE clause can be variable .like : Select * from TABLE where F1 = var1 and F2 = var2 and …

Buddy , i have problem in to combine sql with c++ plzzz any one help for this issue hurry friends i have a library project to combine it with database. hellppppppppppp meeeeeeeeeeeeeeeee.............

I need to write a query that will get the value of a previous records and add it to the current record. In detail: I have a table (Table1) that contains PolicyNum, RecordID, and SequenceID PolicyNum RecordID SequenceID 123456 456 0 123456 456 0 123456 789 1 123456 789 1 …

hi, Does anyone know how to sum fields in ms access using SQL and then place it in datagridview? I have a ms access table with fields 'Points' and 'FacultyID'. I would like to know how to sum all values on 'Points' field and place it in datagridview. Also, I …

I recently was using the BinarySearch method and I was curious about why the designers had coded the method with the following for a return value: "Return Value The zero-based index of item in the sorted List, if item is found; otherwise, a negative number that is the bitwise complement …

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.[CODE] String id= t1.getText(); int c1=Integer.parseInt(rc1.getText()); /* rc1 is a radiobutton */ statementobj.executeUpdate("Update tablename(fieldvalue) values('"+c1+"')where ID='"+id+"'"); [/CODE]

Hello, I have installed DB2 Everyplace, it installed successfully but not able to configure. Getting Error while try to configure it. The error is like this : [CODE] [exec] UPDATE DATABASE CONFIGURATION FOR DSYMSGDB USING MAXLOCKS 50 [exec] SQL1032N No start database manager command was issued. SQLSTATE=57019 [exec] SQL1032N No …

Hi, I'm working with Visual Studio 2008 Team System and SQL Server 2008. I have some RDLC files used to generate reports and the reports render correctly. Currently though only Excel and PDF export formats are available. Can anyone tell me what I need to do to enable CSV exports …

Hi guys, I've started learning SQL after spending several years in the industry. I've got a table defined ... [code] CREATE TABLE [dbo].[Computer]( [Id] [int] NOT NULL, [Name] [nchar](10) NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS …

Hi All. I have developed an application for booking meeting rooms. A user has to log in before he / she can use the system. I want the user name of that user to be shown in the form. I thaught this was easy. Please see my code below for …

Hi all, currently I am doing an online store project using an example from one of your tutorials. In the grid view is populated with data and at the below of the grid view, there is a row of empty fields populated below. After user have enter all the necessary …

I m making registration form for teachers in which teach ID is one coloum name i want message box error if id number already exist in side the table means uniqe ID e.g if id no 1 is already exist then 1 should not be added when next time user …

I have two problems 1. I have develop and Installed a project on my computer. that was work on my PC so many days. but now prject not work properly. It give me error message that [B]SQl connection not avaliable.[/B] Is their is any way to overcome this problem. Can …

How can I use SQL Statements in VB 6 with DataEnvironment. I have a DataEnvironment called Table(DataEnvironment2.Dsr) and a report named rptStudMastOne(rptStudMastOne.Dsr). I am planning to use the SQL Statement " SELECT * FROM Student WHERE StdSSN = txtStdSSN " and it will show in the report the record that …

hi i'm having a problem regarding sql deleteCommand.. can someone please help me solve this problem coz it takes a lot of time for me to figure it out.. here's my code [CODE] Private Sub btnDeleteBC_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDeleteBC.Click If MessageBox.Show("Do you really want …

I'm having trouble getting some data from a combobox. I have a series of comboboxes that populate as you make selections from the boxes. Each combobox is using data that is pulled from a SQL database into a dataset. This all works. When I get to the last box, I …

I found this great article, [url]http://www.singingeels.com/Articles/Understanding_SQL_Many_to_Many_Relationships.aspx[/url], and really helps me a lot. But there's a method that I don't know how to do especially that i find myself still a newbie. From the said article, there's a method that " the customer service rep would enter a record into the …

i find it difficult to add mssql dbs to asp.net website when i am using vs2008. here i intend working locally. please let someone help me.

Hello everybody! I'm doing my project about ASP.NET but i don't know howto create Database. Example: UserName: xxxxxxx Password: xxxxxxx Login(<<<) i want to know how the code working. i want to know where my data will be stored. for example if i am creating login control then which fields …

I tried asking this at the MSDN website and didn't get an answer at all...I was hoping someone here could help. If I indicate that SQL Server Express is to be a pre-requisite for my application, how does the installer interpret this? For example: If end user A already has …

I'm making a visitor management application and I made three tables namely tblStudent, tblEmployee and tblVolunteer in SQL. I made a table according to the categories of a visitor. Do I still need to make a tblVisitor that would be the "general" table for the three tables made? I'm really …

Hi Experts, I have a windows service running every minute and has many database operations to perform. It runs perfectly for many days, sometimes it suddenly stops and throws this exception. Later when we start to debug it, the exceptions goes off, but if we don't debug, the exception continues …

I have the following code: [code] Imports System.Data.SqlClient Public Class Main Protected WithEvents DataGridView1 As DataGridView Dim instForm2 As New Exceptions Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click Dim ssql As String = "select MAX(payrolldate) AS [payrolldate], " & _ "dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') …

[FONT=Courier New]I have been told that views in MS SQL aren’t very good to use. Let’s say that you have a view X with 2 columns Car and Color that looks like this Car Color ----- ------ Alfa Yellow Volvo Yellow Volvo Blue Ford Yellow Ford Blue If you then …

I am trying to write a trigger that updates a column called CUST_BALANCE in a table called CUSTOMER when new data is entered into another table called INVOICE. What I want to do is when new data is inserted into INVOICE it will take the value in column INV_AMOUNT and …