Hi, in my VB.Net application I've created a Dataset that call an existing MS SQL Server stored procedure but after the wizard close no columns where added... how can I add all the columns returned by the stored procedure without adding them manually (off course the stored procedure might change in the future) in which case manually will...
I've tried this: http://be.php.net/manual/en/function.mysql-list-fields.php, but there's too much detail here. What I'm looking for is a function that returns an array of strings. This array should only contain the names of all columns that a certain table has. So for instance, if I have a table with these columns: username | email | ...
I want to read excel 2003( cannot change as its coming from third party) and group data in List or Dictionary (I don't which one is good) for example below (Excel formatting ) Books Data [first row and first column in excel] second row( no records) Code,Name,IBN [third row (second column, third column] Aust [fourth row, first colum...
i have same table at my local database and at my live-main database. I have to copy the content of a particular column from local to main not the whole table.How can i do that in mysql??? ...
Hello, I have a table with the following columns in table: id, t1, t2, t3, t4 All are of type bit (There are other columns as well, however I am only showing the relevant one) Now, I need to get the following string based on the ID: t1 t2 t3 t4 The best I thought of would be this: declare @t1 bit, @t2 bit... Select @t1 = t1, @t2 =...
I have db with column named "link" Links have redirect urls, which I want to change. I have php script, which would take the link and gives me out put as follows $redo = get_redirect('htp://www.mydomain.com/long/url/here&ID=123'); print_r($rez); this is the output: Array ( [0] => htp://www.otherdomain.com ) how do I loop all i...
Hi, I have a listview with checkbox property set to true, and I also allow column reordering. The problem is that when someone moves the first column to some other position, the checkboxes remain in that column and move with it to the new position - so eg. they can be in the middle of the listview. I would like to have the checkboxes A...
This is the data currently located in one column: "Title Info - Company Here - City Here, ST" ST represents state ie GA Sometimes my data looks like this: "Title Info - Company Here - United States" Data is on column named "title" and is without quotes. How do I split this using php, for 4 new columns named: "New_Title", "Compan...
I'm trying to add borders to the middle column in a three column row. This: var subcount = $j('#sub > div').size(); Gives me 6, and I'm trying to figure out how to apply a style to the divs in the middle? (in this case, div 2 and div 5) <div id="sub"> <div>div 1</div> <div>div 2</div> <div>div3</div> <div>div 4</div> <div>div 5</div...
Im trying to put in two sign up forms on a single page, but to effectively do this id like to split the center div into two seperate columns to achieve this. Ive poasted the code below: <div id="content"> <!-- Left Content Start --> <div class="instruct" id="instruct-div"> <div class="contentcol"> ...
Hi guys, I would like to know how to change the edit column position after setting AutoGenerateEditButton="true". By default it is displayed always on the left as the 1st column. TIA ...
I have a JTable with several columns and rows. Once the user has moved the column, I would like to be informed via an event of some sort, so that I can do some calculations. However, since all I needed to do was `table.getTableHeader().setReorderingAllowed(true);` to get the columns to be movable, I am somewhat unsure what I can use ...
I'm trying to optimize my mysql tables (MyISAM) and I changed some column types with phpmyadmin, mostly from int to smallint, medium int, etc. After I did that mysql really bogged down and the server load went really high. I did this on a live site, which I figured was the problem, but even after putting the site into maintenance mode an...
Currently I use a custom sorter on the listview, and i can sort the listview each time i click on the FIRST column, but it won't sort by other columns. SortStyle: Variable to determine whether it is Ascending Sort, or Descending. if (e.Column == 0) { if (SortStyle == 0) { List.ListViewItemSorter = customSortDsc; ...
How do I reorder the column headers in code AS IF I have clicked and dragged them around? When AllowColumnReorder is true on a ListView you can drag around the columns, and the display index is changed. When you add new items to the listview, you don't have to worry about how the columns were rearranged, it lines up the incoming data wi...
Hi there, I am asking this question here as I could not find any conclusive results thru Google. HOw would it be possible to include an image and text in the same column in a Winforms datagridview? I have the following code handling the CellPainting event, but it does not work too well if the user adjusts the height of the row. priva...
I have added a column called Customer to my documents library, this is a business data column. What I want to do is relate a document to multiple customers by entering customer codes into this box. Currently I can add 'FLC' for example, but I want to put 'FLC, MFT, SAL' for a specified document as it relates to many customers. Any id...
Hi, My requirement is to display a Column in select query when a condition satisfies and not to display the column when condition is not matched. For eg : In this simple table below Table : XYZ Name ID Fairness harish 3 White ravi 5 brown arun 2 black rahul 5 white Query: select name,case id when 5 then " I Like to learn more...
What I wanna create is page that fetches results from my DB and display them into two columns like this using CSS (unless theres a better way)... Row 1 | Row 6 Row 2 | Row 7 Row 3 | Row 8 Row 4 | Row 9 Row 5 | Row 10 The second column should be empty if theres no more than 5 rows. ...
So I'm creating columns dynamically for a Grid layout in Silverlight (V3.0, C#): LayoutRoot.ColumnDefinitions.Add(new ColumnDefinition()); and you can specific that the width of the column be "auto" with LayoutRoot.ColumnDefinitions.Add(new ColumnDefinition() { Width = GridLength.Auto }); But how to you set it to be "*" (share with...