John Papa
MSDN Magazine May 2004
View Complete Post
MSDN Magazine January 2002
I have two (parent-child) tables that are bound by a primary key (PK)/foreign key (FK) relation.each PK is identity (idStudent and idBac)
to insert data, i'm using an little application in c# i programmed myself where i insert these columns for the Student table: F_Name, L_Name, Age, Mobile, Adresse, City ,and ( i don't know how to handle the idBac wich is foreign key of the other table wich still not inserted yet)
for the table Bac, i insert section, school, and city.
what i want is when i click on "OK" button, the idBac ,wich is a foreign key of the other table (BAC), receives the same idBac given the moment i inserted the BAC informations too ...
i don't have any problem wich ado.net ...i just want the right query/procedure.
thanks in advance and sorry for my english, it's not my mother tongue.
Hi All,
I am at my wits end and need some help, I have a dynamic data site, and have built a formview for my parent table, Claims (parent), Claims has a child table called DamagedVehicles, I want all the fields on the Cliams table and the fields on the DamagedVehicle to be displayed for insert on the same formsview, when the user fills in all data it should insert the claim and the damagedvehicle at the same time and set the foriegn key on the Damagedvehciles row to the Primary key of the claim, I dont know were to start any examples in VB.net or C# will be greatly appricated. i have been search for 3 days now trying to come to a solution and nothing has worked.
thanks in advance.Andrew
Hi dear coders
though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.
i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net
i will be highly thankful for any kind help from you geniuses.
regards
alok
Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.
Julie Lerman
MSDN Magazine August 2010
Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.
MSDN Magazine July 2010
LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.
MSDN Magazine May 2010
Did you know that by precompiling LINQ queries you might actually be degrading your app's performance if you're not careful? Julie Lerman explains how to ensure you're not re-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.
MSDN Magazine March 2010
In this month's column, John Papa shows you how the DataForm control works and how it can be customized.ÃÂ He presents in detail a sample application that uses several features to bind, navigate, edit and validate data using the DataForm.
MSDN Magazine October 2009
In this month's column, the author shows how binary encoding works, the effect it has on an application's performance, and how it behaves by demonstrating it in action.
MSDN Magazine August 2009
Silverlight 2 applications are restricted to running inside a browser. However, Silverlight 3 applications can run inside the browser or out. Here we build a social networking app as a standalone Silverlight 3 application.
MSDN Magazine June 2009
ADO.NET Data Services and Silverlight make a powerful combination, but to make them work well together, there are a few things you need to understand. Here, John Papa explains.
MSDN Magazine April 2009
Here we build a syndicated news reader application to illustrate the use of isolated storage and data syndication in Silverlight.
MSDN Magazine February 2009
John Papa tackles questions about calling services from Silverlight 2 applications.
MSDN Magazine November 2008
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend