|
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.
|
|
|
|
|
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.
|
|
|
|
|
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..
|
|
|
|
|
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.
|
|
|
|
|
can you please send me some material similar to this stuff..
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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()
{
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.  so pls help
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Is it releated with Asp.net ?
cheers,
Abhijit
|
|
|
|
|
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..
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
S.. I am Looking For an Efficient Way...
Looking forward for ur suggestions...
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
i think u have use
document.getelementbyid(control name)
instead of that
use
document.getelementbyid('<%= ControlID.ClientID >')
|
|
|
|
|
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
|
|
|
|
|
First all, your config file is not in your post.
second , did you install .NET Framework on database server?
cheers,
Abhijit
|
|
|
|
|
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.
|
|
|
|
|
Still same problem.
Just do one thing while posting web.config code, please select "Ignore HTML tags in this message (good for code snippets)" check box in the bottom of editor !!!
cheers,
Abhijit
|
|
|
|
|
ok.Sorry for the inconvinience.this is my config file
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="localsqlserver" connectionString="Data Source=mssql302.ixwebhosting.com;Initial Catalog=Eminoso_yellowebsite;User ID=xxxx;Password=xxxx" providerName="System.Data.SqlClient"/>
</connectionStrings>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
