Comments by Harshit Wadhera (Top 65 by date)

it's giving me error

This my query

<pre lang="sql">select u.name,Count(distinct ex.company_name)
from user u
inner join role r on (r.id = u.role_id)
inner join experience ex on (ex.profile_id = u.profile_id)
where r.name ='Alumni'
group by u.name
--having Count(distinct ex.company_name) in (select max(ex.company_name) from experience ex where ex.profile_id = u.profile_id)
order by u.name,max(ex.company_name)</pre>

i am getting this error
Check the manual that corresponds to your MySQL server version for the right syntax

i know to count the distinct name but how find max that i don"t know.

yupp but that i will know that r.name='Alumni'

I am getting error
check the manual that corresponds to your MySQL server version for the right syntax to use near '[date] as time) between '01:00:00' AND '05:00:00'' at line 1

only 2 data should be fetch 1 and 3

i had entered the data

i will explain you there is only 1 table in which there are 5 rows and i only had to fetch the data from that table. It only consists 3 rows which are between that time.
The problem is that date can be any date.

yeah i have written like
string date1 = Request.Form[txtdate1.UniqueID];
string.Format("dd/MM/yyyy", date1);
but
it is giving me error that "Conversion failed when converting date and/or time from character string."
may you help me
thanx in advance

i had just write the where clause at wrong place and now its working but i have another problem that is
i had write
string date1 = Request.Form[txtdate1.UniqueID];
string.Format("dd/MM/yyyy", date1);
and it is giving me error that "Conversion failed when converting date and/or time from character string."
may you help me

yeah i have use that but it giving me an error "Incorrect syntax near h' is too long. Maximum length is 128."

yeah thanx

I have to display 4 data Column on 4 label.

Great!!! dude i had done it is simple....
thanx sir

private HtmlGenericControl LIList(string innerHtml, string rel, string url)
{

HtmlGenericControl li = new HtmlGenericControl("li");

li.Attributes.Add("rel", rel);

li.InnerHtml = "" + innerHtml + "";

return li;

}


i had write the whole code of inner html that was define in link that you provide..
thanx

the error shows [Firefox can't find the server at ~.]...

error is in this line could you find anything
i am writing the code below because the comment is unable to write properly.

Hi Sir
ok i will explain you with more details..
i have a site in my d folder (D:\site\test) and there is 2 pages in my website first is default.aspx(D:\site\test\Default.aspx) and second is Result.aspx (D:\site\test\Result.aspx)...
and i just have to save the result.aspx url in the database so that if i click then it redirect me to Result.aspx....
i had tried this...
1. test/Result.aspx
2. ~/test/Result.aspx
3. d/site/test/result.aspx
if you have more question please ask

hi i have question

i have to store the link of a page in database. The page is in my website.
like an example
i have to store the link of Result.aspx page in database so how could i do this. i know that google.com can easily be store and its working with google.com but i want to know how to do this with result.aspx..

i have to create it dynamically. which i don't know how to do.
i had create it statically

thank you sir. Its pleasure to talk to you.
I will not forget your help.....
Sir i am beginner in C# now i able to see what i am doing wrong..

Sir may you tell me how i am executing the query of SELLER_DETAILS twice

yes i am executing the query twice because there are two tables in which i have to insert the data.

sir i have update the code.. when i insert values in second table (SELLER_DETAILS)it adds the same data twice.

i have tried this but still not working.

thanku sir i got the Solution thank you very much

sir i got the answer i.e iCatID.ToString() and iSubCatID.ToString() are written in wrong place in cmd
so i have changed one error occur when i just http://localhost:50476/SamsungClassifieds/Results.aspx
error - Object reference not set to an instance of an object.

not

http://localhost:50476/SamsungClassifieds/Results.aspx?Cat_Id=4&Sub_Cat_Id=1
and working properly...

sir did you got any answer??

Sir your answer is working but for some result. i.e when i directly run the page in browser than it will show me a error i.e. Object reference not set to an instance of an object.

sir the error is
The name 'iCatID' does not exist in the current context
The name iSubCatID does not exist in the current context

//int j = Convert.ToInt32(Request.QueryString["Cat_Id"]);
//int i = Convert.ToInt32(Request.QueryString["Sub_Cat_Id"]);


SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\site\SamsungClassifieds\App_Data\Dorknozzle.mdf;Integrated Security=True;User Instance=True");

con.Open();
if((int.TryParse(i.ToString(), out iCatID)&&(int.TryParse(j.ToString(), out iSubCatID))
{
//Do your DB retrieval here .....
SqlDataAdapter cmd = new SqlDataAdapter("SELECT AD_ID,AD_TITLE, AD_DESC, AD_IMG, AD_PRICE, AD_NO, SUB_CAT_DESC, CAT_DESC, SELLER_NAME, SELLER_MOB_NO, SELLER_EMAIL_ID, SELLER_DEP, SELLER_FLOOR,DATE FROM AD_DETAIL_V WHERE (DATE >= { fn CURDATE() }) and BUY_SELL_ID='1' and DELETED_AD = '0' AND SUB_CAT_ID= " + iSubCatID.ToString() + "AND CAT_ID =" + iCatID.ToString(), con);
DataSet ds = new DataSet();
cmd.Fill(ds);
int count = ds.Tables[0].Rows.Count;
if (count == 0) Response.Redirect("HomePage.aspx");
gvImages.DataSource = ds; gvImages.DataBind();
}
else
{ //Handle the parameter type error (i.e. - display a message or redirect user)
Response.Redirect("HomePage.aspx");
}
}

sir its giving me an error on i,iCatID,j,iSubCatID
same error i.e the name doesn't exists in context

Is there any Solution Sir??

ya but if there is any solution
??

sir i want to ask you one more thing i.e when i write some alphabet in cat_id or Sub_cat_ID then it give me a error i.e "Input string was not in a correct format."

sir i want to ask you one more thing i.e when i write some alphabet in cat_id or Sub_cat_ID then it give me a error i.e "Input string was not in a correct format."

sir change your ans i will accept it as ANSWER

sir i have found where we are wrong hypermellow is right..

you are Right sir Thanx sir

cmd.Fill(ds); int count = ds.Tables.Count; if (count == 0) Response.Redirect("HomePage.aspx"); gvImages.DataSource = ds; gvImages.DataBind(); } } Sir i have write the the code but it is not redirecting to HomePage. it remain on the result page.

cmd.Fill(ds);
int count = ds.Tables.Count;

if (count == 0)

Response.Redirect("HomePage.aspx");


gvImages.DataSource = ds;
gvImages.DataBind();
}
}

Sir i have write the the code but it is not redirecting to HomePage.
it remain on the result page.

yes sir you understood but its not working

cmd.Fill(ds);
gvImages.DataSource = ds;
gvImages.DataBind();

int count = ds.Tables.Count;

if (count == 0)
{
Response.Redirect("HomePage.aspx");
}
}
}

Sir i have write this code but its not working

sir this an example i want all that Category id and Sub Category ID to be redirect to home page if it is not exists..

Example - http://localhost:50476/SamsungClassifieds/Results.aspx?Cat_Id=4&Sub_Cat_Id=1
it will redirect to Result page - Because this cat and sub_cat id exists.

but http://localhost:50476/SamsungClassifieds/Results.aspx?Cat_Id=4&Sub_Cat_Id=1222 doesn't exists . therefore it will redirect to result page.

solution 2 is has an error i.e if I select the one the it show the respective data in 2 dropdown and a the same time if i select the 2 option from 1 dropdown then it show both the data that i select first time and 2 time.

solution 2 is has an error i.e if I select the one the it show the respective data in 2 dropdown and a the same time if i select the 2 option from 1 dropdown then it show both the data that i select first time and 2 time.
can you give me link from which i can go through to perform this problem.

how it can be done??

sir how to write this code can you please explain me i am new in jquery....

thanx for the answer.....

Thanx dude it works.....

the code display an error of " The best overloaded method match for 'string.ToString(System.IFormatProvider)' has some invalid arguments"

it's not right but thanx for reply.

your ans is right but i have to save dd/MM/yyyy like this but it is showing like mm/dd/yyyy this

the problem is date is stored but it is always 01/01/1900. date is not change according to user selected date.

how can i store an expiry date in my sql database.
please provide me the code.

not delete but it should not display after 1 or 2 month

i just want to save the date which should expire after 1 month or 2 month according to the user which post the data. And data should not display after expire.