sql

1 view
Skip to first unread message

alireza rahmani

unread,
Aug 15, 2011, 10:59:32 AM8/15/11
to Computer_Association_Rajaee
ba .(dot) va esme pc connect nemishe amma vaghti mizanam alireza-pc
\sqlexpress vasl mishe.aia ina ba ham fargh daran?"

Saeed Jahromi

unread,
Aug 15, 2011, 11:03:25 AM8/15/11
to computer_asso...@googlegroups.com
salam ostad, in topic marboot be vaghtie ke sql enterprize ro baz mikonim.tooie server name vaghti esme computer ro benevisam ya dot bezaram connect nemishe.vali injoori connect mishe: esme computer\sqlexpress. ina ba ham fargh daran?

server type ham "data engine" hast.

ali baie

unread,
Aug 16, 2011, 3:31:22 AM8/16/11
to computer_asso...@googlegroups.com
salam.vaghti ke dot ya esme computer o mizanid dar vaghe be sql
enterpriz vasl mishid.vali vaghti ba esmecomputer\sqlexpress ya
.\sqlexpress mizanid be sql express ke hamrahe ba vs nasb mishe vasl
mishid ke in yani inke 2 noskhe sql ba ham motafavetan.movafagh bashid

Saeed Jahromi

unread,
Aug 16, 2011, 6:22:50 AM8/16/11
to computer_asso...@googlegroups.com
mamnoon, man sql ro az roo rahnama nasb kardam, moghgeie nasb ye instance be esme sqlserverfortest sakhtam ke alanam ba esmecomputer\sqlfortest vasll misham. too barname ham vaghti ba sqlconnection ,connectionstring ro migiram vasl nemishe o in error ro mide:

Error    1    Unrecognized escape sequence    E:\MyLibrary\MyLibrary C#\MyLibrary\MyLibrary\Form1.cs    27    90    MyLibrary

in ham connection stringame:
Data Source=SAEEDJOON-PC\SQLSERVERFORTEST;Initial Catalog=MyLibraryDatabase;Integrated Security=True

too mohite code c# zire harfe S tooie ...SQLSERVERFORTEST khat mikeshe o vaghti mouso miaram roosh hamoon errore bala ro neshoon mide.

ali baie

unread,
Aug 16, 2011, 11:41:57 PM8/16/11
to computer_asso...@googlegroups.com
sql server o baz konid va name server o az jaee ke tooie tasvir moshakhase peyda konid.
sql.gif

Saeed Jahromi

unread,
Aug 17, 2011, 5:33:17 PM8/17/11
to computer_asso...@googlegroups.com
mamnoon ostad moshkel hal shod.ye bare dige sql ro rikhtam va instanse ro default gozashtam.

moshkele jadid ine ke:
ye barnam baraie ketabkhune neveshtam ke formesh in sheklie:



Untitled.png


man tooie rooidade textchange hameie text box haie form code search ro neveshtam amma mikham ba har taghiri ke tooie har kodoom az textbox ha midam natijeie nahayi ke tooie datagridview neshoon dade mishe daghightar beshe, yani age tooie nevisande neveshtam ن va tooie ketab neveshtam د tamame recordayi ke dar sotoone marboot beheshun noon va dal darano neshoon bede va age pakeshun kardam... kollan hei berooz beshe.

alanam haminjoorie vali too bazi halata recorda ro eshtebah neshoon mide masalan:

vaghti ba ن va د search kardam age masalan textboxi ke ن tooshe ro pak konam kolle recorda neshoon dade mishan na oonayi ke faghat د daran.

Untitled.png

Sir-J

unread,
Aug 19, 2011, 8:33:29 AM8/19/11
to Computer_Association_Rajaee
ostad moshkelam hal shod. tooie rooidade text change har kodoom az
textboc ha neveshtam: select * from BookList Where BookName like
texbox1.text or bookWriter like textbox2.text....

ali baie

unread,
Aug 21, 2011, 12:14:54 AM8/21/11
to computer_asso...@googlegroups.com
سلام
در برنامه نویسی دقت  داشته باشید و خودتون رو جای کامپیوتر قرار بدید  و فکر کنید که اگه قرار بود یه کاری رو شما انجام بدید به چه چیزهایی نیاز داشتید
دقیقا همون اطلاعات رو به کامپیوتر بدید
موفق باشید
Reply all
Reply to author
Forward
0 new messages