6,934 Topics
 | |
| | hi guys i need a sql injection tutorial for the site built in asp.. |
| | I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is … |
| | hi, Does anyone know how to accumulate total in sql.I have made a function to add a amount to sql.i wants the amount which i have add to be accumulated in total column in sql.How do i make it work. please help [CODE] Public Function Update_TotalBalance() As Boolean Dim myConnection … |
 | could brothers and sisters welcome me by looking into this longlasted problem: [CODE]"INSERT INTO finaldata (Hall, Bedspace, AmountPaid) SELECT * FROM AllcDataBoys 'WHERE Bedspace ='" + (Bespx.CompareTo(RET) == 0) + "'WHERE RegNumber ='" + txtRegNumber.Text.Trim().ToString(); [/CODE]finaldata table has 7 columns and AllcDataBoys table has 3 columns(which is common on both … |
| | Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open … |
| | I have created a gridview that is populated from a SQL table. The gridview does not autogenerate the fields; all are explicitly defined. [CODE]<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="Hours" style="margin-left: 0px" AllowSorting="true"> <Columns> <asp:TemplateField HeaderText="Send Email"> <ItemTemplate> <asp:CheckBox ID="chkEmail" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="tkinit" HeaderText="Initials" SortExpression="tkinit" /> <asp:BoundField DataField="tklast_first" HeaderText="Name" … |
 | This seems to be the appropriate thread to post my problem in: I'm also trying to bind to a ReportViewer object, however I'm not binding a stored procedure but dynamic sql that selects <dynamic columns> from <dynamic views or tables> nice huh? My boss has fallen in love with the … |
| | [CODE]import java.awt.*; import java.awt.event.*; import java.awt.image.*; import java.io.*; import java.sql.*; public class RefHistTest { public static void main(String args[]) { int iw2, ih2; Image img2; int pixels2[]; double[] hist2 = new double[256]; int y; ResultSet r; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:CBIRS"); Statement st=c.createStatement(); r=st.executeQuery("select Images from ImageTable"); byte[] bytes=null; while(r.next()) … |
| | This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy … |
| | hi, Does anyone knows on how to update records from 1 text file into 2 different sql database. Name of the sql Table is Payment2SQL_Success_P() & Payment2SQL_Success_E() is the code below is on the right track. [CODE=vb.net] Select Case "AGENCIES" Case AGENCY_AV Or AGENCY_SR Or AGENCY_IP Or AGENCY_TM Or AGENCY_MS … |
| | hi, I need to knw on how to accumulate the total amount in sql table. I have created a table below but it does not calculate accurately. By mean it just total up current top up amount with the 1st value of grand total. How do i total up to … |
 | Hello fellas I'm actually developing some web applications in Ajax, and have been trying them in my Wamp server for Windows 7. I've been using the php_sqlsrv module since its release, because of its new features. The thing is, my office has a fedora webserver, and I'm looking for a …  |
 | Is it possible to pass arrays into a function and/or return an array from a function? I think it's possible but I don't really know how to go about it. lets say I have a function that returns a bunch of field from a database ex: [CODE]function a($sql){ $result = … |
| | Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public … |
| | anyone can help me to merge a data from potrait to landscape...or else dont hav any solution for this |
| | i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click … |
| | |
| | I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from … |
| | I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently … |
| | I am having the following trouble: "System.Data.SqlClient.SqlException: Incorrect syntax near '11'. Unclosed quotation mark after the character string ' )'. I tried the solution of using double quote right there, but it give me another problem. The more strange thing is that the data is begin copy to the new … |
 | Pls any body help. I am in a crucial situation :( I want to back up and restore database which is created in sql server 2000. how can I use this in C#. The code which I have written is not working properly. It throws an exception at step 31. … |
| | Hi, is it possible to create the aspnetdb file in Visual Studio 2008 using the "Security" option from Web Site Administration Tool with MS SQL Server 2008 express edition? I get the following error message when I try it: "There is a problem with your selected data store. This can … |
| | Can anyone tell me how or what's the JavaScript code to perform the following: 1. I have two frames on my web page. (Top and Bottom) 2. Top Frame is data 3. Bottom Frame are some Controls. (Print button, Back Button, Close Button.) 4. I'm using VB.Net creating aspx pages. … |
| | Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only … |
| | I am creating a program that will have a database of schools.. Each months the user needs to add a certain data entry for all schools, like each month the user will need to input how each school scored in a monthly competition. The number of months is not fixed, …  |
| | i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. … |
| | hi, If the condition = true How do i select all records stored in .txt (temporary text file) to be updated in sql table How do i do that. Please help Thank You |
| | hi, here is my data base structure: [ATTACH]17124[/ATTACH] i try an sql command that return for each examen its number of tests, so i tried: [CODE]Dim sqlQRY1 As String = "SELECT Int_Exa,count(*) as 'TOTAL' from TEST T1,TEST T2 where T1.Int_Exa=T2.Int_Exa"[/CODE] that`s did not work, so i tried to do that: … |
| | I have kind of the same question as Rambomst, except I need the query string to populate the values for the IN statement this is the code I have but it's not working and I'm stuck and am in DIRE need of an answer: <% Dim rsAuto__print For i=1 to … |
| | i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though three processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe 3) wowexec.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really … |
| | Hi team, I've written a windows program and it works nicely but its really slow when it retrieves the data from the server. Program Overview: The program allows users to search through a database and add contacts if they want. Some of the fields on the forms fill up depending … |
 | Hi guys, I am using Visual Studio 2008 and have connected a database correctly as I have done a login that works fine, although when I try to insert information submitted in the text boxes a different table, it doesn't enter after I end program to check it still has … |
 | Hey all! I'm working on a university project (C# - VS 2010) at the moment which uses an SQL Server 2008 (.mdf) database. At the moment, I have the database (lets call it ProjectDB) attached to SQL Server Management Studio on my laptop (the server - lets call it "LaptopServer") … |
| | hey i need to know whether the below code is correct [CODE] string query = @"Select p.ID,p.Phase From Proposal as p, Negotiation as n,contract as c Where c.CID=con.CID and c.NID=n.NID and n.ID=p.ID and n.Phase=p.Phase (Select con.CID From Contract as con Where CStatus='Active')"; [/CODE] there is an error coming saying "Incorrect …  |
| | I want to validate username and password i.e.I created a table with two variables username and password in sql. I want to match table username and given username as well as for password. If those matches then only it should login. Please help me with the code sir  |
| | I have a SQL table that contains spam or naughty word phrases. I'm trying to decide how to take some text and determine if any of the values in the table exist in my text. In the past I have selected all of the phrases out of the database and … |
| | I'm trying to populate my textboxs with data from my database when the user name is selected but I'm having trouble getting the code right. Help Please! table users (there is a textbox for each of these fields) password lastname firstname Using upcmd As New SqlCommand("SELECT * FROM users WHERE … |
| | [CODE]<cfquery name="Booking_Link" datasource="HotelBookingSystem" username="HBSuser" password="HBSpass"> SELECT * FROM Bookings WHERE BookingDateIN AND BookingDateOUT NOT BETWEEN <cfqueryparam value="#FORM.SelDateIN#" cfsqltype="cf_sql_date"> AND <cfqueryparam value="#FORM.SelDateOUT#" cfsqltype="cf_sql_date"> </cfquery>[/CODE] This works .... But if my booking date(UK - dd/mm/yyyy) has a range of 05/02/2010 to 09/02/2010 And my search value is 04/02/2010 to 05/02/2010 ... this … |
| | If there any solution on how to choose specific column..what is the code?? i'm using VB.Net [CODE] If e.Row.RowType = DataControlRowType.DataRow Then Dim CellValue As Decimal = Convert.ToDecimal(e.Row.Cells(4).Text) If CellValue < 5.0 Then e.Row.Cells(4).BackColor = Drawing.Color.Orange End If End If [/CODE] |
| | Hi, Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve. Eg: field #1 field …  |
| | anyone can help me to separate a database horizontally instead of potrait. as example... BEFORE: Quarter 1=20 Quarter 2=10 Quarter 3=15 Quarter 4=35 AFTER: Q1 Q2 Q3 Q4 20 10 15 35 |
| | I have two databases, tvguide and episodes1. Both are InnoDB, and I use Phpmyadmin to edit them. I tried creating a foreign key between the "episode" field of episodes1 and tvguide, and this error message came up: Error creating foreign key (check data types) : episode How can I fix … |
| | hi please i need help with the query using the values from the combo box and the result will show on the data grid sp [CODE] ALTER procedure [dbo].[sp_GetReservistInfo_ByDesignation] @Platoon varchar (50), @Company varchar (50), @Batallion varchar (50), @Brigade varchar (50), @Division varchar (50), @FirstName varchar(50), @MiddleName varchar(50), @LastName varchar(50), … |
| | can any one tell me the code of inserting data in sql server 2005 through asp.net pages using c#. |
| | well i was looking at some videos online and was prompted to update my realplayer and it failed, since then i haven't been able to open any explorer window. I have run adaware, spybot, striker, and norton full system scan. I can't figure it out and i know alot of …  |
 | Hi i'm new to programming . I'm creating a project in C#.net using visual studio. I'm facing problem. Creating a login button and a new login ID button. the new login ID should store the details in the database and when the same is entered in the login text box, … |
| | Hi, i'm working on migrating csv data into MySQL using jsp. I would like to know if the sql statement shown below can be used in jsp and where i can get examples on the codes. [CODE]String sql3 = "LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE test FIELDS TERMINATED BY …  |
| | I am hoping someone can help me...I am totally frustrated! I am using Visual C# 2010 Express (which might be the problem right there, but I wouldn't think so). I have added a .dbml (LINQ to SQL) file to my project and I am about to create a new connection. … |
| | how to establish a connection after validating all the fields in a form can any one please help me with code |
| |
The End.