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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to make a connection between a word in the cell (href)? and a rule of the same or another table

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :ASP.Net
 HelloHow to make a connection between a word in the cell (href)? and a rule of the same or another table with sql. Is there also finished editors?

View Complete Post

More Related Resource Links

Unable to make connection to database?


Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents. 

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" 
              SelectCommand = "SELECT * FROM Resident "

Which connection owns global temporary table?

Global temporary table exists over time of connection in which was created. I have several connections (sessions) open in management studio. How to check using sql statement, system views, etc... if global temporary table was created in current session?

Gradient Colors in table cell

How to fill the gradient colors in table cells?

Repeating table not showing content following a rule refresh

Background info: I have a form where I populate employee info from the GetUserProfileByName ws. From there I populate its manager info from another web service call (seperate data connections).  Once the manager is populated, through rules, I'm populating the first approver. All this is done at form load through rules. The approvers node is defined as follows and is displayed on the form as a repeating table:  participants (group)    approver (repeating group)       ApproverName       ApproverLogin       ApproverEmail Problem: The repeating table is not showing any content even though I'm using an alert to show that I do in fact have one row in there. As a side note, I know the table is working because if the user elects to delegate approval to another user (through the people picker), the table shows these approvers correctly.  Anyone as any clue what I'm doing wrong? Thanks!    

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

How to update single cell of excel sheet using oledb connection,

 Friends i got some codes from net  by using that i can update a excel sheet ,but there we have to specify some header fields name in command string like as fallows ,Update [Sheet1$] set ProductName="IBG" where ProductId=5but i want to update a single cell of excel sheet only,let say O12 cell i want to change somedata,how it is possible that i don't know.plz help me out... thanks in advance...  

How to make a DataGridView Cell/Column not enterable / selecatble

Hi, I am trying to make a Column in a DataGridView non-entaerable (the user should not be able to set focus to the cell neither using the mouse nor the keyboard). I already tried to change the CurrentCell property in the CellStateChanged. But in this event-handler the CurrenCell is the "old" one; setting it to any value doesn't help, because the value is set after calling this procedure. In Delphi there is an event-handler for entering a cell, where you can tell whether the user is allowed to enter a cell. Is there anything comparable in C#? Any other suggestions?

Trying to include version history table inside Word document

Running MOSS 2007 with SP1, Office 2007.   I'm trying to create a table (doesn't have to be a table though) of a document's version history inside the document. This would be the history information kept by SharePoint. Since we can't even easily get just the current version number into the document I'm having problems and thought I'd see if anybody has a bright idea.   First, a couple facts. From Word 2007 it is possible to view the Document Library version information by clicking on the Office Button > Server > View Version History. This brings up the following: Click for screenshot   My goal is to get that version information displayed IN the document so when it is printed there is a document history. I tried using IRM label policies, but this only displays the current version and you can't include the comments.   After some digging I found the following code sample on MSDN:   Code SnippetDim dlvVersions As Office.DocumentLibraryVersions    Dim dlvVersion As Office.DocumentLibraryVersion    Dim strVersionInfo As String    Set dlvVersions = ActiveDocument.DocumentLibraryVersions    If dlvVersions.IsVersioningEnabled Then        strVersionInfo = "This document has " & dlvVersions.Count & " versions: " & vbCrLf        For Each dlvVersion In dlvVersions            strVersionInfo = strVersionInfo & _                " - Versi

How to make background-image of table or panel Rounded ?

Hi, I have taken background-image of a Table and Panel, that image's corner is rectangula. How can i make its corners Rounded ? I searched some online resources, images were made rounded, how to make make background-image rounded on the fly ? 

To Search a word in all the columns of a Single Table

Dear Friends, How can I search a word in all the columns of a table?Please advise.

WpfDataGrid make cell background fill entire cell

Hi!  I'm setting DataGridColumn.CellStyle to a background color and to a horizontal alignment. If I do not set the horizontal alignment the whole cell is filled with the background color but if i set the horizontal alignment the background color only is shown behind the text in the cell. I've seen some workarounds to this problem (http://stackoverflow.com/questions/1379902/setting-column-background-in-wpf-listview-gridview, setting the Margins on the DataGrid and the Cell margin) but it does not work for me. The background is still only shown behind the text   private void ApplyCellStyle(Style defaultColumnStyle, DataGridColumn dataGridColumn, Color backgroundColor, HorizontalAlignment horizontalAlignment) { var style = new Style(typeof(DataGridCell), defaultColumnStyle); var backgroundPropertySetter = new Setter { Property = Control.BackgroundProperty, Value = new SolidColorBrush(backgroundColor) }; var horizontalAlignmentPropertySetter = new Setter { Property = FrameworkElement.HorizontalAlignmentProperty, Value = horizontalAlignment }; style.Setters.Add(horizontalAlignmentPropertySetter); style.Setters.Add(backgroundPropertySetter); dataGridColumn.CellStyle = style; }   Does anyone know a solution to this problem?    Regards, Lina

Using SIP make a connection and call in Asterisk Server using c#

Hi all,

       I am new to Telecommunication but now my situation is want to use the SIP(Session Initiation Protocol) with Asterisk Server. So some one pls help me that is how i connect with Asterisk server and make a call using the SIP and c#.

Table formatting in word document using C#.net


I need to form my word document(#30 pages) like this using c#.net:
A   C
B   D
E   F
G   H
I   J
K   L

Here A,B,C,D...  are the text paragraphs and the page should split into two columns and if table comes it should come in one colume.
Please can one help me in this regard.

How to make data connection between DataFormWP and InfopathFormWP?



I want to send a row of data from the DataFormWP to the InfopathFormWP on the editifs.aspx page. First I customized the list to use the Infopath form for new, display and edit pages. Then I opened that pageI selected the source DataFormWP > Connections > Send row of data to > Infopath Form WP. Then I selected the source column and the destination column, then saved the page. When I made some changes on the DataFormWP, the changes were not sent to the Infopath Form WP. Could someone please let me know how to achive this? Both WPs are pointing to the same list.

I also have a related question. When I have these 2 WP on the editifs.aspx page, I have 2 sets of ribbon controls: one for the DataFormWP and one for the Infopath Form WP. I can turn off the Infopath Form WP ribbon from the WP Properties, but I can't turn off the DataFormWP ribbon. Can you tell me how to turn it off?



Exporting to Word with table of contents


I was looking for functionality in SSRS 2008 that allows the creation of a table of contents when exporting to Microsoft Word.

I have not been able to find any examples and thought maybe I would have to use a 3rd party component.  Has anyone had experience doing this in SSRS and if so could you provide an example.

Thank you,


How to grab ip address of remote connection to store in table


Hey guys move if in wrong area


I am trying to create a bit of a VPN program using sql server.

I have figured out how to have a form grab the users ip address and port from a tcp connection and store it into a table.

Now I want to integrate this directly into the sql server.

I know you can filter connections by IP using login triggers but is there a way to do the same when a command is issued to the database.

Make div fit width of table


I'm trying to build my first MVC2 application.  I'm returning data from the controller to the view and it is displayed in the "main" div of the masterpage.

<div id="main">
            <asp:ContentPlaceHolder ID="MainContent" runat="server" />

            <div id="footer">

The table runs past the edge of the white "main" div and onto the blue area.   Is there a way to style the "main" div so it expands it's width to always include the entire table?

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