Not able to Configure my Dataset.
hi, i have dataset in vs2008 application,im using dataset in 1 of crsytal report.my dataset not getting right columns neither im able configure dataset. when open dataset designer , see columns being fetched find 3 columns missing.to solve try have @ dataset query,for when open dataset designer gets error: failed open connection database."an error occured while establishing connection server." although tcp/ip,shared memory,named pipes protocols enabled.i still disabled them , again enabled them , restarted services still gets same error. coming dataset.when click on ok of error message box im getting table adapter configuration wizard,i create connection , continue process update dataset.in process check query in wizard,over there im using select * mytable , innerjoin other table.the query surely correct can column leaving 3 columns. i cant see 3 columns not when go in crystal report designer,i connect dataset there drag n drop the fields on crystal report ...