SQL Server 2008 Split Function Example to Split Comma Separated String into Table Rows

Description:

In this example we explain that how to split comma separated string into table values in SQL Server database or how to use split() function to split the comma separated string in SQL query.

Here we pass comma separated (delimiter) values as parameter to function in SQL Server. The comma separated values will be split into table rows and returns the result as a rows of table.

Here in this example we simply create one function that will take one parameter like as a string and return the table row by split the argument value based on delimiter specified in query and return table row. Below is the function for splitting the string into table rows in SQL Server:

Disable Submit button after one click using JavaScript and jQuery in asp.net

Description:

In this example we explain that how to disable button or submit button after one click on the button using JavaScript or jQuery.

Sometime we have requirements like user can click the button only once time like for example in company online attendees when user login and click mark to fill up his/her present in these scenario when employee click mark to present button then his/her attendees will be present and the click mark present button will automatically disabled.

Here we demonstrate how to disable button using JavaScript and jQuery in asp.net.

So implement this type of functionality in your application below is the easy code for you

Calling Parent Page method from Child Usercontrol using Reflection in ASP.Net using C#

Description:-

In this example we explain that how to call parent page method from child web User control using Reflection in asp.net using C#.or calling parent page method from child user control(web user control) placed on the same web page whose method (function) that we want to call using reflection in asp.net using C#.

Before we describe that first we will clear the concept of the Reflection. So what is Reflection and why we use?

Reflection is an objects that are used for obtaining type information at a runtime. Reflection allows you to check the type of an objects at runtime also change the behavior of the method.

The main important part to keep in mind is that parent page method is always declared as public otherwise child user control (web user control) is not able to call the parent page method.

Regular Expression (Regex) to extract Inner Text from HTML HyperLink control (Anchor tags)

Description:-

In this example we explain that how to get or extract the inner text from the HTML hyper link or asp.net link control using Regular expression(Regex) in asp.net using C#. Or how to get or extract inner text from html Anchor tag</a> using Regex expression.

In this example I have one textbox and one submit button in which textbox contain text including hyperlink and when I click on submit button then it extract only text (remove anchor tag or hyperlink) and display in one label control.

So how to extract or fetch only text from the Anchor tag or from Hyperlink using Regular Expression (Regex) in asp.net using C#.

Update Datatable using Linq in C# .Net

Description:-

In this example we explain that how to update datatable using LINQ in C# .Net. Or update datatable column value from other datatable using linq.

Here we explain with simply data table you can also use it with database.

Suppose you have two datatable in which first datatable contain employee id and employee name and second data table contain salary for each employee.so in this situation if you want to display employee name with salary in a single datatable or any data control you must have to use the following code like:

Using SqlBulkCopy to import Excel Sheet data into SQL Server in ASP.Net using C# .Net

Description:-
In this example we explain that how to import excel sheet data into sql server database using sqlBulkCopy in asp.net.

In previous example we already explain that how to use sqlBulkCopy to copy data from data table to sql server database.there is same scenario but here we use the fetch data from excel sheet file and transfer or insert it in sql server database.

SqlBulkCopy: Bulk Copy data from DataTable (DataSet) to SQL Server Table using C#

Description:-

In this example we explain that how to use sqlBulkCopy to insert bulk data to database in asp.net. sqlBulkcopy is used to copies all the rows or data in the supplied datatable to a destination table specified by the DestinationTableName property of the sqlBulkCopy object.

As the name suggest sqlbulkcopy does bulk insert from one place to another place like from datatable to sql server database.

Transferring data from one place to another is a common practice in a terms of software developments and also there are many ways to transfer data from one place to another but which one is the best suits for you.

how to fetch contacts from the EntityCollection in CRM plugin.

Description:-

In this example we explain that how to fetch or get all the contacts from the EntityCollection in CRM plugin.

Suppose if you have requirement like when appointment is created in CRM at that time CRM plugin fire and insert that appointment into external SQL server database. So in which scenario that is possibility when appointment created with multiple Required Attendance or multiple Optional Attendances. So how to fetch how many person or contact are available for this particular appointment.

To fetch all contacts from required attendance fields of the appointment you have to use EntityCollection and then you can easily fetch through for each loop like below code.

how to create appointment programmatically In CRM.

Description:-

In this example we explain that how to create appointment programmatically In CRM. Or create appointment in calendar using CRM plugin.

In previous example we already explain that how to create lead in CRM and transfer this lead data to SQL server external database using CRM plugin when lead is created same flow is occurred in appointment when new appointment is created in CRM then this appointment is automatically inserted to the external SQL database through web service using CRM plugin.

I have already realized that the CRM plugin is not fired for appointment when appointment is created in CRM and I also search this one why plugin is not fired for appointment. The question in my mind was that if plugin was fired for lead after creation of lead in CRM then why it is not working for appointment because same code only fields is changed like appointment fields instead of lead fields.