.NET GENES

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! :)

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

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

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=" &

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.