BaxterWoofus

	How to set parameters for SqlDataSource UpdateCommand 11 Years Ago 11 Years Ago Share on Facebook Share on Twitter Share on LinkedIn For a Gridview: I am trying to use a stored procedure for the first time in a SQLDataSource for the UpdateCommand: <asp:SqlDataSource ID="TECT_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:OracleConnectionString %>" ProviderName="<%$ ConnectionStrings:OracleConnectionString.ProviderName %>" SelectCommand="SELECT MPID, User_Id, Last_Name, First_Name FROM Scripts.vw_Tect_Exam" UpdateCommand="P_TECT_UPD_EXAM_ID" UpdateCommandType="StoredProcedure"> <UpdateParameters> <asp:Parameter Name="MPID" Type="Int32" /> <asp:Parameter Name="User_Id" Type="String" /> </UpdateParameters> </asp:SqlDataSource> … Web Development asp.net gridview procedure sqldatasource 0 1 2K
	Access/Pass variable between windows form and DataSet TableAdapter SQL where clause 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that … Web Development asp.net dataset rdlc report-viewer table-adapter winform 0 2 222
	Using a parameter in a DataTable - ORA-01008: not all variables bound 12 Years Ago 12 Years Ago Share on Facebook Share on Twitter Share on LinkedIn Environment: Visual Studio 2010, Windows Forms Application, Oracle Database I am trying to use a parameter in a DataSet.xsd DataTable. The query and parameter work fine in Query Builder but gives an error if I try "Preview Data" or use in my application. Error: An unhandled exception of type 'System.Data.OleDb.OleDbException' … Web Development asp.net 0 1 87