am not able to getting info from google, am new to jquery can you please help

using webAPI and calling JSON

complete code is not pasting sir...
i have given that image in anchor tag , in anchor href="'<%#Eval("TrailerLink") %>'"

not working sir....

please once look at this code


<asp:Image ID="Image2" runat="server" ImageUrl='<%# Bind("Image") %>' Height="150px"
Width="150px" />


when i click that image my project url also adding ,, how to avoid that

it is redirecting like

http://localhost:5052/AutoCompleteExtenderWithoutWebService/'https://www.youtube.com/watch?v=_UGMZ9iVGvo%27


how to avoid my project url

not working... same issue

i have a link in database , that link i want to bind to that image . how can i

i want display text over the image(not mouse over)... and how to give weblink to the image

when i submit otp , on submit click i have to download file in grid.
how can i give link to submit click and link button in grid view..
am getting error at int id=int.Parse((GridView1.SelectedDataKey.ToString()));

Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.

or if i use int id = int.Parse((sender as LinkButton).CommandArgument);
error is Object reference not set to an instance of an object.

sorry it is pop up window, if user is idle for 5 minutes after clicking login button , i wants to expire his session then redireting him to expire page(aspx page)

one small help sir ...
By using above query am trying to retrieve values of this month only , but the query is returning same month next year value also returning

please find the output image of my query

http://i.stack.imgur.com/LMg1m.png

i want to retrieve only current month value sir

i got it sir , thank you

am getting error sir
Msg 264, Level 16, State 1, Line 1
The column name 'DueDate' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'DueDate' may appear twice in the view definition.



INSERT INTO MYPaymentTracker1(ID,Name,InvestmentType,Amount,MonthlyPay,NumberOfMonths,StartDate,EndDate,Phone,Address,DueDate,DueDate) SELECT PaymentTracker1.*, convert(varchar(20),DATEADD(m,N,StartDate),110) AS DueDate
,(Numbers.N * MonthlyPay) AS DueAmount
FROM PaymentTracker1
INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N
where datepart(mm,DATEADD(mm,N,StartDate))= datepart(mm,getdate()) and datepart(yy,DATEADD(y,N,StartDate))= datepart(yy,getdate())
ORDER BY
PaymentTracker1.Name
,Numbers.N

am getting error ..Incorrect syntax near the keyword 'INTO'.

MYPaymentTracker1

thanks for your help sir..
i want to save the result in permanent table,
and i have created a table with same columns , and how to define that in procedure .
i have tried but iam getting error There is already an object named 'MYPaymentTracker1' in the database.


SELECT PaymentTracker1.*, convert(varchar(20),DATEADD(m,N,StartDate),110) AS DueDate
,(Numbers.N * MonthlyPay) AS DueAmount
INTO [MYPaymentTracker1]
FROM PaymentTracker1
INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N
where datepart(mm,DATEADD(mm,N,StartDate))= datepart(mm,getdate()) and datepart(yy,DATEADD(y,N,StartDate))= datepart(yy,getdate())
ORDER BY
PaymentTracker1.Name
,Numbers.N

thanks for your help sir ,
can we do edit update in grid (asp.net c#)with temp table and is tamp table delete automaticalyy

overview of page is
i have following table in database please find the picture, click below link

http://i.stack.imgur.com/MLRV6.png

i want payment update for this table
37 Chintala Naveen Sagar Chit 100000 9900 12 08/01/2015 08/01/2016 9985437775 Karwan,Mehidipatnam

i want to bind this values to grid and show every month payment and due amount , if i update payment show value 0 , when a month crossed again show monthly pay as due amount, if he not paid money for 3 months show as 3*monthlpay.

again am getting 2 dates sir 2015 and 2016


SELECT
PaymentTracker1.*
, convert(varchar(20),DATEADD(m,N,StartDate),110) AS DueDate
,(Numbers.N * MonthlyPay) AS DueAmount
FROM
PaymentTracker1
INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N

where datepart(m,DATEADD(m,N,StartDate))= datepart(m,getdate()) AND datepart(yy,DATEADD(y,N,StartDate))= datepart(yy,getdate())
ORDER BY
PaymentTracker1.Name
,Numbers.N

no errors sir.. but 0 records showing

SELECT
PaymentTracker1.*
, convert(varchar(20),DATEADD(m,N,StartDate),110) AS DueDate
,(Numbers.N * MonthlyPay) AS DueAmount
FROM
PaymentTracker1
INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N

where datepart(m,DATEADD(m,N,StartDate))= datepart(m,getdate()) AND datepart(y,DATEADD(y,N,StartDate))= datepart(y,getdate())
ORDER BY
PaymentTracker1.Name
,Numbers.N

http://i.stack.imgur.com/LMg1m.png


find the out put image sir

2 dates are showing sir that is oct 2015 and oct 2016

Thanks for your help sir..
am getting error
Invalid column name 'DueDate'.

SELECT
PaymentTracker1.*
, convert(varchar(20),DATEADD(m,N,StartDate),110) AS DueDate
,(Numbers.N * MonthlyPay) AS DueAmount
FROM
PaymentTracker1
INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N where datepart(m,DueDate)= datepart(m,getdate())
ORDER BY
PaymentTracker1.Name
,Numbers.N

Got it sir
Thank you very much...

am getting compilation error if i give that..
"'System.Web.UI.Control' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'System.Web.UI.Control' could be found (are you missing a using directive or an assembly reference?)"

textName.Text = row.Cells[1].Controls[0].Text;

am getting error while converting at .text,if i give .Tostring() no error but when iam updating particular row it is showing as system.web.ui.literal...

am updating grid view columns

thanks for your help sir..
i have to create different columns for 1 lac 2 lac 3 lac ... and you answered my latest question sir,in that am creating automatically calculations based on start date and end date ,
if user selected 1 Lac i have fixed 12(month) columns in database
if user selected 2 Lac i have 18(month) columns in database
so, if user click submit button , i want to save the details separately for 1 lac group 2 lac group 3 lac group....in child table or separate table.

thanks for your help sir,
in output of this code am getting table columns as
... columnname3 columnname2 columnname1
i want like 1/7/2015 1/8/2015 1/9/2015...
i have tried but iam not getting sir please help me

am bringing only one value from database sir
and i got it sir
thank you

Thanks for your help.
how to bind the data to textbox instead of dropdownlist


ddlmonthlypay.Items.Clear();
ddlmonthlypay.AppendDataBoundItems = true;
String strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
String strQuery = "select ID, MonthlyPay from Tmonthlypay where NoOfMonthsID=@NoOfMonthsID";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@NoOfMonthsID", ddlNoOfMonths.SelectedItem.Value);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = con;
try
{
con.Open();
ddlmonthlypay.DataSource = cmd.ExecuteReader();
ddlmonthlypay.DataTextField = "MonthlyPay";
ddlmonthlypay.DataValueField = "ID";
ddlmonthlypay.DataBind();
if (ddlmonthlypay.Items.Count > 1)
{
ddlmonthlypay.Enabled = true;
}
else
{
ddlmonthlypay.Enabled = false;
}


how to bind the result to text box

yes sir ,
sorry for that

and how to bind the value to label . i have tried but it is not working

var str = document.getElementById('txtname').value;

str = str.replace(/[^c-z\.]+/g, '');
document.getElementById('Label1').value = str;

function Click() {
alert("1");
var str = document.getElementById('txtname').value;

str = str.replace(/[^0-9\.]+/g, '');
alert(str);

by using this js am removing letters and it printing only numbers
actually i want to remove particlar letters a or b or c

when click button i want to remove a letter (anything i.e a or b or c) and show remaining in alert box

for example(deleting 'a' from text box entry and showing remaining in alert using javascript )
i have entered madhu in text box
i want to show in alert as mdhu

got it sir ...
thanq

am not getting you sir..


please help

create PROCEDURE [dbo].[GetCustomers_Pager]
@SearchTerm VARCHAR(100) = ''
,@PageIndex INT = 1
,@PageSize INT = 10
,@RecordCount INT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER() OVER
(
ORDER BY [ID] ASC
)AS RowNumber
,[ID]
,[Name]
,[InvestmentType]
,[Amount]
,[MonthlyPay]
,[NumberOfMonths]
,[StartDate]
,[EndDate]
,[Phone]
,[Address]
INTO #Results
FROM [PaymentTracker1]
WHERE [Name] LIKE '%' + @SearchTerm + '%' OR @SearchTerm = ''
SELECT @RecordCount = COUNT(*)
FROM #Results

SELECT * FROM #Results
WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #Results
END

how to bind number of months(5) from table using start date and end date
(bind like june-2015, july-2015......)
automatically bind columns


Noofmonths Startdate EndDate june july august

hi sir..
i have added months to the date.
when i submit the data to database. i want to create columns automatically
if i added 5 months to 24/5/2015 it will display like
May june july august september in database ..

Thank you sir for your motivation .. thanks a lot

startDate.AddMonths(txtNoOfMonths.Text);


am getting error there as
Error 3 Argument 1: cannot convert from 'string' to 'int'
Error 2 The best overloaded method match for 'System.DateTime.AddMonths(int)' has some invalid arguments

still it is not working and here is complete code


<script type="text/javascript">
function ESCclose(event) {
if (evt.keyCode == 27)
window.close();
}
</script>

</head>
<body >
<form id="form1" runat="server">
<div >

<div id="light" class="white_content" >
<table cellpadding="0" cellspacing="0" border="0" style="background-color: #FFFFFF;
font-family: Verdana, Geneva, Tahoma, sans-serif;" width="100%" >
<tr>
<td height="16px">

<img src="Images/delete.png" style="border-style: none; border-color: inherit; border-width: 0px;
height: 20px; width: 20px;" align="right" alt="Close" />
</td>
</tr>
<tr>
<td style="padding-left: 16px; padding-right: 16px; padding-bottom: 16px">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color: #fff"
width="100%">
<tr>
<td align="center" colspan="2" class="headertext">

LOGIN

</td>
</tr>
<tr>
<td align="center">
<table>
<tr>
<td align="right" class="bot_text">
Username:
</td>
<td>
<asp:TextBox ID="txtName" runat="server">
</td>
</tr>
<tr>
<td align="center">
<asp:Button ID="_btnLogin" runat="server" Text="Login" CssClass="Button1" ValidationGroup="a"
Height="40px" Width="100px" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div id="fade" class="black_overlay">
</div>
</div>

click here
</form>
</body>
</html>

still it is not working sir

onkeypress="ESCclose(evt)"

i have written this in div

<script type="text/javascript">
function ESCclose(evt) {
if (evt.keyCode == 27)
window.close();
}
</script>

i have tried this but it still not working

got it sir thank you......

it showing color while am clicking, after page redirecting it is not showing any color

i have used that, when am clicking link it is showing color but after page redirecting the link is not highlighting ..

my code masterpage.master


<title></title>
<style type="text/css">
.menu_div ul
{
padding: 6px;
margin: 0px;
font-size: 12px;
list-style: none;
text-indent: 15px;
}
.menu_div ul li
{
line-height: 28px;
border-bottom: 1px solid #000;
}
.menu_div ul li a
{
text-decoration: none;
font-color: #3A332D;
display: block;
}
.menu_div ul li a:hover
{
background: blue;
}
.menu_div ul li#active
{
background: blue;
}
</style>
<asp:ContentPlaceHolder ID="head" runat="server">

</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<div class="menu_div">
<ul>
<li>Home</li>
<li>Contact</li>
<li>Help</li>
</ul>
</div>
</td>
</tr>
</table>
</div>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">

</form>
</body>

data is binding to gridview there is no problem

protected void Page_Load(object sender, EventArgs e)
{

}
protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
if (CheckBox1.Checked)
{
GridView1.Visible = true;
}
}

Yes gridview has data..but when i click checkbox it is not displaying

<div>
<asp:CheckBox ID="CheckBox1" runat="server" OnCheckedChanged="CheckBox1_CheckedChanged" /><asp:GridView
ID="GridView1" runat="server" AutoGenerateColumns="False" Visible="false"
DataSourceID="SqlDataSource1" >
<columns>
<asp:BoundField DataField="Iname" HeaderText="Iname" SortExpression="Iname" />
<asp:BoundField DataField="courses" HeaderText="courses"
SortExpression="courses" />
<asp:BoundField DataField="fees" HeaderText="fees" SortExpression="fees" />


<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:peersConnectionString %>"
SelectCommand="SELECT * FROM [pubs]">
</div>

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
if (CheckBox1.Checked)
{
GridView1.Visible = true;
}
}


...i cant find answer in google