Invalid cast from System.String to System.Byte[ ] [modified] - ASP.NET Discussion Boards

Hi larree11
You can also place the dropdownlist inside the UpdatePanel. You have one updatepanel which contains a few panels. So whenever panel is drag and dropped you want to update the dropdownlist, so better, you place the dropdownlist box inside the updatepanel and in the drag and drop features update the dropdownlist values.

I think this will help you to resolve your problem

Hi Venk259,

First thanks for the reply... I did try this method before but the dropdownlist did not reload with fresh data whenever i drag and drop a panel.

I have set the dropdownlist autopostback to true but its not refreshing. Any idea why is it like tat? by the way the web service called by the drag and drop is done on client side by calling the webservice using javascript. Any work around?

Cheers

CAN I HELP ME? I NEED SOURCE FORUM ASP.NET WITH C#.

GOOGLE IT !!!!

There's at least one forum here on CP in C#, I thought.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

c#:
THE dataset or (datatable) have much items.
when I click the button(button.text=next) ,how can I get the next item from the dataset or(datatalbe)?
please help me!

By the way :follow method could not get the right answer,allways get the inital value:
private void method1(object sender, EventArgs e)
{
i=(i+1);

}

Use ViewState to hold the DataSet and the Increment counter.

Regards,
Arun Kumar.A

Please don't cross post. Answering in the C# forum, I assumed it was a winforms app.

Do you want to do a postback to get a specific item ? why not write the SQL to return only that item, and store the index in viewstate ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Hi, I get the following error message when I run my application in the browser.

"Invalid cast from System.String to System.Byte[ ]"

I have changed cmdInsert.Parameters.Add("@docContent",OdbcType.Text) to

cmdInsert.Parameters.Add("@docContent",OdbcType.Binary)

like someone had suggested, but it still does not work. I have checked other variables for type mismatch but didn't find any. If you see anything at all wrong with my code please point it out. I would really be grateful if you can show me what is causing VS2003 to throw the exception. Thank you in advance for your help.

The following is my code to help you better understand my situation.

Imports System.IO
Imports System.Data.Odbc
Public Class Upload
    Inherits System.Web.UI.Page

 Private Sub Submit1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.Click
        Dim strFileExtension As String
        Dim StrFileType As String
        Dim intFileLen As Integer
        Dim objStream As Stream
        Dim strInsert As String
        Dim myConnection As OdbcConnection
        Dim cmdInsert As OdbcCommand


        If Not IsNothing(txtFileContents.PostedFile) Then
            'Determines File Type
            strFileExtension = Right(txtFileContents.PostedFile.FileName, 4)
            Select Case strFileExtension.ToLower
                Case ".doc"
                    StrFileType = "doc"
                Case ".ppt"
                    StrFileType = "ppt"
                Case ".htm"
                    StrFileType = "htm"
                Case ".html"
                    StrFileType = "html"
                Case ".txt"
                    StrFileType = "txt"
                Case Else
                    StrFileType = "jpg"
            End Select
            'Grab the content of uploaded file
            intFileLen = txtFileContents.PostedFile.ContentLength
            Dim arrFile(intFileLen) As Byte
            objStream = txtFileContents.PostedFile.InputStream
            objStream.Read(arrFile, 0, intFileLen)


            'Add UpLoaded file to a database
            myConnection = New OdbcConnection("Provider=MySQLProv; Data Source=Data;User Id=myID;Password=myPWD")
            strInsert = "INSERT into QUsers (docTitle,docContent,docDate,docType) values (?,?,?,?,?)"
            cmdInsert = new odbcCommand(strInsert,myConnection)
            
            cmdInsert.Parameters.Add("@docID",OdbcType.int,30)           
            cmdInsert.Parameters["@docID"].Values =""

            cmdInsert.Parameters.Add("@docDate", OdbcType.TimeStame,14)             
            cmdInsert.Parameters["@docDate"].Values = DateTime.Now.ToShortDateString()

            cmdInsert.Parameters.Add("@docTitle", OdbcType.Varchar,30  )
            cmdInsert.Parameters["@docTitle"].Values = txtFileTitle.Text       
            
            cmdInsert.Parameters.Add("@docType", OdbcType.Varchar,30)
            cmdInsert.Parameters["@docType"].Values =StrFileType

            cmdInsert.Parameters.Add("@docContent",OdbcType.Binary)           
            cmdInsert.Parameters["@docContent"].Values =arrFile
            
            myConnection.Open()
            cmdInsert.ExecuteNonQuery()
            myConnection.Close()
        End If

    End Sub
End Class

-- modified at 23:26 Thursday 7th June, 2007

Problem Solved.

I am trying to insert an record in table but it gives me following error. What does it means

Cannot insert explicit value for identity column in table 'tb' when IDENTITY_INSERT is set to OFF.

seema

Hey this is not the right forum to ask this question.

pls move this question to sql/ado/ado.net forum.

And as you have stated above the problem is occurred because of the following. So

@@IDENTITY contains the last identity value generated by your statement. If you insert into a table that runs a trigger and generates another identity value, you will get back the last value generated in any table. To solve this problem you'll need to use SCOPE_IDENTITY to return the inserted value. Every procedure, trigger, function and batch is it's own scope. SCOPE_IDENTITY shows the most recently inserted IDENTITY in the current scope (which ignores any triggers that might fire).

If you want to insert a value into an identity column you can use the SET IDENTITY_INSERT statement

SET IDENTITY_INSERT Yaks ON
Insert Yaks (YakID, YakName) Values(1, 'Mac the Yak')
SET IDENTITY_INSERT Yaks OFF
select * from yaks

You can only turn on IDENTITY_INSERT for one table per session so it's always a good idea to turn it off when you're done with it.

Regards,

Satips. Rose | [Rose]

hi every body
i want a free .net 2.0 documentation tool

thanks in advance

haitham

Search for "Sandcastle"

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Hi All,

I have a table in my database. There is one Image files> How can I retrive the Image files from database and show it in my web page.

seema

There is a good tutorial for what you're trying to do by Faisal Khan. It starts with uploading images to a database and ends with displaying images from a database. Hope this helps, just go to the site below.
http://www.stardeveloper.com/articles/display.html?article=2003040501&page=1

-- modified at 23:18 Thursday 7th June, 2007

I got the following error message when I run my web method

There is no source code avaliable for the current location..

seema

That's a debugging error. When do you get it ? Is it all you get ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Not sure if this is the correct board, but I'll try here.

I am trying to add a custom aspx page to my Sharepoint site. Here are the steps I've taken:

- Published my site with VS 2005
- Created a blank aspx page with Sharepoint Designer
- Copied the published aspx page into the newly created one in Designer
- Added the dll to my Sharepoint bin folder
- Added the following line to my web.config:

<br />
<SafeControl Assembly="App_Web_mzeq_hmf" Namespace="_Default" TypeName="*" Safe="True" /><br />

This is apparently the only way to have custom aspx pages in WSS 3.0/MOSS 2007, which is annoying.

When I try to run the page I get this error:

An error occurred during the processing of /contact.aspx. Value cannot be null.
Parameter name: key

I have no idea what that means. I thought it might have to do with not having a PublicToken parameter, but that was just a blind stab at what that might mean.

Any help on this would be great!

Thank you!

Hello.

When I add a new record in my gridview, I would like to select directly that new row instead of returning on the first row.

I'm using Primarykey in the gridview, and the gridview paging.

Is it possible to do that ?

Thanks a lot for your help.

Pat3d

Hi All,

I am writing internet application proxy for which i have to convert HttpContext.Current.Request object to WebRequest object such that i pass on all the information from Request to WebRequest.

Any ideas?

Thanks,
Amit

You can't convert them, they are two seperate objects for different purposes. What are you trying to accomplish?

only two letters away from being an asset

I am trying to write internet application which will be hosted by me and used by client but application need to access the database which is exposed as webservice in intranet.

Now, i was thinking of hosting a application proxy on client side which will access webservice in intranet environment and then call my application in internet. For an example say client need access Default.aspx page, it will go the application proxy and depending on which page i am trying to access application proxy will get the information from client database and then it will reconstruct the webrequest and send the request to my application.

Thats what i am trying to achieve. Let me know if i can achieve above funtionality some other way.

Thanks,
Amit

Let me know when you work this out. Roll eyes | :rolleyes:

only two letters away from being an asset

Hi. I've created a SSRS chart report that I'd like to display in my .net web application via web services. I've found a few examples that work with SSRS 2000 but not 05. I've managed to get the report to write to a pdf file but I'm unable display it directly in a browser. My code is below, any help will be greatly appreciated. Also if anyone knows where I can review some SSRS 2005 examples of displaying reports on a web page, that would be great! Thanks!

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim rs As RSwebReference.ReportingService2005 = New RSwebReference.ReportingService2005()
Dim rsExec As RSwebReference.ReportExecutionService = New RSwebReference.ReportExecutionService()

'Authenticate to the Web service using Windows credentials
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials

'Assign the URL of the Web service
rs.Url = "http://localhost/REPORTSERVER$SQL2005/ReportService2005.asmx"
rsExec.Url = "http://localhost/REPORTSERVER$SQL2005/ReportExecution2005.asmx"

Dim results As Byte() = Nothing
Dim historyID As String = Nothing
Dim format As String = "pdf"
Dim encoding As String
Dim mimeType As String
Dim extension As String
Dim warnings() As RSwebReference.Warning
Dim streamIDs() As String = Nothing
Dim fileName As String = "C:\samplereport.pdf"
Dim deviceInfo As String = Nothing

'Dim deviceInfo As String = _
' "<deviceinfo>" + _
' "<toolbar>False" + _
' "<parameters>False" + _
' "<docmap>True" + _
' "<zoom>100" + _
' ""

'Define variables needed for GetParameters() method
Dim _reportName As String = "/Test/AuditVendorStatus"
Dim _historyID As String = Nothing
Dim _forRendering As Boolean = False
Dim _values As RSwebReference.ParameterValue() = Nothing
Dim _credentials As RSwebReference.DataSourceCredentials() = Nothing
Dim _parameters As RSwebReference.ReportParameter() = Nothing

Try
'Get if any parameters needed.
'_parameters = rs.GetReportParameters(_reportName, _historyID, _forRendering, _values, _credentials)

'Load the selected report.
Dim ei As RSwebReference.ExecutionInfo = rsExec.LoadReport(_reportName, historyID)

'---------------------------------------------------------
'Set the parameters for the report needed.
'create an array of the values for the report parameters
'Dim parameters(1) As RSwebReference.ParameterValue
'Dim paramValue As RSwebReference.ParameterValue

'paramValue = New RSwebReference.ParameterValue
'paramValue.Name = "StartDate"
'paramValue.Value = ""
'parameters(0) = paramValue

'paramValue = New RSwebReference.ParameterValue
'paramValue.Name = "EndDate"
'paramValue.Value = ""
'parameters(1) = paramValue

'rsExec.SetExecutionParameters(parameters, "en-us")
'---------------------------------------------------------
results = rsExec.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs)

'Create a file stream and write the report to it
Dim stream As System.IO.FileStream = System.IO.File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)

Catch ex As Exception
'TODO
End Try
End Sub

hi i hav deploped url in asp.net..
how to run the url in linux...there is the way...?