What are @fn, @tel, @eml in the sql query below?

Tangara G

10y1.3k.NET

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");
}

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Accepted answer
@fn,@tel, @eml are sql parameters. They are used to add values in sql query. Sql parameters makes your query more simple and clean. If you use parameters then there is no need to use single quotes to insert character or date values, so the chance of syntax error is prevented. Check this http://csharp-station.com/Tutorial/AdoDotNet/Lesson06
+2
Francis Susaimichael10y ago
@fn, @tel and @eml are place holders.You will fill these respective valuesin SQL parameter using this place holder. You cangive any validcharas place holder. These valuesare substitutedin your "Insert"queryafter thatit will be executed. Hope this helps!
0
Tangara G10y ago
Dearest all who have replied,
Deep thank from my heart.
I will study all the answers on weekend, cos I am now flat .....with so much jamming of concepts I tried to learn yesterday....
Tks again.
0
Bikesh Srivastava10y ago
I think you have incomplete code ,but you these are parameters as value .
0
Prakash Kumar10y ago
Hi Karan,
As of your query, you try to give the aliases names for the columns in the table,
this @fn, @tel, @eml are just temporary variables for the columns in this mamber.
Note: avoid writing inline queries while using in c#.
+1
Ranjit Powar10y ago
@fn,@tel, @eml are sql parameters. They are used to add values in sql query. Sql parameters makes your query more simple and clean. If you use parameters then there is no need to use single quotes to insert character or date values, so the chance of syntax error is prevented. Check this http://csharp-station.com/Tutorial/AdoDotNet/Lesson06
0
Manas Mohapatra10y ago
@fn - It relates to Full Name.
@tel - It relates to Telephone number
@eml - It relates to Email

These are SQL parameters names which you are passing to execute SQL query.
It looks you are using inline query, so you should use parameterised to avoid SQL injection.
SQL parameters are used in Inline SQL queries or calling the Stored procedure.

Secongly the parameters names should same as SQL query param names.
0
Tangara G10y ago
I am a beginner and very new in asp.net and c#. FYI. The code is a completed one. Btw, what is proc ?
0
Pradeep Sahoo10y ago
Your shared code is incomplete . Looks like they are local parameter to the in line sql query .
0
Salman Beg10y ago
Hi.
These are the things @fn, @tel, @eml normally used in proc. I can't understand why you gave value like this. Don't use inline sql query rather than that create a proc and pass values from your .cs page and also your code is incomplete.Please provide more details.
thanks.
0