Comments by sr_24 (Top 54 by date)

i have experimented pager on div but it cant be done bec Div does not have IPAgablecontainer ,so it can only be done by some control of asp.net

thanks

thanks Pakistan bhai ..i hv used it like this

for (int k = 0; k <= t; k++)
{
if (arr[k].Length > 15)
{
arr[k]= arr[k].Substring(0, 12) + " ..";
}

Display_Keywords.InnerHtml += "<li>"
+ "" + arr[k] + " "
+ "</li> ";
}

my Visual studio 2008 doesnot support css3 text-overflow:ellipsis ...can there be any alternative solution ?? in css2

thaanks

thanks for the reply .... but why we use it before a string like-- ??

string _Insert = @"insert into Details(fName,lName,DOB,City) Values('" + fName_Txt.Text + "','" + lName_Txt.Text + "','" +_Date.ToString() + "','" + City_Txt.Text + "')";

thankyou very much awesome explaination ...So can iu conclude by it that -- Is it optional to use when initializing/declaring a string variable , if the string does not contain \p ,\f ..i can skip @

otherwise i hv to use it .. ?????
Is their any other reason also ..as my query does not have any \f , \p

I only want to write a Select Query to display date in dd/mm/yyyy format ,though datetype in db is -- DateTime()

what should i do in select query ?

u mean i have to alter my table ??????

Can't i only do that-- after user logout ,when browser backbutton pressed ,i got redirected
to my home page ?????? OriginalGriff ...it wont need to disable browser back button !!

and i hv quecuted the query with both upprer/lower K ..it does not matter Raje_

i resolved thew error ,though i was using + concatenator in the Query i was passing ,but some thing was though wrong , now i hv removed all + and it worked ...thanks for ur help bro Raje_

these are the columns -- Raje_


Table -UserFeedSelection--

User_Id
JobFeed
Selectedkeyword


Table -JobForm--

[Job_Id] [int] NOT NULL,
[Recruiter_id] [int] NULL,
[JobTitle] [varchar](100) NULL,
[Location] [varchar](50) NULL,
[Category] [varchar](50) NULL,
[MinExp] [varchar](20) NULL,
[MaxExp] [varchar](20) NULL,
[Body] [varchar](2000) NULL,
[Keyword1] [varchar](50) NULL,
[Keyword2] [varchar](50) NULL,
[Keyword3] [varchar](50) NULL,
[Keyword4] [varchar](50) NULL,
[Keyword5] [varchar](50) NULL,
[Keyword6] [varchar](50) NULL,
[Keyword7] [varchar](50) NULL,
[Investor1] [varchar](50) NULL,
[Investor2] [varchar](50) NULL,
[Investor3] [varchar](50) NULL,
[Investor4] [varchar](50) NULL,
[Investor5] [varchar](50) NULL,
[CreatedDate] [datetime] NULL

its difficult to show the format here but i have maintained proper spaces
I am already using Concatenator "+" i have increased space between Table name and alias name ...but same error is repeating ... Incorrect syntax near 'A'.

I am already using Concatenator "+"
i have increased space between Table name and alias name ...but same error is repeating ...
Incorrect syntax near 'A'.

i was firing a sql query against a table where column can accept a null value ,but as i user did not provided any value for that --- it was not null but space "" ..but i expect it to be null ,whats d problem ??

i mean to say if i hv not set any default value then what would it be the default value by it self

thanks

thanks sir

this is my Get Function for ajax calling in Jquery--

function SetID(ID)
{
//debugger;
var strID = "#" + ID;
var IsSelected = true;
var temp2 = $(strID)[0].value;
$.get('Dynamic_page.aspx', { Id: ID, Mode: $(strID)[0].value, XYZ: IsSelected }, function() {
//alert("");

});

yes u r right , i hv resolved this mismatch ,the below solution worked

SELECT DISTINCT A.USER_ID, A.CHoice FROM
UserFeedSelection A
INNER JOIN JobForm B ON
A.choice = B.Keyword1 OR A.Choice = B.Keyword2 OR
A.choice = B.Keyword3 OR A.Choice = B.Keyword4 OR
A.choice = B.Keyword5 OR A.Choice = B.Keyword6 OR
A.choice = B.Keyword7
WHERE A.User_ID = 2

but even it has some problem like--
if 4 keywords match with 4 choices
it REPEAT a SAME RECORD 4 Times ...so what should i do Karthik Harve ???

it worked but it has a PROBLEM like that---

if 4 keywords match with 4 choices
it REPEAT a SAME RECORD 4 Times ...so what should i do Karthik Harve ???

I have Update my Question with Table scripts in it !!have a Look gvprabhu

What is Mode in Mode:$(strID)[0].value ???

Sir I have to do this through my above written JQuery Function ,how can i manupulate this function

function SetID(ID)
{
//debugger;
var strID = "#" + ID;

$.get('Dynamic_page.aspx', { Id: ID, Mode:$(strID)[0].value }, function() { });
//callAjax();

//ID = "#" + ID;
if ($(strID)[0].value == "Follow")
{
$(strID)[0].value = "UnFollow";

}
else
{
$(strID)[0].value = "Follow";

}
}

Sir I have to do this through my above written JQuery Function ,how can i manupulate this function

function SetID(ID)
{
//debugger;
var strID = "#" + ID;

$.get('Dynamic_page.aspx', { Id: ID, Mode:$(strID)[0].value }, function() { });
//callAjax();

//ID = "#" + ID;
if ($(strID)[0].value == "Follow")
{
$(strID)[0].value = "UnFollow";

}
else
{
$(strID)[0].value = "Follow";

}
}

Actually i am crating these buttons at Runtime from Code behind so i can write like this --when a User clicks on my button this Jquery function with Ajax is called

function SetID(ID)
{
//debugger;
var strID = "#" + ID;

$.get('Dynamic_page.aspx', { Id: ID, Mode:$(strID)[0].value }, function() { });
//callAjax();

//ID = "#" + ID;
if ($(strID)[0].value == "Follow")
{
$(strID)[0].value = "UnFollow";

}
else
{
$(strID)[0].value = "Follow";

}
}

so where how can i Identify that my button is clicked on second time or not??

Mode:$(strID)[0].value

what Does [o] Means ?? Anyone Please Describe ...thanks in advance

how can i do it Bro ??? Dharmendra-18

Thanks Sir !!! OriginalGriff

Ok ...but in some scenario i have to send parameters values to other pages ,then how could i do pass ,if they are VITAL and UNSECURE ...pls suggest sir ..

If i send USerID instead of UserEmail value will it be secure ????

Thanks

Actually i am sending UserEmailId's through Response.Redirect(), Parameters ...will it be safe Now ??????

Is there any way to Encrypt my Response.Redirect() parameter values ???

Actually i am sending UserEmailId's through Response.Redirect(), Parameters ...will it be safe Now ??????

Is there any way to Encrypt my Response.Redirect() parameter values ???

thanks sir for ur reply !!! Asim Mahmood

No I want to ask ...can i stop page postback without using UPDATE PANEL ??? is there any other way

thanks for ur help ...i am new to asp.net have very little knowledge of jquery ,ajax ,i dont know anything about JSOn,webservices ...Asim Mahmood
...can any more easy way

Capitals words were to emphasize the important words ..whats d problem _Amy ???

Now a interviewer asked me this question to my friend ,about the name of software specially for this purpose ,he told the name of the sofw but my friend forgot ???

Thanks Pallavi Wailar

thanks MDubey87

cmd.CommandText = "select CreatedDate 'Posted Date' ,JobTitle,Location,Job_Id,Category from JobForm ";

field name is same as in Table

It is still showing the same error---- richcb
DataBinding: 'System.Data.Common.DataRecordInternal' does not contain a property with the name 'CreatedDate'.

thanks

thanks MIlind_T it has updated all rows without where clause

I have changed my sp to this one,
what should i write in WHERE clause so that a record with a particular EMAiL and JS_ID will be updated



CREATE PROCEDURE JSP_ResumeUpdate

@JS_Id [int],
@UserEmailId [varchar](150),
@Name [varchar](50),
@Phone [varchar](200) ,
@Institute [varchar](100) ,
@Batch varchar(50),
@Designation varchar(100),
@Organization varchar(100) ,
@Experience_Months varchar(10),
@Experience_Years varchar(10) ,
@TotalExp int ,
@Industry varchar(300),
@CurrentLocation varchar(100) ,
@PreferredLocation varchar(100) ,
@IsInserted int ,
@IsUpdated int ,
@Result Tinyint OutPut

AS
BEGIN

-- IF EXISTS(SELECT * FROM JS_ResumeInsert WHERE UserEmailId =@UserEmailId )
--BEGIN
-- SET @Result = 0-- Already Exists
--END

--ELSE
-- BEGIN


UPDATE JS_ResumeInsert SET
JS_Id=@JS_Id ,
UserEmailId=@UserEmailId ,
Name=@Name ,
Phone=@Phone ,
Institute=@Institute ,
Batch=@Batch ,
Designation=@Designation ,
Organization=@Organization ,
Experience_Months=@Experience_Months,
Experience_Years=@Experience_Years ,
TotalExp=@TotalExp ,
Industry=@Industry ,
CurrentLocation=@CurrentLocation ,
PreferredLocation=@PreferredLocation ,
IsInserted=@IsInserted ,
IsUpdated=@IsUpdated ,
CreationDate=GETDATE() where UserEmailId=@UserEmailId


set @Result =1
return

--END
END

it is generating no error but no updation as well

i already have data in table JS_ResumeInsert ,but the stored procedure is not updating it