ayeshakhan

encountering this error while calling the insert stored procedure from plsql. STORED PROCEDURE: create or replace procedure WLLINSERT (p_WLLPACKAGEID NUMBER, p_WLLPACKAGECODE varchar2, p_WLLPACKAGENAME varchar2, p_WLLPACKAGEDESC varchar2, p_SDATE DATE default null, p_EDATE DATE default null, p_STATUS varchar2, p_BRANDID Number ) is begin insert into WLLPACKAGE (WLLPACKAGEID, WLLPACKAGECODE, WLLPACKAGENAME, WLLPACKAGEDESC, SDATE, EDATE, …

using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OracleClient; public partial class _Default : System.Web.UI.Page { OracleConnection objConn; OracleCommand objCmd; String strSQL; protected void Page_Load(object sender, EventArgs e) { String strConnString; strConnString = "Data Source=pcrm195;User Id=wllnew;Password=wllnew;"; objConn = new …

i want to connect plsql server with asp.net using C# and want to show data of server in grid view. using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OracleClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object …

how to import data from excel to sql database in temporary table and display it in grid using.net c#

i am using visual studio for making website using c# an error is occuring "There is already an open DataReader associated with this Command which must be closed" the code is public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Getregioncategory(); } public void Getregioncategory() …