use asp.net using c# coding

Question

i have to connect local Pc to server that is ( from my website i need to retrieve data from my local PC) use asp.net using c# coding . how to do it

selvi subramanian · Answer

Thanks Ramasagar. its my pc adress ah. in webconfig file what i have to put . i need it in asp.net using c# language SqlConnection connection = new SqlConnection(@Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=tests;Data Source= MAK-PC\SQLEXPRESS);

RamaSagar Pulidindi · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Data; namespace myData { public static class Data { public static DataTable GetSampleData() { SqlConnection connection = new SqlConnection(@Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=tests;Data Source=MAK-PC\SQLEXPRESS); SqlCommand cmd = new SqlCommand(select * from sampleData connection); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); try { connection.Open(); da.Fill(ds); } catch (Exception e) { throw; } finally { if (connection.State == System.Data.ConnectionState.Open) connection.Close(); } return ds.Tables[0]; } } }