(Method 1)Sample Code to delete XML Node Using linq C#:
(Method 2)Sample Code to delete XML Node Using linq C#:
Script to read Query String Value.
Originally posted on Journey to SQL Authority with Pinal Dave:
Note: If you want to practice the code and the example along with here, you can download dbForget Studio from here.
Everyone, who is involved in work with databases, eventually faces with data export/import tasks. Unlike data import tasks, data export has to be performed in various formats, depending on the business requirements of customers. SSMS capabilities allow saving selection result in the CSV format or as a text file with delimiters. Moreover, SQL Server supports the OPENROWSET construct, which usage enables export to XLS files. However, this functionality was scarcely enough for me to perform current tasks. In order to resolve the situation and meet customers’ requirements, I had to automate the export process using dynamic SQL.
At first, such an approach justified itself. For example, here is an HTML markup generating script for a random table/view:
, @object_id INT
, @record_count INT
View original 599 more words
Originally posted on Justin Cooney:
Have you ever wanted to help your users move data from Excel to your Web application? In this article I will give an example in ASP.NET that takes copied Excel spreadsheet rows from the user’s clipboard and saves the information to a SQL Server database table.
View original 839 more words
If you are working with files in asp.net it is better to Store the files on the file system and filepath in the database. In many situations, databases are stored on fast (read: expensive storage, 15k RPM or SSD drives) storage. Images or other files, typically can be stored on slower (read: cheaper, larger drives, 7.2k RPM drives) storage.
still if you want to store files in DataBase only, better to use FileStream field type which can provide the best of both worlds.
Subject: Here we can Learn how to Handle Double click event of Asp.Net controls using Jquery, here i will explain with asp.net button control
If you are New to Jquery Start from here.
first take new asp.net empty website and add jquery library to website and add one asp.net webform and write following code
Here i am explaining Example with Master pages, the reason is, when the asp.net webform renders as html in browser it will assign dynamic ids for asp.net controls while merging master page and content page. Here why asp.net assigning dynamic ids, because to avoid naming collision
so here we have to use
this statement to get asp.net control with dynamic id
and Bind method will bind events to control, here we are binding click and double click events
in this click event we are preventing default behavior of asp.net button control, i.e preventing post back
Double click Event:
in this double click event write your code…
If u have any drought feel free to contact from AboutMe page