[microsoft:sql-server] Forum Topics

good morning ... I wanted to ask you, how to make file backup and restore sql server 2000 through visual basic 6.0 application already many forums I visit and ask, but until now there is no single person who can help me Can you help me? your help is much …

Hello, I am developing a software which will connect to a SQL SERVER situated at Head Quarters over a VPN connection.But for times when VPN is disconnected I want my applications at the branches to connect to a local Sql Server installed at a local server. Now all the applications …

Hi I have three tables [ATTACH]18183[/ATTACH] Suppliers, Supply and Parts. I want two queries. a) List the name of the part along with the Total Price. b) List the names of the supplier that list both p1(part1) and p2 (part2)

[B]Hello..! i have an problem to connect a progress bar with listview object.P.bar working properly. bt i want to connect p.bar with ma sql database while m searching database.kindly help me where m i doin wrong..the code is below.[/B] [code] Private Sub cmdRFind_Click() On Error Resume Next Dim vLst As …

Hi there I want to know how I can save a checkbox value into sql server 2005? The check box is in my windows forms application... Thanks

Hello: I have a table where a column called [I]ActiveStatus[/I] (of datatype 'bit') I am trying to run a query on may contain values Boolean values or NULL. Which means, if there are 10 rows in the table, a likely scenario would have 5 NULLs, 2 FALSEs, and 3 TRUEs. …

Hi Geeks!, I am developing a project now. My problem is how can I create a autogenerate alphanumeric in the textbox to be used as an ID of entries. I'm using VB.Net 2005 and MS SQL Server 2005 STD. Thank you in advance. More power to this site.

Hi I am using vb.net 2008 and sql server 2005 in that one form contains the richtextbox from that richtextbox i am saving the questions in database now i want to change each questions font and size. can anybody help me!

please i need help here. let someone help me to debug this i attach the project bon compressed folder: [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsApplication1 { public partial class Form1 : Form { //static …

I have a stored procedure where I need to insert from some other tables when those items do not exist in the original table. Here’s the stored procedure that I wrote. [CODE] ALTER PROCEDURE [dbo].[sp_CreateRequestedItems] AS BEGIN INSERT INTO dbo.RequestItems ([request], [applicationProfile]) --select from requests and profiles table into requestitems …

I have a listview that is filled with an sql query from temp Sql DB that is created from a program that run from textbox inputs, which writes this db. When the select button is pushed it query loads the listview. Sometimes their may be "0" or null values in …

i m unable to handle jquery accordian i want to bind it to ta database coz m showing lateset events, announcements in it i wanted that the user shuld be able to enter the values in a text box thru a admin panel which i shoud make for him n …

I am starting to learn C# database programming by visual C# express edition. when I open the data source configuration wizard and click the new connection button the wizard closed. Its kind of weird. I have sql 2005 express edition installed. please help me.

Recently, I have been assigned the task of tracking training records used by multiple departments within my company. Before, they would fill out ISO Standard Forms that are built in MS Excel and save them in one folder. This folder held ALL of the documents used by multiple departments, training …

Hi, I have am interesting problem that I cannot think of a solution for. I have an VB.NET application. This Application is permanently resident in memory and minimized to the tray area because we use it very often. The problem comes in when we VPN into a client's site. These …

I have the following three tables: ClassHeader ClassID Major TeacherClasses TeacherID ClassID StudentClasses TeacherID Major I want to select all TeacherClasses where the a given Major = ClassHeader.Major

Hi every one, please could you help me in my project!! I'm trying to design a words game that's give you the first two letters from the word and you insert the rest to make a word (for now I'm just using "co" as example and I have just one …

Hi i have this sign up page backupserver1.123-backup.com:8080/client/signup.cfm When i enter all the details i get this error in the next cfm page call insert-user.cfm Error as follows Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Operand type clash: text is incompatible with tinyint I think the problem something to with a …

i need to isnert in database and i have query liike that [CODE]str_attend = "insert into Attendees([Userid],[Attendees_name],[Attendees_telephone],[Attendees_Email] )values (" & userid & " ," & arr(0).ToString() & " , " & arr(1).ToString() & " , " & arr(3).ToString() & " )" [/CODE] all values hold values in insert statment non …

i want to concateneate my query with textfield value [I][B][COLOR="Green"]select tablename.columnname From TableName[/COLOR][/B][/I] lyk this Select tablename. & Me.textfield.text & from tablename plz tell me where m i doing wrong actually i m trying to only select single column by combo box.whenever combo box value is equal to column name …

Hi guys, My group is having a software development project for our academics at a university. The software we want to develop is an inventory system which will be installed in a Local Area Network. We have decided to use Visual Studio C# (2005 or higher) as the front-end while …

am using sql 2005 and vb 2008.i need to compare dates and select matching records betweem a selected date range.say records between 11/13/2010 and 11/20/2010.e.thing is working ok except when it comes to selecting dates between 11/1/2010 and 11/9/2010.this is happening because when am retrieving the dates from database,its being …

Hi everyone! I want to add dynamic mdf files to my solution and see what tables in every mdf file I added. First I am going to add mdf files and then a listbox will show table names. Is there a way to do it? Which controls should I use? …

Hi, I've writen a stored procedure that is supposed to load 4 tables in a database that are to be used by a vendor to load their tables for an application we purchased from them. being that our data is on multiple servers, the query must read from two servers …

Hi there, How can I write a stored procedure to select a value from a table and return that value?? I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number) I …

I am trying to write a c# app (windows app) that can import certain data from an excel document into a Sql database table. Can anyone please show me how to get this done? I have attached a screen shot of the sample excel doc am trying to upload...it contains …

I am putting together an editor for an application I am creating. The data ultimately resides on a SQL server. The application loads some of the data from the server into a dataset, which is used by a bindingsource which is then used by a bindingnavigator. (wow that's a mouthful). …

i have code [CODE]Protected Sub btn_submitt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_submitt.Click Try If (ddl_Country.SelectedItem.Text = "Select Country") Then Me.Label1.Visible = True Me.Label1.Text = "Please Select Country" Else Me.Label1.Visible = False Dim n As Int32 Dim connString As String = System.Configuration.ConfigurationManager.ConnectionStrings("containerConnectionString").ConnectionString Dim con As SqlConnection = New …

Hi All, In my development of an online application, I have to generage the serial no for the available number from the serial number table in sql server. Multiple users will hit the table to generate the serial numbers. So the serial number should not be repeated. I have to …

What do i do if i have code for insert.when i insert the data it shows when i click the SHOW button(when I enter a serial number and then click SHOW it shows the data) it works but when i stop the system and run it again it does not …

I am new to vb. I am trying to get a value for a textbox from a database according to the selected item in combobox. but i had this ex.message Operator '&' in not defined for string "select*from ......" and type 'dtarowview' Could anyone please tell me what is wrong …

Hi Everyone I have used a drop down and a label. I want on the selection of the drop down data should be viewed on label. [CODE]ex: if user select value from drop down (Apple) so on label it should print (50 per KG)[/CODE] Data should come from sqldata and …

Hello, The title of this thread perhaps does not explain my problem correctly. Actually i am developing a financial software for a company.The software is similar to a banking system. The software is being developed using VB 2008 and SQL Server 2008.The company has its branches located at different locations. …

Hi, I have read many post obout n-layer programming, but still have found no good example or reply on some fundamental issues that I have. I use 3 tier (Dal, BLL, Pll) and for some gridview I want to present the following in one column: the fields period 1, period …

'A way to connect to SQL with VB.Net using Classes 'This must be a class on its own Imports System Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Web Public Class frmConn Public Shared Function ConnSQL() As SqlConnection Dim connectionString As String Dim cnn As SqlConnection connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\test_db.mdf;Integrated Security=True;Connect …

A little help guys i have a JButton..i wanna use it to repeat the SQL statements but with an updated value.... my JButton reads [code] if(ae.getSource()==b1) { v1=v1+2; System.out.println(v1); } [/code] v1 gets a new value everytime i click the button and the v1 is used here ...under public static …

i have a datagridview which i populate from a SQL database. one of the columns is of a Ntext type. i would like to enlarge the cell on focus so the user would be able to read what's in it without entering edit mode. any idea ?

I've managed to put together some code to retrieve data from a sql file. I plan to connect to a sql server that are operated by a database program, that update the registry every 10 sec. Before I try to connect my program to the sql database, I need to …

Hello, I am new to Access and VB, but I have used C# and C++. I am trying to update a whole bunch of records in a table, only one field. For example [CODE] [Employees] [ EmpCode ] [ FirstN ] [ LastN ] [ 019871 ] [ John ] …

I have a web app that when run locally runs as intended. Once published to my server it does not. The issue is related to sql's integrated security. The webservice/sql call is using "domain/machinename" as the login, instead of my active directory credentials. There is no sql security login for …

hi.... in which version of sql server i can get the below two option... 1) performance tools 2)database tuning advisor.. please send me the download site...

i am trying to connect to an MS Access database but i am new to C#. I have looked at, amongst others, Paladin's response to dark omen about connecting to a database and since i have connected to a database before in Visual Basic most of it makes sense to …

Hi I have the below code and when i open it in I.E i get this error Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'Language'. Do i need to enter a database @ the datasource= [code]<!--- GetLanguage ---> <cfquery name="qLanguage" datasource="#request.DSN#"> Select LanguageID, LanguageCode, LanguageName from Language </cfquery> …

Hello... Can anyone help me...? I have the problem when installing SQl Server 2008 on Vista.. The message is : The performance counter registry hive is corrupted... please I need it Quickly... thanks......

hi all, I am new to mssql but C# programmer, can anyone help me on how to merge columns from different tables to a single table in sql for example i've 4 tables and the first table has a,b,c,d columns second table has e,f,g,h thrid table has i, j, k, …

Hi folks I need some help! I have two tables the first contains account information, and the second contains flags that records in the account table may have. These are joined by the account?id. One account record may have several flags from the flag table. ie the following select select …

Hello everybody and thanks in advance for any help you can provide. I am currently working on transitioning a mysql project to mssql and php v 5.3.3 I am having trouble with [code] <form action="{$_SERVER['PHP_SELF']}" method="post"> [/code] when I look at the source code of a working page... Say login.php …

Hi all! I have a program that runs as a large form (Form1) with smaller forms that open inside of it (PeopleBox). It's for friends/contacts - each person gets their own row in the database (PeopleDB). At runtime I'd like it to open a PeopleBox for each person already existing …

hai friends i am developing a voting software, but i cant able to find the code for increment the no:of vote in the database when an user click on the button.I used sql server 2005 as my back end..Any one pls help me...

i have two related table name employee and userloginlogs. In my program user must first log username and password located at employee table. If the user already logged in i want to get the employeeID at employee table then save it to userloginlogs table plus the login and logout date …