.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

why would some one pick a variable contain XML values instead of CSV values?

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
 
hi friends, in one of my previouse post i have asked how to save I;M relationships to tables, the i have received two answers: for the many part of I : M relationship: 1. create a varaible of type varchar() that will holds values has csv 2. create an xml varaible   why would some one choose XML type instead of CSV? thanks


View Complete Post


More Related Resource Links

How to store and retrieve multiple values in a single session variable .

  

I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.


Get Values into a variable

  
Hello, If using crystal reports i am trying to pass the 'Selected Values' to one of my variables but i am not quite sure how to achieve this so far i was able to map the following DECLARE @SA BIGINT, @EA BIGINT, @SB BIGINT, @EB BIGINT   SET  @SA = {?StartA} SET @EA = {?EndA} SET @SB = {?StartB} SET @EB = {?EndB}   but i want to be able to add another variable that will accept multiple values from the report like account all as int 1111 2222 3333 i want to evaluate those values as the following SET @ALLAccounts = {?Accounts}   and then in my queries do something like Select * from Blah where AccountB in (?Accounts)  but this of course wont work can anyone please help me?   Regards

Comparing Null Values(from variable) in SSIS

  
Hi All I need to create a script that checks to see if a variable value is NULL, if it is then it executes the next SQL Task and if not then the package has finished. I have this in a SQL 2000 DTS package script: Function Main() If isnull(DTSGlobalVariables("NextLoadDate")) Then Main = DTSStepScriptResult_DontExecuteTask Else Main = DTSStepScriptResult_ExecuteTask End if End Function As you can see, all I want to do is check to see if a variable is null then don't execute the next task. But i cannot get it to work in a SQL 2005 SSIS package, so far I have created a script and come up with the following: Public Sub Main() If Dts.Variables("NextLoadDate").Value.ToString <> "" Then Dts.TaskResult = Dts.Results.Success Else Dts.TaskResult = Dts.Results.Failure End If End Sub Any Ideas? Thanks BigGopher

How do I get column values in Sharepoint designer so I can use them as a variable in code block?

  
The code below is in my EditForm.aspx and it works but instead of it outputting "This is just a test!" I need get a number that is stored in a column named Phone Number that has 5555555555 stored in it and have the line that says TD2.innerHTML = "This is just a test!"; ouput what ever number is stored in the Phone Number column. Here is the code that is in my EditForm.aspx <script type="text/javascript">function DisplayItemID(){       var TD1 = document.createElement("TD");       TD1.className = "ms-formlabel";       TD1.innerHTML = "<h3 class='ms-standardheader'>Test</h3>";       var TD2 = document.createElement("TD");       TD2.className = "ms-formbody";       TD2.innerHTML = "This is just a test!";       var IdRow = document.createElement("TR");       IdRow.appendChild(TD1);       IdRow.appendChild(TD2);       var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0]; 

Multiple Values to the Variable, HOW?

  
Hi All, I'm trying below query which is working fine:- DECLARE @FULLNAME VARCHAR SET @FULLNAME = 'PQR, ABC L.' SELECT ID FROM TABLE-NAME WHERE LAST_NAME = SUBSTRING(@FULLNAME, 1, PATINDEX('%,%', @FULLNAME) -1) AND FIRST_NAME = LTRIM(RTRIM(SUBSTRING(@FULLNAME, PATINDEX('%,%', @FULLNAME)+1 , PATINDEX('% %', @FULLNAME)))) But when I include two values to the same variable something like this:- DECLARE @FULLNAME VARCHAR SET @FULLNAME = 'PQR, ABC L.', 'LMN, XYZ' SELECT ID FROM TABLE-NAME WHERE LAST_NAME IN SUBSTRING(@FULLNAME, 1, PATINDEX('%,%', @FULLNAME) -1) AND FIRST_NAME IN LTRIM(RTRIM(SUBSTRING(@FULLNAME, PATINDEX('%,%', @FULLNAME)+1 , PATINDEX('% %', @FULLNAME)))) It is giving me error as:- "Incorrect syntax near 'SUBSTRING'." This is because my @FULLNAME will be an SSRS report parameter and which is going to be multi-value parameter. Any Help Please? Thanks Regards, Kumar

how to store the values in a object variable (package level scope) in a script component

  
I have declared a variable of object type with package level scope.  I want to assign values to this variable inside a script component.  My object should hold 5 columns in a row.  How to implement this ?

How do i watch variable values during debugging ?

  
Is there a way i can see the value of the variables during debugging ?

Get the values of session variable 'x' through javascript?

  

I need to query for a session variable called 'steps' every 10 seconds from my Webform in ASP.Net using javascript. This session variable holds an integer value.




How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

jquery autocomplete multiple values

  

i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?

 


JQGrid Loading deleted values

  

Hi,

This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.


Here is the code:


function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

How to cast integer values as an array of enum values?

  

Hello all!

I'm working with VS2010 Beta2, ASP.NET and Dynamic Data. I'm using VB but will certainly be happy to receive a C# example if necessary. Laughing

I used a few of Steve's examples (Writing Attributes and Extension Methods for Dynamic Data and Dynamic Data - Hiding Columns in selected PageTemplates) to create a custom property attribute to be applied to a dynamic data column and want it to accept an array of enum values (each value will represent a dynamic data page template where this column should not be displayed).  My new attribute works fine when I hardcode it like this, meaning the HideColumnIn attribute is properly populated with the array of enum values:

<HideColumnIn(PageTemplate.List, PageTemplate.Edit)> _
Public Property My_DD_Column As Object

 

However, I want to store the values to be used for the HideColumnIn in the DB as integer values that correspond to the

Passing values in pages

  

Hi! Friends..

how to pass the value from one page to another page in asp.net  with out Using State Management Concepts?

Like 1. cookies

        2.Session

        3. QueryStrings

     With out using the above should pass the values...


how to bind Dropdownlist based on textbox values

  

hi

I have one drodownlist which show data based om textbox values...

Let us consider i have 

Select Name from table1 where Type IN(@typ)

here @typ is textbox values

here for example textbox will have some thing like this L1,L2,L3..

How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..

Help me in this


Unable to get all the values from a field

  

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

0,rank,0
1,internalid,0
2,contentid,0
3,contentids,0
4,collection,0 

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="rank">1</FIELD> 
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD> 
<FIELD NAME="contentid">234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD</FIELD> 
<FIELD NAME="contentids" /> 
<FIELD NAME="collection&

Retreiving XML tag values

  

Hi,


I'm new to xml.


Currently I'm using the SOAP service and MSXML2.ServerXMLHTTP40  to get data from a website.

To retrieve data I'm using the "responseText" method of the MSXML2.ServerXMLHTTP40 class.


My XML tree looks like this. ( part of the tree)


<dataID>0</dataID>
<projectName>100208_FC3_BY_RO_rza</projectName>
<chunkSize>0</chunkSize>
<minLat>47.8512912</minLat>
<maxLat>48.2469535</maxLat>
<minLong>11.6839167</minLong>
<maxLong>12.4439732</maxLong>
<minTimestamp>2010-02-03T10:58:29</minTimestamp>
<maxTimestamp>2010-04-09T10:05:22</maxTimestamp>
<imageCount>154282</imageCount>
<audioCount>0</audioCount>
<gpsCount>84475</gpsCount>
<mcvCount>2475</mcvCount>
<fileCount>87</fileCount>
</JobInfo>


Just need to retrieve the value of the "projectName" & "dataID" from this.

Appreciate if somebody can help me to get the values of the above 2 fields with the relevant code.


Thanking you in advance.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend