IOT Virtual Conference - Register now to book your ticket and get updates
x
WIN Surface Laptop 4, i7 Processor, 16GB RAM, 512GB SSD
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Tangara G
1.7k
298
69.5k
What are @fn, @tel, @eml in the sql query below?
Oct 31 2016 7:35 AM
Dear experts,
I would like to know what are @fn,@tel, @eml are ?
Are these names we just anyhow gave ? If not where on earth it came from ?
protected
void
btnCreate_Click(object sender, EventArgs e)
{
DAO.MembersDAO memDAO =
new
DAO.MembersDAO();
string sql =
"INSERT INTO member VALUES (@fn, @tel, @eml)"
;
//SqlParameterCollection spc = null;
//spc.Add(new SqlParameter("@fn", SqlDbType.NVarChar)).Value = txtFullName.Text;
//spc.Add(new SqlParameter("@tel", SqlDbType.NVarChar)).Value = txtTel.Text;
//spc.Add(new SqlParameter("@eml", SqlDbType.NVarChar)).Value = txtEmail.Text;
SqlParameter[] spa =
new
SqlParameter[3];
spa[0] =
new
SqlParameter(
"@fn"
, SqlDbType.NVarChar);
spa[0].Value = txtFullName.Text;
spa[1] =
new
SqlParameter(
"@tel"
, SqlDbType.NVarChar);
spa[1].Value = txtTel.Text;
spa[2] =
new
SqlParameter(
"@eml"
, SqlDbType.NVarChar);
spa[2].Value = txtEmail.Text;
int
result = memDAO.InsertMember(sql, spa);
if
(result == 1)
{
Response.Redirect(
"MemberList.aspx"
);
}
Reply
Answers (
10
)
Read from a file And Write to a file
Error:- unable to start debugging on web server