2,569 Topics
 | |
 | i have the following code [CODE] Dim i As Integer i = Me.GridDomains.CurrentRow.Index Me.lbdomainid.Text = GridDomains.Item(0, i).Value [/CODE] when i have complied it in visual studio 2010 (debug) i get a error saying system.data.sqlclient.sqlexceptions conversion faild when converting varchar value LBdomainID to data type int. in sql the datatype is … |
| | Dear All , I need to backup the sql server 2005 express database . It works fine if I make backup to specific folder"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup" . But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. " … |
| | I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a … |
| | Hi Guys, Not sure if this is a php or sql problem but i keep getting the following error when trying to update a row using php and 'UPDATE': ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right … |
| | I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can …  |
| | Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they … |
| | Hi, I am new to ASP.NET and i have been thrown into the deep end on a project, the person who created this code is no longer available. The website allows an Admin to login and edit, update or delete information in an SQL database referring to PDFs located on … |
 | I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can … |
| | Hey guys i d like to pick your brains about something.. Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc.... Which way would be better? 1 ------ Create a Basictable with all the common fields (like ProductName, Price,Guarantee....) and then create multiple … |
| | i have the following code which works fine where there is data in the table. when the table is empty and there is no data in the @Ctotal varible i get my error MessageBox.Show("Unable to get Claim Total") is there anyway i can ignore this if there isn't a value … |
| | i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be … |
 | I've searched & searched and haven't figured it out, any help is great! I need to display certain fields from my table, right now it only displays the first row of the table. I need to display all rows in the table. Code I have right now [CODE]$query = "SELECT …  |
| | i am trying to write a SP that will return a value in vb.net here is my SP CREATE PROCEDURE ClaimTotal @Ctotal BIGINT output AS select SUM(total) from claim where @ctotal = total I want to SUM my total coloum from my table claim, and store this in a varible …  |
| | Hi, I'm quite new with Data Adapter on VB.NET. I'm having a problem with retrieving data on different tables. Example database: [QUOTE][B]BookInfo[/B][INDENT]BookID: HSD993Z Title: Introduction to SQL[/INDENT] [INDENT]BookID: LDJA293 Title: Advance Computer Programming[/INDENT] [INDENT]BookID: KSKL194 Title: Object Oriented Programming[/INDENT] [B]StudentInfo[/B] [INDENT]StudentID: 2938485 FullName: Michael Zip[/INDENT] [INDENT]StudentID: 2949284 FullName: Ray Williams[/INDENT] … |
| | I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can … |
| | my code is working fine, but the output shows for example 12345.000 i would like to only show the data before the .000 is this posible? [CODE] Private Sub GetCurrentJanVOL() Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString = "Data Source=" & ServerV & ";Initial Catalog=" … |
| | [ICODE]<html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>PicNet Table Filter Demo</title> <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.3.2.min.js" type="text/javascript"></script> <script type="text/javascript" src="picnet.table.filter.min.js"></script> <script type="text/javascript"> $(document).ready(function() { // Randomly Create Data Rows for (var i = 0; i < 50; i++) { var tr = $("<tr>" + "<td>Value" + Math.floor(Math.random() * 500) + "</td>" + "<td>" + Math.floor(Math.random() * … |
| | Hi, how do i do this:- The dyndns that allows Admin to get result from different location. No need to get the database over from another location, able to view the report and print. Using VB.net and SQL Server 2008 |
| | I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign … |
| | Hello, I have two DataGridViews in one window. The first one displays 2 columns, itemNo and task. When I click on a row in this grid, I want to populate the second grid with corresponding material. It is organized so that the itemNo in grid1 is 1, 2, 3, and … |
| | Hello experts, My doubt is pretty simple, I suppose. But still I need assistance. I have a registration form as ASP.NET web form. There are 5-6 fields in it (username, password, email id, sex, country etc. ). I want to enter all the data, entered by a new user in … |
| | Not sure if this is the right forum for SQL statement problems. I've searched all over but don't know how to output formatted SQL queries. Like Selecting the first letter of the first name and then last name with proper spacing. |
| | Hi, I'm having a problem on how to query from the following tables. Here are the tables. PATIENT: PK - PatientNo - FirstName - LastName - MiddleName - Address - Age FK - PageNo PAGE PK - PageNo BOOK PK - BookNo BOOKPAGE 'Junction Table PK - BookNo PK - … |
| | Hi people, I get an error when performing the following request: [CODE] $query=" SELECT * FROM vessel,cargo,customer ORDER BY ladate DESC WHERE vessel.id=cargo.id AND vessel.id=customer.id LIMIT $eu, $limit";[/CODE] it is about the ORDER BY ladate DESC Can you you show me where I should write ORDER BY in the correct … |
| | Hi i have been trying to get the results for the code below and i can't seem toget myself around it. I need to get the results according to the myKad and Student Name on How many times the student has answered Excellent, Satisfaction and Poor for each question, each … |
| | Okay, so I was originally having problems even saving the data, but I can now get it to stay in the dataset, and when I switch to another page it stays there when I go back to it. Although when I close the form and reopen it, the changed data …  |
| | This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, … |
| | Hello world, I need your help/advice, I have a table last_acces where inserting a few data. The table columns are: Id Name Date I want to export this data into excel clicking on the link or button from the page. Anyone could help me on this please? The action will … |
| | in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.  |
| | Can anyone tell me whats wrong with this code? It throws this exception: A call to PInvoke function 'Web!Web.SQLiteBase::sqlite3_open' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match …  |
| | I have two tables: CDDemographics and CBTechProviderData. Both have 200,000+ rows. A common column between these tables is CensusBlockID, of which the first 5 integers are the fips code - in this case I am defining that code as 55001. I am trying to sum the population of CensusBlockIDs where … |
| | I'm trying to run the following code but get a casting error. How can I rewrite my code to achive the same ? [CODE] boolResult= (bool?)dataReader["BOOL_FLAG"] ?? true; intResult= (int?)dataReader["INT_VALUE"] ?? 0;[/CODE] Thanks |
| | I have 2 tables, MPW1400 LeaseRecNo PropNo BldgNo UnitNo LeaseStartDate MPW1482 LeaseRecNo EffectiveDate AnnualAmount CertNo My Objective is to get the total of 'AnnualAmount' Where MPW1400.LeaseRecNo = MPW1482.LeaseRecNo and CertNo = '1' Example: MPW1400 ------------------------------------------------------- LeaseRecNo | PropNo | BldgNo | UnitNo | LeaseStartDate ------------------------------------------------------- 12345 | RG52 | 24 … |
| | Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a … |
| | I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get … |
| | hey there, I am doing testing to my site and i need to make over 60 rows to check paging. Is there any possible way to just copy rows over and over again? Thank you, |
 | |
| | Anyone want to help me with this SQL-code? [url]http://pastebin.com/VWnJmM34[/url] I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it? |
| | I want to develop application using PHP. One module in this application displays attendance of students under particular teacher, between given two dates. The structure of tables in database - 1. student_info(Roll_No, Teacher_Id, First_Name, Last_Name) 2. attendance_info(Teacher_Id,Roll_No,Date,Present) Present stores '1' if student is present on that date and '0' if … |
 | hi Everyone, My program is doing good when I suddenly bumped into this problem. I dont know how to do the next functionality that I need to accomplish. I am done with inserting values, showing the gridview etc and it works great. Now my problem is the update command. I … |
| | I have a combo box with a list of my customers, when a user selects a customer i have the customer code populate a label called LBcustomer. here is how i populate my combo box [CODE] Dim connString As String = "Data Source=" & ServerV & ";Initial Catalog=" & databaseV … |
| | Okay, So I'm currently working on my A2 computing project, and I am having slight difficulties updating and saving the data in my database when it is entered on a form in VB. I cannot find any reason why it wouldn't work, but if someone could suggest a better way … |
| | Hello Can someone please help me with getting a better understanding of dependency theory using Armstrong's Axioms? Thank you |
| | I'm a beginner PHP programmer, so sorry if I'm asking some silly question. I've set up a MySQL database with a table carrying a list of boolean values. I want the PHP page count the number of 'true' on a column (from the table) and display it as a single … |
 | We have migrated our application from an old system (32bit) to this new 64bit server running Sql Server 2008. The code has not changed but however we are getting an error when we are trying to pull data across from our ERP system. We have upgraded the odbc drivers to … |
| | hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, … |
| | Hi to all, I created following table and its view. [blue]create table employee(id integer, name varchar(20), age integer) create view Vemployee as select id, name from employee.[/blue] now I want to rename a view, so I wrote a query like [blue]rename view Vemployee to Pemployee[/blue] But, it shows error about … |
 | Hello peeps. I'm trying to update a sql table from mi php Ajax web page, which stores dynamically a table into the page by [icode]table.appendChild(row)[/icode], so that the user can verify the information he is inserting before the actual database update. How do I do this with ajax? |
| | Hi, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names. Schema A A.Customer A.Product A.Invoice Schema B B.Customer B.Product B.Incoive My first problem is actually configuring Replication on the publisher using the … |
 | Problem is based on C#, ADO.NET, using Access Database. I am trying to filter the results from the database and display them in DataGridView on click of 'button1' button. But the datagridview shows empty results when there are actually 3 records with matching conditions. According to what I know, the … |
The End.