Posted inSQL
Function for Sorting in Sql
CREATE FUNCTION GetSortSql ( @SortBy nvarchar(100), @SortAscending BIT, @Default nvarchar(100) ) RETURNS nvarchar(max) AS BEGIN…
Posted inSQL
Function for Split String in Sql
create FUNCTION SplitString ( @sString nvarchar(2048), @cDelimiter nchar(1) ) RETURNS @tParts TABLE ( part nvarchar(2048)…
Posted inSQL
Function for Removing String Characters in Sql
CREATE FUNCTION RemoveStringCharacters ( @string nvarchar(max), @remove nvarchar(100) ) RETURNS nvarchar(max) AS BEGIN WHILE @string…
Use of Data Row in Data Table in Asp.net using C#
UserController objCont=new UserController(); DataTable dt = new DataTable(); //bind all values in dt dt=objCont.GetAllRecords(); DataRow[]…
Posted inASP.NET C#.Net JAVA SCRIPT
Javascript Function in Item Template when using gridview in Asp.net
<asp:TemplateField> <ItemStyle CssClass="lblCenter" /> <ItemTemplate> <asp:LinkButton ID="lnkButton" runat="server" OnClientClick=='<%# String.Format("javascript:return displayDeleteWarning(\"{0}\")", Eval("ClassId").ToString()) %>' </ItemTemplate> </asp:TemplateField>
Posted inASP.NET C#.Net JAVA SCRIPT
Add Java Script Function to gridview cells in Asp.net
//Add java script function on cells with value protected void GridUsers_RowCreated(object sender, GridViewRowEventArgs e) {…
Sorting in Asp.net using C# with up and down arrow image
.aspx Page
.Cs Page
if (!IsPostBack)
{
ViewState["SortingDirection"] = "";
}
Show alternate color on mouse over in gridview using Asp.net
// Use Gridview Row Created Event
protected void GridUsers_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
Convert Generic List in Data Table in Asp.net using C#
Steps for conversion
Step 1:
//Create structure or class for hold data
public struct GetUserInformation
{
public int UserId { get; set; }
public string UserName { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Email { get; set; }
public bool Approved { get; set; }
}
Step 2 :
public Da
Create DataTable in Asp.net at Run Time
Two ways to create data table
1.
//Add Column in data table
protected void AddColumns(ref DataTable ModyfiedTable, string[] columns)
{
for (int i = 0; i < columns.Length; i++)
{
ModyfiedTable.Columns.Add(columns[i]);
}
}
DataTable ModyfiedTable = new DataTable("ModyfiedTable");
//define the columns
string[] Columns = { "Description","Name","Email"};
//Call function to create columns
AddColumns(ref ModyfiedTable, Columns);
foreach (Info objInfo in myojb.data)
{
// create new row
DataRow Request = ModyfiedTable.NewRow();
