Must declare the scalar variable '@FirstName'

[Ken Adeniji]

Must declare the scalar variable '@FirstName'

ContactGridView WebForm.aspx
<aspqlDataSourc e
RunAt="server"
ID="SqlDataSour ceContact"

ConnectionStrin g="server=local host;database=W ordEngineering; Integrated
Security=SSPI;"
ProviderName="S ystem.Data.OleD b"
SelectCommand=" SELECT SequenceOrderId , FirstName, LastName,
OtherName, Company FROM Contact ORDER BY SequenceOrderId "
UpdateCommand=" UPDATE Contact SET FirstName=@Firs tName,
LastName=@LastN ame, Company=@Compan y WHERE equenceOrderId= @SequenceOrderI d"
href="mailtoequ enceOrderId=@Se quenceOrderId"> SequenceOrderId =@SequenceOrder Id"
/>

<asp:GridView
RunAt="server"
ID="GridViewCon tact"
AutoGenerateCol umns=false
AutoGenerateEdi tButton=true
DataKeyField="S equenceOrderId"
AllowPaging="tr ue"
AllowSorting="t rue"

ContactGridView Page.aspx.cs
public string DatabaseConnect ionString = "Provider=SQLOL EDB;Data
Source=localhos t;Integrated Security=SSPI;I nitial Catalog=WordEng ineering;";
SqlDataSourceCo ntact.Connectio nString = DatabaseConnect ionString;
GridViewContact .DataSourceID = SqlDataSourceCo ntact.ID;

[Kevin Spencer]

Take a look at your code. Do you see the string "@FirstName " anywhere?

Do you know what it is?

It's a parameter decaration. Where have you defined the parameter?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Ken Adeniji" <Ke********@dis cussions.micros oft.com> wrote in message
news:DD******** *************** ***********@mic rosoft.com...

Must declare the scalar variable '@FirstName'

ContactGridView WebForm.aspx
<aspqlDataSourc e
RunAt="server"
ID="SqlDataSour ceContact"

ConnectionStrin g="server=local host;database=W ordEngineering; Integrated
Security=SSPI;"
ProviderName="S ystem.Data.OleD b"
SelectCommand=" SELECT SequenceOrderId , FirstName, LastName,
OtherName, Company FROM Contact ORDER BY SequenceOrderId "
UpdateCommand=" UPDATE Contact SET FirstName=@Firs tName,
LastName=@LastN ame, Company=@Compan y WHERE
equenceOrderId= @SequenceOrderI d"
href="mailtoequ enceOrderId=@Se quenceOrderId"> SequenceOrderId =@SequenceOrder Id"
/>

<asp:GridView
RunAt="server"
ID="GridViewCon tact"
AutoGenerateCol umns=false
AutoGenerateEdi tButton=true
DataKeyField="S equenceOrderId"
AllowPaging="tr ue"
AllowSorting="t rue"

>

ContactGridView Page.aspx.cs
public string DatabaseConnect ionString = "Provider=SQLOL EDB;Data
Source=localhos t;Integrated Security=SSPI;I nitial
Catalog=WordEng ineering;";
SqlDataSourceCo ntact.Connectio nString = DatabaseConnect ionString;
GridViewContact .DataSourceID = SqlDataSourceCo ntact.ID;

[Ken Adeniji]

Must declare the scalar variable '@FirstName' occurs when the user concludes
the edit mode by clicking the update button.

In the past, efforts to define the parameter have been unsuccessful, but
could you please share a working sample code example.

Thank you.

"Kevin Spencer" wrote:

Take a look at your code. Do you see the string "@FirstName " anywhere?

Do you know what it is?

It's a parameter decaration. Where have you defined the parameter?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Ken Adeniji" <Ke********@dis cussions.micros oft.com> wrote in message
news:DD******** *************** ***********@mic rosoft.com...

Must declare the scalar variable '@FirstName'

ContactGridView WebForm.aspx
<aspqlDataSourc e
RunAt="server"
ID="SqlDataSour ceContact"

ConnectionStrin g="server=local host;database=W ordEngineering; Integrated
Security=SSPI;"
ProviderName="S ystem.Data.OleD b"
SelectCommand=" SELECT SequenceOrderId , FirstName, LastName,
OtherName, Company FROM Contact ORDER BY SequenceOrderId "
UpdateCommand=" UPDATE Contact SET FirstName=@Firs tName,
LastName=@LastN ame, Company=@Compan y WHERE
equenceOrderId= @SequenceOrderI d"
href="mailtoequ enceOrderId=@Se quenceOrderId"> SequenceOrderId =@SequenceOrder Id"
/>

<asp:GridView
RunAt="server"
ID="GridViewCon tact"
AutoGenerateCol umns=false
AutoGenerateEdi tButton=true
DataKeyField="S equenceOrderId"
AllowPaging="tr ue"
AllowSorting="t rue"

>

ContactGridView Page.aspx.cs
public string DatabaseConnect ionString = "Provider=SQLOL EDB;Data
Source=localhos t;Integrated Security=SSPI;I nitial
Catalog=WordEng ineering;";
SqlDataSourceCo ntact.Connectio nString = DatabaseConnect ionString;
GridViewContact .DataSourceID = SqlDataSourceCo ntact.ID;

[Kevin Spencer]

No problemo. But you must promise to read the WHOLE thing! ;-)

http://msdn.microsoft.com/library/de...eterstopic.asp

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Ken Adeniji" <Ke********@dis cussions.micros oft.com> wrote in message
news:B9******** *************** ***********@mic rosoft.com...

Must declare the scalar variable '@FirstName' occurs when the user
concludes
the edit mode by clicking the update button.

In the past, efforts to define the parameter have been unsuccessful, but
could you please share a working sample code example.

Thank you.

"Kevin Spencer" wrote:

Take a look at your code. Do you see the string "@FirstName " anywhere?

Do you know what it is?

It's a parameter decaration. Where have you defined the parameter?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"Ken Adeniji" <Ke********@dis cussions.micros oft.com> wrote in message
news:DD******** *************** ***********@mic rosoft.com...

> Must declare the scalar variable '@FirstName'
>
> ContactGridView WebForm.aspx
> <aspqlDataSourc e
> RunAt="server"
> ID="SqlDataSour ceContact"
>
> ConnectionStrin g="server=local host;database=W ordEngineering; Integrated
> Security=SSPI;"
> ProviderName="S ystem.Data.OleD b"
> SelectCommand=" SELECT SequenceOrderId , FirstName, LastName,
> OtherName, Company FROM Contact ORDER BY SequenceOrderId "
> UpdateCommand=" UPDATE Contact SET FirstName=@Firs tName,
> LastName=@LastN ame, Company=@Compan y WHERE
> equenceOrderId= @SequenceOrderI d"
> href="mailtoequ enceOrderId=@Se quenceOrderId"> SequenceOrderId =@SequenceOrder Id"
> />
>
> <asp:GridView
> RunAt="server"
> ID="GridViewCon tact"
> AutoGenerateCol umns=false
> AutoGenerateEdi tButton=true
> DataKeyField="S equenceOrderId"
> AllowPaging="tr ue"
> AllowSorting="t rue"
> >
>
> ContactGridView Page.aspx.cs
> public string DatabaseConnect ionString = "Provider=SQLOL EDB;Data
> Source=localhos t;Integrated Security=SSPI;I nitial
> Catalog=WordEng ineering;";
> SqlDataSourceCo ntact.Connectio nString = DatabaseConnect ionString;
> GridViewContact .DataSourceID = SqlDataSourceCo ntact.ID;