Dotnet Tips, ASP.Net, C# , SQL Server, JQuery, JavaScript

the parameterized query which was not supplied

This error will raise while the passing parameters with NULL values, we can handle this exception

if(LoanRefNo!=null)

{

parameters.Add("@lRefNo", SqlDbType.NVarChar, LoanRefNo, 50);

}

else{

parameters.Add("@lRefNo", SqlDbType.NVarChar,DBNull.Value, 50);

}

textmode password field blank when using wizard

The Textbox's Text Mode is password when using it in Wizard or Multiview the text values will get clear while moving to another view or wizard, So in like that situation we go to ViewState or Session,Dont go for hidden Field cause we can see hidden field values in View Source,so its not secure.

ViewState["mypass"] = txtPassword.Text;

Multiview1.ActiveViewIndex =1;

Select and Delete multiple rows using Linq

Here am using two line statement to select multiple rows and delete the same in proper way.

var result = Context.tablename.Where(data => data.fk_applicantID== 21);
Context.tablename.DeleteAllOnSubmit(result);

Context is the instance of Linq Data Context .

small things may help lot.

-----------------------------------------------------------------------------

Additionally want to know this: Garbage Collection

CONVERT VS TRY_CONVERT IN SQL 2012

Sys is not defined

I faced this problem, i did what had mentioned in the above screen shot. Its working fine for me.

how to identify the sql server edition

select serverproperty('edition')

The result will look something like:

32-bit: Enterprise Edition

64-bit: Developer Edition (64-bit)

Determine Size of a Table in SQL Server

sp_spaceused ‘Tablename’

How to read child nodes from specific xml file

you need to use here is theXLINQ. After adding the reference to System.Xml.Linq

in your program do write the below code.

XElement companyInfo = XElement.Parse(
                @"<COMPANYINFO>
                    <CORPORATE ID=""C45RT4C"" NAME=""NEW COMPANY LTD."">
                        <LOCATION ID=""P88972FC"" NAME=""EASIER"">
                            <SUBLOCATION ID=""S89872FE"" NAME=""400462""/>
                        </LOCATION>
                        <LOCATION ID=""PDRD2905"" NAME=""XT-454560-5"">
                            <SUBLOCATION ID=""SFDF22D7"" NAME=""202743""/>
                            <SUBLOCATION ID=""S106B993E"" NAME=""401048""/>
                            <SUBLOCATION ID=""SDEA2907"" NAME=""507152""/>
                            <SUBLOCATION ID=""123C699"" NAME=""507180""/>
                            <SUBLOCATION ID=""HTY4C896"" NAME=""507205""/>
                            <SUBLOCATION ID=""SFD580DD"" NAME=""600281""/>
                        </LOCATION>
                        <LOCATION ID=""PD1104ED"" NAME=""TD-454560-4"">
                            <SUBLOCATION ID=""211704EF"" NAME=""202724""/>
                            <SUBLOCATION ID=""SFD37943"" NAME=""401056""/>
                            <SUBLOCATION ID=""XDEA2A2D"" NAME=""507169""/>
                        </LOCATION>
                    </CORPORATE>
                </COMPANYINFO>");
            foreach (XElement subLocation in companyInfo.Elements("CORPORATE").Elements("LOCATION").Elements("SUBLOCATION"))
            {
                Console.WriteLine(subLocation.Attribute("NAME").Value);
            }

If condition in Repeater,Listview

while binding data in repeater i need to do a if condition in the same repeater, so i use below one.

<table>

<div id="Div1" runat="server" visible='<%#Eval("TextA") !="" %>'> // true or false

<tr>

<asp:TextBox ID="TextBox1" Text='<%#Eval("AnimalGroup") %>' Width="100" runat="server"></asp:TextBox>

</td>

<asp:TextBox ID="txtQno" Text='<%#Eval("QNO") %>' Width="100" runat="server"></asp:TextBox>

</td>

<asp:TextBox ID="txtTextA" Text='<%#Eval("TextA") %>' Width="500" runat="server"></asp:TextBox>

</td>

</tr></div>

</table>

</ItemTemplate>

Its working fine..... Thanks