i try both strong-typed dataset and sqldatasource to get connection from sql server 2008 but it gave me error like :
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
while using conventional connection like describing connstring :
private static string connstring = "Data Source=123\\SQLEXPRESS;Ini
tial Catalog=productdb;User Id=xx;Password=xxx;";