View Complete Post
<cname>United Arab Emirates Dirhams</cname>
public void Main()
String URLString = "http://www.xe.com/dfs/datafeed2.cgi?beeline";
XmlDocument doc = new XmlDocument();
XmlTextReader reader = new XmlTextReader(URLString);
XmlNodeList currencynodes = doc.SelectNodes("currency");
foreach(XmlNode currency in currencynodes)
XmlNode csymbol = currency.SelectSingleNode("csymbol&quo
I am using SSIS 2008, I set a varaible @t1 to data type CHAR and set the value to
Y next I used an Execute SQL Task with an ADO.NET connection to SQL 2008 R2 database to insert this the value of @t1 into a test table with only 1 column of data type NCHAR(1):
insert into test1
On the Parameter Mapping section of this task I put the Data Type as String and initially set the Parameter size to
The only problem is it tries to insert a 2 character numeric value into the SQL table. If I set the value of @t1 to N the parameter mapping seems to convert this to
78, when I set the value of @t1 to Y the parameter mapping converts this to
89 it looks like it converts the character to an ASCII code.
Is this meant to be the intended behaviour, as all I wanted to do was insert the actual character into the destination column and not the ASCII code?
I am using SSIS Import and export Wizar to load data from Excel file, I have set the datatype as "nvarchar(max); those data are not biger than 1000 bits but was failed to transfer as the error says:
[Source - TreatmentPlans$ ] Error: The "output column "SchoolPlan" (57)" failed because truncation occurred, and the truncation row disposition on "output column "SchoolPlan" (57)" specifies failure on truncation. A truncation error occurred on the specified
object of the specified component.
How to load data through list object (in.net)(Through list object the data is populating dynamically) using ssis....?
Can any one help me....ASAP...?
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.
Hi , I declared a user variable MINIODate as string in package level and assigned this variable in an execute sql task 2008 , where my source is ado.net and sql command is Select CSTR(MIN(IODate) ) as MINIODate from IOData ( This
is source table available in MSAccess DB) , The above senario working fine in 2005. During the run time in 2008 i am getting the following error
[Execute SQL Task] Error: An error occurred while assigning a value to variable "MINIODate": "The type of the value being assigned to variable "User::MINIODate" differs from the current variable type. Variables may not change type during execution. Variable
types are strict, except for variables of type Object.
i am migrating from oracle to sql i am getting data type format error while importing data from oracle to sql for date datatype in oracle. I was using SSIS with data conversion task.
IS there any method i can use to resolve the error with date format?
Thanks in advance
public DataSet ListofAccounts(string custidno)
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStrWestSideBank"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select * from AccountDetails where vCustIdentityNo ='" + custidno + "'", con);
DataSet ds = new DataSet();
ServiceReference1.ServiceClient svcobj = new
This is frustrating, and I don't know how to solve it.
I have a strange problem. I am adding a LinqDatasource object, and set the context:
protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
Then I get this error:The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:<add assembly="System.Data.Linq, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.
is there another way adding a refernce to a web project? or only though teh web.config?
I have a problem I can't figure out.
I've been trying to add a listbox with multi select enabled as a parameter to my select statement in sqldatasource.
So i created a function like this :
string strItemTypes = "";
foreach (ListItem li in lbItemType.Items)
strItemTypes += "," + li.Value;
strItemTypes = strItemTypes.Substring(1);
which gives me the selected items like this for example : "1,2,3"...Then I've been trying to add it to my sql select statement :
SELECT tblOfficesItems.idOfficesItems, tblStockItems.Name, tblStockItems.Description, tblStockItemTypes.TypeItem, tblStockItems.Notes FROM tblOfficesItems INNER JOIN tblStockItems ON tblOfficesItems.fkItem = tblStockItems.idItem INNER JOIN tblStockItemTypes ON tblStockItems.fkTypeItem = tblStockItemTypes.idTypeItem WHERE tblStockItems.fkTypeItem IN ( @fkTypeItems )
using a hiddenfield with a controlparameter of type=objectbut it just don't seem to work, seems like the data just won't bind or something and I don't get any errors so I'm confused!!
then i tried this :
SELECT tblOfficesItems.idOfficesItems, tblStockItems.Name
I am using fluent NHibernate with WebForms and I am trying to build a page where I allow a user to post a status update on their profile page and I a using a .asmx WebService to post the data to the database and then returnig a StatusUpdate instance to the page to be used by jQuery. I have a couple problems.
1) First off when I return a string from the WebService(i was testing) the textbox where the user enters their status doesnt empty the contents. And since the page doesnt refresh even if I manally clear out the textbox and put in something else, it still posts the previous status to the database again. How do I fix this?
2) Secondly, when I return the StatusUpdate Object from the Webservice I cant the results to display anything. Like I sad, Im using jQuery to make an AJX call to the WebService.
Here is my code:
User Profile Page:
Status: <asp:Label ID="status" runat="server"></asp:Label><span style="font-size:.7em;"><asp:Label ID="statustime" runat="server"></asp:Label></span><br />
<textarea id="statusBox" rows="3" cols="40"></textarea><br />
<input type="button" value="Update Status" onclick="SetStatus(); return false;