vb and oracle connection

Dim Oracon As ADODB.Connection
Dim recset As New ADODB.Recordset
Dim objErr As ADODB.Error
Dim Message, Title, Default, EmpNoValue
Dim EID As Integer, EName As String, EHeight As Integer
Dim EEmail As Strin, EWeight As Integer, EBloodType As String

i = 0
On Error GoTo err_test
Set Oracon = CreateObject("ADODB.Connection")
Oracon.ConnectionString = "Provider=OraOLEDB.Oracle;" & "Data Source=sigma;" & _
"User ID=sigma;" & "Password=sigma;" & "PLSQLRSet=1;"
Oracon.Open
Set recset = New ADODB.Recordset
recset.Open "EMPLOYEES", Oracon, adOpenDynamic, adLockOptimistic
With recset
If Not (.BOF And .EOF) Then
While Not .EOF
EID = recset.Fields("employeeid").Value
EName = recset.Fields("employeename").Value
EHeight = recset.Fields("height").Value
EEmail = recset.Fields("email").Value
EWeight = recset.Fields("weight").Value
List1.AddItem EID & " " & EName & " " & EHeight & " " & EEmail & " " & EWeight
.MoveNext
Wend
End If
recset.Close
End With
Exit Sub
err_test:
MsgBox Error$
For Each objErr In Oracon.Errors
MsgBox objErr.Description
Next
Oracon.Errors.Clear
Resume Next
End Sub

Making Report Using JSP

U can generate a report in servlet . Simpley u execute the query in servlet and print the resultset in servlet.using printWriter object. Now the output will come in html format.

if u want the same output in excel then put

response.setContentType("application/vnd.ms-excel");
for pdf output put

response.setContentType("text/pdf");

Don't use jsp directly to display a report as it may print some unwanted comments.

Otherwise u can go 4 some reporting tools like jasperreport ,ireport or pentaho reports

all these are open source tools so u can download them

Only u have to learn how to make reports using these tools

try pentaho.org

binding dynamic accordian pane in asp.net

Design page for VS2008

<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

        </asp:ToolkitScriptManager>

        <asp:Accordion ID="Dynamic" runat="server" SelectedIndex="0"HeaderCssClass="headerAccordion" ContentCssClass="contentAccordion">

        </asp:Accordion>

Design page for VS2010

<asp:ScriptManager ID="ScriptManager1" runat="server">

        </asp:ScriptManager>      

        <asp:Accordion ID="Dynamic" runat="server" SelectedIndex="0"HeaderCssClass="headerAccordion" ContentCssClass="contentAccordion">

        </asp:Accordion> 

Add below line for css within <title></title>

<link href="Styles/accordion.css" rel="stylesheet" type="text/css" />

Add below line for css within

(you will get at attachment)
Code Behind
Retrieve value and put at datatable like below
string sql1 = "select * from Admin_Package_Details where Pak_Type='" + b + "'";
SqlConnection con = new SqlConnection(GetConnectionString());
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
Now create dynamic accordion pane based on value with pane title
int i = 0;
for(i=0;i
function printing() {
window.print();
}

Now you can add link button with querystring like below
string a = lbTitle.Text;
string url = "querystring.aspx?";
url += "Item=" + a.ToString();
LinkButton lk;
lk=new LinkButton();
lk.Text="Booking";
lk.PostBackUrl = url;
add link button at accordion pane like below
pn.ContentContainer.Controls.Add(lk);

datatable filter using linq in asp.net c#.net

I go through lots of site for select query on DataTable. But most of the time I did not get a suitable solution. So, at last I use linq to filter data from datatable. So I share my code below:-



DataTable dt = new DataTable();
string sqlStatement1 = "select * from hsswith_view where cp_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "' or ep_amount<='" + bug_amount + "' and no_of_days >='" + no_of_days + "'";
SqlCommand sqlCmd1 = new SqlCommand(sqlStatement1,connection); SqlDataAdapter sqlDa1 = new SqlDataAdapter(sqlCmd1);
sqlDa1.Fill(dt1);
var query = from r in dt1.AsEnumerable()
where r.Field("pax") == no_person
select new
{
entry_id = r["entry_id"].ToString(),
pax = r["pax"].ToString(),
package = r["package"].ToString(),
no_of_days = r["no_of_days"].ToString(),
cp_amount = r["cp_amount"].ToString(),
ep_amount = r["ep_amount"].ToString()
};
GridView1.DataSource = query;
GridView1.DataBind();


First of all I select data using one select query and fill it at datatable(dt1). Now I write linq query to extract data from dt1 DataTable and bind the values at GridView. These much.

Creation of database using oracle.

Creating a Database Manually
• Decide on a unique instance and database name
• Choose a database character set
• Set the operating system variables
• Edit / Create the initialization parameter file
• Start the instance (nomount)
• Execute the CREATE DATABASE command
• Run scripts to generate the data dictionary and
accomplish post creation steps

Preparing the Parameter File
• Create the new initSID.ora

A Sample PFILE initdb01.ora

# Initialization Parameter File: initdb01.ora
db_name = db01
instance_name = db01
control_files = ( /u03/oradata/db01/control01db01.ctl,
/u03/oradata/db01/control02db01.ctl)
db_block_size = 4096
db_block_buffers = 500
shared_pool_size = 31457280 # 30M Shared Pool
db_files = 1024
max_dump_file_size = 10240
background_dump_dest = /u05/oracle9i/admin/db01/bdump
user_dump_dest = /u05/oracle9i/admin/db01/udump
core_dump_dest = /u05/oracle9i/admin/db01/cdump
undo_management = auto
undo_tablespace = undtbs

• Modify the initSID.ora by editing the
parameters

Starting the Instance
• Connect as SYSDBA to an idle instance
• Start the instance in NOMOUNT stage

SQL>STARTUP NOMOUNT

DATABASE CREATION SCRIPT

create a text file and name it as newdb.sql type the following in it

create database db01
logfile
GROUP 1 ('/u01/oradata/db01/log_01_db01.rdo') SIZE 15M,
GROUP 2 ('/u01/oradata/db01/log_02_db01.rdo') SIZE 15M,
GROUP 3 ('/u01/oradata/db01/log_03_db01.rdo') SIZE 15M
datafile '/u01/oradata/db01/system_01_db01.dbf' SIZE 100M
undo tablespace UNDO
datafile '/u01/oradata/db01/undo_01_db01.dbf' SIZE 40M
default temporary tablespace TEMP
tempfile '/u01/oradata/db01/temp_01_db01.dbf' SIZE 20M
extent management local uniform size 128k
character set AL32UTF8
national character set AL16UTF16;

execute the script as

SQL>@newdb.sql

execute the catalog.sql script in the $ORACLE_HOME/admin directory to populate the data dictionary tables.

Now Your DATABASE IS READY TO USE

Php Form Validation Tutorial

This contact us form requires four input :
• sender name
• sender email
• message subject
• message body
In button online event put “return checkForm();”
The code snippet below shows the client part of contact form.

function checkForm()
{
var cname, cemail, csubject, cmessage;
with(window.document.msgform)
{
cname = sname;
cemail = email;
csubject = subject;
cmessage = message;
}

if(trim(cname.value) == '')
{
alert('Please enter your name');
cname.focus();
return false;
}
else if(trim(cemail.value) == '')
{
alert('Please enter your email');
cemail.focus();
return false;
}
else if(!isEmail(trim(cemail.value)))
{
alert('Email address is not valid');
cemail.focus();
return false;
}
else if(trim(csubject.value) == '')
{
alert('Please enter message subject');
csubject.focus();
return false;
}
else if(trim(cmessage.value) == '')
{
alert('Please enter your message');
cmessage.focus();
return false;
}
else
{
cname.value = trim(cname.value);
cemail.value = trim(cemail.value);
csubject.value = trim(csubject.value);
cmessage.value = trim(cmessage.value);
return true;
}
}
function trim(str)
{
return str.replace(/^\s+|\s+$/g,'');
}
function isEmail(str)
{
var regex = /^[-_.a-z0-9]+@(([-_a-z0-9]+\.)+(ad|ae|aero|af|ag|
ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|
bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|
ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|
dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|
gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|
hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|
kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|
ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|
mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|
nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|
re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|
su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|
ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|
zm|zw)|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i;

return regex.test(str);
}

Insert Data into mysql database using php tutorial

Inserting data to MySQL is done by using mysql_query() to execute INSERT query.

include 'library/config.php';
include 'library/opendb.php';

mysql_select_db($mysql);
$query = "INSERT INTO user (host, user, password, select_priv, insert_priv, update_ priv) VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y', 'Y')";

mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

include 'library/closedb.php';