Comments by Nigam,Ashish (Top 49 by date)

what problem you are getting?

You can use Rotator control to rotate your Products with Repeater or tables.

Its call as Jim told. You if you are using Asp.net then you can use JQuery or Javascript with Ajax call.

Can you mention which URL you are hitting?

Are you getting any error.

thanks Karthik

ok thanks Karthik

where do you want to store data in local or in server?

what is the problem you are getting?

please check is session "sepet" is available or not.

How many records you have in your table?

where have you stored images.

Check Connection timeout also with this change.

Can you mention whole function code.

you need to change connection time out in web config.

you are not changing value/stream of image in loop.

If he want to use this in a table then he can use alias in place of variables with select statement.

Hi, Why you are using two dataset, use one data set and get values with the join of your tables in query. if you have any relation with those tables.

Where have you written this code(In which Event).

please mention your code also.

Remove "Nid" from query because it is unique number. Try below query:

SELECT nCompanyId, nEmpId, sum(Salary) Salary, sum(TDS) TDS,sum(PF) PF
FROM Form16_temp
PIVOT(
MAX([dAmt])
for [sComp] IN ([Salary],[TDS],[PF])
) as P
group by nCompanyId, nEmpId

what is the output you are getting. with new query

You can make a Deployment project for this with help of below link.

http://www.c-sharpcorner.com/UploadFile/996353/create-setup-and-deployment-project-in-visual-studio-200820/

http://vijirajkumar.blogspot.in/2010/03/create-setup-and-deployment-project.html

http://www.fordevs.com/2009/07/steps-to-create-setup-and-deployment-project-in-dot-net-vs-2008.html

I think Proc is best way

which Visual studio version you are using?

Where is your check box is it in Grid or in form (out side of grid).

ok

what is the error you are getting?

You can not restore upper version database in lower version.

you can replace your textbox control Id in place of button.

document.getElementById('<%=yourTextboxId.ClientID %>').disabled = true;

Ok, then why it is showing in List. It should not show on list for suggestion/Solution.

Has this problem resolved?

Please mention what out put/error you are getting
I have seen your code I got a problem with your code in last two below lines.

string State = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; //Country
string City = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; //Country

in both line you are using same control for City and State I think it is wrong.

use sub group for this

can you send me screen shots or code of after change and error details.

DECLARE @i BIGINT = 1
SELECT @i = ( CASE WHEN 1 = 1 THEN @i+1 ELSE @i END )
select @i

you cann't get querystring in source page direct.

but if you are using back button in your page then you can again send query string to source page from second page.

You have to check decryption logic/function in your database/application code.

Please see the answer no Solution 3.

I have given u a example you can put @usageunitName='pc' instead of '' or null and put your field in place of your field, and replace " AND " in to "OR"

you Need to Convert ordernr field in varchar/char type. You can use like

"SELECT convert(varchar(100),TT.ORDERNR) + ' ' + PostIt.Text FROM"

Ashish Nigam

What is the use of @article parameter?

Hi,

Then you should use sum function for "target" and remove "target" from the Group by. Like this:


INSERT INTO Table3
SELECT Table1.Name, COUNT(Table2.ID),sum(Table1.Target)
FROM Table2


INNER JOIN Table1 ON Table2.ID=Table1.ID

GROUP BY Table1.Name


Ashish Nigam

Yes you are right. thanks for your comments. I will remember this.