[microsoft:sql-server] Forum Topics

Hi guys i need some advise on do this system. I create a system called badge tracking system the system need to display the latest or the old information that having the badge. Inside the program have a datagrid that can direct edit into the ms sql 2000 and have …

hi all, i have a simple problem with the reporting services. i have configured the reporting server and it is working fine when i browse the reports through the report server. i have another application in which i have made use of a report server. when i try to browse …

Hi, All I encounter this problem when I am trying to insert some data manually for my project. Example: LA-R1, LA-R2 , LA-R5 , LA-R8 ….. [The Rs are Already in the Original Data] Simply put, my Goal is to fill in the gaps between the Rs. So, the result …

hai friends, I dont know how to create database dynamically in vb.net.(if a button is clicked 4 databases in access or sql has to be created).similarly by clicking the delete button the specified database should be deleted.can you help me out with the coding.

...hope some body can help me resolve the problem....where i have to update a particular data , the datas are retreived from the db using a dropdownlist,selected data are updated inside a textbox........... .....where there are constraints set by validators for space and !^#$%&*^----charaecters: My problm is data is not …

Hi guys if i use the asp.net to write the code but i didnt involve to connect to the sql database what should i write in the web.config under the connection string??

Hi, i got a problem that is i create a program based on pervious program that do from others. Now i using the asp.net to create and the sql express 2005 to do it. So the question do anyone know how to open the mdf(master database file) file. I try …

Hi guys do anyone know how to change the code line from sql express to ms sql 2000. Below is my code help me to check it? web.config [CODE]<?xml version="1.0"?> <!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings …

Hai, We are working in a project which handles lots of data. How many tables can we have in sql server 2000 so that it can be managed efficiently.Is there any rule for separating the tables. We store information like candidate details,interview process.... Thanking in advance

i have a problem in dropdown :suppose i select id from dropdown then i want name of the employee is displayed matched with that id is displayed in textbox : i have use the following code con = New SqlConnection(constr) adpt = New SqlDataAdapter("select * from reg where f_name='" + …

The issue isn't how to use sp_send_dbmail, because i use it everywhere, for both querys and system mails. But i have one problem, and that is how do you send a mail with HTML and TEXT format? You probably wonder why i need this because all the mail readers now …

I am trying to create Update trigger which should be invoked only if the ReturnedOn column is clicked. I have used the following code-snippet but it generates the error: CODING: [code] create TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn) begin IF EXISTS(SELECT 1 FROM …

Hi all, I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id. The values for this column should start with PT and contain the serial numbers in ascending order. Eg. PT001 PT002 PT003 I want to …

Ok fellows. I've tried EVERYTHING!! System OS: Windows Vista SP2 IIS: version 7 MSSQL: 2008 express ASPX: .NET 3.5 framework my global.asax has sqlcachedependency.start and stop at application start and end i have enabled sqlnotifications on the database. The database has a table for tracking the changes and the track …

(And before anyone points it out; I know they're not calling it DTS any more!) My problem is as follows: Whenever I go to import a flat file using the DTS import it's setting the default column sizes to be ludicrously small (50 characters) and it doesn't subsequently matter HOW …

Hi, I want to display a text, getting from database, into a DropdownList using text property. My Code:: [code=ASP.NET]SqlDataReader drd; if (drd.Read()) { drpcompname.Text = drd.GetValue(0).ToString(); }[/code] But It Display an error:: 'drpcompname' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter …

Hey All, I am using MSSQL -2005 with VB6. I have created a master table tblCompany and detail Table tblDetail having foreign key relationship. When i try to insert a value within a TRANSACTION I am getting Error No. -2147217873 at Line No. 0 (The INSERT statement conflicted with the …

hi i am working in vb.net 2005 and sql 2005. i have developed backup and restore forms. in the backup form if i backup database, i need to list server dir and folders but i am working in client system. how to list server dir list? in my system connected …

Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a way to detect what column, or what value that is to large? I’m thinking about splitting up the INSERT string, …

I have a table name Project(id,projectid,date) ----------------------------------------------------------- id | projectid | date 1 | 9 | 2009-02-03 2 | 9 | 2009-03-04 3 | 9 | 2009-04-05 i need a query which will return me the recent date of that project id. query will return: 3 | 9| 2009-04-05

hi all, i m working on a component for MIS department. i need that when i run my component it should ask for: from where u want to retrieve ur data i.e. from Oracle/SQL Server/MS-Access. when i select one of these options for ex. if i select Oracle or SQL …

I have a datagridview that tracks when employees clock in and out. I used the datetime data type in sql but I dont want the year to display. How would i go about doing this? Do i have to modify my select statement, or can I do it with vb …

hi guys ; i have a code for read txt and later write to sql database but its not working :( can you help me _? Best regards [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using System.Data.SqlClient; using Utilities; namespace …

Hello, i have face problem when i need to retrieve data from database (SQL 2000). Below my table : Column A | Column B 1 a 1 b 2 c 2 d i need the result is : Column A | Column B 1 a b 2 c d Can …

Hy, you guys! I'm trying to implement in a trigger write by-me error handling with TRY...CATCH, but I'm loosing a lot of time without success. :'( Here there's a simple code write for test: [CODE]ALTER TRIGGER [dbo].[INS_AlarmsEvents] ON [dbo].[TEST] AFTER INSERT, UPDATE AS BEGIN TRY RAISERROR (N'This is message %s …

I'd like to make a querry prom 2 tables that have the same information. Tables have only one column named "fish". I'd like to create a querry that will show me every combination from first table with the second table (in 2 separate columns). For example: My table contains: A,B,C. …

Halo, i here wanna know how to create a report in microsoft visual studio team system 2008 from a microsoft sql server management studio 2008. i had watch the video from msdn that teach how to create report but not work on me. [U][url]http://msdn.microsoft.com/en-us/vcsharp/dd638031.aspx[/url] [/U] [COLOR="Red"]GUIDE ME PLEASE[/COLOR]

Hi guy i need some help on checking this table structure is right or wrong. PLEASE CORRECT id i'm wrong [U]tblBadgeNew[/U] iBadgeID (Foreign Key) iEmpID (auto number) iActive iRecycleStatus iIssueDate [U]tblBadgeOld[/U] iBadgeID (auto number) iEmpID (auto number) iActive iRecycleStatus iIssueDate This two table will send data to the data grid …

HI, I have in my database 50+ tables and getting slowly lost because it's looks like a bit messy up because of the long list in the Object Explorer (SQL Server Management Studio). Does anybody know a way how to organize this tables in subfolders like how the "system tables" …

Hi all, I have created the Trigger for UPDATING to be invoked when Returnedon column is updated using the following code snnipet. [Code] CREATE TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn)) begin begin tran update nur set nur.NumberOfBooksIssued = nur.NumberOfBooksIssued -1 from NewUserRegister nur …

Hi, I am trying to connect to sql server by using ADO to insert a record via stored procedure. I keep on encountering this error message (Source: Microsoft OLE DB Provider for SQL Server Description: The precision is invalid.)I had read on several blogs and forums and it said that …

Hi all, I am creating a trigger which should be triggered on insert to BOOKISSUEDETAILS table. I want to alter the table LIBRARYBOOKDETAILS table only if the Inventory column value is greater than 1. Initially I have created the trigger in the following way. But now I want to alter …

Hi evrybody, My sql SP takes around two to three minutes which is quite long time to execute the SP select data from three tables publicity(29000 row) publicitysubject(29000 row) & lookuptable(50 rows) all three tables have clustered index How can i reduce the time [code] USE [ReadWorthyPublication] GO /****** Object: …

[code=vb]I'm new in visual basic.net 2008. I just want to know if what is the best method for database connection (access and sql server) on a client/server application. Do I need to use a class,business objects or something? thanks very much! a simple example is very much appreciated. tgcngb+[/code]

I have been struggling over this for about a week now. I am trying to duplicate a ranking system for a client so that it can be accessed privately and players can have a different rating from publicly. I have added new field to encompass my new information. Everything works …

HI All, Another Question: I have created another program that queries the StockTracker database for all users and the stocks held by each user. The program compiles, but at run-time i get the error: [COLOR="Red"]"Exception in thread 'main' java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn<JdbcOdbcResultSet.java:1833> at sun.jdbc.odbc.JdbcOdbcResultSet.getString<JdbcOdbcResultSet.java:395> at StockByUser.main<StockByUser.java:43>"[/COLOR] I am …

Hi, I have a dataset build at design time (vs 2008) with several tables of my DB (MSSQL 2005). I have a DataTable with its tableadapter... I need that the TableAdapter.Update function returns the key updated (always will be a single row updated at the time). I know, I passed …

I has a question i create a form using vb but i dun know how to write the code for the it. So all the data i fill in the form will show it the MS SQL. So what to write the code and anyone have a good tutorial for …

Do anyone know how to use the vb to retrieval data from MS SQL ? Do anyone have a good tutorial about it can post it??

I have written a complex stored procedure which have a log table which keeps the track of success/failure of each and every query in the stored procedure. If there is any error in any of the query entire transaction is rollback . while rollingback, data in log table is also …

I'm new in visual basic.net 2008. I just want to know if what is the best method for database connection (access and sql server) on a client/server application. Do I need to use a class,business objects or something? thanks very much! a simple example is very much appreciated. tgcngb+

Hello, I want some asp.net projects with source code for reference.My database is SQL Server 2005. Please help me out.

Hi All, I have data like the following: Stuff Sizes ID pen s1 100001 pen s2 100002 pen s3 100003 pencil s1 100001 pencil s3 100004 pencil s5 100007 pencil s2 100006 ruler s7 100005 ruler s8 100008 .. .. where each size is coordinate with a unique ID number; …

Hi, thought it time i stopped lurking :) Im currently building a project in .net and im having issues with check boxes. On one form i have a few text boxes for username, password, initials. Then check boxes to tick (these will be to allow/deny access to various forms later) …

Hello, please help me in such a stiuation I have a stored procedure that insert a new record after checking that this record does not exist.... TODO: I need to lock the row after the select statment executed on a specific row to ensure that no changes will occure between …

Hello everybody, i'm beginner. I have a problem: I have this code: [code]<cc1:Accordion ID="Accordion2" runat="server" SelectedIndex="0" FadeTransitions="true" FramesPerSecond="40" TransitionDuration="250" AutoSize="None" D[B]ataSourceID="SqlDataSource1"[/B] ContentCssClass="Content" HeaderCssClass="HEADER"> ... ... </cc1:Accordion>[/code] The code inside of Accordion is executed for each row of SqlDataSource1. I'd like if it is possible get actually row of SqlDataSource1 that …

Hi, I hope some-one can help. I am trying to create a mobile application that uses merge replication. I am having problems synchronising CE db to coporate db. I have had major trouble setting up my laptop for this, and have been unable to fix my final error. What I'm …

Hi there, im new to VB and am trying to work out how i can check that my database connection info is correct before i connect. error example with incorrect info: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or …

[U]users table[/U] userid PK + autoincrement name surname i wrote a procedure [ICODE]ALTER PROCEDURE insertUser @userid int, @name varchar(50), @surname varchar(50), AS SET NOCOUNT ON insert into users (userid,name,surname) values (@userid,@name,@surname,)[/ICODE] in aspx file i write [ICODE] cmd.Parameters.AddWithValue("@userid", ????????); cmd.Parameters.AddWithValue("@name", TextBox2.Text); cmd.Parameters.AddWithValue("@surname", TextBox3.Text);[/ICODE] what can i assign for userid column …

i have multiple checkboxes on my form.i am trying to add them with stored procedure but it gives me [I]Procedure or function konut_ekle has too many arguments specified [/I] [CODE] protected void Button1_Click1(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString); SqlCommand cmd; con.Open(); string cmdstr = "konut_ekle"; cmd …