How can you load a List<> object from a Datareader?I tried to do it but for some reason it is not working. Below is the code that I tried to use:
using System;
using System.Data;
using System.Configuration;
[code]...
how to convert sqldatareader to List
View 2 RepliesI'm having difficulties getting XslCompiledTransform.Load method to take a server path. I googled around and found that I need to do something like:
xslt.Load(System.Web.HttpContext.Server.MapPath(xslPath), XsltSettings.Default, new XmlUrlResolver());
But it returned an error saying HttpContext is null.
I also tried:
xslt.Load(System.Web.HttpServerUtility.MapPath(xslPath), XsltSettings.Default, new XmlUrlResolver());
That also returned an error saying an object reference is required for the non-static field, method, or property 'System.Web.HttpServerUtility.MapPath(string)'
The xslPath has a path that points to a xsl file in Sharepoint Web. I just want XslCompiledTransform to load the xsl file with the server path. Is it possible? If so, what is the proper way or hackish way of doing it?
EDIT: I have access to a SPWeb object which contains the path to the xsl file. However when I check the ServerRelativeUrl, it just says "/MyTree/xsl.xsl". The problem here is I couldn't get the XslCompiledTransform.Load to load the file from SharePoint list.
my page contain a dropdownlist which binding many list of data with no categories. While refresh in one update panel is very slow.
View 4 RepliesI'm trying to set the selected value of a ddl during page load ie. before databind.
This causes "selected value does not exist" errors. So I force a databind, and add a new element if it does not exist in the data source.
However it looks like when the databind is performed later in the page lifecycle that my added element(s) are removed/overwritten.
Am I setting the values in the wrong part of the life cycle?
I'm really new to MVC (just started a few weeks ago) and new to Ajax (never looked at it before today). I need some design / technical advice concerning Ajax, MVC, loading partial views, and posting / getting from a view. What I'd like to do it load a partial view that takes in a list of objects that have been queried from my db into an details-type view. The details view already has some other content that has been handeled and loaded from information pulled from my database and setup through some actions. It is strongly types to a model.
Below is the partial view I've created thus far:
[Code]....
And here's a portion of the Details page:
[Code]....
I'm not sure what to do for the Ajax.ActionLink. I'd like for a use to be able to type into the text box on it's left and hit "Add" (the Ajax link) and have the application add the content in the text box to the database. Should it be something else? An <input>? The Controller code piece is below:
[Code]....
So it should be adding the member into the repo / db and then reload the contents of the partialview. Instead, it's reloading the whole page and not just the partial view. (the url is changing from /project/details/5 to /project/membersection/).
i have radio button list ion my web page
<asp:radiobuttonlist id="radio1" RepeatDirection="horizontal" runat="server" OnSelectedIndexChanged="radio1_SelectedIndexChanged">
<asp:listitem id="option2" runat="server" value="CarrierCode" Selected=True/>
<asp:listitem id="option1" runat="server" value="ConsolidationName" />
</asp:radiobuttonlist>
what i am trying to do is load the dropdwon list cboDealers if the first radio buton is selected and load cbocarriercode if the second one is selected
I found that I don't need to use jQuery or AjaxToolKit to use a textbox with autocomplete instead using the AutoCompleteType() class.However, base in the documentation it says the autocomplete will just trigger after the button was click at first instance, with that
description looks like what I want to do will not be applicable.Is it possible to populate the textbox with a list of strings in page load? so that if I type in a textbox it will give me a complete list of strings already.
i would like to know how to load the dropdown list in the Gridview edit with the dropdown list values from the database
View 3 RepliesI have a page with 14 dropdown lists. In the first page load (ie. not isPostback) I set the selectedIndex of the dropdownlists individually but I find that they are all set to the value I use for the last dropdownlist set. Here is the code
comboFirstJudge1.SelectedIndex = 0
comboFirstJudge2.SelectedIndex = 0
<so on for all the dropdown lists until the last one>
comboFirstJudge14.SelectedIndex = 4
The result is that all dropdown lists have SelectedIndex = 4. If I run the same code on a postback it works just fine (the first lists have SelectedIndex = 0 and the last one = 4).
I used to use datasets instead of sqldatareaders and I used to be able to do something like this
If dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
This obviously doesn't work with sqldatareaders.I have code to see if the SQLDatareader has any rows but was wondering if there was a way to get the value of each rowI'm guessing this is possible and i've had a look around but can't seem to find anything
Dim conn As SqlConnection = New SqlConnection("server='h'; user id='w'; password='w'; database='w'; pooling='false'")
conn.Open()
Dim query As New SqlCommand("DECLARE @investor varchar(10), @sql varchar(1000) Select @investor = 69836 select @sql = 'SELECT * FROM OPENQUERY(db,''SELECT * FROM table WHERE investor = ''''' + @investor + ''''''')' EXEC(@sql)", conn)
Dim oDR As SqlDataReader = query.ExecuteReader()
If oDR.HasRows or dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
That is the code I have at the moment which obviously doesn't work
In normal way of write the code as follows in DAL.
DataSet ds=db.executedataset();
IEnumerable<datarow>= ds.tables[0].asEnumerable();
For better performance can use datareader in Linq instead of DataSet
why the following code doesn't work?
internal static string[] GetToolsForRole(string selectedRole) {
string[] tempStr;
ArrayList myAL = new ArrayList();
[code]...
I have a dropdown control that has a list of names in it called PlayerNameDropDownList_Insert and a textBox called PlayerName.
When I select a name from the dropdown it populates the textbox correctly.However, when the page opens the first name is selected in the dropdown but nothing in the textbox. How can I get the textbox to populate with the value of the dropdown at pageload?
[Code]....
I've noticed that page load time increases dramatically as you load up a ddlistbox with items. 10,000 or so results in a pretty much unacceptable wait time for my setup. The dropdown I'm trying to load is Airports - like all of them. What are some alternative UI solutions that give the user the ability to easily select any (literally) airport, but without a ginormous page loading time? (Currently the dd is keyed to the airport's 3 letter code, so it's convenient for the prepared user to just type the 3-letter code and have the right airport selected. The display is then set to code, city, country.)
View 7 RepliesI am new here so I will try and give you as much detail as I can:
(C# + SQL)
I am developing a web site that has holiday prices which are taken from a different database and loaded into two SQL databases.I have two girdviews to display each of the prices data.What my issues is that I need to load an SqlDataSource on database 1,when 'Family' is selected from a dropdown list and run an SqlDataSource on database 2 when 'Themed' is selected and then run both when 'Don't Mind' is selected.
how to get the number of rows from sqldatareader
View 2 RepliesI have a SQL Server 2008 database and I am working on it in the backend. I am working on asp.net/C#
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
//how do I read strings here????
}
I know that the reader has values. My SQL command is to select just 1 column from a table. The column contains strings ONLY. I want to read the strings (rows) in the reader one by one. How do I do this?
This my code SHoul the sqldatareader even be null when i debug (becuase response write not working)
[Code]....
hile i have been working with application perfomance tuning part i found an article for doing the same from Microsoft. it suggests me to reduce the round trip between application and database by using Sqlbatch statements. i got two ways to achieve it 1. SqlDataReader.NextResult() - we can use single connection to execute sql batch statements2. MARS (Multiple Active Result Sets) - we can use single connection to open multiple readers and execute the batch statements
View 2 Repliesi need to Get Two rows details in variables using SQLdatareader and using while loop in it.Can i do so,
my query and while loop are getting fired when i debug and see my while loop...but i dnt know how to get details and show or store it, when i will get 2 records on execution of query.
MY CODE IS BELOW...
[Code]....
When I query for only one record/row, sqldatareader is giving correct result but when i query for multiple rows, its giving error on the client side. below is my code.
[code]....
I am trying to run a stored proc from this function. When I run it thorugh the debugger I can see that myReader.HasRows = true and myReader.FieldCount =14.
But the control does not go in the loop while (myReader.Read()) where I am trying to read Version field returned by the stored proc.
[Code]....
i try to use userControl to display SqlDataReader data.
in the main page
public SqlDataReader Data2;
...
<uc1:WebUserControl ID="WebUserControl1" RData1="<%=Data2 %>" runat="server" />
and in the userControl
Repeater1.DataSource = RData1;
Repeater1.DataBind();........
But i keep getting this error
Cannot create an object of type 'System.Data.SqlClient.SqlDataReader' from its string representation '<%=Data2 %>' for the 'RData1' property.
I have a very strange issue, I'm using System.Data.SqlClient. to get data from a SQL Server though a stored procedure. When I test the Application at the Development and Stagging machines it works fine but when I deploy the application on the Production Server I randomly getting an SqlDataReader IndexOutOfRangeException with different column names!.The error appears in 2 requests in each 1000 request (approximative).
public static List<CountryInfo> GetAllCountries(){
List<CountryInfo> Items = new List<CountryInfo>();
try{
using (rdr = SqlHelper.ExecuteReader(Globals.ConnectionString, "unv_spGetAllCountries"))
[code]...