Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - ASP.NET Discussion Boards

how to read Excel file and show records into the Grid.

Tejesh Kamble31-Oct-07 1:09

31-Oct-07 1:09

Hi All,
I want to read Excel file and show records into the Grid.
for that i have written vb.net code,this code is successfully running as follows:
DataGrid1.DataSource =
Excel.GetWorkSheetByName(Excel.ExcelWorkSheets.Item(0).TableName);
DataGrid1.DataBind();

while writting same code in c# as follows:

DataGrid1.DataSource =
Excel.GetWorkSheetByName(Excel.ExcelWorkSheets.Item[0].TableName);
DataGrid1.DataBind();

it gives an error message as follows:
Cannot apply indexing with [] to an expression of type 'WorkSheet'

Please Help.

Thanks in advance.

Tejesh Kamble.

Re: how to read Excel file and show records into the Grid. [modified]

Jintal Patel31-Oct-07 2:05

Jintal Patel

31-Oct-07 2:05

hi
i m not getting what's the error ...

but u try like this

string strcon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\jintal\\test\\test.xls; Extended Properties=Excel 8.0;";
OleDbConnection con = new OleDbConnection(strcon);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connection);

DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "Sheet1$");
GridView1.DataSource = myDataSet.Tables["Sheet1$"].DefaultView;
GridView1.DataBind();

-- modified at 8:15 Wednesday 31st October, 2007

Jintal Patel

Re: how to read Excel file and show records into the Grid.

Tejesh Kamble31-Oct-07 2:30

Tejesh Kamble

31-Oct-07 2:30

Thanks for ur reply.

I will try this.

Tejesh Kamble.
Software Engineer.

Paging problem in GridView [modified]

Thavika31-Oct-07 0:55

Thavika

31-Oct-07 0:55

With the Index I m finding control so wen it reaches 5th record it searches for 6th then says out of range error because pagesize is 5

-- modified at 7:22 Wednesday 31st October, 2007

kavitha

Re: Paging problem in GridView

Imran Khan Pathan31-Oct-07 1:24

Imran Khan Pathan

31-Oct-07 1:24

Because here gridview's datasource contains only 5th records.

bEst rEgard
pAthan

please don't forget to vote on the post that helped you.

Re: Paging problem in GridView

Thavika31-Oct-07 1:31

Thavika

31-Oct-07 1:31

I m very clear i know that only 5 rows are ther in the grid .but i need all the records from the grid

kavitha

Re: Paging problem in GridView

Imran Khan Pathan31-Oct-07 1:35

Imran Khan Pathan

31-Oct-07 1:35

Thavika wrote:
5 rows are ther in the grid .but i need all the records from the grid

please don't forget to vote on the post that helped you.

sachinkalse31-Oct-07 0:44

sachinkalse

31-Oct-07 0:44

Dear All,
I have a web application (ASP.NET / framework 2.0 / Windows Server 2003) on one machine, i.e. Web Server and corresponding database (SQL Server 2005) on second machine.
If I access the application from Web Server, it works fine, but when I access from a third client machine it gives following error
-------------------------------------------------------
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
-------------------------------------------------------

I think this has some thing to do with the permissions to access DB from client machines

my Web.config file has following things added
---------------------------------------------------------
<add name="ConnString" connectionString="workstation id=MY_WORKSTATION;packet size=4096; integrated security=SSPI;data source=MY_DB; persist security info=False;initial catalog=MY_CATALOG"/>
<system.web>
.....
<identity impersonate="true"/>
.....
</system.web>
---------------------------------------------------------

Moreover, the SQL Server is configured as per following link
"http://support.microsoft.com/kb/914277"

Please guide

Regards
Sachin

How to close a frame in a webpage?

Spunky Coder31-Oct-07 0:36

Spunky Coder

31-Oct-07 0:36

How to close a frame from either javascript or from code behind in a page? Suppose if in a page two frames are present and in one frame an aspx page is present...in onClick of a button in the aspx page the other frame should be closed and the aspx page should occupy the whole window ...is there any way to do this?

Koushik

Re: How to close a frame in a webpage?

N a v a n e e t h31-Oct-07 1:01

N a v a n e e t h

31-Oct-07 1:01

I guess you can't close a frame. You can redirect to other page which don't have any frames.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

HTML Source From URL

raju melveetilpurayil31-Oct-07 0:35

raju melveetilpurayil

31-Oct-07 0:35

code for get HTML Source from input URL

using System.Web.Caching;
using System.Net;
using System.IO;

string URL = TextBox1.Text;//INPUT URL
if (URL.Substring(0, 7) != "http://")//CHECK URL CONTAIN http://
{
URL = "http://"+TextBox1.Text;
}
string ConvertURL =(string)Cache.Get(URL);
if (ConvertURL == null)
{
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(new Uri(URL));
HttpWebResponse res = (HttpWebResponse)req.GetResponse();
StreamReader srdr = new StreamReader(res.GetResponseStream());
ConvertURL = srdr.ReadToEnd();
}
Response.Write(ConvertURL);

Raju.M
http://aspdotnetprogrammer.blogspot.com/

Re: HTML Source From URL

Guffa31-Oct-07 1:00

Guffa

31-Oct-07 1:00

makhaai wrote:
URL = "http://"+TextBox1.Text;

Why reading it from the text box again? Just do:

URL = "http://" + URL;

makhaai wrote:
string ConvertURL =(string)Cache.Get(URL);

Why do you look in the cache for the source? Do you have any code elsewhere that stores anything in the cache?

You forgot to dispose the HttpWebResponse and the StreamReader.

---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams

Re: HTML Source From URL

N a v a n e e t h31-Oct-07 1:04

N a v a n e e t h

31-Oct-07 1:04

He was not asking a question, it seems like he is advertising this[^]

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: HTML Source From URL

Guffa31-Oct-07 9:49

Guffa

31-Oct-07 9:49

N a v a n e e t h wrote:
He was not asking a question

Yeah, I didn't see any question, but he got an answer anyway. Smile | :)

N a v a n e e t h wrote:
it seems like he is advertising this[^]

Seems you can take any crappy code and make a blog out of it... Wink | ;)

Re: HTML Source From URL

Guffa31-Oct-07 9:47

Guffa

31-Oct-07 9:47

makhaai wrote:
please tell wat is the prob in my code?

I just did.

button id in gridvew

Sonia Gupta31-Oct-07 0:28

Sonia Gupta

31-Oct-07 0:28

i have a jaascript function. and a gridview , which contains a button.My problem is , how i should add the attributtes of that utton.i am doing it in the following manner.
on form load i am extracting the id of button (whichh is in gridview).
Button l = (Button)GridView1.FindControl("p");
l.Attributes.Add("onClick", "javascript:return abc();");

and in java script i am extracting the button id in the following manner.

function abc()
{
var a = document.getElementById("<%=GridView1.subassembly.ClientID%>");
alert(a);
}
after doing this , i am gettng an error, does not contain the definition for
subassembly.
Where is the problem lying?

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: button id in gridvew

N a v a n e e t h31-Oct-07 0:35

N a v a n e e t h

31-Oct-07 0:35

Sonia Gupta wrote:
i am gettng an error, does not contain the definition for
subassembly.

From this you got the error. What's the problem now ?

Sonia Gupta wrote:
var a = document.getElementById("<%=GridView1.subassembly.ClientID%>");

What is the use of getting Gridview's client id here ? Controls inside gridview will be having different id.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: button id in gridvew

InsDev31-Oct-07 0:36

InsDev

31-Oct-07 0:36

U have place button inside a gridview of row. If yes use this code in rowDataBound Ok.

Button btn=(Button)e.Row.FindControl("buttonID");
btn.Attributes.Add("onclick","javascript:abc('"+btn.ClientID+"')");

It will work. Smile | :)

Devjit Das.

Re: button id in gridvew

Sonia Gupta31-Oct-07 0:41

Sonia Gupta

31-Oct-07 0:41

actually , i have textbox also, and after leaving the textbox blank , i want a messagebox.
that's y i am writig the code in the source file.
and i am using this tag var a = document.getElementById("<%=GridView1.subassembly.ClientID%>");
in java script because the page is of master type, i mean the html is under content place holder tag.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: button id in gridvew

InsDev31-Oct-07 0:49

InsDev

31-Oct-07 0:49

what ever u want to do do.
just use like this of script function.

function abc(id)
{
var a = document.getElementById(id);
alert(a);
}

Devjit Das

Re: button id in gridvew

InsDev31-Oct-07 1:39

InsDev

31-Oct-07 1:39

what happen have u done.

Devjit Das.

Re: button id in gridvew

Sonia Gupta31-Oct-07 1:54

Sonia Gupta

31-Oct-07 1:54

how should i access the button id which is placed in the template column of gridview.and i want to wite the funciton in javascript at source file.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: button id in gridvew

InsDev31-Oct-07 2:04

InsDev

31-Oct-07 2:04

what is this i have all ready given the code. just once again.

In grid use this event.
grid_RowDataBound
Button btn = (Button)e.Row.FindControl("buttonID");
btn.Attributes.Add("onclick", "javascript:abc(" + btn.ClientID + ")");

Note buttonID means the id u have provide in grid template ok.

javascript function
function abc(id)
{
document.getElementById(id);
alert("Plz enter value");
}

It will work . ok Smile | :)

Devjit Das

Re: button id in gridvew

Sonia Gupta31-Oct-07 2:18

Sonia Gupta

31-Oct-07 2:18

InsDev wrote:
function abc(id)
{
document.getElementById(id);
alert("Plz enter value");
}

message box is saying null.
anything missing?

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: button id in gridvew

InsDev31-Oct-07 2:23

InsDev

31-Oct-07 2:23

in ur code message box never say null. Ok
use like ...
var _txt=document.getElementById(id);
alert(_txt);

See object ur r getting or not.

Devjit Das.

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