Comments by kishorekke

kishorekke 2-Apr-14 11:14am View

Thanks for the replay. Actually this is working in my machine but it is giving error on remote server. I have given everyone full permission also. Could you please suggest me wat needs to do.

kishorekke 31-Mar-14 10:07am View

Everyone full control

kishorekke 25-Jul-12 3:59am View

first connect to your server2 then write a procedure in ur server2 like below

@server = 'SERVER1',
@srvproduct = 'sqlserver',
@provider = 'SQLOLEDB',
@datasrc = '12.228.0.0' -- Server IP Address

--Create Login Credentitals to The Patron Server
EXEC Master.dbo.SP_ADDLINKEDSRVLOGIN 'SERVER1', 'false', null, 'sa', 'sa'

--Create RPC to Server
EXEC Master.dbo.sp_serveroption @server='SERVER1', @optname='rpc', @optvalue='true'
EXEC Master.dbo.sp_serveroption @server='SERVER1', @optname='rpc out', @optvalue='true'

-- Your query
SELECT * FROM SERVER1.TempDB1.dbo.Source1 S1 INNER JOIN SERVER1.TempDB1.dbo.Source2 S2 ON S1.ID=S2.ID

--Delete the Server link and Login Credentials
EXEC Master.dbo.sp_dropserver 'SERVER1', 'droplogins'

kishorekke 17-Jul-12 8:52am View

Hi friend thanx for your solution. I want always focus on the popup.
if i use ..
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "var Mleft = (screen.width/2)-(760/2);var Mtop = (screen.height/2)-(700/2);window.open( '39;your_page.aspx?InvoiceID='" + strInvoiceID.ToString();+"', null, 'height=700,width=760,status=yes,toolbar=no,scrollbars=yes,menubar=no,location=no,top=\'+Mtop+\', left=\'+Mleft+\'' ).focus();", true);

This is working in IE9.0 but getting error in IE8.0
Please suggest me, it should work on ie8 also.
Thanks
Kishore

kishorekke 13-Jul-12 7:38am View

except the above statement.. everything is fine in your procedure

kishorekke 4-May-12 8:01am View

hi friend.. i used like that but not working..

function calculateTime(strName) {

debugger

//Totals

var lbl=$find("tabMain$TabMTQAHours$lblTotalHoursWorked");

//var lbl=$find("tabMain_TabMTQAHours_lblTotalHoursWorked");

//var totalhours=document.getElementById("tabMain_TabMTQAHours_lblTotalHoursWorked").innerText;

alert(lbl.innerHTML);

kishorekke 4-May-12 7:37am View

Deleted

i cont post all the code here... it is not able to display

kishorekke 4-May-12 7:34am View

Deleted

hi how to attach design

kishorekke 18-Oct-11 3:01am View

please send the query u wrote..

kishorekke 13-Oct-11 7:46am View

ID|
Name (FirstName+LastName)|
E-Mail |
ContactNo (isnull(Mobile,PhoneNo)) |
Address (Address+Street+City+State+Country+Zip) |
EDIT

When u click on Edit link, get the details with ID and display all the fields in a panel and update. After u click update button in panel then bind grid again it will display updated row in grid

kishorekke 12-Oct-11 4:14am View

you welcome...

kishorekke 11-Oct-11 8:30am View

can u show ur code?

kishorekke 29-Sep-11 5:46am View

But i want to operate this from code window. Please suggest me

kishorekke 21-Sep-11 3:56am View

You can use Varchar insted int in that table like below

CREATE TABLE #tempTable (CUS_NO varchar(15))
DECLARE @CODE AS VARCHAR(20),
@tbl varchar(30),
@delimiter char(1) = ',' ,
@sql varchar(8000),
@select varchar(8000)
SET @tbl='#tempTable'
SET @CODE = '1,2,3,4,1003'
SET @select = 'SELECT ' + REPLACE(@CODE, @delimiter, ' SELECT ')
SET @select = REPLACE(@select, '''', '''''')
SET @sql = 'INSERT ' + @tbl + ' EXEC(''' + @select + ''')'
EXEC (@sql)
SELECT * FROM CUSTOMER
WHERE CUSTOMER.CUS_NO IN (
(select distinct CUS_NO from #tempTable
UNION
select CUSTOMER.CUS_NO)
)
DROP TABLE #tempTable

Comments by kishorekke (Top 14 by date)