<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
var db : String = "server=10.1.0.1;uid=sa;pwd=123;database=db";
var sql : String = " select * from table ";
var rs = SqlDataReader;
var conn : SqlConnection = new SqlConnection(db);
var cmd : SqlCommand = new SqlCommand( sql,conn);
try{
conn.Open();
rs = cmd.ExecuteReader();
if (rs.HasRows) {
//Founded.
} else {
//Not Found.
while(rs.Read()) {
Response.Write(rs["id"] .ToString());
}
}
rs.Close();
conn.Close();
}catch(e){
Response.Write("ERROR!");
}finally{
cmd.Dispose();
conn.Dispose();
}
%> < <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<%@import namespace="System.Data.SqlClient"%>
var db : String = "server=10.1.0.1;uid=sa;pwd=123;database=db";
var sql : String = " select * from table ";
var rs = SqlDataReader;
var conn : SqlConnection = new SqlConnection(db);
var cmd : SqlCommand = new SqlCommand( sql,conn);
try{
conn.Open();
rs = cmd.ExecuteReader();
if (rs.HasRows) {
//Founded.
} else {
//Not Found.
while(rs.Read()) {
Response.Write(rs["id"] .ToString());
}
}
rs.Close();
conn.Close();
}catch(e){
Response.Write("ERROR!");
}finally{
cmd.Dispose();
conn.Dispose();
}
%> < <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>