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


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

toggle column from row text box

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server
 

I have a tablix with a row group.  I enabled toggle visibility for a child row group.  So far so good.

My problem is, the child row group would ideally display 4 more columns when expanded.  I tried configuring column visibility based on the same toggle trigger but I get an error saying they it cannot be at the same scope.

Do any of you have a sample or blog post that would describe how to do this?  So when I click on expand row, not only I see the child rows but also columns get expanded (there will be more columns).  Now, when the row gets collapsed, those child rows will disappear as well as the extra columns.

Thanks!


Javier Guillen


View Complete Post


More Related Resource Links

Unique text value in databse column

  

Hi Everyone!

I know this is probably a very basic question but how do I keep a column's text values unique in SQL server (ie for a unique username)?  The column is not an integer it's varchar(50), and it's not the primary key but I could make it the primary key if recommended.

The front end could handle it;  where the user would enter text, it's validated, then a query is done to see if that username is available.  If so, then user can decide to choose it and an insert is done, if not they pick a new username and process repeats.  With this approach, the responsibility of keeping the value unique solely rests on the front end, nothing on the database side.

Is this the correct way to handle this? 

Thank you!

 


How to get character count in 'Multiple Text 'column using Calculated Column?

  

Hi All,

I have a multiple text box in a list

I want

  • A column which lists number of characters in multiple list column example 188, 199 etc
  • Multiple character column must not have more than 200 chars
Is this possible?

Appreciate all the help!

-saumil


How to read a column of a sharepoint list to a text string field of infopath form?

  
My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Most efficient way to check whether a DataGridView contains some specific text at a specific column

  
Dear All,   I am looking at the most efficient way to check whether a specific column of a DataGridView contains some text. For example I have a list of firs names and I would like to check whether the text "Bob" already exists in that columns. I would like to avoid to loop through each row but what thinking of using something with "Contains".   Anybody has an idea ?   Cheers,   Kalos

Adding starting text to a column field

  
I am wanting to know if there is a way you can add starting text within a field that displays within a page layout?  I have a page layout that has a field (column) called 'page summary'. What I want to do is when a content managers creates a new page based on that page layout, the text "This page contains a public notice" is automatically inserted in the page summary field and the content manager can continue typing or highlight the text and remove it. Kind of like adding a base 'Text Value' to the field (column).  I want to be able to do it without having to do custom code though.

How to tell repeater to wrap text after certain number of characters for a particular column ?

  
I have a column in my repeater which allows as many as 255 characters and causes the page contents pushed away to the right if any of the record has all 255 characters in that column. How can I tell it to wrap the text after 50 characters ?Thanks,

How to redirect bad date(xxx,9999) in datereceived column in text file in ssis

  
I want to redirect bad date format from flate file source to log table. I tried with redirect row but it is not working. Thanks in advance

Infopath 2007 Repeating Table - Multiple Value Column Text - Hiding Rows based on Column text values

  
Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

Infopath 2007 Repeating Table hide row based on Text values of column

  
Infopath 2007 browser based form Full Trust Example: I have a repeating table (FruitChoice) that has multiple columns. Both drop down list point to sharepoint list data sources. Choose your tree ft. drop down list – 6Ft Choose your Department drop down list - 103 This repeating table is conditional on the drop down values. This works great. Trees     Fruit       Cost   Date Ordered    Date Delivery Department 6Ft        Peaches                                                        103 3Ft        Apples                                                          102 3Ft        Peaches         &

Wrap text in Multiple Lines of text column

  
I had a List created from Calendar. I then took two copies of it to use for two slightly different purposes. I created a View on the list in both cases using the "Newsletter" style. On one of the list the Description column wraps text. In the other one it does not. Any idea what I could have done differently? Is there a checkbox in the View definition or the Column definition that toggles wrap text ?

Calculated Column: Text ==> Date and Time Column (Date+Time)

  

 

Hello,

 

I have a little question about calculated columns in WSS 3.0 (not MOSS 2007)

 

How can I have a calculated column which is a Date+Time based on a text_column

Converting YYYYMMDD_HHMM (time = 24 hour format) format  ==> Date+Time

 

Example:

20070629_0848 converting to 29/06/2007 08:48

 

==> I have already a formule, but with teh DATE(...) function, you cannot give the hour-minute-seconds as a parameter, so the time is always 00:00 in WSS 3.0 (and yes, i have selected date+time as result-type for the column)

 

Is this possible in WSS to calculate a full date out of a text, maybe if i use two seperate text-columns, and convert a to date and one to time and a third which combines the two...

 

It would be a huge help if somebody could give me som advice to calculate a full date+time out of one or more text-columns....

 

thx

Frederik

 


How to Compare Text Column with Today Calculation in view?

  

I  have 2 columns

Birth Date (DateTime), Birth-Month(Text- Calculated from Birth Date with MONTH([Birth Date]))

Now I want to know who's birthday in this running month?

So How can I implement filter or CAML Query for a view.

 


Regards, Kashyap Patel http://interview-question-aspnet.blogspot.com/

extracting last four characters of a text column and storing it in a number column

  

hi

is there a way to do the above, for example...I have a text column, Column A containing "172671-08-7892", I need 7892 to be extracted to another column of the type number, from there I need to divide by 2. If the remainder is 0, Column C will be updated as Female, if the remainde is 1, Column C will be updated as Male


Update Multiple Row in same column with different text

  

Hi all!

I am trying to explain with example what i want to do. I have a table that has names and surnames of people. Some of names are null in table and i know its number. I want to update null values but i want to give to every row different names not updating with single name.

ali yilmaz
NULL mert
NULL pol

Can i update these two records with names of 'ahmet' and 'yasir' within one single update statement

I hope i could explain my question. Any help would be so appreciated.

Thanks...


Ahmet UZUN

how to make text fit into column of a gridview

  

hi,

i'm bindng data to gridview using bound field.one column of gridview is linkbutton.if the text is more than the cell width then the gridview width is increasing automatically.for ex if i have text like "microsoft asp.net forums" then it's displaying the whole text.but i need that text like "microsoft.....".how to display like this in gridview?can any one help me?


Can a gridview contain an image and text in the same column?

  

I have a 1-column gridview (and it must remain 1-column) which contains only text.  My requirement is to prefix each row with an image followed by the text.  The image may or may not be indented a bit, like an expanded child node in a tree.

I know a gridview renders as a table and I know I could put an image at the beginning of each row in a table (using a repeater, for example).  But this is an existing app with a couple gridviews which need to be enhanced and I don't have the time to swap out the gridviews for repeaters.

I can't find any reference anywhere on the 'net which deals with this topic.  Anyone have any ideas?

Thanks in advance,

Brad

 - C# & .Net v4


Importing text file datetime string into SQL datetime column

  

Hi,

Using SSIS 2008 R2 to import text files.  Two of the fields contained are datetime values in the format "2010-09-24 18:58:29.220".  Ultimately both the date and time need to be extracted with precision to the second, at the very least.  When I import the text file, however, the time value seems to get truncated before the date value's being imported, for an imported result of "2010-09-24 00:00:00.000".

Is my problem with the Flat File Connection Manager?  Regardless of which DataType choice I use for the properties of my datetime values--I've tried every form of date datatype--the imported column values contain the correct date but the wrong time value.

Is there an easy way to import a text file datetime value straight into a datetime column?  Is it possible, or am I trying to shortcut what should be a proper process?

Thanks,
Eric


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