openkava

专注物流系统,企业信息化,进出口业务,会展,电子商务 目标:CIO 架构师
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

aspx最小代码连接数据库

Posted on 2008-06-26 12:40  openkava  阅读(3345)  评论(0)    收藏  举报
<%@ Page language="c#"  codePage="65001"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Web.SessionState" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %>
<%@ Import Namespace="System.Web.UI.HtmlControls" %>
<%@ Import Namespace="System.ComponentModel" %>
<%@ Import Namespace="System.Collections" %>
<%
//更新街道交叉口经纬度信息到数据库,如果没有,则插入,有则更新
// 用法: street1=华山路 & street2=衡山路 & lng=11111&lat=4444
System.Web.HttpContext context = this.Context;
System.Text.StringBuilder sb
=new System.Text.StringBuilder();
 context.Response.AddHeader(
"Prama","no-cache");
            context.Response.CacheControl
="private";
            context.Response.Expires
=0;
            
             context.Response.ContentType
="text/html";     
          
             
//获取参数
             string street1=Request["street1"];  
             
string street2=Request["street2"];
             
string lng        =Request["lng"];
             
string lat        =Request["lat"];
             
             
if(street1==null{street1="";}
             
if(street2==null{street2="";}
             
if(lng==null{lng="";}
             
if(lat==null{lat="";}
              
       
                     
//获取数据
             DataSet ds = new DataSet(); 
             
int r=0;
            
string  sql="";
            
string msgsuccess="操作成功<br/>";
            
string msgerror="不成功,没有记录<br/>";
            
string conn = "server=(local);database=callmeal;Uid=sa;Pwd=yyy;";
            SqlConnection con 
= new SqlConnection(conn);
            
             sql
=" select *  from street";  
             context.Response.Write(sql); 
             SqlCommand   _cmd
=new   SqlCommand(); 
             SqlDataAdapter da 
= new SqlDataAdapter(sql,conn);
             da.Fill(ds); 
             con.Open();                  
                _cmd.Connection 
=con;
                 
               //更新数据
                          sql
=" update street set lng=11 where streetid=1" 
                          _cmd.CommandText
=sql;
                        r
=_cmd.ExecuteNonQuery(); 
                   
if(r==-1
                        context.Response.Write(msgerror); 
                    
else
                        context.Response.Write(msgsuccess);  
                              
            con.Close();   
                       
         
          
//context.Response.Write(sql);
                      
//context.Response.Write(sb.ToString()); 
             context.Response.Flush();
            context.Response.Close();

 
 
%>