I would like to ask: how to dynamically create stored procedures in asp.net (C #)?

iceeric

I know I can modify a stored procedure dynamically, but I don't know how to build a stored procedure dynamically?
Has anyone done it?

First post the code to modify the stored procedure as follows:

        string cStr = "Provider = Microsoft.Jet.OLEDB.4.0; Data source =" + Server.MapPath (DBPath);
        string ProcName;
        ADODB.Connection cn = new ADODB.Connection ();
        cn.Open (cStr, null, null, -1);

        // Activate and modify
        ADOX.Catalog catalog = new ADOX.Catalog ();
        catalog.ActiveConnection = cn;

        ADODB.Command cmd = new ADODB.Command ();
        cmd.CommandText = "PARAMETERS UserID varchar; select * from guestbook where username = UserID;";

        ADOX.Procedure pro = catalog.Procedures [ProcName];
        pro.Command = cmd;

苹果小刀

ExecuteNonQuery()

acidrain

It shouldn't be like yours. Look at this http://blog.csdn.net/net_lover/archive/2004/06/08/6963.aspx

iceeric

The following code can be created for practical use, but it is estimated that it is built in memory, and it is not visible in the query options of ACCESS.
The query entity named MyNewProName does not know how to move the stuff in memory to ACCESS.
Code:
//increase
string NewProName="MyNewProName";
ADODB.Command cmd1 = new ADODB.Command();
cmd1.CommandText = "PARAMETERS ArticleID long;select * from article where id=ArticleID;";

catalog.Procedures.Append(NewProName, cmd1);

iceeric

acidrain
   It shouldn't be like yours. Look at this http://blog.csdn.net/net_lover/archive/2004/06/08/6963.aspx
  
-----------------------
Thank you for your answer, but it still doesn't work. It's okay to build tables and libraries, but the stored procedure is different.
ADOX.Prucedure can't create a stored procedure object,
Such as: ADOX.Prucedure pro=new ADOX.Prucedure();
This will prompt an error.

Use this command: catalog.Procedures.Append(NewProName, cmd1);
It was executed, and a stored procedure was successfully added, but it was not seen in the query options of ACCESS.
depressed.