View Complete Post
Am reading an XML from web service and storing in a dataset.
then in write to a DataTable as follows
DataTable dtResult1 = dsSearch.Tables["RESULTSET"];
DataTable dtHIT = dsSearch.Tables["HIT"];
DataTable dtField = dsSearch.Tables["FIELD"];
The issue is in the DataTable dtField i can only see 3 columns FieldID,Name,HIT_ID
The corresponding values in the dataTable looks like this for the corresponding fileds
I am unable to get the Field Name values 1,8799f4646b6ed9acde142581a84f75a6 ,234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD,Yes...etc
What would be the cause for this...Any Help
Below is the structure of the XML-
- <RESULTSET FIRSTHIT="1" LASTHIT="10" HITS="10" TOTALHITS="46" MAXRANK="3159" TIME="0.0040">
- <HIT NO="1" RANK="2955" SITEID="0" MOREHITS="0" FCOCOUNT="0">
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD>
<FIELD NAME="contentids" />
I want to know if there is an easy way to the pre-populate field values to ListB from ListA.
In ListA I have ColumnA, ColumnB and ColumnC. In ListB, I have Column1, Column2 and Column3.
When I add a new item in ListB, Column1 is a lookup field tied to ColumnA. So, if I select a value from the lookup list, I want it to automatically populate ColumnB value to Column2 and ColumnC value to Column3. Can this be done without programming?
--Loading the single row returned by a table valued function into a temp table works fine like this:
DECLARE @techNumLoop VARCHAR(25)
DECLARE @myTemp TABLE (
--,[...20 more fields]
--Loop a while
INSERT @myTemp SELECT * FROM ufn_FindSomeRow(@techNumLoop)
--And finally display a table with one row for each function call
SELECT * FROM @myTemp
--My Question: what if I would like to also display the value of @techNumLoop passed in to ufn_FindSomeRow?
--Then I add a field to @myTemp to hold it:
DECLARE @myTemp TABLE (
the sharepoint number field in list comes with 2 decimal places in dispform, like
when I enter number like 12 on new form, when I open the dispform, it shows 12.00
I tried to keep the decimal places to 0 but it didn't work.
Do you guys know anything about this one. I don't want to make it a single line of text.
I would like to create a parameter that has as value, the combination of 2 fields of my dataset.
Say like Name and FirstName combined as EmployeeName
There is no chance I can update/change the procedure that delivers these fields.
I tried looking into the code, but didn't have a lot of success.
Anyone some ideas?