how to convert the Nvarchar to Integer with Select c#

Question

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

Jin Necesario · Answer

string txt = "".PadLeft(9, '0' ); string result = txt.Insert(txt.Length - txtno.Text.Length, txtno.Text).Substring(0, 9); 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.

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.codeproject.com/Questions/714116/error-Converting-data-type-nvarchar-to-int-csharp

Abdalla Elawad · Answer

Hi Jin Vincent Necesario i try your code , but doesn't run this is cln on sql server

Salman Beg · Answer

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.