[microsoft:sql-server] Forum Topics

Hi people I need some help here. Here is the CODE : [B]for Form1:[/B] [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.SqlClient; namespace practice { public partial class Form1 : Form { Form2 obj; public Form1() { InitializeComponent(); } …

Hi Friends, i ve a doubt in sql.. want to display all dates between 2 dates.. for example if our input are 9/2/2011 and 12/2/2011 na, the output are 10/2/2011 11/2/2011 .. i need query for this..can u clear my doubts..

I have a table that contains ID, lastname and firstname of a person. How to make my stored procedure handle the where conditions using only stored procedure. SELECT * FROM person where lastname = @lastname SELECT * FROM person where firstname = @firstname SELECT * FROM person where ID = …

Hi, For the benefit of newbies here is a list of all the topics you need to know to program a connection using VB to a SQL Server database and develop a database software. 1. Network Operating system. 2. SQL Server 2000 Installation on a Client / Server Network. 3. …

I was able to insert a single row from datagrid but when i try to select 2 or more rows its just inserting the first row. How will I save multiple rows in the sql table, could somebody help me. Here's my code... For ex. 3 products in one OR …

Hello All, I am writing my self a simple little address book application and I seem to be having some trouble with updating the dataset. I have written the code and I cant see for any reason why it shouldnt work, but during run time, when I delete an entry …

Hi, It appears that the code tags in the MSSQL forum aren't working today. Example: [URL="http://www.daniweb.com/forums/thread348193.html"]this thread[/URL].

G'day Folks. This is a general question and not a request for code. I have a client with many DTS packages on their sql server 2000. Has anyone had to migrate these buggers to sql server 2005 or 2008? Was it difficult? - After substantial googling/searching I'm not sure I …

I'm having difficulty to implement a select query for my database using datagridview to bind to and textbox for searching a particular value in my table. I have this stored procedure [CODE]CREATE PROCEDURE usp_searchvisitor @keyword nvarchar(20) AS SELECT * FROM tblVisitor WHERE lastName = @keyword OR firstName = @keyword OR …

MyTable: People who moved from Blah City, Blah State: Name Location Date Kids Jack LA 02/05/1999 0 Cindy Chicago 12/15/2005 2 Randy LA 06/19/2003 3 Jason Seattle 04/06/2002 0 1. Who moved to LA? [CODE] SELECT Name, Location FROM MyTable ORDER BY Location; [/CODE] Expected result: LA Jack, Randy What …

Hi Everyone, I have a table that has a 2 column primary key. I set up the key where the 2nd column is an identity column. When I ran my VB application I discovered the ID (2nd column) did not increment the correct way. I was hoping it would increment …

Hi! I need to be able to change the location of the database at runtime through a menu in my program. My question is how to best achieve this. If for example the ip to the server change, the user need to be able to update the database path; i.e. …

While using an insert query for a certain table, can I used a select statement to know whether there's an already existing value in the stored procedure using a return value where insert occurs? Or do I need to separate a procedure? I don't know much of return values.

Hello, I'm doing my final project and I'm thinking about creating an application that is user based.. A user can login (See their score etc) and also register if they haven't got an account yet.. I'm thinking about doing this using SQL and I haven't really done it before, other …

I've constructed an inventory program that relies on a database for information. Previously, I've used Access 2007, because it is easy and n00b friendly. Unfortunately, I'm not so sure Access can handle the requirements (Multiple simultaneous users over a LAN connection). So I switched to SQL Server 2005 Express. And …

USE [DIAMDBF] GO /****** Object: StoredProcedure [dbo].[STOCKREPORT] Script Date: 01/21/2011 11:32:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[JEWELLSTOCKREPORT] @SELDBNM SYSNAME, @FILENO1 nvarchar(7), @FROMCODE nvarchar(20), @TOCODE nvarchar(20), @START nvarchar(12), @LAST nvarchar(12), @DATE1 nvarchar(12), @DATE2 nvarchar(12), @DATEFORMAT varchar(12), @GROUPCODE char(10), @FROMLOT nvarchar(10), @TOLOT nvarchar(10) AS Declare @execstring …

I want to convert a kind of a large MSSQL table to text -- ideally CSV. One crude way would be to use SQL Developer to do a SELECT * and do a copy-and-paste. But there must be a more precise and efficient way of doing this. Perhaps SQL Developer …

I have 3 tables; Group, MemberOfGroup and Graduates. GroupID is a primary key for Group and MatricNo is a primary key for Graduates. Both GroupID and MatricNo are composite key for MemberOfGroup. I want to show the group lists according to member size. Below is my sql. [CODE]Select g.GroupName, count(m.MatricNo) …

Hi, I have recently finished a windows desktop application for a client that connects to a sql server database. Throughout development while the server instance was on my local machine the application and server communicated fine with the connection string below [CODE] <add name="myString" connectionString="Data Source=myServerName;Initial Catalog=&quot;myDbName&quot;;Integrated Security=True" providerName="System.Data.SqlClient" /> …

Hello, I'm newbie to VB.Net and thus I need an urgent help so doing this posting. I'm currently working on a project to track officers attendance time. I have several table in SQL backend. The 2 obvious tables are tblStaff which keeps all the staff's records, and the tblAttendance which …

Evening all, I have created a program that reads a Data Base contents, displays the information, prompts the user to press enter, then in theory they should enter an account number and that specific accounts details be deleted from the data base. Finally the contents of the data base should …

Here is a sample of my table: ID Name Codes 1 John D S12, S13, S89 1 John D S98, T12 2 Joe D X27, S28 3 Bob S F12, F13, X43 3 Bob S S44, X38, S90 4 Steve F D25 I want a query that will return the …

Hi, I tried installing MS SQL server 2008 on win 7 Ultimate x86. It was slipstreamed installation with SQL SP1. I got 7 errors during installation. All of them are showing almost similar messages (but different event ids)except the 2nd error (which was about failure to open some registry). The …

I have a function that imports an Excel sheet into a SQL database. This function works except ONE line. [CODE] If sheetContent.Range("A" & exRow).Value2.ToString.Length < 1 Then Exit For End If[/CODE] The rest of this function works great, and it uses lines of code that are VERY similar to that …

PLEASE I HAVE OVER TEN CLIENT COMPUTERS. AM DESIGNING AN VB.NET WITH MSSQL SERVER 2005 EXPRESS APPLICATION THAT THE CLIENT CAN CONNECT TO THE DATABASE ON A ON COMPUTER HOW DO I DO THAT.# ie vb.net + sql server network application

I have this code in design's code behind [CODE]int id; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_addvisitor"; cmd.Connection = con; cmd.Parameters.Add("visitorname", SqlDbType.NVarChar).Value = textBox1.Text; SqlParameter bookidparam = new SqlParameter("@visitorid", SqlDbType.Int); bookidparam.Direction = ParameterDirection.Output; cmd.Parameters.Add(bookidparam); id = Convert.ToInt32(bookidparam.Value); con.Open(); cmd.ExecuteNonQuery(); con.Close(); for (int i = 0; i < checkedListBox1.Items.Count; i++) { if …

How to save the checked items on checkedlistbox in sql database? I searched through the web and found out that for loop or foreach is necessary. Could someone give me a sample code and an explanation. I really need to do this, but can't find a good tutorial for this.

Dear sir, I need a help. am having problem coding in vb.net. I have created a field which automatically in sql server. I want a code in vb.net so that user the text on the get focus, the automber would display the current no on the form. This autonumber is …

hi, i think there is a problem with my code below....it insert the data more than 1 record (data redundancy) in the server database....i think there is a problem at the place i highlight with red.... can any1 assist me on this.... [CODE] If Not Update_ServerPOS() Then Update_TempPOS() End If[/CODE] …

i try to create an application that can sent the value from vb.net to SQL database.. the problem is i dont know how....i created the interface, just a simple one like inserting name, D.O.B, hobbies & phone nmber(all this using text area)...and a submit button... pleaseeeeee........... help me :'( -im …

Hi friends i am making project in c# and i want to retrieve/add/update/delete data from the database, so please provide me with sample codes. Note : am using VS C# 2010 and back end is MS SQL 2008. I did google search but its confusing me.

This is my app.config [CODE]<?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="radicalGuard" value="Data Source = MICHAEL-PC\SQLEXPRESS; Initial Catalog = radicalGuardDB; Integrated Security = True" /> </appSettings> </configuration>[/CODE] And this is my connection string [CODE]SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["radicalGuard"].ToString());[/CODE] Whenever I try to debug, it says "object reference not set to …

Hi i was installing sql 2000 on win 7 but it gave a message something like "sql have compatibility issues with this version of windows". I want to use sql 2000 with vs2005. Is it possible to run sql server 2000 on win 7? If yes how can i run …

I am asim, hi, i have uploaded my site first time and but unfortunately i got errors in web.config file that is as below: [CODE]<?xml version="1.0"?> <!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration> <connectionStrings> <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" …

I need to get codes for ADD DELETE SEARCH (WHICH GOES TO ANOTHER FORM WHEN CLICKED) UPDATE (WHICH UPDATE AND SAVES RESULTS) [ATTACH]19289[/ATTACH] just the code for that thank you! :) it's from a SQL Database;

when saving the "conversion failed when converting datetime from character string" is displayed. Please help Private Sub BtnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSave.Click Try Dim cn As New SqlConnection(ConnectionString) cn.Open() put = "insert into NewAccount(Account_no,Surname,First_Name,sex,Date_Applied,Date_Birth,Contact_no,Contact_Address,Acco unt_type,Branch_ID)values('" & Me.TxtAddress.Text & "','" & Me.txtAccount_No.Text & "','" & Me.txtSurname.Text …

I am using COLDFUSION . And using coldfusion i am inserting a table using URLEncode function. For instance, the word 'Registration Fee' will be inserted into a table like 'Registration%20Fee' after encoding using URLEncode function in coldfusion.But I need to write a mssql statement to decode the word and want …

hi there, i have a question in C# files. i have a client application which is created in visual studio C#. and from that i copy a file to a folder in the server computer folder. so when i am trying to display it ot the user i user System.Diagnostic.Prcess.Start(PathToTheFileInTheServer) …

Hi I am using IIS 5.1 and im trying to host my web site on IIS. But it generates error while opening database..im using MS SQL server 2005. The error is : "Cannot open database "EXAM" requested by the login. The login failed. Login failed for user 'ABC-0C2DBCA594D\ASPNET'." Please help …

hello Hope u all be fine Plz help i want to create a single database host in a server that is access by both ASP.net website and access remotely by windows mobile Application. The user want to easily update,create,delete their record through mobile application and update,create,delete their record through Asp.net …

Hello . I have Gridview which display a table that contain a Foreign Key , and because of Foreign Key , The Automatic Generate Delete Link Can't be work correctly , because SqlQuery not one Table ,... So i must Type a code in Row Delete Event , if my …

Hi Everyone! I am a beginner at VB. I have been a systems admin for some time and my new employers are forcing my hand into programming. I am currently Trying to write custom software that interfaces with our Advantage Database. I have the data source and connection opening fine. …

Hello, I am having problem in calling Stored Procedure second time while remaining on the Entry Form. I have attached a word file having screen shots and code snippet Thanks

Hi all, (Firstly please note I am a beginner programmer!). I have the following code where I am trying to print the data base entries, then the user press the space bar to add another entry, followed by the data base contents being printed again. Any pointers in the right …

I'm using Visual Studio 2010 C++ Express and connecting via ODBC to MS SQL Server 2008 R2 Express. My question is: Is there any way I can pass some type of pointer into SqlGetData instead of an actual data type, then stuff that reference into a void pointer for the …

I have a C#.NET Website that stores status logs from hardware installations. A report is stored in a report_info table and it's data entries are stored in report_data. I first insert into the report_info table and retrieve the insert ID using: [CODE] cmd.CommandText = "SELECT @@IDENTITY"; // Get the last …

Hii plz anyone share me the link where can i download Complete video of SSRS

Hello,I'm having problem with SQL INSERT statement In Europe we use comma instead dot for decimal number. But when I try to insert it with SQL statement I get this error: "Number of query values and destination fields are not the same." Can anyone help me with this? Thanks

I have a datagridview that is being populated by a dataset using an SQL table. How can I implement a backup and restore? Would I use the SQL select into statement?

guys, how to check data if it is already in the database? i am using sql server.. thanks