how can i search by Nvarchar(10) as integer number c#

Abdalla Elawad

hello Programmers i faced a brolem in searching events becaues i used filed contains to 10 digits as nvarchar i will attache code and table to explain more this problem .

Soory System faced problem to upload file , generally this is code below

IqamaNo is Nvarchar(10) contains to 10 digits how to search by by this type of datatype , if i need to convert to this type please help me how can i convert it .

thanks

string mainconn = ConfigurationManager.ConnectionStrings["Con_VisitorsControl"].ConnectionString;

SqlConnection sqlconn = new SqlConnection(mainconn);

string sqlquery = "select VisitorName, IqamaCopy from [dbo].[tbl_Visitors] where IqamaNo= ' " + 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();

4 Replies

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

Jenith Thakkar7y ago
Try this Query

select VisitorName, IqamaCopy from [dbo].[tbl_Visitors] where IqamaNo= CAST(' " + txtno.Text + " ' AS BIGINT) WHERE ISNUMERIC(IqamaNo) = 1
0
Jayanth Reddy7y ago
try

SELECT convert (int, dbo.your_NvarcharColumn) FROM dbo;

(or)

https://stackoverflow.com/questions/40975612/converting-nvarchar-to-int-datatype-in-sql-server-2008
https://stackoverflow.com/questions/30399918/convert-nvarchar-to-integer-in-sql
0
Abdalla Elawad7y ago
I try to convert.toIn64 , but failed
thanks
0
Dinesh Gabhane7y ago
You can use Convert.ToInt64 if it is a 10 digit number
0