9,022 Topics
i'm doing a online hotel reservation project using asp.net Vb script now. but i'm facing problem that once the users has submitted their reservation form. how can i redirect the user to another page while the data can be inserted into my MS SQL database? hope somebody can help me …
Hi I have a small question. I'm building a website and I would like to make custom message strings that I can later put in a sql database. Is the following idea the correct way to go? File: SystemMessages.vb [CODE]Select Case EventID Case 100 msg = "New user" & username …
Hi, i have a form in VB. iam using SQL Server as Back-end. And connection string and all works properly. the only one thing is i want to retrieve data from database into a combobox. i'am using this code.... [ dim i ] [ for i = 0 to Combo1.ListCount …
Hi I'm about to write a short application but I have a problem: I need to get a recordset (or two) from 2 different SQL servers. I would prefer a single quarry but i don't know if it is possible. And if not, I will have rs_1 and rs_2. How …
hi guys.. i got one big problem rite now..currently i'm handling new project using VB 6 and MS SQL Server as host server. Rite now i'm stuck at store/save data into the server. Previously, i'm using C#.Net and it success but then i'm not sure whether the code from .Net …
hello, I'm kinda newbie in databases. I have a table like that: DB is MSSQL 2003 Name is varchar Fruit is int (i used the name just to avoid mess with numbers) the number and the type of the fruit is fixed (in real case are 1,2,3 and 4) Qty …
I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help …
I have a table with 3 columns as follows: lower upper id 12 20 100 100 150 200 I want to select range of numbers based on lower and upper column. For example I want to display numbers between 12 to 20 or from 100 to 150. How to do …
[code]SqlConnection con = new SqlConnection(connectionstring); SqlCommand cmd = new SqlCommand("proAdd", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter sqlparam = null; sqlparam = cmd.Parameters.Add("@EmpName", SqlDbType.VarChar, 50); sqlparam.Value = txtname.Text.ToString(); sqlparam = cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50); sqlparam.Value = txtaddress.Text.ToString(); sqlparam = cmd.Parameters.Add("@BasicPay", SqlDbType.Money); sqlparam.Value = decimal.Parse(txtaddress.Text); sqlparam = cmd.Parameters.Add("@PF", SqlDbType.Money); sqlparam.Value =decimal.Parse(txtpf.Text); sqlparam = cmd.Parameters.Add("@HRA", …
I want to make a simple application which its databse is on another PC in my LAN,What do I need to do to make such connection? I can make connections on the local PC.What do need to do to make a remote one? I want the exact syntax of the …
the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck …
Hi all!! This is my first post in this forum! I recently joined an IT company as a software tester and I'm to find a software that will automate testing as much as possible as there are many versions being built simultaneously. Could someone please recommend me a program that …
The code below gives me "Warning: Wrong parameter count for mssql_bind() in" [CODE] $action="L"; $M_ExhibitionID=$_REQUEST[M_ExhibitionID]; $areaid=1; $LngCode="el"; $sproc=mssql_init( "sp_php" ); mssql_bind($sproc,"@action",$action,SQLCHAR,false,false); mssql_bind($sproc,"@M_ExhibitionID",$M_ExhibitionID,SQLINT4,false,false); mssql_bind($sproc,"@areaid",$areaid,SQLINT4,false,false); mssql_bind($sproc,"@lang",$LngCode,SQLVARCHAR,false,false); $GET_EXHIBITS=mssql_bind($sproc); [/CODE] what is my wrong?
Hi: I have a question.. I got a control/master database. I have another work database. I have to match each value from 2 fields present in my work database to a control db. The values could be anywhere in the fields in my master db.. it just has to be …
Hi: I have a question.. I got a control/master database. I have another work database. I have to match each value from 2 fields present in my work database to a control db. The values could be anywhere in the fields in my master db.. it just has to be …
Hi... I have a sql 2005 database called KN_online.. I have a stored procedure called Account_Login [code] USE [KN_online] GO /****** Object: StoredProcedure [dbo].[ACCOUNT_LOGIN] Script Date: 07/16/2008 01:01:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[ACCOUNT_LOGIN] @AccountID varchar(21), @Password varchar(13), @nRet smallint OUTPUT AS DECLARE @Nation …
Hello All, any code immediately following an 'N' is throwing an error. Please advise on why. TIA. [code] set @localized_string_AddRole_Failed = N'Failed adding the ''state_persistence_users'' role' DECLARE @ret int, @Error int IF NOT EXISTS( SELECT 1 FROM [dbo].[sysusers] WHERE name=N'state_persistence_users' and issqlrole=1 ) BEGIN EXEC @ret = sp_addrole N'state_persistence_users' SELECT …
Hello, If I have a table like this where i have the year and the month, how can a get something like 2008 3 after a select? - I mean the maximum month for the maximum year? Thank you. [CODE] year month 2006 1 2007 1 2006 2 2007 2 …
I want to connect to a remote SQL server database in C# and the connection string needs USER NAME and PASSWORD,(I think its they`re database`s) Any way How can I create usr and pass for a databaese? I tried it in users part of databse but it wants(user name,login name??,and …
hello guys, i wanted to write a query, or a view to be exact to display data from two tables as follow: 1. schedule_table (scheduleID as pk) 2. remarks (remarkID as pk, scheduleID as fk) meaning a schedule can contain many many remarks and non at all. now the problem …
hi all, I want to calculate days b/w two different month like as 7/15/2008 and 9/30/2008 this is silly question but i have problm to calculte ti .Its urgent in projec
Can you please tell me what's wrong with this statement ? i get no errors but I get no o/p either! [QUOTE] Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim con As OleDbConnection = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") If (ComboBox6.SelectedItem = 0.5) …
there is another problem that i am facing..i got 2 comboboxes filled with values from MS Access and they have values like 1.00,2.00,2.98,3.00,3.25 and 8.00 I want to be able to choose 2 values i.e. one value from each combo box and when I hit click I should get queries …
Sorry, I posted this in the wrong area (I'm using MySQL) Hello all: I'm currently building a website for a radio station and I want to setup a programming lineup. The fields I'm using are: ID Title Dayofweek (Show Day) Timeslot (Show Time) AMPM (AM or PM) Description Name (Host …
Hi the situation is, My database is online. On one system i have my asp.net project (as a server). i need to access this site in LAN. Means from anywhere i access site the database is live. Am i right..!! Now the problem is I am unable to access the …
I have written the following Stored Procedure in an attempt to update two tables in the same database reliably but unfortunately it is not too successful. I ocassionaly end up with only the BundlesIssued tables updated and nothing in TicketsIssued. Please make suggestions on how I could make this stored …
Hi.. I m using vb6. plz tell me how can i access data in sql table by vb coding like.....eg. In sql table i hard code the 20 question i want every time when we click the next button on vb form then display question no-2 & IInd time i …
Hello, I have a table with a field AFM (integer), I want to display all fields of the AFM column that have the same value eg. 1 row has 1111 2 row has 4567 3 row has 1111 4 row has 5678 5 row has 3456 6 row has 3456 …
Hi, Why a database with two words separated by a space causes problem to a bcp command like below : EXEC xp_cmdshell 'bcp [History Data].dbo.InventoryValuation_FP102008" out D:\test.txt -q -T -c' Do you guys met with the same problem before? If yes, how to solve it. Many thanks.
hello frds, I m working on windows app in .net envirement with c#. I want to fetch large amount of data from a table and load it to my app. by dataset. but problem is, it unable to handle this or take a long time. My table have approx 10 …
Hi all, I want to install both SQL and the MS.NET software.The normal order is install MS.NET first ,then the SQL .But I wat to install SQL first .Can MSSQL sever installed before MS.NET? Suggestions please !!! Thanks in advance !
Hello everybody, i'm a newbie to MSSQL - so excuse the newbie question. i am creating a page wich is hosted like any other page on a web server, i need to somehow connect to a MSSQL server , wich is located on a normal computer and connected to the …
hi i'm a new user to ms sql 2005. Can anyone please tell me how can i make a existing null constraint column of a table as a not null ..... i.e If a column already exists and can hv null value ,then how can i convert it into not …
Four times my MSSQL Server hacked. Somebody inserts most of the tables text, varchar fields with its value adding at the end with<script src=http://www.pyttco.com/ngg.js></script> I changed my ftp usernamd and password, database username and password. Still they are able to insert different scripts like <script src=http://www.cdport.eu/ngg.js></script> <script src=http://www.drvadw.com/ngg.js></script> <script src=http://www.bnrc.ru/ngg.js></script> …
i tried putting in actual values and it works..this code gives results of RAM > 0.500 and less than and equal to 2.000 but how do i make it parametrized ??????????????????? [QUOTE] Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim con As OleDbConnection = New …
I am having some trouble wrapping my head around this project. I am needed to code a relational database in C++ making use of the sql selection and projection operators. I can use a 2d array to create the 'database'. Please, if anyone could just point me in the right …
Hi all! Ive created this code to read in data from several tables but i have a problem with SUM. With this code im trying to add together all the null values that have the most recent date but all the SUM commandi have does is multiply the number by …
Hey guys, i'm trying to create a database in Access, but i'm having problems, keep getting the same error, i've gone through it so many times but cannot see whats wrong with it, i'm getting a syntax error which highlights at the start of the Enrolment table, any help would …
Hi Guys, I have a text file which looks like this 123456 Amanda Morris and I would like it to look like this "123456","Amanda","Morris" The file has about 2000 lines how would I go about inserting the quotes and the commas. I use textpad to open the textfile and I …
Hi, I have an average cost greater than price crystal report for 20 different stores. I want to create a master report that lists all of the results over the entire company. Hence, I want to use union all in a SQL command for this master crystal report. For example, …
example string: /* hack */ string SQLSTR="SELECT * from pass where username="+"'"+textBox1.Text+"'"+"and password="+"'"+textBox2.Text+"'"; best war for in message is: /* not hack */ [B]string SQLSTR=string.Format("select * from pass where username='{0}' and password='{1}'",textBox1.Text,textBox2.Text);[/B]
Hi, I am getting this error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." when trying to get some data from SQL Server 2000 database. SQL Server is installed on Windows Server 2003, and i am testing the application from WinXP sp2. Testing from other machines with same settings …
Hi, I am getting this error "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." when trying to get some data from SQL Server 2000 database. SQL Server is installed on Windows Server 2003, and i am testing the application from WinXP sp2. Testing from other machines with same settings …
So I got this code off the internet. The guy who made it said this, "I have done this in SQL Server.If u want to do in Acess Database just create a table name USERS then add two fields name user_name and user_pwd thats it." I tried that and it …
hi. I'm trying to delete a row by specifying the actual row number. When I call all columns from one table it does work but when I already multiselect them I get an error: [COLOR="red"][I]Msg 4405, Level 16, State 1, Line 1 View or function 'Records ORDERED BY rowID' is …
hi guys, i was trying to sum up all the balances of clients to know which of them has reach their credit limit but my codes are not working. It shows an error and highlights on this code [code] rsArmaster.Open "select sum(balance) as credit from ArMaster where shippercode= '" & …
I want to select data from ranges like Column1 Column2 25000 10 50000 20 75000 30 I want records like upto 25000, I get 10 upto 50000, I get 20 upto or more than 75000, I get 30 Can anybody suggest me a simple query for that? Thanks in advance,
Why is this script not working.. [CODE] USE [KN_online] GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[UPDATE_PREMIUM_SERVICE_USER_EXEC] AS DECLARE @d24 datetime SET @d24 = DateAdd(hh,-24, GETDATE()) UPDATE PREMIUM_SERVICE SET nDays = nDays - 1 where Date > @d24 [/CODE] This is suppose to take 1 day …
hii all, i have a query,,it might be simple bt i hav no idea how to do it,,i am creating an application in VB lang using asp.net 2005 and sql server 2005. in my form i have a combo box which displays all the table names from my database say …
hi friends i have to store and read .txt files from database(sqlserver 2005) using asp.net 2.0 and i m unable to do that plzz reply me as soon as possible
The End.