|
One of the things I did in VS2008, was to call GetChanges on the dataset during the FormClosing event to determine if changes have been made but not saved. Doing this in VS2010 always returns a non-null value even if the dataset has not been changed. This is causing the user to be prompted if they want to save their changes even though they just selected the SAVE icon from the application which saves any changes. I even tried calling AcceptChanges but I still get a non-null value coming back from GetChanges.
Is this a bug, or did something change in VS2010. Is there another way to check this?
Thank you,
Glenn
|
|
|
|
|
When I click button Update this error is cccurred :
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.
my SqlDataSource is:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AdNetConnectionString %>"
SelectCommand="SELECT AdCampaign.CampaignName, AdCampaign.AdType AS [Campaign Type], AdCampaign.Date AS [Start Date], AdCampaign.Clicks, AdCampaign.Impr, AdCampaign.DailyBudget AS [Daily budget] , AdCampaign.Status FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)"
UpdateCommand="UPDATE AdCampaign SET DailyBudget = 30 FROM Account INNER JOIN AdCampaign ON Account.ID = AdCampaign.AccountID WHERE (Account.EmailAddress = @EmailAddress)">
<SelectParameters>
<asp:SessionParameter Name="EmailAddress" SessionField="EmailAddress" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="EmailAddress" />
</UpdateParameters>
</asp:SqlDataSource>
the parameter :
<asp:Parameter Name="EmailAddress" />
is a session parameter.
I am waiting please guide me.
|
|
|
|
|
When you click the Update button, some other command was executed. Since I don't see a statement containing "nvarchar" in the code you have posted, I believe you have hooked up the event handler to somewhere else. You can track down the problem using your debugging environment and pinpoint the problematic statement.
|
|
|
|
|
I don't use Wizards to do my database work. But this parameter isn't supposed to have a data type ?
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
How to form this logic in a true sql?
Select * from AdCampaign where category and language and keyword in
(select sitecategory, language, keyword from Adzone)
|
|
|
|
|
You can use a join. Use something like this:
select a.* from AdCampaign a inner join Adzone b
on a.category=b.sitecategory and a.language=b.language and a.keyword=b.keyword;
|
|
|
|
|
Could I replaceany of the dqual "=" into "like"?
|
|
|
|
|
You will need to give further details about your requirement. What do you want to achieve with "like"? In SQL "like" matches a pattern, similar to using wild cards. In your case, you seem to mean something else. I may not be able to answer your question, but if you offer more details, somebody else may have an answer.
|
|
|
|
|
I had an error with % at end of query
<pre>select a.AdHeadline,a.AdText,a.DisplayUrl, a.TargetUrl from AdCampaign a inner join Adzone b
on a.sitecategory=b.category and a.language=b.language and a.keyword like %b.keyword%;</pre>
Error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'b'.
|
|
|
|
|
make it as
'%'+b.keyword+'%'
|
|
|
|
|
USE pubs<br />
IF EXISTS (SELECT name FROM sysobjects <br />
WHERE name = 'au_info2' AND type = 'P')<br />
DROP PROCEDURE au_info2<br />
GO<br />
USE pubs<br />
GO<br />
CREATE PROCEDURE au_info2<br />
@lastname varchar(30) = 'D%',<br />
@firstname varchar(18) = '%'<br />
AS <br />
SELECT au_lname, au_fname, title, pub_name<br />
FROM authors a INNER JOIN titleauthor ta<br />
ON a.au_id = ta.au_id INNER JOIN titles t<br />
ON t.title_id = ta.title_id INNER JOIN publishers p<br />
ON t.pub_id = p.pub_id<br />
WHERE au_fname LIKE @firstname<br />
AND au_lname LIKE @lastname
this example was taken from msdn like examples
Marc Clifton wrote: That has nothing to do with VB. - Oh crap. I just defended VB!
|
|
|
|
|
Hi,
I'm writing an application and I keep receiving an "Invalid Operation Exception" with this message: "Update requires a valid UpdateCommand when passed DataRow collection with modified rows."
I created a DataSource using the "Add New Data Source" option from Visual Studio 2010 and dragged the controls onto the form. The dataset is set to detail instead of datagrid.
Showing at the bottom of the form I have a ktReunionDataset, reunionBindingSource, reunionTableAdapter, tableAdapterManager.
This table was originally created from a MS-Access database and then was cloned using Visual Studio. I assigned a primary key to the "ID" field through the Server Explorer via the Open Table Definition, then right clicking on the ID field and assigning it the Primary Key. The ID field shows a key icon indicating it's the Primary Key.
The code for the Save button off the navigator looks like this:
private void reunionBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.reunionBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.kTReunionDataSet);
}
Do I need to manually code an update for when the user presses the save button, and iterating through each entry? I have looked at other examples and it doesn't have an update attached to the Data Adapter only Fill and FillByxxx so I'm not sure I need to add something here? Any help is appreciated.
Thank you,
Glenn
|
|
|
|
|
have you tested your update SQL statement on the database? if so does that give an error?
Marc Clifton wrote: That has nothing to do with VB. - Oh crap. I just defended VB!
|
|
|
|
|
Please don't remove your question after you have received an answer (you posted a message regarding this problem on the VB.NET forum). Others may have the same question, and can benefit from the answers.
If your adapter only has a fill command, then you may have configured it incorrectly. Try to configure it again, somewhere the wizard will ask you if you also want update, delete, and insert commands. I suspect that you left some checkbox unchecked the first time when you created the adapter.
My advice is free, and you may get what you paid for.
|
|
|
|
|
I got this to work, it appears that Visual Studio did not generate the Update methods. After going into the design view of the dataset and right clicking on the Fill,GetData of the TableAdapter and selecting "Configure" then clicking NEXT all the way through re-generates everything. After doing this everything works perfect.
Glenn
|
|
|
|
|
Ex:
Tables:
1) Account: ID,UserName,Pass
2) Campaign: ID,AccountID,Date,Balance
3) CampaignSpec: ID,CampaignID,Spec,Color
Note: Account.ID = Campaign.AccountID and Campaign.ID = CampaignSpec.CampaignID
|
|
|
|
|
delete a, b, c
from Account as a inner join Campaign as b
on a.[id] = b.[id] inner join CampaignSpec as c
on b.[id] = c.campaignid
and just include any where clause that you need else all will be deleted
Marc Clifton wrote: That has nothing to do with VB. - Oh crap. I just defended VB!
|
|
|
|
|
I would suggest the more "proper" way to do this would be to set up proper foreign key relationships along with cascade options in the database. Then you don't have to worry about this at all.
|
|
|
|
|
Hi,
I have one table as,
id Items
1 col1
2 col2
3 col3
another table as
Sid col1 col2 col3 col4
1 A B NULL NULL
2 D E NULL F
now i have to compare Items of tbl1 with columns of tbl2.
here i need the output as true or false from select query.
for ex. col1 of tbl1 is compared with col1 of tbl2.if the col1 has value then it should return false. if all values are null then it should return as true.
here im expecting col1-false,col2-false,col3-true
Nothing is Impossible. Keep always Smiling... 
modified on Wednesday, May 5, 2010 5:39 AM
|
|
|
|
|
What have you tried so far ?
My advice is free, and you may get what you paid for.
|
|
|
|
|
I created a table in SqlServer with
CREATE TABLE Foo(
column1 bit not null default 0,
.....
)
this implicitly created a randomly named constraint which would set the default value.
Now when I try to run
ALTER TABLE Foo DROP COLUM column1
I got the error message DF_Foo_colum_2F34CDE is dependent on column1,
i.e. the randomly named constraint which sets the default value prevent the deletion of the column.
Now I could fix that on my database, but how could I write a script which will work on all databases?
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
I found out how to find those bastards!
SELECT * FROM sys.sysobjects Where NAME LIKE 'DF__Foo%'
or
SELECT * FROM sys.objects type_desc='DEFAULT_CONSTRAINT'
But I also had a better work around: 
1. these nameless constraints being only on developers machines so far, I just dropped them manually
2. and give them a name in the create table with
CREATE TABLE FOO (
column1 bit not null CONSTRAINT DF_Foo_column1 DEFAULT 0
....
)
A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.
|
|
|
|
|
Hello,
I am trying to read a DateTime value from an Oracle database (Oracle Version 11.2.0.1.0 running on a German Windows XP). The column is defined as "DATE", and the value is correctly shown as "2010-05-04 16:17:10.0" via the web browser when viewing all the data of the respective table.
But when I retrieve the data with the OracleClient (via OracleCommand and OracleDataReader) in a C# application (.NET 2), I receive a string (!) value of
"04.05.10 " , i.e. reader["LASTLOGIN"] returns a string with that value which I then convert to a DateTime using the Convert.ToDateTime() function.
By the way, a
int lastLoginCol = reader.GetOrdinal("LASTLOGIN");
LastLogin = reader.GetDateTime(lastLoginCol);
yields a "Specific cast is not valid" error message.
Please note the 6 blanks after the date part. Where has the time part gone to?
How can I retrieve the full date time value? Is the answer: "Not at all, it's Oracle"?
And what about a situation where the server is running with a different locale than the client? Is it really necessary to change to CHAR 14 (i.e. YYYYMMDDhhmmss - that does work with some tricks)?
Thanks a lot for your ideas!
Bernhard
|
|
|
|
|
The Oracle DATE type for the column does not have a corresponding equivalent within most languages you will use. As a result it must be cast to some other intrinsic type. Usually what will happen is that Oracle will convert it to a string using a session specific date format specification. Look up on NLS_DATE_FORMAT and if you don't know what that format is, the following might help you
SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
In .NET all you have to do is open an OracleDataReader from an OracleCommand and then call GetDateTime. It works for me. .NET should handle all the type conversion issues: the OracleDataReader "knows" how to convert SQL types to .NET types so that I don't have to. It's called encapsulation. Or maybe abstraction, I can never remember the difference between those two.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
