[microsoft:sql-server] Forum Topics

Hello, I have a big web-site(ASP.NET) with a huge data-base(MS-SQL) and i searched for a good way to use paging in my web-site. I found two good way's to do it but i have a little problem to decide which paging way to use, [U]The first way to is to …

I was create asp.net application...In that case I read value from "sql server" to "textbox" I want update that value & send it to database again at run time.. my question is my new value was ignore & again get my befour value as new value... how i update values

hi.. Im using Sql server 2005 SP3 edition & i want to store my database on the live Database server..As i try to connect to the server normally, it gives me error, so i asked the server administrator, he asked me to connect to the server using Query editor. As …

Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), …

I'm having problems trying to fill in the DataSet using SQL Server 2005. Basically I have a table in SQL Server and I want to retrieve those information and be able to display it in a web browser using DataSet. Whenever I run my code I always get error message: …

Hi everyone, I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables. [Code] SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business FROM Receipt …

this is my code: [code] $user = "sa"; $pass = ""; $host = "192.168.1.246"; $db ="payroll_hti"; $dbhandle = mssql_connect($host, $user, $pass) or die("Couldn't connect to SQL Server on $myServer"); [/code] i access from my computer with ip 192.168.1.100 this is my error report: Unable to connect to your database server …

I think I may have my problem corrected, but it occured to me that this might be a bigger problem than I originally thought. I am working on an application that is going to use a .sdf database file to store data. I noticed that while I was at work …

When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is …

I would like to update 2 fields values from one record to a set of records in the same table: I tryed this: [CODE]UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin …

I need help here anyone can give me heads up will be appreciated Hotel Room Reservation System Westin owns a chain of hotels internationally around the world. As a world renowned hotel, it is their priority to ensure the efficiency of their services. As a means to improve their services, …

i am a student...i am zero knowloedge about sql neither c#.my job is to build a database.i dont really know how i can do it and how to do it?i had tried a tutorial for c# from other website but the tutorial using sql 2005.but i had download sql 2008.i …

Hi I have a problem where dot is used in a table's column name. Say that there is a column called 101.name in a table t1. How do i reference this column in the following: select ... from table t1, table t2 where t1.101.name='test' This doesn't work because of the …

I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, …

HI i am making a window aaplication using MS Access data base........ I have three combobox of Class, section and subject on form, now i want that when user first select class ,then he selects any section corresponding to that class and then from the third combo he could select …

I have the following query in MS Access 2007 [CODE=sql]SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9 FROM Projects GROUP BY Projects.BIMinspector HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));[/CODE] How do I get it to return a result of zero if no records are found?? Any suggestions would be great. Thanks,

I want to use my data from mssql database and print it like following format which is an invoice ( bill) format... Please help me, how can i arrange my data to print like this...type is not important i can use word,excel,pdf, etc.... Thank you for your answers ;) --------------------------------------------------------------------------------------------------------------------- …

How to connect queries from SQL Server 2005 to VB.Net Windows application

I am trying to deploy a report to the Reporting Services Server but keep running up against this error: [QUOTE]An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection) Could not obtain information about Windows NT group/user …

Please tell me how to work with SQL databases in C#

Sorry if there is a topic on this somewhere - i have been searching for awhile now no dice. I'm upgrading a VB6 application to a vb.net 2008 application. problem that's driving me nuts: I fill a listview with a list of customer first & last names + number from …

sir I want to login form in asp.net with vb in 2010 version and data base connections also in sql server

hi all I want some one to help me in writing login page in c# consisting of user id text box and password text box and click button. if the login is success accepted page appears otherwise fail message appear. i will use an existing table from sql server 2005 …

I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep …

Hello I have an application in vb6 that works on MSAccess 2003. And now I have to change connection to SQL Server 2005. I changed connection string to: conn.Open "Driver={SQL Server}; Server=server; Database=Base; UID=ID; PWD=pwd" I open recorset like this Set rs = cnServer.Execute("SELECT * FROM tbl") and it is …

Hello, I've got some weird database issue, and I can't figure it out myself, so I'd like to ask for your help. My problem is the following: I've a working ASP.NET solution which relies on a MSSQL 2008 database, Express Edition. Now, I'm working on a WPF version of the …

I'm a IT student I hope I will finish my dergree soon. My day time job is auto mechanic I can fix most cars out there. I love anything that has to do with computer and IT. I'm on my second programming class right now and I love all about …

I created a personal website using the Microsoft personal website starter kit ([url]http://www.asp.net/downloads/starter-kits/personal/[/url]) then tried to run it in Visual Web Developer 2008. When I did so, I got the error msg shown below. My OS is Win XP Home and I am running Visual Web Developer in an admin …

Hello, We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this? Thanks a lot for your help.

Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER …

I've added a dataset , and a table adapter to my C# project. In this query , I get table data , then filter , then I will iterate and fill a listbox.(The dataset and tableadapter was added via DataSources boxes) [CODE=CSHARP] listBox1.Items.Clear(); ETPDataset.t_USR_UsersDataTable tbl = (new ETPDataset.t_USR_UsersDataTable()); ETPDatasetTableAdapters.t_USR_UsersTableAdapter tblAdap …

last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems] thanks

Hi Everyone, I am seeing the following error message whilst attempting to access a website that is hosted on my workstation computer (127.0.0.1) Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. C:\INETPUB\WWWROOT\INTRANET\..\connection.asp, line 12 If anybody can shed some …

Hi I have this data [code] CustBid idProduct bidAmount bidDate 1 272 165.00 2009-11-20 09:05:31.640 1 272 155.00 2009-11-20 09:05:25.480 4 272 95.00 2009-11-19 12:40:44.973 4 272 85.00 2009-11-19 12:40:40.377 1 272 85.00 2009-11-12 11:20:52.400 1 272 85.00 2009-11-12 11:20:52.400 4 272 75.00 2009-11-12 11:11:02.080 1 272 65.00 2009-11-12 11:20:20.170 …

Hi guys. Please help me with my problem. I have to upload my my image to MS SQL SERVER and i don't know what to do. I want to save it as binary data in using asp and after that, i will display it too. can you help me with …

I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I …

I am trying to write a query in my .net app and I'm having trouble pivoting the table since the columns are generated dynamically (based on a month range selected by the user) [CODE]SELECT SUM(HEALTH_MTTR) AS MTTR, SUM(HEALTH_OTR) AS OTR, SUM(HEALTH_REPEAT) AS REPEAT, SUM(HEALTH_CHRONIC) AS CHRONIC, SUM(HEALTH_TOTAL) AS TOTAL, (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) …

i need code in c# for dropdown , by selecting anyone data i need to display the data in the grid ,that data have to retrive from the sql server 2005

hai all i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table its returning wrong results. my table contains, dable datas table_1 is table name number1 text1 1 notify us the day you roll check over. 2 notify us theday you roll check . 3 notify …

i was able to successfully connect my database using connection string, i am having a hard time finding tutorials on how to add the items in a textbox. [CODE]Imports System.Data.SqlClient Public Class FrmMain Private Sub FrmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sqlconnection As New SqlConnection …

Hi I have a column named 'ExtRefNo' which of varchar datatype. The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3) My requirement is if the user search for ExtRefNo between 100 & 105, it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105. Need not include …

Hello Experts, I'm a new bie in vb.net.I completed an application in vb.net and i'm using sql server 2005 as database engine.Now I want to create a software package for this application.But the problem is that how can I include the database within this package,I'm also using a crystal report …

i have promblem when using bottom update, when i get data in textbox, this is my code string uSql; uSql = "UPDATE Material SET MaterialName='"+txNama.Text+"',MatGroupID='"+cbGroup.Text+"' WHERE MaterialID='"+txKode.Text+"'"; SqlConnection conn = new SqlConnection(connetionString); SqlCommand comand = new SqlCommand(uSql, conn); conn.Open(); comand.Parameters.Add(new SqlParameter("@MaterialName", SqlDbType.NVarChar, 50)); comand.Parameters["@MaterialName"].Value = txNama.Text; comand.Parameters.Add(new SqlParameter("@MatGroupID", SqlDbType.NVarChar, 20)); …

Pleeeeeaaaase help. If you have the answer please email me on <<mail removed>> Thanks Hi I have a VB6 system that interacts with a SQL Server database and GET's records with the following code If I_Syscont.State = adStateOpen Then I_Syscont.Close End If szSQL = "select * from syscont" szSQL = …

hey all, I'm using a form to throw info straight into a database. i know it isn't the best way but i'm new and all other implementations have confused me (i've been reading and watching tutorials for 2 weeks) but anyway i'm going to take the info straight from the …

Hello, I am new to Microsoft SQL Analysis service and am trying to create cubes. But, I understand that I first need to create fact and dimension tables. How do I create them? I kinda know the relationship between those two (Maybe not) but I just don’t know how to …

VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET

Can anyone tell me what is wrong with this code, i am trying to add information into a gridview from a sql datbase, thanks SQLSearch("SELECT * FROM engineerissues WHERE EngineerNumber = " & cmbRepTyp.Text) RS.AddNew() Dim dgvRow As New DataGridViewRow Dim dgvCell As DataGridViewCell dgvCell = New DataGridViewTextBoxCell() dgvCell.Value = …

If I build an application using BS 2008 in C# that uses an SQL database, Do I have to include SQL Express as part of the deployment package? In other words, does the user need SQL Express on his/her machine in order to use my application if my app does …

I am working on a library database module ([URL="http://www.daniweb.com/forums/thread241506.html"]See this thread[/URL]). I want to implement a custom error class. [CODE=Python] class LibraryError(Exception): def __init__(self, value): self.parameter = value def __str__(self): return repr(self.parameter) [/CODE] This class needs to handle errors such as sql execute errors, and be able to check for …