Odbc parameter error

[Santosh]

Hii all i have written following code for inserting records into
database but it gives me an error espected parameter @NewsTitle which
is not supplied.

OdbcConnection conn = new OdbcConnection( );
protected System.Web.UI.W ebControls.Butt on Button1;
OdbcCommand cmd =new OdbcCommand ();
protected System.Web.UI.W ebControls.Text Box TextBox1;
protected System.Web.UI.W ebControls.Text Box TextBox2;
OdbcParameter param =new OdbcParameter() ;

//class constructor
public TestAddRec()
{

conn.Connection String="DSN=vri tti;uid=sa;pwd= sa";
cmd.Connection= conn;
conn.Open();
}

private void Button1_Click(o bject sender, System.EventArg s e)
{

cmd.CommandType =CommandType.St oredProcedure;
cmd.CommandText ="DS_SP_Insert_ News";

param.OdbcType= OdbcType.VarCha r;
param.Value = "@TextBox1.Text ";
param.SourceCol umn="@NewsTitle ";

//param.Parameter Name="Param1";
cmd.Parameters. Add(param);
OdbcParameter param1 =new OdbcParameter() ;
param1.OdbcType =OdbcType.VarCh ar;
param1.Value = "@TextBox2.Text ";
param1.SourceCo lumn="@NewsDesc ";
//param.Parameter Name="Param2";
cmd.Parameters. Add(param1);

OdbcParameter param2 =new OdbcParameter() ;
param2.OdbcType =OdbcType.DateT ime;
param2.Value = DateTime.Now.To ShortDateString ();
param2.SourceCo lumn="@Modified Date";
//param.Parameter Name="Param3";
cmd.Parameters. Add(param2);

OdbcParameter param3 =new OdbcParameter() ;
param3.OdbcType =OdbcType.Date;
param3.Value = DateTime.Now.To ShortDateString ();
param3.SourceCo lumn="@AddedDat e";
//param.Parameter Name="Param4";
cmd.Parameters. Add(param3);

OdbcParameter param4 =new OdbcParameter() ;
param4.OdbcType =OdbcType.VarCh ar;
param4.Value = "Santosh";
param4.SourceCo lumn="@AddedBy" ;
//param.Parameter Name="Param5";
cmd.Parameters. Add(param4);
cmd.ExecuteNonQ uery();
Response.Write( "<Script language=javasc ript>alert('Rec ords are added
successfully'); </script>");
}

[David R. Longnecker]

Looking at your parameters and how NewsTitle compares to your other parameters,
perhaps it's due to the fact that a new OdbcParameter hasn't been instanciated
for NewsTitle inside the button1_click. Have you tried moving it in there?

** OdbcParameter param = new OdbcParameter() ; **
param.OdbcType= OdbcType.VarCha r;
param.Value = "@TextBox1.Text ";
param.SourceCol umn="@NewsTitle ";

//param.Parameter Name="Param1";
cmd.Parameters. Add(param);

If not, is there a reason it's left outside?

-dl

--
David Longnecker
Web Developer
http://blog.tiredstudent.com

Hii all i have written following code for inserting records into
database but it gives me an error espected parameter @NewsTitle which
is not supplied.

OdbcConnection conn = new OdbcConnection( );
protected System.Web.UI.W ebControls.Butt on Button1;
OdbcCommand cmd =new OdbcCommand ();
protected System.Web.UI.W ebControls.Text Box TextBox1;
protected System.Web.UI.W ebControls.Text Box TextBox2;
OdbcParameter param =new OdbcParameter() ;
//class constructor
public TestAddRec()
{
conn.Connection String="DSN=vri tti;uid=sa;pwd= sa";
cmd.Connection= conn;
conn.Open();
}
private void Button1_Click(o bject sender, System.EventArg s e)
{
cmd.CommandType =CommandType.St oredProcedure;
cmd.CommandText ="DS_SP_Insert_ News";
param.OdbcType= OdbcType.VarCha r;
param.Value = "@TextBox1.Text ";
param.SourceCol umn="@NewsTitle ";
//param.Parameter Name="Param1";
cmd.Parameters. Add(param);
OdbcParameter param1 =new OdbcParameter() ;
param1.OdbcType =OdbcType.VarCh ar;
param1.Value = "@TextBox2.Text ";
param1.SourceCo lumn="@NewsDesc ";
//param.Parameter Name="Param2";
cmd.Parameters. Add(param1);
OdbcParameter param2 =new OdbcParameter() ;
param2.OdbcType =OdbcType.DateT ime;
param2.Value = DateTime.Now.To ShortDateString ();
param2.SourceCo lumn="@Modified Date";
//param.Parameter Name="Param3";
cmd.Parameters. Add(param2);
OdbcParameter param3 =new OdbcParameter() ;
param3.OdbcType =OdbcType.Date;
param3.Value = DateTime.Now.To ShortDateString ();
param3.SourceCo lumn="@AddedDat e";
//param.Parameter Name="Param4";
cmd.Parameters. Add(param3);
OdbcParameter param4 =new OdbcParameter() ;
param4.OdbcType =OdbcType.VarCh ar;
param4.Value = "Santosh";
param4.SourceCo lumn="@AddedBy" ;
//param.Parameter Name="Param5";
cmd.Parameters. Add(param4);
cmd.ExecuteNonQ uery();
Response.Write( "<Script language=javasc ript>alert('Rec ords are
added
successfully'); </script>");
}

[Santosh]

i have tired in other ways also but still it is giving same error . if
i am using sqlconnection, sqlcommand, sqlparameters then it works fine
but it gives an error when i am using Odbc.

--
David R. Longnecker wrote:

Looking at your parameters and how NewsTitle compares to your other parameters,
perhaps it's due to the fact that a new OdbcParameter hasn't been instanciated
for NewsTitle inside the button1_click. Have you tried moving it in there?

** OdbcParameter param = new OdbcParameter() ; **
param.OdbcType= OdbcType.VarCha r;
param.Value = "@TextBox1.Text ";
param.SourceCol umn="@NewsTitle ";

//param.Parameter Name="Param1";
cmd.Parameters. Add(param);

If not, is there a reason it's left outside?

-dl

--
David Longnecker
Web Developer
http://blog.tiredstudent.com

Hii all i have written following code for inserting records into
database but it gives me an error espected parameter @NewsTitle which
is not supplied.

OdbcConnection conn = new OdbcConnection( );
protected System.Web.UI.W ebControls.Butt on Button1;
OdbcCommand cmd =new OdbcCommand ();
protected System.Web.UI.W ebControls.Text Box TextBox1;
protected System.Web.UI.W ebControls.Text Box TextBox2;
OdbcParameter param =new OdbcParameter() ;
//class constructor
public TestAddRec()
{
conn.Connection String="DSN=vri tti;uid=sa;pwd= sa";
cmd.Connection= conn;
conn.Open();
}
private void Button1_Click(o bject sender, System.EventArg s e)
{
cmd.CommandType =CommandType.St oredProcedure;
cmd.CommandText ="DS_SP_Insert_ News";
param.OdbcType= OdbcType.VarCha r;
param.Value = "@TextBox1.Text ";
param.SourceCol umn="@NewsTitle ";
//param.Parameter Name="Param1";
cmd.Parameters. Add(param);
OdbcParameter param1 =new OdbcParameter() ;
param1.OdbcType =OdbcType.VarCh ar;
param1.Value = "@TextBox2.Text ";
param1.SourceCo lumn="@NewsDesc ";
//param.Parameter Name="Param2";
cmd.Parameters. Add(param1);
OdbcParameter param2 =new OdbcParameter() ;
param2.OdbcType =OdbcType.DateT ime;
param2.Value = DateTime.Now.To ShortDateString ();
param2.SourceCo lumn="@Modified Date";
//param.Parameter Name="Param3";
cmd.Parameters. Add(param2);
OdbcParameter param3 =new OdbcParameter() ;
param3.OdbcType =OdbcType.Date;
param3.Value = DateTime.Now.To ShortDateString ();
param3.SourceCo lumn="@AddedDat e";
//param.Parameter Name="Param4";
cmd.Parameters. Add(param3);
OdbcParameter param4 =new OdbcParameter() ;
param4.OdbcType =OdbcType.VarCh ar;
param4.Value = "Santosh";
param4.SourceCo lumn="@AddedBy" ;
//param.Parameter Name="Param5";
cmd.Parameters. Add(param4);
cmd.ExecuteNonQ uery();
Response.Write( "<Script language=javasc ript>alert('Rec ords are
added
successfully'); </script>");
}