.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Problem with XML from Dataset

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :ASP.Net

I am having difficulties working with the xml from a dataset. My code throws an exception when trying to load and xmldocument with the xml from the dataset. Below is my code:



FileStream stream = File.Open("c:\\rma.xls", FileMode.Open, FileAccess

View Complete Post

More Related Resource Links

problem filling dataset


Hey guys,

Am using a dataset to get different data from a table depending on options selected. Sometimes this means the database returns no matching rows. However with this particular case it seems if there are no rows to put into the dataset I get an "Arithmetic overflow error converting nvarchar to data type numeric." error.

Code looks like this :

Dim saleSelect As String = "SELECT * FROM [sales] WHERE ([affected] LIKE '%' + @affected + '%') AND ([minVal] < @price) AND ([active] = @active)"
Dim saleCmd As SqlDataAdapter = New SqlDataAdapter(saleSelect, sqlConn)
saleCmd.SelectCommand.Parameters.AddWithValue("@affected", "," & id & ":")
saleCmd.SelectCommand.Parameters.AddWithValue("@price", price)
saleCmd.SelectCommand.Parameters.AddWithValue("@active", "True")
Dim saleDs As DataSet = New DataSet()

saleCmd.Fill(saleDs, "saleTbl") 'Error occurs here

The error occurs when SqlDataAdapter attemps to fill the Dataset.

All fields in the table are nvarchar except ofr [id] which is 'int' and [active] which is 'bit'

Any ideas?

problem in Transferring a large dataset to remote machine by using the NetTcpBinding

i am developing an WCF application, in which i have to transfer a large dataset to the remote machine!! for that im using nettcpbinding in WCF but i got this exception ' The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '10:29:59.4140000'. at my sender side.   Sender/Client side code   // Object for sending to remote client using (_dpParameters = new DPParameters()) { _dpParameters.SequenceFieldName = "Sequence"; _dpParameters.Size = 10; _dpParameters.SubjectsForFiles = "S,Y,T"; _dpParameters.SubjectNames.Equals(SubjectNames); _dpParameters.FilePath = " E:\\Source\\Phospho.xml"; // this dataset can be in GBs but for testing me using jst 6.78mb DataSet ds = new DataSet(); ds.ReadXml(_dpParameters.FilePath); _dpParameters.Usd = ds.Tables[0]; } /// This is the binding settings NetTcpBinding tcpBinding = new NetTcpBinding(); tcpBinding.ReceiveTimeout = new TimeSpan(10, 30, 00); tcpBinding.SendTimeout = new TimeSpan(10, 30, 00); tcpBinding.MaxBufferSize.Equals(67108864); tcpBinding.MaxBufferPoolSize.Equals(67108864); tcpBinding.MaxReceivedMessageSize.E

Facing problem in Passing Multiple values to a DataSet


Hi all,


I have a report parameter(@rptParameter), which allows only single value.

The Main Data Set query :

Select * From XXXX 

Where Title like @rptParameter+'%'

This is how i'm handling till now.

but now i need to allow users to select multiple values at report param,

and need to generate report based on that.


I'm totally lost, i don't have any idea that hw can i use "like" and "in" at a time in my Data set.


Please help me out.


If you not clear with question, let me know i will give you some example.


Thanks in Advance.


Dataset Connection string problem


In my webconfig and in the web pages I have the connection string. 

connectionString="server=(local);database=Kansascity;trusted_connection=true" and this works fine

When as during creating a dataset to use what is in webconfig I choose yes. However the connection string it puts on the dataset is

connectionString="Data Source=(local);Initial Catalog=Kansascity;Integrated Security=True"

This shows up as a problem on the webservice using the dataset which gives a login error.  I can seem to figure out why its making this connection string or how to change it. Also don't know why it isn't working when the test in query builder are fine.

Strongly Typed Dataset and Gridview: Problem


I am trying to populate a gridview using two tables. I also have a strongly typed dataset and used the method on this page:


the problem is that, when i try to use two table the gridview does show up (I checked through debugging that the datatable comes back as empty).

I will be grateful for ur assistance or thoughts. Thank you

Report Server Project DataSet creation problem


I am getting an error while trying to create a dataset in SSRS.


"An error occurred while loading the query designer 'OLEDB-MD'. Only text based query designer will be loaded."


The "Query Designer" command is getting disabled.


FYI: I was able to create successful connection while created the shared DataSource to the AS db, which I used to create my dataset.


Please guide me in getting through this error..


Thanks in advance


Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

Hi friend,

you can use this thread to solving problem and solutions.

Introducing ADO.NET and the Typed DataSet

In reviewing the applications it seemed everything they were doing involved database reads, writes, and manipulation. The development staff had been reviewing the articles and code samples for ADO.NET. They had spent many years refining their existing ADO based infrastructure and perfecting their use of ADO

Create and Use a Typed DataSet by Using Visual C# .NET

This article shows you how to create and use a typed DataSet in a small Web application. Typed DataSets, which inherit from the DataSet class, create first-class members of a DataSet's DataTables and DataColumns, yielding the many benefits that come with the use of strong typing.

Get Top 1 Record from Dataset

Many of them in need of getting the Top 1 or Top 10 records from a Dataset without going to SQL query. It is possible to do from Code Behind. I have given the code below,
The below code is to get single record from a Dataset. Also I have given for getting 8 records at Green Color.

Returning a DataSet From a Web Services: Step-by-Step

This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.


This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.

Virtual Path Problem


 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-


Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"

        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http

Strange Photo upload problem


I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

thaks for your help in advance

ASP.Net Caching problem ??


I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!

Could some one tell me whats the Problem with this String Manipulation ??? C#.net



I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend