9,022 Topics
Hi, I was wondering if it is possible to update one table with another tables values depending on a where condition, such as a insert into or using a join as a subquery. I have successfully got a windows application to do what I want it to do but it …
With regards to another thread, [url]http://www.daniweb.com/forums/thread251069.html[/url] on how to compare the current date to retrieve relevant data (Details there), now I have issue on storing this query result on a VB.net variable. It works in this way. It is an academic work to do a ecommerce website, and I need …
Hi Gurus, I am attempting to install KB970892 on SQL Express 2005SP3, and I am unable to do so, due to a SQL suspended installation. When I try to continue the installation (which I have no idea what is it trying to install - I have inherited this server the …
Hope someone here is more experienced than our current database programmer (no offense to him). We have a business search and directory website that just launched. It was developed using flex with msSQL as the database. Here is the problem... We want the keyword field to be searched so that …
Hi, I am having a system with following configuration RAM : 2 GB HardDisk : 250 GB Prcessor : Intel Core 2 Duo OS : Vista Starter I am facing problem while installing SQL Developer in my syatem. Is there any way to resolve this issue or is there any …
Dear Sir, How to write these codes correctly. It displays following tooltip Too many arguments to 'public function iif(expression as bolean, truepart as object, falsepart as object) as object'. [CODE]Dim cmd As New SqlClient.SqlCommand("Insert Into master (code) Values (@code)", con) cmd.Parameters.AddWithValue(IIf(Val(Me.TxtCod) = 0, "Null", "@code", Val(Me.TxtCod)))[/CODE]
Hello there, I am facing a problem for a website i am developing. I have a form with some set of text boxes and dropdown list. When click on submit it transfers the data in the fields and goes to a different website. Now i also want to save the …
Hi i want to save a picture of employee in SQL server Database in my college project payroll system, Please Help me in this matter and give me one example of this.
In VS 2008, for example I have sql command like SELECT * FROM STUDENTS WHERE STUDENTID = @STUDENTID Then I append value into it, for example 15 How to I catch this sql command SELECT * FROM STUDENTS WHERE STUDENTID = 15 Thx in advance
Hi everyone, I have a problem in MS SQL. Due to academic nature, I am supposed to use a query to find out the present applicable tax rate (GST, Good & Sales Tax) without altering the table. The table has 3 tax rates, 1: WEF (With Effect From) 2004 Jan …
I would like to insert to some table's columns input in UTF-8 characters. 1. what property of the column should I change to support this action, should it be 'Collation' or other property (like 'encoding' as well)? 2. I am using Microsoft SQL Management Studio. How can I change property …
Hello, I am trying to make this code to combine the varchar string using fetch technique. The purpose for the code below is to combine all of the results and display back as 1 record instead of multiple records. We have SQL 2000 server. Thanks guys [code=sql]CREATE PROCEDURE get_all_clumns_name ( …
Dear everybody I have a question! I have a database with a invoice table for storing invoice data. In this table i use the InvoiceID as my invoice number. My problem is that if a user makes a mistake and the invoice is deleted in order to create a new …
I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do …
can someone kind give me a sample code it will be highly appreciated thanks!
[code] <?php $MD5Code = "kikugalanet"; // Your Neuz MD5 Code $dbAddr = "127.0.0.1"; // Your MSSQL Host IP $dbName = "ACCOUNTS_DBF"; // Your Account Database $dbUser = "root"; // Your Database user $dbPass = ""; // Your Database User password ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html …
[CODE]<?php $link = @mssql_connect("-", "-", "-") or die ("Server is down!"); $db = @mssql_select_db('-') or die ("Accout table is missing!"); function doesUsernameExist($name){ $exit = FALSE; $result = @mssql_query("SELECT * FROM Accounttable.. WHERE account='$name'"); if(mssql_num_rows($result) != 0){ $exit = TRUE; } else{ $exit = FALSE; } return $exit; } if(!isset($_POST['submit'])){ printSign(""); …
I have one terminal on my network that is using a crazy amount of ram. It is slowing the computer way down. How can I adjust the amount of ram that sqlserver can use? In task manager it is always at the top of the list of memory hogs. How …
Hey! 3 days ago i recieved mail from insitute about my project. My project is about Flat Booking System. After handwork if i am not wrong next step is DataBase. I Have no problem till yet about DataBase. But my teacher told me to show him "DataBase Plan" in next …
Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures [I]245.70 …
Hello guys! I am developing simple desktop application that suppose to connect to SQL DB launched on remote server. Everything going fine, exept that when connecting to DB I get exeption "Login failed for user 'guest'." So, looks like i need to create some user with password and give him …
Dear Sir, Table Employees has data as follows sno----name 1------Eric 2------Boris 3------Bill Whien I enter "B" in text5 and run following codes then it show error message as [CODE]IndexOutOfRangeException was unhandeled There is no row at position 0I have two question[/CODE] 1) Why it does not select name begins with …
hi friends, how can i store video files in the server or database like mysql, if u r having any related docs or code. please send it to my mail-id. otherewise tell me the way how can i store. i am waiting for ur replies... ok bye.. thanks in advance.
hey everyone need some help again, i have two computers both running in vista ultimate. one is a server and the other is like a terminal. my problem is, how do i connect the terminal to a database which is in the server? please provide me a step by step …
i made a windows form application,i want to insert values in to two tables,do i have to use procedure i wrote a procedure but i dont know how to insert the values (dont know the C# codes to inset values) , this is the procedure [CODE=sql]Create Procedure AddMark ( @RegNo …
Dear Sir, SQL Table employees has data as follows sno--name----img-----img_path 1-----A----Binary---D:\C2009\BITMAPS\PICT.JPG 2-----B----Binary---D:\C2009\BITMAPS\eric.JPG Now I want to display picture in picturebox1. To do this I use this codes, but it does not display picture on this line: Dim arrPicture() As Byte = CType(dt2.Rows(0)("img_path"), Byte()) it shows this message, please help Unable …
hi frnds, i was a get a problem, i want to update the serialnumber by using a text box,,,, suppose i am updating the serial number as 3,,,,it was updated,,,, but if i wants to update the serial number as 4 ,that is already in the database it is also …
[code] <?php $MD5Code = "kikugalanet"; // Your Neuz MD5 Code $dbAddr = "127.0.0.1"; // Your MSSQL Host IP $dbName = "ACCOUNT_DBF"; // Your Account Database $dbUser = "sa"; // Your Database user $dbPass = ""; // Your Database User password if(!extension_loaded("mssql")) { echo "The MSSQL extension is not enabled on …
vb.net sql server connection
I'd like to ask a lil help from everyone. I have this problem. I have like items in column 1 & 2: COLUMN 1 COLUMN 2 0001 0043 0001 0056 0001 0078 0002 0043 I just need 1 row per distinct item in column 1 but I need the items …
sir,i am doing a web based application with front end ASP.net and back end microsoft SQL server.i need to know how to start doing a web based application.i need to know does designing is first to start or coding.suggest me some website for guide.
I am trying to return the value of a column if a condition is met: [CODE] cmd.CommandText = "SELECT plan_entity_id FROM PLANNER_INFO Where plan_id = plan_id"; cmd.Parameters.Add("plan_id", SqlDbType.Int, value); con.Open(); returnValue = Convert.ToInt32(cmd.ExecuteScalar()); [/CODE] for instance, if Plan_id is 1 it returns the entity ID which is equals to 1. …
In SQL 2005, if i update any value of a column in a table..... how can i get the column name(it should only return column names when any of its value is updated)
Good day guys!, I have a table named cake_catalog and it has some data as follows- 5 columns cakeCatalogId,prod_code,size,flavor,price respectively: 81 100050 JUMBO BUTTERMOIST 2530.00 82 100050 JUMBO CHOCOMOIST 2530.00 83 100050 JUMBO MOCCA 2230.00 84 100050 JUMBO VANILLA 2230.00 85 100050 REGULAR BUTTERMOIST 1970.00 86 100050 REGULAR CHOCOMOIST 1970.00 …
Dear Sir, Datagridview1 has three columns as S.No-------Porducts--------Price When I enter s.no in column1 then product name and price must display in relevant columns as S.No-------Porducts--------Price 1------------Mango---------12 I wrote folloiwng codes as example Please help [CODE]str = "SELECT * FROM products where code =sno =" & Val(DataGridView1.Rows(1).Cells(0).Value) cmd = New …
ADODB Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified i downloading odbc driver for php...i paste that drivers in php ext directory....then also i m getting this error...anybody help me
hai friend's i am having a table in that i have the field like ( id , name , date),in that i stored id name date e123 raj 12/08/2009 e123 raj 12/10/2009 e123 raj 12/12/2009 e124 ram 12/08/2009 like this while fetching the select id ,name,date from tablename where id="@id" …
Dear Experts I use following codes to display image from sql server. On this line of codes [CODE]Dim ms As New IO.MemoryStream(CType(row("user_img"), Byte()))[/CODE] this error messages appears [CODE]Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.[/CODE] How to get rid of this error message. This message appears because image …
Hello there, I'm again working with a insertTemplate but this time I would like to know, basically I have two SQL tables one called Technician and the other called Alert. Basically I have a TextBox where a user can add new employees and save them to the Technician table, the …
hey, i have a problem regarding the format of the date format. in the form i have the date format in dd/mm/yyyy and when i try to save the date in that format in sql database, it's not accepting in that format. but i need to save the date in …
Currently using ASP.net 2005 I am havin an errot in update statement my code is: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'" myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data …
I get into DataSet CostumerNames and Hours (type DateTime) of their registrations. I would like to sort customers my time of registration (time of a day). I show both in listView. This is my code: [CODE] string DanesRezervacije = "SELECT Stranka.ImePriimek, Naročilo.RegisterTime FROM Stranka, Naročilo " + " WHERE Stranka.IDStranke …
Dear Experts Please modify UPDATE codes according to INSERT codes Style. 'Insert Codes [CODE] Dim cmd As New SqlClient.SqlCommand("Insert Into employees (sno,Name, city, phone,img) Values (@sno,@Name, @city,@phone, @img)", con) cmd.Parameters.Add(New SqlClient.SqlParameter("@sno", SqlDbType.Int)).Value = Val(Me.TextBox1.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@name", SqlDbType.VarChar)).Value = Trim(Me.TextBox2.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@city", SqlDbType.VarChar)).Value = Trim(Me.TextBox3.Text) cmd.Parameters.Add(New SqlClient.SqlParameter("@phone", SqlDbType.VarChar)).Value = Trim(Me.TextBox4.Text) cmd.Parameters.Add(New …
hai friend's ny question is about the database storage , in my project i created database for school , in that i create table for attendance for the school so while they enter the atttendance per day it may be 1000entry per day so for a month i will be …
I want to display a table in a VB form and display the records fetched from an SQL server table in the table in the VB form. how 2 do dis?
i'm a beginner in vb.net i just want to know if it is possible to store the formatting of a text to ms sql so that the next time i retrieve a record that i've already formatted, it will display the format that i did for that record. if possible, …
could u please explain me d difference between 'not exists' , 'not in', 'not all' in detail. Thank You.
I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say C# or Java). It currently works but has severe limitations. Its input is string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns …
im using : v.s 2003 sql server: 2000 [B]im creating this vb application and i took a coding from the inter net which uses 2005 i only have one error that is it's not supported in v.s 2003 can some one help me how to solve this my problem occurs …
The End.