on 03-24-2009 3:17 PM
Has anyone successfully written a Web service in .Net C# that Xcelsius can use? I was just trying to create something simple and it will not work. I get data in my Xcelsius report, but it is all lumped into one 'cell' and the XML tags are still in there. If anyone has some sample code that does work it would be much appreciated.
Here is what I have:
public string getTableInfo()
{
SqlDataAdapter dbadapter = null;
DataSet returnDS = new DataSet();
using (SqlConnection dbconn = new SqlConnection(
"Server=SERVER;"
+ "Database=DB_NAME;"
+ "User ID=ACCOUNT;"
+ "Password=PW123;"
+ "Trusted_Connection=False;"))
{
SqlCommand cmd = new SqlCommand();
string sqlQuery = "select FIELD1, FIELD2 from TABLE";
cmd.CommandText = sqlQuery;
cmd.Connection = dbconn;
dbadapter = new SqlDataAdapter(cmd);
dbadapter.Fill(returnDS);
}
return returnDS.GetXml();
}
thanks!!!
Hi Jeremy
Not sure if this will help but have you looked at getting an XML map to consume your data in Excel?
Regards
Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.