piter11
یک شنبه 02 آذر 1393, 21:35 عصر
چطور میشه در یک فرمی که میخوام دستور like بنویسم اشاره کنم به تکس باکسی که در فرم registeruser هست
الان اشاره میکنم به مقدار txttozihat.txt ارور میده
cmd.CommandText = "SELECT ID AS [آیدی],Name as [نام],LastName as [نام خانوادگی],Saat as [ساعت],tell as [تلفن یا کد],Tarikh as [تاریخ],Tozihat as [توضیحات],Bayaniye as [مبلغ کل]FROM TblRegisterUser WHERE (checked=1 and '" & txttozihat.Text & "' like '%عروس%') ORDER BY tarikh ASC,Saat ASC"
الان اشاره میکنم به مقدار txttozihat.txt ارور میده
cmd.CommandText = "SELECT ID AS [آیدی],Name as [نام],LastName as [نام خانوادگی],Saat as [ساعت],tell as [تلفن یا کد],Tarikh as [تاریخ],Tozihat as [توضیحات],Bayaniye as [مبلغ کل]FROM TblRegisterUser WHERE (checked=1 and '" & txttozihat.Text & "' like '%عروس%') ORDER BY tarikh ASC,Saat ASC"