View Complete Post
I want to be able to pass multiple parameters through DataNavigateUrlFormatString both th PONumber and ProjectCode.
Could someone please help me?
<asp:DetailsView ID="DetailsView8" DataSourceID="AccessDatasource8"
runat="server" Height="50px" Width="125px" AutoGenerateRows="False"
NavigateUrl="~/bringPO.aspx" Target="_blank" />
<asp:BoundField DataField="PONumber" HeaderText="PoNumber"
SortExpression="PONumber" HtmlEncodeFormatString="True" />
<asp:BoundField DataField="ProjectCode" HeaderText="ProjectCode"
I have code, shown below highly simplified that works all except for 1 thing: The variables being passed byRef get passed, but once modified in RecordData, they are never updated in the calling function. The calling function does not receive the updated
data that is in the variables custid and amt. When debugging, I see the data in the else section of if me.invokerequired, but once it returns from the callback and is in the latter part of if me.invokerequired the data is missing.
How do I fix this?
Delegate Sub RecordDataCallback(ByRef custid As String, ByRef amt As Double)
Private Sub RecordData(ByRef custid As String, ByRef amt As Double)
If Me.InvokeRequired Then
I have created an SSRS in BIDS 2008 with OLEDB Provider so as to access MS Access 2010 DB. My report is working fine. But the only problem is when am sending multiple parameter it raises error. I have enabled AllowMultiple Value checkbox.
ERROR : "Cannot add multi value parameter '@parametername" for DataSetName because it is not supported by the data extension".
My query is "SELECT * FROM tablename WHERE ([columnname] in (@parametername))"
Thanks in advance
I have multiple apps running which access a sql server database. I had initially a table set aside for each app but now I was told to put everything into one table and have all apps access the database. I just want to make sure that just changing my connection
string for all apps will suffice and that I do not have to make any other changes for all apps to write to one table. Will this be ok? The apps are writing to the database table which has a unique index on one column and a auto incremented primary id key.
I changed the stored procedures I had for each app since the connection strings were the same as they access the same database. Just want to make sure there will be no conflict issues when each tries to write to the same table. None of the apps will be querying
the table at any time except when I run manual queries myself.
I created a new database with the help of Database Configuration Assistant !
I created with the scott account
Now i'm not able to connect to the database with the connect identifier with the scott account
The error i get is.,
Plz help !
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
MSDN Magazine August 2009
Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.
Alok Mehta and Daniel Williams
MSDN Magazine January 2002
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
I am trying to use a parameter field where there is a subreport in my main report but i keep getting the error "subreport cannot be shown" when running the report. Any ideas please.
p.s - I have just set the parameters the same in the subreport as the main report.
Hi,I've working on a chat type project at the moment. I was originally using a DB but decided to move to XML which has improved speed a lot and also made the control more portable. I have two related issues that I was hoping you guys could pass comment on.The first is dealing with multiple users either reading or trying to write to the xml file when someone else already has it open. I've had to be an Exception loop around the write process to 'queue' the writes from different users. This means that sometimes there is now an issue with speed of response.The second issue is to do with the speed at which my code read and writes xml. Speeding it up would help my app generally and but would also help with issue one.Here is my code. Just so you are aware, when someone makes a post it does Savemessage and then Getmessages. Getmessages also runs every 3 seconds regardless:
public List<Chat.Message> Getmessages(int numberOfMessages, int lastMsgID)
List<Chat.Message> res = new List<Chat.Message>();
DataSet xmlDB = new DataSet("xmlMSG");
if (xmlDB.Tables.Count > 0)
// I only want a maximum of the last
Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?