Click here to Skip to main content
Page 1 of 2
Page Size: 10 · 25 · 50


Author filtered by: Chiranthaka Sampath [x]
ASP.Net with SQL Server Express 2008 by Chiranthaka Sampath
Answer 9 May 2013   license: CPOL
Its the sequence of the statements nothing else!
Question 9 May 2013   license: CPOL
I have created the following Stored Procedure in an SQL Server Express Instance. I am using Visual Studio 2010 Professional and SQl Server 2008 Express edition.USE [LeaveMgt]GO/****** Object: StoredProcedure [dbo].[LeaveApply] Script Date: 05/10/2013 02:06:31 ******/SET...
Question 8 May 2013   license: CPOL
I have created a a web form that has text box called 'txtEmpNo'. At that text box I only want to enter numbers. In other hand I want to restrict the content to numbers when enter A - Z that text box should not allow to do that!I use C#.Net with ASP.NetHow am going to solve that? I...
Answer 8 May 2013   license: CPOL
Ok guys I have successfully abled to use JQuery http://jquery.com/[^] so the problem was solved ! Thanks for the help anyway!
Question 7 May 2013   license: CPOL
I have added a calender control to myasp.net form and I disabled it using the visible property. But Iwant to visible true it when a textbox_textchanged and I did it as the below!protected void txtDtApp_TextChanged(object sender, EventArgs e) { clnDates.Visible =...
Question 5 May 2013   license: CPOL
I have created a web form with the login control. Now I want to validate the UserName & the Password with the data on a table in a SQL database (username & password as the fields of the table). I am new to ASP.Net & I need your help thanks.I am using VS 2010 .net Framework 4.0 in win 7...
Question 30 Apr 2013   license: CPOL
I have created an MSInfoPath 2010 Form using the 'Blank Form'. After designing the form I need to use this form in a ASP.Net page using C#. I have searched through the WWW to find out how to do that and found something in...
C# Global Variables Accessing by Chiranthaka Sampath
Question 7 Apr 2013   license: CPOL
I have created a class as the following it has one global variable. using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace LankaLab{ class dbConnect { public String strSuperPatID; public String...
C# Global Variables Accessing by Chiranthaka Sampath
Answer 7 Apr 2013   license: CPOL
But pal that didn't also solved my problem. I will state the question again with some more info!frmBldCuntDet class has the following variables and those use to generate a automatic patient id. Class - 01 public partial class frmFulBldCuntDet : Form ...
MS Access INSERT INTO Statement. by Chiranthaka Sampath
Question 7 Mar 2013   license: CPOL
There is an error at the following statement stating that "Syntax error at INSERT INTO statement". The code is at the below. OleDbComm.CommandText = @"INSERT INTO Full_Blood_Count ([PatID],[PatName],[PatAge],[PatAddress], ...
Answer 6 Mar 2013   license: CPOL
I found a nice article that solve my problem. Please refer the link I have posted at the below!Setting up Change Data Capture in SQL Server 2008http://www.techrepublic.com/blog/datacenter/setting-up-change-data-capture-in-sql-server-2008/1272[^]Thanks Chiranthaka
Question 6 Mar 2013   license: CPOL
When I am truing to insert data to MS Access Database Table using oledb 4.0 I found an errorThe statementprivate void btnPrint_Click(object sender, EventArgs e) { //Creating the Patient ID. intYear = DateTime.Now.Month; strYear =...
Question 14 Feb 2013   license: CPOL
I want to know that is there any option that I can use to track the updated or modified table records from the last log in of the database?
Question 13 Jan 2013   license: CPOL
I want to find one record that exists on a mysql database table using the following statement. The filteration is done using a textfiled. I am using Java & i don't use the JPA. Just simple mysql database connection with mysql connector.At the below I have pasted the whole java application....
Answer 5 Jan 2013   license: CPOL
The Correct MySQL statement is at below.sql = "INSERT INTO ITEMDETAILS(" + "ItemCode," + "ItemType," + "ItemSize," + "ItemName," + "ItemColour," + "InStock," +"ItemPrice)" + "VALUES(" + txtICode.getText() + ",'" + txtIType.getText() + "','" + txtISize.getText() + "','" +...
Question 5 Jan 2013   license: CPOL
When I am trying to insert data into a mysql database table I got the following error "Syntax error in your mysql statement near Values(". I don't know how to fix this matter. The source code is stated at the below. If you could please solve my problem!Thank You. private void...
Question 23 Dec 2012   license: CPOL
When I am using JInternalFrame where and how am I able to connect a MS Access database using a separate class? I already create a class as the following.import java.sql.*;import javax.swing.*;public class Connect {Connection conn = null;ResultSet rs = null;PreparedStatement pst...
Question 21 Dec 2012   license: CPOL
In VB.Net a package called System.Data.DataTable can be imported to a working form or to a class. But I tried this by doing C# like Using System.Data.DataTable gives me an error, saying "A using a namespace directive can only be applied to namespaces;'System.Data.DataTable is a type not a...
Question 20 Dec 2012   license: CPOL
When I was trying to create a report in VS 2008 using Crystal Report using MS Access Database (.accdb) I cannot find the Provider ACE.12.0.OLEDB provider from the provider list. But There is only the Jet.4.0.OLEDB PRovider. What is the problem in here?
Question 17 Dec 2012   license: CPOL
I have created an application that connects to an MS Access Database. But I have also used an another class that holds the database connection variables. it is as the followingusing System.Text;using System.Data.OleDb;using System.Data.DataTable;namespace Lanka_Lab{ public...
Question 17 Dec 2012   license: CPOL
1.) I have created an abstract class as the following. All the methods that belongs to the class is also added as at the following. public abstract class Vehicles { public String vRegNo; public String vModel; public String vBrand; public boolean hired; // This hired...
Question 29 Nov 2012   license: CPOL
I have created an inventory control & sales system for a local shoe showroom. One customer can buy one or more shoes at the same time. Each purchase must have a receipt to be issued as an invoice to the customer. At the same time the data will be saved in an MS Access database table. I have no...
Question 10 Oct 2012   license: CPOL
I have created 2 classes in java 1.StudVariables.Java - This contains all the variable that uses the private identifier. In here I have created all the get() & set() with relevant variables. In here I have used private identifier because I wanted to hide some...
Question 2 Oct 2012   license: CPOL
How I can able to stop the application after running 3 times in vb.net. I want to stop running the application after launching the application 3 times! But I cannot any coding for that in vb in the WWW.Please help me!
JavaScript within the PHP Script by Chiranthaka Sampath
Question 22 Sep 2012   license: CPOL
I have created the following php script with javascript using a text editor and to run the php file I used XAMPP. But when I run the file I got an error. I saved the PHP file with the .php extension. At the below I am inserting the source code and the error message please try to solve my...
JQuery Callender Controller! by Chiranthaka Sampath
Question 12 Sep 2012   license: CPOL
I created a form using HTML and JQuery but it didn't give me the result and I couldnot able to find an error in here. Please try to solve my question and my source code will be ststed at the below!
Question 8 Aug 2012   license: CPOL
At the bellow I have paste the source code that I have been developing but still I cannot get the correct output form both Mozilla Firefox & IE with newest versions.I also I have validate this using W3C validation service that had not given error on that! If you are able to have small time...
Question 21 Jul 2012   license: CPOL
I want to get records from a database table to an array which will be multidimensional or one dimensional. How can I do that?Thanx!
Question 8 Jul 2012   license: CPOL
I have a java server application. To execute that I need apache tomcat 7.0. But I have already installed XAMPP server that include both apache web server & apache tomcat server. But how can I mount my java web app to XAMPP's apache tomcat serve?I am using eclipse & vaadin as the framework!
Question 4 Jul 2012   license: CPOL
I type the following statement in SQL server 2008 to drop a foreign key.ALTER TABLE BOOK DROP FOREIGN KEY (FK_AUTHOR_NUMBER)But after executing the command I got the following error.Msg 156, Level 15, State 1, Line 1Incorrect syntax near the keyword...
Question 4 Jul 2012   license: CPOL
I have created several tables like stating at the below.CREATE TABLE AUTHOR(AUTHOR_NUMBER VARCHAR(6),LAST_NAME VARCHAR(25),FIRST_NAME VARCHAR(25), PRIMARY KEY (AUTHOR_NUMBER))CREATE TABLE BOOK(BOOK_CODE VARCHAR(6),TITLE VARCHAR(50),AUTHOR_NUMBER VARCHAR(6),PAPER_BACK BIT,BOOK_TYPE...
Question 20 May 2012   license: CPOL
When I am trying to create a table using SQL Server 2008 DataCenter Server R2 I cannot use the SQL 'Date' datatype for a Data Column but the query was executed with an error that giving the date format is not a available data type. It also not appeared at the table design. But when I refer some...
Question 2 May 2012   license: CPOL
I want to make an invoice for my sales system. I will state some info at the below! The report should have the following format.Invoice ID - 05523Purchase Date - 29/04/2012Item No Desc Qty Value 0056 Key Board 5 900 ...
Uploading a file in php by Chiranthaka Sampath
Question 22 Apr 2012   license: CPOL
Hi I have working on a php code that used to upload a file actually an image using a web form. But after successfully upload the image I have got an error message saying that'Notice: Undefined index: uploaded in C:\xampp\htdocs\test\addok.php on line 13The file has been uploaded, and your...
PHP Foreach in complex scenario by Chiranthaka Sampath
Question 16 Apr 2012   license: CPOL
I found a code snippet in PHP at one of the web sites. I will insert it at the below
Answer 23 Feb 2012   license: CPOL
Ok pals I got the solution by my self. The solution is mentioned at the bottom. echo ' javascriptfunction(); '?>
Question 22 Feb 2012   license: CPOL
After inserting a record to a MySQL database I want to view a message that the record adding is successful by not using .php but using JavaScript. I want to do that to view the message in the client's side i.e the web browser.
Uploading a file into FileZilla by Chiranthaka Sampath
Question 16 Feb 2012   license: CPOL
I have created the following .php form to upload a file to the locally installed XAMP server's FileZilla server.File Upload formFilename:
HTML Form with PHP action file. by Chiranthaka Sampath
Answer 30 Dec 2011   license: CPOL
I had solved the problem my self. Thanks guys!
HTML Form with PHP action file. by Chiranthaka Sampath
Question 30 Dec 2011   license: CPOL
I have created the following form and the .php code as follows but when I click the submit button there are not any errors but also there is no any output also. If you guys have the time please help me solve this problem.Note: I have used the XAMP to host my web pages in both HTML &...
Using JQuery Plugins by Chiranthaka Sampath
Question 29 Dec 2011   license: CPOL
When I want to add a Jquery plugin to my web site, have I to use the plugin's Javascript file & the JQuery Production or developemnt .js files. Can you guys why it is useful to use all that .js files?
Validate data using Javascript by Chiranthaka Sampath
Question 29 Dec 2011   license: CPOL
I have created a web page that contains 2 text boxes that allow to enter two dates and javascript is used to validate the two text boxes are that empty. The out put is not coming as it wishes!If the two text boxes are empty the javascript alert want work properly. I post the source code...
Question 28 Dec 2011   license: CPOL
How can I able to input a date from a JQuery calendar control to a textfield in an HTML web form?
How to use JQuery Plugins by Chiranthaka Sampath
Question 28 Dec 2011   license: CPOL
How can I able to use JQuery on my web site without installing it on my PC or Laptop?Am I able to use JQuery plugins in offline mode? Where can I able to download free JQuery plugins without any water marks?
Building and using a calender control by Chiranthaka Sampath
Question 28 Dec 2011   license: CPOL
I want to create a calender control using javascript, css and xhtml. Also I need to pass a date from that calender control to a text box in a html or xhtml web form.! I will create this web site use in an Intranet so that keep remind that I need an offline solution rather than an online solution...
Building and using a calender control by Chiranthaka Sampath
Answer 28 Dec 2011   license: CPOL
Hi JQuery is working perfectly.
Question 25 Dec 2011   license: CPOL
I have installed VB 2008 & Microsoft SQL Server 2008 DataCenter Edition on Windows 7 64bit.When I want to run the SQL Server I always have to run the SQLExpress database engine server and cannot run the MSSQLServer database engine. Also I cannot select that from using the "Browse for more"...
Viweing full date in the text-box by Chiranthaka Sampath
Question 16 Dec 2011   license: CPOL
I used a calender controller to insert a date to one of my forms used in ASP.Net. But the text-box shows the date as a short date. All I want is to display the date as a long date for better viewing.I used VB 2005 with ASP.Net 2.0
Setting DBMS Password by Chiranthaka Sampath
Question 12 Nov 2011   license: CPOL
UpdatedThi...
Question 29 Oct 2011   license: CPOL
I want store my database password externally in a text file. And when I want to connect to the database this password must be given in a form and verified from using that externally stored password I want this in vb 2005 and vb 2008 but not using C#Thanks!

Page 1 of 2
1 2


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid