Programmer Newsletter

Master Programmer Find articles on computer software, programming, ASP.net, Sql server, databases, C#, websites, Internet, Windows, Outlook macros.    Programming Articles Current Articles | Archives | Search Asp.Net Country and State Data Bound DropDownLists with Default Selected in Minutes For Asp.Net 4 using C# and Linq. Here is some handy code you can use to add Country and State DropDownLists to your form in a few short minutes.... Asp.net 7 Asp.net Gmail Smtp Error The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at Wrote some code to send email from my website via Gmail. The code is simple enough, but I kept getting the error: The SMTP server requires a secure c... Asp.net 12 Asp.net Linq Set Default Values from Database DetailsView Cannot insert the value NULL into In Asp.net 4, when trying to insert a record using a DetailsView with a LinqDataSource, I get the error message Cannot insert the valu... Asp.net 216 Create Linked Server for MS Sql Server to Remote IP or Internet Web Hosting Server I want to copy data to and from Sql Server Express running on my PC to and from Sql Server running at my web hosting company. One way to do this... Sql 263 Operator '==' incompatible with operand types 'Int32' and 'Object' This error happened to me when I was building a Master, Details page with a GridView and a DetailsView. These controls are designed to work together ... Asp.net 223 Asp.net GridView DataKeyNames Not Set, Empty In Asp.net 4, I was working with Master, Detail pages and was trying to get the Selected value from the GridView in an onSelecting event handler ... Asp.net 246 Asp.net GridView and DetailsView on Same Page with Search Box Click here to see an image of an Asp.Net GridView and DetailsView on same page. In Asp.net 4.0 I created a page with a GridView and DetailsView ... Asp.net 481 Asp.net 4 Menu Control Error with Ampersand (&) in Url Am using Asp.net 4.0. Am using an xml file to define the links for my menu control. Some of the links pass a query string so they need to have ampers... Asp.net 244 Asp.Net 4 The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. I upgraded my website to Asp.net 4.0 and started getting the following error. Am running Windows 7 with IIS. The 'Microsoft.Jet.OLEDB.4.0' pro... Asp.net 314 Sql Server Cannot Open Database Requested By the Login. Login Failed IIS APPPOOL This problem happened to me in my development environment using Visual Studio Express and Sql Server Express. The problem is my connection statement ... Asp.net 329 Asp.net Relative and Virtual Path Problems with Applications and Development and Production Environments When you use Visual Studio to develop a website application and you run the website in the Visual Studio debugger you get a url like this. http://l... Asp.net 310 Asp.Net User Control Content is not allowed between the opening and closing tags for element In Asp.Net 4, I have a user control for putting an email address on the page. The control looks like this. <my:email ...>Any Text</my:emai... Asp.net 298 The type or namespace name 'Objects' does not exist in the namespace 'System.Data' In migrating my website from Asp.Net 3.5 to 4, I got this error. The type or namespace name 'Objects' does not exist in the namespace 'System.Da... Asp.net 319 Disabling Printing, Selecting and Right Clicking to Prevent Copying Text and Saving Images Using Javascript and CSS Here is some useful code to protect the content of your website from the average viewer who may casually try to grab it. Of course, this will not pre... Web Browser Html Javascript Jquery 311 CSS List Bullets and Numbers Overlay Floating Image Have you had the bullets, numbers or letters for your list items overlay an image or some other item on your page? Try this. ul,ol { list-style-... CSS - cascading style sheets 665 Microsoft Sql Server Management Studio Express How to Edit More than 200 Rows In Microsoft Sql Server Management Studio Express (MS SSMS Express 2008), if you right click on a table you have the option to Select Top 1000 Ro... Sql 745 Asp.net Login Not Working in an Iframe If someone wants to embed part of your website within their website, a simple way to do that is using an Iframe. One problem is if people need to log... Membership 893 Giving Up for Now on Auto Resizing Iframe for Cross Browsers I have written a number of articles about how to auto resize an iframe to fit to the size of its contents.  This is a great thing, when it ... Web Browser Html Javascript Jquery 827 Css Center Images Horizontally You can try to use this CSS code to center an image. img.center { display:block; margin:0 auto; position:relative; } Use in your ... CSS - cascading style sheets 956 Sql Server Changing the Default Database In Windows 7, Sql Server Express R2 with SSMS, the default database is the master database. Not great. If you run a script and forget to specify the ... Sql 664 Understanding SqlCmd Variables and the Use Command SqlCmd variables appear to be object references or at least something related, not strings. SqlCmd variables can be set to strings, but they can also... Sql 2123 Powershell How to Make Windows Faster By Stopping Processes and Services The more programs running the slower your Windows computer will work. To speed up your computer, stop programs from running that you do not need... PowerShell 1122 Powershell Execution Policy Warning Cannot Be Loaded Scripts is Disabled on this System Powershell scripts are programs and can take over your computer. They are potentially dangerous, so by default Powershell scripts are disabled. You w... PowerShell 1004 Asp.net Menu Control Remove Inline Font-Size 1em The Asp.net menu control adds font-size:1em to the menu items. This prevents setting the font-size in a CSS style sheet. That is a nuisance. Th... Asp.net 1230 Asp.net Menu Control Horizontal Bar Separator Add the Easy Way When using the Asp.net Menu Control to display a horizontal menu, you might want to add a bar between menu items, like this: Item1 | Item2 | Item3 ... Asp.net 3468 Asp.Net Menu Control How to Skip the First Item If you are using an Asp.net menu control with an Xml file, you may have a problem in that the root node is displayed. For example, if your Xml file l... Asp.net 1038 How to Read a Delimited Text File in Asp.Net Using OleDb Including CSV or Tab Here is a handy way of reading a delimited text file into an Asp.net program. Rather than reading and parsing the file yourself, you can use the OleD... Asp.net 2368 Chamber of Horrors Cross Browser Programming Back in the day, when I first started writing software for the Internet, there were a few browsers around. The first thing that stuck out was they did... Web Browser Html Javascript Jquery 1127 Dynamically Resize Iframe to Fit Contents for Internet Explorer and Firefox Only works on the same domain. Wasted way too much time on cross browser support, but it must be done since Firefox and IE deliver about the same num... Web Browser Html Javascript Jquery 2401 Windows Live Mail Programming Macros SDK Wanted to write some code for the Windows Live Mail client. I have a bunch of different from email addresses. Some are for clients. The problem is, s... Windows 1736 Asp.net Menu Control Drop Down Not Displaying Appears Blank in IE8 When using IE8 the drop down menus with the Asp.net Menu Control do not show. You get the outline of the menu, but there are no menu items in the box... Asp.net 3008 How to Parse an Xml Document in Asp.net Grabbing Attributes Values and InnerText from ChildNodes Asp.net provides many ways to parse Xml Documents. How you parse your Xml document depends on the structure of your document and what values you need ... Asp.net 4487 Ustream.Tv Get Archived Videos for a User Ustream.tv lets you stream live videos. After your live show, Ustream automatically archives the videos. You can embed your live show on our website.... Asp.net 1590 Convert HTML and XML to Display on Web Page You may get some html or xml text that you want to display as is. To do this, you need to convert the text so that the web browser does not format the... Asp.net 1616 Asp.net Menu Control Drop Down Menus Display Badly in Safari and Chrome The Asp.Net menu control does not display drop down menus on Apple in Safari browser and may have problems on Chrome and other browsers. The two... Asp.net 2308 HtmlTextWriterTag.Div Downgrades to Table on Lower Level Browser in Asp.net Yikes, in Asp.net you can ask for Div tag  and get a Table tag. writer.RenderBeginTag(HtmlTextWriterTag.Div); That sucks. In my case, I ... Asp.net 1458 ASP Does Not Work in IIS 7 You are using Internet Information Services 7 or 7.5 and you get an error trying to bring up a classic ASP page. Server Error in Applicatio... Asp.net 2285 CSS for Information Highlights, Boxes and Tables Here is some CSS to make highlighting information on your website easy. Rather than putting the highlighting directly in your HTML code, you create a... CSS - cascading style sheets 1104 CSS Tables without HTML CellPadding and CellSpacing to Remove Space Between Cell Borders To have a thin line as a border around the cells in your tables, using HTML, you need to use the BORDER, CELLPADDING and CELLSPACING attribu... CSS - cascading style sheets 3155 CSS Background Image Url Not Working This CSS code adds a background image. .backimage { background-image:url(/images/imagefile.jpg);} If you followed the instructions for How to Fix ... CSS - cascading style sheets 1976 Add Avatars for Your Users An avatar is a picture icon that you place next to your user's name so people can identify a face or image with that person. You could go ahead and c... Website 1472 Dynamically Resize an Iframe to Fit Content and Prevent Scrollbars November 5, 2010 - updated code here. http://www.programmer.bz/Articles/tabid/159/asp_net_sql/243/Dynamically-Resize-Iframe-to-Fit-Contents-for-Inter... Web Browser Html Javascript Jquery 5606 How to Include Multiple Forms on One Asp.Net Page Asp.net only allows one form with the attribute server="runat" per web page. However, on the client side, you can have as many forms as you want. So... Asp.net 2279 Sql How to Get the First Occurance of a Value (Email) in a Column A common Sql problem is getting the first record of each set of records with a duplicate value in a column. For example, suppose you have a set ... Sql 1258 Variables in Sqlcmd Setvar and :r commands Author's note: updated the below article and have posted a new article on the same subject on May 3, 2011, for Windows 7, Sql Server Express 2008 R2. ... Sql 2867 How to Edit Outlook 2003 Email Message HTML Source In Outlook 2003 you can view the Html source, but you cannot edit the html source. Found a brilliant post with a macro to edit the html source in Out... Outlook 4023 Asp.net Accessing Page Object from Controls During Initialization When controls are initialized on an asp.net page, the Page object may not be available. You get an error message that says: Object reference not ... Asp.net 1331 How to Fix Problems with Internet Explorer that do not happen in other browsers When Internet Explorer does not work like other browsers it is often because the DOCTYPE was not specified. Add this to the top of your html document ... Web Browser Html Javascript Jquery 1496 Scrollbars on Iframe in Internet Explorer with Aweber Form Like Aweber email service a lot. They have a nice form generation feature, but the other day, their forms started showing up with scrollbars. Have fi... Web Browser Html Javascript Jquery 3115 How to start Powershell from Sql Server Management Studio Open Sql Server Management Studio (express version works). Click on databases, click on a database, right click on Tables, click Start Powershell. 1... PowerShell 2003 Page 1 of 2 First   Previous   [1]  2  Next   Last

Programmer Newsletter Subscribe to the Internet Handholding newsletter AWeber Email List Marketing Test Drive Use email marketing to convert targeted subscribers to customers. Let the system sell itself for you!