如何使用存储过程而不是transact sql帮助我？ [英] how to use stored procedure instead of transact sql help me ?

问题描述

我有2个班级



里面的头等舱这个方法

  public  DataTable GetRecords（ string 查询）
 
 {
 da =  new  SqlDataAdapter（Query，cnn）; 
 da.Fill（dt）; 
  return （dt）; 
 
} 

其中第二课这种方法

  public   void 查询（ ref  GridView gv）
 {
 dt = o.GetRecords（  SELECT TchrMiddleName，TchrLastName，Address，Mobile，Email，BirthDate FROM Teachers）; 
  //   dt = o.GetRecords（select * from Teachers）;  
 gv.DataSource = dt; 
 gv.DataBind（）; 
} 

我把这段代码放在aspx页面

  protected   void  Page_Load（对象发​​件人，EventArgs e）
 {
 teach.query（ ref  GridView1）; 
} 

_______________________

请帮助我，我想要使用存储过程而不是交易SQL代码将是什么？

解决方案

在sql server中创建存储过程然后将ff代码放在之间BEGIN 和 END 并将SP保存为'spGetDetails'

  SELECT  TchrMiddleName，TchrLastName，Address，Mobile，Email，BirthDate  FROM 教师

然后更换此部分：

  public   void  query（ ref  GridView gv）
 {
 dt = o.GetRecords（  SELECT TchrMiddleName，TchrLastName，Address，Mobile，Email，BirthDate来自教师）; 
  //   dt = o.GetRecords（select * from Teachers）;  
 gv.DataSource = dt; 
 gv.DataBind（）; 
} 

with：

  public   void 查询（ ref  GridView gv）
 {
 dt = o.GetRecords（  spGetDetails ）; 
  //   dt = o.GetRecords（select * from Teachers）;  
 gv.DataSource = dt; 
 gv.DataBind（）; 
} 

谷歌是你最好的朋友。



Goodluck！

Eduard，

您需要在SQL Server数据库中编写存储过程，并可以在代码中调用它。请尝试以下方式致电：



在ADO中调用存储过程.NET [ ^ ]



通过存储过程插入和检索数据 [ ^ ]



希望它有所帮助：）

尝试：

 创建  PROC  GetInfo 
  AS  
  SELECT  TchrMiddleName，TchrLastName，Address，Mobile，Email，BirthDate  FROM 教师
  GO  

但是对于这么简单的程序，我真的不会打扰......

I have 2 classes

First class inside it this method

public DataTable GetRecords(string Query)

    {
        da = new SqlDataAdapter(Query, cnn);
        da.Fill(dt);
        return (dt);
    
    }

Second class inside it this method

public void query(ref GridView gv)
    {
        dt = o.GetRecords(" SELECT   TchrMiddleName, TchrLastName, Address, Mobile, Email, BirthDate FROM Teachers");
        //dt = o.GetRecords("select * from Teachers ");
        gv.DataSource = dt;
        gv.DataBind();
    }

And I put this code in the aspx page

protected void Page_Load(object sender, EventArgs e)
    {
        teach.query(ref GridView1);
    }

_______________________
help me please I want to use stored procedure instead of transact SQL what's the code will be?

解决方案

create a stored proc in sql server then put the ff codes between BEGIN and END and save SP as 'spGetDetails'

SELECT TchrMiddleName, TchrLastName, Address, Mobile, Email, BirthDate FROM Teachers

then replace this part:

public void query(ref GridView gv)
    {
        dt = o.GetRecords("SELECT TchrMiddleName, TchrLastName, Address, Mobile, Email, BirthDate FROM Teachers");
        //dt = o.GetRecords("select * from Teachers ");
        gv.DataSource = dt;
        gv.DataBind();
    }

with:

public void query(ref GridView gv)
    {
        dt = o.GetRecords("spGetDetails");
        //dt = o.GetRecords("select * from Teachers ");
        gv.DataSource = dt;
        gv.DataBind();
    }

Google is your best friend here.

Goodluck!
Eduard,

You need to write stored procedures in your SQL server database and can call that in your code. Try these for calling:

Calling Stored procedures in ADO.NET[^]

Insert and retrieve data through stored procedure[^]

hope it helps :)

Try:

CREATE PROC GetInfo
AS
 SELECT TchrMiddleName, TchrLastName, Address, Mobile, Email, BirthDate FROM Teachers
GO

But for such a simple procedure, I really wouldn't bother...

这篇关于如何使用存储过程而不是transact sql帮助我？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！