Your question is not so clear . .but as much i can understand you want to show all the tables columns in one data grid... For that you cannot use such a code but u may need to use UNION in your query. So you need to select all the data in single query using union and then populate data ina single table. You can google union .. you will get it . .. It should be something like this : da1 = new OleDbDataAdapter("select * from InitialApproval where InitialApproval.PrNo='"+rd.GetString(0)+"' UNION select EstimatedVal,FwdDtByPSD from PSDApproval where PSDApproval.PrNo='" + rd.GetString(0) + "' UNION select POValue,rcd_dtCC,saving from CommonData where CommonData.PrNo='" + rd.GetString(0) + "'", con); da.Fill(ds);

place add rotator inside content template... and check.. Government Dyal Singh College Lahore.

I would look into writing a windows service that runs in the background to perform such a job, rather than trying to write it as part of a web site. A service is autonomous, and can be guaranteed to be executing so your job will run on the appropriate schedule. Its difficult, if not impossible, to make such a guarantee from a job triggered by an ASP.NET process. Just a word of warning...executing a query every 5 seconds against a database could cause problems with performance and load. It might be better to reevaluate why you need such a job, and perhapse approach it in a different way (one that does not involve executing queries against an access database every 5 seconds). A windows service could still provide a host for your job.

Hi... First I would like to know whether you need to get the files from the directory in the local system only or you would like to upload the files as well. If you want to get the files from the directory we can use Directory.GetFiles() method. GO through the following code. GridView1.DataSource = Directory.GetFiles("c:\\Tempu\\Upload", "*.doc"); GridView1.DataBind(); Please let me know if it serves your question. Regards Raj.

As u said, when user click on the link it wont open,remember only the path is there in database .U must store the file in database,then only it will happen. And if u r storing the full path,then it is easy to get the path as cell value.Then u can open it.Make that field in gridview a template and try modified on Friday, February 20, 2009 5:59 AM

Hi, same question came up last week. Check the response, maybe this will be helpful: http://www.codeproject.com/script/Forums/View.aspx?fid=12076&select=2912689&fr=532#xx2912689xx[^] Regards Sebastian It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.