All Forums

How to avoid error while binding with special character

2013-06-20T10:55:41.353-04:00

the datasorce contain special character (please refer the image below)

while biding with this kind of data there retutn an error

There is an error in XML document (1, 1000612).

I have no idea how to replace this kind of symbol and have no idea how to avoid the error while gridview biding with themplease help.. thank you very much

which data control should i use?

2013-06-20T10:31:18.977-04:00

Hello

plz check the below sample and suggest me to which control shuld i use to display this kind of layout.

i used repeater control before but here i don't know that how to display data in 3 columns.

thank you

Windows Authentication

2013-06-20T08:53:18.27-04:00

Hi all,

I have made a CRM and i have to upload it on the server of my office,everything is done correctly,i have uploaded it correctly,but it is failing login,there is a network related issue may be.....it is not connecting to my databse or giving authorities gor logging in...what can be the solution...i tried to make user network service but this is also not permitted in the security part...i think i should go for windows authentication,,what are the steps dont know anything about it,do i have to change all my login page settings in which user name and password are stored in database...what is the way kindly help....

insert with coulmns and without columns -difference

2013-06-20T10:29:40.873-04:00

Hi all,

below the two methods for insertion.

insert into Customers values (val1, val2, val3......)


insert into Customers(col1, col2, col3.....) values (val1, val2, val3......)

in first one I didn't mention the columns but in the second query I used columns. Which one is good, beetr? and which one we should use?

How to bind img control to gridview.

2013-06-20T10:43:43.037-04:00

my image is stored in database and i have to img control (html control) to show in database. and image is stored in varbinary(max) format.

how to bind it to gridveiw???

jQuery not working into UpdatePannel

2013-06-18T10:03:50.273-04:00

I have a Slider that is retrtived image from database. I also added 3 options so that user can filter slider image by category. Everything is working perfectly. but problem is, every click refresh the full page. That's why I applied the "UpdatePannel". Now it's working except jQuery.

the code is:

<script type="text/javascript">
        $(document).ready(function () {
            $('.slideDisplay').cycle({
                fx: 'fade'
            });
        });
    </script>

for more detiail, here is the screenshot of hompage:

string split based on specified character

2013-06-20T10:34:52.8-04:00

Hi All,

I want to split a string based on the character on the string lets say(B, and F)

for example i want to break the string "B001B0002B000005F0006" to a string array like this {"B001", "B0002", "B000005", "F0006" }

how can i do this

how to change text in javascript

2013-06-20T10:35:56.337-04:00

when clicked if text is read more then chaange to read less

when again clicked the text is read less change it to read more..........

function Show2() {

var str=document.getElementById("readmore").innerHTML;
alert(str);
if(str == "readmore")
{
alert("if");
var n=str.replace("more","less");
document.getElementById("readmore").innerHTML=n;
}

else
{
alert("else");
var n=str.replace("less","more");
document.getElementById("readmore").innerHTML=n;
}

}

Above code change to read less but when clicked again not changing to Read more.plz suggest

I want to view Mark Semester Summary in gridview asp.net

2013-06-20T09:53:52.857-04:00

Each Semester Mark to show Each Gridview in single page,

I use this code

GridView gvs = new GridView();
for (int k = 5; k < 10; k++)
{
gvs.ID = "Gridview" + k.ToString();
gvs.DataSource = CreateSemesterSummary();
gvs.DataBind();
pnlTest.Controls.Add(gvs);
}

<asp:Panel runat="server" ID="pnlTest"></asp:Panel>

its Working Only one gridview at that time , I want to view more than 5 based on Loop

how to Show ???

This theaming format i want to show

<asp:GridView ID="GridView3" align="Center" style="text-align:center;" Width="750px" runat="server" CellPadding="2" PageSize="6"
GridLines="None" AllowPaging="False" ForeColor="#333333">
<AlternatingRowStyle BackColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<FooterStyle BackColor="#1C5E55" ForeColor="White" Font-Bold="True" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" Font-Names="Cambria"/>
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" Wrap="true" />
<RowStyle BackColor="#E3EAEB" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F8FAFA" />
<SortedAscendingHeaderStyle BackColor="#246B61" />
<SortedDescendingCellStyle BackColor="#D4DFE1" />
<SortedDescendingHeaderStyle BackColor="#15524A" />
</asp:GridView>

How do you detect browser from APIController?

2013-06-20T10:00:53.44-04:00

Questions in the title really, I have tried to use Request.Browser however APIController seems to be using a different object to the standard controllers.

Login with EMail Id or Mobile Number

2013-06-20T10:25:58.357-04:00

How to login with (EMail Id or Mobile Number as a user name) and password with authentication for this?

Can't see code behind. HELP!

2013-06-20T07:30:59.903-04:00

I'm using VS2010 and working on a website.... I only see the markup of my content page... what I did is add a button, double clicked it to place some code behind and this is what happened...

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" %>

 
<script runat="server">

    protected void SendMail()
    {
        
        
        // Gmail Address from where you send the mail
        var fromAddress = "ml17.santos@gmail.com";
        // any address where the email will be sending
        var toAddress = YourEmail.Text.ToString();
        //Password of your gmail address
        const string fromPassword = "Password";
        // Passing the values and make a email formate to display
        string subject = YourSubject.Text.ToString();
        string body = "From: " + YourName.Text + "\n";
        body += "Email: " + YourEmail.Text + "\n";
        body += "Subject: " + YourSubject.Text + "\n";
        body += "Question: \n" + Comments.Text + "\n";
        // smtp settings
        var smtp = new System.Net.Mail.SmtpClient();
        {
            smtp.Host = "smtp.gmail.com";
            smtp.Port = 587;
            smtp.EnableSsl = true;
            smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
            //smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
            smtp.Timeout = 20000;
        }
        // Passing values to smtp object
        smtp.Send(fromAddress, toAddress, subject, body);
    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {

        try
        {
            //here on button click what will done
            SendMail();
            DisplayMessage.Text = "Your Comments after sending the mail";
            DisplayMessage.Visible = true;
            YourSubject.Text = "";
            YourEmail.Text = "";
            YourName.Text = "";
            Comments.Text = "";
        }
        catch (Exception) { }
            
    }
</script>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style3
        {
            width: 451px;
        }
        .style4
        {
            width: 516px;
        }
        .style5
        {
            height: 21px;
        }
        .style6
        {
            height: 21px;
            width: 158px;
        }
        .style7
        {
            height: 201px;
        }
        .style8
        {
            width: 173px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table class="style1">
        <tr>
            <td>
                <table class="style1">
                    <tr>
                        <td align="center" class="style4">
                            <iframe width="450" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.com.ph/maps?ie=UTF8&amp;q=olympia+somerset+towers,+makati&amp;fb=1&amp;gl=ph&amp;hq=olympia+somerset+towers,+makati&amp;cid=0,0,1321729403434567995&amp;ll=14.556305,121.025788&amp;spn=0.006295,0.006295&amp;t=m&amp;iwloc=A&amp;output=embed"></iframe><br /><small><a href="https://maps.google.com.ph/maps?ie=UTF8&amp;q=olympia+somerset+towers,+makati&amp;fb=1&amp;gl=ph&amp;hq=olympia+somerset+towers,+makati&amp;cid=0,0,1321729403434567995&amp;ll=14.556305,121.025788&amp;spn=0.006295,0.006295&amp;t=m&amp;iwloc=A&amp;source=embed" style="color:#0000FF;text-align:left">View Larger Map</a></small>
                
                
                
                            
                            </td>
                        <td style="font-family: georgia">
                            <table class="style1">
                                <tr>
                                    <td align="left">
                                        <table class="style1">
                                            <tr>
                                                <td class="style6">
                                                    Name:</td>
                                                <td class="style5">
                                                    <asp:TextBox ID="YourName" runat="server" Width="225px"></asp:TextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="style6">
                                                    Email Address:</td>
                                                <td class="style5">
                                                    <asp:TextBox ID="YourEmail" runat="server" Width="225px"></asp:TextBox>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="style6">
                                                    Subject:</td>
                                                <td class="style5">
                                                    <asp:TextBox ID="YourSubject" runat="server" Width="225px"></asp:TextBox>
                                                </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        Message:</td>
                                </tr>
                                <tr>
                                    <td align="left" class="style7">
                                        <asp:TextBox ID="Comments" runat="server" Height="193px" TextMode="MultiLine"
                                            Width="391px"></asp:TextBox>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left" id="text">
                                        please do leave your contact info for future references*<br />
                                        <asp:Label ID="DisplayMessage" runat="server"></asp:Label>
                                        <br />
                                    </td>
                                </tr>
                                <tr>
                                    <td align="center">
                                        <asp:Button ID="Button1" runat="server" BackColor="#FF99CC" Text="Submit"
                                            onclick="Button1_Click" />
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>
                 <table class="style1">
                    <tr>
                        <td align="center">
                            <br />
                            <asp:Image ID="Image1" runat="server"
                                ImageUrl="~/Resources/content header/ContactInfo.png" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <table class="style1" style="border: thin solid #999999">
                                <tr>
                                    <td class="style3" style="font-family: georgia; font-size: large;"
                                        align="center">
                                        <span style="font-weight: bold; vertical-align: 10%; text-indent: 10px; line-height: normal;">
                                        Carpio- Macalintal Dental Office</span><p style="font-size: small"
                                            align="center">   G/F Olympia Somerset Towers, Makati Avenue, Makati City</p>
                                    </td>
                                    <td style="font-family: georgia; border-left-style: solid; border-left-width: 1px; border-left-color: #CCCCCC;"
                                        align="left">
                                    
                                        <span style="font-weight: bold">
                                        &nbsp;&nbsp;&nbsp; </span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<table
                                            class="style1">
                                            <tr>
                                                <td class="style8" align="left">
                                    
                                    <span style="font-weight: bold">
                                     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Telephone no.: </span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                                <td align="left">
                                                    (632) 813-1297</td>
                                            </tr>
                                            <tr>
                                                <td class="style8" align="left">
                                                    <span style="font-weight: bold">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mobile:</span> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                                <td align="left">
                                                    (+63) 0905 4177 222</td>
                                            </tr>
                                            <tr>
                                                <td class="style8">
                                                    &nbsp;</td>
                                                <td align="left">
                                                    <br />
                                        <asp:ImageButton ID="ImageButton6" runat="server" ImageUrl="~/Resources/fb.png"
                                            Width="32px" />
&nbsp; <asp:ImageButton ID="ImageButton7" runat="server" ImageUrl="~/Resources/twitter.png" Width="32px" />
                                                </td>
                                            </tr>
                                        </table>
                                        <br />
                                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                        We are open for appointments from Monday to Saturday<br /><br />
                                    </td>
                                    
                                   
                                       
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

The mark-up and code behind are kinda mixed up... is that normal? also I can't find the ContactUs.aspx.cs file...

SQL Query required

2013-06-20T10:36:47.817-04:00

I have following tables

TABLE : A

ENTERPRISE_MAIN_CODE   ENTERPRISE_SUB_CODE   ENTERPRISE_DESCRIPTION
1                                                 0           A
2                                                 0                                     B
3                                                 0           C
4               0                                     D
5               0                                     E
6               0                                     F
7               0                                     G
8                                                 0                                     H
9                                                 0                                      I

TABLE : B

ID_NO           ENTERPRISE_MAIN_CODE       ENTERPRISE_SUB_CODE
1                                  1                                     1
2                                  1                                     2
3                                  7                                     1
4                                  4                                     1
5                                  4                                     1
6                                  6                                     1
7                  6                                     5

TABLE : C
ID_NO           ENTERPRISE_ID_NO       ENTERPRISE_DATE       ENTERPRISE_AMT
1                             1                                20130109       1000
1                             2                                20130315                     2000
2                             3                                20120120                     3000
2                             4                                20120305                     4000
3                             5                                20141111                     5000
4                             6                                20130115                     6000
5               7                                20130320                     7000

the expected op is as follows. op is based on the year 201303.

ENTERPRISE_DESCRIPTION       count   amt                  count   amt             count   amt             count   amt
       A                                       1        2000                 1          4000               2         3000             2        7000
       B     0    0 0 0    0    0    0    0
       C       0 0                     0           0                  0           0                 0        0
       D       1 7000 0 0                 2           13000           0       0
       E     0 0    0 0 0    0 0    0
       F       0 0    0 0    0 0    0 0
       G    0 0    0 0    0    0 0 0
       H 0    0 0 0 0    0    0 0
       I    0 0    0    0    0 0    0 0

Thanks

Nick

</div> </div>

required field validator is firing but without writing required property in model class

2013-06-20T09:55:13.273-04:00

I am facing very strange problem in MVC4(Razor).

I have a index view here is code below

@model Test2.Models.PlatAnodeRetrofitModels
@{
    ViewBag.Title = "Plat Anode Retrofit";
}
<script type="text/javascript">
    $(document).ready(function () {
        $("#RetroDate").datepicker({
            changeMonth: true,
            changeYear: true
        });

    });
    

</script>
@section featured {

@if (TempData["Success"] != null)
{
    <p class="success-message-info">
        @TempData["Success"].ToString()</p>
}
@Html.ValidationSummary()
@using (Html.BeginForm("Index", "TestPage", FormMethod.Post, new { id = "form" }))
{
@*@using (Ajax.BeginForm("Index","TestPage",new AjaxOptions{HttpMethod="POST"}))
{*@
    
    <h2>
        TestPage</h2>
    @Html.Action("GridViewPartial")
    <div id="div1" class="formLayout">
        <div class="TabSectionL" style="width: 95%">
            <span class="TabSectionHeader">Anode Details</span>
            <table cellpadding="4" cellspacing="4">
                <tr>
                    <td>
                        Retrofit Date
                    </td>
                    <td>
                        No. of Anode
                    </td>
                    <td>
                        Wht. of Anode
                    </td>
                    <td>
                        Total Weight
                    </td>
                </tr>
                <tr>
                    <td>@Html.TextBoxFor(m => m.RetroDate, "{0:MM/dd/yyyy}", new { tabindex = "1" })
                    </td>
                    <td>@Html.TextBoxFor(m => m.NumberOfAnodes, new { @class = "shortinput", maxlength = "4", tabindex = "2" })
                    </td>
                    <td>@Html.TextBoxFor(m => m.WeightOfAnode, new { @class = "shortinput", maxlength = "4", tabindex = "3" })
                    </td>
                    <td>@Html.DisplayFor(m => m.TotalWeight)
                    </td>
                    @Html.HiddenFor(m => m.lng_id)
                </tr>
            </table>
        </div>
        <div class="TabSectionL" style="width: 95%">
            <span class="TabSectionHeader">Comments</span>
            <div id="Div2" class="multilineTextBoxPanel">
                @Html.TextAreaFor(m => m.Comment, new { @class = "multilineTextBox", tabindex = "4" })
            </div>
        </div>
        @*<input onclick="ProgressbarFunction();" type="submit" tabindex="5" value="Save" />*@
    </div>
}
}

and in model class i have following code

        [Required(ErrorMessage = "Date is required")]
        [DataType(DataType.Date)]
        [DisplayFormat(ApplyFormatInEditMode = true)]
        public DateTime RetroDate { get; set; }

        [Required(ErrorMessage = "No. of Anode Required")]
        [RegularExpression(@"^[0-9]+$", ErrorMessage = "Numbers only")]
        public double NumberOfAnodes { get; set; }

        
        public double WeightOfAnode { get; set; }

        public string Comment { get; set; }

        public double? TotalWeight = 0;

        public int lng_id { get; set; }

SO you can see i have set required attribute to first two properties only

but when i run the code and click on save , i am getting validation error of other proprties too...which is very strange..

please see the image below

resource files

2013-06-20T10:34:53.493-04:00

I have a website that uses a resource file to hold messages, button text, etc. In the project this has a build action of 'Embedded resource'

in an .aspx page the resource string is displayed like this

<asp:Label ID="Label1" runat="server" Text="<%$ Resources:DetailsRes, Message %>"></asp:Label>

this works fine under development, but when I Publish the site (using msdeploy) the page falls over when it tries to access the Message resource string. The only way to get it to work is to manually copy DetailsRes.resx to the deployed website (app_GlobalResources)

why should this be ? Ive set it as an embedded resource so I shouldnt neeed to deploy the .resx file.

can anyone see where Im going wrong ?

IP Address

2013-06-20T10:23:47.327-04:00

Hi,

I want to get the ipaddress of the clientmachine in c#.

public string getIp()
        {
            IPHostEntry host;
            string localIP = string.Empty;
            host = Dns.GetHostEntry(Dns.GetHostName());
            foreach (IPAddress ip in host.AddressList)
            {
                if (ip.AddressFamily == AddressFamily.InterNetwork)
                {
                    localIP = ip.ToString();
                }
            }
            return localIP;

}

I used this but it will give the hosted machine IP. I need user machine IP.

Thanks

How to display the multiple images - VS 2010 ?

2013-06-20T10:22:24.83-04:00

Hi,
It's my project in ASP.Net...Any how successfully learned to display the pag contents by text...
But when I try to display multiple Images, I don't know which control will help me...

When I search Google for good design.. I found the below link has better, attarctive for me
http://areej-group.net
It displays 5 or 6 images alternatively changing the images on start-up page...

So which control can achieve it ?

Thanks for the ideas

Disabled Asp control in Javascript but not in .NET

2013-06-20T10:33:01.277-04:00

Hi,

I disable a TextBox with Javascript:

if(fechaDate<fechaDateHoy) {
txtFecha.disabled= true;
}else{
txtFecha.disabled= false;
}

I can see the disabled control in my screen but when I check in my code behind it is enabled:

if (txtFecha.Enabled == false)

{
// I never reach this

}

Any idea to disable a TextBox with Javascript and be disabled in code behind too?

Using javascript to generate a list of links that use window.open and pass parameters to the child window

2013-06-20T09:48:39.05-04:00

I have a aspx file that is supposely to generate window.open links

for (var i=0; i< para.length; i++){

<a href="#" onclick="window.open("ViewHistory.aspx?IID=" + para[i] + "", "windowname1", "toolbar=yes,location=no,menubar=no,width=450,height=200,resizable=yes,scrollbars=yes,top=200,left=250"); return false;"><img src="images\\history.png"></a>

}

However, it seems it is not working and it mention some syntax errors.

When the child windows popup (a popup window that will open the ViewHistory.aspx) , I can't seems to read the value IID?

So, how do I generate window.open link that will pass the IID parameters to the ViewHistory.aspx page and the ViewHistory.aspx will display the IID value for me to see?

How to Handle DBNull Values in loop?

2013-06-20T09:27:49.557-04:00

I am fetaching data from a table some times it has null values some times it has values.

I want to know what is the better way to handle dbnull values in loop.

Here is my code that i have did but I want to know is there any better approach to handle this?

if (_DT.Rows.Count > 0)
                {
                    QualityRanking qr;

                    foreach (DataRow DR in _DT.Rows)
                    {
                        if (DR["ReportMonth"] == DBNull.Value)
                            continue;
                        qr = new QualityRanking();

                        if (string.IsNullOrEmpty(DR["ReportMonth"].ToString()) == false)
                            qr.month = Convert.ToInt32(DR["ReportMonth"].ToString());

}}}