|
i was able to bind the dropdown but how can i retain the selected value while adding a new row in grid view having same drop down
|
|
|
|
|
hi
I want to use the crystal report in my application on the basis of dataset.
I have done it with dataset having single table but having this error with more than one table :
"Query Engine Error"
Here is the Code:
Dim DS As New DataSet
Dim Cnn As New SqlClient.SqlConnection
Dim DA As New SqlClient.SqlDataAdapter
Cnn.ConnectionString = "data source=sofsrv02\development;" _
& "initial catalog=Northwind;persist security info=False;" _
& "user id=sawd=;workstation id=alirazaooling=false;packet size=4096"
Cnn.Open()
DA.SelectCommand = New SqlClient.SqlCommand("Select A.PRODUCTID,A.PRODUCTNAME,B.SUPPLIERID,B.COMPANYNAME from SUPPLIERS B,PRODUCTS A WHERE A.SUPPLIERID=B.SUPPLIERID", Cnn)
DA.Fill(DS)
Dim oRpt As CrystalReport1 ' create new report object
oRpt = New CrystalReport1 ' create new instance of the report object
oRpt.SetDataSource(DS) ' set the reports data source
CrystalReportViewer1.ReportSource = oRpt ' set the viewers report source
It executes all the code but finally give me error.
Kindly Solve this Problem
Regards
Ali
|
|
|
|
|
This is the complete error.
Error in File C:\DOCUME~1\ALIRAZ~1\ASPNET\LOCALS~1\Temp\temp_2d2350fe-39ee-4e43-a51c-2503df13defd.rpt: Query Engine Error
Regards;
ALI
|
|
|
|
|
i was trying to run a website (language vb.net 2005).i got the following error.There is no coding work or designing work done in the web site.
I was trying to execute it and got the error.
Unable to connect to Visual Studio Local Host Web Server.
|
|
|
|
|
To use the web server built into Visual Studio, you have to start the site from within Visual Studio.
If you don't want to use the built in web server, you need to set up the site in IIS instead.
---
single minded; short sighted; long gone;
|
|
|
|
|
Did you change any of the project properties? e.g. To start in IIS as opposed to using the built in web server?
Do you have IIS installed on the current machine?
|
|
|
|
|
Gday everyone,
I have a critical problem that I really someone help
I need to get the a cell(this is not shown on Gridview) according to which row that user click on in a Gridview populated from a method in runtime.
Please help me. Thanks in advance.
Eric
eric
|
|
|
|
|
well i wanted to do the same thing but didn't find any solution.
you must have made the column invisible, when the column is invisible we can't access it contents
dont know how to do that 
|
|
|
|
|
Hello everyone, I'm having some troubles binding my gridview to an oracle database, I'm using the oracle provider 10, it doesn't generate the insert, update and delete, so i tried to write them down for the datasource but wasn't successful. How could i write my own insert , update and delete in for the gridview linked with that datasource ??
Thanks in advance
M.Shedid
|
|
|
|
|
I have a portal for users with different roles,I have defined roles for my users from asp.net configuration.by defining the users and their roles .Net 2.0 has created a database just for users.
For additional functionality in my portal I need more tables to add,I wanted to know wether I have to add tables to same database or to create a new database by myself and connect it to the database which .Net 2.0 has created!!
|
|
|
|
|
You can
a) add to the aspnetdb - not recommended since it may be shared by other other applications
b) create your own db and leave user data in aspnetdb
c) create your own db and register it as the target for asp.net user and profiles (asp_regsql.exe, I think)
only two letters away from being an asset
|
|
|
|
|
If I create a new database then how can I connect it to my users database??!!
|
|
|
|
|
Something called a connection string and a little programming knowledge and skill.
only two letters away from being an asset
|
|
|
|
|
If I knew it, I would'nt ask!!!therefore I need more explanation!
|
|
|
|
|
|
THANKS A LOT FOR YOUR VERY HELPFUL SUGGESTION PLEASE DONT BOTHER YOURSELF TO MUCH TO ANSWER MY PROBLEMS/QUESTIONS!!
|
|
|
|
|
You're welcome.  You have been answered, cool off and open your eyes and mind.
only two letters away from being an asset
|
|
|
|
|
ANYWAY TNX
|
|
|
|
|
The aspnetdb.mdf is just a database with the membership schema/functionality installed.
All you really need to do is rename the DB/Log file to something less ambiguous (e.g. client_db.mdf")
Now, the schema is intact along with all the functionality. Then change the DB name in your connection string, presumably in your web.config file to match that of what you renamed it too.
Then you can add all the tables you need, to the existing DB.
However, it would be good to brush up on the Memebership classes and security protocols like previously mentioned.
Hope this helps.
|
|
|
|
|
This website is designed for programmers. We will not just hand over chunks of code. If you have a piece of code that is not working, we can look at it and give you help. You are asking for something that is a basic, and a simple google search and a couple hours of reading/typing will solve your answer. but you want us to do it, and you're acting upset. Get over yourself and put a little brain power into it.
__________________
Bob is my homeboy.
|
|
|
|
|
YES MAYBE U R RIGHT!!
BUT AS FAR AS I HAVE CHECKED THIS WEBSITES DISCUSSION BOARD MOST OF THE QUESTIONS R MORE THAN A PIECE OF CODE/QUESTIONS!!AND UNFORTUNATELY/FORTUNATELY THEY GET THEIR ASNSWER!!
|
|
|
|
|
First, I don't understand your response.
Second, don't type in all caps. It's considered rude.
__________________
Bob is my homeboy.
|
|
|
|
|
I have a gridview showing ProjectCode, Contractor and the Project Cost. I want to iterate through the grid row and highlight the row with the lowest projectcost in green while the rest cost in another color. pls how do i go about this
t.aransiola
|
|
|
|
|
After binding the Data to the GridView find the index of the Row which contains
lowest projectcost.
let it be leastIndex;
gridView.Rows[leastIndex].Style["background-color"] = "#cccccc";
If it does not works:
make a loop and try to set the property to all the cells of that row:
gridView.Rows[leastIndex].Cells[i].Style["background-color"] = "#cccccc";
Regards,
Arun Kumar.A
|
|
|
|
|
Hi, I have declared sitemapprovider in my web.config file:
------------------------------------------
<system.web>
<authentication mode="Forms" />
<roleManager enabled="true" />
<siteMap >
<providers>
<add name="secureProvider" type="System.Web.XmlSiteMapProvider" siteMapFile="Web.sitemap" securityTrimmingEnabled="true"></add>
</providers>
</siteMap>
-----------------------------------------------------
However, when I try to use this map provider via menu control, I cannot see any item in the menu. What may be wrong?
I`m using standard Menu control with SiteMapDataSource, where I point the name of that provider declared in web.config file. Menu is placed in my master page.
Thank you very much in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
