Comments by Arasappan (Top 200 by date)

hmmm..

It will postback to yy when i submit login to xx

hmm.. I try Sitecore..

ppolymorphe its not a answer mean u may proceed in comment .... U know that its not a answer for this question.. so only we have comments..

if i ligin with xx mean it also validate the username and password not by means of connectionstring.. just send the value

I need like database valution chill.. like query string in same project website .. I need too send to another website

use break point

y they are unvoting..after the answer was accepted..:-)

ok

mmmm

would u uplad the ajax bin file

how many textbox u have

:-)

please clearly explain

:-)

U forgot to said Autopostback="true" Griff

please refer solution 1 with ppolymorphe

<Triggers>
<asp:PostBackTrigger ControlID="btn_ID" />
</Triggers>

Remove trigger

is that wrong I done George Jonsson..

Oh....Fine Madhu..

did u google yar...

Did u putting break point.. and find what happens

Is this work or not madhuu

Response.Redirect("../Login.aspx,false");

../ is depending upon ur need only use break point

Is this go to exception

Redirect the page properly madhu..

5ed

Y griff...he doesnt try a single line.. or Idea

Hmm.....

5n Keeep trying.....

did u get the values in recordsV2

what path u used to show the image as a url..Bind simailar to the label...

For Image It will be Image Url
For Label It will be Text.. Bind Similar to the label which is to display the image

make the break point and run..what did u getting in del_path

Your 100% right..

Am Already Used

like

what source u used

drag the js file and incclude in your project

U say


if (Session["userStatus"]!=null)
{

Where and when you get the value of Session["userStatus"],Then how it should be enter on the loop

This one also the same problem appear

Google Session

5

are you missing in the header of the project

go and check the bin folder

both the solutions help u

U want to send whole grid or image only..

if u find the solution just in a comment..not in solution

where is ur code..what is this belongs to..

You give Pankaj...

the format u saved in sql is

who is downvoted...

:)

ha ha....

what you getting

Answer Updated

What can I do for this wait sometime.. If we get the result only we can move furtherly

please try this

alter PROCEDURE stp3_getDataFrom11Tables
@FirstTableMonth int=0,
@LinkedServerName sysname = 'Server1'
AS
DECLARE
@DynamicSQL nvarchar(max) = '',
@DynamicSQL2 nvarchar(max) = '',
@OpenQuerySql nvarchar(max),
@Table_Name sysname,
@Table_Name2 sysname,
@TableMonth int,
@TableMonth2 int ,
@CurrentMonth int = 0,
@NextYearMonth int = 1,
@part2 nvarchar(max) = ''



BEGIN
WHILE @CurrentMonth < 11
SELECT @TableMonth = CASE WHEN (@FirstTableMonth + @CurrentMonth) % 100 < 13 THEN
@FirstTableMonth + @CurrentMonth
ELSE
@FirstTableMonth + 100 - (@FirstTableMonth % 100) + @NextYearMonth
END,
@NextYearMonth = CASE WHEN (@FirstTableMonth + @CurrentMonth) % 100 < 13 THEN
@NextYearMonth
ELSE
@NextYearMonth + 1
END,
@Table_Name = 'xx'+CAST(@TableMonth as varchar)+'_T' ,

@TableMonth2 = @TableMonth+ 1,
@Table_Name2 = 'xx'+CAST(@TableMonth2 as varchar)+'_T' ,
--@TableMonth2 = CAST(@TableMonth2 as varchar),
--print @TableMonth2


@DynamicSQL = @DynamicSQL + 'SELECT *
FROM '+ @Table_Name + ' WHERE co_cde = 15
and cust_no in (123
) '+ CASE WHEN @CurrentMonth < 10 THEN ' UNION ALL ' ELSE '' END ,


@DynamicSQL2 = @DynamicSQL2 + 'SELECT *
FROM '+ @Table_Name2 + ' where
cust_no in (123
) ' + CASE WHEN @CurrentMonth < 10 THEN ' UNION ALL ' ELSE '' END ,


@part2 = @part2 + 'SELECT *
FROM OPENQUERY(Server1," SELECT *
FROM xx
where cust_no in (123
) "

)'



SET @CurrentMonth = @CurrentMonth + 1
IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL BEGIN DROP TABLE #TEMP END
--last months snapshot
SELECT *,
cast(ODATE as datetime) as open_date
into #temp
FROM OPENQUERY(Server1,' SELECT *
cast(ODATE as datetime) as open_date
FROM xx WHERE cust_no in (123
) '
)
--if equal to month + 99 = previous month then union 11 tables with last months snapshot
--else
--union 11 tables with 12th table
SET @OpenQuerySql = 'IF (@FirstTableMonth+99) = CONVERT(nvarchar(6), dateadd(month,-1,GETDATE()), 112)
BEGIN
SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL + ''' )
UNION ALL
SELECT *
FROM #temp
end
else IF (201404+99) <> CONVERT(nvarchar(6), dateadd(month,-1,GETDATE()), 112)
begin

SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL + ''' )
UNION ALL
SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL2 + ''' )
end
'
END
EXEC sp_executesql @OpenQuerySql
GO

alter PROCEDURE stp3_getDataFrom11Tables
@FirstTableMonth int=0,
@LinkedServerName sysname = 'Server1'
AS
BEGIN

DECLARE
@DynamicSQL nvarchar(max) = '',
@DynamicSQL2 nvarchar(max) = '',
@OpenQuerySql nvarchar(max),
@Table_Name sysname,
@Table_Name2 sysname,
@TableMonth int,
@TableMonth2 int ,
@CurrentMonth int = 0,
@NextYearMonth int = 1,
@part2 nvarchar(max) = ''

WHILE @CurrentMonth < 11

SELECT @TableMonth = CASE WHEN (@FirstTableMonth + @CurrentMonth) % 100 < 13 THEN
@FirstTableMonth + @CurrentMonth
ELSE
@FirstTableMonth + 100 - (@FirstTableMonth % 100) + @NextYearMonth
END,
@NextYearMonth = CASE WHEN (@FirstTableMonth + @CurrentMonth) % 100 < 13 THEN
@NextYearMonth
ELSE
@NextYearMonth + 1
END,
@Table_Name = 'xx'+CAST(@TableMonth as varchar)+'_T' ,

@TableMonth2 = @TableMonth+ 1,
@Table_Name2 = 'xx'+CAST(@TableMonth2 as varchar)+'_T' ,
--@TableMonth2 = CAST(@TableMonth2 as varchar),
--print @TableMonth2

@DynamicSQL = @DynamicSQL + 'SELECT *
FROM '+ @Table_Name + ' WHERE co_cde = 15
and cust_no in (123
) '+ CASE WHEN @CurrentMonth < 10 THEN ' UNION ALL ' ELSE '' END ,

@DynamicSQL2 = @DynamicSQL2 + 'SELECT *
FROM '+ @Table_Name2 + ' where
cust_no in (123
) ' + CASE WHEN @CurrentMonth < 10 THEN ' UNION ALL ' ELSE '' END ,

@part2 = @part2 + 'SELECT *
FROM OPENQUERY(Server1," SELECT *
FROM xx
where cust_no in (123
) "

)'

SET @CurrentMonth = @CurrentMonth + 1
IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL BEGIN DROP TABLE #TEMP END
--last months snapshot
SELECT *,
cast(ODATE as datetime) as open_date
into #temp
FROM OPENQUERY(Server1,' SELECT *
cast(ODATE as datetime) as open_date
FROM xx WHERE cust_no in (123
) '
)
--if equal to month + 99 = previous month then union 11 tables with last months snapshot
--else
--union 11 tables with 12th table
SET @OpenQuerySql = 'IF (@FirstTableMonth+99) = CONVERT(nvarchar(6), dateadd(month,-1,GETDATE()), 112)
BEGIN
SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL + ''' )
UNION ALL
SELECT *
FROM #temp
end
else IF (201404+99) <> CONVERT(nvarchar(6), dateadd(month,-1,GETDATE()), 112)
begin

SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL + ''' )
UNION ALL
SELECT *
FROM OPENQUERY(['+ @LinkedServerName +'], '''+ @DynamicSQL2 + ''' )
end
'
END
EXEC sp_executesql @OpenQuerySql
GO

id the query execute or not..

Its run or not

IF ITS RUN

ha ha anyway fine

Its not a Solution KrunalRohit

It will definitely wrk

Use f10 for step by step

Wheres the error appear;

Dd u use break point

whats happen when using this solution

MAke Break point then run

First Open The Con then Query Then Close

Use My Solution

can u please show ur c#

Is your Input more than the 10 ..

like KINGMAKER=9
KINGMAKER1=10
KINGMAKER11=11..not in correct format

Show your db design

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

once again create a form and copy all those things

delete althose thing between MasterPageFile=""; Now place the cursor between "" ..And ctrl+spacebar..now pickurl and select ur master page

or<%@ Page Language="C#" MasterPageFile="~/MDIForms/Admin.master" AutoEventWireup="true" CodeFile="ErrorPage.aspx.cs" Inherits="ErrorPage" Title="" %>

It run perfectly in local database.not in online db

where to add the order by in the dynamic sql

order by cast(a.voucher_no as bigint) ASC

Is this Right

ur genius griff..But The entries are already there how can I change it is there any chance like in c# int.parse

1009 then 101

voucher_no expensive_id
1008 101 1 22/06/2015
1008 101 1 22/06/2015
1009 58 1 22/06/2015
101 58 1 09/04/2015
1010 88 1 22/06/2015

HMM GOOD GRIFF

can you please give me the syntax..

protected void ImgLogin_Click(object sender, ImageClickEventArgs e)
{
try
{




SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constrings"].ConnectionString;
SqlCommand cmd = new SqlCommand("select *From tbl_login_user where username=@username and password=@password", conn);
conn.Open();
cmd.Parameters.AddWithValue("@username", txtusername.Text);
cmd.Parameters.AddWithValue("@password", txtpwduser.Text);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
dr.Close();
Response.Redirect("~/Adminlogin/home.aspx", false);
}
else
{
dr.Close();
msg.ShowAlertMessage("Invalid Login Credentials");
}


}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}

k THEN HOW TO CLOSE ALL CONNECTIONS..iF ITS FALSE MEANS Y FOR FIRST SOME ATTEMPTS IT ENTER ON IT

aLL CONNECTIONS ARE CLOSE

first 10 logins it will access

onnum purila ne vera....pretty clearnu.. (I dont know what the error is)

Working exactly..for joins result it may apply

Wait I am slow learner, analyse and call u

want to bind in dynamic values

dont know y they are downvoting

Phil by mistake i forget to replace the *

Solution updated..

Label1.Text = sdesc.Text;

Thank You,AsPDevloper.

Popup Shown On the Top Of the toolbar you may block the popup please see in top..

Please See My Improved Solution

What Is shown on url content

ok.. -KR

hmm me to...

Use required field Validator in Ajax....

Realy Surgey

I done that also..But its nort surgey..

First one is for sliding image.. another one is for Image zoom...
When add the zoom..slide is not working..

I fixed But not getting the output of first one...

I wont say my script is not working..When add another script..It affect the previous script....

"Throw us a freakin' bone, here" ^_^ mean

5

u reached 50%.. help me to pass the id also

no response..

I also pass the id.. How can i done

javascript webform_dopostbackwithoptions("");

tomorrow I will laugh..for this joke..Kornfeld Eliyahu Peter..

good;

ha ha...

fine

i want to redirect to products.aspx

I think u do it for notification.. this is posssible

nice.. 5ed

thank u mika

5

5 ed

5

5

Try.. on your grid view tag add autogeneratedcolumns="true"

its only path.. we can take image path as nvarchar also..

Y griff

5 ed

Small help by me..

Nice arguments.. waiting to learn more...

Ur grid structure

thank u surgey

where is the command to insert..

or in sql..If u can put the other at first

or in sql..If u can put the other at first

If ur answer yes mean..show ur code to bind the data in C#..

can i Give the solution..for dropdownlist not in sql...

nice

go with hyperlink

I thing u do this for dropdownlist ..Right..?

how did u add the master page

Actually what happens now

are u need that it works are not.. there is no need to put autoplay="true"

5

y is auto play .. video tag

What do u want

ha ha...am just giving idea Chill60

on textbox text changed
{
write the query


select top '"+value.TextBox+"' * from tbl_customerdetails
}

set auto postback on text box

do u whant to show the top

where is ur table

Where is ur state dropdownlist

Route ur jscript correctly

explain correctly

lol lol please explain correctly

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["valmont"].ConnectionString);

Keep on trying Rohitk

do u written the code for third box..dr

:-(

code behind please.

it may help u or not

use the breakpoint,and note it get all data

put update panel .. on your dropdownlist and textbox

take the idea from the answer and modify as per ur need.. thank u

What is mean by 5ed

see my improved answer.output 100% sure :-)

please clearly explain

whaen i saw in quick answer Now only see the day

I think to u want this for editing purpose..Am I right

Show your dropdownlist function

Response.Write("<script > alert('"yhe book id is + v + your selected"')</script>");

First try and say...U only joking man.. ur not need in array.. then..

What is this logic griff... he doesn't gave no status..ur not yet clear with newparkinglot().. there is no status..i cant get u griff...

If u have any sql table related this mean.. i can simplify with very easy manner whats the logic i know... like in table maintain a column 1 as parking.2.. 3.. is there any query or status.. tell me

string v=lblbookid.Text;
msg.ShowAlert("the book id + v+ your selected");

screen position show at which place

Is this example or u can only these alphabets to sort.....

Hmm....okok..ur need is u have to connect to all ur local network.. am I right.

Surgey.. is there any "for" loop condition to get all the gridvalues because i guess it will take only one row and also he said first ... can u catch me surgey

Code behind?

What do u want