M.Waqas Aslam

use selection formula option of crystal reports , and set your criteria. Regards

you can use registry values for this . here is a link having detail information and code. hope this will solve your prob :) [Click Here](http://www.rune-server.org/programming/application-development/tutorials/299016-vbulletin-net-how-create-trial-version-implement-your-application.html) Regards

try this class Calendar { public Calendar(ref NullableDateTimePicker Picker) { } } i use this site to convert code from vb.net to c# [Click Here](http://www.carlosag.net/tools/codetranslator/) Regards

Michael , where to use Close() ? can please explain it ?

you can simply do this //import the sqlclient library at the top like this using System.Data.SqlClient; 'now you can connect to your database like this SqlConnection con = new SqlConnection(|"Data Source=YourServerAddress;Initial Catalog=YourDatabaseName;Integrated Security=SSPI;"); con.Open(); //here you can perform any database operation using different objects like //sqldataadapter //sqldatareader //sqlcommand con.Close(); every …

as pgmer said you have to populate your datagrid again each time when you insert , update or remove record, Regards

please ALWAYS post precis question , there is no time to read all your debugging information . what is your prob? ,tell us your prob in simple words.

hello! i am currently working on a simple file make application , this application read data from foxpro .dbf file , i want to get records between two dates , from date and to date , the invoice date field name is fl02 here is my query but this is …

you can also change the value by just double clicking in it . but this will not change value in your dataset or datatable Regards

i think in order to create your own programing lang you have to know deep knowledge about assembly lang . complier , assembler. every programing lang first convert in assembly lang before machine code. so you can simple make a text editor , define some reserve words like in every …

just loop your datagrid view and save values , you can do like this for i = 0 to datagridview.rows.count -1 'your code here next Regards

hello ! recently i complete my project management application in .net , now i want to make a attractive main form , i google alot and searching attractive interfaces of application of same domain. i want to you to guid me or if possible then give some links . you …

you want to show output from the database and show it in your textbox ? if yes then you can use sqldatareader for this. Regards

you want to display files of that selected employee or data of file of that selected employee ?

"select * from table1 where @yourDate between hiringdate and contractEndDate and id = @ID '@yourDate and @ID are the variable fields. try this , may be this will solve your prob. Regards

linabeb. to find error use debugger , just place a break point then use f11 to check each line of code to find where is the error. this will help you in future , now to get the proper error you can use try catch , like this try 'your …

well you can do like this , as in my computer there is no mssql installed so may be this will not work properly but give you an idea. select distinct fname ,'','' from table union all select distinct '',mname,'' from table union all select distinct '','',lname from table this …

you have to first add columns to your grid in order to add rows to it , first add columns then add rows Regards

please visit this link , hope this will help you to solve your prob. [Click Here](http://social.msdn.microsoft.com/forums/en-US/vbgeneral/thread/8d9ff8b9-2d3e-4ce4-a3be-98a451464080/) Regards

to day is 65th independence day of pakistan . please wish my country a great future and piece , our soilders fighting for the global piece , even my elder brother captain Faiz also give his life for this noble cause . 40,000 + soilders of pakistan killed in this …

can you please tell me what is your prob , just posting your code is not sufficient to help you , explain your prob so that any one can help you. Regards

here are some links , they will help you to take first step [Click Here](http://vb.net-informations.com/communications/vb.net_chat_server_program.htm) [Click Here](http://social.msdn.microsoft.com/Forums/da-DK/Vsexpressvb/thread/05d24093-87cd-4bc7-ba99-f9d8711fcaf5) Regards

just add web browser control to your form and use this code webbrowser1.navigate(application.startuppath & "\a.html") it will load that file in your web browser control. hope this will solve your prob. Regards

you can set the modifire property in property window of your control public from private , then you can access it on your second form like this frmMain frm = new frmMain(); txtGetText.Text = frm.txtMyText.Text hope this will help you.

to download from ftp you can use this my.computer.network.download(ur ftp address+filename,username,password,destination folder+filename) 'as i just typed it here so may be the sequence of parameters may be different. so please advance sorry for this. Regards

well , there is not that much time to read all your code , i have a better suggestion for you , you can just edit all the records in your grid , after that save all your records , it is simple fast and it will reduce your work …

hello ! i am working on a telerik reports , i worked on them in asp.net and we can just pass parameters to the report by by just doing this Response.Redirect("rptReportViewerTelerik.aspx?report=rptInvestmentAnalysis&fromDate=" + txtFDate.Text + "&toDate=" + txtTDate.Text + "&doctorTypeID=" + txtDType.Text + "&investmentTypeID=" + txtSegType.Text + "&locationID=" + txtLocation.Text); but …

i think you can join datatables using Linq queries ,i dont know much about it but you can google it , regards

in order to add new row you have to define column in your grid then just add row like this for example i have to textboxes txtName , txtFatherName and a grid with two columns , name and father name , a button , i want to add new row …

everything has some basics , you should start from basics , first study about strings , constants , variables ,conditional statements , loops , functions , datatypes , arrays ,pointers,classes , objects etc. along with it make some simple programs in c# which help you to get familier with practical …

you can make a view like this select i.invoiceNo , (i.amount) as Amount from invoices i where i.IsDeleted = 0 union all select i.invoiceNo , 0 as Amount from invoices i where i.IsDeleted = 1 and use this view in your report . this and then just add summary at …

brylle , please use your own thread for your question. do not post your questions in others thread. Regards

means there are more then one dataabases you have , ? and you want that your code will update the selected database ? if yes then do something like this dim con as new sqlconnection("your connection string") con.ChangeDatabase(comboBox.text) ' you can use combobox.selectedvalue con.open() '------------------ here you can use your …

just declare a variable of int datatype then use if statements to check conditions at your combobox selected index changed event.like this dim totPoints as integer 'use if condition like this if val(combobox1.selectedvalue) > 20 then totPoints = totPoints + 3 elseif val(combobox1.selectedvalue) > 30 totPoints = totPoints + 2 …

you can use replace like this update table set column1 = replace(column1, '|', ' ') May be this will solve your prob. Regards

you dont have select permission for this database , try to use windows athentication in vb.net or you can call it trusted connection string , in that string there is no need to give id and pass . [Click Here](http://www.connectionstrings.com/) at this site you can get connection string. Regards

hello ! i want to disable my usb port using c# or vb.net ,is it possible to do so using .net ? if yes then any idea how i can do this ? Regards

yes you can do it just open connection complete your work and close it.

ok here is a example , you can search your all emplyees by there names , do something like this first take a form with a grid and a textbox , now use this code at the textbox text change event. dim con as new sqlconnection("your connection string") con.open() dim …

update your qty and minus your sold qty from main qty.

you can use timer control , as mikey said if you are working on winform application. just add a timer control to your form , go to property window , set interval and call your function at timer tick event , HINT: in timer interval 1000 = 1 sec , …

yes you can use web browser control in vb.net form and after that you can easily edit the webpage. but for this you have to make your or custom browser. Regards

and i also want to add something in jim's comment that in your code you are using 4 cmd objects , 4 dataadapter and 4 datatable , it not good . just use this cmd as new sqlcommand() da as new sqldataadapter() etc this will reduce your code. Regards

you have to add all files present in bin folder of your project ,

i dont know about the auto width function in crystal report yes you use can grow property of your column , just set can grow property true. Regards

welcome you :)

here is query of mssql , i dont know about mysql , it may not work in mysql , but it will give you an idea to solve your prob. select s.articlenb , a.supplier ,a.cell, s.barcodenb s.barcodedescription s.instock from stock s inner join articles a on a.articlenb = s.articalnb where …

before coding , i think it is better to analyise your proj , and requirements then start developing database then start coding. , you can find so many hospital management application on net tril version or demo versions , after testing them you can better analyise your application . Regards

you can also use textbox text change event for this ,here is an example to in which we have to give qty and price and nettotal will calculated auto. 'use this code on the price textbox's text change event txtNetTotal.text =val( txtQty.text) * val( txtPrice.text)

i think you have to convert your int value first in decimal value and after that make calculations and then just convert your decimal value to string and concatinate it with "%" string. Regards