Re: Creating folder on Client's computer using ASP .Net 2.0 - ASP.NET Discussion Boards

Error While Reading image From Database in Asp.net

nabeelkhan8-Aug-06 0:26

8-Aug-06 0:26

Hi.
i have a prblm while i try to read the image from sqlserverdatabase 2000 and showing in asp.net datagrid,on backend i m using vb.net.the error in "invalid Casting" tell me how can read the image from database and show in my asp.net datagrid.
this is my code that i use to pull the image from sqldatabase.
public funciton bindata()
Dim connstring As String = ConfigurationSettings.AppSettings.Item("DBSettingsServer")
Dim con As SqlConnection
Try
con = New SqlConnection(connstring)
con.Open()
Dim cmd As New SqlCommand
cmd.Connection = con
Dim dst As New DataSet
Dim dr As SqlDataReader
'cmd.CommandText = "Select * From tblNews where " & Request.QueryString("id")
'cmd.CommandText = "Insert into tblnews (NewsID,NewsDesc, NewsImg,NewsStatus) values (@NewsID,@NewsDesc, @NewsImg,@NewsStatus)"
' cmd.CommandText = "Select * from tblnews where NewsID = " & Request.QueryString("id")
cmd.CommandText = "Select * from tblnews where NewsID = 000001 "
dr = cmd.ExecuteReader
If dr.Read() Then
Dim bindata() As Byte = dr.GetValue(3)
Response.BinaryWrite(bindata)
End If
con.Close()
Catch ex As Exception
'Response.Write(ex.ToString)
con.Close()
Throw ex
Finally
con.Close()
End Try
End Function
tell me how can i read the image from sqlsever database
or tell me where i m wrong

Re: Error While Reading image From Database in Asp.net

_AK_8-Aug-06 1:41

_AK_

8-Aug-06 1:41

Here you can get help for image storing and retrieving using sql server 2000.

http://www.codeproject.com/cs/database/ImageSaveInDataBase.asp

Best Regards,
Apurva Kaushal

Getting data from an SQL database query into an XMLDocument ???

Red_Wizard_Shot_The_Food8-Aug-06 0:01

Red_Wizard_Shot_The_Food

8-Aug-06 0:01

I'm having a bit of a reocuring problem that I just cant seem to get my head round.

I want the output of an SQL query to be placed into an XMLDocument (for use as a source for an ASP.NET XML tool).

At the moment my SQL query outputs using: FOR XML AUTO, ELEMENTS

But I dont really have any experiance using the XMLDocument and was wondering how I should go about getting the output from the SQL query into the XMLDocument??
Is there a simple way of just "shoving" it in there or is it an intricate element by element process ?

Thanks.

CommandField Button

Kamal.Afridi7-Aug-06 23:24

Kamal.Afridi

7-Aug-06 23:24

I have three Select buttons in GridView Control.

Now how can i capture which button is clicked.

If I use TemplateColumn (ImageControl) CommandName Property = "Add User" then i m unable to get

SelectedIndex of GridView Control.

Any idea Please......

Know Yourself Then Grow Yourself.

Re: CommandField Button

Paddy Boyd8-Aug-06 0:59

Paddy Boyd

8-Aug-06 0:59

If you are in the itemCommand event of the gridView, then you can check for the correct item command like so:

if (e.ItemCommand == "Add User")
{
  //Do stuff
}

and then the current row should be e.Item.

Re: CommandField Button

Kamal.Afridi10-Aug-06 22:26

Kamal.Afridi

10-Aug-06 22:26

Thanks

Know Yourself Then Grow Yourself.

Creating folder on Client's computer using ASP .Net 2.0

arvindbhateja7-Aug-06 22:23

arvindbhateja

7-Aug-06 22:23

Hi,
Actually I want to create a folder on client's computer and save an Excel file into that folder when the user clicks on save button. Is it possible to achieve this using ASP .Net 2.0

Right now when I create a folder at location "C:\folder1", it creates a folder on the Web server.

Plz help me if u can... OMG | :OMG:

Re: Creating folder on Client's computer using ASP .Net 2.0

Red_Wizard_Shot_The_Food8-Aug-06 0:09

Red_Wizard_Shot_The_Food

8-Aug-06 0:09

As far as I am aware ASP.NET is server side only meaning you cant do this kind of thing on a clients computer by ASP.NET alone... imagine the security problems if you could!

You may need to install software on the cleints computer and launch it via ASP.NET (I think there is a tutorial on Codeproject for doing this) or use somthing like JavaScript (though not sure even that is possible.. becuase, again, its a big security issue)

Re: Creating folder on Client's computer using ASP .Net 2.0

kumar sanjay9-Jan-09 23:27

kumar sanjay

9-Jan-09 23:27

i also want to create folder in client computer. how i can create? about which tutorial of code proj. u are telling?
pls help me.

sanjay s/w ltd

Re: Creating folder on Client's computer using ASP .Net 2.0

Paddy Boyd8-Aug-06 1:05

Paddy Boyd

8-Aug-06 1:05

red wizard is right. You can't do this just with ASP.net. Your best bet would be to just let the user download the file and save it wherever they like.

how to open a file

nannapanenikamalnath7-Aug-06 22:03

nannapanenikamalnath

7-Aug-06 22:03

have a webform and I want to create a hyperlink to a text file, so that it
opens on internet explorer in a new window.
I have added the following
testhyperlink

Now when I click on the hyperlink, nothing is happening. No error.
when I open a browser and type file:///D:/Test/Test.txt, the file is opening.
please help me.

kamalnath

Re: how to open a file

coolestCoder7-Aug-06 22:18

coolestCoder

7-Aug-06 22:18

Hi kamalnath,
I think you are using the physical path of the file. Try changing the URL to ---
http://localhost/<ur web="" app="" name="">/Test.txt

Hope this works !

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

Re: how to open a file

nannapanenikamalnath7-Aug-06 22:30

nannapanenikamalnath

7-Aug-06 22:30

hi anant
file is in d drive .then how to get that file

kamalnath

Re: how to open a file

Iamawanderer8-Aug-06 7:12

Iamawanderer

8-Aug-06 7:12

I think you should use method PathMap to convert the physical address to URL.
Good luck!

galaxy

problem When displaying barcode

meetbinu20037-Aug-06 21:59

meetbinu2003

7-Aug-06 21:59

I have a web application in ASp.net . I want to display barcode at client browser without installing barcode font at client side.

Pls Reply

Thanks in Advance

Urgent

Re: problem When displaying barcode

dapoussin9-Aug-06 0:59

dapoussin

9-Aug-06 0:59

I've done that with a Web Service returning a byte[]. Then I create an image dynamically with this data.
More info here[^]

Hope it helps.
Cheers
Laurent

PLz help me it is urgent

Prasad.garlapati7-Aug-06 20:56

Prasad.garlapati

7-Aug-06 20:56

Hai i am new to asp.net i have small problem , i was useing asp.net2003 and sqlserver as backend
problem is :
i have login page with uid and password (textboxes)
when user enter valid user& password user enter into next page
table contain uid,password,username,usercode
userid=010101 password =010101 username='ramesh' usercode=01
userid like =010101 based on that first two digits i have diaply username into second page
how to use substring query in that
plz help me it is urgent

prasad.g

Re: PLz help me it is urgent

_AK_7-Aug-06 21:01

_AK_

7-Aug-06 21:01

Do you want to get the first two characters of the strng?
if so then you can use like this:
userid.Substring(0,2);

Best Regards,
Apurva Kaushal

Re: PLz help me it is urgent

albCode7-Aug-06 21:26

albCode

7-Aug-06 21:26

Prasad.garlapati wrote:
based on that first two digits i have diaply username

Prasad.garlapati wrote:
,username,usercode

username = username.Substring(0,2);

if you want to pass in another page u acn use sessions ,querystring,etc

Example:

//in  ur  first aspx.cs page<br />
<br />
Session["twodigits"] = username.ToString();<br />
<br />
//in  ur  second aspx.cs page<br />
<br />
<code>string twodigirs = Session["twodigits"].ToString();

Re: PLz help me it is urgent

PlayByTheRules8-Aug-06 1:42

PlayByTheRules

8-Aug-06 1:42

This is a useless subject line.

Everyone who starts a thread on this forum is looking for help in some form or another.

Saying that it is "urgent" is pointless too. We are not paid to give you support. You'll get help if someone knows the answer and is willing to help and for no other reason. If it really is urgent then I suggest that you pay for support.

Invalid_Viewstate_Client_Disconnected

Praveen_S7-Aug-06 20:52

Praveen_S

7-Aug-06 20:52

I just deployed a new web and my global error handler is sending me back of
ton of nessages that say "Invalid_Viewstate_Client_Disconnected" complete
with a complete copy of the viewstate - very helpful I am sure. I can't seem
to duplicate the problem. What's up?

Error Msg :

Invalid_Viewstate_Client_Disconnected Client IP: 10.6.174.41 Port:
1639 User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
..NET CLR 1.0.3705; .NET CLR 1.1.4322) ViewState:

please help

Praveen

Re: Invalid_Viewstate_Client_Disconnected

_AK_7-Aug-06 20:56

_AK_

7-Aug-06 20:56

May be the problem is because all the contents of viewstate from client side are not coming to server side. Are all the settings correct in IIS?

Best Regards,
Apurva Kaushal

Re: Invalid_Viewstate_Client_Disconnected

Bimal Kothari2-Oct-08 3:56

Bimal Kothari

2-Oct-08 3:56

There are several conditions that may cause this issue. Each known condition is presented with a short explanation and a possible workaround.

1. Application Pool Recycling
2. Server Farms or Server Clusters
3. Form Posts
4. Proxy servers and Virus Scanners

Background:
Viewstate represents the state of the page when it was last processed on the server. The contents of the page are stored in a container and moved to and from the server on each request. By default, ASP.NET validates the contents of viewstate to ensure that it has not been tampered. If this validation test fails, an invalid viewstate exception is thrown. Some known issues that cause this test to fail are listed below.

Application Pool Recycling:
IIS 6 will periodically recycle the application pool to maintain the health of the application pool. At the instance when the application pool is being recycled, browser requests may sometimes result in an invalid viewstate error. The fix in this case is to adjust the settings on the application pools so that recycling is less likely to occur at peak periods. This issue represents a bug since the application pool is supposed to gracefully handle this condition.

Server Farms or Server Clusters:
Applications running in a server cluster must have all the machineKey configurations set to the same validationKey. The default autogenerate key cannot be used in a cluster environment. The registry keys responsible for autogeneration are listed here:

HKEY_LOCAL_MACHINE\Software\Microsoft\ASP.NET
HKEY_CURRENT_USER\Software\Microsoft\ASP.NET

When the machineKey is set to AutoGenerate, the key information is stored in the HKEY_CURRENT_USER hive for the account running the process. For W2k3 servers, this is the Network Service account. Otherwise, the account is ASP.NET machine account. When the process launches, ASP.NET will use the HKEY_CURRENT_USER registry key if it is available. If this key is not available, the
HKEY_LOCAL_MACHINE key will be used. If neither registry key exists, the process creates the key in the HKEY_LOCAL_MACHINE hive. If these conditions fail, the process creates a brand new set of keys.

When the application pool is running under a user account, the above keys are not generated leading to an intermittent invalid viewstate error.

The workaround is to use a specific key in the machine.config to prevent automatic key generation on each process start. The key must be exactly 128 bits made up of random characters and inserted into the configuration file on each webserver experiencing the problem.

Form Posts:
Viewstate can only be posted back to the same page. Attempting to post an aspx form to another page will fail with a viewstate invalid exception. This behavior is by design.

One other remedy involves disabling the Machine Authentication Check. Unless, you implement a back up authentication mechanism, you should refrain from this approach. Machine Authentication Checks are important in reducing the attack surface of ASP.NET applications.

Proxy servers and Virus Scanners:
A firewall and/or antivirus software can tamper with the viewstate resulting in an invalid viewstate exception being thrown.

Thanks,

Bimal Kothari

bimal.kothari@gmail.com

Read XML

Vipin Venugopal7-Aug-06 20:35

Vipin Venugopal

7-Aug-06 20:35

can anyone help me to read the nodes and values of a XML to a multidimensional array.there is only single parent node for my xml page.

Vipin

Re: Read XML [modified]

coolestCoder7-Aug-06 22:15

coolestCoder

7-Aug-06 22:15

Hi Vipin,
You can use a For each statement to read all the nodes in an XmlDocument. the XmlDocument will contain the xml data from a file, i guess. You can do something like this-

XmlDocument xmlDoc = new XmlDocument();
int i=0;
string[] arrString = new string[20];
XmlNode tempNode, xn;

xmlDoc.Load("c:\sample.xml");
xn = doc.DocumentElement;
ForEach(tempNode In xn.ChildNodes)
arrString[i] = tempNode.InnerText;
i++;
Next
doc.Save("c:\sample.xml");

Hope this helps. The code i wrote is not compiled. tell me if gives some error, i will correct it.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

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