how to convert the Nvarchar to Integer with Select c#

Abdalla Elawad

6y3.2kVisual Basic .NET

please help me and look to this code

string mainconn = ConfigurationManager.ConnectionStrings["Con_VisitorsControl"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
string sqlquery = "select VisitorName, IqamaCopy from [dbo].[tbl_Visitors] where VisitorId = ' " + txtno.Text + " ' ";
SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn);
sqlconn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = sqlcomm;
DataSet ds = new DataSet();
sda.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
sqlconn.Close();

this VisitorId Is Nvarchar contain to 9 digits on sql how can i select and convert this fieldname in the c#

thanks

4 Replies

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

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.codeproject.com/Questions/714116/error-Converting-data-type-nvarchar-to-int-csharp
0
Abdalla Elawad6y ago
Hi Jin Vincent Necesario

i try your code , but doesn't run

this is cln on sql server

0
Jin Necesario6y ago
1. string txt = "".PadLeft(9, '0');
2. string result = txt.Insert(txt.Length - txtno.Text.Length, txtno.Text).Substring(0, 9);
4. string sqlquery = "select VisitorName, IqamaCopy from [dbo].[tbl_Visitors] where VisitorId = ' " + (result) + " ' ";
E.g.

txtno.Text = "20";
it will result into "0000000020"

Let me know if this one helps. I hope you get the idea.Thanks.
+1

Salman Beg6y ago

Hi. You can use var x= Convert.ToInt32(Id); to convert nvarchar to int. But if it contains character or special character then it will throw error. Thanks.