Posts

Donate

Databinding ASP.NET 4.5 GridView With jQuery And Ajax

Image
Hi, Here's a simple asp.net program that performs adding of data to GridView control through jQuery and ajax. On page load, perform databinding on dropdown list and gridview using server side and code behind. And on client side, that is a selection change occurs in dropdown list, perform binding by adding table rows and columns to GridView. Page Load (Load All Products): Selection Change (Load Specific Products): The sample code is available for download here: Databinding ASP.NET 4.5 GridView with jQuery and Ajax Code Cheers!

GeckoFX DocumentText Similar To Webbrowser Control Alternative (C#)

In this post GeckoFX DocumentText similar to Webbrowser , I presented a solution on how to retrieve the page source of a website. However, another solution was provided by a .NET guru using TextContent property: this .Document.GetElementsByTagName( "html" )[0].TextContent; Cheers!

How To Paint Or Set WPF DataGridCell Background Without Using IValueConverter

Here's how to paint WPF DatagridCell using extension methods without using IValueConverter. Extension Method: 1 2 3 4 5 6 7 8 9 10 11 12 Module DataGridExtensions < Extension() > Function GetRow ( ByVal grid As DataGrid, ByVal index As Integer ) As DataGridRow Dim row As DataGridRow = DirectCast (grid.ItemContainerGenerator.ContainerFromIndex(index), DataGridRow) If row Is Nothing Then grid.UpdateLayout() grid.ScrollIntoView(grid.Items(index)) row = DirectCast (grid.ItemContainerGenerator.ContainerFromIndex(index), DataGridRow) End If Return row End Function End Module MainWindow.xaml: 1 2 3 4 Dim firstRow As DataGridRow = grid1.GetRow( 0 ) 'grid1 is your DataGrid control Dim firstColumnInFirstRow As Controls.DataGridCell = DirectCast (grid1.Columns( 0 ).GetCellContent(firstRow).Parent, Controls.DataGridCell) 'set background firstColumnInFirstR

Split A String With Multiple Space As Delimiter Or Separator Using Regular Expression Or String.Split In C# and VB.NET

Given that you have a string that you want to split and the separator is two or more spaces. You can achieve using split() or Regex. VB.NET 1 2 3 4 5 6 7 8 Dim str As String = "Rule Name: WhosThere-176.44.28.203" Dim whosThereVar As String Dim whosThereString As String 'using split whosThereVar = str.Split( New String () { " " }, StringSplitOptions.RemoveEmptyEntries)( 1 ).Trim() 'using regex whosThereString = System.Text.RegularExpressions.Regex.Split(str, "\s{2,}" )( 1 ) C# 1 2 3 4 5 string str = "Rule Name: WhosThere-176.44.28.203" ; //using split string whosThereVar = str.Split( new string [] { " " }, StringSplitOptions.RemoveEmptyEntries)[ 1 ].Trim(); //using regex string whosThereString = System.Text.RegularExpressions.Regex.Split(str, @"\s{2,}" )[ 1 ];

Sorting A HashTable Object Using LINQ In C#.NET And VB.NET

Image
In .NET, you can't directly sort a Hashtable object. A tip on sorting a Hashtable object is to cast it to Dictionary then apply LINQ OrderBy() method to the Hashtable object. See examples below: VB.NET 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Private Sub SortHashTableKey () hash = New Hashtable() hash.Add( "B" , 1 ) hash.Add( "A" , 2 ) hash.Add( "C" , 3 ) Dim dict = hash.Cast( Of DictionaryEntry)() _ .ToDictionary(Function(d) d.Key, Function(d) d.Value) _ .OrderBy(Function(e) e.Key) Console.WriteLine( "Sort by Key" ) For Each item In dict.ToList() Console.WriteLine( String .Format( "{0}, {1}" , item.Key, item.Value)) Next Console.WriteLine(Environment.NewLine) End Sub Private Sub SortHashTableValue ()

Update ASP.NET Web Forms Label Control Value Using Continuous Mouse Down Click

Starting today, I'm going to contribute source code in vbforums.com( Visual Basic Forum ). The community helped me way back since VB 6.0 and VBA. And in turn, it's time to give back as an experienced member. :) Here's a an ASP.NET application I posted in ASP.NET code bank on how to update label values continuously on mouse hold. Update Label Value using jQuery/Javascript in ASP.NET Reference: Easily do a continuous action on mouse hold using javascript Cheers! :)

Bind XML Node Value To GridView Column In ASP.NET Using XPath

Image
Given in a datasource object where in you have a column which contains an XML string and you want to bind a certain node value instead of the entire XML string to GridView column, here's a solution using XPath. ASPX: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 <asp:GridView ID= "gvPersons" runat= "server" AutoGenerateColumns= "False" BackColor= "White" Width= "400px" BorderColor= "#E7E7FF" BorderStyle= "None" BorderWidth= "1px" CellPadding= "3" > <AlternatingRowStyle BackColor= "#F7F7F7" /> <Columns> <asp:BoundField DataField= "ID" HeaderText= "ID" > <ItemStyle Width= "50px" /> </asp:BoundField> <asp:BoundField DataField= "XMLData" HeaderText= "Name" > <ItemStyle Width= &quo

Retrieve Last Inserted Record In MySQL Database Using C#.NET

To get last inserted unique ID in MySQL, use LAST_INSERT_ID(). C# Code: 1 2 3 4 string insert_product_query = ( "INSERT INTO PRODUCTS (Stock) VALUES (5); SELECT LAST_INSERT_ID()" ); MySqlCommand cmd_query = new MySqlCommand(insert_product_query, objConn); int idResult = Convert.ToInt32(cmd_query.ExecuteScalar()); txtID.Text = idResult.ToString(); MySQL Docs: Getting Last Unique ID in MySQL

ASP.NET Generic Handler Not Downloading .pptx (PowerPoint) And .pdf Files Properly

Hello, There was a question raised in the forums as to why the generic handler doesn't download properly PowerPoint and PDF (.ppt/.pdf) files using Firefox but works perfectly using chrome and IE. The solution is to add a content-disposition header and set the ContentType property of context.Response. VB.NET Code: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Sub ProcessRequest( ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest Dim documentID As Int32 If Not context.Request.QueryString( "documentID" ) Is Nothing Then documentID = Convert.ToInt32(context.Request.QueryString( "documentID" )) Else Throw New ArgumentException( "No parameter specified" ) End If Dim strm As Stream = ShowDocument(documentID) context.Response.AddHeader( "content-disposition" , "attachment; filename=" &

ASP.NET MVC ActionResult With [HttpPost, HttpPut] Filter Not Executing

Given the ActionResult method and View that executes the controller. [HttpPost, HttpPut] public ActionResult Update(EditModel input) { if (ModelState.IsValid) { var person = Database.People.Find(input.Id); input.ToPerson(person); Database.SaveChanges(); return RedirectToAction( "Edit" , new { id = person.Id }); } return View( "Edit" , input); } View: @model PagedListTableMvcDemo.Models.EditModel @{ ViewBag.Title = "Edit"; } <h2>Update</h2> @using (Html.BeginForm("Update", "People")) { @Html.Partial("_Person") } When the user clicks the submit button rendered by the BeginForm helper, the browser shows an error URL not found or The view does not navigate to the Action with the corresponding Controller supplied in the BeginForm's parameters. The solution is to replace %5BHttpPost, HttpPut%5D with AcceptVerbs attribute. [AcceptVerbs(HttpVerbs.Post | HttpVerbs.

Donate