TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
Tangara G
NA
298
93.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