how to perform dml operaction on a table in oracle

Question

Hi Friends I am new to .net development (beginner) i faced one problem ... how to update values in table my back end is oracle and front end be .net.. update emp set values ='firstname+'' +lastname+ ' where empno=1 is it correct please help me.. Regards Pradeep.

Vishal Gilbile · Answer

Hello Friend For working with oracle DB you need to reference System.Data.OracleClient in your web application. after that the following code may help you. Let's assume we have a table name Employee with fields(EIDENameEAgeESal) Way 1(Without using Procedure): OracleConnection con=new OracleConnection(Your Connection string); OracleCommand cmd=new OracleCommand(Update Emp set EName=@nameEAge=@ageEsal=@sal where EID=@idcon); cmd.Parameters.AddWithValue(@nametextBox2.Text); cmd.Parameters.AddWithValue(@agetextBox3.Text); cmd.Parameters.AddWithValue(@saltextBox4.Text); cmd.Parameters.AddWithValue(@idtextBox1.Text); con.Open(); int rows=cmd.ExcecuteNonQuery(); if(rows>0) Label1.Text=Data Updated; else Label1.Text=Error Updating Data; con.Close(); Way 2 (With using Procedure) OracleConnection con=new OracleConnection(Your Connection string); OracleCommand cmd=new OracleCommand(procedureNamecon); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@nametextBox2.Text); cmd.Parameters.AddWithValue(@agetextBox3.Text); cmd.Parameters.AddWithValue(@saltextBox4.Text); cmd.Parameters.AddWithValue(@idtextBox1.Text); con.Open(); int rows=cmd.ExcecuteNonQuery(); if(rows>0) Label1.Text=Data Updated; else Label1.Text=Error Updating Data; con.Close(); Hope that solves your problem. With Regards Vishal Gilbile