thank you leppie but i couldn't find out your post..could you please repost it or post the link for that

hi... can any one help me to monitor/limit the bandwith usage of PC with c# 2. i have searched through web and didn't get any positive result..

thank you very much.that's working.:)i was trying with System.IO.Path.GetFileName. :)

i want to populate combo by file names which contain on specified folder on form load.still i couldn't find a way. can anyone help me to solve this.

thanks if i try to backup to "c:\" it's giving that error .but if i backup to "c:\new folder" it's ok.i dont know why's that and what'll i do.i think that's not sql account problem.

BACKUP DATABASE [db] TO DISK = N'D:\Classes' WITH NOFORMAT, INIT, NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 i use this query to backup my db with sql express 2005. it's fine.but when i use direct partition(eg. C:\) or desktop it's giving error as os error and access denied anyone can help me

thx. but that's not working.. now i use this way create dataset and populate it using database table and write xmlschema from dataset then use xml file as database file of report.it works fine

sorry i can't get what you'r saying.could you please explain

i,m using c#2005 and sqlexpress. in my projects i use separate class for db connection and call that on project. there i use connection string as ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database\\stock.mdf;Integrated Security=True;User Instance=True"; as i understand this db created on project location and it attached to sql server when project(or build exe) running. after successfully build project i could see db had attached to server as "D:\Equipmanager\Equipmanager\bin\Debug\Database\stock.mdf" everything ok.db connection works fine. but problem comes when i start reports. there i tried on ADO.net and OLE DB.but wizard shows only default dbs.master etc....(actually my project db attached to server when running.show how it show there?) here's my problem... 1. can i use this connection string...is there any problem... 2. how to use project db for reporting(use crystal report)..?should i attached db manually and do report? if i use sql 2000 this problem ok.because there every db is attached and not separate file. currently i get db details by code and pass those to report(actually this connection string fine.because when deploying db is automatically attached.no need to do it manually) but passing parameter is not good when long report.that's why i want to find way connect db to report?

i want to use dataset with created runtime to populate my report.i use this code Classes_Obj.getRecord is return dataset but this gives error as "The report has no tables" could anyone help me Dim aa As DataSet aa = Classes_Obj.getRecord("select * from Frames") ReportPurchase.SetDataSource(aa) ReportViwer.rptContainer.ReportSource = ReportPurchase 'ReportPurchase.PrintToPrinter(1, False, 0, 0) ReportViwer.ShowDialog() -- modified at 9:08 Monday 27th November, 2006

Db2 is running on as400. We want to have a copy of the data on a windows server with ms sql server. a. Is there an odbc driver for db2 so we can query db2 from within ms sql server? b. More in general: how can we copy data from db2 to ms sql server and maybe automate this? c. what else do we need to know or is there some guide available online.

i have to draw pie chart on my application run time.i used this way. create a graphic object and then draw lines. my problem is when from minimize or other form come over that from,drawing is refreshing(erasing) is there a way to prevent this.

i have populated a data grid with like this dim QryFrames As String = "SELECT F.ProductId, F.BrandName, F.Collection, F.Temple, F.Bridge, F.Eye, F.FrameName, F.Color, F.Meterial, F.FrameType,F.FrameShape, F.RimType, F.LenseColor, F.Gender,F.QtyInHand,F.ReorderLevel FROM Frames AS F INNER JOIN Stock AS S ON F.ProductId = S.ProductId and F.GrnNo=S.GrnNo" ds = classes_obj.getRecord(QryFrames) dgAddReorder.DataSource = ds.Tables(0) here getRecord function return dataset for passes qry string. this works on index change event of combo box. my problem is user change combo box selected item this return (populate data grid) different order.that mean not in same order. eg. say i want to get ReorderLevel for last column of data grid.so i place it as last item of Qry.but different times it get different location.(but first time ok. i think this because of cashing or something of dataset.) i want to get this same position every time. regards. amila pradeep

please mention the version of ide u use.in vb 2005 this property is available on property window.go n chk there

i have to insert one record and update another 2 table. if update is no successful i want rollback inserted transaction. problem is i use one public connection to create connection with db and every time i use that.and use class and it have update and insert function. in this case i don't know how to use transaction object. i use vb 2005. as a example in case i want to add a record i just call classname.addrecord("qry") and classname.update("qry") can anyone help me. regards amila pradeep

if we use vs 2005 masked text box, there's no way to privent input spaces.(using array key can put blank) can we privent this. anyone's help

i have filled a dataset.it's getting only one row.that mean only one row on db according to query. now i want to get values from dataset to text field. can anyone help me

i have used check constarin like this constraint disignation CHECK(Designation IN('Key Person','Assignee')), when i try to enter data using my code it,s getting error on this constrain. in the code i have used combo box and there fixed items.i access this item using "bombobox1.selecteditem" but i check it using msgbox and it,s giving correct word.i,m confused with this coz i have used this on vb.net 2003 now i,m using vs2005 can any one help me my quary string is like this "insert into Complaint values('" & cbocustomerId.SelectedItem() & "','" & cborepID.SelectedItem() & "','" & cbosource.SelectedItem() & "','" & rtxtdescription.Text & "','" & cboempID.SelectedItem() & "','" & txtdate.Text & "','" & cbocatagory.SelectedItem() & "','" & cboFtype.SelectedItem() & "' ,'" & txtvehicleNo.Text & "','" & txtbustop.Text & "','" & cboOp_dept_no.SelectedItem() & "','" & cbostatus.SelectedItem() & "','" & txtrefNo.Text & "','" & txtplace.Text & "')") -- modified at 7:39 Monday 22nd May, 2006

ok i got the anwser.i had not specified as mix authentication on sql server, thanks

i want to use sql authentication.i created a new user account with sql mangement studio.but i can't connect using it with sql authentication. i use same username and password on my coding. getConnectionString_local = "Server=Z1\SQLEXPRESS;Database=" & DBPath & "test;User ID=amilapradeep;Password=amilapradeep;Trusted_Connection=False" it's this then it gives error as "Login failed for user 'amilapradeep'. The user is not associated with a trusted SQL Server connection." but i can connect using "attach db" method it's connecting