10 days of the seventh day learn ASP.net

Learning Objective: Learn to add remove modify the record

ASP in the past, whether we add or delete records or to use SQL statements with EXECUTE () or is directly RECORDSET of NEW, DELETE, UPDATE and other methods to add delete modify records. Which we use in ASP.NET with SQL statement object to execute SQL statements COMMAND way to add delete modify records. This is up from that record is also easy to read. Actually only one difference, the ExecuteReader () was revised to ExecuteNonQuery () can, because we do not need the return value ah.
string strConnection = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =";
strConnection + = Server.MapPath (strDb);
OleDbConnection objConnection = new OleDbConnection (strConnection);
OleDbCommand objCommand = new OleDbCommand ("Here is the SQL statement", objConnection);
objConnection.Open ();
OleDbDataReader objDataReader = objCommand.ExecuteNonQuery ();

-----------------------
dim objConnection as OleDbConnection
dim objCommand as OleDbCommand
objConnection = new OleDbConnection (Provider = Microsoft.Jet.OleDb.4.0; Data Source = "+ Server.MapPath (strDb))
objCommand = new OleDbCommand ("Here is the SQL statement", objConnection)
objConnection.Open ()
objDataReader = objCommand.ExecuteNoQuery ()

Cite the following examples illustrate the SQL statement (ACCESS):

Add record: insert int
o table name (field 1, field 2) values (string 1, string 2) where the conditions
Delete records: delete from table name where conditions
Modify the record: update table name set field 1 = 脳 脳, field 2 = 脳 脳 where conditions

Require special attention, if it is to delete record delete Sql Server table name, do not need to add from the.

Here today, tomorrow, said inside the most famous ASP.NET DATAGRID.






相关链接:



Reviews Seasonal - Screen Savers



Directory Web Development



AMD expects Q4 REVENUE to fall about 25%



Terminal promotion on doing SOME of the views



Telnet in RHEL 5 on the OPENING process



comparison Personal Finance



Correctly UNDERSTAND the IPD of the "structured process"



Younger's Quickstep



M2TS to MKV



Easy Food And Drink



Photoshop Rendering Realistic Beautiful Necklace



The Rise Of Domestic Erp Market Share In 2010



MKV to VOB



Cool I am a LEADING online high quality music box



Flash to MPEG



TMPGEnc --- MPEG Compression King



INSURANCE Goes to focus on risks and preventive measures

Beat my opponents so

I remember a few years ago, I followed up a hotel project in the city. In fact, it's a year ago, I conducted a thorough investigation by a number of ways the market is estimated at about this hotel will be conducted in two lock management system reform. Thus, the hotel's name, in my diary on the top of the constantly forward, and finally entered the focus of my business to track the object list. During this time, I did everything possible, use every opportunity to continue with them into contact with different departments. In the end, from CEOs to the clerk, getting along all Jiaoshu, and they all know that I am selling a lock.

One day, the Finance Department received a Miss the hotel phone, call me in the past to help them a little better. I rushed to the hotel, financial Miss told me that they are preparing the budget hotel transformation, asked me to lock, monitor, and front desk management system to provide some help. I'm so happy, of course, make every effort to help. I immediately look for veterans, respectively, procurement vice president and chief engineer, hope they will consider my company's products. When told that the transformation of the whole package, and has determined the contractor, and the contractor has worked with me a few times more likely to trust each other, my heart felt, won the single business, with great certainty.

I found the general contractor, that I had come, the boss told me that my product in the list of candidates, ranked first, and total hotel workers and works minister said were called to give priority to my product, I Fengyun heart finally hung a little practical. But I dare not be complacent, often contacts with hotels and general contractor. During this period there have been dealers to enter, mostly to the impact of the price that the sword, and I was a professional explanation to convince the hotel and the general contractor declined them.

After about ten days, when I once again came to general contractor here, we found the situation a little different. When I move almost the same when they play, their faces do not always feel natural, not like the original advice to me as some of the technical aspects of the installation process. Look at the sample area, my samples are gone, replaced by a general quality, but also little-known product. I know the boss of marketing this product, people quite live, but in our industry, in the city, her performance is not how good. I asked how this is going on general contractor, he did not answer me, and told me to ask the hotel will know. But when asked when I went to the hotel, and no one told me how the thing just kept on comfort me, and lost not a single business, you will starve, or lose it time to look for other business. I think that I could not just die for no apparent reason, even if I lose, I have to know how I failed, but also a good sum up, in subsequent operations can not be repeated. I went to inquire about general contractor that end, the procurement minister told me that the contract price, my God, higher than my tens of dollars a quote, and asked me: "Do you know the boss of operating this product? Anyway, I do not know. "I said:" I know people very live. "procurement minister:" Do you think she like? "I said:" Indeed you can. "procurement minister:" It does not have to matter, She accompanied the hotel office for three days, you can do so! "My God, there is such a way, I nearly fainted at that time. This opponent, I really no match for her.

Three months later, the officers fired by the hotel, but this is not important to me, the important thing is that I spent so much energy and effective, then failed to get one. But I remind myself, in this market, we should pay attention to this man, he was dry in the line of file in the future should work, if his figure at the time, certainly in this respect he buttoned. (Postscript: A year later, the door of the hotel to spend our management system has had, as installed in front of major quality problems, the guests are locked in the room can not get out, are forced to change).







Recommended links:



MKV to Xbox 360



Report Hobby



China Business Daily: Who Is the end of the traditional MP4



LOOKING for a breakthrough signing strangers



My favorite Dictionaries Education



Waves Resurgence - Purple VS Sogou Contest



MPG to AVI



ASP.NET 2.0 At The Same Time To Prevent The Same User Login



Shopping GUIDE all high-end DVD recorder Raiders



Children's Books list: Foreign Books victory, was embarrassing domestic children's books



Comparison of six agent approach



FLV to iPod



Sogou Pinyin input method and how to do conflict Game?



build home made windmills



Comments: Baidu more recent non-