connect to an external sql server from window form

Question

Hi, I am workin' on a small windows application in Visual studio .net using c# and I want to access a ms sql server over the internet... How can I do this? What should my connection string look like?? The servers ip is "skylab1.te.hik.se" port 25000. the server name is "SKYLAB1\INST2" the database name is "BreemerChat". I use Sql server authentication (don't wont to post the logins ;)). earlier I used an alias in the client network utility (wich worked fine) but that doesn't work on other computers, that havn't got an alias... I am a beginner when it comes to this so please help me!

Answer 1

Can any one could solve this problem, if yes plz help me to solve it.

Answer 2

hai Sanjay Kumar,

Thanks for your valuable reply, Actually what iam trying to implement is to make a repeater user control that can generate dynamic columns , that is if i use that repeater in a web form with 3 columns  i must be able to use that repeater control in the next web form for more than or less than 3 columns , so the problem is i need to bind that data with out using source code, that is "Eval" method can only add one data from a particular table only, i need to generalize that part and need to made that part data binding in general, so can i bind data to a repeater without source code by using only code behind.

Please pardon me if there is any confusions, ask me for more clarifications to my idea.

Answer 3

Hi

try this

http://www.c-sharpcorner.com/UploadFile/47548d/twitter-bootstrap-and-repeater-control-in-Asp-Net/