Re: Reading the Excel sheet - ASP.NET Discussion Boards

TheEagle20-Jun-06 21:41

20-Jun-06 21:41

Is it possible to transfer data between a Windows Application and a Web Application?
and How?

"I am too late but i will never give up"

Re: Windows & Web Applications

Vasudevan Deepak Kumar20-Jun-06 22:45

Vasudevan Deepak Kumar

20-Jun-06 22:45

Yes. You can use a WebService to do that.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

Re: Windows & Web Applications

TheEagle23-Jun-06 7:46

TheEagle

23-Jun-06 7:46

Thank you for you respond...

I want to make a windows application on my computer for chating with my website clients...

Infact the web application have been uploaded on the Web Hosting Service server so I want the web application to transfer data to my windows application and vice versa so it is possible to chat other website clients through the web application(the web application represents other clients where the windows application represents me).

"I am too late but i will never give up"

Janus Controls -- Listview

Uma Kameswari20-Jun-06 21:09

Uma Kameswari

20-Jun-06 21:09

Hi,
I have janus control listview.Now my problem is if i want to sort the contents of this listview in numeric order rather than alphabetical order how do i do that. It is given that using Sorted and SortType properties we can achieve this.But they are not supported .I am using asp.net 1.1 framework.How do i achieve this task now.
Regards,
Uma

Re: Janus Controls -- Listview

Vasudevan Deepak Kumar20-Jun-06 22:56

Vasudevan Deepak Kumar

20-Jun-06 22:56

Uma,

In that case, you have them done before and then bound right, based on Item events. It actually depends on the particular component or a fix (patch) for it.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

Re: Janus Controls -- Listview

Uma Kameswari23-Jun-06 0:42

Uma Kameswari

23-Jun-06 0:42

hello Vasudevan Deepak Kumar,
I did not understand. Can u send me the sample code?
Uma

Reading the Excel sheet

Sandeep Akhare20-Jun-06 20:42

Sandeep Akhare

20-Jun-06 20:42

hi I am developing the web application in which i want to read Name ranges given to excel sheet i am reading it using Excel COM object but it is taking more time than expected . So can i read the Name Ranges of excel sheet using oledb connection please help me . i am using ASP.net

Re: Reading the Excel sheet

Vasudevan Deepak Kumar20-Jun-06 23:04

Vasudevan Deepak Kumar

20-Jun-06 23:04

Two things:

(*) Excel is basically a desktop application. Microsoft support itself does not recommend heavy use of Office applications in ASP.NET as it might deadlock.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^]

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

Re: Reading the Excel sheet

Sandeep Akhare21-Jun-06 2:58

Sandeep Akhare

21-Jun-06 2:58

hi Vasudevan
Then what to do ? i want the name ranges of the excel sheet please help me this

adding of dll for TreeView

Prasanna Kuamri Pydi20-Jun-06 20:22

Prasanna Kuamri Pydi

20-Jun-06 20:22

how to add TreeView.dll in microsoft visual studio .net 2003

prasanna

Re: adding of dll for TreeView

sathish s20-Jun-06 20:47

sathish s

20-Jun-06 20:47

Have a look here
http://www.samspublishing.com/articles/article.asp?p=101748&seqNum=9&rl=1

Re: adding of dll for TreeView

Vasudevan Deepak Kumar20-Jun-06 23:05

Vasudevan Deepak Kumar

20-Jun-06 23:05

You can reference it from 'References' and/or copy to the bin folder of the application right?

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

How to pop up a web form as a modal dialog box??

kvPriya20-Jun-06 19:46

kvPriya

20-Jun-06 19:46

Hi,
I've two webforms. When a condition is satisfied, I need to pop up a webform as a modal dialog box where the user can enter some text.After submitting this child form, the user had to be redirected to some other webform. Inorder to catch the text,I've used a session variable.
What I've worked is......
In html page, I've written

function giveReason(w,h)
{
wleft = (screen.width-w) / 2;
wtop = (screen.height-h) / 2;
imgwindow1=window.open("HiReason.aspx","imgwindow1","width="+w+",height="+h+",left="+wleft+",top="+wtop+"status:Yes;");
imgwindow1.focus();
}

And I've called the above script function in codebehind page as...
jstr = " giveReason(500,170);"
Page.RegisterClientScriptBlock("reasonKey", jstr)

After that...
In child form,

Dim strjscript As String = ""
strjscript = ""
strjscript &= "window.opener.Home.Text1.focus();"
strjscript &= "window.close();"
strjscript = strjscript & "</script" & ">"
RegisterClientScriptBlock("close", strjscript)

Home is some other webbform's id.
While running this,I'm getting the error.... "imgwindow1 is null or not an object. poop up window is blocked"

Any suggestions?? Thanks in advance....

-Priya

Re: How to pop up a web form as a modal dialog box??

varshavmane20-Jun-06 20:33

varshavmane

20-Jun-06 20:33

Instead use this

var winSettings = "dialogWidth:350px;dialogHeight:300px; help: no; status: no";
var qs = "../Calender/Calender.aspx";
var values = window.showModalDialog(qs,'cal',winSettings);

Where values will have all the return values from child form.

In Child Form:

var MyArgs = new Array();
MyArgs[0] = value1;
MyArgs[1] = value2;
window.returnValue = MyArgs;
window.close();

I hope this will help u.If not let me know.

Re: How to pop up a web form as a modal dialog box??

Vasudevan Deepak Kumar21-Jun-06 0:20

Vasudevan Deepak Kumar

21-Jun-06 0:20

showModal is IE specific. Netscape needs workarounds using blurring and focussing techniques and tricks.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

Display info in a process

miftha20-Jun-06 19:35

miftha

20-Jun-06 19:35

I have a process to be run at the end of year in a leave management system. The process is started when the start process button is pressed, I need to show the employee number currently been processed in a label or a text box. What i did was i gave (Ex : text1.text = tabel(0).row(0).item(0)) when the record is bean read in the for loop. but it shoes only the last record in the process because the processing bar in the page was activated while the process is on. Is there another way to show the record that is being processed in the text box.

Thanx Laugh | :laugh:

AMIF

Are You Stored Procedure Savvy..........

Nagraj Naik20-Jun-06 19:27

Nagraj Naik

20-Jun-06 19:27

Hi All,
I am creating dynamic stored procedure,means quuery condition is depending runtime supplied parameter values.

stored procedure is given below.

ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50),

AS

Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)
set @Where = ''
set @Select ='Select KeySkills from Jobseeker'
/*set @Select ='Select * from jobseeker'*/
if(@KeySkills is not NULL )
begin
set @Where = ' KeySkills = ' + @KeySkills end

set @Select = @Select + @Where
EXEC (@Select)

It gives error at statement in bold
Incorrect syntax near '='.

Regards,

Re: Are You Stored Procedure Savvy..........

Edbert P20-Jun-06 20:01

Edbert P

20-Jun-06 20:01

KeySkills expects nvarchar, so the code should be
set @Where = ' KeySkills = ''' + @KeySkills + ''''
The '' above are two single quotes.

However, after saying that, you should use sp_executesql instead which to execute your dynamic sql, which accepts the following parameter:
EXEC sp_executesql @sqlString, @paramlist, [@param1], [@param2], ...

@sqlString example is 'SELECT * FROM tblA WHERE KeySkills = @KeySkills'
@paramlist is a list of parameters your sqlString requires, e.g.
SET @paramlist = '@KeySkills nvarchar(50), @Param2 nvarchar(50)'
@param1 to @paramN are your parameter values, it has to correspond to the exact ordering in @paramlist (e.g. @KeySkills have to be passed as first parameter).

Hope that helps.

"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross

Edbert
Sydney, Australia

Re: Are You Stored Procedure Savvy..........

Nagraj Naik20-Jun-06 20:20

Nagraj Naik

20-Jun-06 20:20

Hi Edbert,
As you suggest I made changes But Error is still coming on same line.
If possible please run this query at your end and correct it accordingly.

ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50)

AS
Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)

set @Where = ''
set @Select ='Select KeySkills from Jobseeker'

if(@KeySkills is not NULL )
begin
/* set @Where = ' KeySkills = ' + @KeySkills */

set @Where = ' KeySkills = ''' + @KeySkills + ''''
end

set @Select = @Select + @Where

EXEC sp_executesql @Select

RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Re: Are You Stored Procedure Savvy..........

Edbert P20-Jun-06 20:31

Edbert P

20-Jun-06 20:31

Oh! If you're going to use the sp_executesql you do not need the single quote between the @KeySkills.
And you're missing the WHERE clause after your SELECT statement.
Try this instead:

set @Where = ''
set @Select ='SELECT KeySkills FROM Jobseeker WHERE 1 = 1 '

if(@KeySkills is not NULL )
begin
<code>set @Where = ' AND KeySkills = @KeySkills '</code>
set @Select = @Select + @Where              /* Resulting in SELECT KeySkills FROM Jobseeker WHERE 1 = 1 AND KeySkills = @KeySkills */

SET @paramlist = '@KeySkills nvarchar(50)'  /* You need to specify all the parameters you use */

<code>EXEC sp_executesql @Select, @paramlist, @Keyskills</code>   /* You need to pass not only the sql statement, but the parameter list and the parameter value itself */

Hope that one works.

"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross

Edbert
Sydney, Australia

Re: Are You Stored Procedure Savvy..........

Nagraj Naik20-Jun-06 20:51

Nagraj Naik

20-Jun-06 20:51

Hi,
Thanks A lot.
I hope we will meet again with new discussion.

Regards,
Nagraj
Let's Teach Life To Laugh........

Re: Are You Stored Procedure Savvy..........

Vasudevan Deepak Kumar21-Jun-06 0:22

Vasudevan Deepak Kumar

21-Jun-06 0:22

Missing Quote Delimiters or Preferably an IN operator, for faster queries.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
ViewPoint 24x7

Popup window on button click and fetching the value back [modified]

Varun Arora20-Jun-06 19:15

Varun Arora

20-Jun-06 19:15

Urgent
Hi all,

I have a textbox and a button with it. I want on clicking the button , a popup window should open. And after selecting record from popup window it should fill the value in the textbox of previous page.

Suggestions and links are welcome.

Regaruds,
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India

-- modified at 1:40 Thursday 22nd June, 2006

Re: Popup window on button click and fetching the value back

varshavmane20-Jun-06 20:35

varshavmane

20-Jun-06 20:35

Can u please tell me u want popup on Button click or textbox click???

Re: Popup window on button click and fetching the value back

Varun Arora21-Jun-06 19:38

Varun Arora

21-Jun-06 19:38

Button Click

Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.