ASP.NET

27-Nov-08 8:33

Hi, I am trying to import contents of excel spread sheet to the panel of textboxes (NOT datagrid). can anybody please tel me how to import the contents of each cell in the column into the textboxes dynamically as soon as the user opens the link of excel into the form. pls temme how to get the link into the form and how to retrieve the cells contents from that excel link and place into textboxes.

pls gimme some guidance .. i jus know how to create textboxes inside a panel.. but the rest im totally lost.. thanks.

Christian Graus27-Nov-08 10:01

27-Nov-08 10:01

You use office interop to read the cells. You're writing a website where the user uploads an xls and it's fed back as a panel of textboxes ?

Christian Graus

Driven to the arms of OSX by Vista.

adarshyam27-Nov-08 11:37

27-Nov-08 11:37

ya .. user must be able to browse for some xls document in his local hard disk and the cell contents in that particular document must be displayed in panel of textboxes in the form.. pls help me with code snippet.. im dunno how to start..

Christian Graus27-Nov-08 15:25

27-Nov-08 15:25

Like I said, you start with the interop libraries from Microsoft to control Office from .NET code.

Christian Graus

Driven to the arms of OSX by Vista.

adarshyam27-Nov-08 15:29

27-Nov-08 15:29

can you please send me some material similar to this stuff..

Christian Graus27-Nov-08 15:45

27-Nov-08 15:45

Really, all I know is that the library exists, and that there's tons of info on the web about it, I've not actually used it myself.

Christian Graus

Driven to the arms of OSX by Vista.

adarshyam27-Nov-08 18:55

27-Nov-08 18:55

im searchin for the past 2days.. i can get somethin which s not compatible to the version i have.. im using MS excel 2007 wit visual web developer 3.5 and can you pls temme how to make the user browse for the document he wants to retrieve the cel contents and put them in textboxes..please guide me .. im kinda lost even after tryin lot of prototypes

adarshyam30-Nov-08 7:22

30-Nov-08 7:22

can anybody pls help me with code for retrieving excel cell contents in panel of textboxes(not in gridView). im trying that for the past few days but no luck.. this is what i have done till now to open a file into my form..

<div id="divHidden" style="visibility: hidden; width: 0px; height: 0px">
  <input type="file" id="fileInput">
</input></div>

<input type="button" value="click here to get a file" onclick="getFile();">

<script language="javascript">
function getFile()
{
  //Use the <input type="file" ...=""> object to get a filename without showing the object.
  document.all["fileInput"].click();
  var fileName = document.all["fileInput"].value;
 
}
</input></script></input>

i want the excel contents in that excel file to be displayed in textboxes .. pls help me.. its an interestin prog i wan a solution. Confused | :confused:

so pls help

Navigate2

Sebastian T Xavier27-Nov-08 8:23

Sebastian T Xavier

27-Nov-08 8:23

Hi all,

I am working a desktop application, from which I need to invoke a web application. As the user have already signed into the desktop application, he doesn't want to login again in web application, so what i think is to pass a querystring to my webapplication & if the querystring is there I can bypass the login procedure.

Here is what I have tried for that...

InternetExplorer objie = new InternetExplorer();
String vHeaders = null;
String cPostData = null;
object vPost = null;
String strUserName = "test";
cPostData = "uname=" + strUserName + "&FromWindows=0";
vHeaders = "Content-Type: application/x-www-form-urlencoded" + "\n" + "\r";
vPost = ASCIIEncoding.ASCII.GetBytes(cPostData);
String strUrl = @"http://localhost/webreportingsystem/admin.aspx";
object objurl = new object();
object objNull = new object();
object objvPost = new object();
object objvHeaders = new object();
objurl = (object)strUrl;
objNull = null;
objvHeaders = (object)vPost;
objvHeaders = (object)vHeaders;
objie.Visible = true;
objie.Navigate2(ref objurl, ref objNull, ref objNull, ref objvPost, ref objvHeaders);

But nothing is happening for me. In my webapplication I can't receive the querystring values.
Can anybody guide me in this? Thanking you for your time !!!

Sebastian

Re: Navigate2

Christian Graus27-Nov-08 10:03

Set IsVisble Tag Property in SharePoint Data View WebPart based on query string

27-Nov-08 10:03

This is all very odd. Why not just use process.start to lauch IE ? Also, there are no query string values here. ( finally, this is not an ASP.NET question )

Christian Graus

Driven to the arms of OSX by Vista.

Brilliant_Corners27-Nov-08 5:48

Brilliant_Corners

27-Nov-08 5:48

Hello,

I would like to pass a string parameter to a SharePoint Data View Web part and control if the webpart is visible or not. I understand how to manually set the isvisible property (for example isvisible =”False”) in the DWP Tag Properties but I can’t pass a parameter into the web part.

What I would like to accomplish is have two webparts on the same page. I would like to display one of the webparts based on the query string parameter. For example,

www.site/default.aspx?id=1 set isvisble=”true” webpart1 - set isvisble=”False” webpart2

www.site/default.aspx?id=2 set isvisble=”true” webpart2 - set isvisble=”False” webpart1

I could filter based on the query string but the webpart still takes up space on the rendered page.

I could do this after the page renders with Javascript but it seems like I should be able to accomplish this more directly.

Thanks for any input.

BC

conditional split in ssis

l.laxmikant27-Nov-08 3:35

l.laxmikant

27-Nov-08 3:35

hi friends

I have created one ssis package using interface, it works fine

flow is like

oledbdatasource ->

conditional splits like
--> if action = 1 then oledb command 1 -> oledbcommand2
if action = 2 then oledb command 3 -> oledbcommand4
default output of conditional split
to oledb destination

i want to do this using C#.

all the components like conditional split and oledbcommand should be add on the fly.

any one can give me a hint or url for this.

thanks so much

Re: conditional split in ssis

Abhijit Jana27-Nov-08 3:38

Need help from ASP.Net Developers

27-Nov-08 3:38

Is it releated with Asp.net ?

cheers,
Abhijit

Binoy Rajan27-Nov-08 2:54

Binoy Rajan

27-Nov-08 2:54

Hi...

I am developing a website, which Contains Around 15 webpages. In Each page (Using MasterPage), it's having top menu (Not ASP.Net Menu Control, Only Html Anchor tags), left menu, and Right Menu. All menu items r Anchor Tags, not ASP.Net Menu Control. Right Side Menu Contents will be Changed Accoring to Page by Page. Right Now what I am Doing is,Right Menu Contents r In an ASP:ContentPlaceHolder. and Whenever Right Menu has to changed, On a Particular page, I am Overriding the MasterPage ASP:ContentPlaceHolder with Page's Design. it's working Fine.
But is this can be achieved, in any other way...
please give ur suggestions.......

Hope u people will help me..

Re: Need help from ASP.Net Developers

Abhijit Jana27-Nov-08 3:11

Re: Need help from ASP.Net Developers

27-Nov-08 3:11

binoy rajan wrote:
it's working Fine.

Great !!

binoy rajan wrote:
But is this can be achieved, in any other way...
please give ur suggestions.......

You are on right Track !!

Let us know if you have face any problem !!!

cheers,
Abhijit

Paul Conrad27-Nov-08 5:32

Paul Conrad

27-Nov-08 5:32

binoy rajan wrote:
it's working Fine.
But is this can be achieved, in any other way...

If it is working fine, then why change it? Are you trying to find a more efficient way of handling it?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Re: Need help from ASP.Net Developers

Binoy Rajan29-Nov-08 19:30

Binoy Rajan

29-Nov-08 19:30

S.. I am Looking For an Efficient Way...
Looking forward for ur suggestions...

How to validate textboxes using java script code while using Master page and content Page

Rameez Raja27-Nov-08 1:55

Rameez Raja

27-Nov-08 1:55

Hi all,

iam unable to validate textboxes enteries using java script code in asp.net 2.0 while iam using Master page.

I have created master page and an other one is Default under master Page and i have added few textboxes into default.aspx page and did validation using java script but iam unable to Perform validation .

can any body guide me in this issue. where to put java script code while we are using Master page and content Page scenario.

best regards
Rameez

Re: How to validate textboxes using java script code while using Master page and content Page

Abhijit Jana27-Nov-08 2:10

Re: How to validate textboxes using java script code while using Master page and content Page

27-Nov-08 2:10

I dont think there should be no issue. Java Script for Content page control should be written on Content page only .

rameez Raja wrote:
I have created master page and an other one is Default under master Page and i have added few textboxes into default.aspx page and did validation using java script but iam unable to Perform validation .

can you be more specific about your problem ?

cheers,
Abhijit

l.laxmikant27-Nov-08 3:31

l.laxmikant

27-Nov-08 3:31

i think u have use

document.getelementbyid(control name)

instead of that

use

document.getelementbyid('<%= ControlID.ClientID >')

webconfig error in webhosting server

pavanip27-Nov-08 1:31

pavanip

27-Nov-08 1:31

I placed my asp.net code in my server and i placed my database stuff in web hosting server.I created a virtual directory in web hosting server to access my files from my server.I have written the code in webconfig file like this
<connectionstrings><remove name="LocalSqlServer">
<add name="localsqlserver" connectionstring="Data Source=mssql302.ixwebhosting.com;Initial Catalog=Eminoso_yellowebsite;User ID=loginid;Password=password" providername="System.Data.SqlClient">
when i run this local its working but when i am trying to run using website server address i am getting webconfig error.
"An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customerrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customerrors> tag should then have its "mode" attribute set to "Off".

<configuration><system.web><customerrors mode="Off">"

can you please help me how to resolve this ixwebhosting problem.

Thanks in advance
pavani

Re: webconfig error in webhosting server

Abhijit Jana27-Nov-08 1:43

Re: webconfig error in webhosting server

27-Nov-08 1:43

First all, your config file is not in your post.
second , did you install .NET Framework on database server?

cheers,
Abhijit

pavanip27-Nov-08 2:00

pavanip

27-Nov-08 2:00

connectionstring
add name="localsqlserver" connectionstring="Data Source=mssql302.ixwebhosting.com;Initial Catalog=Eminoso_yellowebsite;User ID=xxxx;Password=xxxx" providername="System.Data.SqlClient"

This is my web config file.And i installed .net framework in serevr.
thank u i am waiting for your reply.

Re: webconfig error in webhosting server

Abhijit Jana27-Nov-08 2:04