ASP.Net - How to Format Date in Bind Statement inside a label

Watch this example on YouTube



<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("BirthDate","{0:MMM dd, yyyy}") %>'></asp:Label>

</ItemTemplate>

ASP.NET 2013 - How to bind multiple data to itemtemplate label in gridview

Watch this example on YouTube




 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
            <Columns>
                 <asp:TemplateField HeaderText="Customer" SortExpression="CustomerID">
                     <ItemTemplate>
                         <asp:Label ID="Label1" runat="server" Text='<%# String.Format("{0} {1} {2} {3} {4}" ,"(", Eval("CustomerID") , "-" ,Eval("CustomerName"), ")") %>'></asp:Label>
                     </ItemTemplate>
                 </asp:TemplateField>
            </Columns>
        </asp:GridView>

MS Sql 2013 - How to fix error Must declare the scalar variable - another example

Replace

Declare @CustomerIDs VARCHAR(50) = '1,2'

declare @CustomerTbl table(Stat nvarchar(300))

insert into @CustomerTbl

select DISTINCT CustomerID

from CustomerMaster

WHERE ','+ Convert(varchar(50),@CustomerIDs) +',' like '%,'+ Convert(varchar(50),CustomerID) +',%'

Select * FROM CustomerMaster INNER JOIN

@CustomerTbl ON CONVERT(VARCHAR(300),CustomerID) = @CustomerTbl.Stat

With

Declare @CustomerIDs VARCHAR(50) = '1,2'

declare @CustomerTbl table(Stat nvarchar(300))

insert into @CustomerTbl

select DISTINCT CustomerID

from CustomerMaster

WHERE ','+ Convert(varchar(50),@CustomerIDs) +',' like '%,'+ Convert(varchar(50),CustomerID) +',%'

Select * FROM CustomerMaster INNER JOIN

@CustomerTbl ct  ON CONVERT(VARCHAR(300),CustomerID) = ct.Stat

MS SQL 2013 - How to fix error - Must declare the scalar variable

Watch this example on YouTube



Replace

DECLARE @Customer VARCHAR(20)

SET @Customer = '1'

Declare @sql varchar(max)

Set @sql = 'SELECT * FROM CustomerMaster '

Set @sql = @sql + 'WHERE CustomerID =  @Customer'

Execute(@sql)

With

DECLARE @Customer VARCHAR(20)

SET @Customer = '1'

Declare @sql varchar(max)

Set @sql = 'SELECT * FROM CustomerMaster '

Set @sql = @sql + 'WHERE CustomerID = ' +@Customer

Execute(@sql)

How to import contact from BlackBerry to Samsung Galaxy S4 in a few seconds

Watch this example on YouTube

ASP.Net - How to disable days in Calendar, change color of disabled days, strike out

Watch this example on YouTube



protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)

{  if (e.Day.Date < DateTime.Now.Date)

{                  
   e.Day.IsSelectable = false;

   e.Cell.ForeColor = System.Drawing.Color.Red;

   e.Cell.Font.Strikeout = true;


}

} 

Microsoft Visual Studio 2013 - How to switch between tabs in code editor using key shortcuts

Watch this example on YouTube


use Ctrl+Shift

C# - How to fix error - 'StringBuilder' could not be found

Watch this example on YouTube


You may receive this error if you translated VB.NET code into C# using some online translator

Error 1 The type or namespace name 'StringBuilder' could not be found (are you missing a using directive or an assembly reference?) C:\Users\livingroomadmin\Documents\Visual Studio 2013\Projects\WebApplication1\WebApplication1\WebForm1.aspx.cs 16 13 WebApplication1

to fix it simply add

using System.Text

C# - How to fix error - Newline is constant

Watch this example on YouTube

Replace
text = text.Replace("\\", "\");
with
text = text.Replace(@"\\", @"\");

ASP.NET - Grid View - How to remove grid header

Replace
<asp:GridView ID="GridView1" runat="server" ></asp:GridView>
With
<asp:GridView ID="GridView1" runat="server" showheader="false" ></asp:GridView>

ASP.NET - CSS - How to apply 2 classes to control

Wath this example on YouTube.

Example that shows how to apply multiple css classes to one div
I have 2 classes in my css

.DefaultFontColor {

color: red;

}
 .DefaultFont {

font-size: 20px;




}

then in html
<div class="DefaultFont DefaultFontColor">


some text  </div>

C# - How to fix error - The type or namespace name 'Threading' could not be found (are you missing a using directive or an assembly reference?)

Watch this example on YouTube


Replace
 catch (Threading.ThreadAbortException ex) { }
with
 catch (System.Threading.ThreadAbortException ex) { }

MSSQL - How to fix error - The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Watch this example on YouTube

  

Replace

SELECT TOP (1000) id,comment

FROM Test.dbo.TableTest

GROUP BY id, comment  

With

SELECT TOP (1000) id,CAST( comment AS VARCHAR)

FROM Test.dbo.TableTest

GROUP BY id, CAST( comment AS VARCHAR)