6,934 Topics
 | |
| | Hi, I have a problem with asp.net insertion data in SQL data base. I am using SQL Express with ASP.NET 4.0. I had written the code correctly and it was working fine as well, but now it does not insert the data in the database. It started behaving abnormally when … |
 | Hi I am trying to update my database based on the selected values in two comboboxes. Combobox1 = Manufacturers Combobox2 = Orderlists In the App the user selects a manufacturer and then an orderlist and then presses Ok button which updates the default orderlist for the manufacturer. I am having … |
| | Hello i have a problem with protect from sql injection : the problem is: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in My Old Code (working): [CODE] <?php $currentid= $_GET['id']; $q="select * from tbl_car where id=$currentid"; $result= mysql_query($q); while ($row = mysql_fetch_assoc($result)) {} ?> [/CODE] my … |
| | Basically, it is an open source software creation application that revolves around databases (similar to Microsoft Visual studio in some aspects but with python as the language). The user will be able to create forms with a drag and drop GUI builder, create an SQLite database and add functionality to … |
| | Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that …  |
| | I'm getting an "Object reference not set to an instance of an object" error with this line of code: [code] t1.FindNode(rs.GetString(4)).ChildNodes.Add(node); [/code] Here is all of the code: [code] using System; using System.Data; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data.SqlClient; namespace TreeViewProject { public partial …  |
| | Hi, I am trying to organize the way my episode titles output. At the moment it prints like this. (I want to be able to upload the newest episodes and also go back and upload the older shows but i want the newer shows to stay at the bottom in … |
 | Hey Guys, I need some assistance if possible. I am using MySQL & PHP, I have an "events" table with a row field called "Users_Attending" and can't seem to figure out the best way to add multiple users to an event rows "Users_Attending" field. I want to store user emails … |
| | hi, now I wants to insert some records into table in Microsoft Access and C#, below is my codes : [CODE] SQLStr = "Insert Into RegisterEmployee(EmployeeName,Password,Gender,ContactNumber,Position) " + "Values ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" + SQLStrCmd.ReplaceStr(genReg.Text) + "', '" + SQLStrCmd.ReplaceStr(Hptxt.Text) + "', '" … |
| | Hi, I am unable to run my c# application on a different computer other than my own computer. I have an attached mdf database file in my project. I have 'SQL SERVER 2008' as pre-requisite in the setup project. The application is installing & running fine on my machine, but … |
| | I need to tackle the question of threading in Visual C# application development. In its most basic use, I will need to "branch out" to SQL SPs (for example), but need to be able to inform the user that "I'm doing something" - such as the following outline: 1- user … |
| | Is there anyway to do it? I find a msoft tool that does it for sql server 2005. There is an import feature in sql server 2008 but it doesn't do it correctly. Anyway to convert my database with all its relationships to sql server automatically?? |
| | [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Data.Sql; using System.Data.SqlClient; using System.Configuration; using System.Linq; using System.Text; using System.Windows.Forms; namespace Eventmanagement { public partial class Registration : Form { SqlConnection aConnection; string firstname= string.Empty; string lastname= string.Empty; int aid; string date = DateTime.Now.ToShortDateString(); SqlDataAdapter da = new … |
| | Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things … |
| | I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there. Aside from that I'm trying to build a query that provides me with counts of the games so I … |
| | Hi everyone, i have created a sql table to store hindi data. it works fine. Now i want to store data in this sql table from an Excel sheet. i want to know which hindi font i have to use in excel sheet so it will store hindi data in … |
| | I have this page that you can do a search on the site. However, if I do a search that contains an apostrophe ('), it breaks and doesn't display anything although I have entries that have them. Does an easy fix exist for this problem? This is an example of … |
| | The application is currently developed using ASP.NET (C#) I have code to pull data from a SQL Server 2008 table and organize it into an hierarchy: [code=sql] With hierarchy (id, [location id], name, depth, trail) As ( -- selects the "root" level items. Select ID, [LocationID], Name, 1 As depth, … |
| | Hi all, I'd appreciate some advice concerning the following issue. I have a situation with two very different ways to implement. Both are easy, but Im not sure of the pros and cons of each. Basically I am allowing users to message each other on a website, and so I …  |
| | hi I am new to SSRS. I have a matrix table like below: [CODE]--------------------------------------------------------------------------- | id | name | family | book1 | book2 | book3 | book4 | book5|...|book10| [/CODE] As you know, the count of books in rum time are different for each user. it's may be 10 … |
| | I find for just numbers type_digit() works great combined with addslashes() but what about for a mixture, to prevent SQL injection?  |
| | Hello, i am facing an issue in retrieving data from an array. I have a table called registered_members, the table contain First_name, and Last_name. I also have a table called Friends, it contain Friend_ID, Member_ID, Status. What i did is that in a search box, when someone type a name …  |
| | Hi all, Sorry for the long post but i need to describe my problem properly to avoid confusion, i hope I have a table with users, and every user has a specific latitude and longitude coordinate. let say user Test_User is logged in and then he decides he wants to … |
 | I've written a sales and inventory program in C# that makes use of SQL Server, because I've heard it functions well over LAN connections (haven't tried it yet). I've... let's say... hardwired the my connection string into the program. I have a notepad connection.ini file that has the connection string, …  |
| | please see this picture: [URL="http://www.irupload.ir/images/t03rzv61q36tmhnvic4.jpg"]http://www.irupload.ir/images/t03rzv61q36tmhnvic4.jpg[/URL] in this query instructor table is for register information teachers. how i can this query to statement in sql? thanks. |
| | So I have these two very basic tables. CODE PROJNAME ------------ -------------- 101 ProjectX 222 ProjectY 355 ProjectZ 973 ProjectAlpha ID NAME PROJCODE HOURS ----- ------------ -------------- ------------ 55055 Smith 101 20 55055 Smith 222 10 39002 Bob 973 25 00001 Preston 355 5 10000 Logan 355 5 00777 Bond … |
| | I was just wondering if it can or not. Otherwise wouldn't this code work great for stopping SQL injection? [code=php] $some_post = addslashes($_POST['some_post']); if (!ctype_alnum($some_post)) { //error } else { //all good } [/code] |
| | Is using php with MS SQL server over MySQL a good practise? Ive been using MySQL for quite sometime and what I like about it is that it is free. Are there any advantages of using MS SQL server over MySQL? Or any challenges. |
| | Greeting to all :) i wanted to store a selected option in to mysql database My senior said must in this format" option 1 option 2 option 3 I was stuck with this couple hours ago! i have think of nl2br but i'm not familiar with it Can anyone help? … |
| | HI,anyone know how to check every single record that we have been inserted in sql server?either exist or not..please help. |
 | I noticed in the Advanced Properties of the connection string dialog, there is a setting for AttachDbFilename (see picture attached). The question is, in this case, the file resides on the E:\ drive of my local system. When the application is finished and deployed, will my application's connection string still … |
 | Hello, I have a query, that I am trying to have a conditional statement for a variable that I will pass into the query. If I use one of the conditions it works, but if I try both I can't get it to work. I would appreciate any help. Thanks, … |
| | Dear all i have created a from to receive data from users. and data will store in sql table. all is going well. BUT NOW i have installed a module so users can type in Hindi fonts to fill details in form. when users will type data in hindi font … |
| | I think I understand the general concept of how these files work, but I want to make sure, and ask a couple questions about them. Am I correct in thinking MDF files are "attached" to the SQL instance only as long as the application is running and are "detached" when … |
| | [LEFT]Hey guys. i am trying to insert data from a form to a sql database, but this error keeps coming up. [code]Incorrect syntax near ',' [/code] Here is the code. [code] Dim AddSwimmer_comm As New SqlCommand( _ "INSERT INTO [MasterRecords] ([APASCID], [FullName], [Gender], [DOB], [21m], [25m], [50m], [100m], [4x21m], [4x50m]) … |
 | hi i want to direct my website to different pages If there are competions that are active to show the page list of them else go to other page i tried this but no luck [CODE]<?php include_once "connect_to_mysql.php"; $extract = mysql_query("select * from tbl_competition WHERE fld_closed='N'"); while ($row = mysql_fetch_assoc($extract)) … |
| | hi, can i use count and top 6 in the same sql command ?? and also, how can i use inner joins to link guest id in reservation table with guest name from guest table |
| | Hi. I am doing a C# windows form application and I am using Ms Access for the database. I have a sql query which retrieves data from 2 tables and I am displaying it in a crystal report. The problem I am having is for example i have 4 records … |
| | Hi I'm not an asp .net developer although I have done web development with php and mysql, I'm more of a software developer for desktop and mobile devices. So this is my first big project with ASP .NET. I have a question with the ASPNETDB database, understand that the database … |
| | Dear knowledgeable ones A new problem have arisen. I have now an SQL database file with about 100 tables in it. I would like to automatically go through all of these tables and check if the column "Owner" exist. If this field does not exist, then it should be created … |
 | [B]is Codeigniter able to protect Your Site From sql injection When You Use Active Record??[/B]  |
| | Hello all. The Java Date and time classes are difficult. I think I have to use java.sql.Date which is a sub class of Date but is not a date unless the time is normalized to zero. so I've heard. I would like to work with my studentDOB first by collecting … |
| | I have the function pt_replace: [CODE]function pt_register() { $num_args = func_num_args(); $vars = array(); if ($num_args >= 2) { $method = strtoupper(func_get_arg(0)); if (($method != 'SESSION') && ($method != 'GET') && ($method != 'POST') && ($method != 'SERVER') && ($method != 'COOKIE') && ($method != 'ENV')) { die('The first argument … |
| | hi i have a question in reporting server. the server is started and when i try to go to the URL it doesn't give me anything my windows account does not have admin privileges is this the cause for this. and from MS SQL management studio when i try to … |
| | hi there, i am using a code to back (downloaded) up a database in a server and when i run the application it gives me an error saying operating system error 3 [CODE=C#] //Use this line if you have already created a bakup file. File.Delete(DBpath + "\\backup.bak"); this.Cursor = Cursors.WaitCursor; … |
| | Hi all, First-time poster and netadmin/infosec guy trying to get into coding. My company uses a SQL Server 2005 database to store customer information and the like, and I'm hoping to learn to interact with it programmatically so I can write and/or customize software to make life a bit easier … |
| | hi, i am doing a hotel reservation system and i don't know how to get the rooms available ! can some one help pls ? i have these tables: [ICODE][B][U][COLOR="Red"]tblRoom[/COLOR][/U][/B] ID--int RoomNo--int RoomType--int BedType--varchar(25) RatePerNight--money MaxNoOfPersons--int [COLOR="red"][B][U]tblReservation[/U][/B][/COLOR] ID--int GuestID--int DateOfReservation--datetime NoOfPersons--int RoomID--int ArrivalDate--datetime DepartureDate--datetime TotalCost--money CheckIn--bit (-this is set to … |
| | Hi, I'm attempting to use a Loop which uses an ICount of 1-9 in order to insert data into a database. The code is used for a website and when this page is loaded there are already values assigned to intProductIDSelected1, intProductIDSelected2 etc so I am attempting to use ICount … |
| | hi there, i have a question in connecting to the server. when i log in to the server and connect to the ms sql server i can connect to the databases. but when i login to another computer and try to login to the MS SQL server management studio i … |
| | This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from … |
The End.