Search DaniWeb - idatareader

Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by gbeltrao …'s wrong at this part: [CODE] Dim xReader As Data.IDataReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) [/CODE] While I get apart of… it, : [CODE] Dim xReader As Data.IDataReader xReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) [/CODE] The debugger showed that… Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by mrjimoy_05 … As System.EventArgs) Handles login.Click Dim xReader As Data.IDataReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) If xReader.Read Then Session("… object of type 'System.Data.DataView' to type 'System.Data.IDataReader'. What's wrong with the code? I have try to… Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by gbeltrao … As System.EventArgs) Handles login.Click Dim xReader As Data.IDataReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) If xReader.Read Then Session("… object of type 'System.Data.DataView' to type 'System.Data.IDataReader'. What's wrong with the code? I have try to… Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by mrjimoy_05 …'s wrong at this part: [CODE] Dim xReader As Data.IDataReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) [/CODE] While I get apart of… it, : [CODE] Dim xReader As Data.IDataReader xReader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) [/CODE] The debugger showed that… Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by mrjimoy_05 It still doesn't work. I tried to convert the SqlDataSource to IDataReader. It's strange... Does jQuery work within the ASP.Net? Because I include jQuery on the page. I wonder if that's the problem. But after have a try, it still can't. Btw, I adopt the code from my last project. How to select n rows using IDataReader 12 Years Ago by mrjimoy_05 … with this code: [CODE]With MenuNavCatDataSource Dim xReader As Data.IDataReader = .Select(DataSourceSelectArguments.Empty) If xReader.Read Then MenuNavCat1.Text = xReader… Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by DhCoder The problem is that the SqlDataSource Select method will return a dataview if the DataSourceMode of the SqlDataSource is set to System.Web.UI.WebControls.SsqlDataSourceMode.DataSet. Try changing the SqlDataSourceMode to System.Web.UI.WebControls.SqlDataSourceMode.DataReader and that should fix your problem. Re: Unable to cast object of type 'System.Data.DataView' to type 'System.Data.IDataReader 13 Years Ago by mrjimoy_05 Hey, that's fixed the problem, @DhCoder! Thank you so much. ^^ @gbeltrao: Thanks for the help! :) Bind Data from SQL into Web Chart 12 Years Ago by violette … web chart. thank you all :) [CODE]Function GetReader() As IDataReader Dim strSQL As String strSQL = " SELECT aa.alert_id, … End Function Protected Sub Chart() Dim reader3 As IDataReader = GetReader() Dim reader4 As IDataReader = GetReader() Dim chart3 As New WebChart.ColumnChart()… create pie chart in vb.net 12 Years Ago by violette … Return command.ExecuteReader() End Function Dim reader3 As IDataReader = GetReaderYear() Dim chart3 As New WebChart.ColumnChart()…) ChartControl1.RedrawChart() reader3.Close() Dim reader4 As IDataReader = GetReaderYear() Dim chart4 As New WebChart.ColumnChart()… ASP.NET, referring to a DataSet within script 19 Years Ago by fortheloveof …a dataReader? [code] Function GetCustomerList() As System.Data.IDataReader Dim connectionString As String = "Provider=Microsoft.Jet.… = dbConnection dbConnection.Open Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection) Return dataReader… Listbox selectedItem.value cannot be retrieved 18 Years Ago by ozeona … dbApt.Fill(dsSet, "features_list") 'listbox------------------------------------------------- Dim dtr as IDataReader = cmdSelect.executeReader() linklist.DataSource = dtr linklist.DataTextField = "f_title"… Problems with connections 18 Years Ago by erikkl2000 ….Data Namespace SuperCenter.DataAccess Public Class Blinds Private _Datareader As IDataReader Private _cnn As IDbConnection Const DATABASE = "Data Source=Desktop… dynamically create check box list validation in asp.net 14 Years Ago by ashab27 …; DataSet ds; static DataTable dt; SqlDataReader readsid, readalltest, readallinterview, readallquestion; IDataReader readqus; public string qus, sid, alltest, allinterview , score; int[] allquestion… import text and numbers 13 Years Ago by mustangBE … * from [Blad1$]", connection) connection.Open() Dim dr As Data.IDataReader = Command.ExecuteReader Dim bulkCopy As SqlClient.SqlBulkCopy = New SqlClient.SqlBulkCopy… To Table or NOT to Table, That Is The Question! 11 Years Ago by bill_kearns … row3 = new TableRow(); TableCell cell3 = new TableCell(); cell3.ColumnSpan = 11; IDataReader reader = this.Database.ExecuteReader("SELECT * FROM SomeView where SomeViewID… timeout happening due to store proc 11 Years Ago by coder91 …<Summary> GetSummary(String Ref) { Database db = XDatabaseFactory.GetXDatabase(); IDataReader reader = db.ExecuteReader("storedprocName", new object[] { Ref }); LinkedList… Re: Active Reports passing variable to AR class 14 Years Ago by scottwilleke … some things for you to consider... If you set an IDataReader instance to the DataSource property of the report you don… use FetchData. AR will automatically get the fields from the IDataReader instance and allow you to use them in the report… Re: Trying to clear a list box on panel.hide 12 Years Ago by mikejs ….strConn Dim conn As New SqlConnection(connString) Dim reader As IDataReader Dim cmd As New SqlCommand Dim tempList As New BindingList….strConn Dim conn As New SqlConnection(connString) Dim reader As IDataReader Dim cmd As New SqlCommand Dim tempList As New BindingList… Re: C# Generics HELP 12 Years Ago by thines01 …. As a matter of fact, if you study how the IDataReader is created, you have some syntax that has to be…<T, U, V> where U : IDbCommand where V : IDataReader { private string _strSQL { get; set; } private OracleCommand _cmd { get; set… Re: C# Generics HELP 12 Years Ago by six_sic6 …. As a matter of fact, if you study how the IDataReader is created, you have some syntax that has to be…<T, U, V> where U : IDbCommand where V : IDataReader { private string _strSQL { get; set; } private OracleCommand _cmd { get; set… Re: Import/Export Excel 16 Years Ago by TaoistTotty … * from [Cornwall$]", connection) connection.Open() Dim dr As Data.IDataReader = Command.ExecuteReader Dim bulkCopy As SqlClient.SqlBulkCopy = New SqlClient.SqlBulkCopy… Re: AutoCompleteCustomSource 15 Years Ago by s3r4ph1m … this how i fill the autocompletecustomsource Dim acTipeMobil As Data.IDataReader = Me.MasterTipeMobilTableAdapter.GetData.CreateDataReader Do While acTipeMobil.Read txtNamaTipe.AutoCompleteCustomSource… Re: how can i create dynamicaly checkbox or checkboxlist in asp.net 14 Years Ago by ashab27 … con; SqlDataAdapter da; SqlCommand cmd; DataSet ds; static DataTable dt; IDataReader readqus; public string qus; static int count = 0; protected void… Re: vb.net listview connect to access database 13 Years Ago by The Bug … ORDER BY Title", _ con) Dim data_reader As Data.IDataReader = cmd.ExecuteReader() Do While data_reader.Read() Dim new_item As New… Re: can you fill a list box with data from two sql tables? 12 Years Ago by mikejs ….strConn Dim conn As New SqlConnection(connString) Dim reader As IDataReader Dim cmd As New SqlCommand cmd.CommandText = "SELECT t_id… Re: How to handle a large dictionary file, better ways? 12 Years Ago by thines01 … space here, ignore it strDescription = arr_strData[3].Trim(); } public CChineseToGerman(IDataReader rdr) { strChineseChars = rdr["CHINESE_CHARS"].ToString().Trim(); strStuffInBrackets = rdr… Re: Accessing database fields .NET 12 Years Ago by thines01 Have you looked into the IDataReader types, such as OdbcDataReader? Re: Accessing database fields .NET 12 Years Ago by niggz [QUOTE=thines01;1711194]Have you looked into the IDataReader types, such as OdbcDataReader?[/QUOTE] Okay, I wrote some code, … Re: Accessing database fields .NET 12 Years Ago by thines01 Another technique I use is to let the constructor of the object take the entire IDataReader and parse into its own fields. Check out [URL="http://www.daniweb.com/software-development/csharp/threads/397785/1706682#post1706682"]this posting[/URL].