Search results for query: *

Go through the following line of code If you have Table A and you want to get the data Dim strqry as string strqry="select column1 from A where column1='" & textbox1.text & "'" After this u can do whatever u want. Whether u want to display the results in the grid based on this query or...

I have checked those links also. But I was not able find a solution.Any other solution for this?

I used this while modifying the records. But I was not able to catch the exception.I removed them(i.e Set modified) and then I got the exception Exception: System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records. Then I added some of the columns to...

code I am using Transcation Sever Where I have written Saving function After creating the Dataset I wrote the code in the front end Dataset.Tables("Tablename").Acceptchanges for i=o to Dataset.Tables("Tablename").rows.count-1 Dataset.Tables("Tablename").rows(i).setmodified next In...

I am using command builder for inserting and updating of records. The records are inserted properly. But when I try to udate the records in the table No column is updated. I am not getting any error or exceptions Can anyone guid me? Should I call GetChanges?

wORKING FINE Thanks The code you have given is working absolutely fine. Thank you very much.

I am checking the item in the checked list box. There are many items in the check box. If the item checked is at the bottom it should be displayed. i.e The focus should go to the checked item. Item is checekd after it is retrieved from the table. how to solve this problem?:confused:

Use Runnin Total Field Have you used details section in your report? If you have used details sections you use running total field in the field explorer. You will find the options for summing of amount after you right click on Running total field and select new. You can calculate grand total...

Check Viewstate Just check if you have set the viewstate property to true or not. If not set viewstate property of the form to True. I feel this should workout.

Thaks Ok Mr Kulrom I will check this out. I am using VS.net 2003. Is the feature you mentioned is available in vs.net 2003? Of course I had forgotten to tell you one thing. Since IIS on my machine is having some problem I am running web applications using ASP.NET Web Matrix. Will ASP.NET...

Send screen shot if possible You try this out. Set viewer.displaybackgroundedge property to false. Still if you are finding any problem just send me the screen shot of your rpt file.

Sholud i write the same code in HTML view Mr Kulrom sorry for disturbing you again. I want to know one more thing whether I should write the above piece of code in HTML view also?:confused:

group tree button Mr Deseydel What you have done for the problem is perfectly right. But with that you should also set viewer.showgouptreebutton to false. Then you will not see any margin on the left. Even if you dont set this property you can solve this at runtime. You have to just click on...

you can export it but I feel there is no way you can preview report in HTML format. But of course you can export the report to PDF,doc etc. There is one export button in the crystal report viewer. When you click on that button export to dialog box will appear. Then you can select the type you...

The code is above Yes Mr Kulrom. You are right. The code is in my first post. So I want to know if I am missing anything there. If I have missed anyhitng I want some sample code. Can you provide me with some sample code?

Now no error Thanks Mr Kulrom. Now I am not getting that error. But one more problem I am having. After clicking on submit button it is not redirected to another page. Nothing happens. can you suggest some code corrections?:)

It is not possible.But alternative way It is not posiible to load specific page in the crystal report viewer if there are more than one page. But in your form you can give the page selection option and select a specific page for viewing. For this you have to write write a code for click event...

do like this I think you must be right clicking the solution. You must right click the project. There you find add->add new item. Now add new item dialog box will appear and you can find you can find the crystal reports in teh templates plane. Just select crystal report option and name it as...

Re:Can anyone help? Hello Can anyone help me out ? I am new to asp.net

Insert special field You just right click on the rpt file(e.g. Report1.rpt) go to insert . There you will find the option special field where you select PageNofM and put it on the page Header. The report will print the page No as you wanted. I feel this should solve your problem.