i am new to ASP.NET programming ,through c#.
In my web project,i am inserting into SqlServer Database through Command.Text method.It is working fine.
Below i am giving the code for SqlServer database table.
Code:
...
....
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlcon = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=DB2;Integrated Security=True;Pooling=False");
protected void Page_Load(object sender, EventArgs e)
{
GridControl();
}
protected void Button1_Click(object sender, EventArgs e)
{
String sqlins = "insert into emp_t values(@emp_name)";
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = sqlins;
sqlcmd.CommandType = CommandType.Text;
sqlcmd.Parameters.Add("@emp_name", TextBox1.Text.ToString());
sqlcon.Open();
sqlcmd.ExecuteNonQuery();
sqlcon.Close();
Response.Write("record saved");
GridControl();
}
public void GridControl()
{
String sqlsel = "select *from emp_t";
SqlDataAdapter sda = new SqlDataAdapter(sqlsel, sqlcon);
DataTable dt = new DataTable();
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
Code:
...
.....
using System.Data.OracleClient;
public partial class _Default : System.Web.UI.Page
{
OracleConnection oracon = new OracleConnection("Data Source=EARTH;Persist Security Info=True;User ID=rinku;Password=rinku;Unicode=True");
protected void Page_Load(object sender, EventArgs e)
{
GridControl();
}
protected void Button1_Click(object sender, EventArgs e)
{
String orains = "insert into T6 values(@name)";
OracleCommand oracmd = new OracleCommand();
oracmd.Connection = oracon;
oracmd.CommandText = orains;
oracmd.CommandType = CommandType.Text;
oracmd.Parameters.Add("@name", TextBox1.Text.ToString());
oracon.Open();
oracmd.ExecuteNonQuery();
oracon.Close();
Response.Write("Record saved");
GridControl();
}
public void GridControl()
{
String orasel="select *from T6";
OracleDataAdapter oda = new OracleDataAdapter(orasel, oracon);
DataTable dt = new DataTable();
oda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
Build is successful but,
It gave the following runtime error:-
Error at : oracmd.ExecuteNonQuery();
OracleException was unhandled by the user code
ORA-01036: illegal variable name/number
plz help me ...
