ASP.NET Discussion Boards

First Prev Next

Re: Converting excell file into html file

Arun.Immanuel23-Apr-07 1:39

Arun.Immanuel

23-Apr-07 1:39

Hi,

Here is the entire code:

using System;
using System.Collections ;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

Excel.Application excel = null; //In my system i am unable to refer the class Excel.Application like what U have.

Excel.Workbook xls = null;
excel = new Excel.Application();
object missing = Type.Missing;
object trueObject = true;
excel.Visible = false;
excel.DisplayAlerts = false;

xls = excel.Workbooks.Open("E:\\aOfficial\\MyFiles\\Output1.xls", missing, missing, missing,

missing,missing,missing,missing,missing,missing, missing,missing,

missing,missing,missing);

object format = Excel.XlFileFormat.xlHtml;

IEnumerator wsEnumerator=excel.ActiveWorkbook.Worksheets.GetEnumerator();
int i = 1;

while (wsEnumerator.MoveNext ())
{

Excel.Worksheet wsCurrent = (Excel.Worksheet )wsEnumerator.Current;//This is the only change
String outputFile = "d:\\a" + "." + i.ToString() + ".html";
wsCurrent.SaveAs(outputFile, format, missing, missing, missing,
missing, missing, missing, missing, missing);

}
excel.Quit ();

}
}

Regards,
Arun Kumar.A

Re: Converting excell file into html file

Lijo Rajan23-Apr-07 4:08

Lijo Rajan

23-Apr-07 4:08

Thank You verymuch Mr Arun.

How can we pass more than one Query String in the site map,

kaushik49019-Apr-07 19:53

kaushik490

19-Apr-07 19:53

hi,

How can we pass more than one Query String in the site map

<b> this is the exmaple for one query string :</b>

<siteMapNode url="~/Members/Membersmails.aspx?otherCall=No" title="Inbox" description="Inbox"></siteMapNode>

now i want to pass 3 query strings:
<b>this is my code:</b>

<siteMapNode url="~/Members/Memberscomposemail.aspx?otherCall=No&email=k.pulpa@gmail.com&k=7 title="Inbox" description="Inbox"></siteMapNode>

but this is not working
Can any one help me out with this.
Thanx in Advance

Re: How can we pass more than one Query String in the site map,

Davide Icardi20-Apr-07 5:17

Davide Icardi

20-Apr-07 5:17

I think that the & is an xml reserved character, you must use the entity form like this & amp ; (without the spaces).

Davide

Re: How can we pass more than one Query String in the site map, [modified]

kaushik49020-Apr-07 17:47

kaushik490

20-Apr-07 17:47

It has really helped me,

Thanx a lot ,

I have hard coded the values as below

<siteMapNode url="~/Members/Memberscomposemail.aspx?otherCall=No&email=k.pulpa@gmail.com&k=7" title="Compose Mail" description="Compose Mail"></siteMapNode>

How to pass dynamically the values in the query String of the sitemap

with thanks and regards,
kaushik pulpa

-- modified at 0:07 Saturday 21st April, 2007

IIS Response

NICE TO MEET19-Apr-07 19:31

NICE TO MEET

19-Apr-07 19:31

we are requesting an asp page and aspx pages, how the IIS knows the both the pages are different while giving the output from server

Thanks in Advance

Re: IIS Response

sangramkp20-Apr-07 2:22

sangramkp

20-Apr-07 2:22

There is different HTTP handlers for different extensions.

The request will will pass through different Http Modules and atlast it will be handled by apropriate HTTP hendler.

String Encrypt and Decrypt

monuSaini19-Apr-07 19:25

monuSaini

19-Apr-07 19:25

Hello Friends,

I am encrypting an string and passing it with URL,

But when it is decrypted it is creating the following error :

System.FormatException: Invalid length for a Base-64 char array. at System.Convert.FromBase64String(String s)

but its working fine on local.

I have noticed one thing that which encrypted string is having '+' in it only that encrypted string creating this error while decrypting online.

And same encryped string is decrypted on local it is working fine...

I am not able to understand why it is happening.

Regards,

rahul saini

Re: String Encrypt and Decrypt

Sathesh Sakthivel19-Apr-07 19:30

Sathesh Sakthivel

19-Apr-07 19:30

In .Net, the method you're looking for is this one: System.Web.HttpUtility.UrlEncode().

http://msdn2.microsoft.com/en-us/library/system.web.httputility.urlencode.aspx

Hope this helps,

Regards,

Satips.

Re: String Encrypt and Decrypt

monuSaini19-Apr-07 19:56

monuSaini

19-Apr-07 19:56

Hello Satips,

I think it will work,

as same it is working on local fine ,

I had make changes online now hope for best.

Thanks. Smile | :)

Regards,

rahul saini

Re: String Encrypt and Decrypt

monuSaini19-Apr-07 21:33

monuSaini

19-Apr-07 21:33

hello Satips,

When i encode an id 58 using httpUitility it returns %7f%3b%f0%a5h%c4wu

but when i pass it in query string it shows the same but when i do request.querystring["Id"] it returns ;hwu t

regards;

rahul saini

Re: String Encrypt and Decrypt

Sathesh Sakthivel19-Apr-07 23:01

Sathesh Sakthivel

19-Apr-07 23:01

monuSaini wrote:
but when i pass it in query string it shows the same but when i do request.querystring["Id"] it returns ;hwu t

Clearly specify your doubt.

I could not able to get your problem.

Regards,

Satips.

Data Grid Row Color

NICE TO MEET19-Apr-07 19:14

NICE TO MEET

19-Apr-07 19:14

for my requirement i want to change the colour of datagrid row by two colours alternatively, how can i achieve this requirement,

also based on one column value yes or no, if no means i want to change the row colours

please help for the two scenario

Thanks in advance

Re: Data Grid Row Color

Sathesh Sakthivel19-Apr-07 19:34

Sathesh Sakthivel

19-Apr-07 19:34

Try with Code

function myColor(){ <br />
    var i = this.getRowProperty("index"); <br />
    return obj_data[i][9]; <br />
} <br />
<br />
obj.getColumnTemplate(0).setStyle("color", myColor); <br />
  <br />

Regards,

Satips.

Re: Data Grid Row Color

Mayank Parmar19-Apr-07 19:44

Mayank Parmar

19-Apr-07 19:44

Write this code in ItemDataBound Event
-----------------------------
LinkButton lbd = (LinkButton)e.Item.FindControl("lbDLI");
if (e.Item.FindControl("lbDLI") != null)
{
if (DataBinder.Eval(e.Item.DataItem, "LIVE") != null) // Here LIVE is column name in database
{
int i = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "LIVE"));
if (i == 0)
{
lbd.Text = "Idle";
}
else
{
lbd.Font.Bold = true;
lbd.ForeColor = Color.Green;
lbd.Text = "Live";
}
}
}

Regards,
Mayank Parmar
Senior Software Engineer
Amba Tech
Gandhinagar, India

.net remoting and object invocation

alimohammed19-Apr-07 18:43

alimohammed

19-Apr-07 18:43

Hi all,
I am a beginer in .net and i hav to implement a chat program [ web application, not standalone] and i have implemented public chat, but in private chat if a user send a mesage to another, i wanna pop up a window in the second user's computer [ like all other chat servers]. How can i invoke a remote object from server [ to pop up a window in client system from web server ]?

please advice.

Thanks to all.

Ali

Re: .net remoting and object invocation

xibeifeijian19-Apr-07 20:36

xibeifeijian

19-Apr-07 20:36

Server send messages to client?In C/S system there maybe some solutions use socket.
But in web applications there is no way to achieve this.
For a substitute,you can use ajax to post some request periodly for check is there are new messages.If ajax request find new message,then get it and show it in a pop up window. Sniff | :^)

▒〓〓〓〓〓▒▒〓▒〓▒▒
▒〓▒▒▒▒▒〓〓〓〓〓▒
▒〓▒▒▒▒▒▒〓▒〓▒▒
▒〓▒▒▒▒▒〓〓〓〓〓▒
▒〓〓〓〓〓▒▒〓▒〓▒▒

Re: .net remoting and object invocation

alimohammed19-Apr-07 21:37

alimohammed

19-Apr-07 21:37

yes thats what i want, but i cannot inject a javasript to the page to opo up a window if there is a message, i get an exception [which is shown in an alert window ] and i searched for the solution and what i got is to avoid this response.write part from ajax related part. any way to pop up a window? it can be easly done if there is no ajax code.

Re: .net remoting and object invocation

xibeifeijian20-Apr-07 5:16

xibeifeijian

20-Apr-07 5:16

Use window.setInterval to watch if there is a new message.I mean the ajax is you use a Msxml2.XmlHTTP ActiveX object to post some request and get response from it.All of these operations are in javascript.;P;P;P Don't use Ajax.dll or other dll please Big Grin | :-D

▒▒〓▒〓▒▒

▒〓〓〓〓〓▒

▒▒〓▒〓▒▒

▒〓〓〓〓〓▒

▒▒〓▒〓▒▒

Get RowIndex from GridView when Click a Button

michaelastewartmas19-Apr-07 18:38

michaelastewartmas

19-Apr-07 18:38

I have a GridView that contains a few Template Columns. In one of my Template Columns I have a Button and a TextBox. When the user Clicks the button, I want to place a value into the TextBox next to it. In order to do that, I figured I could get the RowIndex of the GridView row containing the clicked Button. Then I could find the particular TextBox Control in that row and fill that TextBox with the value I wish.

How can I get the RowIndex from a GridView when a user Clicks a Button within in….on the Server Side.

Any help would be appreciated! Thanks

Re: Get RowIndex from GridView when Click a Button

Chetan Ranpariya19-Apr-07 21:24

Chetan Ranpariya

19-Apr-07 21:24

Hi,

You can achieve this as following.

Create an event handler for a buttonclick event in the code behind.

protected void Bttn_Click(object sender, EventArgs e)
{
Button bttn = (Button)sender;
GridViewRow gr = (GridViewRow)(bttn.Parent.Parent);
Response.Write(gr.RowIndex);
}

and assign its name to the onClick event of teh button inside the TemplatedColumn in the gridview.

<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="buttn" runat="server" Text="Click" OnClick="Bttn_Click"/>
</ItemTemplate>
</asp:TemplateField>

This way you can get the RowIndex of the GridRow Containting the button and then you can find the textbox from that row using FindControl Method.

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

Export fon Asp.net 2.0

AnhTin19-Apr-07 17:32

AnhTin

19-Apr-07 17:32

Hi all
I have problem some body show for me ???
I have file demo.exe, this file use to Export for me some format file. If Export file I have to command Run “run -> cmd and cd to the forder contain file demo.exe after that writer command Ex: demo -f myshp -h myserver -u apguser -P apgpassword mygisdb
"select * from province WHERE id IN(1,2,3,4,67,34) “ so this demo exprort file for me”
But I want export with my Page (asp.net). How can I do it ???
I am developing application by asp.net (2.0)
Rose | [Rose]

Form Authenication

hahii19-Apr-07 14:28

hahii

19-Apr-07 14:28

Hi,

I have a web config file

configuration>
<system.web>
<customerrors mode="Off">
<authentication mode="Forms">
<forms name="AuthCookie" path="/"
="" loginurl="login.aspx" protection="All" timeout="30">
<credentials passwordformat="Clear">
<user name="jeff" password="test">
<user name="mike" password="test">

<authorization>
<deny users="?">

<compilation debug="true">

But in web config file you are using some data for user name and password but what I need pass a database in which I stored usernames and passwords. I have no idea how can I check weather users and passwords matches with columns UserName and Password in my table. Table name is tbUsers.

I have connection String

Re: Form Authenication

Venk25919-Apr-07 22:38

Venk259

19-Apr-07 22:38

Solution is for .net 2.0

Add these lines to the web.config

<authentication mode="Forms">
<forms name="AuthCookie" path="/" loginUrl="login.aspx" protection="All" timeout="30" defaultUrl="test2.aspx">
</forms>
</authentication>
<authorization>
<deny users="?"/>
</authorization>

the authorization is used to prevent the anonymous user. in this example my default url is text2.aspx page

In login page write the following code in the button click event
if (ValidateUser())
{
FormsAuthentication.RedirectFromLoginPage(txtuserName.Text, false);
}

ValidateUser() is user-defined function where you will write the code to check whether the password given my user matches with the password available in the database.

In other page's nothing is needing to write for validation

View State problem in pages

pothineni19-Apr-07 13:43

pothineni

19-Apr-07 13:43

Hi,

I am getting the below exception when i am trying to sort my webpage or select nextpage in my application.Here is the error details.Need help urgently.

The state information is invalid for this page and might be corrupted.
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.Web.HttpException: The state information is invalid for this page and might be corrupted.

Source Error:

[No relevant source lines]

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\va.admin\ae19a4a9\2ea09e75\App_Web_jb2ohxsj.10.cs Line: 0

Stack Trace:

[SerializationException: The constructor to deserialize an object of type 'Ext.Javascript.JSObject' was not found.]
System.Runtime.Serialization.ObjectManager.GetConstructor(Type t, Type[] ctorParams) +2320401
System.Runtime.Serialization.ObjectManager.CompleteISerializableObject(Object obj, SerializationInfo info, StreamingContext context) +99

[SerializationException: The constructor to deserialize an object of type 'Ext.Javascript.JSObject' was not found.]
System.Runtime.Serialization.ObjectManager.CompleteISerializableObject(Object obj, SerializationInfo info, StreamingContext context) +239
System.Runtime.Serialization.ObjectManager.FixupSpecialObject(ObjectHolder holder) +44
System.Runtime.Serialization.ObjectManager.DoFixups() +167
System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) +203
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) +190
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream) +12
System.Web.UI.ObjectStateFormatter.DeserializeValue(SerializerBinaryReader reader) +1713
System.Web.UI.ObjectStateFormatter.DeserializeValue(SerializerBinaryReader reader) +384
System.Web.UI.ObjectStateFormatter.DeserializeValue(SerializerBinaryReader reader) +198
System.Web.UI.ObjectStateFormatter.DeserializeValue(SerializerBinaryReader reader) +384

Srikanth Pothineni

Last Visit: 31-Dec-99 18:00 Last Update: 8-Jun-24 10:35

Refresh

ᐊ Prev 1...5058 5059 5060 506150625063 5064 5065 5066 5067 Next ᐅ

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