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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

joining

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :ASP.Net
 
i have assigned a task in which a folder in d drive contain 100 images i have to make a program which convert 100 images in to 50 images means two images are joined into one image ...please help me ho to do this in asp dot net


View Complete Post


More Related Resource Links

{ End Bracket }: Joining the Team

  

It's been more than a year since my words last floated across the pages of MSDN®Magazine. As readers of my blog probably know, my life's been interesting the past 12 months.

Matt Pietrek

MSDN Magazine January 2005


Joining complex SQL tables

  
Hi, I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at http://rapidshare.com/files/412281201/SQL_query.zip Or, from lsoon3@gmail.com Thanks for your guidance, below are the query:  1) MS Office Query: ================ select v_Add_Remove_Programs.DisplayName0 AS [MS Office Edition] from v_Add_Remove_Programs where DisplayName0 like 'Microsoft Office Project Professional%' OR DisplayName0 like 'Microsoft Office Visio Standard%' OR DisplayName0 like'Microsoft Office Visio Professional%' OR DisplayName0 like 'Microsoft Office Enterprise%'OR DisplayName0 like 'Microsoft Office Standard%' OR DisplayName0 like 'Microsoft Office Professional%' 2) Computer Details Query: ======================= select  distinct  v_R_System.ResourceID,  v_R_System.Netbios_Name0 AS [Computer Name],  v_R_System.Resource_Domain_OR_Workgr0 AS [Domain/Workgroup],  v_Site.SiteName as [SMS Site Name],  [Top Console User] = CASE  when (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 = '-1')  then 'Unknown'  Else v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0  End,  v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],  v_GS_OPERATING_SYSTEM.CSDVers

Joining tables from 2 SQL Server CE databases

  
Is it possible to join 2 or more tables in different SQL Server CE databases? I am currently using VB.NET 2008 and SQL Server CE 3.5.

joining two tables using dataservice

  
joining two tables using dataservice

Syntax for joining the results of two UDF

  
I have a table UDF similar to proj.MyFunction(2010).  I would like to join the results from the select of each of the functions.  I tried a syntax like below but it does not work.  What is the correct syntax? proj.MyFunction(2010) (select fn1.ProjectID from proj.MyFunction(2010)) fn1 inner join (select fn2.ProjectID from proj.MyFunction(2010)) fn2 on fn1.ProjectID = fn2.ProjectID   Thanks, LLoyd

ASP.NET insertion and joining data between tables

  
I have the following tables:1.) PRODUCT_INFORMATION2.) CUSTOMERS3.) DISTRIBUTORS4.) PRODUCT_NAME5.) CONTROLLEREach table has a primary key assigned. The customers table has an ID column and a CUSTOMER_NAME column with unique index property set to avoid any duplication. How do I insert values in the product_information table that has a foreign key column from the CUSTOMERS table if we insert a value in the CUSTOMER_NAME field of the CUSTOMERS table. I want to know how can I create a join between all the tables so that when I insert values in individual tables they are joined with a serial number column in the PRODUCT_INFORMATION  table?Please suggest!!

XSL Lookup to another List in a View. Joining in data from another List. xsl:value-of select=

  
I've been able to create a DataView with data joined from two SP Lists. I did this using SPD, a linked Source, and doing joined subviews.  The technique works nicely, but I have to create my DataView from scratch.As an alternative, I took an existing AllItems View in SPD, converted it to XSL, and was able to add a column from another List as follows:   <TD Class="{$IDA1VDGH}" style="width: 62px; height: 23px"><xsl:value-of select="/dsQueryResponse/Master/Rows/Row/@Lastname" />The problem is, it reports the column for the first row everytime. I'm new to XSL and was wondering..    using XSL, and preserving all the original columns already in the View, is there anyway to make the added column smarter, maybe with a filter?I noticed in my working example, I have this filter (I guess where the subview join magic is)            [@Title = $dvt_ParentRow/@Key] which does not resolve syntax:I tried this, but it does not work, only finding one match, and it also seems to get set for the entire Dataview and not just the column.     [../../../Master/Rows/Row/@Title = @Key] I guess I'm looking either for the SPD steps, or XSL code for adding a single column from another list, joined in by a column in both lists.Thanks for any help or information.

Joining two views

  
Hi,   Before I send any table structures and sample SELECTs might someone knows my case as a general issue?   I have a table with stock quotes ca. 1M rows & 300 different companies. Then I have two views. Fist selects latest stock quotes for some companies. The second selects stock quotes for 30 days ago for the same companies. Both views return 35 rows. And both run in ca. 200ms. Then I have joined both views in the third view and this operation takes 1 minute. Join column is a nvarchar(100), so I understand it is not a perfect solution. But joining 35 rows with 35 rows cannot take so long. This can take almost same time in my mind. Any ideas here?   Thanks, Przemo

Joining but only showing top entry for one join

  
  Lets say I have a join as follows: Select * from Table1 left outer join Table2 on Table1.ID = Table2.ID left outer join Table3 on Table1.ID = Table3.ID   Now, I want to be able to see every entry on Table1 and Table 2. However, I do not want Table3 to repeat its values. For example, I would like to see something like this:   Table1 ID Table2 ID Table3 ID 1 1 1 1   2 1   3 2 2 2 3 3 3 Is this possible?

Joining tables from diffrent sites

  
We would like to setup some Master Lists under the Home site such as "Customer Data", and "Employee Data" and then under our multiple Sub-Sites setup Lists that have columns joined back to those tables created on the home site.  I can Join Lists which are under the same Sub-Site however I am not able to join Lists which are under the Parent Site. Is there a way to do this?   Thanks

Joining Dimtime table by a referenced Join create a problem

  

Hello

I am trying to join a dimtime table by a refernced join to an orderlines table which is the fact.

(the referenced join was defined in the relationship matrix of the cube ).

The referenced table is the ordersheader which had no measures in it but only used a linking table between those two other.

The join from the dimtime to the ordersheader  is done by date and from ordersheader to orderlines by orderid

The problem is that in the cube browser measures are shown as they were multiplied across all dates (like the join was done in a wrong way )

I have created an sql query and the logic is working just fine when quering directly from the DB

 

What am I doing wrong


Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Joining with some format

  

Please help to get the required results after joining.
Table #volume_2 should take three number from starting and #volume's Vol column should repeat three times.

drop table #Volume
CREATE TABLE #Volume (cnt int, Vol int)
insert into #Volume values (1,1300)
insert into #Volume values (2,1000)
insert into #Volume values (3,1200)

CREATE TABLE #Volume_2 (num int)
insert into #Volume_2 values (2)
insert into #Volume_2 values (3)
insert into #Volume_2 values (4)
insert into #Volume_2 values (6)
insert into #Volume_2 values (7)
insert into #Volume_2 values (8)
insert into #Volume_2 values (10)
insert into #Volume_2 values (11)
insert into #Volume_2 values (12)

--Required output

num   Vol
---   ----
2    1300
3    1300
4    1300

6    1000
7    1000
8    1000

10    1200
11    1200
12    1200

 


Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Impersonation with domain account without joining the domain?

  

My feeling says it's not posible but anyway I am curious if there is at least a workaround for accomplish this.

Basically I am working at my client site and my machine is not connected to the domain.
What I want to do is running a web application locally under a domain account, and using the webdev server.
The webapp uses the default authentication, windows authentication that is.
I tried using impersonation with domain\user & password but I got the following error

Could not create Windows user token from the credentials specified in the config file. Error from the operating system 'Logon failure: unknown user name or bad password.

I have to mention that the username and the password are correct.

Thanks in advance
Iulian


Joining but only showing top entry for each join

  

I have a number of tables, whereby I want to join the tables to a parent table. My problem is that I wish to show every row of the table, but only show these rows once. This is hard to explain in text, so I have provided a example table below, which is the output I expect from the sql below. The #SI is the parent table.

(Note that I have only created the example with 4 tables. The actual number of tables will be more that this).

Output expected:

SI-1 SD1-1    
SI-2 SD2-1 RS2-1  
SI-2 SD2-2    
SI-3 SD3-1 RS3-1

Error When Joining Reporting Server to Farm: "Task configdb has failed with an unknown exception" an

  

This is apparently a very common error message, as I see numerous posts about it on these forums.  Unfortunately, none of the solutions have worked for me.  So I'm hoping somebody knows what is happening in my case.

CURRENT FARM (all in same domain):

Server Web3, Windows Server 2003 R2 (x86) <- WFE, WSS 3.0, SP2
Server Web4, Windows Server 2003 R2 (x86) <- WFE, WSS 3.0, SP2 (also Central Admin host)
Server SQL2, Windows Server 2003 R2 (x64) <- Database server for WSS installation (SQL 2008)
Server SQL5, Windows Server 2008 R2 (x64) <- New reporting server (SQL 2008), WSS 3.0 SP2 - unjoined from farm

- Reporting server database is configured in Sharepoint integrated mode.
- All WSS servers are at SP2.  I have double, triple, and quadruple checked this.  Build on all three servers is 12.0.6425.1000 (as retrieved from Add/Remove Programs and Programs and Features, respectively.)
- No additional hotfixes were applied after SP2.

When trying to join my new server (SQL5) to the existing farm using the configuration wizard, I get the following error...

10/11/2010 19:21:16  8  ERR                      Task configdb has failed with an unknown exception
10

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