[microsoft:sql-server] Forum Topics

Hello all. I wasn't sure if I should post this here or under DB? I'm a PHP user that is new to C#/ASP.NET/MS SQL. I have a table with rows of string values (not sure why they were made strings as they are numbers but thats what they are). I …

Ok; I have a table with a list of products, for example ProductID Name Price 1 Red 2 2 Blue 1 3 Green 3 4 Orange 3 5 White 4 6 Blue 5 I want to give people the option of "featuring" products, and also to be able to control …

Hi all, I am trying to update Table[land] with the following data (simplified): [u]Scenarios:[/u] Num_1 like [A-Z], Num_1_Index like [1-9] Num_2 like [A-Z], Num_2_Index like [1-9] ..... Num_26 = [A-Z], Num_26_Index = [1-9] --------------------------------------------- Update land set Num_1_Index = case when Num_1 like 'A' then '1' when Num_1 like 'B' …

I am trying to figure out how to set multiple text boxes/labels with one sql query. I dont need help connecting to the database or anything like that I just need to know how I can write one query to and set multiple text boxes with that one query. here …

Need help can anyone give some example of the code to retrieval data from Microsoft sql to the vb datagrid

Hi, I want to use VB.NET to connect to sql server remotely and input and receive data from the server. Can anyone help me to do it? I really appreciate code example. Thank you very much!!

I am currently developing an Access 2000 database for the purchasing department at work, and I'm learning as I go. The tables are all set up. I'm trying to create forms to update the tables, but I've run into a few problems. A simple example is the Parts table. It …

Hi. I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause in both queries results are equal. I am using the same table so I do …

Hi everyone, I am working on a project where i have encounter such problems: Data samples: LA-1-2, LA-1-2-33, LA-1-22-333-4444, LA-2-3, LA-12-34, LA-123-45-67 .. with upto 8 dashes Objective: I need to find the values behind each dashes into multiple columns in orders. [e.g LA-1-2-33 will have columnA = 1,columnB = …

The configuration in our setup is one Web Server and one database server running SQL Server. With the current connection string it works. Recently we moved the database server to another machine with a different ip but with the same name. We used the name and not the ip in …

Hi All, I am creating an application where in I want to display the rows in DataGridView based on the values entered by the user in the textbox. For Eg. If the User enters the BookName in the textbox all the details regarding that book should be displayed in a …

please.. i need help can you please post simple sample code on how to insert and retrieve image in sql 2000 im a beginner.. :) thank you so much

I don't use combo boxes very much, so I basically forgot how to use them. Im connecting to an SQL database and I just want to populate a combo box with a users first name. Heres what I have so far: DBATimeOff.SelectCommand.CommandText = "SELECT FName FROM tblEmployee" DBATimeOff.Fill(DataTimeOff) CmbEmployee.DisplayMember = …

Hi guys, I has a question to ask it is possible to call out the same ID on two different table. Example i have same ID like said 123 on table 1 & table 2 it is possible to call then out and show out on the data grid when …

Hey guys, I want to be able to insert data into text boxes and when i press the button store to be able to store the data into the database. Does anyone know the code to do this? Below is the code I have used so far, I know its …

Hi Alls, I try to write into .doc file and success...but i need to know how to write into form that i already make in microsoft word?...it's mean i got one form(document) in microsoft word format...then my input from textbox box ,will save into SQL database. I need to print …

Hello, How would I go about being able to use a URI of a binary class. For example, I need to be able to give the URI for a song, but the song comes for a SQL server which sends it in a binary form, which is on the memory. …

Hi all, i am trying some code examples given in a book. I am getting an error while connecting to the database.I have installed sqlexpress edition and trying to connect to system database "master". Below is the error message: "A network-related or instance-specific error occurred while establishing a connection to …

Hi everybody I have coded a LINQ SiteMapProvider for my ASP.NET site. The site pages info is stored in a MSSQL database. When I make changes to the SitePAges table, the SiteMap does not reset. Here is my code[CODE]Public Overrides Function BuildSiteMap() As System.Web.SiteMapNode If RootMapNode IsNot Nothing Then Return …

Hello, I am generally a php guy. But right now I need to update entries in SQL Server using ASP. Does anyone know how to escape malicious data before putting it into the database? The following is what am doing right now Many thanks in advance. [CODE] Dim inactiveList ' …

Hi to all, Programmers. :icon_smile: [B]i require a general syntax for checking if the [COLOR="Red"]SQL table[/COLOR] is empty or Contains records.[/B] if the table is empty i'm suppose to add initial counter (like 0001) and if table already contain records then i'm suppose to increment the counter by ONE. The …

Hi, If I have a stored procedure that creates a table of 4 rows (recommended products for a given product). What's the best way to create a cached table of these 4 recommended products for EVERY product in a products table. (Cached table being 4 times bigger than product table) …

I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in …

I am REALLY new to SQL. Teaching myself C#; downloaded SQL Express 2008. (Not sure of the terminology either...) Successfully created several tables for my desktop customer database. I am not able to populate the database yet... Do I have to create my own application to add data to the …

My problem is that i want to develop a project in which there is front end (window form) in vb .net in which there are diffrent field for book entry name,author,image etc. all this data is stored in back end sql server 2005 there is drop down list of books …

Hi there, Being new to Vb.Net 2003, I need help to determine whether to Create new Record or Update an exisitng record in SQL SERVER table. In VB6 I used this logic to do that but in Vb.Net 2003, I am totally lost at it. Please Help me. Thanks. VB6 …

Hi all, I am trying to create an application which involves the User to change the password. I am using Microsoft Visual Studio for developing the Graphical User Interface and Microsoft SQL server as the back-end. I have created a separate form which allows the user to change the password. …

hi I am badly stuck with inserting and retrieving Date in SQL DB from C#. I have a C# application which needs to save date in SQL 2008 Database for various purposes. The format in DB is DateTime for my DateColumn and i am using Datetime Picker in my c# …

Dear All, I have developed C# application to import data from CSV to SQL Server using sqlBulkCopy. However I am facing couple of problems listed below 1. whole transfer fails when one record has column width issue (source column width is 30 and destination is 20) so how could I …

hello everyone..I would be grateful if anybody could help me in performing subtraction from diffrent tables... My Database has a Asset table which has opening balance and balance left coloums in it.and i have one store table which has received/issued item and its quantity.Wat i want to do is if …

Hi, I have hosted a website that has MSSQL Server 2005 database on different machine. I am using the following connection string [code]<add name="ConnectionString" connectionString="Server=mssql2005.ableos.com.au;Database=visualinventory_ableos_com_au;Uid=myuserid;Pwd=mypassword;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />[/code] I am getting the following error. [B]A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server …

Hi Im using visual studio .net 2003 (not 2005) and I'm looking for a good database to work at and also helpful articles to help me, a newbie to c# and database, start creating a database and linking my forms' data from visual studio to the database. 1) If it …

Good day! I just need to pull all the records in table named "cusname" in sql server to an existing excel worksheet which is located in the folder where my program reside.The name of the existing excel worksheet is "excelcusname". I need to put the records in column C, row …

I'm relatively new to MSSQL, and I'm trying to improve the DB write performance. I have some legacy Java code that's generating about 1500 records every second. These 1400 records are generated by multiple Java threads. Right now, my approach is to create an SQL statement in each thread, to …

I need to call a SQLSERVER 2005 DTS package from my windows service which was developed using C#.Net. please help me with source code

hey, first off I'd like to state that I am pretty new to ms sql and stored procedures tho I have worked with sql for quite some time. My employer would like me to write a script which takes html content from a mssql db (originally delivered dynamically) and create …

Hi every one, Can i set multiple font for a textbox in aspx page. (as per user selection) If possible does the font can be inserted in sqlserver datbase. Thanks, Raja

Hi, As a requirement of one of my assignments, we have to upload images, videos and audio files in a column called fileContents. Earlier I had set the data type for the column as 'Image'. But my professor says that I wont be able to upload Audio or video to …

Hi good day.! Im so confused why my code to get the total records in a certain table in sql server returns false. Im already connected to sql server and set-up a table named "loanlist".This table contains 10 records. But when i want to get the recordcount, it will returned …

hi, there , i am coming up with a login page and i am getting error on the codes... please help. [code]<script runat="server"> Sub OnLoginError(ByVal sender As Object, ByVal e As EventArgs) Login1.PasswordRecoveryText = "Forgot your password?" End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Dim …

how the session states are stored in sql server ...where it will be configured before store it into sql server ?

can anyone tell me about sql transcation with example..what are the types are there ?

In my application I need to have the user select one program (item) from the collection in a listbox. This listbox click event then triggers a sql query of an existing sql server data table using the selected program (item) in the sql 'where' clause. The returned data then will …

Hey all, I'm trying to insert a bunch of rows from an xml document into an SQL database. I have a stored procedure that I'm calling from my program after I generate the XML string and pass it into the SP. It runs with no (visible) errors, but when I …

hi, how to get database records from mssql into excel sheet using vb.net. if i click on button and open the excel sheet enter the data and the data is stored in database in the form of records...

Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER JOIN MTM_ACTV_STAFF MTN ON S.ID = …

how will u send automatic email from sql ?

[code] Public Sub add_emp(ByVal emp As EmployeeObj) Dim con As New SqlConnection Dim sqlcmd As SqlCommand 'Dim sqlrdr As SqlDataReader Try If is_emp(emp.Id) = False Then con.ConnectionString = My.Resources.ConnString con.Open() sqlcmd = New SqlCommand("INSERT INTO [Employees] (" _ & "[Id], [SocialSecurity], [FirstName], " _ & "[MiddleName], [LastName], [Suffix], " _ …

I have three tables. student(stud name,stud id) subject(subid,subname) stud details(stud name,stud id,sub name,marks) I want to write a query or a stored procedure in sql server such that the output should be a table say any A1(stud name,sub1,sub2,sub3,total) here sub1,sub2,sub3 are row values of sub name column in subject table. …

I've designed a class diagram for my business entity library, in visual studio 2005, now I was wondering if theres any way to export it to a SQL Script to generate the corresponding tables ... I hope that it can be done... Omar