myprofessionalitblog.blogspot.com
My Professional IT Blog: Dynamic jQuery calls from code behind VB.NET
http://myprofessionalitblog.blogspot.com/2013/11/dynamic-jquery-calls-from-code-behind.html
Monday, November 25, 2013. Dynamic jQuery calls from code behind VB.NET. Simple Function call: You can call the jQuery from code behind with the help of ClientScript.RegisterStartupScript():. Assign via the control: If you have multiple controls on a page and need to make an individual jQuery call based on condition (not for every time; let say after the button click). L Result: asp:Label runat. Save Button: asp:Button runat. SbAppend(vbNewLine) sb.Append( " scr. SbAppend(vbNewLine) sb.Append( "$('#".
myprofessionalitblog.blogspot.com
My Professional IT Blog: September 2010
http://myprofessionalitblog.blogspot.com/2010_09_01_archive.html
Thursday, September 23, 2010. Save and display images to and from SQL Database C#. Save images on the Database. Let say, I've a fileupload control to browse images and a button to upload images on SQL database. Write this code inside the button click event:. To store image into sql database. ImageSize = new byte. FileUpload1.PostedFile.ContentLength];. UploadedImage = FileUpload1.PostedFile;. UploadedImage.InputStream.Read(imageSize, 0, ( int. FileUpload1.PostedFile.ContentLength);. CmdConnection = conn;.
myprofessionalitblog.blogspot.com
My Professional IT Blog: January 2014
http://myprofessionalitblog.blogspot.com/2014_01_01_archive.html
Thursday, January 16, 2014. Merge Two Rows in SQL. Let's create a table:. StudentId, Semester) ;. I am going to show you the third one here: Rank by semester and then pivot on the rank:. Rk = 1 then. Rk = 1 then. Rk = 2 then. Rk = 2 then. StudentId, Course, Semester,. Subscribe to: Posts (Atom). Make me your Homepage. Computer Engineer (MCTS,MCPD). View my complete profile.
myprofessionalitblog.blogspot.com
My Professional IT Blog: January 2011
http://myprofessionalitblog.blogspot.com/2011_01_01_archive.html
Tuesday, January 11, 2011. Encode and Decode the QueryString parameter value. Let say, I have a web application where I send data from a page to another page via QueryString. If the Querysting value contains '&' sign, it'll truncate the data after this sign and we won't get the matched data:. NavigateUrl=' %#DataBinder.Eval(Container.DataItem,"book name","chapter Matches.aspx? DataBinder.Eval(Container.DataItem, "book name". And in chapter Matches.aspx:. Str = Request.QueryString[ "book name". Results = ...
myprofessionalitblog.blogspot.com
My Professional IT Blog: April 2011
http://myprofessionalitblog.blogspot.com/2011_04_01_archive.html
Thursday, April 14, 2011. Reset MSSQL Table Identity. We can use DBCC CHECKIDENT to reset the indentity value of SQL table. Let Say, you have a SQL table with Auto-Increment ID. If you delete the records from ID numbers 10-15 and insert the new record, it'll take the next ID i.e. 16. But if you want the new record starts from ID: 11, you can do this with the help of simple single query:. So, it'll reset the indentity to 10 and next ID will be autoIncrement by 1 i.e. 11. Subscribe to: Posts (Atom).
myprofessionalitblog.blogspot.com
My Professional IT Blog: Disable Dates in Calendar Extender & Calendar Control
http://myprofessionalitblog.blogspot.com/2013/02/disable-dates-in-calendar-extender.html
Wednesday, February 6, 2013. Disable Dates in Calendar Extender and Calendar Control. CalenderExtenders don't have OnDayRender Event, It is specially for Calendar Control. For CalenderExtender we can use some JS function:. Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %. DOCTYPE html PUBLIC "-/ W3C/ DTD XHTML 1.0 Transitional/ EN" "http:/ www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd". Http:/ www.w3.org/1999/xhtml. CheckDate(sender, args) {. Milliseconds in a day.
myprofessionalitblog.blogspot.com
My Professional IT Blog: July 2012
http://myprofessionalitblog.blogspot.com/2012_07_01_archive.html
Wednesday, July 11, 2012. SQL Select result displays Horizontally Separate by comma. Let say you have a table structure and data as follow:. Then you would need a SQL select output as. Table1where Id = 1. Or you could do like this:. T1Id = t2.Id. T1Id, t2.Id. Subscribe to: Posts (Atom). Make me your Homepage. Computer Engineer (MCTS,MCPD). View my complete profile.
myprofessionalitblog.blogspot.com
My Professional IT Blog: August 2012
http://myprofessionalitblog.blogspot.com/2012_08_01_archive.html
Friday, August 24, 2012. Get Email Addresses and Send Email SQL. Let say, you have a form to order books and 'Customer' table to save the information with 'Customer Name', 'Email', 'Shipped Date', 'Received' columns. I want to write an auto email query in SQL and would like to run by SQL agent so that the customer would get an e-mail reminder if they forget to return the books in 3 weeks from the shipped date. EmailList ';',. Email IS NOT NULL). Received = 0) 'bit value. Profile name = 'Your Profile Name'.
myprofessionalitblog.blogspot.com
My Professional IT Blog: Merge Two Rows in SQL
http://myprofessionalitblog.blogspot.com/2014/01/merge-two-rows-in-sql.html
Thursday, January 16, 2014. Merge Two Rows in SQL. Let's create a table:. StudentId, Semester) ;. I am going to show you the third one here: Rank by semester and then pivot on the rank:. Rk = 1 then. Rk = 1 then. Rk = 2 then. Rk = 2 then. StudentId, Course, Semester,. Highly Appreciated your comments. Subscribe to: Post Comments (Atom). Make me your Homepage. Computer Engineer (MCTS,MCPD). View my complete profile.
myprofessionalitblog.blogspot.com
My Professional IT Blog: July 2010
http://myprofessionalitblog.blogspot.com/2010_07_01_archive.html
Monday, July 19, 2010. Multiple SQL rows merge into single row if the ID is same. Let's create with a table example:. Identity(1,1), PersonID int. 1, 'Che YYYY'. 1, 'Phy XXXX'. Replace space in your column with a special character and remove it in your select statement. Unit,' ','. SELECT t1.PersonID,. SELECT Unit AS [data()]. T2PersonID = t1.PersonID. Subscribe to: Posts (Atom). Make me your Homepage. Computer Engineer (MCTS,MCPD). View my complete profile.