This shows you the differences between two versions of the page.
|
csharp_net:sql_select [2009/07/15 02:00] 127.0.0.1 external edit |
csharp_net:sql_select [2011/10/18 14:37] (current) laurosoto |
||
|---|---|---|---|
| Line 18: | Line 18: | ||
| <%@ PAGE LANGUAGE=C# %> | <%@ PAGE LANGUAGE=C# %> | ||
| - | |||
| <%@ Import Namespace="System" %> | <%@ Import Namespace="System" %> | ||
| - | |||
| <%@ Import Namespace="System.Data" %> | <%@ Import Namespace="System.Data" %> | ||
| - | |||
| <%@ Import Namespace="System.Data.OleDb" %> | <%@ Import Namespace="System.Data.OleDb" %> | ||
| - | |||
| <FORM RUNAT=SERVER> | <FORM RUNAT=SERVER> | ||
| - | |||
| CLAVE A BUSCAR<ASP:TEXTBOX ID=CLAVE SIZE=3 RUNAT=SERVER/> | CLAVE A BUSCAR<ASP:TEXTBOX ID=CLAVE SIZE=3 RUNAT=SERVER/> | ||
| - | |||
| <ASP:BUTTON ONCLICK=BUSCAR TEXT=BUSCAR RUNAT=SERVER /><BR> | <ASP:BUTTON ONCLICK=BUSCAR TEXT=BUSCAR RUNAT=SERVER /><BR> | ||
| - | |||
| <ASP:DATAGRID ID=TABLAGRID RUNAT=SERVER | <ASP:DATAGRID ID=TABLAGRID RUNAT=SERVER | ||
| - | |||
| Width=400 | Width=400 | ||
| - | |||
| BackColor=#ccccff | BackColor=#ccccff | ||
| - | |||
| BorderColor=black | BorderColor=black | ||
| - | |||
| ShowFooter=false | ShowFooter=false | ||
| - | |||
| CellPadding=3 | CellPadding=3 | ||
| - | |||
| CellSpacing=0 | CellSpacing=0 | ||
| - | |||
| Font-Name=Verdana | Font-Name=Verdana | ||
| - | |||
| Font-Size=8pt | Font-Size=8pt | ||
| - | |||
| HeaderStyle-BackColor=#aaaadd | HeaderStyle-BackColor=#aaaadd | ||
| - | |||
| EnableViewState=false | EnableViewState=false | ||
| - | |||
| /> | /> | ||
| - | |||
| </FORM> | </FORM> | ||
| - | |||
| <script runat=server> | <script runat=server> | ||
| - | + | // creando y cargando coneccion, adpter, dataset como variables globales | |
| - | // creando y cargando coneccion, adpater, dataset como variables globales | + | |
| OleDbConnection coneccion; | OleDbConnection coneccion; | ||
| - | |||
| DataSet tabla; | DataSet tabla; | ||
| - | + | OleDbDataAdapter adapter; | |
| - | OleDbDataAdapter canal; | + | |
| void BUSCAR (Object sender, EventArgs e) | void BUSCAR (Object sender, EventArgs e) | ||
| - | |||
| { | { | ||
| - | + | coneccion = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\sites\\www28\\laurosoto\\db\\mibase.mdb"); | |
| - | coneccion=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\progfacil\\lauro\\mibase.mdb"); | + | string q="select * from tabla1 where clave = @CLAVE"; |
| - | + | adapter=new OleDbDataAdapter(q, coneccion); | |
| - | string q="select * from mitabla where clave = @CLAVE"; | + | adapter.SelectCommand.Parameters.Add(new OleDbParameter("@CLAVE", OleDbType.Integer)); |
| - | + | adapter.SelectCommand.Parameters["@CLAVE"].Value = CLAVE.Text; | |
| - | canal=new OleDbDataAdapter(q, coneccion); | + | |
| - | + | ||
| - | canal.SelectCommand.Parameters.Add(new OleDbParameter("@CLAVE", OleDbType.Integer)); | + | |
| - | + | ||
| - | canal.SelectCommand.Parameters["@CLAVE"].Value = CLAVE.Text; | + | |
| // creando el dataset y cargandolo | // creando el dataset y cargandolo | ||
| - | |||
| DataSet tabla= new DataSet(); | DataSet tabla= new DataSet(); | ||
| - | + | adapter.Fill(tabla, "tabla1"); | |
| - | canal.Fill(tabla, "mitabla"); | + | |
| // cargando el datagrid | // cargando el datagrid | ||
| - | |||
| TABLAGRID.DataSource=tabla; | TABLAGRID.DataSource=tabla; | ||
| - | + | TABLAGRID.DataMember="tabla1"; | |
| - | TABLAGRID.DataMember="mitabla"; | + | |
| TABLAGRID.DataBind(); | TABLAGRID.DataBind(); | ||
| - | |||
| } | } | ||
| - | |||
| </script> | </script> | ||
| Line 109: | Line 69: | ||
| TAREAS PROGRAMACION C# NET | TAREAS PROGRAMACION C# NET | ||
| - | 1.- hacer programas de busquedas para las bases hechas | + | 1.- hacer programas de busquedas para las bases hechas��� |