6,934 Topics
 | |
| | i wants to make a database for my school web site where students can select their class then enter their roll number then the result will show how can it possible like Select Class--->> Class Nursary to Class 10th (Drop down menu) Enter Your Roll number ---> Txt-box Submit then … |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Thank you Question: 1. (a)modify the addnames.php script to read in and store two fields of data – … |
| | I'm having some issues with this code: [CODE] Imports System.Data.SqlClient Public Class loginForm Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load '--Connection string to POS database Dim loginFormConnection As New SqlConnection("SERVER = localhost\SQLExpress; DATABASE = POS; INTEGRATED SECURITY = true;") '--Check to see if Windows Point …  |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Also i struggle in this questions as i do not get it fully(in fact i dont get what … |
| | Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Question 3. Write a script to search for the properties which match a postcode (call it search.php ). … |
 | I have a combo box which help me select SQL servers in my local computer, but now I want it to be able to select just any connected servers (like remote servers) as possible, how could I solve it??? [CODE] Sub server(ByVal str As String) con = New SqlConnection("Data Source=" … |
| | how can i connect sql server db in asp using c#? please give me an example |
| | Hi, I am having problems with deleting part of a record. The record has approximately 15 different fields, and I only wish to delete 3 of them using the following piece of SQL coding: DELETE [PMID 1], [PMName 1], [Price 1] FROM Subscriptions WHERE [Customer ID]="001" The code works absolutely … |
| | Hello programmers!. Please help me. :( I have here a combobx1 that has a value of Mr.A and Mr.B. want that if i choose from my combobox1 the selected value will go to my sql database.  |
| | String sQueryShow = "SELECT SUM(pf5_showplaylists.runningtime) FROM pf5_showplaylists WHERE pf5_showplaylists.showID = " + ShowID + ";"; HOW CAN I GET THE RESULT OF THIS SQL STATEMENT INTO A VARIABLE SO COULD DISPLAY THE OUTPUT IN A MESSAGE BOX? (URGENT, REALLY URGENT..) |
| | Hi all I am trying to enter data into textboxes which will then store the data entered into a database. When I debug everything starts but when I click Add, the database stays the same. I think I might be missing something in my code. Any help is appreciated. [CODE] …  |
| | |
| | Hello all, I am new to python and working on a school project to import an SQL query with python and have it print out results then save them to a file location. This is what I have so far and wanted to know what I am missing or if … |
| | Hello. I'm currently coding a customer/product/etc registration site and there's this problem I just kinda can't figure out even after searching around on the web. The DB consists of 8 tables User (for login handling) Customer (for customer registration) Product (for product registration) ProductCategory (for product category registration) Cleaning (for … |
| | I am working with a database application and am currently having a problem in joining the tables.. Table 1 : Materials -- Columns (item_code PK,item_name,p_rate,n_rate) Table 2 : Projects -- Columns (proj_id PK,proj_name,etc,etc) Table 3 : Proj_Mat -- Columns (id PK,item_code FK,proj_id FK,qty) Here Proj_Mat works as the bridge table.. … |
| | Hello every one, I have a question about creating users in Oracle using SQL*PLUS. But what I want to do is write the syntax in a txt file first (script) then when I run the script by calling it using the @ or by copy/past it should prompt me for … |
| | Hello, I have this multiple checklist and I cannot figure out how to enter the checked values into the database. The table is called "colors" and the column name is "color" and is of type "text". add_color.php [CODE] <?php // connect to database require "mysql_connect.php"; ?> <?php // get value …  |
| | Hello everyone, assuming i want to write some values into my database of choice i found two ways to do this. [CODE] my $sql = "INSERT INTO table (foo, bar, foobar) VALUES (?, ?, ?)"; my $sth = $dbh->prepare($sql); foreach(sort keys %hash) { $sth->execute($_, $hash{$_}, $some_other_value); } [/CODE] as opposed … |
| | Well something is missing of me (again :P) and I need some help.. I am trying to get files for my database and load it into comboBox. But for some reason I get systax error.. As I mention into other post I am not familliar with VB so please check … |
 | Hello Guys, I hope you are all doing fine. I have a Linq to SQL problem. My entity class is as follows; [CODE]using System; using System.Data.Linq; using System.Data.Linq.Mapping; namespace SilverlightGrid.Web.TableMappings { [Table(Name = "Travel_Meal")] public class Travel_MealDetails { [Column(IsPrimaryKey = true)] public Guid MealID { get; set; } [Column(Name = …  |
| | why is it sometimes i get an error? it doesn't highlight the error [B]CODE[/B] [CODE]Dim SqlQuery As String = "Select UserName from Login" Dim SqlAdapter As New MySqlDataAdapter Dim SqlCommand As New MySqlCommand Dim Ds As New DataSet Dim i As Integer With SqlCommand .CommandText = SqlQuery .Connection = sConnect … |
| | how to create crystal report using sql quary in vb.net step by step. |
| | Hello Every one can any body help me how to start with ssrs(sql serevr reporting service ??how to isntall and configure it.. I have SQL server 2005 installed on my machine.. Thnaks |
| | Hi to all, I want to pass the below statement to a report... Kindly help me how to do it ... select a.po_number,a.mr_number,b.item_code,c.item_desc, b.qty,b.rate from po_head a,po_detail b,item_master c where a.mr_number=b.mr_number and b.item_code=c.item_code and po_number = ' & combopo.text & '; kindly help...  |
| | When Creating a query using the sear Criteria Builder . I keep getting the error : " The schema returned by the new query differs from the base query " I no this means that the error is due to the query attempting to return too little columns i have …  |
| | please help me on my school project it is called "faculty evaluation system" my project is used to evaluate faculty members,i will use the following softwares, visual basic 2008 editon, ms sql server 2000, and crystal reports, what i want to do is their will be a question and it … |
| | hi every 1 i am trying to copy stored Employee id and i want to show it on a customer registration form. Basically i want to show which employee severd which customer. below is my code could you plz check or modify it thanks Dim Con As New SqlConnection Dim … |
 | Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data … |
| | Hello people,I hope everyone is well. I am having problems with my connection string. It seems its not detected at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE] ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["DataConnect"]; string connection = settings.ConnectionString; DataContext dataContext … |
| | Can Anyone tell how to convert String datatype 2 timestamp using altercommand in oracle  |
| | Good day!. I have here a SQL database named Database1 and it has a tables (StudentID, Student name, Age, Gender,) vb.net and i want that if i input a records in vb.net it automatic save to sql database. Help me please. |
| | Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in … |
 | gents please help on the following. I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt. My question is: How can I save this dt … |
| | Hi, I'm using asp.net together with vb.net. I am trying to develop: 1. a login page in asp.net, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and … |
| | hi, I am currently making a website and was wondering how to make it so that when a button is clicked it will update a field in the database by +1. This is sort of a 'like' system for photos so someone can view a photo and then press this … |
| | Hi i have created oracle database with 100 tables. Now i want to replicate the same data, indexes,triggers and everything into sql server2008 without using any third party tool and scripts.I should use either Query or C# code. Can u please help me to get a good solution? Bunch of … |
| | [CODE]insert into po_detail (item_code,qty,item_rate,item_tax) select a.item_code,qty,item_rate,item_tax from mr_detail a,mr_head b where a.mr_no = " & combo_mr_no.Text & " and a.mr_no=b.mr_no""[/CODE] what's the error in the above code ?  |
| | Below dynamic query will set StartDate and EndDate to 1st of March to 30th April as UK financial year. DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12), getDate() ) - datePart(d,DATEADD( mm, -(((12 + DATEPART(m, getDate())) - 4)%12),getDate() ))+1 … |
| | Hello people,I hope everyone is well. I am having problems with my connection string. It seems its not detected at all. I am designing a Silverligtht app with a Linq to SQL connection for the data. Here is my code.[CODE] ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["DataConnect"]; string connection = settings.ConnectionString; DataContext dataContext … |
| | Well, when almost finishing this tutorial: [INDENT][/INDENT][url]http://msdn.microsoft.com/en-us/library/ff677562.aspx[/url] I found a problem on connecting the Add-in to the database, and so the lobInstance can´t be opened: [url]http://i.stack.imgur.com/AFzie.png[/url] This is the error code. (in fact the error message was being popped out when the Excel 2010 client starts, but I commented the … |
| | I want to manually test my sites to check if they are secure against SQL injections. Whats a good way to attempt it. How do I get started? thank you |
| | Hello, I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? Could anyone list out the steps that should be performed. I saw the concept of … |
| | Hello people, I hope everyone is well. I have just started learning silverlight and retrieving data through Linq to SQL. I have a problem with retrieving certain coulums from the table. I can retrieve through an object that retrieves all the columns but I don't want this. i managed to … |
| | Hi, I recieve the following error message: "java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression'name '" when I run this statement: [CODE] sql = "INSERT INTO empDetail VALUES("; sql += txtName.getText()+ ", "; sql += "'" + txtAddress.getText()+ "', "; sql += "'" + txtSuburb.getText()+ "', …  |
| | In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that … |
| | Hi everybodies! How increase ProductId inside Product_Table when insert a new product according to following approach? Language_Table: Id Code --------- --------- 1 ka 2 en Product_Table: ProductId ------------- 1 2 Product_Translation_Table: TranslationId Title ProductId LanguageId -------------- ------------------- ------------- ------------ 1 Kompiuteruli 1 1 2 Computer 1 2 3 Radio 2 …  |
| | Hi all, first post here, please excuse the newbieness!! I am a complete and total beginner to web development in all forms other than mediocre HTML and CSS. Please be gentle and use small words!! :-) I have recently installed Microsoft's Visual Web Developer 2010 Express in order to have … |
| | I have two relation table and I've made a php sql query out of it ... What I need is to insert the sql result into a new database table... Anyone ? this is my code [CODE]<?php $con = mysql_connect("localhost","sample","sample"); if (!$con) { die('Could not connect: ' . mysql_error()); } … |
| | The problem is that it will show 2 the same result but with different employee fname. How to have something like this . "Employee.employee_id has employee.fname " It will show also lots of result if I will not use distinct. Select distinct TRANSACTION.TRANSACTION_ID ,CUSTOMER.FNAME ,CUSTOMER.LNAME,PET.PNAME,Employee.Emp_ID,Employee.fname,TRANSACTION.DATESTART,TRANSACTION.DATEEND from(TRANSACTION) INNER JOIN CUSTOMER ON … |
| | Hello Friends, I am messed up with the below query [CODE] Try Dim myCommand As OleDbCommand myCommand = New OleDbCommand("select sum(tmt.total) as Total from Appointment appt, TreatmentMaster tmt where appt.patientid='" + txtPatIDBill.Text + "' and [tmt].[treatid]=[appt].[treatmentid] and (Format([appt.ApptDate], 'Short Date')) between '" + dtpFromBill.Value.Date + "' and '" + dtpToBill.Value.Date … |
The End.