[microsoft:sql-server] Forum Topics

hey everyone i have a problem with attaching sql server database to an installer file. i dont know how to do it. i tried searching the internet but i cant understand anything please help me im a noob hahaha anyway tnx in advance

Iam doing a sales and purchase management proj ...i need to implement a feature in which the stock updates like if it is out of stock it should notify me before a time period like 7 days or so///the front end is vb 6.0 and back end is sql server …

Hi guys; I have a table of books in my DB and each page has a different serial no following each other eg. Page 9 has serial 005065 and 10 has 005066. In my table it only gives me a range of serials as per the book, this is how …

Hey guys, When I bind my data to the GridView, it populates the GridView with the correct number of rows from the database, but the rows are empty. Do you know how I can get the data to appear in these rows? Please look at the attached picture to get …

Hi, I'm new to sqlserver so i has a lot of confuse in working with the user defined types and my C# app , i mean that the problem is how to pass the variables from my c# app to a stored procedure or function in sqlserver , if some …

i get an "This SqlTransaction has completed; it is no longer usable." error everytime i run my code: the main code [CODE=vb.net] If DBOpen() = True Then Try 'begin transaction BeginTranscation("Clearance") 'receipt CallSP("InsertReceipt") InsertParam("@ORNo", Trim(txtOR.Text)) InsertParam("@FACode", "***") InsertParam("@Amount", txtAmount.Text) InsertParam("@Nature", "Business Clearance") InsertParam("@PaymentType", "Cash") InsertParam("@DateIssued", dateDocIssue.Text) ExecSP() 'document CallSP("InsertDocument") InsertParam("@PersonID", …

Hi all, I have a VS2008 winform application that connects to an Access 2007 database. However, I have been given the task of converting it so that it connects to SQL Server 2005 instead. (I've already migrated the data + database over without too many problems). The question is... is …

using this code.stored procedure [code=text] @_Empno nvarchar(8),@_Surname nvarchar(50), @_Firstname nvarchar(50), @_Middlenamenvarchar(50),@_PermanentAdd nvarchar(Max), @_PresentAdd nvarchar(Max), @_Identity ouput int AS SET NOCOUNT ON; INSERT INTO TblEmpPersonal ( Empno, Surname, Firstname, Middlename, PermanentAdd) values(INSERT INTO TblEmpPersonal ( @_Empno, @_Surname, @_Firstname, @_Middlename, @_PermanentAdd) set @_Identity = (Select cast(scope_identity() as int) as empID) [/code] here …

hi guys, i have a situation let say a customer orders 3 items item A worth 300 item B worth 100 item C worth 500 He paid in full for items A,B and he paid a partial payment of 250 for item C now I have a receipt for full …

Hi, is there a way how to (in transact sql) catch output from stored procedure which returns set (2 and more) of tables and move through it ??? thanks!

Hi, I need to create a PHP script which can read an MS SQL database in order to authenticate users onto my website. Once they're authenticated, they get sent to their own personal log in page which allows them access to certain areas of the website. This needs to be …

Hi, I am create one application using c# and Sql server. suppose database stored on one machine how to access this database to another machine, i.e database which is created using sql server stored on one machine and application run on another machine how to access this database which are …

good day guys, I have an order table and some stuffs, and the user can cancel an order. my question is: 1.] what is the best implementation of canceling an order in a database? Im sure I must create a table for canceled order or something right? 2.]Is it appropriate …

Hello, In this situation, my application can connect to the MSSQL server in one of two ways; via a direct TCP/IP connection (WAN) (IP's filtered using RRAS in 2003 Server) or via a VPN connection. The application will first try to open the connection using the WAN connection string and …

I am trying to get 'SERVERPROPERTY ('edition') using ADODB. I have a connection to a database but I keep getting Error 80040e14 and unexpected token SERVERPROPERTY was found following BEGIN-OF-STATEMENT. Any ideas how to fix this. Thanks Joey

Hi all I'm having some trouble with EF and SQL 2008 default values. Firstly, I have a column called 'CreatedDate' and the default value in SQL Server is getdate(). If I add a field in SQL server this works fine. I also have a column called Guid and the default …

How can I connect to sql server via network by using vb.net.

Hi all,, you can call me bie... now i am studying aplication web based using c# and sql server.... i hope i can find anything that i need in here.. thanks..

I'm trying to a open a connection to a local database and no matter what I try it just won't work (I'm pretty new to SQL Server and VB for that matter) I tried using 'sqlconnection' with different connection strings but none of them worked or gave me any useful …

Hi all I am using sqldatareader to read data from sqldatabase. The data is being shown on web forms with tabcontainer and tabs. The scenario is I have three rows of data for a client.I want to read row by row data on a button click event.I used while loop …

I have to install Visual Studio 6 in XP Mode on Windows 7 and Visual Studio 2008 on Windows 7. Both use SQLServer 2005. Which do I install the SQLServer 2005, on the Windows 7 or XP Mode or do I need to do two installs?

[code] for(int p=0; p<dsForumList; p++) { dsForumList="select ForumName from KF_Fourms"; { if(dsForumList.Tables.Count > 0) { if (dsForumList.Tables[0].Rows.Count > { for (int i = 0; i < dsForumList.Tables[0].Rows.Count; i++) { strForumName = Convert.ToString(dsForumList.Tables[0].Rows[i]["ForumName"]); // strForumName =Convert.ToString (dsForumList .Tables [0].Rows[i]["ForumName"]); for (int j = 0; j < dsCategoryList.Tables[0].Rows.Count; j++) { //intCategoryID = …

I don't have any experiance in this part so I really need someone's help to get start. I have setup for my application in VB.NET...what i need to do (want to do) is next... -create/restore a database that I use for that application (I have database in MSSQL). Maybe I …

Im trying to create a report that only includes records that was created between to [B]Date Variables[/B], [B]dateTo[/B] and [B]dateFrom[/B]. There are three combo boxes used to get the values for the two dates. Here's the code I didn't include the select case for the month(in string) to be converted …

I wrote a query yesterday and it ran fine. Today i inserted a new record and it has broken my query. Can anyone help me figure out why? Query: [CODE] WITH temp_orgChart (KitID, PartID, Quantity, iteration) AS ( SELECT KitID, PartID, Quantity, 0 FROM ItemParts WHERE KitID = 200185 UNION …

The above code has been runtime Error display. Variable 'objReader' is used before it has been assigned a value. A null reference Exception could result at runtime. pls solve this error. Error Line for: objReader.Close()[code]Protected Sub Login(ByVal sender As Object, ByVal e As System.EventArgs) Dim intID As Integer = 0 …

plz hepl me ...... table_1 Name_____Date_________Ptype Keadr____22/2/2010____P Anup_____22/2/2010____P Deepak___22/2/2010____A Keadr____23/2/2010____P Anup_____23/2/2010____L Deepak___23/2/2010____A Keadr____24/2/2010____P Anup_____24/2/2010____P Deepak___24/2/2010____P I want To convert this table as Name_____22/2/2010____23/2/2010_____24/2/2010 Kedar____P____________P_____________P Anup_____P____________L_____________P Deepak___A____________A_____________P my query select * from table_1 PIVOT(MAX(Ptype)FOR[Date]IN([22/2/2010],[23/2/2010],[24/2/2010]))AS p i got result Name_____22/2/2010______23/2/2010______24/2/2010 Kedar Anup Deepak didnt get values in 22/2 ,23/2,24/3 col

Hi, how to import/include Spatial Data format (Geometry and Geography) in Sql Server 2008 ?

Can anyone help me about how to post image and sql data. [ATTACH]13786[/ATTACH] Check the attached image, it is from jaiku.com. [you can see image of the user and data which is posted by user] i have one textbox(multiline mode enabled), and a button. when the user input the data …

hy, i have 2 database. DB1 & DB2. i create SP in DB1. in the SP, i want to access table "TBL" in DB2. how can i create that SP?? [CODE] CREATE PROCEDURE test AS BEGIN ?????????? END; [/CODE] Thx,

hi there......... i am using MS SQL i have made a database in MS SQL now i want to export to another computer (pc) ,,,,,, please help me out with this......... thanks

can anyone explain to me i want to create for search books i created books table, authors and title_authors table.. with MS SQL but i cann't relation with them and how to doing in asp.net with C# for search books!! please explain me i want to leaning!! thanks you so …

Less than a year after launching its high performance computing strategy, Microsoft finds its [URL= http://www.microsoft.com/hpc/] HPC Server 2008[/URL] near the top of the heap. The Windows Server 2008 derivative placed 23rd on a list of the 500 top-performing supercomputers in the world, as measured by the [URL= http://www.ncsa.uiuc.edu/] National …

Hi all, I use gridview to display the data in Item table. The edit and delete button works fine in the gridview initially. When I search for particular records and display in the grid the edit and delete button does not work. [CODE] <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" …

I dont understand what im doing wrong! [CODE]public partial class Delete : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnSubmit_Click(object sender, ImageClickEventArgs e) { SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand comm = new SqlCommand("Delete into [Staff] (Staff_Number, Login_Password, Phone_Num) VALUES (@Staff_Number, @Login_Password, @Phone_Num)", conn); comm.Parameters.Remove("@Staff_Number", …

Hi , I want to create user defined data types in MS SQL 2008, So when I start MS SQL Server Management Studio -> Database here 'Adventure Work' is not appearing. ( I am referring this -http://www.mssqltips.com/tip.asp?tip=1628) how to enable that?:?: or is their any another way to declare user …

Hello Friends I wanted to make a same change in over 300 SQL scripts. Is there a way to automate this? Thanks

Hi All, In my jsp page, I am getting the data from Ms-sql for 3 combos.first 2 combos are independent, like course,location. either i can select course or location in 3rd combo i need to display the name of student. I was not able to pass the two combo values …

Hi, i am doing with deleting row permenately from database currently,but the problem i face right is that i can delete row from datagridview only, but the data inside database remains unchange.I want to delete a row which i selected permenately when i click a delete button . Here is …

[B]Stored Procedure "InsertUser"[/B] [code] ALTER procedure [dbo].[InsertUser] ( @username as varchar(50), @email as varchar(50), @password as varchar(20) ) as if(not exists(select email from dataUser where email=@email)) begin declare @lastnumber as integer set @lastnumber =0 select top 1@lastnumber =cast(substring(user_id,8,9) as integer) from dataUser order by user_id desc --insert insert into dataUser …

I have created a windows application in c# using sql server 2005 as back end , i completed my project , now i want to create an MSI package , i know how to create a sample MSI or EXE application in Visual studio 2008 , but i dont know …

Hi, My project modules are organized in such a way that I have to maintain following Database structure. I've 5 schemas, each containing 20 to 50 tables. Each schema is accosiated with one module of the project. All the tables that are used within more than one modules are kept …

Hi, My project modules are organized in such a way that I have to maintain following Database structure. I've 5 schemas, each containing 20 to 50 tables. Each schema is accosiated with one module of the project. All the tables that are used within more than one modules are kept …

Hi guys; I need your assistance. I am extracting some info from my database and I need difference between two fields of money values. Lets call the fields as Field1,Field2,& Field3. Field1 = Current Balance Field2 = Starting Balance Field3 = Field1 - Field2 From my query, I get Field3 …

This is a continuation of the [url="http://www.daniweb.com/tutorials/tutorial19303.html"]Updated: ASP.NET Login Page Tutorial[/url]. This tutorial will demonstrate how to create a registration page for new users to your site. This registration page will utilize the same principles used in the Login Page Tutorial, so this should be no more difficult to do …

Hi All, Is it possible to take Backup of SQL Server Compact database (i.e. *.sdf) and Restore the same. Regards.

[b]Split from - [url]http://www.daniweb.com/forums/thread94883.html[/url] [/b] hi i have the button click event [code] protected void Button1_Click(object sender, EventArgs e) { SqlConnection myConn = new SqlConnection(); myConn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Postmyadd\App_Data\postmyad.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; myConn.Open(); string strqry = "Insert into advertisements values (" + TextBox1.Text +")"; SqlCommand myCom = new SqlCommand(strqry, myConn); …

Hi There; I have an application that work in multi-user environment. Would like to know what are the possible way to update the datagridview in other user workstation once someone did the changes? For instance, when user A had done some Add/Update/delete for a record, datagridview that work by user …

hi i m mahesh i want to knw about the project on media player[QUOTE=mattybennett;660156]Hi all, Ok - there's nothing like a BIG challenge to start off my exploration into programming. Given that I'm a complete newbie with more build errors than a builder having a bad day (bad pun!), what …

Hi,I want to generate unique ID in the database that has the combination of characters and digits. eg. ab111 and next should be ab112 ,ab113 and so on. Can anybody help me?