Search DaniWeb - oraclecommand

OracleCommand Object in C# brings back 1 less row 9 Years Ago by G_Waddell … C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing… Re: OracleCommand Object in C# brings back 1 less row 9 Years Ago by pritaeas Show your code. Re: OracleCommand Object in C# brings back 1 less row 9 Years Ago by jwenting You're either looping through the results incorrectly or you're connecting to a different schema where there's a different number of rows to be returned. Any other possible options are so remote they're not worth considering. Re: OracleCommand Object in C# brings back 1 less row 9 Years Ago by Cesc_1 ... or you haven't commit the last insert; it usually happens when debugging even to experimented programmers!!! Executing Several SqlCommands in a Single OracleConnection 13 Years Ago by Behseini …empno from emp"; // Create the OracleCommand OracleCommand cmd = new OracleCommand(cmdQuery); cmd.Connection = con; cmd.CommandType…// Create the OracleCommand OracleCommand cmd = new OracleCommand(cmdQuery); // Create the Second OracleCommand OracleCommand cmd = new OracleCommand(cmdQuery2); // … Need help on how to if record exists update else insert 7 Years Ago by mldardy … conn = new OracleConnection(); // C# conn.ConnectionString = strConnection; conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "INSERT.... ...... cmd.ExecuteNonQuery… Zk SDK -error 1053: the service did not respond in a timely fashion 3 Years Ago by George_38 … Checkifexist(OracleConnection ora, string EnrollNum, DateTime dt, DataTable All_data) { OracleCommand oracmd = new OracleCommand(); OracleDataReader DR; DataTable dt1 = new DataTable(); string d; foreach… : System.NullReferenceException: Object reference not set to an instance of an object 13 Years Ago by ayeshakhan …WLLPACKAGE"; OracleDataReader dtReader; objCmd = new OracleCommand(strSQL, objConn); dtReader = objCmd.ExecuteReader();…Item.ItemIndex]+"'"; objCmd = new OracleCommand(strSQL, objConn); objCmd.ExecuteNonQuery(); myDataGrid.EditItemIndex … single Datagridview - show/insert/update/delete [Multiple tables] 12 Years Ago by thenndral …"; cn = new OracleConnection(connectionString); OracleCommand command; string insertQuery = @"insert …active;)"; //MessageBox.Show(insertQuery); command = new OracleCommand(insertQuery, cn); command.Parameters.Add("@id"… Re: C# Generics HELP 12 Years Ago by thines01 … (OracleConnection conn = new OracleConnection(csb.ToString())) { conn.Open(); _cmd = new OracleCommand(_strSQL, conn); using (_rdr = _cmd.ExecuteReader()) { while (_rdr.Read()) { //copy… Re: C# Generics HELP 12 Years Ago by six_sic6 … (OracleConnection conn = new OracleConnection(csb.ToString())) { conn.Open(); _cmd = new OracleCommand(_strSQL, conn); using (_rdr = _cmd.ExecuteReader()) { while (_rdr.Read()) { //copy… How to update database table using commandbuilder without having Primary Key. 13 Years Ago by MARKAND911 …;] = 1000; } //ds.Tables[0].AcceptChanges(); da.UpdateCommand = build.GetUpdateCommand(); //OracleCommand updatecommnad = new OracleCommand(); //updatecommnad.CommandText = "update table test_m_srvdetail where SDBM_SERVICE_NO between… Re: Need help on how to if record exists update else insert 7 Years Ago by lolafuertes …)` will always return true, because even no record exist for `OracleCommand("SELECT COUNT(*) FROM CONTRACT_INFO WHERE (rid = @rid)", con… STORED PROCEDURE in .NET please help... 18 Years Ago by dbenoit64 …quot; ' Dim insertCmd As New System.Data.OracleClient.OracleCommand(strSql, objConnection) ' insertCmd.CommandType = CommandType.StoredProcedure '… Dim updateCmd As New System.Data.OracleClient.OracleCommand(strSql, objConnection) updateCmd.CommandType = CommandType.… SelectedIndex_changed event of ListBox control 16 Years Ago by VarshaAruja …() Dim con As OracleConnection Dim cmd As OracleCommand Dim dr As OracleDataReader Dim strSelect As String…("DeepakConnectionString").ConnectionString) con.Open() cmd = New OracleCommand(strSelect, con) dr = cmd.ExecuteReader() ' Loop through… Some Error Please help 14 Years Ago by Traicey … = ldate; txtReturnDate.Text = rdate; txtFineAmount.Text = famount; txtFinePaid.Text = fpaid; OracleCommand cmd = new OracleCommand(sql, conn); int ok = cmd.ExecuteNonQuery(); [/code] Re: Some Error Please help 14 Years Ago by Traicey …, MemberID, LoanDate, ReturnDate, FineAmount, FinePaid where LoanID = + " loanid; OracleCommand cmd = new OracleCommand(sql, conn); cmd.Parameters.add("LoanID", OracleType… Customer survey problem 14 Years Ago by deepak12333 …;Data Source=xyz;User ID=SYSTEM;Password=omar;"); OracleCommand cmd = new OracleCommand(); cmd.Connection = Conn; Conn.Open(); string strConn = Request.QueryString… connection status closed after opening c# oracle 14 Years Ago by nirvana74v …=1 AND STATUS='INQUEUE' ORDER BY REPORT_ID ASC"; OracleCommand orCmd = new OracleCommand(singleRecQry, Program.orConn); orCmd.CommandType = CommandType.Text; OracleDataReader orDatRdr… braces error 13 Years Ago by hunfa …, String ConnectionString) { OracleDataReader dr; OracleConnection oracle_conn = new OracleConnection(ConnectionString); OracleCommand Oracle_cmd = new OracleCommand( sqltext, conn ); Oracle_cmd.Connection.open(); dr = Oracle_cmd.ExecuteReader(System… check the code for errors 13 Years Ago by hunfa …, String ConnectionString) { OracleDataReader dr; OracleConnection oracle_conn = new OracleConnection(ConnectionString); OracleCommand Oracle_cmd = new OracleCommand( sqltext, conn ); Oracle_cmd.Connection.open(); dr = Oracle_cmd.ExecuteReader(System… Re: braces error 13 Years Ago by Lusiphur …, String ConnectionString) { OracleDataReader dr; OracleConnection oracle_conn = new OracleConnection(ConnectionString); OracleCommand Oracle_cmd = new OracleCommand( sqltext, conn ); Oracle_cmd.Connection.open(); dr = Oracle_cmd.ExecuteReader(System… error in using System.Data.OracleClient 13 Years Ago by ayeshakhan ….UI.Page { protected void Page_Load(object sender, EventArgs e) { OracleCommand cmd = new OracleCommand("SELECT wllpackagecode,wllpackagename,wllpackagedesc,sdate,edate,status,brandid… ORA-01036: illegal variable name/number 13 Years Ago by ayeshakhan … = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionStringOracle"].ConnectionString); try { OracleCommand cmd = new OracleCommand("wllinsert", cn); cmd.CommandType = CommandType.StoredProcedure; OracleParameter… Dataadapter and datasets issue 13 Years Ago by maephisto … on the other two, like this : [code=c#] _cmd = new OracleCommand("select * from um_users", _conn); _odaUsers = new OracleDataAdapter(); _usersDataSet….SelectCommand = _cmd; _odaUsers.Fill(_usersDataSet, "um_users"); _cmd = new OracleCommand("select u.user_id, r.role_id, r.role_name, r.descr… How to pass parameter from URL into iFrame 13 Years Ago by markymark180 …,DESCONDN,DETCONDN,DISPLAYFIELD FROM conditionsFreehold where IPMSREF= " + IPMSREF; OracleCommand command = new OracleCommand(Query, connection); command.CommandType = CommandType.Text; connection.Open(); OracleDataReader… how to import csv data into Oracle using c # 13 Years Ago by hery … + "', '" + res[i].EVENT_CODE + "')"; OracleCommand command = new OracleCommand(sql, con); command.ExecuteNonQuery(); } } Console.WriteLine("Successfully… Re: how to import csv data into Oracle using c # 13 Years Ago by hery … dataDuration_usec_SFI = currentRow(15) 'myRowTable.ItemArray(15).ToString Dim cmd1 As OracleCommand = New OracleCommand("", conn) cmd1.CommandText = "PROC_CSV_SFI" cmd1… CrystalReports print from DataSet - Problem 13 Years Ago by lukasrzeznik … = new Daneset(); OracleConnection connection = new OracleConnection(connsetting); connection.Open(); OracleCommand command = new OracleCommand(sql, connection); command.CommandText = sql; OracleDataAdapter adapter = new OracleDataAdapter… Passing SQL Query Result into a String 13 Years Ago by Behseini … = "Select FName From Emp Where EmpID = 20"); OracleCommand oc = new OracleCommand(cmd, oraConnection); [/CODE] As you can see the above…