Yes thanks i did get it though i did not like the correctional facilities here.

Oh i didnt know u were 40 years and you talked like that .. Frustration must be killing you. Anyway thanks for letting me know am not supposed to use txt here.

i cannot believe this.. alright whatever man...

Alright..... At last u have answered me now.. though i still don see wots wrong in tryna find da most optimized way of doing things..i just don get my faults here. and your tone-am sure thats how u were brought up.

wow..wot a way to answer a genuine question. thanks for wasting you time typing... some codes are not optimized and would require much more processor time than others though not significant for humans to realise but it can surely be seen in very large db programs thats wy i asked if any one could help comment..weda its the best maybe i should have added 'Optimized' and i guess 'u answered ####quite#### well'

DataTable dt = con.Fromdbase("Select * from DailyTrans"); dg.ItemsSource = (System.Collections.IEnumerable)dt.DefaultView; dg is the WPF Datagrid plz the above code works fine in my WPF c# app but i want to know weda this is the best way of setting the data location for a grid dynamically i rely don want to use the item binding..cos i want more control Thanks

modified on Sunday, August 23, 2009 12:07 PM

Thanks am trying it out.. thanks a mill

foreach (DataGridViewRow dr in dgproducts.Rows) { if (Convert.ToInt32(dr.Cells[9].Value) < Convert.ToInt32(dr.Cells[6].Value)) { ## //i need to color this row here } } ## i need to colour the particular row at that point of the loop i cant find anything like in that intellisense and sub-intellisense maybe am not checking well. any help plz

Thank you very much Sir

this is a sample account statement generation for an e-banking software Plz i want the accounts and customers details to appear even if no transactions exists. am finding it difficult making that work..i have tried full outer joins and outer joins any help? code below IF @type='RANGE' BEGIN print 'Query began' SELECT (SELECT Openbal FROM Accounts WHERE SUBSTRING(AccNum,9,4)=@AccNum) AS openBal,(SELECT Name FROM ThisCompany) AS CompName, (SELECT Branch FROM ThisCompany) AS Branch, (SELECT StreetAdd FROM ThisCompany) AS StreetAddress, (SELECT AddLine1 FROM ThisCompany) AS AddLine1, (SELECT AddLine2 FROM ThisCompany) AS AddLine2, @dt1 as Date1,@dt2 as date2, (SELECT Tel1 FROM ThisCompany) AS Tel, (SELECT Website FROM ThisCompany) AS Web, SUBSTRING(Accounts.AccNum,9,4) AS CustNum, Accounts.AccType, Accounts.Currency, Customers.FName+' '+ Customers.LName as FName, Customers.CorrespAdd, Transactions.Dt, Transactions.Debit, Transactions.Credit, Transactions.TranDetails, Transactions.Bal FROM Accounts FULL OUTER JOIN Customers ON Accounts.CustNum = Customers.CustNum FULL OUTER JOIN Transactions ON Accounts.AccNum = Transactions.AccNum WHERE SUBSTRING(Accounts.AccNUM,9,4)=@AccNum AND Transactions.Dt BETWEEN DATEADD(dd,1,@dt1) AND DATEADD(dd,1,@dt2) ORDER BY Transactions.Dt ASC RETURN END

look at your OS login Form and add a web form and design it just like that

The default extender sample website works fine on my computer but this one does not work i am trying to just get the files from a folder so i can easily add images to that folder any help my code here [System.Web.Services.WebMethod] [System.Web.Script.Services.ScriptMethod] public AjaxControlToolkit.Slide[] GetSlides() { DirectoryInfo ajdir = new DirectoryInfo(@"images"); int s=ajdir.GetFiles().Length; FileInfo[] ajfiles = ajdir.GetFiles(); AjaxControlToolkit.Slide[] Slide = new AjaxControlToolkit.Slide[s]; int Count = 0; foreach(FileInfo f in ajfiles) { Slide[Count] = new AjaxControlToolkit.Slide("images/"+f.Name+"","",""); Count++; } return Slide; }

it will be nice if u paste ur error msg here though i find a prob with your code. I just want to be sure

thank you sir.....am trying to check around it right away but plz...are there any tips as to where to actually look around? Thanks once more well da dataset displays da correct number of rows and records

Plz google out stufffs First b4 u post here.Thanks http://www.scampers.org/steve/sms/libraries.htm

Please correct me if i am in the wrong post i am pulling data from a db to populate a crystal report document. when i run the query in 'toad 4 sql editor'' or sql management studio' i get about 6800 records but when the report is generated i get only 4 records. I even test the rows of the datatable being passed to the reports and it says 6800 records but the report actually shows 4 records in the first and only page. no subsequent pages exist here is a samnple code 'creates a new instance of the report Dim DrvReport As New CRDrivers 'test the number of rows generated MsgBox(dt.Rows.Count) 'set the dataseource 4 the report DrvReport.SetDataSource(dt) 'set report source 4 da crystal report viewer CRViewer.ReportSource = DrvReport CRViewer.RefreshReport() DrvReport.Dispose() i have been using crystal but never experienced this before.Sorry for my long text Plz help..thank you all

PLZ WHAT SQL COMMAND DOU TYPE THERE TO VIEW THE TRIGGERS AND THEIR CODES

READ on the SMTP class in vb.net,its very easy..u will get it

I just joined a company that uses SQL 7.0,which am not that much used too. i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS and can view triggers and other objects with 'sysobjects' i want to view the code for the triggers in a particular table... PLEASE HELP ME...THANKS

I just joined a company that uses SQL 7.0,which am not that much used too. i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS and can view triggers and other objects with 'sysobjects' i want to view the code for the triggers in a particular table... PLEASE HELP ME...THANKS