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 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
System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records.
Then I added some of the columns to...
I am using Transcation Sever Where I have written Saving function
After creating the Dataset I wrote the code in the front end
for i=o to Dataset.Tables("Tablename").rows.count-1
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?
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...
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...
group tree button
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...
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.