C# - Retrieving Xml Value Into String
Dec 23, 2010
In the following XML structure how do i retrieve the name value and put this into a string? (i am using a XPathNavigator in my method)
<testsystem>
<test>
<name>one</name>
<name>two</name>
<name>three</name>
</test>
</testsystem>
The name will get displayed in the boundcolumn of a datagrid. I was able to get a attribute with a syntax alike this: (but when changing the xml struture it no longer holds a attribute value)
string name = nav.GetAttribute("name", "")
But have no luck getting the value with a nav as of yet. The purpose is to be able to use it for the following object so i can put name into it.
test t = new test() { Name = name, Questions= new List<Questions>() };
View 3 Replies
Similar Messages:
Dec 16, 2010
I am retrieving connection string based on value stored in cookie.NowI am making crystal report. I cannot hard code server credential. I have to get these credential from connection string from web.config. so that i can pass these credentials to my crystal report .
ConnectionInfo reportConnectionInfo = new ConnectionInfo();
reportConnectionInfo.ServerName = connection string server name from web.config
reportConnectionInfo.DatabaseName = connection string database name from web.config
reportConnectionInfo.UserID = ...;
reportConnectionInfo.Password = ...;
View 1 Replies
May 18, 2012
I am using query string under gridview, when i click link on gridview "
Datas are in table,
add_cat_name(field)
Educational aides-Glass Decorators (Display the value in search related page)
Colleges-Arts & Science Colleges UG/PG (does not display the value because (&)
My coding
<asp:GridView ID="GridView2" GridLines="none" runat="server" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href="search_related.aspx?id=<%# Eval("add_cat_name")%>">
[Code] .....
View 1 Replies
Feb 16, 2010
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
View 4 Replies
Jul 12, 2010
iam using an empty div in which i am assigning values through an external javascript via ajax call iam also using an fck editor what i want to do using an internal javascript i want to set the contents of that div in the textarea of fckeditor but in the internal javascript when iam accessing the contents of that div then it is showing "undefined"....
View 1 Replies
Oct 19, 2010
On my page, whenever a DetailsView is updated, I must audit the changes into a database. On most pages this works perfect, as there were just textboxes - however on a page I am working on right now, with dropdownlists, my code isn't working.
Basically, what the code does is captures the Updating event of the SqlDataSource, creates a datareader to look at the contents of the row before it's updated, compares the contents to the parameters in the Update query of the SqlDataSource, and if one has changed to log this in a field in the Audit table. An extract of my code is below:
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
try {
if (reader[i].ToString() != [code].....
When the control is on a dropdownlist, it seems to never go 'into' the IF even though the fields are different. Do I need to do something special to compare the values of dropdownlists? Note I believe the value is stored as an int in my table.
View 1 Replies
Jan 12, 2011
I want to retrieve a cell from the selected row in GridView. Please tell me how to do tanks in advance
View 2 Replies
Apr 4, 2010
i've two tables trans-mstr having columns as acc_no_from,date,particular,wd_dt,amt,balance and third_party_transfer(table2) having columns as acc_no_frm,acc_no_to,date,amt.now i wnt to retreive date ,particular,wd_dt,acc_no_to,amt,balance where the acc_no_from in third_party_transfer is equal to the no.entered in the textbox of the webpage.i've used datagrid view to show all this.i'm using c# n sql server2005 in this i'm a beginer
View 1 Replies
Feb 17, 2010
ERROR: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005
a. I had configured the DCOM on the server
b. If i run the APP on the server with any user: RUN!
c. If i run the APP using the Internet Explorer from any PC everything is fine until i try to call word
e. I have put all template (.dotx) on the server, on the PC and nothing WORD.
I am using office 2003.
View 2 Replies
Dec 28, 2010
the syntax for retrieving a value from a SqlDataSource? I've managed to get it working using numbers to represent the column, but I'd much rather use it's DB name?
[Code]....
View 2 Replies
Jul 14, 2010
//Controller code
CookieContainer cookieContainer = new CookieContainer();
//makes new cookie here
cookieContainer.Add(myCookie);
//Service/Facade code
//myCookie gets passed here
How do I pull the cookie out of the container to make sure it's the right cookie?
View 1 Replies
Jun 29, 2010
Hey there
I have in my database emails table
and i am retrieving all the mails from that table in a string to be included in
message.To.Add()
HOW can i put it in the right format ( separated by Comma and space ) while selecting them from the database?
thank you
View 3 Replies
Jan 28, 2011
in my db i have:
2011-01-28 12:03:46.223
when displaying on .aspx page,
<%# Eval("ModifiedDateTime") == null ? " " : Eval("ModifiedDateTime")%>
it displays on the grid like this:
12/2/2010 8:43:18 AM
how do I format it like the default format shown when I query my db?
View 1 Replies
Jan 16, 2011
I have the following select statement :
string Statement = "SELECT * FROM Car WHERE brand = Bmw;
how is it possble to display the result from the statement, because when i display the result exp: LblInfo.Text = Statement;
The result is : SELECT * FROM Car WHERE Brand = Bmw
View 5 Replies
Feb 25, 2011
I have a stored procedure with two input parameters which calculates the distance between two points. When I call it from aspx.cs I get an error.
Here is the code:
CreateDataSet();
float raz;
String str = "";
float min = 3.4F;
String clo = "";
[Code]....
and the error I get is:
Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Source Error:
[Code]....
When I test the procedure in SQL Server Management Studio everything is OK and I get a value 539.551855770807 for the certain input parameters.
View 2 Replies
Aug 20, 2010
I want to be able to take a select statement like: SELECT password FROM table WHERE user_name = @user_name and compare it with what was entered in a form text box. I have tried:
AccessDataSource1.SelectParameters("password").DefaultValue
= TextBox1.Text
AccessDataSource1.Select() (not sure how this works or what to set it equal to)
I also tried to connect to the database with a basic ADO connection that I got off another forum, with no luck
View 4 Replies
May 10, 2010
I am binding some data to control, but want to limit the number of character of a specific field to a 30 first characters. I want to do it, if it's possible, on aspx page.
I tried this:
Text='<%# String.Format("{0}", Eval("Title")).Substring(0,30) %> '
But got this error: Index and length must refer to a location within the string. Parameter name: length
View 3 Replies
Feb 13, 2011
I am trying to retrieve two listviews from an ascx control for the purpose of saving them to a PDF file:
<TagCloud:TagCloudControl ID="TagCloudControl1" runat="server" />
I get the following error: TagCloudControl1 is a field but is used like a type and an object reference is required for the non-static field, method or property..
ListView lv1 = (TagCloudControl1)ListView.FindControl("ListView1");
ListView lv2 = (TagCloudControl1)ListView.FindControl("ListView2");
lv1.RenderControl(htWriter);
lv2.RenderControl(htWriter);
View 2 Replies
Apr 3, 2011
just like in google, when you search for something. the websites are displayed without clicking submit button.
View 2 Replies
Sep 18, 2010
I have the following code in a stored procedure to retrieve all posts:
[Code]....
However, I am having trouble selecting posts by their tag..
View 9 Replies
May 31, 2010
i need to retrieve all the records present in a database
iam using the following code but it fails to show any record
Dim con As New System.Data.OleDb.OleDbConnection
Dim myPath As String
View 3 Replies
Aug 26, 2010
I am trying to call a Web service to retrieve some XML data from a database. The Ajax call works fine if I use a static file e.g. like this:
$.ajax({
type: "GET",
url: "test2.xml",
data: buildXMLDataRequestObject(),
dataType: "xml",
[Code]....
The GetXMLData method has been configured to return XML and the Ajax call has its datatype set as XML so I'm very confused as to what is causing the error.
EDIT: If I alter the $.ajax() call slightly so that the contentType is specified I get this error:
The data at the root level is invalid. Line 1, position 1.
I've tried contentType: "text/xml" and contentType: "application/xml" and both give the same error.
EDIT: Yesterday (Aug 30th) I noticed that the service call would succeed if I omitted the data parameter of the ajax call. I guess there is something about the JSON object that is causing a problem. For now I have implemented this functionality on the server side of the application but I do intend to revisit this when I get some time.
View 1 Replies
Jul 20, 2010
For all of my cases, I have binary data for pdf stored in my database. I have a stored proc that brings the binary for each case.How do I read this binary to store as pdf on a file server?How do merge these pdf files fo a set of cases and stored a merged file on the file server?
View 2 Replies
Dec 24, 2010
I m facing some problem. i m not passing Dynamic string through query string..
I m using this code
string abc = "CPCB_" + TextBox1.Text + "_" + TextBox2.Text;
Response.Write("<script>window.open('xml.aspx?Flag=3&date='+abc,target='new');</script>");
View 2 Replies
Feb 24, 2011
i facing a problem to change the date format at gridview display.
below is my coding:
[code]....
View 2 Replies